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 1lMJXl-0007mT-Oq for pgsql-bugs@arkaria.postgresql.org; Tue, 16 Mar 2021 23:56:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lMJXk-00006D-NX for pgsql-bugs@arkaria.postgresql.org; Tue, 16 Mar 2021 23:56:08 +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 1lMJXk-000063-HM for pgsql-bugs@lists.postgresql.org; Tue, 16 Mar 2021 23:56:08 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lMJXi-0006Wy-OH for pgsql-bugs@lists.postgresql.org; Tue, 16 Mar 2021 23:56:08 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.nyi.internal (Postfix) with ESMTP id 5619A5C00B5; Tue, 16 Mar 2021 19:56:05 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute3.internal (MEProxy); Tue, 16 Mar 2021 19:56:05 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm1; bh=6nHBUuW7W9klgR6caiaVEFxexRh p2diCaLTb7k9/ewE=; b=kb+VyNLapZA7504u1od2kyDvZ6qtm1UjFGCcM0PNhyE 3yronzgbA+3NSgMTOmiG424WryNtI9yzGlkG03JIinbV89ILyzC+FggMkuRfMgwe ScX+oXBg37/L5jnfbm21nZxFg3IyI5B2Jlf8ydMpSlj8g593oP5O+PSmFKuOHmYn tdjNo8StKKDVyRVARsyaFT3vCY1pDddatkE7QA7TTZ3wuvwBEnsodbGBMdZbqnon CuNmYGIlSTw/8ftF3i8+XHLfFhMhI97KkcvlPP9rYow2MSxQZb8L2EQu0cVAo7HY sPn+jIfPXgNbQesNvyXCw9iWBUjjHgfPqJ+1R6Lu5Ww== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; bh=6nHBUu W7W9klgR6caiaVEFxexRhp2diCaLTb7k9/ewE=; b=DirGgiEXme91vvkm+NCyxG o11o+32UrPd5QkNLtM5AK/oAPiz7MgAZ/NdFBJvHfI72HNzbGJ/8aGGrBDfF8x7N P3l6fUgGTVXT7ymDYz4ZEf+7aDnqFIWfXl6hMX8I91tfkPK/jdEVHzZDDJURh54L q4mibwaLBdVQDVrS8bNEn7UIA4gLKXrJL4vkrSY8QFoS0iOSAPJDX2Oe6Elr3nTT jw1d4IWbowKTt2GIl1Og7keoXzJ3LTqbyxBm3mFLlay/Bdg5UN23TAc4/qU9S8RW w/Um6Iv0Apdew18juXPRbjubJ7Z9EzaX3yzDEb22wj+z6sSNezjaa2BzkTVLHuYw == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduledrudeffedguddvucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvuffkfhggtggujgesghdtreertddt vdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucggtffrrghtthgvrhhnpedvgeduuefhtdeuleettdevjeeh heeiveeuieegleetgeeljeelieeuieehgeevhfenucfkphepudduuddruddtvddrudektd drudekheenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhm pehmihgthhgrvghlsehprghquhhivghrrdighiii X-ME-Proxy: Received: from paquier.xyz (ee0822lan1.rev.em-net.ne.jp [111.102.180.185]) by mail.messagingengine.com (Postfix) with ESMTPA id 65D7B240065; Tue, 16 Mar 2021 19:56:03 -0400 (EDT) Date: Wed, 17 Mar 2021 08:56:01 +0900 From: Michael Paquier To: =?utf-8?B?0K/RgNC+0YHQu9Cw0LIg0J/QsNGI0LjQvdGB0LrQuNC5?= Cc: Postgres bugs Subject: Re: BUG #16927: Postgres can`t access WAL files Message-ID: References: <16927-67c570d968c99567@postgresql.org> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="QwoNFiiVPn741K26" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --QwoNFiiVPn741K26 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Wed, Mar 17, 2021 at 07:30:00AM +0900, Michael Paquier wrote: > I am still running some tests on my own environments, but that's much > harder to hit for me, visibly, and the error code path complaining is > not the same. If I may ask, what are the contents of pg_wal on the > instances where the errors happen. Do you have some files suffixed > with ".deleted" around, or anything named like xlogtemp.N, where N is > an integer for a PID? Another thing I could do here is to share links to download all the binaries built for 13.2 and 13.2 + a patch, that you could drop into your own servers to test what I am suspecting causes the issue. Depending on your server policies, perhaps that's not acceptable, though. Just let me know which one you'd prefer. -- Michael --QwoNFiiVPn741K26 Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmBRRZEACgkQnvQgOdby QH2ePg//dhSwwoHPuiNWbWhcrDglAmvpoTnXMUIqcp1CRSPxv/Tb3O7a6B3NJHp/ 5eFAcZygDSF7c86QtaFmXNSEv/8WIXIZI0dOaPtnTBgumEqqqqWdkuGz32pf/Kpk 1zIqq6Jy4FJSpP/8GfPGmri3UKBo3RE1rqC7lW1PncTnH1kjlPmNxpPx6LVeYsMl Gu+0i9gj8nfJzZiWPOUbiERqNDWuR+x1o/vWbo0SZaTD+V26TDyI6gbuQc+fe7T4 gRsAGVWLh0D9AU0OQ88EFMwlm7qaDX2Y52uI/tsfK8s43p1Ev3iRobh2sqq4LkZb l5rlzd/B2rp5BHj58lsoNrcf6PNOXG7WVFeoezYj4OKG5YWhlxQ3a+edMsZDZ4Qu ykO/iWe34yxVMxhA0o8exb098Fsu8Gn5MzkhfJEjA2Vpcu2sqpZF3mbGRJwpp1LA OMPBUBZQNI+RgbLYVQVGTvlLw2PkMR8spTtnIiztS4nuB9BuuiAEi9s8NYLpfQVc n9bFh2gMm+QOTFkAqGz35+jIeidaVdm6keJ9b1HxmmNGatt/VloujdaLqDvaAOIJ JEPuiV/TUR5NGIBubrqlc7UGKWcEELa2qLoCX1vAHjwPSxQJXjkjgtYokc99R/bw fenlQ50SrakAypE+9XO8GiZNmsI1ZgLq2mV5JLhQs+9dilXEhMw= =3eA2 -----END PGP SIGNATURE----- --QwoNFiiVPn741K26--