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.96) (envelope-from ) id 1x6nV5-000RfB-2E for pgsql-hackers@arkaria.postgresql.org; Wed, 16 Sep 2026 11:08:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1x6nV4-006yt1-2g for pgsql-hackers@arkaria.postgresql.org; Wed, 16 Sep 2026 11:08:26 +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.96) (envelope-from ) id 1x6nV4-006yst-1O for pgsql-hackers@lists.postgresql.org; Wed, 16 Sep 2026 11:08:26 +0000 Received: from smtp.outgoing.loopia.se ([93.188.3.37]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1x6nV0-00000000mEa-4BtL for pgsql-hackers@lists.postgresql.org; Wed, 16 Sep 2026 11:08:26 +0000 Received: from s807.loopia.se (localhost [127.0.0.1]) by s807.loopia.se (Postfix) with ESMTP id 0FDF9784153 for ; Wed, 16 Sep 2026 13:08:23 +0200 (CEST) Received: from s899.loopia.se (unknown [172.22.191.5]) by s807.loopia.se (Postfix) with ESMTP id 0065D78347C; Wed, 16 Sep 2026 13:08:23 +0200 (CEST) Received: from localhost (unknown [172.22.191.6]) by s899.loopia.se (Postfix) with ESMTP id F2ACA2C8BA66; Wed, 16 Sep 2026 13:08:22 +0200 (CEST) X-Virus-Scanned: amavis at amavis.loopia.se X-Spam-Flag: NO X-Spam-Score: -1.2 X-Spam-Level: X-Spam-Status: No, score=-1.2 tagged_above=-999 required=6.2 tests=[ALL_TRUSTED=-1, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1] autolearn=disabled Authentication-Results: s471.loopia.se (amavis); dkim=pass (2048-bit key) header.d=yesql.se Received: from s979.loopia.se ([172.22.191.6]) by localhost (s471.loopia.se [172.22.190.35]) (amavis, port 10024) with LMTP id KAn5ROrIRaCP; Wed, 16 Sep 2026 13:08:22 +0200 (CEST) X-Loopia-Auth: user X-Loopia-User: daniel@yesql.se X-Loopia-Originating-IP: 95.193.139.107 Received: from smtpclient.apple (host-95-193-139-107.mobileonline.telia.com [95.193.139.107]) (Authenticated sender: daniel@yesql.se) by s979.loopia.se (Postfix) with ESMTPSA id 67EA710BC4AB; Wed, 16 Sep 2026 13:08:22 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yesql.se; s=loopiadkim1707475645; t=1789556902; bh=9otykxKs7dFIpJ/mMCPEv9e7ojntjbFdxPgeydQCbwA=; h=From:Subject:Date:References:Cc:In-Reply-To:To; b=eOdrWkWi5ypzonl0sgrhWbonliXladxKWquOciugdF7PKn9KqSSGdZpyDG7hi4+aX hVILTkjt67b8V6GAG5N2flMSGdPDzqm1pSje0nSrWxaEClpfXNY9qkEPQ8CNbR02iL NaV3B7w0o0RkF6n/46R2/beJI1gQgMOOomEgNJzfSoeVD+6nmDFzA9ufviZK8fdq9v XugV/+QGKhAh4sNRFr2rNcS+gVFVSCr/D+6bY+ZN4r9otNtz/M+phoWW97dLBLTCmS 2IB85Se2fFctJkq4ngXVB1LamCvPkRs/3C7rX6elfGtXV6pgyECqphzrQxO1W6Rr5p pv18mOI8SK7xQ== Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable From: Daniel Gustafsson Mime-Version: 1.0 (1.0) Subject: Re: pgsql: Revert online data checksum transitions Date: Wed, 16 Sep 2026 13:08:12 +0200 Message-Id: <1EEAFCFB-15DB-4EC1-BD49-964C799A01B2@yesql.se> References: Cc: Daniel Gustafsson , PostgreSQL Hackers In-Reply-To: To: Masao Fujii X-Mailer: iPhone Mail (23G71) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On 16 Sep 2026, at 13:01, Fujii Masao wrote: >=20 > =EF=BB=BFOn Wed, Sep 16, 2026 at 6:06=E2=80=AFPM Daniel Gustafsson > wrote: >>=20 >> Revert online data checksum transitions >=20 > It's unfortunate that this feature had to be reverted... > Anyway, thanks for all your hard work on it!! >=20 >=20 > After the revert, the buildfarm member longfin reported the test failure [= 1], > which seems to have been caused by the revert. >=20 > According to longfin's server log, the test triggers the following > assertion failure: >=20 > TRAP: failed Assert("(data - start) =3D=3D data_size"), File: > "heaptuple.c", Line: 442, PID: 78459 > ... > 2026-09-16 06:03:57.172 EDT [77693:4] LOG: client backend (PID > 78459) was terminated by signal 6: Abort trap: 6 > 2026-09-16 06:03:57.172 EDT [77693:5] DETAIL: Failed process was > running: SELECT count(*) > 0 AS ok FROM pg_control_checkpoint(); >=20 > After the revert, pg_control_checkpoint() now returns 19 columns, but its > pg_proc.dat entry still declares 20 output columns, including > data_page_checksum_version. This seems to trigger the assertion failure > in heap_form_tuple(). >=20 > We should remove data_page_checksum_version from the pg_control_checkpoint= > entry in pg_proc.dat and reduce proargmodes from 20 output columns to 19? Ugh, I thought I had tested everything but clearly missed this one. Will fix= immediately when back from lunch. ./daniel=