Обсуждение: XX000: invalid BTree prefetch end_key
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
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/
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
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