diff options
| author | Heikki Linnakangas <heikki.linnakangas@iki.fi> | 2024-06-27 21:06:32 +0300 |
|---|---|---|
| committer | Heikki Linnakangas <heikki.linnakangas@iki.fi> | 2024-06-27 21:10:34 +0300 |
| commit | 9dbf8ab48c21f9a006e578983b21739326d7c621 (patch) | |
| tree | 4141098290e16d0e6bd993e0ccbe14caac2c21e0 /src/backend/utils/adt/xml.c | |
| parent | 34221af648f1b5b2aaa5c1814e692ec98063ba52 (diff) | |
| download | postgresql-9dbf8ab48c21f9a006e578983b21739326d7c621.tar.gz postgresql-9dbf8ab48c21f9a006e578983b21739326d7c621.zip | |
Fix MVCC bug with prepared xact with subxacts on standby
We did not recover the subtransaction IDs of prepared transactions
when starting a hot standby from a shutdown checkpoint. As a result,
such subtransactions were considered as aborted, rather than
in-progress. That would lead to hint bits being set incorrectly, and
the subtransactions suddenly becoming visible to old snapshots when
the prepared transaction was committed.
To fix, update pg_subtrans with prepared transactions's subxids when
starting hot standby from a shutdown checkpoint. The snapshots taken
from that state need to be marked as "suboverflowed", so that we also
check the pg_subtrans.
Backport to all supported versions.
Discussion: https://www.postgresql.org/message-id/6b852e98-2d49-4ca1-9e95-db419a2696e0@iki.fi
Diffstat (limited to 'src/backend/utils/adt/xml.c')
0 files changed, 0 insertions, 0 deletions