Re: Failures with wal_consistency_checking and 13~

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>
Cc: Postgres hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Michael Paquier <michael(at)paquier(dot)xyz>
Subject: Re: Failures with wal_consistency_checking and 13~
Date: 2020-06-19 19:33:49
Message-ID: 20200619193349.GA21437@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2020-Jun-15, Michael Paquier wrote:

> I have begun my annual study of WAL consistency across replays, and
> wal_consistency_checking = 'all' is pointing out at some issues with
> at least VACUUM and SPGist:
> FATAL: inconsistent page found, rel 1663/16385/22133, forknum 0,
> blkno 15
> CONTEXT: WAL redo at 0/739CEDE8 for SPGist/VACUUM_REDIRECT: newest
> XID 4619
>
> It may be possible that there are other failures, I have just run
> installcheck and this is the first failure I saw after replaying all
> the generated WAL on a standby. Please note that I have also checked
> 12, and installcheck passes.

Umm. Alexander, do you an idea of what this is about?

--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2020-06-19 19:41:21 Re: More tzdb fun: POSIXRULES is being deprecated upstream
Previous Message Tom Lane 2020-06-19 19:27:41 Re: More tzdb fun: POSIXRULES is being deprecated upstream