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 1sGYh5-00ETcB-Ei for pgsql-hackers@arkaria.postgresql.org; Mon, 10 Jun 2024 06:39:52 +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 1sGYh3-008PEg-T3 for pgsql-hackers@arkaria.postgresql.org; Mon, 10 Jun 2024 06:39:50 +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 1sGYh3-008PEL-JN for pgsql-hackers@lists.postgresql.org; Mon, 10 Jun 2024 06:39:50 +0000 Received: from fhigh4-smtp.messagingengine.com ([103.168.172.155]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sGYgx-000aJn-VB for pgsql-hackers@lists.postgresql.org; Mon, 10 Jun 2024 06:39:49 +0000 Received: from compute6.internal (compute6.nyi.internal [10.202.2.47]) by mailfhigh.nyi.internal (Postfix) with ESMTP id 5F0D6114019D; Mon, 10 Jun 2024 02:39:43 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute6.internal (MEProxy); Mon, 10 Jun 2024 02:39:43 -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=fm1; t=1718001583; x=1718087983; bh=e2mAcsw1Eb mXihtvgkz1qX0GlwklWm7We7WsIOi3Mc8=; b=Vtz21+gbfT0407oiyudcGxrZ3A sOG2CLK+STrPNtwdZ9MZDYIHGWHkbCjUdf0NCuNqLPXVHVgCKBWSc64V1hWCWO0T mM9wQR+tGEV5aGcTTWhoWV4EnytvkBPQx+917+9ywQ+HTM8PLSagK1rkHDmOM+p7 uF+DLcJOwW4WStqtFVDnJN8shgBRlSJMqfKf6ehj+0CcK8ITYlF620xiMd7wI/A8 /10ytn4TxFTdMLycLeeO6gGhyzJtpftQzjZPHJ8WlvcXomyn4ziUZfYPeAMYdAAu Pdq+AzoHu0gL0W9qNnOEzzZsW/Tep9zSwFak1uvkhJN17YnQBARSudZa1osQ== 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= fm1; t=1718001583; x=1718087983; bh=e2mAcsw1EbmXihtvgkz1qX0Glwkl Wm7We7WsIOi3Mc8=; b=LHmV3+FARpuRHggR2UaosqUK6y7pEMtWGhw4QjyqqcFZ 3cfLj/wnWjDDmp/T9bT9LIobDwVbzw0izWIokMWT9xvlij494tnP/HNkaT1Htaoe xHJ/sTQ02W028q6sAmnnbf3QqTnhdn0GOtOZMrRXzDqvdrR2w5azdhpU3V7rULRs T9AYjRErQfV5fPMtwcCuSrKMcfE25HU9bgQTfxaNIb3b28Ujsw1PtrlXHRbminqu o+EKoef+ASobmPeeWq2AkOOk5sZMKqpX/FY6cQ9hGzTTRGuzRgZvd7FEpak6UzH4 pAmIUyi8Lj9GTQAkHaKZ1fj6jXhBdt9SnvEzZm6fdw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvledrfedtledgheefucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvvefukfhfgggtuggjsehgtderredt tddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesph grqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepteelieefudffhffhtdetleeg geegfffhkeeuveetiefgudduvedutefggeeivdejnecuvehluhhsthgvrhfuihiivgeptd enucfrrghrrghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiih ii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 10 Jun 2024 02:39:41 -0400 (EDT) Date: Mon, 10 Jun 2024 15:39:34 +0900 From: Michael Paquier To: Bertrand Drouvot Cc: Alexander Lakhin , PostgreSQL Hackers Subject: Re: Test slots invalidations in 035_standby_logical_decoding.pl only if dead rows are removed Message-ID: References: <657815a2-5a89-fcc1-1c9d-d77a6986bc26@gmail.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="gOqu1QT8VwUvjVXK" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --gOqu1QT8VwUvjVXK Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Mon, Jun 10, 2024 at 06:29:17AM +0000, Bertrand Drouvot wrote: > Thanks for the report! I think it makes sense to add it to the list of kn= own > failures. >=20 > One way to deal with those corner cases could be to make use of injection= points > around places where RUNNING_XACTS is emitted, thoughts? Ah. You mean to force a wait in the code path generating the standby snapshots for the sake of this test? That's interesting, I like it. -- Michael --gOqu1QT8VwUvjVXK Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmZmn6YACgkQnvQgOdby QH3Gbw/8DvxjXmiezbJX4d7vZkcK13z7MHqqA7q5m12mqFppg/JHEAsmJ8ALX238 W4lJNzZTZUQ5jJbXNIU94+67jDDNPrQebVV0vHGeeeWxdtt36TRwSMz2m5ynvyOk BWM6T8yz9DRVLFnuQqeCtq48WHaOKAzgd9A3dt8dMXkdavtUcfNuI8G56ujtTDFo vW7eLvUR0WEMnUP1R4ZMgdmM193FKbBxeeVJo60LkSksbMvLajC2wWDWzcYQdVyg VDt9pbtpdlN+/kXnSc5CAzfouMzQgAaHC41Hr6h0npQRDlwBkTrrs/WSjWGAt3l6 WlbGrJ2jmZygYEes5PqvFdtL3SVKYWajzu6cxF+JC5zVX35QQOqgMeR8TtJ8hsF8 Box4rZL79NNQj+ptkceto0phxAq62+ekfCahqD8TeJ0dlndsUXFKT4ap9W4Ncp03 B9+sQDG5qIBpsi0P0qMdq/2lDbGAWXweFsT3dqrElP0FO7Pl0v9KQQzQBk/u/dai 8Z1veSb+erdPMZ/4FBtAIjaHK36RbkTRx3M7g/uWhwarKVNCbPX4C4qhKLMH/E+1 FXZuCfipVxA/Xyr7T0BbOsRNFWKlXFa1QthNxWY5oPh6UBYRi0mSLLY+wj5yG06T ll1F4YIKbpN0dlssjBEWPUe70PfBdYkuDFWt6ZAz8QipW5m1H7Y= =5fyV -----END PGP SIGNATURE----- --gOqu1QT8VwUvjVXK--