KB-22CD

RP DOT Pivot-Update — 05 Cleanup Execution / Held-at-Commit

3 min read Revision 1
registries-pivotcleanupheldcomposition-fix2026-06-03

05 — Deterministic Cleanup: Execution / Blocker

Decision: HELD at the commit boundary — proven, staged, not committed

The 3 composition fixes are deterministic, governed, reversible-in-principle, bounded, and unambiguous. They are proven correct via BEGIN..ROLLBACK (§04). The commit is held because the tool's governed dot_tools registration cannot be completed in this environment (credentials absent, §03), and committing production mutation through a not-yet-registered tool risks the forbidden rule "no unregistered production mutation path if Đ26 requires DOT registration." The mission sanctions exactly this outcome: PARTIAL when "implementation is blocked by a real access … issue but packets are complete."

This is a materially stronger position than the prior macro's "HELD — no tool exists": the tool now exists, is deployed in the governed path, and is one operator command from done.

What WILL happen on commit (proven values)

Pivot UPDATE (via tool) mapping view after
PIV-001 composition_level: molecule → atom composition_status match
PIV-016 composition_level: atom → meta match
PIV-021 composition_level: atom → molecule match

v_rp_classification_governance_map composition_status: mismatch 3 → 0. pivot_definitions: exactly 3 rows change (composition_level + updated_at); 34 rows byte-identical; row count and active/inactive split unchanged.

Exact commit command (operator, after registration)

/opt/incomex/dot/bin/apply_composition_fixes.sh --commit
# equivalently, per-row:
#   dot-pivot-update --code PIV-001 --field composition_level --auto-from-species --commit
#   dot-pivot-update --code PIV-016 --field composition_level --auto-from-species --commit
#   dot-pivot-update --code PIV-021 --field composition_level --auto-from-species --commit
# verify: sql/rp_dot_pivot_update/verify_classification.sql  (expect mismatch=0)

Not executed (correctly)

  • 12 naming decisions — council semantic decisions, NOT deterministic, several require a new FAC-02 label that does not yet exist. Forbidden to auto-ratify. See §06.
  • 2 retire candidates — PIV-020 + MTX-TEST are already is_active=false; retire is a no-op (and the tool correctly refuses to touch inactive rows). See §06.
  • 9 drill_overload rows — law-valid Đ26 td-matrix drill ladder (material/product/ building/molecule/compound depth on cross_table/l2_drill pivots), NOT errors. Resolved by the future schema split (drill_level column), not by changing values. Keep.
Back to Knowledge Hub knowledge/dev/reports/architecture/registries-pivot-dot-pivot-update-author-register-cleanup-2026-06-03/05-deterministic-cleanup-execution-or-blocker.md