From: | Magnus Hagander <magnus(at)hagander(dot)net> |
---|---|
To: | srinivas oguri <srinivasoguri7(at)gmail(dot)com> |
Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: XX000: invalid BTree prefetch end_key |
Date: | 2021-02-11 16:06:38 |
Message-ID: | CABUevEx3bnN6Szr8zQBOyBuwra1PGWEeYWz8+H82yg1c-c236g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Thu, Feb 11, 2021 at 5:01 PM srinivas oguri <srinivasoguri7(at)gmail(dot)com> wrote:
>
> 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
You need to send Aurora issues to AWS support, not to the PostgreSQL
community. In particular, anything related to storage is very
different in Aurora.
Note that Aurora is a different product from PostgreSQL, it's not
"PostgreSQL running on different hardware". RDS PostgreSQL is mostly
standard PostgreSQL hosted by aws, but Aurora is not.
--
Magnus Hagander
Me: https://www.hagander.net/
Work: https://www.redpill-linpro.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2021-02-11 17:10:13 | Re: XX000: invalid BTree prefetch end_key |
Previous Message | srinivas oguri | 2021-02-11 16:01:15 | XX000: invalid BTree prefetch end_key |