Add PostgreSQL connection retry with exponential backoff at server startup #684

New issue

Open

opened 2026-04-11 12:16:30 -04:00 by pook · 0 comments

pook commented

2026-04-11 12:16:30 -04:00

Owner

Container deployments may start before PostgreSQL is ready. Need retry logic to prevent crash-looping on DB connection failure during startup.

Implementation:

In the database connection module, wrap initial connection in a retry loop:
- Max 5 attempts with exponential backoff (1s, 2s, 4s, 8s, 16s)
- Log each retry attempt with attempt number
- On final failure, log error and exit with code 1
Use existing database client — no new dependencies.
Add test verifying retry behavior with mock client that fails N times then succeeds.

Acceptance: Server retries DB connection on startup failure. Test passes. No new dependencies.

Generated by CEO Planner (priority: 3)

Container deployments may start before PostgreSQL is ready. Need retry logic to prevent crash-looping on DB connection failure during startup. Implementation: 1. In the database connection module, wrap initial connection in a retry loop: - Max 5 attempts with exponential backoff (1s, 2s, 4s, 8s, 16s) - Log each retry attempt with attempt number - On final failure, log error and exit with code 1 2. Use existing database client — no new dependencies. 3. Add test verifying retry behavior with mock client that fails N times then succeeds. Acceptance: Server retries DB connection on startup failure. Test passes. No new dependencies. --- *Generated by CEO Planner (priority: 3)*