agora inbox for pgsql-bugs@postgresql.org  
help / color / mirror / Atom feed
From: Michael Paquier <michael@paquier.xyz>
To: exclusion@gmail.com
To: pgsql-bugs@lists.postgresql.org
Cc: Peter Geoghegan <pg@bowt.ie>
Subject: Re: BUG #19686: Rolling back SET TABLESPACE + INSERT leads to index corruption
Date: Mon, 28 Sep 2026 05:35:01 +0900
Message-ID: <arl99XV0LOps1dT7@paquier.xyz> (raw)
In-Reply-To: <19686-30f4da834585129f@postgresql.org>
References: <19686-30f4da834585129f@postgresql.org>

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
> 
> The assertion failure is reproduced starting from 0d861bbb7.

Err, Peter?
--
Michael

Attachments:

  [application/pgp-signature] signature.asc (832B, ../arl99XV0LOps1dT7@paquier.xyz/2-signature.asc)
  download

view thread (7+ messages)  latest in thread

Message-ID: <arl99XV0LOps1dT7@paquier.xyz>
Permalink:  ../arl99XV0LOps1dT7@paquier.xyz/
Also on:    postgresql.org/message-id/arl99XV0LOps1dT7@paquier.xyz

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: michael@paquier.xyz, exclusion@gmail.com, pgsql-bugs@lists.postgresql.org, pg@bowt.ie
  Subject: Re: BUG #19686: Rolling back SET TABLESPACE + INSERT leads to index corruption
  In-Reply-To: <arl99XV0LOps1dT7@paquier.xyz>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox