Postgres Pro
Downloads
Home   >   mailing lists

Re: Avoiding another needless ERROR during nbtree page deletion - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: Avoiding another needless ERROR during nbtree page deletion
Date
Msg-id CAH2-WzndmUM9iZG+dpJCUmBcwY8LaGwbSzVjU-pGwSRxhoASeg@mail.gmail.com
Whole thread Raw
In response to Re: Avoiding another needless ERROR during nbtree page deletion  (Greg Stark <stark@mit.edu>)
List pgsql-hackers
Tree view 
On Thu, Jun 1, 2023 at 6:47 AM Greg Stark <stark@mit.edu> wrote:
> What error would one expect to see? I did have a case where vacuum was erroring on a btree in $previous_job.

You mean in general? It's usually this one:

https://gitlab.com/gitlab-org/gitlab/-/issues/381443

In the case of this particular issue, the error is "right sibling's
left-link doesn't match". Per:


https://stackoverflow.com/questions/49307292/error-in-postgresql-right-siblings-left-link-doesnt-match-block-5-links-to-8

--
Peter Geoghegan

pgsql-hackers by date:

Previous
From: Dagfinn Ilmari Mannsåker
Date:
Subject: [PATCH] Using named captures in Catalog::ParseHeader()
Next
From: Peter Smith
Date:
Subject: Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication