KB-3738

One-Roof Clone Axis/Topic Substrate Pipeline — 00 Overview & State Recovery (PASS)

6 min read Revision 1
one-roofnonprod-cloneaxis-substrateaxis-topicoverviewstate-recoverypass

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_rulebuilt.
  • Ownership-for-other-axes — solved by a parallel axis_object_ownership (the design's offered alternative to ALTERing governance_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).

Back to Knowledge Hub knowledge/dev/reports/architecture/one-roof-nonprod-clone-axis-topic-substrate-pipeline-2026-06-02/00-overview-state-recovery.md