0

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??

Improve this question
6
  • Sounds like the field identifying the type of index got corrupted. What was the exact error message? Commented Jul 26, 2022 at 17:31
  • What was the statement that caused that error? Commented Jul 26, 2022 at 19:01
  • All the statements fired in db related to that table caused the error. The error was same as the title. Commented Jul 27, 2022 at 5:02
  • That is not a Postgres error message. What is the output of select version();? Commented Jul 27, 2022 at 5:18
  • EnterpriseDB 10.7.15, compiled by Visual C++ build 1800, 64-bit Commented Jul 27, 2022 at 7:03

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.