Horton

Reset lastOverflowedXid on standby when needed

Alexander Korotkov <akorotkov@postgresql.org>

View on postgr.es
Commit: 8f779a1a3eb6716faf47ef10e7bf0b883b8a1170
Author: Alexander Korotkov <akorotkov@postgresql.org>
Date: 2021-11-06T15:34:21Z
Releases: 12.9 
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

Files

PathChange+/−
src/backend/storage/ipc/procarray.c modified +19 −2

Discussion