| From: | Andrey Borodin <x4mmm(at)yandex-team(dot)ru> |
|---|---|
| To: | Peter Geoghegan <pg(at)bowt(dot)ie> |
| Cc: | Bertrand Drouvot <bertranddrouvot(dot)pg(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Andres Freund <andres(at)anarazel(dot)de>, scott(at)scottray(dot)io |
| Subject: | Re: Snapshot export on a standby corrupts hint bits on subxact overflow |
| Date: | 2026-10-08 06:27:01 |
| Message-ID: | F4F5602C-4BB8-4374-AF71-157C9A33E370@yandex-team.ru |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bertrand Drouvot | 2026-10-08 06:55:23 | Re: WAL segment file descriptor leak on read errors can PANIC the server |
| Previous Message | Andrey Borodin | 2026-10-08 06:20:35 | Re: Compression of bigger WAL records |