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+00silent_secondsat baseline = 346,163 s ≈ 96.2 hours- Pre-Phase 2, this gap is NOT surfaced in
v_queue_healthorfn_queue_stale_check(queue_heartbeat empty).
Extensions
SELECT extname, extversion FROM pg_extension:
btree_gist 1.7pgcrypto 1.3plpgsql 1.0postgres_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 insidepostgrescontainer. - 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_outboxtraffic).