]> 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 16:13:58 +0000 (19:13 +0300)
commit05e6e78c1840d07154a4b52092178a2d1ad39445
tree333aef49f2fa8a1924d8638bff3829038d72b0c6
parentd8bf0a1c1d3429cafb3019f2773e2f3aa68f3b65
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