Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s1NBB-00Bjca-2v for pgsql-hackers@arkaria.postgresql.org; Mon, 29 Apr 2024 09:20:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1s1NB7-00G9Ld-Gt for pgsql-hackers@arkaria.postgresql.org; Mon, 29 Apr 2024 09:20:06 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s1NB6-00G9Ji-OB for pgsql-hackers@lists.postgresql.org; Mon, 29 Apr 2024 09:20:06 +0000 Received: from fhigh5-smtp.messagingengine.com ([103.168.172.156]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s1NB4-000aE4-ST for pgsql-hackers@postgresql.org; Mon, 29 Apr 2024 09:20:04 +0000 Received: from compute7.internal (compute7.nyi.internal [10.202.2.48]) by mailfhigh.nyi.internal (Postfix) with ESMTP id 007A91140136; Mon, 29 Apr 2024 05:20:02 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute7.internal (MEProxy); Mon, 29 Apr 2024 05:20:01 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm3; t=1714382401; x=1714468801; bh=mt8chiojCo IARI3/Eyrxnn4DBJTXMnY//9OO2MWGk+0=; b=s0BYdTAk5Wqz15XHiFoQwtr8NJ GdA80EgEgjPRL+gpT6QY8fH7pAoEDLHfqFEsOt3lAiV3VD9YHwqjsS+71m11S77u 1PI6J7+ycjONkdhs4tctkyoS2S4iefJLhB2MoBfzsTqVd+Frd5hbG+Ju5zEhntBA AhLLOYYtcYCV6/I69NMn9BgQgBJwlefxZxRIE6fEUvnPoI0FNcDyvDD0KKcc+dBh QhocE3ujQhdYmdDcMejKVn6YLWfs6hk2YEF85Pu5Blmq9WwF4pw+3zuJ6q6qInTY U8nwILSndAtePcuFoRlBEmGRHx9qpUlApSRIn3Z5BtUbgT4KLM8+RIZSr39g== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm3; t=1714382401; x=1714468801; bh=mt8chiojCoIARI3/Eyrxnn4DBJTX MnY//9OO2MWGk+0=; b=FzryldLtvKwjq0uY8cPMSAgn3HIEnnJj90LIGXB5WrUl r1gnfXV41SAVDSypp68x1e8iQ5pTTyNqXoJk1ppY1ez1JtjaH29vks6oh2aQcVHl IOW5CLu3yQ1/XNhdQnaka59mtaVbrmKyaEMY4nnHE/2MxqvW7UXPt5UY08SdRpk9 AvRwU4rqLZFvJNrF5JyagBHjL2h462CQdGq/2KbXpDDcj0Ho9eK5k7tjI125b/HJ 7yD2MvjLkq0r0Rcfl9OJKRld5oB6JlG7H7A4vwFlAT2FB2n3w+KUI3cnm14lGw+k rd2u+EG5dLxL4CckOOKv1gcQQYIeOBRWdjexL66s4g== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvledrvdduuddgudefucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucgfrhhlucfvnfffucdljedtmdenucfjughrpeffhf fvvefukfhfgggtuggjsehgtderredttddvnecuhfhrohhmpefoihgthhgrvghlucfrrghq uhhivghruceomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvg hrnhepteelieefudffhffhtdetleeggeegfffhkeeuveetiefgudduvedutefggeeivdej necuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhepmhhitg hhrggvlhesphgrqhhuihgvrhdrgiihii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 29 Apr 2024 05:19:59 -0400 (EDT) Date: Mon, 29 Apr 2024 18:19:48 +0900 From: Michael Paquier To: Richard Guo Cc: Tom Lane , PostgreSQL-development Subject: Re: A failure in prepared_xacts test Message-ID: References: <1068977.1714367460@sss.pgh.pa.us> <1076837.1714368760@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="w28rpWbnAtfcSAoD" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --w28rpWbnAtfcSAoD Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Mon, Apr 29, 2024 at 05:11:19PM +0800, Richard Guo wrote: > I noticed that some TAP tests from recovery and subscription would > select the count from pg_prepared_xacts. I wonder if these tests would > be affected if there are any prepared transactions on the backend. TAP tests run in isolation of the rest with their own clusters initialized from a copy initdb'd (rather than initdb because that's much cheaper), so these scans are OK left alone. -- Michael --w28rpWbnAtfcSAoD Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmYvZjQACgkQnvQgOdby QH0ONg//STC+GiTfS55Xr0Q53/AnvZcv7d/MjO696dg2TItentHgNNKgEHdUco69 T+ZCpH0gH+wyRYg6FU0aQaZohYnqqFjYLKA/rFjOPZtfg33vRt99WlZjJHKjx5ve vo7k1UhXhCbcDSZuE7g9QB8uSQmqSrQ0N+pN7RA/T8pb4LfubpG9xvNINaiG0KSk uwy9iw2d3lizULYfk35mvOgelvpNH5wbnKs1iCi5fK+xs9wLKU/RE6Nz/nlKEqO4 rOszL/ESUK1NkqnYDJwmP5FYSRJUy0966GryMNbJDCYeHgvuXFv4PiC/6mA1f3l1 G4jHJCrsD+c0iC2kMEuukCQEsVdm68RRcVycYBPhbJkfbJoQduJz8hGvgLzsLDzN OEe6QqnBBTjaSeFyyb1/LnISN0f2VROfj7p0qsQYxGgo1UJZz+z5vTVFOkK+TN2w fh+vfqqo1VNLIUwsAW9kg4ISgEL2lh3VBxjdhX1ywdtgfYD+g9hS+xEUsgKQDXGB m0X8uMnbU6cBsTVpqtLn2PsdPlT31wbRh9FOYvuoG++RRLdH6Radr+o/wQ8a9MaC bTrlbJnsU7Z3cDAYYyM5G0Q6rX9Ix60h1ZNP51/g3314HoNDuZxz4opviq2+QCbe AQf8ZPx6AufHdt1raeMQH/Aozfw8n/398483X41AE+NBh2aETUU= =+OIs -----END PGP SIGNATURE----- --w28rpWbnAtfcSAoD--