KB-2351

00 — G1 Candidate Registry Activation Closure Campaign — Overview & Control

5 min read Revision 1
g1candidate-registryactivationphase0control2026-05-29

00 — G1 Candidate Registry Activation Closure & Phase-0 Gate Prep — Overview / Control

Campaign: G1_CANDIDATE_REGISTRY_ACTIVATION_CLOSURE_AND_PHASE0_GATE_PREP_CAMPAIGN Date: 2026-05-29 · Host: contabo VPS · Container: postgres (postgres:16) · DB: directus Read channel: MCP query_pg (role context_pack_readonly, READ ONLY, 5s timeout) · Apply channel (rehearsal only): ssh contabo "docker exec -i postgres psql -U workflow_admin -d directus" (stdin-fed, single invocation).

Verdict: PASS

All agent-solvable G1 blockers are CLOSED. The only remaining items are human/sovereign authority (B-5 Điều 32) — for which a fully executable activation pack is delivered (doc 06). Zero persisted mutation occurred this campaign; the live rehearsal was BEGIN..ROLLBACK and returned the DB byte-identical to baseline.

Blocker status

Blocker Was Now Where
B-2 production schemas (not stubs) open CLOSED — production DDL written + proven to create cleanly and pass fn_pre_birth_check 5/5 doc 01
B-3 PREFIX-NNN / meta_catalog code open CLOSED — exact codes FIELD-001/FORM-001/TIER-001 + CAT-1011/1012/1013, validation query, collision proof doc 02
B-4 tier_registry has no owning Mother open CLOSED (recommended) + AUTHORITY-DEFERRED — owner = Điều 37 authority (GOV-COUNCIL); write proven reversible; final selection is a human decision doc 03
P-1 +52 birth cascade uncharacterized open CLOSED — measured exactly: +60 birth rows, full decomposition + rollback/irreversible-risk maps doc 04
B-5 Điều 32 enacting-law + cross-sign ≥2 open AUTHORITY-DEFERRED (correct) — agent must NOT self-mint; executable human pack delivered doc 06

Hard Gate 0 (passed)

  1. Host = contabo VPS ✓ 2. Container = postgres ✓ 3. DB = directus
  2. Read identity = context_pack_readonly (server 172.19.0.3) ✓
  3. Apply role workflow_admin confirmed with SELECT first ✓
  4. pg_stat_activity: no orphan / idle-in-transaction from this campaign at entry or exit ✓
  5. fn_iu_gate_verify_closed()all_safe=true, never_flip_intact=true, all_governed_closed=true (10/10 gates safe) ✓
  6. Baseline snapshot captured (below) ✓
  7. Rollback/rehearsal strategy: one stdin-fed BEGIN..ROLLBACK with server-side statement_timeout=60s, lock_timeout=10s, idle_in_transaction_session_timeout=120s; no client-timeout-kill (per the 8-orphan-backend incident lesson) ✓

Baseline snapshot (entry == exit, verified)

Object Count
meta_catalog 169
collection_registry 168
table_registry 21
v_registry_counts 169
birth_registry 902130
governance_registry 9
entity_species 42
species_collection_map 164
measurement_registry 142
dot_iu_command_catalog 53
dot_iu_command_run 55
field_registry / input_form_registry / tier_registry ABSENT (NULL)

Post-rollback re-read confirmed every count unchanged and all 3 target tables still absent. GOV-COUNCIL.capability returned to NULL (the rehearsal tier-ownership write rolled back).

Document map

  • 01 Production schemas (Branch A) — B-2
  • 02 PREFIX-NNN / meta_catalog code plan (Branch B) — B-3
  • 03 Tier ownership / no-orphan decision (Branch C) — B-4
  • 04 +60 birth cascade characterization (Branch D / P-1)
  • 05 Full activation rehearsal (Branch E)
  • 06 Final human/sovereign activation pack (Branch F) — B-5
  • 07 Phase-0 gate board update (Branch G)
  • 08 Law / forbidden / self-review (Branch H)

Live-safe changes this campaign

NONE persisted. Read-only introspection + one rolled-back rehearsal transaction only. The v_registry_counts_id_seq lag defect found in the prior campaign was already fixed (setval committed 2026-05-29 earlier); this campaign required no sequence correction. No gate opened, no catalog growth, no DOT run rows added (dot_run stays 55).

Builds on

[[project-g1-candidate-registry-reversibility-solved-2026-05-29]] — which proved reversibility; this campaign closes the four technical blockers it deferred.

Back to Knowledge Hub knowledge/dev/reports/architecture/g1-candidate-registry-activation-closure-campaign-2026-05-29/00-overview-control.md