From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andres Freund <andres@anarazel.de>
cc: Noah Misch <noah@leadboat.com>, Peter Geoghegan <pg@bowt.ie>,
        David Rowley <dgrowleyml@gmail.com>,
        PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Subject: Re: Intermittent buildfarm failures on wrasse
In-reply-to: <1521388.1649953580@sss.pgh.pa.us>
References: <1364997.1649893086@sss.pgh.pa.us>
 <CAH2-WzkUGqFNXhnFRbVG4xfTo3WpapcdRaH4hQSTrNvDgYvYoQ@mail.gmail.com>
 <1365924.1649893883@sss.pgh.pa.us>
 <CAH2-Wzn2Obp90oyZa5HN26rzG8ozzHM3dgkpLcsVzxTR+jK5NQ@mail.gmail.com>
 <1374062.1649896550@sss.pgh.pa.us>
 <20220414010505.s7z24jxrfsjbzz7l@alap3.anarazel.de>
 <1401379.1649899392@sss.pgh.pa.us>
 <20220414015112.yhruzx3dbjnz4pji@alap3.anarazel.de>
 <20220414025122.GA808845@rfd.leadboat.com> <1486022.1649952083@sss.pgh.pa.us>
 <20220414161850.ibqkevxcv6a7vdxg@alap3.anarazel.de>
 <1521388.1649953580@sss.pgh.pa.us>
Comments: In-reply-to Tom Lane <tgl@sss.pgh.pa.us>
	message dated "Thu, 14 Apr 2022 12:26:20 -0400"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1547911.1649971995.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Thu, 14 Apr 2022 17:33:15 -0400
Message-ID: <1547912.1649971995@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/1547912.1649971995%40sss.pgh.pa.us>
Precedence: bulk

I wroteL
> Andres Freund <andres@anarazel.de> writes:
>> Thanks! Can you repro the problem manually on wrasse, perhaps even
>> outside the buildfarm script?

> I'm working on that right now, actually...

So far, reproducing it manually has been a miserable failure: I've
run about 180 cycles of the core regression tests with no error.
Not sure what's different between my test scenario and wrasse's.

Meanwhile, wrasse did fail with my relallvisible check in place [1],
and what that shows is that relallvisible is *zero* to start with
and remains so throughout the CREATE INDEX sequence.  That pretty
definitively proves that it's not a page-skipping problem but
an xmin-horizon-too-old problem.  We're no closer to understanding
where that horizon value is coming from, though.

			regards, tom lane

[1] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=3Dwrasse&dt=3D=
2022-04-14%2019%3A28%3A12