On Tue, Aug 28, 2018 at 2:51 PM Peter Eisentraut <peter.eisentr...@2ndquadrant.com> wrote: > > This is reproducible with PG11 and PG12: > > initdb -k data > postgres -D data > > make installcheck > # shut down postgres with Ctrl-C > .. > > The files in question correspond to > > hash_i4_index > hash_name_index > hash_txt_index >
I have looked into this problem and found the cause of it. This problem is happening for the empty page in the hash index. On a split, we allocate a new splitpoint's worth of bucket pages wherein we initialize the last page with zero's, this is all fine, but we forgot to set the checksum for that last page. Attached patch fixes the problem for me. Can someone try and share their findings? -- With Regards, Amit Kapila. EnterpriseDB: http://www.enterprisedb.com
setchecksum_empty_pages_v1.patch
Description: Binary data