]> git.ipfire.org Git - thirdparty/postgresql.git/commit
nbtree VACUUM: cope with topparent inconsistencies.
authorPeter Geoghegan <pg@bowt.ie>
Thu, 22 Jun 2023 00:41:50 +0000 (17:41 -0700)
committerPeter Geoghegan <pg@bowt.ie>
Thu, 22 Jun 2023 00:41:50 +0000 (17:41 -0700)
commit355917c07c633ab00e41c91eef262b3e438a63e4
treed1a47144c8714e14e140cb2f0fa9b211e93a4454
parent9b4c44fef81918393fd2e770867041601d9a40c2
nbtree VACUUM: cope with topparent inconsistencies.

Avoid "right sibling %u of block %u is not next child" errors when
vacuuming a corrupt nbtree index.  Just LOG the issue and press on.
That way VACUUM will have a decent chance of finishing off all required
processing for the index (and for the table as a whole).

This is similar to recent work from commit 5abff197, as well as work
from commit 5b861baa (later backpatched as commit 43e409ce), which
taught nbtree VACUUM to keep going when its "re-find" check fails.  The
hardening added by this commit takes place directly after the "re-find"
check, right before the critical section for the first stage of page
deletion.

Author: Peter Geoghegan <pg@bowt.ie>
Discussion: https://postgr.es/m/CAH2-Wz=dayg0vjs4+er84TS9ami=csdzjpuiCGbEw=idhwqhzQ@mail.gmail.com
Backpatch: 11- (all supported versions).
src/backend/access/nbtree/nbtpage.c