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 1tsAoe-00G5A6-Bj for pgsql-hackers@arkaria.postgresql.org; Wed, 12 Mar 2025 01:23:24 +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 1tsAoc-00Ax8Z-7I for pgsql-hackers@arkaria.postgresql.org; Wed, 12 Mar 2025 01:23:22 +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 1tsAob-00Ax8R-Ld for pgsql-hackers@lists.postgresql.org; Wed, 12 Mar 2025 01:23:21 +0000 Received: from mail-oi1-x22b.google.com ([2607:f8b0:4864:20::22b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tsAoZ-002KQv-2Q for pgsql-hackers@postgresql.org; Wed, 12 Mar 2025 01:23:20 +0000 Received: by mail-oi1-x22b.google.com with SMTP id 5614622812f47-3f556b90790so1829349b6e.0 for ; Tue, 11 Mar 2025 18:23:19 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=leadboat.com; s=google; t=1741742599; x=1742347399; darn=postgresql.org; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:from:to:cc:subject:date :message-id:reply-to; bh=ZvFzjvdx1lpnFZ5AKl/aMLNOaWqwRWbcu8sO9xcbAhQ=; b=GqwvGJptmVP08QXMPqYLR41fSIQYH4U8A4Qd29o0t3PnCKvmGuEEl0QCZQF/92aiw6 u6tsjuzd/30Y6ZyBHFXLMDPN5qxcqQG6NvFdl2zVhlL4UH1vS6oCTdHRlzJTDXKheh8S zqOnphuCxcSMs7Ap2j/EpjKpTbr6VUrL20iQo= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1741742599; x=1742347399; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=ZvFzjvdx1lpnFZ5AKl/aMLNOaWqwRWbcu8sO9xcbAhQ=; b=WV6ACtGPKXbrDXzpcf4IY4bqsgnA/7dhxBeQC6EQiocBsFJhfldXn0VHPWePfEuCbQ E9Mw6Yg+ImIA6DKiNLlqZkgxWEgovTvaKmOwn7rGIzgWLzeBCCA5X68i0hLPLFd2Tt9u WISxz6mj0EfgHrJpt6a/9/+TuqSkwQ1xNyf6pBr2jAspmzHxU8teHQGDE0aIf+D0kuQr 6TUrnHFYVZ8O6vHCC6BL3RlKcEdx2ERyyfnUwFhszz+orgojGDKhLaj9kLSDc3TNII2J 9NJfGHFI4UOMBYmahq4etVVbeMxi7h400tb2ORsmI6X/gX07+BRZXXsTPW+WZ2SXHv+t s3xw== X-Forwarded-Encrypted: i=1; AJvYcCVeJO8el2XOy8Sh8ebhp3g9/K38taTwXPmDFDu6UjBzuepAWwbubscUHFPf6xLiAnDU+thb/xd/+1toKaSJ@postgresql.org X-Gm-Message-State: AOJu0Yy4GW3XN76CkEWuJwv4qcGy2eJRML3D++pxsS1h/YdEa2ZNTtx4 IVVQgW0eveSMozI8/SCUoAdQ7TIOHRrwMzdxpabGGme5y2MA/+IEm/PXqD//OQ== X-Gm-Gg: ASbGncvb2DqlE5xmnDXDmbd9V5W124oZrjbmBo/helTxyNLVNivQB4JYDywEdRIVG1H Qnx++A5GzIOn2FCa48kGtp4ljUwW3555tKPctR27jsPflrRSuaV6okD42rutQ1VcnbnTlmlfy52 FHl1QoJBDtsbh8meRjGfJ3MFQuJDWzBXkSRHN+T9QuuV8QxgGtzzTPBZsDNTv+2KE8xGt/iRwis nkkPxiJV9GoWiaZu4QbFN5ZmglWs1BqUS0SKIAb/W0/maxrb9MDFM29Nb3wAmj52NfWRer2E+ja gVIOOazHfq1ocg9/iPHTTvVeV2ufI2d58dlvupM= X-Google-Smtp-Source: AGHT+IGQc1kmQRwhf6/jNkhJz6ENQIW2w8HvpFCcmiEXk0G1lw6JELSS+/GbuEgbDPNsIQ8tWXKIBQ== X-Received: by 2002:a54:4506:0:b0:3f6:a476:f7d3 with SMTP id 5614622812f47-3f6a476f97dmr6643317b6e.9.1741742599179; Tue, 11 Mar 2025 18:23:19 -0700 (PDT) Received: from google.com ([2600:1702:a20:5750::46]) by smtp.gmail.com with ESMTPSA id 5614622812f47-3f6a403b4d6sm1928108b6e.25.2025.03.11.18.23.17 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Tue, 11 Mar 2025 18:23:18 -0700 (PDT) Date: Tue, 11 Mar 2025 18:23:15 -0700 From: Noah Misch To: Michael Paquier 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: <20250312012315.fd.nmisch@google.com> References: <7chjz7zeigbsbt7nim4cj6zryflzcpy2lgenas3yh7cpvwf3gb@m6cwqzlvfd6q> <20250306193013.36.nmisch@google.com> <20250311205749.a8.nmisch@google.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/2.2.12 (2023-09-09) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Mar 12, 2025 at 09:46:27AM +0900, Michael Paquier wrote: > On Tue, Mar 11, 2025 at 01:57:49PM -0700, Noah Misch wrote: > > Thanks for crafting back-branch versions. I've queued a task to confirm I get > > the same result. > > Thanks for that. That helps a lot. I'll let you know when I get there. > > There's a test case I'll polish, too. > > Are you considering the addition of a TAP test in 17~ based on a wait > injection point in the checkpointer coupled with a check of the server > logs to see if we see the error patterns you've spotted? No, nothing involving injection points or otherwise version-specific.