Part of #983.
Context
A fresh gittensory DB without reviewbot's stateful tables would trigger a full re-review STORM (the dead-letter-storm class of incident) + a reputation RESET across all 3 repos on cutover. The stateful tables to migrate are: per-head_sha decision-cache (migration 0005), approved_sha approve-once-per-commit (0006), submitter reputation/stats (0011/0018), tunables + shadow overrides + override audit (0014-0016), and review_audit with source/head_sha (0019, the parity columns from #1024). These must land in gittensory D1 BEFORE any cutover. reviewbot's migrations 0001-0019 must be reconciled against gittensory's 0001-0045 schema (namespace-check review_audit table-name collision with gittensory's recordAuditEvent).
Deliverables
Acceptance criteria
- All stateful tables (decision-cache, approvedSha, reputation/stats, tunables/shadow/override-audit, review_audit with source/head_sha) exist in gittensory D1 with data, BEFORE any cutover.
- Cutover does not cause a re-review storm or a reputation reset; the migration dry-run confirms no mass re-enqueue.
Notes
Part of #983.
Context
A fresh gittensory DB without reviewbot's stateful tables would trigger a full re-review STORM (the dead-letter-storm class of incident) + a reputation RESET across all 3 repos on cutover. The stateful tables to migrate are: per-head_sha decision-cache (migration 0005),
approved_shaapprove-once-per-commit (0006), submitter reputation/stats (0011/0018), tunables + shadow overrides + override audit (0014-0016), andreview_auditwithsource/head_sha(0019, the parity columns from #1024). These must land in gittensory D1 BEFORE any cutover. reviewbot's migrations 0001-0019 must be reconciled against gittensory's 0001-0045 schema (namespace-checkreview_audittable-name collision with gittensory'srecordAuditEvent).Deliverables
approved_sha(0006) so approve-once-per-commit is preserved.review_auditrows withsource/head_sha(0019 / Parity audit columns + wiring (source+head_sha; computeGateParity ported) #1024) so parity has history.review_auditvs gittensoryauditEvents/recordAuditEvent).Acceptance criteria
Notes