KB-7312
00 — README FIRST — Birth Fix Next-Cycle Verification / Trigger Reconciliation / RP Hygiene
3 min read Revision 1
00 — README FIRST
Macro: BIRTH_FIX_NEXT_CYCLE_VERIFICATION_TRIGGER_RECONCILIATION_AND_RP_OBJECT_HYGIENE_REPOINT
Date: 2026-06-05
Mode: EXECUTION — live mutation = additive views only (12 CREATE OR REPLACE VIEW); birth-neutral (before==after==1,210,742). No DML, no trigger DDL, no source edits.
Verdict: see 08-final-summary.md and the checkpoint.
What this session did
- Track A — 13:00 UTC cycle verification. At session start (≈12:00 UTC) the 13:00 UTC executor cycle had not yet fired → classified PENDING_TIME with an exact watch that was then executed live (background waiter at 13:12 UTC). Result in
01-13utc-cycle-verification.md. - Track B — spike recurrence. Confirmed NO active recurrence. Bursts at 07:00 (5,056) and 10:00 (5,177) UTC were PRE-FIX; flatline since. See
02-spike-recurrence-status.md. - Track C — trigger reconciliation. 29 exempt-active / 50 deferred-active / 5 required-missing / 18 duplicate. Rehearsed a duplicate-DROP in
BEGIN..ROLLBACK(proven valid+reversible+birth-neutral). Left an operator/owner packet — did NOT auto-apply. See03-trigger-reconciliation-readiness.md. - Track D — RP object hygiene. SSOT already clean (managed=2,927 vs raw=1,210,742, 98.97% noise). No RP view uses raw count as object truth; only
v_rp_authority_execution_preflightexposes a raw diagnostic fact (operator UI repoint candidate). See04-rp-object-hygiene-repoint-plan.md. - Track E — guards. Consolidated dashboard + no-go guard (7/7 pass). See
05-monitoring-guard-hardening.md. - Track F — router. See
06-next-router.md.
Key live facts (as of ~12:00 UTC 2026-06-05)
birth_registryraw total = 1,210,742; last_10m=0, last_1h=0; most-recent non-provenance birth at 10:53 UTC.- H11a:
check_kind=detect_only,auto_fix_action=NULL→ CONTAINED. fn_birth_registry_autoskipscoverage_status LIKE 'BIRTH_EXEMPT%';fn_log_issueidempotent oncoalesce_key.- entity_labels = BIRTH_EXEMPT_STRUCTURAL_JUNCTION; registry_changelog = BIRTH_EXEMPT_SYSTEM_LOG_OR_AUDIT.
Artifacts
- SQL on VPS:
/opt/incomex/docs/mcp-writes/birth-fix-next-cycle-2026-06-05/{01_apply_views.sql,02_trigger_reconciliation_OPERATOR_PACKET.sql,99_rollback_views.sql} - 12 new views (all
v_birth_fix_*,v_birth_13utc_*,v_birth_post_fix_*,v_birth_trigger_reconciliation_*,v_rp_birth_count_truth_contract,v_rp_managed_vs_raw_birth_surface,v_rp_object_hygiene_repoint_plan).
Read order
00 (this) → 01 cycle → 02 spike → 03 triggers → 04 RP hygiene → 05 guards → 06 router → 07 safety audit → 08 final summary → 09 GPT/MCP checkpoint.