Hi,
On Mon, Mar 15, 2021 at 1:18 PM Peter Geoghegan <p...@bowt.ie> wrote:
> On Mon, Mar 15, 2021 at 6:56 AM Avinash Kumar
> <avinash.vallar...@gmail.com> wrote:
> > psql:amchecksql.sql:17: DEBUG: leaf block 1043751 of index
> "idx_id_mtime" has no first data item
>
> That one is harmless.
>
> > And one error as follows.
> >
> > psql:amchecksql.sql:17: ERROR: down-link lower bound invariant violated
> for index "some_other_index"
>
> That indicates corruption. Can you tie this back to the crash? Is it
> the same index?
>
No, that's not the same index. The Index discussed in the previous
messages shows the following output.
DEBUG: verifying consistency of tree structure for index "idx_id_mtime"
with cross-level checks
DEBUG: verifying level 2 (true root level)
DEBUG: verifying level 1
DEBUG: verifying level 0 (leaf level)
DEBUG: verifying that tuples from index "idx_id_mtime" are present in
"player"
DEBUG: finished verifying presence of 1966412 tuples from table "player"
with bitset 29.89% set
LOG: duration: 3341.755 ms statement: SELECT bt_index_parent_check(index
=> c.oid, heapallindexed => true), c.relname, c.relpages FROM pg_index i
JOIN pg_opclass op ON i.indclass[0] = op.oid JOIN pg_am am ON op.opcmethod
= am.oid JOIN pg_class c ON i.indexrelid = c.oid JOIN pg_namespace n ON
c.relnamespace = n.oid WHERE am.amname = 'btree' AND c.relpersistence !=
't' AND c.relkind = 'i' AND i.indisready AND i.indisvalid AND indexrelid =
80774 AND n.nspname = 'public' ORDER BY c.relpages DESC;
bt_index_parent_check | relname | relpages
-----------------------+-----------------+----------
| idx_id_mtime | 8439
(1 row)
> --
> Peter Geoghegan
>
--
Regards,
Avi.
