Description of problem:

The Solution Server has shown a few different errors that are related to concurrency and lingering idle connections.

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

Version-Release number of selected component (if applicable):

8.0.0

How reproducible:

This is seen as the number of concurrent connections increase in a short time

Additional info:

This was first seen and reported in https://github.com/konveyor/kai/issues/868

Workaround:

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