KB-59DE

Phase 2 — HARD GATE 0 + Baseline

3 min read Revision 1
dieu45phase2hard-gate-0baseline2026-05-26

HARD GATE 0 + Baseline Snapshot

HARD GATE 0 — Live apply channel

Check Result
SSH contabo reachable OK
docker exec postgres reachable OK
psql workflow_admin@directus opens OK
SELECT version() PostgreSQL 16.13 (Debian 16.13-1.pgdg13+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 14.2.0-19) 14.2.0, 64-bit
DDL/DML BEGIN; CREATE TABLE _gate0_probe…; ROLLBACK; PASS; to_regclass('_gate0_probe') IS NULL = true
pg_dump -Fc to container /tmp/ OK (82,970,890 B)
Phase 1 tables present OK — job_queue, job_dead_letter, queue_heartbeat
Phase 1 views present OK — v_queue_health, v_job_queue_backlog, v_job_dead_letter_summary
Phase 1 functions present OK — fn_job_ack, fn_job_claim, fn_job_enqueue, fn_job_fail_or_retry, fn_job_move_to_dead_letter, fn_job_queue_updated_at (trigger), fn_queue_heartbeat_tick, fn_queue_stale_check
Phase 1 queue.* dot_config keys 8 keys present (substrate/worker/notify/heartbeat = false; lease/retry tuning intact)

Verdict: HARD GATE 0 PASS.

Baseline row counts (pre Phase 2)

Object Rows
job_queue 0
job_dead_letter 0
queue_heartbeat 0
event_outbox 133,784
iu_route_worker_cursor 1
iu_vector_sync_point 152
information_unit 175
production_documents (table absent)

Silent-gap measurement

  • iu_route_worker_cursor.iu_outbound_default.last_run_at = 2026-05-22 11:31:41.928657+00
  • silent_seconds at baseline = 346,163 s ≈ 96.2 hours
  • Pre-Phase 2, this gap is NOT surfaced in v_queue_health or fn_queue_stale_check (queue_heartbeat empty).

Extensions

SELECT extname, extversion FROM pg_extension:

  • btree_gist 1.7
  • pgcrypto 1.3
  • plpgsql 1.0
  • postgres_fdw 1.1

pg_cron NOT installed. Phase 2 does NOT install it.

queue.* dot_config at baseline (8 keys)

Key Value
queue.heartbeat.enabled false
queue.heartbeat.stale_threshold_seconds 300
queue.job_substrate.enabled false
queue.lease.duration_sec 300
queue.notify.enabled false
queue.retry.backoff_base_sec 10
queue.retry.max_attempts_default 5
queue.worker.enabled false

Backup record

  • Pre-Phase 2: /tmp/dieu45_phase2_pre.dump (custom format, -Fc), 82,970,890 B, taken 2026-05-26 11:43 UTC inside postgres container.
  • Post-Phase 2: /tmp/dieu45_phase2_post.dump, 83,187,232 B, taken 2026-05-26 13:56 UTC.
  • Delta = +216,342 B (Phase 2 mig 051 substrate + ~10 min of background event_outbox traffic).
Back to Knowledge Hub knowledge/dev/laws/dieu44-trien-khai/v0.6-dieu45-phase-2-heartbeat-activation-lease-governance/01-hard-gate-and-baseline.md