Fix rare test failure in nbtree_half_dead_pages
Heikki Linnakangas <heikki.linnakangas@iki.fi>
Author:
Heikki Linnakangas <heikki.linnakangas@iki.fi>
Date: 2026-01-16T12:38:20Z
Releases:
19 (unreleased)
Fix rare test failure in nbtree_half_dead_pages If auto-analyze kicks in at just the right moment, it can hold a snapshot and prevent the VACUUM command in the test from removing the deleted tuples. The test needs the tuples to be removed, otherwise no half-dead page is generated. To fix, introduce a helper procedure to wait for the removable cutoff to advance, like the one used in the syscache-update-pruned test for similar purposes. Thanks to Alexander Lakhin for reproducing and analyzing the test failure, and Tom Lane for the report. Discussion: https://www.postgresql.org/message-id/307198.1767408023@sss.pgh.pa.us
Files
| Path | Change | +/− |
|---|---|---|
| src/test/modules/nbtree/expected/nbtree_half_dead_pages.out | modified | +23 −0 |
| src/test/modules/nbtree/sql/nbtree_half_dead_pages.sql | modified | +24 −0 |
Discussion
- Bug in amcheck? 13 messages · 2025-10-22 → 2026-01-16