From: | Avinash Kumar <avinash(dot)vallarapu(at)gmail(dot)com> |
---|---|
To: | Peter Geoghegan <pg(at)bowt(dot)ie> |
Cc: | Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Postgres crashes at memcopy() after upgrade to PG 13. |
Date: | 2021-03-15 18:21:33 |
Message-ID: | CAN0TujfgV09uVhe49ONVX+Y-HdMBORixRx19biizirhz10bJ5A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Hi,
On Mon, Mar 15, 2021 at 1:18 PM Peter Geoghegan <pg(at)bowt(dot)ie> wrote:
> On Mon, Mar 15, 2021 at 6:56 AM Avinash Kumar
> <avinash(dot)vallarapu(at)gmail(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Fred Habash | 2021-03-15 19:20:39 | Allowing John to Drop Triggers On Chad's Tables |
Previous Message | Laurenz Albe | 2021-03-15 17:01:23 | Re: Fwd: row level security (RLS) |
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Dilger | 2021-03-15 18:32:41 | Re: REINDEX backend filtering |
Previous Message | Fujii Masao | 2021-03-15 18:12:54 | Type of wait events WalReceiverWaitStart and WalSenderWaitForWAL |