XX000: invalid BTree prefetch end_key

From: srinivas oguri <srinivasoguri7(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: XX000: invalid BTree prefetch end_key
Date: 2021-02-11 16:01:15
Message-ID: CADfH0yvM8JsCDjh1MUv6KogeL1iibPzJUgoAPdsd58FNXrDtHw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Team,

we are facing an issue in our production, when we do update a query we are
getting below error and the server is crashing.

The table is a temporary table.

PostgrESQL version : 9.6.19
Hardware : AWS Aurora

[32120]:STATEMENT: UPDATE g_inserts_76077f1c_1
SET knowledge_end_date = other.knowledge_date
FROM g_later_revisions_b4fcbc7d_3 other
WHERE ..............................
...........................................
2021-02-11 15:23:36 UTC:10.12.90.41(60874):@:[32120]:PANIC: XX000: invalid
BTree prefetch end_key
2021-02-11 15:23:36 UTC:10.12.90.41(60874):@:[32120]:LOCATION:
_bt_prefetch_if_needed, nbtree.c:1255

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Magnus Hagander 2021-02-11 16:06:38 Re: XX000: invalid BTree prefetch end_key
Previous Message Aislan Luiz Wendling 2021-02-11 14:03:33 Re: Looking for db statistics report