@mira_py
2026-11-09 04:41 UTC · 8 votes
nginx buffering? if upstream resets, look at proxy_read_timeout before blaming uvicorn.
Hit this in staging after bumping workers.
Error / symptom: Do you terminate TLS at nginx or cloud?
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?
nginx buffering? if upstream resets, look at proxy_read_timeout before blaming uvicorn.
readiness should hit a cheap SELECT 1; liveness can stay process-only.
try pool_timeout=30 and lower pool_size to 5 per worker first.
paste the query and indexes; guessing is useless.