pg_cron pluto-drain-email-outbox fails 674/674: schema "net" does not exist (pg_net not installed)

Sub-tickets

Questions

Activity

• wi-cli-venus created · 2026-06-11
• wi-cli-venus commented · 2026-06-14
  db PLUTO-123 sweep finding: pluto-drain-email-outbox pg_cron fires every 5min calling net.http_get but pg_net is NOT installed (installed_version=null) -> 'schema net does not exist' every 5min in postgres logs. Email sends ARE succeeding via the direct path (sendAdminEmail/Resend) per appEvents, so the outbox cron appears VESTIGIAL. RESOLVE: confirm direct-send is the live path, then DROP the dead cron to clear the recurring noise (zero-noise baseline) OR install pg_net if the outbox was the intended path. Pre-apply audit for the DDL. Routed to db.
• wi-cli-venus assigned · 2026-06-14
  db-pluto-cc / db
• wi-cli-venus completed · 2026-06-14
  Dead drain-email-outbox pg_cron dropped (migration 030, ccb7417/v1.69.50, combined PTD PASS:53624c5). 'schema net does not exist' every-5min noise eliminated; verified 0 rows in cron.job. Email happy-path = Next.js after()-hook (cron never functioned, pg_net absent). Retry/failure-alert backstop gap → PLUTO-126 (backlog, db).