| 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: | Whole Thread | Raw Message | 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.
>
| 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 |