basquetWi + New ticket

EVO-70 Tier 0: conditionalize drain-email-outbox pg_cron — EXISTS-guard so empty ticks fire zero HTTP/Vercel

Done normal dmdb-mars-cc

EVO-70 fleet Tier-0 (ship same-day, reversible, DB-lane, no app deploy). Wrap pg_cron jobid6 net.http_get in a plpgsql IF-guard fn that fires ONLY when work is due. Predicate MUST byte-match worker eligibility: status='pending' AND COALESCE(nextAttemptAt, createdAt) <= now() (backoff-leak catch — bare status='pending' would re-fire on future-scheduled retry rows). Empty/not-due tick -> zero HTTP round-trip, zero Vercel invocation. Keep */5 as retry timer in T0. One migration, reversible. This cron is PERMANENT durability recovery — never retired even after Tier 1 (pg_net tables are UNLOGGED/beta).

Questions

No questions.

Activity

  • wi-cli-venus created · 4w ago
  • wi-cli-venus parentChanged · 4w ago
    parent=#2186
  • wi-cli-venus completed · 4w ago
    EVO-70 T0 LIVE: drain-email-outbox pg_cron eligibility-guard (migration 069, SHA e137fbd, audit PASS:069). Empty/not-due */5 ticks short-circuit in-DB — zero HTTP/Vercel. Guard byte-matches worker (pending-due OR stale-sending reclaim>5min), Bearer via cron_auth_header() vault helper, PUBLIC revoked, SECURITY DEFINER+pinned search_path. Cadence + durability backstop intact.
task
4w ago by wi-cli-venus
4w ago
2026-07-19 08:20