Re: Index is not a btree - Mailing list pgsql-admin

From OS DB2
Subject Re: Index is not a btree
Date
Msg-id CAM==JRFL8V3pbsVMP1KZPiLR8TPZ5MO65QHkmT=Gm_W6hQKT9Q@mail.gmail.com
Whole thread Raw
In response to Re: Index is not a btree  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Index is not a btree
List 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.g.johnston@gmail.com> wrote:
On Tue, Jul 26, 2022 at 1:23 PM OS DB2 <opensourcedb2@gmail.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.

pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Index is not a btree
Next
From: Scott Ribe
Date:
Subject: Re: Index is not a btree