One-Roof Clone Axis/Topic Substrate Pipeline — 00 Overview & State Recovery (PASS)
00 — Overview & State Recovery
Mission: ONE_ROOF_NONPROD_CLONE_AXIS_TOPIC_SUBSTRATE_AND_COVERAGE_PIPELINE
Date: 2026-06-03 · Mode: production READ-ONLY; clone directus_gov_test_20260602 persistent test commits (marked TEST_CLONE, DROP-reversible).
Verdict: PASS — axis/topic substrate advanced from rollback-only prototype to a persistent, integrated working substrate on the clone, A→E executed and committed; F/G/H produced; production byte-unchanged.
What this mission did (one paragraph)
The prior extended-pipeline run proved the axis/topic substrate as a rollback-only prototype (7/7) and shipped a build-ready design, deliberately withholding commit. This run took the explicit clone-commit authorization and built the substrate for real on the clone: six tables, nine views, three axes (responsibility/topic/containment), the candidate→active lifecycle, confidence/zone/provenance assignment governance, a generalized coverage engine that reproduces the canonical 210 with zero drift, an idempotent scanner that writes bounded clone-local findings, and a fail-closed issue/event boundary — then packaged a gated production rollout. Production was only ever read.
State recovery — sources reconciled
| Source | Key fact carried forward |
|---|---|
…extended-governance-pipeline-2026-06-02/03-axis-topic-readiness-on-clone.md |
Prototype 7/7; 4-table design reproduces 210; coverage modes cross_product/per_assignment; commit withheld pending ownership-axis extension. |
…extended…/sql/B_axis_substrate_prototype_rollback_only_clone.sql |
The exact proven DDL + coverage engine (this run's starting point). |
…operational-hardening…/05-axis-storage-build-ready-design.md |
Richer column model: zone (approved/candidate/quarantine), match_score vs confidence, provenance-or-quarantine, lifecycle, parent/child. |
…operational-hardening…/04-axis-operating-model-hardened.md |
Two behavioural classes (deterministic vs uncertain); axis = a row, not infrastructure; owner-per-scope; no-island. |
| GPT review named in mission prompt | Not found on disk (consistent with the recurring "mission-named gpt-review file absent" pattern). Immaterial: the build-ready design it gated is present and was used. |
Current production state (live, read-only, 2026-06-03)
db=directus · ownership_rows=0 · gap=210 · ospa=0 · gov_emit=0 · axis_tables=ABSENT(0) · candidate_state=0 · ruleset=0 · worker_cursor=0 · inventory=35 · idle_in_tx=0. This is the exact long-standing Phase-1 baseline (own0/gap210/ospa0). Unchanged at entry, mid, and exit of this run.
Current clone state (entry → exit)
| entry | exit | |
|---|---|---|
original governance_object_ownership rows |
30 | 30 (untouched) |
canonical v_object_owner_gap |
0 | 0 (untouched) |
| inventory / containment | 35 / 35 | 35 / 35 |
| axis substrate tables | 0 | 6 (built) |
| axis views | 0 | 9 (built) |
| axes (registry rows) | 0 | 3 (responsibility active, topic active, containment candidate) |
| axis values / assignments / parallel owners | 0/0/0 | 15 / 6 / 4 |
| axis findings (clone-local) | 0 | 34 |
| generalized required / gap | n/a | 216 / 2 (resp 0, topic 2) |
| event_outbox governance rows | 0 | 0 (inert) |
Axis/topic missing pieces — now closed (on clone)
axis_registry,axis_value,axis_assignment,coverage_rule— built.- Ownership-for-other-axes — solved by a parallel
axis_object_ownership(the design's offered alternative to ALTERinggovernance_object_ownership), so the production-shaped ownership table is never touched and the existing 210→0 pipeline stays byte-intact. - Lifecycle candidate→active, confidence/zone/provenance, parent/child topic, scanner integration, fail-closed events — all tested.
Exact clone build goal (met)
Persist a working, integrated axis substrate that (a) reproduces the canonical responsibility coverage with zero drift, (b) supports a second uncertain axis (topic) with the full governance column model, (c) integrates with the scanner/candidate and issue/event boundaries, and (d) is fully DROP-reversible — without altering any pre-existing table.
Forbidden production scope (honoured)
No production writes/DDL/axis-creation/ownership/candidate/event/DOT/Directus/Qdrant/Nuxt/approval changes. Production touched by query_pg (read-only role) only.
Rollback / drop strategy
sql/Z_axis_substrate_drop_clone.sql removes every object this run created on the clone (9 views + 6 tables, dependency-ordered) and asserts 0 remain — restoring the clone to its pre-build state. Because the build is purely additive, the drop is total and lossless. Production rollout has its own reversal: sql/G_prod_03_rollback.sql.
See: 01 (safety gates) · 02 (substrate build) · 03 (seed/lifecycle) · 04 (assignment coverage) · 05 (scanner) · 06 (issue/event) · 07 (UI/API) · 08 (rollout packet) · 09 (clone lifecycle) · 10 (GO/NO-GO) · 11 (self-review).