On Mon, Mar 15, 2021 at 3:21 PM Avinash Kumar <avinash.vallar...@gmail.com> wrote:
> 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. > I am afraid that it looks to me like a deduplication bug but not sure how this can be pin-pointed. If there is something I could do to determine that, I would be more than happy. -- Regards, Avi
