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 1qoYZl-001lPn-85 for pgsql-hackers@arkaria.postgresql.org; Fri, 06 Oct 2023 00:20:17 +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 1qoYZi-001bck-Rp for pgsql-hackers@arkaria.postgresql.org; Fri, 06 Oct 2023 00:20:15 +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 1qoYZi-001bcc-H8 for pgsql-hackers@lists.postgresql.org; Fri, 06 Oct 2023 00:20:15 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qoYZh-000Irz-6V for pgsql-hackers@lists.postgresql.org; Fri, 06 Oct 2023 00:20:14 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailout.nyi.internal (Postfix) with ESMTP id 026845C0346; Thu, 5 Oct 2023 20:20:11 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute2.internal (MEProxy); Thu, 05 Oct 2023 20:20:11 -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:sender :subject:subject:to:to; s=fm2; t=1696551610; x=1696638010; bh=MZ NW2ry7MwNoUknEjV/+hxCoRk6xOfCjdyN86Zhb/IQ=; b=C+f/7GS+w4a288mEBH vptJCMeOgnPPTd39+auAEZhTyzydw5Msjh/Eo/XvrSkLTGD9Cl5wHIximtHr5VdF QA0j5aPlcdhTcSq6vthAyQYSX7YpBVpfvLphutqW7mB7R5DhNUitFJD7fHamPK6i dGd2F9T4E1TuVpZIEFSOwjcIhVfy4oQGft5meqLa3gA74kuPEf4LoIA+Qe+bxDzg QGJG8pPvQxg4xXwjGbPLKwAs0fSfwcE89PnQ772uK9XpG5lGvlG9T67jekQ32UhU tvNi+3KyHc5i/6ShSpUG+8OYdfRoIX5XBOIr1/WhBmVK7m20Qe0SFI5x/WmZn4h5 Tydw== 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:sender:subject :subject:to:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm2; t=1696551610; x=1696638010; bh=MZNW2ry7MwNoU knEjV/+hxCoRk6xOfCjdyN86Zhb/IQ=; b=rf5lZflPFQLsMUMwXCWB3HASvsmkr KEIqfx8OsQYQu7Q//vt5+1tkrsLxWrYETiXuHPQLxKO6PLI0gyy9IDPAkJ2W1C0D IxYZ/zN0pYy+rVvAv+HHJTiOlZggWfC3Xu9cnILN/iA9fkt/RnVHl7WpGqbST2E8 0KfzWBZh2+WC4qTmXIjOowPpuXX+i9/BwcOoO6opTp5UXCrZFKGoB8w98rM0iUDX 3HE4HMrI2IXGZobndvHD3QkW9/WTKzxfy6D+7It2+PeR26qSrAefOB0vZ4ZqCfQN qNmp9VBDq9WCJxgrVjGBYVFc9JXAfqSQDQqYhya+6+LjpGfC1hEGdQEgQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvkedrgeehgdeffecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfg hrlhcuvffnffculdejtddmnecujfgurhepfffhvfevuffkfhggtggujgesghdtreertddt vdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucggtffrrghtthgvrhhnpeetleeifedufffhhfdtteelgeeg geffhfekueevteeigfduudevudetgfegiedvjeenucevlhhushhtvghrufhiiigvpedtne curfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 5 Oct 2023 20:20:08 -0400 (EDT) Date: Fri, 6 Oct 2023 09:20:05 +0900 From: Michael Paquier To: Justin Pryzby Cc: pgsql-hackers@lists.postgresql.org, Andres Freund Subject: Re: pg16: invalid page/page verification failed Message-ID: References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="q9b0Ycnw1jv5qBJf" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --q9b0Ycnw1jv5qBJf Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Thu, Oct 05, 2023 at 11:45:18AM -0500, Justin Pryzby wrote: > This table is what it sounds like: a partition into which CSV logs are > COPY'ed. It would've been created around 8am. There's no special > params set for the table nor for autovacuum. This may be an important bit of information. 31966b151e6a is new as of Postgres 16, has changed the way relations are extended and COPY was one area touched. I am adding Andres in CC. -- Michael --q9b0Ycnw1jv5qBJf Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmUfUrUACgkQnvQgOdby QH1LTA/+O+VWAy/rCgQKxw7ZuWNLoYGlxWj6mbcBI671hpUPqhK1GGT7x5e01eVi TnPi9TNtRERWY1vYUPDNdBHv40vb/jnxXoPg7z6bStkZMTEjbsdZgAAIEqOq/RCi BzyAJLeMOltjAz2RBJnvdlaxHSCY2+6oBPn3Ulp7YmGtoLTspk42DafC5BmOKtPm xtG8T5a9HEGKEs40pguqVTwepD0AVPUgkbMTy1y5DkTgyR/GA8aHV3oXHneux76a cJdGx+WtSWeT3SodoTwVNpO37OQQ+KLe2KeXf4QX4x2y1RJFsX7Sc1SRqh11B0u3 zwaYvcF63LNHnn/OTrCm5ZCjc0/r3ZGq5kdTN2hxU74Ft3Tf6l34iasevQKDxgAL eLlwWjkIw90lgp9na9lB39pqKsUch3jv2DQJ/oA90i94HM+dEXf+MMEiDdq1R8Ic b6Ft4OuEKEhhYKa2NSs3O1Zp+2Ha2xqVJwVNZJTfOWrzhBq07AckKrBO3i4z8ltY dyquL7oTiPDcXeYH2dWovuEO67uuSpC+xrsb3rFAJjq+Ewyjm59PvmfHPBZLJOlp aDPp7slIXIeoGh1/d3TzgH6gU2t9wzatP1/OLyLLGlP3QF9st9m1F55OCCs2vnWV sLgCYVy8G/VEeo70ch/3/bfKZvhGZFEhzrsPWVk7Kj6eHK0SofU= =QY/W -----END PGP SIGNATURE----- --q9b0Ycnw1jv5qBJf--