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.98.2) (envelope-from ) id 1xAvba-00000002uT2-0Qvi for pgsql-bugs@arkaria.postgresql.org; Sun, 27 Sep 2026 20:36:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xAvaY-00000006ci3-3de0 for pgsql-bugs@arkaria.postgresql.org; Sun, 27 Sep 2026 20:35:10 +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.98.2) (envelope-from ) id 1xAvaY-00000006chu-0AHs for pgsql-bugs@lists.postgresql.org; Sun, 27 Sep 2026 20:35:10 +0000 Received: from fout-b1-smtp.messagingengine.com ([202.12.124.144]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xAvaV-00000001ZKf-1nIR for pgsql-bugs@lists.postgresql.org; Sun, 27 Sep 2026 20:35:09 +0000 Received: from phl-compute-04.internal (phl-compute-04.internal [10.202.2.44]) by mailfout.stl.internal (Postfix) with ESMTP id F0D381D00054; Sun, 27 Sep 2026 16:35:06 -0400 (EDT) Received: from phl-frontend-03 ([10.202.2.162]) by phl-compute-04.internal (MEProxy); Sun, 27 Sep 2026 16:35:07 -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:subject :subject:to:to; s=fm1; t=1790541306; x=1790627706; bh=H8/zSQChg1 T+k4tGK+mG9264qw/K+hePUQ4q9GtoRHA=; b=Cd0MeDAqesppR13YxUGRcB1rQ1 vFTM2vNLc41K1meYeXFMZQCIK8B9+IjeTZQYeY+LozTsLdIicNWnZvu5ibxwi2+E 91x8y9OhCkqlmK2sZ4hKM3O2fRmA7e4RHzL/URhv4odYU8g/1b16nAwsozF2cFuA 1crKOSkVUcdKmyhzNCYtuhwaoI+tFJOk0T8TsrdeO+pY7EKw66nhYxdN5REuT/Xq UAEgZaLevjgUtQ/S7/Lf9afH4LSz8mG/XERC9buPCHATc0nrsGMpCsnh/akfd0oU LoXdcPtn93M3J5EKdW08wHjTbsjh28yXoLZruzNCsQ3cyqPx+YMPRVZPFUig== 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:subject:subject:to :to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t= 1790541306; x=1790627706; bh=H8/zSQChg1T+k4tGK+mG9264qw/K+hePUQ4 q9GtoRHA=; b=SgAUP85/0X89WKPJhM9hbVM5apK41AyOtywf84NNxRBrtWM6fb1 YoucR6ozgE0WUqEJ8SQ8FVAvADWL0e4D3HADVSUTDB/e7d8zunnWnnWaifFJ6Mss QWjn9OdUploZ1w6RWVOZtOAQeF4MyVrsAg9NHNIbZIhZuqZh3iIFZ+evo8303S3S SpN8Rrpalg4uWX6qqAEm5umVzuC+o0da5pK/NcEMsN4NkLR9wA1XkbuFMBY+hy4s qucaDNtA1SfRSVF5LakSupNdvrxcLdwnv1M7KbwJP0AEBrZyt9iV70VdMfNHsnbN Ss+bWQfWHSz0BNrckWVuf+JD1onQhhBCrWA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: dmFkZTECu6KZfApA2ef6iGZGwqLoCeSaiSPKZsKhEiawjCaKMpEFc68alAOXrFFg39xmGP hh3y+UxhwZ96Sdho11fHtCMmj2w6JC6O4i8wLSdc/HPKrE7Rxt0hTHeLSgIaNm3yne5IQT iia9HzcbbEgjxZLyYfX++5xvrHH4NUHUzoMwWEl9uHM7nWOD4DYKxCaBSOZJO889GsTVLI rsvzSeejjsqvhQY3tQuf/QoCuS/K3mYd0E7yUFOw1Hf7IhqSKe0+AXDPO41dfjQorBEzru L1noE0Aas55JWnQg0Sro+hrshVmRtPoC4A5ZVfdESvu2imk6pe2cFOOajAv/XrYztbpur7 aSGnRBxV8rmdswXKrUzSYGCdnNl30j88/8UIQmaBWPUIcJv5FfkqJM4W4+ywXhBXdHSIfr q2BfVXWUTG/EKp8s8JBLckiKn7YxR/vEe8pNPnd7T5eHhYdbf6e2AvZWA/bLvvaH9J7cLA lijilSdleVGI07nw2/+81X18f32aeANp6yqiSeVy98yU6+S+6kO1dFsSqU98PNATzGvUxG /p6IQrksbqEsOMa/qKGFfEMymXPP6bLrHak282HPp3Kg0xcucwd7gM8q32Q9PahNjVtguB HUSl+FNfXRIf4IJS1MQewvKvJQuTnZoclv37pRI68mG9uH7Uca7ZRtoD0uxg X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sun, 27 Sep 2026 16:35:05 -0400 (EDT) Date: Mon, 28 Sep 2026 05:35:01 +0900 From: Michael Paquier To: exclusion@gmail.com, pgsql-bugs@lists.postgresql.org Cc: Peter Geoghegan Subject: Re: BUG #19686: Rolling back SET TABLESPACE + INSERT leads to index corruption Message-ID: References: <19686-30f4da834585129f@postgresql.org> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="+gL9dhWeuYlkmVYI" Content-Disposition: inline In-Reply-To: <19686-30f4da834585129f@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --+gL9dhWeuYlkmVYI Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Sun, Sep 13, 2026 at 04:00:01PM +0000, PG Bug reporting form wrote: > triggers: > 2026-09-13 18:09:42.598 EEST|postgres|regression|6aa6bcb6.297fd6|LOG: > statement: INSERT INTO t SELECT i FROM generate_series(1, 4000) i; > TRAP: failed Assert("_bt_posting_valid(itup)"), File: "nbtdedup.c", Line: > 900, PID: 2719702 > ExceptionalCondition at assert.c:51:13 > _bt_form_posting at nbtdedup.c:905:7 > _bt_dedup_finish_pending at nbtdedup.c:584:11 > _bt_dedup_pass at nbtdedup.c:173:15 > _bt_delete_or_dedup_one_page at nbtinsert.c:2827:3 > _bt_findinsertloc at nbtinsert.c:918:4 > _bt_doinsert at nbtinsert.c:261:16 > btinsert at nbtree.c:219:11 > index_insert at indexam.c:231:9 >=20 > The assertion failure is reproduced starting from 0d861bbb7. Err, Peter? -- Michael --+gL9dhWeuYlkmVYI Content-Type: application/pgp-signature; name=signature.asc -----BEGIN PGP SIGNATURE----- iQIzBAEBCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmq5ffUACgkQnvQgOdby QH3qZQ/9GXMxx5zYzfoDpxCRAlasj3VIXwBA8Hkn+yVTQ20ryqNMZqSnnnPPcPg/ ZJyO392CcACTAmQ7Exuuj+t4D9yuyACU4EKY1heVuFWmHjxjoa2MI3/GGWecedR6 sObUN2MKLOMbB/hzyleNX4BUX3sjqnfPxoDrUNhpl8JBBScSzX3BJYVccPnziK7w ADQG6oEgM95HWMD710WEjgcdsKzqRUpSpghfKrOw1fliR6mfDMpbuV8xjwLcN/oP iGtuU9cDZhSbYWUNSJ4xA9nBfTPr/WNUDzEzn4HhZ7vr8tkJ7pykJku44rOshbhp TD1pdv6xF6EVa6mVuiRFWnEQ1RnzkR6MjH3BWvgm8gmoMTKhMyQeI1iQU73fgpP7 p794cIDGM+cRWRNqYRdDq37NLO3MJl7bVOs2jVpSyms/Y8SCEthzJEGMCHCsOZRO Uv1Hx1YxaiBn4011CRJ/g/KHY//4SGt48TV/mMhIRh/RUEqkfZvWaLZFzbopic04 vU/Gt4klabAwYeRxhOvCWnhwT2tRUqMcbSocFervdR7ifcFxydWuhB73Hy7qapJz qbQ3KUlrr87vEwVEyuMVsyNavA2/iEuVAy/RMC1fWqvj4qrUTLXPUmZccxZUMAYZ WkwmJAx3LHfwthtNbrL0tZfvEvVJYWf+5qIwmKgoD8TIx2nuc8E= =OXfC -----END PGP SIGNATURE----- --+gL9dhWeuYlkmVYI--