From: Tom Lane <tgl@sss.pgh.pa.us>
To: Hans Buschmann <buschmann@nidsa.net>
cc: Amit Langote <amitlangote09@gmail.com>, Peter Geoghegan <pg@bowt.ie>,
        "David G. Johnston" <david.g.johnston@gmail.com>,
        "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
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>
Comments: In-reply-to Hans Buschmann <buschmann@nidsa.net>
	message dated "Tue, 24 Oct 2023 06:16:13 -0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <572493.1698162977.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Tue, 24 Oct 2023 11:56:17 -0400
Message-ID: <572494.1698162977@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/572494.1698162977%40sss.pgh.pa.us>
Precedence: bulk

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