KB-7219

Checkpoint — Topic Axis Self-Operated Advance 2026-06-04

4 min read Revision 1
topic-axischeckpointself-operated2026-06-04

Checkpoint — Topic Axis Self-Operated Advance (short SSOT)

Date: 2026-06-04 Macro: TOPIC_AXIS_SELF_OPERATED_DECISION_QUEUE_UI_CONTENT_AUTOMATION Final status: PARTIAL — every safe/additive/reversible branch self-operated and committed live; only genuine human/legal decisions remain. Execution mode: EXECUTION_MODE. prod = query_pg RO + ssh contabo root → docker exec postgres psql -U directus RW. Live mutation: YES — 3 additive reversible objects (below). 0 taxonomy node, 0 promotion, 0 activation, 0 approval approved, 0 source-tag change.

Live objects committed

  • 14 approval_requests rows AXR-TOPIC-01..14, ALL status=pending (211→225). The human gate as an operational row-by-row queue covering all 7 decision categories. Side-effect: +14 governed provenance births (1,152,873→1,152,887; normal approval-insert path; disclosed; unretirable).
  • v_axis_topic_governance_gap (read-only, 8 rows, all OWNER_MISSING).
  • v_axis_topic_automation_candidates (read-only, 49 rows = 7 topics × 7 routing patterns, non-executing).

Status fields

  • Approval workflow: LIVE queue, 14 pending, no fake approval (verified via independent MCP read-back).
  • UI/API: DEPLOY-READY — 10 routes (7 prior + 3 NEW: approval-queue, governance-gap, automation-candidates) + tests + checklist (doc 03). Redeploy operator-gated.
  • Content-map: COMPLETE — 7 candidates classified; knowledge_graph deep-mapped (10 IU hub, ∩architecture×3); cross-topic shared-IU adjacency graph found (doc 04).
  • Automation bridge: PLAN LIVE as a view + pilot rows queued (AXR-TOPIC-13 verbs, AXR-TOPIC-14 KG).
  • Governance bootstrap: GAP LIVE as a view + pending request AXR-TOPIC-12 (no active ownership faked; gov_object_ownership stays 0).
  • End-to-end proof: COMPLETE, 9/9 on live data.

Two findings

  • action='add' approval_requests auto-approve (fn_auto_approve_add) → AI proposals must use action='review'.
  • approval_requests births on insert; MCP RO role can't see triggers via information_schema → use pg_trigger.

Live numbers (2026-06-04, post-commit)

AX-TOPIC=CANDIDATE; assignments 25/7; surface 7; pivots 14; decision queue 7; taxonomy 58 (FAC-08=0 nodes); births 1,152,887; edges 2,199; gov ownership 0; gov scopes 6; approval_requests 225 (14 AXR-TOPIC pending); event types 45; source topic tags 25/16 IU.

Next macro

Primary: INFORMATION_PIECE_CONTENT_WORK_ON_CANDIDATE_TOPIC_SURFACE (no human gate; actionable now). Parallel: RP_UI_AXIS_SURFACE_DEPLOY (operator) + TOPIC_AXIS_OWNER_DECISION_AND_TAXONOMY_PROMOTION (owner drains AXR-TOPIC-* queue).

Exact blocker

GOV-COUNCIL FAC-08 root approval (Điều-32) + owner authorisation for unretirable taxonomy births + real owner_gov_code/OSPA for ownership + axis-law ratification. No engineering blocker. All queued as AXR-TOPIC-* pending rows.

Report path

knowledge/dev/reports/architecture/topic-axis-self-operated-decision-ui-content-automation-2026-06-04/ (docs 00–10). Rollback: /tmp/axis_self_operated_rollback.sql. Continues checkpoint-rp-ui-axis-decision-queue-2026-06-04.md.

Back to Knowledge Hub knowledge/dev/reports/architecture/checkpoint-topic-axis-self-operated-advance-2026-06-04.md