Failures with wal_consistency_checking and 13~

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Postgres hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Failures with wal_consistency_checking and 13~
Date: 2020-06-15 13:14:05
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Hi all,

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.



Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2020-06-15 13:29:41 Failures with installcheck and low work_mem value in 13~
Previous Message Ranier Vilela 2020-06-15 13:03:56 Re: Postgresql13_beta1 (could not rename temporary statistics file) Windows 64bits