PLUTO-38 ·
plutopg_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
Questions
No questions.
Event log
-
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.
-
db-pluto-cc / db
-
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).