aboutsummaryrefslogtreecommitdiff
path: root/src/bin/pg_verifybackup/t/002_algorithm.pl
diff options
context:
space:
mode:
authorNathan Bossart <nathan@postgresql.org>2024-09-26 15:51:23 -0500
committerNathan Bossart <nathan@postgresql.org>2024-09-26 15:51:23 -0500
commitb52adbad46740524cbfbffaeb202b01a2c16202a (patch)
tree329f4423c29e64f9fa9db9a1c97daac543d54258 /src/bin/pg_verifybackup/t/002_algorithm.pl
parent9726653185de62f2f8bf42a25e961bc56895a41b (diff)
downloadpostgresql-b52adbad46740524cbfbffaeb202b01a2c16202a.tar.gz
postgresql-b52adbad46740524cbfbffaeb202b01a2c16202a.zip
Ensure we have a snapshot when updating pg_index entries.
Creating, reindexing, and dropping an index concurrently could entail accessing pg_index's TOAST table, which was recently added in commit b52c4fc3c0. These code paths start and commit their own transactions, but they do not always set an active snapshot. This rightfully leads to assertion failures and ERRORs when trying to access pg_index's TOAST table, such as the following: ERROR: cannot fetch toast data without an active snapshot To fix, push an active snapshot just before each section of code that might require accessing pg_index's TOAST table, and pop it shortly afterwards. Reported-by: Alexander Lakhin Reviewed-by: Michael Paquier Discussion: https://postgr.es/m/a97d7401-e7c9-f771-6a00-037379f0a8bb%40gmail.com
Diffstat (limited to 'src/bin/pg_verifybackup/t/002_algorithm.pl')
0 files changed, 0 insertions, 0 deletions