Re: Index is not a btree

Поиск
Список
Период
Сортировка
От OS DB2
Тема Re: Index is not a btree
Дата
Msg-id CAM==JRFL8V3pbsVMP1KZPiLR8TPZ5MO65QHkmT=Gm_W6hQKT9Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Index is not a btree  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: Index is not a btree  (Scott Ribe <scott_ribe@elevated-dev.com>)
Список 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 по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Index is not a btree
Следующее
От: Scott Ribe
Дата:
Сообщение: Re: Index is not a btree