pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedXX000: invalid BTree prefetch end_key
4+ messages / 3 participants
[nested] [flat]
* XX000: invalid BTree prefetch end_key
@ 2021-02-11 16:01 srinivas oguri <srinivasoguri7@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: srinivas oguri @ 2021-02-11 16:01 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: XX000: invalid BTree prefetch end_key
@ 2021-02-11 16:06 Magnus Hagander <magnus@hagander.net>
parent: srinivas oguri <srinivasoguri7@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Magnus Hagander @ 2021-02-11 16:06 UTC (permalink / raw)
To: srinivas oguri <srinivasoguri7@gmail.com>; +Cc: pgsql-admin
On Thu, Feb 11, 2021 at 5:01 PM srinivas oguri <srinivasoguri7@gmail.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/
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: XX000: invalid BTree prefetch end_key
@ 2021-02-11 17:10 Tom Lane <tgl@sss.pgh.pa.us>
parent: Magnus Hagander <magnus@hagander.net>
0 siblings, 1 reply; 4+ messages in thread
From: Tom Lane @ 2021-02-11 17:10 UTC (permalink / raw)
To: Magnus Hagander <magnus@hagander.net>; +Cc: srinivas oguri <srinivasoguri7@gmail.com>; pgsql-admin
Magnus Hagander <magnus@hagander.net> writes:
> On Thu, Feb 11, 2021 at 5:01 PM srinivas oguri <srinivasoguri7@gmail.com> 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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: XX000: invalid BTree prefetch end_key
@ 2021-02-11 18:06 srinivas oguri <srinivasoguri7@gmail.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 4+ messages in thread
From: srinivas oguri @ 2021-02-11 18:06 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin
Thank you very much for your help
On Thu, Feb 11, 2021, 10:40 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Magnus Hagander <magnus@hagander.net> writes:
> > On Thu, Feb 11, 2021 at 5:01 PM srinivas oguri <srinivasoguri7@gmail.com>
> 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
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2021-02-11 18:06 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-02-11 16:01 XX000: invalid BTree prefetch end_key srinivas oguri <srinivasoguri7@gmail.com>
2021-02-11 16:06 ` Magnus Hagander <magnus@hagander.net>
2021-02-11 17:10 ` Tom Lane <tgl@sss.pgh.pa.us>
2021-02-11 18:06 ` srinivas oguri <srinivasoguri7@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox