From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andres Freund <andres@anarazel.de>
Cc: Michael Paquier <michael.paquier@gmail.com>
Cc: Thomas Munro <thomas.munro@gmail.com>
Cc: Stephen Frost <sfrost@snowman.net>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: David Steele <david@pgmasters.net>
Cc: Dmitry Dolgov <9erthalion6@gmail.com>
Cc: Jakub Wartak <Jakub.Wartak@tomtom.com>
Cc: Tomas Vondra <tomas.vondra@enterprisedb.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Subject: Re: WIP: WAL prefetch (another approach)
Date: Wed, 28 Apr 2021 23:39:38 -0400
Message-ID: <2958651.1619667578@sss.pgh.pa.us> (raw)
In-Reply-To: <20210429031409.quuhyjihk6hqbloe@alap3.anarazel.de>
References: <CAOuzzgrn7iKnFRsB4MHp3UisEQAGgZMbk_ViTN4HV4-Ksq8zCg@mail.gmail.com>
<892344.1619054465@sss.pgh.pa.us>
<CA+hUKGJKKh8TbA+6977zK5TKUSsTspBHsr0s4S42q7ynkxcPGQ@mail.gmail.com>
<20210428163245.ff67pb2ii5irr5zr@alap3.anarazel.de>
<2808045.1619628335@sss.pgh.pa.us>
<CA+hUKGJ03Q-TmE8-JzAm04_1maYus6_kX7XB--JBh1K63agSbQ@mail.gmail.com>
<2947529.1619652293@sss.pgh.pa.us>
<20210429001224.cdkef4ybkw7gramv@alap3.anarazel.de>
<2949950.1619655883@sss.pgh.pa.us>
<20210429005922.ftonkkpijkhhlazf@alap3.anarazel.de>
<20210429031409.quuhyjihk6hqbloe@alap3.anarazel.de>
Andres Freund <andres@anarazel.de> writes:
> I was now able to reproduce the problem again, and I'm afraid that the
> bug I hit is likely separate from Tom's.
Yeah, I think so --- the symptoms seem quite distinct.
My score so far today on the G4 is:
12 error-free regression test cycles on b3ee4c503
(plus one more with shared_buffers set to 16MB, on the strength
of your previous hunch --- didn't fail for me though)
HEAD failed on the second run with the same symptom as before:
2021-04-28 22:57:17.048 EDT [50479] FATAL: inconsistent page found, rel 1663/58183/69545, forknum 0, blkno 696
2021-04-28 22:57:17.048 EDT [50479] CONTEXT: WAL redo at 4/B72D408 for Heap/INSERT: off 77 flags 0x00; blkref #0: rel 1663/58183/69545, blk 696 FPW
This seems to me to be pretty strong evidence that I'm seeing *something*
real. I'm currently trying to isolate a specific commit to pin it on.
A straight "git bisect" isn't going to work because so many people had
broken so many different things right around that date :-(, so it may
take awhile to get a good answer.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: tgl@sss.pgh.pa.us, andres@anarazel.de, michael.paquier@gmail.com, thomas.munro@gmail.com, sfrost@snowman.net, alvherre@2ndquadrant.com, david@pgmasters.net, 9erthalion6@gmail.com, Jakub.Wartak@tomtom.com, tomas.vondra@enterprisedb.com
Subject: Re: WIP: WAL prefetch (another approach)
In-Reply-To: <2958651.1619667578@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox