XX000: invalid BTree prefetch end_key

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

XX000: invalid BTree prefetch end_key

srinivas oguri
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
Reply | Threaded
Open this post in threaded view
|

Re: XX000: invalid BTree prefetch end_key

Magnus Hagander-2
On Thu, Feb 11, 2021 at 5:01 PM srinivas oguri <[hidden email]> 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/


Reply | Threaded
Open this post in threaded view
|

Re: XX000: invalid BTree prefetch end_key

Tom Lane-2
Magnus Hagander <[hidden email]> writes:
> On Thu, Feb 11, 2021 at 5:01 PM srinivas oguri <[hidden email]> wrote:
>> 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.

Indeed, neither the quoted message text nor the function
bt_prefetch_if_needed appear at all in community Postgres.
So this is definitely Aurora-specific.

                        regards, tom lane


Reply | Threaded
Open this post in threaded view
|

Re: XX000: invalid BTree prefetch end_key

srinivas oguri
Thank you very much for your help

On Thu, Feb 11, 2021, 10:40 PM Tom Lane <[hidden email]> wrote:
Magnus Hagander <[hidden email]> writes:
> On Thu, Feb 11, 2021 at 5:01 PM srinivas oguri <[hidden email]> wrote:
>> 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.

Indeed, neither the quoted message text nor the function
bt_prefetch_if_needed appear at all in community Postgres.
So this is definitely Aurora-specific.

                        regards, tom lane