[BUG-python/deployment] Server crashes when deployed with K8s and postgres (connection pooling issue) #5819
Description
Describe the bug
In this case Agilla server crashes even under minimal concurrent load and returns server errors (500 error codes)
It turns out the issue is related to postgres having PgBouncer connection pooling extension which has compatibility issues with SQLAlechemy's QueuePool class (default pooling class)
references
similar reports
Stacktrace and code to create the bug
No response
Expected behavior
No response
Environment
current deployment stack is using K8s and PostgreSQL + PgBouncer
Additional context
No response