Mission 3.5: Automation Hardening Report

Date: 2026-03-28 | PR: #644 | Status: MERGED + DEPLOYED

Step 0: Checkpoint

• OR v5.8: Mission 3 DONE. 4 gaps in §0-AI. Mission 3.5 DISPATCHED.
• Merge Rule: 4 required checks GREEN = MERGE NGAY.
• §0-AF: Evidence from production URL.

Production Survey (Before)

• Crontab: 12 entries, NONE for pivot refresh or health
• Drift: CAT-000 (33 vs 28), CAT-006 (114 vs 6 — filtered pivot match bug), CAT-023 (19340 vs 19386)

Changes

A1: CRON + On-demand for refresh

• Cron: */10 * * * * refresh_meta_catalog_from_pivot() → /var/log/incomex/pivot-refresh.log
• On-demand: /api/registry/refresh-counts.post.ts → status=ok, updated=22
• Fixed: refresh function now only uses total pivots (unfiltered + ungrouped)

A2: DOT-114 daily health check

• Cron: 0 4 * * * dot-pivot-health → /var/log/incomex/pivot-health.log

A3: PG trigger on pivot_definitions

• trg_after_pivot_definitions_change: AFTER INSERT/UPDATE/DELETE FOR EACH STATEMENT
• Calls refresh_meta_catalog_from_pivot() automatically
• Tested: INSERT PIV-TEST → refresh fires → DELETE PIV-TEST → cleanup OK

A4: DOT-114 warnings investigation

• H4 (2 missing): CAT-024 (pivot_definitions itself) + CAT-999 (_uncategorized). Expected. No fix.
• H6 (3 duplicates): Cross-table pivots share source_object with total pivots. False positive. No fix.

VERIFY AUTOMATION

• A1-CRON: Entry present. Zero drift after refresh.
• A1-ONDEMAND: status=ok, 22 updated.
• A2-CRON: Entry present. dot-pivot-health 5/7 PASS (2 expected warnings).
• A3-TRIGGER: trg_after_pivot_definitions_change enabled (O). INSERT/DELETE test passed.
• A4: Warnings explained. No fix needed.
• Production: pivot_definitions 27 rows. Registries page HTTP 200.

§0-AI Compliance

Feature	Cron	On-demand	Compliant
refresh counts	*/10 min	POST /api/registry/refresh-counts	YES
health check	daily 4AM	dot/bin/dot-pivot-health	YES
pivot_definitions change	PG trigger (immediate)	Manual refresh	YES

Mission 3.5 COMPLETE. All automation dual-triggered.