Re: pg_verify_checksums failure with hash indexes

On Tue, Aug 28, 2018 at 2:51 PM Peter Eisentraut
<peter(dot)eisentraut(at)2ndquadrant(dot)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