Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nlxBL-0000TF-1t for pgsql-hackers@arkaria.postgresql.org; Tue, 03 May 2022 18:23:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nlxBJ-0006At-Kn for pgsql-hackers@arkaria.postgresql.org; Tue, 03 May 2022 18:23:29 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nlxBJ-00067u-B0 for pgsql-hackers@lists.postgresql.org; Tue, 03 May 2022 18:23:29 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nlxBH-0003dd-50 for pgsql-hackers@postgresql.org; Tue, 03 May 2022 18:23:28 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 243INNj72174976; Tue, 3 May 2022 14:23:23 -0400 From: Tom Lane To: Andres Freund cc: Robert Haas , pgsql-hackers@postgresql.org, Thomas Munro Subject: Re: failures in t/031_recovery_conflict.pl on CI In-reply-to: <20220503182025.wvbebs2ojk6vpi5f@alap3.anarazel.de> References: <5111.1649547266@sss.pgh.pa.us> <20220412184913.3wrt4olkdiqvicsj@alap3.anarazel.de> <907760.1649790322@sss.pgh.pa.us> <20220413002626.udl7lll7f3o7nre7@alap3.anarazel.de> <20220429200809.uuuseakmhb57sppk@alap3.anarazel.de> <465685.1651274819@sss.pgh.pa.us> <20220503014803.uknu3cwahwhbgrak@alap3.anarazel.de> <1929823.1651549472@sss.pgh.pa.us> <20220503040557.eimbfibv4rsey3s5@alap3.anarazel.de> <1959496.1651555006@sss.pgh.pa.us> <20220503182025.wvbebs2ojk6vpi5f@alap3.anarazel.de> Comments: In-reply-to Andres Freund message dated "Tue, 03 May 2022 11:20:25 -0700" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <2174974.1651602203.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Tue, 03 May 2022 14:23:23 -0400 Message-ID: <2174975.1651602203@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Andres Freund writes: > On 2022-05-03 01:16:46 -0400, Tom Lane wrote: >> Irritatingly, it doesn't reproduce (at least not easily) in a manual >> build on the same box. > Odd, given how readily it seem to reproduce on the bf. I assume you buil= t with >> Uses -fsanitize=3Dalignment -DWRITE_READ_PARSE_PLAN_TREES -DSTRESS_SORT= _INT_MIN -DENFORCE_REGRESSION_TEST_NAME_RESTRICTIONS Yeah, I copied all that stuff ... >> So it's almost surely a timing issue, and your theory here seems plausi= ble. > Unfortunately I don't think my theory holds, because I actually had adde= d a > defense against this into the test that I forgot about momentarily... Oh, hm. I can try harder to repro it. regards, tom lane