[HACKERS] "inconsistent page found" with checksum and wal_consistency_checking enabled

Поиск
Список
Период
Сортировка
От Ashwin Agrawal
Тема [HACKERS] "inconsistent page found" with checksum and wal_consistency_checking enabled
Дата
Msg-id CALfoeis5iqrAU-+JAN+ZzXkpPr7+-0OAGv7QUHwFn=-wDy4o4Q@mail.gmail.com
обсуждение исходный текст
Ответы Re: [HACKERS] "inconsistent page found" with checksum andwal_consistency_checking enabled  (Michael Paquier <michael.paquier@gmail.com>)
Список pgsql-hackers
Дерево обсуждения

Currently, page checksum is not masked by Page masking routines used by wal_consistency_checking facility. So, when running `make installcheck` with data checksum enabled and wal_consistency_checking='all', it easily and consistently FATALs with "inconsistent page found".

If anything needs to be masked on Page to perform / pass wal consistency checking, definitely checksum is not going to match and hence must be masked as well. Attaching patch to fix the same, installcheck passes with checksums enabled and wal_consistency_checking='all' with the fix.

Clubbed to perform the masking with lsn as it sounds logical to have them together, as lsn is masked is all the cases so far and such is needed for checksum as well.

Thank You,
Ashwin Agrawal
Вложения

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

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Re: [HACKERS] why not parallel seq scan for slow functions
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: [HACKERS] Boom filters for hash joins (was: A design for amcheckheapam verification)