Thread: Index is not a btree
Hi,
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??
Regards,
OS DBA
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.
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.
> On Jul 26, 2022, at 3:47 PM, OS DB2 <opensourcedb2@gmail.com> wrote: > > DB version is 10.7.15. There is no PostgreSQL version 10.7.15. That must be the version of something else--maybe client library or application? There is an Enterprise DB 10.7.15, but if you're using EDB you need to ask them for support.