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 1u10Y0-00CFCP-Ch for pgsql-hackers@arkaria.postgresql.org; Sat, 05 Apr 2025 10:14:44 +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 1u10Xz-00BhVb-59 for pgsql-hackers@arkaria.postgresql.org; Sat, 05 Apr 2025 10:14:43 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u10Xy-00BhVQ-Ju for pgsql-hackers@lists.postgresql.org; Sat, 05 Apr 2025 10:14:42 +0000 Received: from fout-a2-smtp.messagingengine.com ([103.168.172.145]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1u10Xw-003Wcv-0S for pgsql-hackers@postgresql.org; Sat, 05 Apr 2025 10:14:42 +0000 Received: from phl-compute-01.internal (phl-compute-01.phl.internal [10.202.2.41]) by mailfout.phl.internal (Postfix) with ESMTP id 6BF7B1380138; Sat, 5 Apr 2025 06:14:38 -0400 (EDT) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-01.internal (MEProxy); Sat, 05 Apr 2025 06:14:38 -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=fm2; t=1743848078; x=1743934478; bh=o/rgUTy0RM ooPUnMiMEBsI78WyVBjCm3hTGhaCkuDXw=; b=aH0zUxENQ7ySMseyeAtvqG4Dbl /CESqLmnNOFIOOBAKD1rtfdicuDjNeTrJAB5F7iM+DmrOSk5tHVz1e4wCwhYI14/ Xq+T0OWYuuzZCJPf2TCrCbU8YkRTC0sj5wAGcld1fR0lt6unhCGNiHiHEiwmDlaQ y9mihTZh+28FIZnC8zBuRl9u+0Fn+kZ0GNdHXp4tHTg/ww+265v9yaSSI/rt8YwL n2hFKgAWpE6yd/F6HiALB4eY+/XGHRWD5WuOqNMI6FrYttaqZREjEoG/yShh8gJv qABigrHPijdwnVE4PyY+C0GARO8CUPB4y17sWoucIw/E056laYJlfJzOrC6g== 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-sender:x-me-sender:x-sasl-enc; s=fm2; t= 1743848078; x=1743934478; bh=o/rgUTy0RMooPUnMiMEBsI78WyVBjCm3hTG haCkuDXw=; b=E6RztBHHb/fF4I1f8bzvavTZYBK3tq1SgM5RZsT9Ro+TSaOquAO Xta6rCzu0YLUvhOPnXYcb5hCFbYezsrvTdMDum4GEJAL+39NEo3ok0hgstoW+Xz5 4Md+O3QtzFPKp4vnpK7l4IZazhjSDS9N94BWdvMIATDoEvMVhfV7XwjfJMxtB1B9 W9uJKy/SY72Wzf0yJIcLgBoHnG3SIHzvm+OPePX56RpDoLxCscZWLzGaxXlXZFxn mpH+2irET9slx3lVgWB8eTVhVEasD9hVGw20kmGgk3W9AM3ockR9Q+rR4WBvQs63 JGI99vjzOkQ5n3ILkdqf/Y5igqkdGjbSqqw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefvddrtddtgdduleegtdekucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggv pdfurfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpih gvnhhtshculddquddttddmnegfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvvefu kfhfgggtuggjsehgtderredttddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhivg hruceomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhep teelieefudffhffhtdetleeggeegfffhkeeuveetiefgudduvedutefggeeivdejnecuve hluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhepmhhitghhrggv lhesphgrqhhuihgvrhdrgiihiidpnhgspghrtghpthhtohepkedpmhhouggvpehsmhhtph houhhtpdhrtghpthhtohepnhhorghhsehlvggruggsohgrthdrtghomhdprhgtphhtthho pehnrghthhgrnhgusghoshhsrghrthesghhmrghilhdrtghomhdprhgtphhtthhopegrnh gurhgvshesrghnrghrrgiivghlrdguvgdprhgtphhtthhopehrohgsvghrthhprghnghes ghhoohhglhgvrdgtohhmpdhrtghpthhtohephhhorhhikhihohhtrgdrnhhtthesghhmrg hilhdrtghomhdprhgtphhtthhopehtghhlsehsshhsrdhpghhhrdhprgdruhhspdhrtghp thhtoheprhhosggvrhhtmhhhrggrshesghhmrghilhdrtghomhdprhgtphhtthhopehpgh hsqhhlqdhhrggtkhgvrhhssehpohhsthhgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sat, 5 Apr 2025 06:14:35 -0400 (EDT) Date: Sat, 5 Apr 2025 19:14:27 +0900 From: Michael Paquier To: Noah Misch Cc: Nathan Bossart , Andres Freund , Robert Pang , Kyotaro Horiguchi , Tom Lane , robertmhaas@gmail.com, pgsql-hackers@postgresql.org Subject: Re: Back-patch of: avoid multiple hard links to same WAL file after a crash Message-ID: References: <7chjz7zeigbsbt7nim4cj6zryflzcpy2lgenas3yh7cpvwf3gb@m6cwqzlvfd6q> <20250306193013.36.nmisch@google.com> <20250311205749.a8.nmisch@google.com> <20250312012315.fd.nmisch@google.com> <20250403002900.5d.nmisch@google.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="5PkcAJ9+zX6MICLZ" Content-Disposition: inline In-Reply-To: <20250403002900.5d.nmisch@google.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --5PkcAJ9+zX6MICLZ Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Wed, Apr 02, 2025 at 05:29:00PM -0700, Noah Misch wrote: > Your back-patches are correct. Thanks. Thanks for double-checking. I'll move on with what I have after a second look as it's been a few weeks since I've looked at all these conflicts. I am also planning to add a few notes in the commits to mention this thread. > Here it is. Making it fail three times took looping 1383s, 5841s, and 2594s. > Hence, it couldn't be expected to catch the regression before commit, but it > would have made sufficient buildfarm and CI noise in the day after commit. Hmm. Not much of a fan of the addition of a test that has less than 1% of reproducibility for the problem, even if it's good to see that this can be made portable to run down to v13. -- Michael --5PkcAJ9+zX6MICLZ Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmfxAoMACgkQnvQgOdby QH0HVQ//XWTd3pYIkn43BkxgJqRvEqh+aKCV+KuC6QUZ8PAbVRSEosfnx8lqfbfq vs26DN/wiYy5CyR5GXHF4EfHzh6zjponjfCKrXU4DhHFeL8DC9zrrQaoUhvUSGTG hsymT6TNeuRZ2vLjdfKV+mJ4zcw0hny6uJvhHT3MLcXjF7KZw5FqfOabzDlk62g1 zRL2RidriCj5zs8n2wZcm0GInkdhIWZyNtXwPIz85Wbx0SZpdFEGrJbwTm85VPo+ 3UQAHJzxOe6buhpo49owmFPwHCa39/bhNeelICXn8qt8LxWizFzrZzhp/Eu3FkzM a0ImGgHk/KzzGe1GupljTZP5K6aDXBDfOOX0oLZ9CNIXUM/TxkE1e1flaIHj7gds 7Kl2iZifBBO2/teABFDcM96rmKTQtB2xcrzvuXHKXsT7aaDuglY+wu4WClEK05Ip h4m+QIiphUmhqaCefHRsn3eC5PZwF+6dRs9bl5XC219HUvIzhLMx7felomOOdJzX 27M1EPcttEDEmANwTVCr1q5+MbhuVdwRIA+ymOOWnhbu/YSBevj0x+Yta0NBFuJ1 rrdU4eUUpiDjx7YPC2zrgrYfMHCVHFhyGWP+2ivm+Rgy8RurmN+3ywPtznuS/rHf C5YrvVtAwxaGX3zcTEjV/zF4Rco239xc7BuvoRAhpXEB4ZoqDLo= =MyjM -----END PGP SIGNATURE----- --5PkcAJ9+zX6MICLZ--