Re: Failures with wal_consistency_checking and 13~
Alexander Korotkov <a.korotkov@postgrespro.ru>
From: Alexander Korotkov <a.korotkov@postgrespro.ru>
To: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Postgres hackers <pgsql-hackers@lists.postgresql.org>, Michael Paquier <michael@paquier.xyz>
Date: 2020-06-20T10:16:52Z
Lists: pgsql-hackers
On Fri, Jun 19, 2020 at 10:34 PM Alvaro Herrera <alvherre@2ndquadrant.com> wrote: > > 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? I don't have idea yet, but I'll check this out ------ Regards, Alexander Korotkov
Commits
-
Fix masking of SP-GiST pages during xlog consistency check
- 39aafc88c4b4 13.0 landed
- 3f88e2d78dbe 11.9 landed
- 396a44a01536 12.4 landed
- a44dd932ff38 14.0 landed