From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
To: pgsql-hackers <pgsql-hackers@postgresql.org>
Subject: pg_verify_checksums failure with hash indexes
Date: Tue, 28 Aug 2018 11:21:34 +0200
Message-ID: <5d03686d-727c-dbf8-0064-bf8b97ffe850@2ndquadrant.com> (raw)
This is reproducible with PG11 and PG12:
initdb -k data
postgres -D data
make installcheck
# shut down postgres with Ctrl-C
pg_verify_checksums data
pg_verify_checksums: checksum verification failed in file
"data/base/16384/28647", block 65: calculated checksum DC70 but expected 0
pg_verify_checksums: checksum verification failed in file
"data/base/16384/28649", block 65: calculated checksum 89D8 but expected 0
pg_verify_checksums: checksum verification failed in file
"data/base/16384/28648", block 65: calculated checksum 9636 but expected 0
Checksum scan completed
Data checksum version: 1
Files scanned: 2493
Blocks scanned: 13172
Bad checksums: 3
The files in question correspond to
hash_i4_index
hash_name_index
hash_txt_index
Discuss. ;-)
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: peter.eisentraut@2ndquadrant.com
Subject: Re: pg_verify_checksums failure with hash indexes
In-Reply-To: <5d03686d-727c-dbf8-0064-bf8b97ffe850@2ndquadrant.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox