aboutsummaryrefslogtreecommitdiff
path: root/src/bin/pg_verifybackup/t/002_algorithm.pl
diff options
context:
space:
mode:
authorMichael Paquier <michael@paquier.xyz>2024-09-27 09:40:09 +0900
committerMichael Paquier <michael@paquier.xyz>2024-09-27 09:40:09 +0900
commit09620ea09121b66e9372e8e9244d8bb6b19b89d7 (patch)
tree00d500a4599b175198edc8bc9ad9b9d8d2503b3e /src/bin/pg_verifybackup/t/002_algorithm.pl
parentf762d99c8783f5ca99d5a6ab0f8245e164a954ce (diff)
downloadpostgresql-09620ea09121b66e9372e8e9244d8bb6b19b89d7.tar.gz
postgresql-09620ea09121b66e9372e8e9244d8bb6b19b89d7.zip
Fix incorrect memory access in VACUUM FULL with invalid toast indexes
An invalid toast index is skipped in reindex_relation(). These would be remnants of a failed REINDEX CONCURRENTLY and they should never been rebuilt as there can only be one valid toast index at a time. REINDEX_REL_SUPPRESS_INDEX_USE, used by CLUSTER and VACUUM FULL, needs to maintain a list of the indexes being processed. The list of indexes is retrieved from the relation cache, and includes invalid indexes. The code has missed that invalid toast indexes are ignored in reindex_relation() as this leads to a hard failure in reindex_index(), and they were left in the reindex pending list, making the list inconsistent when rechecked. The incorrect memory access was happening when scanning pg_class for the refresh of pg_database.datfrozenxid, when doing a scan of pg_class. This issue exists since REINDEX CONCURRENTLY exists, where invalid toast indexes can exist, so backpatch all the way down. Reported-by: Alexander Lakhin Author: Tender Wang Discussion: https://postgr.es/m/18630-9aed99c38830657d@postgresql.org Backpatch-through: 12
Diffstat (limited to 'src/bin/pg_verifybackup/t/002_algorithm.pl')
0 files changed, 0 insertions, 0 deletions