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 1oGPKG-0000NV-TO for pgsql-hackers@arkaria.postgresql.org; Tue, 26 Jul 2022 18:30:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oGPKF-0006ne-Gz for pgsql-hackers@arkaria.postgresql.org; Tue, 26 Jul 2022 18:30:35 +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 1oGPKF-0006nV-6G for pgsql-hackers@lists.postgresql.org; Tue, 26 Jul 2022 18:30:35 +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 1oGPKD-0000Fs-0h for pgsql-hackers@lists.postgresql.org; Tue, 26 Jul 2022 18:30:34 +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 26QIUUR52468551; Tue, 26 Jul 2022 14:30:30 -0400 From: Tom Lane To: Andres Freund cc: Thomas Munro , Melanie Plageman , pgsql-hackers@lists.postgresql.org Subject: Re: Unstable tests for recovery conflict handling In-reply-to: <20220726181611.4xw3blxigqzsz4d4@alap3.anarazel.de> References: <394950.1651077914@sss.pgh.pa.us> <447238.1651082925@sss.pgh.pa.us> <2454340.1658858273@sss.pgh.pa.us> <20220726181611.4xw3blxigqzsz4d4@alap3.anarazel.de> Comments: In-reply-to Andres Freund message dated "Tue, 26 Jul 2022 11:16:11 -0700" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <2468549.1658860230.1@sss.pgh.pa.us> Date: Tue, 26 Jul 2022 14:30:30 -0400 Message-ID: <2468550.1658860230@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-07-26 13:57:53 -0400, Tom Lane wrote: >> So this is not a case of RecoveryConflictInterrupt doing the wrong thing: >> the startup process hasn't detected the buffer conflict in the first >> place. > I wonder if this, at least partially, could be be due to the elog thing > I was complaining about nearby. I.e. we decide to FATAL as part of a > recovery conflict interrupt, and then during that ERROR out as part of > another recovery conflict interrupt (because nothing holds interrupts as > part of FATAL). There are all sorts of things one could imagine going wrong in the backend receiving the recovery conflict interrupt, but AFAICS in these failures, the startup process hasn't sent a recovery conflict interrupt. It certainly hasn't logged anything suggesting it noticed a conflict. regards, tom lane