pgsql: Compare Xmin to previous Xmax when locking an update chain - Mailing list pgsql-committers

From Alvaro Herrera
Subject pgsql: Compare Xmin to previous Xmax when locking an update chain
Date
Msg-id E1Vm36s-00022l-LK@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Compare Xmin to previous Xmax when locking an update chain

Not doing so causes us to traverse an update chain that has been broken
by concurrent page pruning.  All other code that traverses update chains
uses this check as one of the cases in which to stop iterating, so
replicate it here too.  Failure to do so leads to erroneous CLOG,
subtrans or multixact lookups.

Per discussion following the bug report by J Smith in
CADFUPgc5bmtv-yg9znxV-vcfkb+JPRqs7m2OesQXaM_4Z1JpdQ@mail.gmail.com
as diagnosed by Andres Freund.

Branch
------
REL9_3_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/2a4b6eed0916a8fdc57b4778ecb1463fe752d369

Modified Files
--------------
src/backend/access/heap/heapam.c |   14 ++++++++++++++
1 file changed, 14 insertions(+)


pgsql-committers by date:

Previous
From: Alvaro Herrera
Date:
Subject: pgsql: Cope with heap_fetch failure while locking an update chain
Next
From: Alvaro Herrera
Date:
Subject: pgsql: Compare Xmin to previous Xmax when locking an update chain