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

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

XMLWordPrintable

    • Icon: Task Task
    • Resolution: Done
    • Icon: Normal Normal
    • MTA 8.0.0
    • None
    • Documentation
    • None
    • Quality / Stability / Reliability
    • 1
    • False
    • Hide

      None

      Show
      None
    • False
    • None

      In MTA 8.0.0 we need to add a release note that concurrent usage of the Solution Server may lead to idle connections not being freed. 

      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

       

      Manual Workaround to set an idle connection timeout:

      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';"

       

       

              mpershin@redhat.com Mariya Pershina
              istein@redhat.com Ilanit Stein
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: