A v2.4.1 deploy to checkout-api introduced an N+1 query pattern that exhausted the database connection pool 22 minutes later, spiking checkout errors from under 1% to 40%.
Steps to test
- Open INC0000001.
- Steps 4–7: db_connection_wait_ms ramps from 2ms to 890ms; a trace on POST /checkout shows "connection pool exhausted, waited 890ms".
- Step 8: the v2.4.1 deploy, 22 minutes earlier, is the single change candidate.
- Steps 10–11: top hypothesis at 0.88 confidence (change-sourced).
- Step 12: already approved.
- Steps 13–14: rollback and pool increase executed live, verification RESOLVED.
Outcome: resolved and verified — the full happy path, all 15 steps.