]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Reset lastOverflowedXid on standby when needed
authorAlexander Korotkov <akorotkov@postgresql.org>
Sat, 6 Nov 2021 15:31:21 +0000 (18:31 +0300)
committerAlexander Korotkov <akorotkov@postgresql.org>
Sat, 6 Nov 2021 15:34:23 +0000 (18:34 +0300)
commit691c0df73a74786b1704b806132006a5754dff32
treef111022470fc2739248b8784d30040e36808d2fd
parent92224e470c830e73636de20689690f28037cd019
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
src/backend/storage/ipc/procarray.c