Re: Snapshot export on a standby corrupts hint bits on subxact overflow - Mailing list pgsql-hackers

From Andrey Borodin
Subject Re: Snapshot export on a standby corrupts hint bits on subxact overflow
Date
Msg-id F4F5602C-4BB8-4374-AF71-157C9A33E370@yandex-team.ru
Whole thread
In response to Re: Snapshot export on a standby corrupts hint bits on subxact overflow  (Peter Geoghegan <pg@bowt.ie>)
List pgsql-hackers
Hi Peter,

On 26 Aug 2026, Peter Geoghegan wrote:
> Pushed.

While investigating foreign-key violations after failover, I found
tuples with HEAP_XMIN_INVALID set despite their xmin being committed.
pg_visibility reported them, but verify_heapam() did not.

I posted amcheck checks for this damage [0], including the xmax case.
Would it be worth backpatching the first patch in that series, to help
users find existing damage after installing new minors?

Thank you!


Best regards, Andrey Borodin.

[0] https://postgr.es/m/9B06CC00-4F0A-423F-94E4-E3AC1F8C40DF@yandex-team.ru



pgsql-hackers by date:

Previous
From: Andrey Borodin
Date:
Subject: Re: Compression of bigger WAL records
Next
From: Bertrand Drouvot
Date:
Subject: Re: WAL segment file descriptor leak on read errors can PANIC the server