06 — Gate Monitor and Ready-to-Run Checklist

Date: 2026-06-03. Objective D. Artifacts: sql/gate_monitor/gate_check.sql, sql/gate_monitor/gate_check.sh. Read-only, no daemon, no side effect.

Design

Answers one question — is the rollout gate OPEN? — by re-evaluating the conditions the executor's Tier-0 preflight enforces, but read-only and non-aborting. No mutation, no loop, no dispatch. On-demand or cron-scheduled read only; no standing production process.

SQL monitor — gate_check.sql

Prints a detail row then a single verdict row:

gate_status | blockers | ospa | resp_gap | resp_ownership
BLOCKED     | ospa<1;  |    0 |      210 |              0

gate_status ∈ {READY, BLOCKED}. READY requires ALL of: db=directus, ospa≥1, ownership=0, gap=210, conflict=0, gov_emit=0, axis substrate absent, 5 prereq views present. Validated live this run via query_pg: returned BLOCKED | ospa<1; | 0 | 210 | 0 — the expected blocked output.

Shell monitor — gate_check.sh

./gate_check.sh → GATE: BLOCKED|ospa=0|gap=210 (exit 10); --quiet → BLOCKED. Exit 0 READY / 10 BLOCKED / 1 error. Suitable for cron (read-only). Do NOT tight-loop against production; a daily/hourly read is ample (gate only changes on deliberate human ratification).

Expected outputs

Situation	gate_status	blockers	Action
Today (blocked)	BLOCKED	ospa<1;	wait for ratification
Ratified, clean	READY	(empty)	run prod/99_run_all.sql
Ratified but drift	BLOCKED	gap<>210; / axis_present;	investigate; do NOT execute
Partially applied	BLOCKED	axis_present;	rollback, re-baseline

No-op-while-blocked

While BLOCKED the monitor performs only SELECT count(*) reads — writes/emits nothing. The executor is independently fail-closed: 00_preflight.sql aborts any rollout while ospa<1.

Ready-to-run checklist

• gate_check.sql → READY
• ospa ≥ 1 from a real ratified APR (pass as -v ratified_apr=)
• resp_gap=210, ownership=0, conflict=0
• axis substrate absent
• gov_emit=0
• you intend the accountability assertion (GOV-COUNCIL/KG-SYS/DOT/MOIT)
• rollback path reachable (final_rollback_copy/99_rollback_full.sql)

Alert format (no external dispatch performed by this package)

[one-roof-gate] <UTC> BLOCKED ospa=0 gap=210 — rollout held at human L2/L4 ratification. On READY, page the engineer to run doc 07's prompt (separation of detection and action).

Verdict: Objective D PASS.