Re: ERROR: posting list tuple with 20 items cannot be split at offset 168 - Mailing list pgsql-bugs

From Peter Geoghegan
Subject Re: ERROR: posting list tuple with 20 items cannot be split at offset 168
Date
Msg-id CAH2-WzkmsXRp95h+=dquSmHEkGFzgZvT57s0xSexFuayUjBbtw@mail.gmail.com
Whole thread Raw
In response to Re: ERROR: posting list tuple with 20 items cannot be split at offset 168  (Herman verschooten <Herman@verschooten.net>)
Responses Re: ERROR: posting list tuple with 20 items cannot be split at offset 168  (Herman verschooten <herman@verschooten.net>)
List pgsql-bugs
On Mon, Oct 25, 2021 at 10:35 PM Herman verschooten
<Herman@verschooten.net> wrote:
> I can confirm that after dropping and recreating the 6 indexes everything is working fine.

Did you also run VACUUM?

You said that not all rows seem to be affected. Is there any pattern
that you notice about the rows that are affected?

I understand (from your remarks onSlack) that you found that the
problem seemed to go away once you dropped the index named
index_freights_on_cmr_received. But once you recreated the index from
scratch, the problem came back.

In other words, rebuilding the index didn't seem to make the "posting
list tuple with 20 items cannot be split at offset 168" error go away,
but dropping the index appeared to *temporarily* resolve the issue?
Suggesting that the problem was either in the table, or in the code
that builds a new index structure by scanning the table?

> Thanks for all the help, both here and on slack,

Thanks for the report!

--
Peter Geoghegan



pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: conchuela timeouts since 2021-10-09 system upgrade
Next
From: PG Bug reporting form
Date:
Subject: BUG #17248: Installation fails...