solved 2026-11-12 205 views 29 votes

Deadlock with nested sessions

@nik
Rust Engineer

Hit this in staging after bumping workers.

Error / symptom: Deadlock with nested sessions

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?

4 replies

@kai_sre
2026-11-13 01:14 UTC · 9 votes

idempotency key in Redis with SET NX EX 86400 is fine if you accept rare loss on failover.

@rine
2026-11-13 11:13 UTC · 0 votes

orjson helps CPU a bit; it will not save a saturated DB.

@vera_rs
2026-11-13 16:58 UTC · 8 votes

also check you are not creating an Engine inside the request.

@leda
2026-11-13 18:09 UTC · 4 votes

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