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 1lHLYE-0008DZ-T2 for pgsql-bugs@arkaria.postgresql.org; Wed, 03 Mar 2021 07:04:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lHLYC-0004dy-Hq for pgsql-bugs@arkaria.postgresql.org; Wed, 03 Mar 2021 07:04:04 +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 1lHLYB-0004dr-UB for pgsql-bugs@lists.postgresql.org; Wed, 03 Mar 2021 07:04:04 +0000 Received: from out5-smtp.messagingengine.com ([66.111.4.29]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lHLY9-0001Qp-2H for pgsql-bugs@lists.postgresql.org; Wed, 03 Mar 2021 07:04:03 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailout.nyi.internal (Postfix) with ESMTP id 67AF45C013C; Wed, 3 Mar 2021 02:03:59 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute1.internal (MEProxy); Wed, 03 Mar 2021 02:03:59 -0500 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=mhUFKr7vt+uspjXNDKYitx3EQPf jBYONr7Ta3HAAUVw=; b=o1AUX8GQjGpM4o5oyS2LTq6bn4hiHY5c9b3kxc+cAvr O3TIMN1171fh6MG6rCYx5ANt3V7fdPj1BZfxJltn6IgLcBiUiciRoWxBqMn/yYRq DP7oQ/l7ZsxIrJHYPe0NIGOP+GLrFyrFAkSDavGVoFdJaz8cxPAoNtlU+XLWi2cM BUQLNMiKnFY696S2p+ZyBi0N+y108wj1pifyjrpcIyMCCbMGeqpG/TIjQl6QACud YeOqxzNvVOYmDMTBPsCAhMnvrhcQM3aDgjohS/BeX6XqWFq1+xpFUm9RdEaaUdkD Ojl6aY/6VUnIVVOXtFYzicKVuvDtQ9Y/Z3/yGpabx6g== 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=mhUFKr 7vt+uspjXNDKYitx3EQPfjBYONr7Ta3HAAUVw=; b=glEetUtEiEzx7B63rffv65 Y8BZ8Gmm/8dzSb8OYtNBNobac1GA2iATYtEMqwA3TtJ5AtlhK45LQvhJ6NwCV4ok CfzTAt2L8lZ6uURwWyx0Mcz+6jz5MWSuTFE+KZeWfytEFn3jaJHDFglr1NTY5U6c gNHBdJZNdrJyyfvj9d5EQwBSZ/PJ3p+/l5acNUmJjn6B81RVrDdMWx+vweK8pIi+ PTJ5X5TokO8Z0V/oGnki2iEyXnaDPnLkgj6NH9atRUWOq3/Pjp+1UQ5ZVq4cGDL2 VuBwugOuxYzwWJf8ykYjUT0csGFwnsR+5p0L0xxSHxF6rzC4AqkFssM3LTwipk9A == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduledruddtuddgleeiucetufdoteggodetrfdotf 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 E86F31080059; Wed, 3 Mar 2021 02:03:55 -0500 (EST) Date: Wed, 3 Mar 2021 16:03:52 +0900 From: Michael Paquier To: David Steele Cc: =?utf-8?B?0JDQvdGC0L7QvSDQmtGD0YDQvtGH0LrQuNC9?= , pgsql-bugs@lists.postgresql.org Subject: Re: BUG #16894: PANIC: WAL contains references to invalid pages Message-ID: References: <16894-c29735df12727642@postgresql.org> <11b70b37-997e-8a2d-62f3-0f8398b7cafd@pgmasters.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="aSZmza1giaL5vYPz" Content-Disposition: inline In-Reply-To: <11b70b37-997e-8a2d-62f3-0f8398b7cafd@pgmasters.net> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --aSZmza1giaL5vYPz Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Tue, Mar 02, 2021 at 07:46:21AM -0500, David Steele wrote: > That summarizes the process very well. Okay. > My concern here is that we appear to have a partial page write as the fir= st > write to a page after the backup start checkpoint. At least, that's what > this error seems to be indicating from my reading of the code. >=20 > The question is -- are there valid circumstances under which this might be > happening or is it a bug? Err, what you are doing here is qualified as unorthodox, but isn't "unsupported" a better term? That's basically tricking WAL replay into doing something it would never have to do for physical backups. -- Michael --aSZmza1giaL5vYPz Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmA/NNgACgkQnvQgOdby QH1Bsw//a1FnlHVkvfgXYdbEBsPPNoDsis8TTcGQ/xLQ857Zs8g5jWCDXjoK7vOS 7FVhigX+Z7U0dHNFH0f1BeIHfx7uFUAh/5gOhi4HqZYnLEkcRUfcs2a9BYdwRF6E 40Qwlng8fqTD/lK/OXLJMvPIK0sCOdVB3KqwkAeJrhMM1R+1rCODGwRLKjfc/nSe pyg6tfxZGHcYGehvHXxEu4GOALMZMxHiCJJf64Xxn1yRKi/YjibyaCuNSudn8RRl MkD9dqjHXZbs48wMzmvn6HXPux/En7RywC0zg6Bxdjfc/vJic8qfr3uTLXFGGswU eJKCTlDc7JPDYzkhjWfJG7aw6m7QGMSBsC+afVVBNuo/iMZJD7QKcny9J6B1nZ8+ B/ntvWtCqcibFq7iKg60yA4snr/v/euAzmHjgRd+gzXXAicvl8FxakX4X3d4pHNv fCp+VjBFGsfZu2A+akuj7sW6u3vfmS9yTnSngKAed13Zld1e+Donc20SOEnYqdKB D+Lxl2G/FIlT8kHRGpDG5vgBiQbSAIIfbPb5/zRDRRGMhDb771ejcLmiXE+Lzzuu XsD11rNg6+mJtpFd6u1pHSw5lbZ6XHtl5zyg7VI+f+2UQNQCW/1HsNR2hQRoo7Ad fwCU5tUHL+5kbX8/YdeelpfdlGv+CBP6CuwWNaunZq+4UjKGg3Y= =jmVJ -----END PGP SIGNATURE----- --aSZmza1giaL5vYPz--