Re: Assertion failure in _bt_pagedel (leafblkno == scanblkno) after interrupted VACUUM - Mailing list pgsql-bugs

From shihao zhong
Subject Re: Assertion failure in _bt_pagedel (leafblkno == scanblkno) after interrupted VACUUM
Date
Msg-id CAGRkXqRWHoeAFjdEyRmirBjG-z-AijAOPVF6PGhwfuhO7apyTA@mail.gmail.com
Whole thread
In response to Assertion failure in _bt_pagedel (leafblkno == scanblkno) after interrupted VACUUM  (Iliia Khaprov <i.khaprov@gmail.com>)
Responses Re: Assertion failure in _bt_pagedel (leafblkno == scanblkno) after interrupted VACUUM
List pgsql-bugs
Hi Iliia,

Thanks, I can reproduce this on master with your script.

_bt_pagedel() builds no descent stack when the page it is given is
already half-dead. If the right sibling of that page is empty too, it
steps right and builds the stack there. The assertion insisted that this
only happens for the initial page. That stopped being true once an
interrupted VACUUM could leave the initial page half-dead. 

Feels like the right way is to remove the assertion.

Thanks,
Shihao

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #19733: Row not visible to a new snapshot after its transactional logical decoding message has been streamed
Next
From: shihao zhong
Date:
Subject: Re: BUG #19705: One NaN box makes a BRIN box_inclusion_ops index omit unrelated rows