-
Task
-
Resolution: Duplicate
-
Undefined
-
MTA 8.0.0
-
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