solved 2026-10-18 978 views 9 votes

Connection leak when TestClient exits dirty

@skye
Junior Python Dev

Hit this in staging after bumping workers.

Error / symptom: Connection leak when TestClient exits dirty

Traceback (most recent call last):
  File "app/main.py", line 42, in endpoint
    await db.execute(stmt)
TimeoutError: connection pool exhausted

Env: Python 3.12, FastAPI 0.115, uvicorn workers=4, Postgres 16.
What am I missing in pool settings?

3 replies

@leda
2026-10-19 07:44 UTC · 1 votes

I saw the same when each worker opened its own pool of 20. Math: 4*20 = 80 against a 50 max_connections box.

@leo_cache
2026-10-19 11:28 UTC · 11 votes

try pool_timeout=30 and lower pool_size to 5 per worker first.

@tomo
2026-10-19 18:27 UTC · 4 votes

thanks — dropping pool_size fixed p99. marking notes in the thread.