Postgres logs an error every 30 seconds for the old DeadAir table #196

New Issue

rays · 2026-10-11T13:09:31-07:00

rays commented

2026-10-11 13:09:31 -07:00

Every ipx command, the healthcheck's ipx status included, runs create_missing in src/db.rs, which still tries the one-time clean-up of the DeadAir copies from before #181: SELECT path FROM deadair WHERE path IS NOT NULL, treating failure as "already done". The table is gone in production, so the query fails each time and Postgres logs ERROR: relation "deadair" does not exist with the statement: 120 in the last hour (docker logs --since 1h postgres | grep -c 'relation "deadair"'), about 2,900 a day, in a log other apps share. Found by the ponytail audit of [Unreleased] on 2026-10-11 and confirmed in the prod check of the same day. Production has run the clean-up (no copies left), and it is the only database, so the block and its test deadair_drops_its_old_copies_once can go.

Every `ipx` command, the healthcheck's `ipx status` included, runs `create_missing` in src/db.rs, which still tries the one-time clean-up of the DeadAir copies from before #181: `SELECT path FROM deadair WHERE path IS NOT NULL`, treating failure as "already done". The table is gone in production, so the query fails each time and Postgres logs `ERROR: relation "deadair" does not exist` with the statement: 120 in the last hour (`docker logs --since 1h postgres | grep -c 'relation "deadair"'`), about 2,900 a day, in a log other apps share. Found by the ponytail audit of [Unreleased] on 2026-10-11 and confirmed in the prod check of the same day. Production has run the clean-up (no copies left), and it is the only database, so the block and its test `deadair_drops_its_old_copies_once` can go.

rays added the bug label 2026-10-11 13:09:31 -07:00

rays referenced this issue from a commit

2026-10-11 13:12:25 -07:00

Drop the spent DeadAir clean-up and keep not-due skips off live updates (#196, #197)

rays commented

2026-10-11 13:14:11 -07:00

Fixed in 12fadbd: the clean-up of DeadAir's old copies and its test are gone. Deployed at 20:13 UTC; the last relation "deadair" does not exist in Postgres's log was at 20:13:04, before the new daemon started, and none since.

Fixed in 12fadbd: the clean-up of DeadAir's old copies and its test are gone. Deployed at 20:13 UTC; the last `relation "deadair" does not exist` in Postgres's log was at 20:13:04, before the new daemon started, and none since.

rays closed this issue

2026-10-11 13:14:12 -07:00

Sign in to join this conversation.

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: rays/ipx#196