Uploaded image for project: 'Ansible Automation Platform RFEs'
  1. Ansible Automation Platform RFEs
  2. AAPRFE-2471

[RFE] Persistent migration state to prevent repeated DB checks by MigrationRanCheckMiddleware on each API call in AAP.

XMLWordPrintable

    • False
    • Hide

      None

      Show
      None
    • False

      1. What is the nature and description of the request?
        The awx.main.middleware.MigrationRanCheckMiddleware process currently verifies database migrations on every API request. This causes unnecessary database overhead, increasing CPU utilization and latency on the Automation Controller and PostgreSQL database. The request is to modify this behavior so that the migration check is performed only when migrations are pending or actively running, rather than on every API invocation.
      2. Why does the customer need this? (List the business requirements here)
        • Reduce unnecessary DB load and CPU utilization during normal operations.
        • Improve API response time and scalability for large environments.
        • Ensure resource efficiency for Automation Controller and DB nodes.
        • Maintain stability during high-volume API or job traffic.
      3. How would you like to achieve this? (List the functional requirements here)
        Implement a persistent “migrations complete” state flag stored in cache or application memory.
      4. List any affected known dependencies: Doc, UI etc..
        • Backend: Django middleware MigrationRanCheckMiddleware
        • Database: PostgreSQL (migration table queries)
      5. Github Link if any

              Unassigned Unassigned
              rhn-support-johenson Joshua Henson
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: