Re: [HACKERS] "inconsistent page found" with checksum andwal_consistency_checking enabled - Mailing list pgsql-hackers

From Kuntal Ghosh
Subject Re: [HACKERS] "inconsistent page found" with checksum andwal_consistency_checking enabled
Date
Msg-id CAGz5QCKgTpkNu3fW=O-ihZ5X9cvpxCPNnGsdJfGq5Q5K_MqOpw@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] "inconsistent page found" with checksum andwal_consistency_checking enabled  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: [HACKERS] "inconsistent page found" with checksum andwal_consistency_checking enabled
List pgsql-hackers
On Wed, Sep 20, 2017 at 10:22 AM, Michael Paquier
<michael.paquier@gmail.com> wrote:
> On Wed, Sep 20, 2017 at 5:23 AM, Ashwin Agrawal <aagrawal@pivotal.io> wrote:
>> 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".
>
> Indeed. This had better be fixed before PG10 is out. I am adding an open item.
>
Oops and surprised! How come we missed that previously. If page lsns
are different, checksums will be different as well. Anyhow, nice catch
and thanks for the patch.


-- 
Thanks & Regards,
Kuntal Ghosh
EnterpriseDB: http://www.enterprisedb.com


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

pgsql-hackers by date:

Previous
From: Craig Ringer
Date:
Subject: [HACKERS] Utilities for quoting literals and identifiers in Pg TAP tests
Next
From: Andrey Borodin
Date:
Subject: Re: [HACKERS] Index Only Scan support for cube