01 — Overview & Control (Combined Macro 2+3)
title: 01 — Overview & Control (Combined Macro 2+3) date: 2026-05-31 host: contabo VPS (vmi3080463) · DB directus · postgres:16 (6 weeks up) approval_mode: COMMIT_FORBIDDEN_NO_APPROVAL verdict: PASS (deferred path) — all safe work done, zero persistent mutation
01 — Overview & Control
Combined Macro 2+3 for Registries-Pivot. Covers phases 5–12: threshold/label grouping,
registry pin, phantom policy/law, Directus/API exposure, connected static UI preview v2,
Nuxt render-shell pack, legacy retirement plan, production acceptance suite. Built on the
Macro 1 commit-ready foundation. No persistent PG / Nuxt / Directus / Qdrant mutation
occurred. One static preview was deployed under /ui-preview/registries-pivot/v2/.
Hard Gate 0 (re-verified live this run)
| Check | Result |
|---|---|
| Host | contabo VPS vmi3080463, container postgres up 6 weeks (healthy) |
| DB / role | directus / context_pack_readonly (read) · apply-channel workflow_admin (rehearsal only) |
| idle_in_transaction | 0 (entry and after every rehearsal) |
/knowledge/registries |
HTTP 200 ("Danh mục hệ thống") |
/knowledge/pivot |
HTTP 200 ("Pivot — Thống kê theo Lớp cấu tạo") |
/ui-preview/registries-pivot/v1/ |
HTTP 200 |
| Approval scan | NO_APPROVAL_FOUND for every RG1–RG9 scope |
Entry baseline counts (16 objects, live)
| object | count | object | count |
|---|---|---|---|
| meta_catalog | 169 | entity_labels | 726,864 |
| pivot_definitions | 37 | dot_tools | 309 |
| pivot_results | 126 | dot_iu_command_catalog | 54 |
| collection_registry | 168 | information_unit | 219 |
| table_registry | 21 | iu_relation | 60 |
| entity_species | 42 | v_registry_counts | 169 |
| species_collection_map | 164 | taxonomy | 58 |
| taxonomy_facets | 10 | label_rules | 38 |
entity_labels grew 718,744 → 726,864 since the design-pass sessions — the live label machinery is active (consistent, not a discrepancy).
Clean-slate proof (nothing from Macro 1 was committed)
A single query confirms the deferred path held: six_views_present=0,
substrate_fn_present=0, bundle_pivots_present=0 (PIV-500/301/302/303/311/321),
parent_code_wired=0. Pin/favorite/watchlist table scan = 0 rows. The foundation is
hot and re-rehearsable, but nothing persisted.
Live count-integrity state (leaf set, 160 rows)
leaf 160 · ok 152 · failed 3 · unverified 5 · pivot_backed 21/160 · status FAILED (honest)
net_gap +5,380 = CAT-023 +5,249 (model-A write-race) + CAT-006 +146 (model-B phantom-candidate) − CAT-007 15 (model-B unregistered)
The invariant closes (Σ drift gaps == leaf net_gap) — proof the scalar-EXISTS strategy does not double-count. net_gap fluctuates (CAT-023 birth race; Σrecord moved +1 in-session).
What this macro produced
- Gate 0 re-verified; commit mode classified COMMIT_FORBIDDEN_NO_APPROVAL (doc 02).
- Threshold/label pack —
display_policyrehearsed GREEN, 28/160 leaves exceed ceiling, PIV-311=23 groups (doc 03). - registry_pin pack — rehearsed GREEN, REGISTRY_MISSING confirmed (doc 04).
- Phantom policy/law pack — source_model-aware, RG4 decision package + event/issue mapping (doc 05).
- Directus/API readiness — 8 proposed read endpoints, GOOD-pattern template, no-count-in-API rule (doc 06).
- Static UI preview v2 DEPLOYED —
https://vps.incomexsaigoncorp.vn/ui-preview/registries-pivot/v2/HTTP 200 (doc 07). - Nuxt render-shell implementation pack (doc 08).
- Legacy retirement plan with exact file:line targets (doc 09).
- Production acceptance suite, read-only portions executed (doc 10).
- Consolidated roadmap with gates (doc 11), no-hardcode evidence (doc 12), next macro prompts (doc 13), self-review (doc 14).
Control properties (Đ30/31/32)
- Every DDL touch was inside
BEGIN..ROLLBACKwithSET LOCALlock/statement/idle timeouts. query_pgMCP is read-only (AST-blocks DDL); apply-channelworkflow_adminused only for rehearsal, always rolled back.- No self-approval; no fake approval; the only human approvals in PG (6 rows) are S178 DOT-repair, out of scope (doc 02).
- Static preview is additive, versioned (
v2/besidev1/), rollback =rm -rf v2/.
builds on registries-pivot-macro1-ratify-foundation-pivot-drilldown-2026-05-31/.