00 — G1 Candidate Registry Activation Closure Campaign — Overview & Control
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)
- Host = contabo VPS ✓ 2. Container =
postgres✓ 3. DB =directus✓ - Read identity =
context_pack_readonly(server 172.19.0.3) ✓ - Apply role
workflow_adminconfirmed with SELECT first ✓ pg_stat_activity: no orphan / idle-in-transaction from this campaign at entry or exit ✓fn_iu_gate_verify_closed()→all_safe=true, never_flip_intact=true, all_governed_closed=true(10/10 gates safe) ✓- Baseline snapshot captured (below) ✓
- Rollback/rehearsal strategy: one stdin-fed
BEGIN..ROLLBACKwith server-sidestatement_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.