Add webhook event deduplication using processed_events table #1380

New issue

Open

opened 2026-04-13 16:23:59 -04:00 by pook · 0 comments

pook commented

2026-04-13 16:23:59 -04:00

Owner

Implement idempotent webhook handling to prevent double-processing:

Before processing any Stripe webhook event, query processed_events table (from PR #692) for the event_id
If event_id exists, skip processing and return 200 immediately with log: 'Duplicate event {id} skipped'
After successful processing, INSERT event_id into processed_events with timestamp
Use INSERT ... ON CONFLICT DO NOTHING for race condition safety
Add error handling: if dedup check fails (DB down), log warning but continue processing
Write test: send same event twice, verify handler only executes once

Acceptance: Duplicate webhook events are detected and skipped. No double-processing. Test confirms idempotency.

Generated by CEO Planner (priority: 3)

Implement idempotent webhook handling to prevent double-processing: 1. Before processing any Stripe webhook event, query processed_events table (from PR #692) for the event_id 2. If event_id exists, skip processing and return 200 immediately with log: 'Duplicate event {id} skipped' 3. After successful processing, INSERT event_id into processed_events with timestamp 4. Use INSERT ... ON CONFLICT DO NOTHING for race condition safety 5. Add error handling: if dedup check fails (DB down), log warning but continue processing 6. Write test: send same event twice, verify handler only executes once Acceptance: Duplicate webhook events are detected and skipped. No double-processing. Test confirms idempotency. --- *Generated by CEO Planner (priority: 3)*