AW: AW: BUG #18147: ERROR: invalid perminfoindex 0 in RTE with relid xxxxx

Hans Buschmann <buschmann@nidsa.net>

From: Hans Buschmann <buschmann@nidsa.net>

To: Tom Lane <tgl@sss.pgh.pa.us>

Cc: "David G. Johnston" <david.g.johnston@gmail.com>, "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>

Date: 2023-10-23T17:05:03Z

Lists: pgsql-bugs

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Prevent duplicate RTEPermissionInfo for plain-inheritance parents
- 01575ad788e3 17.0 landed
- 178ee1d858d8 16.1 landed
Fix problems when a plain-inheritance parent table is excluded.
- b1444a09dcb5 16.1 landed
- 8f4a6b9e4f5b 14.10 landed
- 1268e7378123 15.5 landed
- 387f9ed0a083 17.0 landed
Doc: indexUnchanged is strictly a hint.
- 74e5ea1e002f 17.0 landed
- cf89d3052d62 16.1 landed
- be2502947f29 15.5 landed
- df73ca35144a 14.10 landed

Attachments

err_demo.sql (application/octet-stream)
errdb_noerr_231008.sql (application/octet-stream)

Hello all,

I finally managed to reproduce the bug on a demo database as shown below.

The file err_demo.sql shows all the steps to reproduce. The table creation is done with errdb_noerr_231008.sql (unchanged from last mail).

The clue is:

- you have an inherited table
- on the archiv part, you have only (one or more) brin indexes
- to reorder the tuples before moving to a new major version (with pg_dumpo/restore) the archiv part is clustered.
 this requires to create a btree index, which is removed immediately after the cluster statement.

when all this has been done, a write access to the archiv-part of the table hierarchy causes the error.

 A direct update access to or_followup_archiv clears the error (as shown in the final comment part of err_demo.sql).

To make the error reappear, you have to redo the 3 recluster steps.

PS: please apply the steps of err_demo.sql manually because it was not tested for full automation.

Hope this enables you to investigate the root cause of the error.

Hans Buschmann
________________________________