Added runbook docs/runbooks/indexer-reorg-replay-dedup.md: dedup via (tx_hash, pair_id) / ON CONFLICT DO NOTHING, safe replay for swaps, manual reorg recovery (stop indexer, restore DB or trim state, reset last_indexed_height / START_BLOCK), backfill cautions. Links SECURITY_REVIEW IX-03 and indexer/src/db/queries/state.rs.

@brouie please review.

## Epic #62 delivery Added runbook `docs/runbooks/indexer-reorg-replay-dedup.md`: dedup via `(tx_hash, pair_id)` / `ON CONFLICT DO NOTHING`, safe replay for swaps, **manual** reorg recovery (stop indexer, restore DB or trim state, reset `last_indexed_height` / `START_BLOCK`), backfill cautions. Links SECURITY_REVIEW IX-03 and `indexer/src/db/queries/state.rs`. @brouie please review.

PlasticDigits commented

2026-04-13 12:29:19 +00:00

(Migrated from gitlab.com)

mentioned in issue #62

Brouie commented

2026-04-20 07:00:02 +00:00

(Migrated from gitlab.com)

@PlasticDigits Verified on current main. docs/runbooks/indexer-reorg-replay-dedup.md present (32 lines). Content covers:

Cursor model (last_indexed_height in Postgres, state.rs reference)
Swap dedup via (tx_hash, pair_id) unique constraint with ON CONFLICT DO NOTHING (insert_swap)
Reorg detection (compare indexed tip vs trusted LCD/explorer)
Manual recovery steps: stop indexer, restore DB or trim state, reset last_indexed_height or use START_BLOCK
START_BLOCK guidance (use only on fresh or cursor-reset database)
Links IX-03 in SECURITY_REVIEW and indexer/src/db/queries/state.rs

Operator guidance is clear and actionable. Closing.

@PlasticDigits Verified on current main. docs/runbooks/indexer-reorg-replay-dedup.md present (32 lines). Content covers: - Cursor model (last_indexed_height in Postgres, state.rs reference) - Swap dedup via (tx_hash, pair_id) unique constraint with ON CONFLICT DO NOTHING (insert_swap) - Reorg detection (compare indexed tip vs trusted LCD/explorer) - Manual recovery steps: stop indexer, restore DB or trim state, reset last_indexed_height or use START_BLOCK - START_BLOCK guidance (use only on fresh or cursor-reset database) - Links IX-03 in SECURITY_REVIEW and indexer/src/db/queries/state.rs Operator guidance is clear and actionable. Closing.

Brouie (Migrated from gitlab.com) closed this issue

2026-04-20 07:00:06 +00:00