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 1njsvj-0006HD-Cd for pgsql-hackers@arkaria.postgresql.org; Thu, 28 Apr 2022 01:26:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1njsvi-0001VZ-2J for pgsql-hackers@arkaria.postgresql.org; Thu, 28 Apr 2022 01:26:50 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1njsvg-0001VN-Cz for pgsql-hackers@lists.postgresql.org; Thu, 28 Apr 2022 01:26:49 +0000 Received: from out5-smtp.messagingengine.com ([66.111.4.29]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1njsvY-000438-2v for pgsql-hackers@lists.postgresql.org; Thu, 28 Apr 2022 01:26:48 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.nyi.internal (Postfix) with ESMTP id 6CF345C01DD; Wed, 27 Apr 2022 21:26:37 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute3.internal (MEProxy); Wed, 27 Apr 2022 21:26:37 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=anarazel.de; h= cc:cc:content-type:date:date:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to; s=fm1; t=1651109197; x=1651195597; bh=/E6b940O9j r+5FvvTr7qbVy4SljOGjNSpNUVMpgJvJ8=; b=mryoPnjAsUWJLgrOUYb2cAE+qK bGLWszWli4+A2Ez1dchTCxoEur9VGiHs636DdSACrH9g1AtpOLN/uAOh50BEPthr rYG/9EE+TMbFWn4EGy77klhb28VHJJyr0ME6M416Wuu0O+wYz18vzqVQ2tKk2ge0 uKRNUSJlTU8hGKziDYkRYSlgbQYO9Mj7YEZ32FqPEkoRKFL+TSvKhet/B4ynBjov c0a/EulnFhgh9Su7lgNehr6RDRV9xObhkVbwWwZ5WmSBTkTvCwLvo+n4RKK/Ax1t 3iJLbQ1T84juo63QQubOapaqe09dlOVenlfp//ULvkiwu1ILNMfmD10i4yDA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:date:date:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:sender:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1651109197; x= 1651195597; bh=/E6b940O9jr+5FvvTr7qbVy4SljOGjNSpNUVMpgJvJ8=; b=P w0utoFTJkkBh5BaqIxNigkaEh7BlHdIncgsTOKr77UIpkPzaTrASeOKGSLV/MCwX dZdeQXB6VbhDRK/1Q01kdVxqhinNxqjJEB2Ra3d4dPciqIinUeoKnINDJNQSLqNF ydnXkqdcgQvaKDvp+cQoxxoibnmsMIwP2qXAVob08ZuAZwqHv7asQHpaT5eZdd3K wP9fh2vPVo9Jn2R+gf2uWO1oeRhZg+k+hidIm0Q/u1bT506m2wFCqPlbCS5MwG9F Rpo3Ek3mko7w3TeiHQSN8zqEDHh7EvdNd1lfZuS33Z286YYujQuSdYzZV8aK/SeM S5nHmcCRMBDWq6MZZWlmQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvfedrudeigdegjecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenuc fjughrpeffhffvvefukfhfgggtuggjsehttdertddttddvnecuhfhrohhmpeetnhgurhgv shcuhfhrvghunhguuceorghnughrvghssegrnhgrrhgriigvlhdruggvqeenucggtffrrg htthgvrhhnpedvffefvefhteevffegieetfefhtddvffejvefhueetgeeludehteevudei tedtudenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpe grnhgurhgvshesrghnrghrrgiivghlrdguvg X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 27 Apr 2022 21:26:36 -0400 (EDT) Date: Wed, 27 Apr 2022 18:26:34 -0700 From: Andres Freund To: Mark Dilger Cc: Tom Lane , Melanie Plageman , pgsql-hackers@lists.postgresql.org Subject: Re: Unstable tests for recovery conflict handling Message-ID: <20220428012634.xobo2f7ipaeblv6a@alap3.anarazel.de> References: <394950.1651077914@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On 2022-04-27 10:11:53 -0700, Mark Dilger wrote: > > > > On Apr 27, 2022, at 9:45 AM, Tom Lane wrote: > > > > [ starting a new thread cuz the shared-stats one is way too long ] > > > > Andres Freund writes: > >> Add minimal tests for recovery conflict handling. > > > > It's been kind of hidden by other buildfarm noise, but > > 031_recovery_conflict.pl is not as stable as it should be [1][2][3][4]. > > > > Three of those failures look like > > Interesting, > > I have been getting failures on REL_14_STABLE: > > t/012_subtransactions.pl ............. 11/12 > # Failed test 'Rollback of PGPROC_MAX_CACHED_SUBXIDS+ prepared transaction on promoted standby' > # at t/012_subtransactions.pl line 211. > # got: '3' > # expected: '0' > t/012_subtransactions.pl ............. 12/12 # Looks like you failed 1 test of 12. > t/012_subtransactions.pl ............. Dubious, test returned 1 (wstat 256, 0x100) > Failed 1/12 subtests > > And the logs, tmp_check/log/regress_log_012_subtransactions, showing: I'm a bit confused - what's the relation of that failure to this thread / the tests / this commit? Greetings, Andres Freund