CoS tip: recover stale durable event sequence (#51413)

[kvnloo]

Origin

anomalyco#51413

Intent

Repair a stale EventSequenceTable seq (lagging behind EventTable) before the next durable publish so (aggregate_id, seq) inserts do not unique-violate.

Proof (fail → pass)

cd packages/core
bun test test/event.test.ts -t "repairs a stale durable sequence"
# NEGATIVE (tip test on base product): 0 pass / 1 fail
# GREEN (full tip): 1 pass
# restore (product reverted): 0 pass / 1 fail

Notes

• Base: dev
• github_writes_origin=0 (fork-only)
• Codex promote: parked