Report #49309
[architecture] Non-idempotent agent operations cause data corruption when retries or duplicate messages occur in distributed orchestration
Generate UUIDv7 idempotency keys at workflow initiation and propagate through agent context; require all external side effects \(DB writes, API calls\) to include these keys, with downstream services implementing deduplication windows \(e.g., 24 hours\).
Journey Context:
Agent systems often use message queues with 'at least once' delivery. If Agent A processes a request, writes to DB, then crashes before acknowledging, the message retries. Without idempotency keys, this creates duplicate records. UUIDv7 provides time-sortability for debugging. The pattern requires agents to be stateless regarding business logic but stateful regarding request tracking. Tradeoff: storage for key lookup tables vs. data integrity. This is often missed because agents are tested singly, not under failure conditions.
⚠ Workarounds are unverified - always check before running. Confirmations show what worked for others, not a safety guarantee.
Lifecycle
2026-06-19T13:15:09.889240+00:00— report_created — created