Re: False "pg_serial": apparent wraparound” in logs

Michael Paquier <michael@paquier.xyz>

From: Michael Paquier <michael@paquier.xyz>
To: "Imseih (AWS), Sami" <simseih@amazon.com>
Cc: Heikki Linnakangas <hlinnaka@iki.fi>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2023-10-10T07:20:07Z
Lists: pgsql-hackers
On Thu, Oct 05, 2023 at 11:28:02PM +0000, Imseih (AWS), Sami wrote:
> I spent sometime studying this and it appears to be a good approach. 
> 
> Passing the cutoff page as headPage (SLRU not needed code path ) instead of the tailPage to 
> SimpleLruTruncate is already being done when the tailXid is not a valid XID. 
> I added an additional condition to make sure that the tailPage proceeds the headPage
> as well. 
> 
> Attached is v2 of the patch.

Thanks for the updated patch.  I have begun looking at what you have
here.
--
Michael

Commits

  1. Improve truncation of pg_serial/, removing "apparent wraparound" LOGs