From: Tom Lane <tgl@sss.pgh.pa.us>
To: Hans Buschmann <buschmann@nidsa.net>
Cc: Amit Langote <amitlangote09@gmail.com>
Cc: Peter Geoghegan <pg@bowt.ie>
Cc: David G. Johnston <david.g.johnston@gmail.com>
Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Subject: Re: AW: AW: AW: BUG #18147: ERROR: invalid perminfoindex 0 in RTE with relid xxxxx
Date: Tue, 24 Oct 2023 11:56:17 -0400
Message-ID: <572494.1698162977@sss.pgh.pa.us> (raw)
In-Reply-To: <b134494499a7481f987955247b65a63b@nidsa.net>
References: <18147-6fc796538913ee88@postgresql.org>
<CAKFQuwYFq-Q2rxbXXBmdHCAEFm-Pu_qhPAEi-PO+LmjtYN2hhg@mail.gmail.com>
<2796464.1696525626@sss.pgh.pa.us>
<9fdfed847859435e8641e613198be9e3@nidsa.net>
<3319880.1696778678@sss.pgh.pa.us>
<3c9fe737f6aa4ae9b0dc19bffd97e106@nidsa.net>
<408285.1698085850@sss.pgh.pa.us>
<b134494499a7481f987955247b65a63b@nidsa.net>
Hans Buschmann <buschmann@nidsa.net> writes:
> 1st query: ERROR
> 2nd query to or_followup_archiv: Succeeds
> then 1st query repeated: SUCCEEDS!!
> With this direct update to or_followup_archiv (or an unclustered table) the error disappears.
Yeah. After more study I think there's less there than meets the
eye. If the row update manages to be HOT then we don't need to make
any new index entries so we never reach the troublesome code.
In your original reproducer, the CLUSTER step was important because
it left the target tuple in a fully-packed page with no room for a
HOT update on the same page. When playing around with variants or
even re-executing the same query, it matters how much free space
there is on the page containing the target tuple, and that is
affected by all sorts of seemingly-irrelevant actions.
Anyway, we do now have a simple and reliable reproducer, so we can
work on fixing this. Thanks again for the report!
regards, tom lane
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: tgl@sss.pgh.pa.us, buschmann@nidsa.net, amitlangote09@gmail.com, pg@bowt.ie, david.g.johnston@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: AW: AW: AW: BUG #18147: ERROR: invalid perminfoindex 0 in RTE with relid xxxxx
In-Reply-To: <572494.1698162977@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox