Re: Index is not a btree

From: OS DB2 <opensourcedb2(at)gmail(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Index is not a btree
Date: 2022-07-26 21:47:27
Message-ID: CAM==JRFL8V3pbsVMP1KZPiLR8TPZ5MO65QHkmT=Gm_W6hQKT9Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

DB version is 10.7.15.

We observed the error during execution of select statement. On every
execution of select statement we were observing the same error and was not
able to fetch the output.

Regards,
Nikhil

On Wed, 27 Jul 2022, 01:56 David G. Johnston, <david(dot)g(dot)johnston(at)gmail(dot)com>
wrote:

> On Tue, Jul 26, 2022 at 1:23 PM OS DB2 <opensourcedb2(at)gmail(dot)com> wrote:
>
>> In our production, environment suddenly we recieved error that *index is
>> not a btree *for one index.After performing reindex on the same, we were
>> able to access the table, But we are unable to get root cause of the issue.
>> Can any one help us??
>>
>>
> What did you execute that provoked the error and was it reproducible prior
> to the reindex?
>
> What version? What is the exact error message?
>
> David J.
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Ribe 2022-07-26 21:51:07 Re: Index is not a btree
Previous Message David G. Johnston 2022-07-26 20:26:25 Re: Index is not a btree