pgsql: Reset lastOverflowedXid on standby when needed - Mailing list pgsql-committers

From Alexander Korotkov
Subject pgsql: Reset lastOverflowedXid on standby when needed
Date
Msg-id E1mjOK8-0000J5-Tb@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Reset lastOverflowedXid on standby when needed

Currently, lastOverflowedXid is never reset.  It's just adjusted on new
transactions known to be overflowed.  But if there are no overflowed
transactions for a long time, snapshots could be mistakenly marked as
suboverflowed due to wraparound.

This commit fixes this issue by resetting lastOverflowedXid when needed
altogether with KnownAssignedXids.

Backpatch to all supported versions.

Reported-by: Stan Hu
Discussion: https://postgr.es/m/CAMBWrQ%3DFp5UAsU_nATY7EMY7NHczG4-DTDU%3DmCvBQZAQ6wa2xQ%40mail.gmail.com
Author: Kyotaro Horiguchi, Alexander Korotkov
Reviewed-by: Stan Hu, Simon Riggs, Nikolay Samokhvalov, Andrey Borodin, Dmitry Dolgov

Branch
------
REL_11_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/691c0df73a74786b1704b806132006a5754dff32

Modified Files
--------------
src/backend/storage/ipc/procarray.c | 21 +++++++++++++++++++--
1 file changed, 19 insertions(+), 2 deletions(-)


pgsql-committers by date:

Previous
From: Alexander Korotkov
Date:
Subject: pgsql: Reset lastOverflowedXid on standby when needed
Next
From: Alexander Korotkov
Date:
Subject: pgsql: Reset lastOverflowedXid on standby when needed