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

asked Jul 26, 2022 at 17:08
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

Know someone who can answer? Share a link to this question via email, Twitter, or Facebook.

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.