pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedIndex is not a btree
4+ messages / 3 participants
[nested] [flat]
* Index is not a btree
@ 2022-07-26 20:22 OS DB2 <opensourcedb2@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: OS DB2 @ 2022-07-26 20:22 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Index is not a btree
@ 2022-07-26 20:26 David G. Johnston <david.g.johnston@gmail.com>
parent: OS DB2 <opensourcedb2@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: David G. Johnston @ 2022-07-26 20:26 UTC (permalink / raw)
To: OS DB2 <opensourcedb2@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Index is not a btree
@ 2022-07-26 21:47 OS DB2 <opensourcedb2@gmail.com>
parent: David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: OS DB2 @ 2022-07-26 21:47 UTC (permalink / raw)
To: David G. Johnston <david.g.johnston@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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.
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Index is not a btree
@ 2022-07-26 21:51 Scott Ribe <scott_ribe@elevated-dev.com>
parent: OS DB2 <opensourcedb2@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: Scott Ribe @ 2022-07-26 21:51 UTC (permalink / raw)
To: OS DB2 <opensourcedb2@gmail.com>; +Cc: David G. Johnston <david.g.johnston@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
> 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.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2022-07-26 21:51 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-07-26 20:22 Index is not a btree OS DB2 <opensourcedb2@gmail.com>
2022-07-26 20:26 ` David G. Johnston <david.g.johnston@gmail.com>
2022-07-26 21:47 ` OS DB2 <opensourcedb2@gmail.com>
2022-07-26 21:51 ` Scott Ribe <scott_ribe@elevated-dev.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox