| From: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
|---|---|
| To: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | pg_verify_checksums failure with hash indexes |
| Date: | 2018-08-28 09:21:34 |
| Message-ID: | 5d03686d-727c-dbf8-0064-bf8b97ffe850@2ndquadrant.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | hubert depesz lubaczewski | 2018-08-28 09:38:13 | Re: Would it be possible to have parallel archiving? |
| Previous Message | Andres Freund | 2018-08-28 07:52:13 | Re: buildfarm: could not read block 3 in file "base/16384/2662": read only 0 of 8192 bytes |