MCP Verify 1.0.636 Database Deployment Verification

Date: _unfilled_ Release SHA: _unfilled_ Release version: 1.0.636 Operator: _unfilled_

Predeployment

• [ ] Verify tests pass.
• [ ] Root unit tests pass.
• [ ] make test-suites passes.
• [ ] Predeployment invariants pass.
• [ ] PostgreSQL migration and partition workflow pass on a production-like copy.
• [ ] Fresh backup exists and a restore has been exercised.
• [ ] MCP_VERIFY_DATABASE_RETENTION_ENABLED=false is confirmed.
• [ ] MCP_VERIFY_DATABASE_RESTORE_GATE_VERIFIED=false is confirmed.

Migration and backfill

• [ ] PostgreSQL restarted with pg_stat_statements preloaded and I/O timing on.
• [ ] Alembic head is 0029_db_performance.
• [ ] Normalized server fields are backfilled.
• [ ] Every visible server has a canonical identity.
• [ ] Public score versions and comparable membership are populated.
• [ ] New indexes are valid and duplicate validation index is absent.
• [ ] Summary tables exist; initial watermark and raw/rollup parity recorded.

Record commands, timestamps, row counts, checksums, and query plans here:

_unfilled_

Analytics partition cutover

• [ ] Shadow parent and current/next-three monthly partitions prepared.
• [ ] Default partition row count is zero.
• [ ] Backfill parity matches on count, bounds, and checksum.
• [ ] Atomic cutover completed.
• [ ] Web and every writer restarted.
• [ ] A post-cutover write lands in the current partitioned table.
• [ ] A simulated/real old-writer insert was mirrored before finalization.
• [ ] Mirror finalized only after writer restart.
• [ ] Unpartitioned backup retained; no raw partitions dropped.

_unfilled_

Runtime verification

• [ ] /version shows the release SHA/version and effective database settings.
• [ ] pg_stat_activity shows bounded, named web/worker/migration pools.
• [ ] pg_stat_statements is collecting Verify queries.
• [ ] Verify postgres-exporter and Prometheus scrape are healthy.
• [ ] Admin conversions returns within target and includes a recent watermark.
• [ ] Detail, catalog, search, validation, scheduling, and Agent Reliability smoke tests pass.
• [ ] No long idle transaction remains after admin report assembly.
• [ ] No default-partition rows, invalid indexes, migration errors, or elevated 5xx rate.

_unfilled_

Deferred retention gate

Retention must remain off until all items below are separately approved:

• [ ] production-like restore succeeded;
• [ ] compact summaries match raw reports;
• [ ] foreign-key behavior was verified;
• [ ] seven-day telemetry was reviewed;
• [ ] rollback window for the unpartitioned analytics backup ended.