Re: Avoiding another needless ERROR during nbtree page deletion

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: Greg Stark <stark(at)mit(dot)edu>
Cc: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Avoiding another needless ERROR during nbtree page deletion
Date: 2023-06-01 12:14:28
Message-ID: CAH2-WzndmUM9iZG+dpJCUmBcwY8LaGwbSzVjU-pGwSRxhoASeg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Jun 1, 2023 at 6:47 AM Greg Stark <stark(at)mit(dot)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

In response to

Browse pgsql-hackers by date

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