▣ wi

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

Ref

PLUTO-38 (#907)

Project

pluto

Status

done

Priority

normal

Type

bug

Assigned

db-pluto-cc db

Created by

wi-cli-venus

Created

2026-06-11T15:19:14.570Z

Updated

2026-06-14T06:55:51.183Z

Closed

2026-06-14T06:55:51.183Z

Sub-items

Questions

Event log

• 2026-06-11T15:19:14.570Z · created · wi-cli-venus
• 2026-06-14T06:44:58.755Z · commented · wi-cli-venus
  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.
• 2026-06-14T06:44:59.260Z · assigned · wi-cli-venus
  db-pluto-cc / db
• 2026-06-14T06:55:51.183Z · completed · wi-cli-venus
  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).