Uploaded image for project: 'Migration Toolkit for Applications'
  1. Migration Toolkit for Applications
  2. MTA-6205

Document known issue and workaround for: Solution Server needs to improve handling of idle connections

XMLWordPrintable

    • Icon: Task Task
    • Resolution: Duplicate
    • Icon: Undefined Undefined
    • MTA 8.0.0
    • MTA 8.0.0
    • None
    • Quality / Stability / Reliability
    • False
    • Hide

      None

      Show
      None
    • False
    • Yes
    • None

      In MTA 8.0.0 we need to add release note that after deploying the solution server, the following command must be run to allow the db to expire lingering idle connections:

      oc -n <mta namespace> exec deploy/kai-db – psql -U postgres -d postgres -c "ALTER ROLE kai SET idle_session_timeout = '1min'; ALTER ROLE kai SET idle_in_transaction_session_timeout = '1min';"

      Example of an error:

      asyncpg.exceptions.TooManyConnectionsError: sorry, too many clients already
      [09/29/25 09:39:25] ERROR    Error calling tool 'create_incident': sorry, too many clients already                                                                                   tool_manager.py:140

       

       

       

      Upstream issue: 

      https://github.com/konveyor/operator/issues/479

       

              Unassigned Unassigned
              jmatthews John Matthews
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: