| From: | shihao zhong <zhong950419(at)gmail(dot)com> |
|---|---|
| To: | vignesh C <vignesh21(at)gmail(dot)com> |
| Cc: | pgsql-hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Robert Haas <robertmhaas(at)gmail(dot)com>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> |
| Subject: | Re: Hash index corruption and CLOG lookup errors from checkpoint races |
| Date: | 2026-11-04 14:59:38 |
| Message-ID: | CAGRkXqQfDL23mqZGGXogLca-VV3RXKLoBjkNv15K=EE9yyP7Kg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi Vignesh,
Thanks for the test and for trying the backport.
How did I miss your MultiXact case..... 0005 take care of it.
For the back branches I attached two versions of 0003. The one for 16
to 18 uses PageSetChecksumInplace(). The one for 14 and 15 also uses
rd_node.
I can send back-branch versions of 0005 once the master version looks
fine to people. 0001 to 0004 have no code changes.
Thanks,
Shihao
| Attachment | Content-Type | Size |
|---|---|---|
| v3-0003-Extend-hash-index-before-WAL-logging-new-bucket-page.patch | application/octet-stream | 3.2 KB |
| v3-0001-Advance-oldestXid-before-truncating-CLOG.patch | application/octet-stream | 3.8 KB |
| v3-0005-Advance-oldestMulti-before-WAL-logging-MultiXact-tru.patch | application/octet-stream | 2.4 KB |
| v3-0002-Add-test-for-a-checkpoint-that-starts-during-CLOG-tr.patch | application/octet-stream | 4.9 KB |
| v3-0004-Add-test-for-a-checkpoint-that-starts-during-hash-bu.patch | application/octet-stream | 9.2 KB |
| v3-0006-Add-test-for-a-checkpoint-that-starts-during-MultiXa.patch | application/octet-stream | 9.0 KB |
| v3-0003-REL_16-18-hash-extend-before-wal.patch.nocfbot | application/octet-stream | 3.3 KB |
| v3-0003-REL_14-15-hash-extend-before-wal.patch.nocfbot | application/octet-stream | 3.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Previous Message | Manu | 2026-11-04 14:57:49 | Re: PG19 regression in ecd9288624a: JSON_ARRAY() indexes that go stale |