solved 2026-11-15 400 views 42 votes

Redis SETNX for idempotency keys

@amira
Tech Lead

Hit this in staging after bumping workers.

Error / symptom: Redis SETNX for idempotency keys

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?

2 replies

@piotr
2026-11-15 21:11 UTC · 8 votes

nginx buffering? if upstream resets, look at proxy_read_timeout before blaming uvicorn.

@cole
2026-11-16 00:03 UTC · 7 votes

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