On Thu, Nov 4, 2021 at 11:08 AM Maxim Boguk <maxim.boguk@gmail.com> wrote:
> select bt_index_check('pg_toast.pg_toast_2624976286_index', true);
> DEBUG: verifying consistency of tree structure for index
> "pg_toast_2624976286_index"
> DEBUG: verifying level 3 (true root level)
> DEBUG: verifying level 2
> DEBUG: verifying level 1
> DEBUG: verifying level 0 (leaf level)
> DEBUG: leaf block 715360 of index "pg_toast_2624976286_index" has no
> first data item
> DEBUG: verifying that tuples from index "pg_toast_2624976286_index"
> are present in "pg_toast_2624976286"
> ERROR: heap tuple (59561917,1) from table "pg_toast_2624976286" lacks
> matching index tuple within index "pg_toast_2624976286_index"
> HINT: Retrying verification using the function
> bt_index_parent_check() might provide a more specific error.
That's an unusually large TOAST table. It's at least ~454.42GiB, based
on this error. Is the block number 59561917 near the end of the table?
Structural verification of the B-Tree itself doesn't throw any errors
here. This leaves little doubt that the problem is that the index is
missing entries that it really should have. That's not really new
information, though -- I was pretty sure of that much already.
--
Peter Geoghegan