#817 DB failover breaks durability: duplicate side effects (exactly-once) + run failures under postgres restart (#agentic)

closed high agentic Created 2026-07-09 01:40 · Updated 2026-07-10 00:38

Description

Edit
Chaos harness with --db-restarts 3 (postgres restarts mid-flight) on 20 canary runs: 3 runs FAILED and 26 DUPLICATE transactional side-effect markers (tasks whose commit was in-doubt when the connection dropped were re-executed -> double insert). No state corruption. Two gaps: (1) a task re-run after a commit-in-doubt (connection lost during/after COMMIT) does not dedup on the already-committed checkpoint -> duplicate side effect; (2) some DB-connection errors fail the run instead of being retried durably. Worker-crash chaos (no DB faults) passes cleanly; this is specific to DB connection loss. Found by tests/chaos --db-restarts.

Comments

Loading comments...

Context

Loading context...

Audit History

View All
Loading audit history...