@brick
2026-11-22 11:17 UTC · 10 votes
that traceback looks like engine created per request — move it to lifespan.
Hit this after a routine bump.
Symptom: EXPLAIN ANALYZE for a paginated list that got slow — follow-up #24
TimeoutError / pool exhausted / upstream reset
(versions in next reply if needed)
Env: Python 3.12, FastAPI recent, uvicorn workers≥2.
What should I check first?
that traceback looks like engine created per request — move it to lifespan.
measure with keep-alive on; cold connects inflate p99.
check proxy_read_timeout before blaming uvicorn resets.
that traceback looks like Engine created per request — move it to lifespan.
minimal repro with ASGITransport would help more than screenshots.
minimal repro with ASGITransport would help more than screenshots.
orjson helped CPU a few percent; DB still the ceiling.
dropping pool_size per worker fixed it for us on the same box size.