KB-2975

F6 Pre-Activation Macro 08 — Rollback & Artifact Inventory

3 min read Revision 1
one-roofphase1f6rollbackartifact-inventory2026-06-02

08 — Rollback & Artifact Inventory (Objective H, part 1)

Mutation ledger for this run

Surface Writes performed Persistent?
PostgreSQL directus 1 × BEGIN..ROLLBACK rehearsal (doc 02) No — rolled back, entry==exit on both channels
PostgreSQL — COMMIT none
system_issues / event_outbox none
Directus / Qdrant / Nuxt none
Local FS (knowledge/…) package docs + SQL artifacts yes (reports only)
KB (Incomex_KB) package upload (doc 10) yes (reports only)

Net governed-state delta = 0. Only residue is a non-transactional governance_object_ownership_id_seq advance (no row behind it) — cosmetic, standard for rolled-back inserts.

Rollback posture

  • The rehearsal script (sql/f6_large_ownership_rollback.sql) ends in ROLLBACK; unconditionally; even on mid-script error the surrounding transaction aborts ⇒ rollback either way.
  • For the future ratified COMMIT, the pre-staged reversal is DELETE FROM governance_object_ownership WHERE created_by LIKE 'F6_%'; — proven reversible (table has 0 triggers, no cascade).

Artifact inventory

Package: knowledge/dev/reports/architecture/one-roof-phase1-coverage-preactivation-consolidated-testmode-macro-2026-06-02/

File Purpose
00-overview-state-recovery-and-executive-verdict.md state recovery + executive verdict
01-live-preflight-and-gates.md Hard Gate 0 (25 gates)
02-large-ownership-rollback-rehearsal.md Objective A results
03-scanner-query-path-and-dry-run.md Objectives B+D
04-persistent-test-seed-decision-and-results.md Objective C decision + readiness packet
05-issue-event-log-boundary.md Objective E
06-axis-objectgrain-boundary.md Objective F
07-activation-matrix.md Objective G
08-rollback-and-artifact-inventory.md this file
09-final-go-nogo-and-next-macro.md final decision + next macro
10-self-review.md self-review + KB verification
sql/f6_large_ownership_rollback.sql the executed rollback-only rehearsal
sql/f6_scanner_readonly.sql the read-only scanner path + payload shaping

Live evidence anchors (for reproducibility)

  • DB directus; write role workflow_admin; read role context_pack_readonly.
  • inv=35, cont=35, scopes=6, gap_ceiling=210; ownership=0; ospa=0; gov_emit=0; sys_issues=199,455; birth_registry=1,084,816; idle_in_txn=0.
  • Trigger map: ownership/ruleset/cursor/scan_run/candidate = 0; system_issues=9; event_outbox=1.
  • axis_registry/axis_assignment/coverage_rule = absent.
Back to Knowledge Hub knowledge/dev/reports/architecture/one-roof-phase1-coverage-preactivation-consolidated-testmode-macro-2026-06-02/08-rollback-and-artifact-inventory.md