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

  1. 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.
  2. 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.
  3. 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. See 03-trigger-reconciliation-readiness.md.
  4. 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_preflight exposes a raw diagnostic fact (operator UI repoint candidate). See 04-rp-object-hygiene-repoint-plan.md.
  5. Track E — guards. Consolidated dashboard + no-go guard (7/7 pass). See 05-monitoring-guard-hardening.md.
  6. Track F — router. See 06-next-router.md.

Key live facts (as of ~12:00 UTC 2026-06-05)

  • birth_registry raw 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=NULLCONTAINED.
  • fn_birth_registry_auto skips coverage_status LIKE 'BIRTH_EXEMPT%'; fn_log_issue idempotent on coalesce_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.

Back to Knowledge Hub knowledge/dev/reports/architecture/birth-fix-next-cycle-verification-trigger-reconciliation-rp-hygiene-2026-06-05/00-readme-first.md