pg_verify_checksums failure with hash indexes

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема pg_verify_checksums failure with hash indexes
Дата
Msg-id 5d03686d-727c-dbf8-0064-bf8b97ffe850@2ndquadrant.com
обсуждение исходный текст
Ответы Re: pg_verify_checksums failure with hash indexes  (Michael Banck <michael.banck@credativ.de>)
Re: pg_verify_checksums failure with hash indexes  (Michael Paquier <michael@paquier.xyz>)
Re: pg_verify_checksums failure with hash indexes  (Bernd Helmle <mailings@oopsware.de>)
Re: pg_verify_checksums failure with hash indexes  (Amit Kapila <amit.kapila16@gmail.com>)
Список 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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: buildfarm: could not read block 3 in file "base/16384/2662":read only 0 of 8192 bytes
Следующее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: Would it be possible to have parallel archiving?