Re: lastOverflowedXid does not handle transaction ID wraparound

x4mmm@yandex-team.ru

From: Andrey Borodin <x4mmm@yandex-team.ru>

To: Dmitry Dolgov <9erthalion6@gmail.com>

Cc: Stan Hu <stanhu@gmail.com>, Pg Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2021-10-20T11:00:35Z

Lists: pgsql-hackers


> 17 окт. 2021 г., в 21:55, Dmitry Dolgov <9erthalion6@gmail.com> написал(а):
> I wonder what would be side
> effects of clearing it when the snapshot is not suboverfloved anymore?

I think we should just invalidate lastOverflowedXid on every XLOG_RUNNING_XACTS if subxid_overflow == false. I can't find a reason not to do so.

Best regards, Andrey Borodin.

Commits

Reset lastOverflowedXid on standby when needed
- 05e6e78c1840 15.0 landed
- b0f6bd48f35d 14.1 landed
- 7381b79ade47 9.6.24 landed
- 774d00573966 10.19 landed
- 691c0df73a74 11.14 landed
- 8f779a1a3eb6 12.9 landed
- e1fee28a0441 13.5 landed
Fix variable shadowing in procarray.c.
- dc899146dbf0 15.0 cited
Move InRecovery and standbyState global vars to xlogutils.c.
- 317632f3073f 15.0 cited