pg_index_indrelid_index error, any ideas ??

Started by Nonameover 20 years ago2 messagesgeneral
Jump to latest
#1Noname
aw_contact@inbox.ru

I've got an error from postgresql server -
"ERROR: root page 1 of "pg_index_indrelid_index" has level 512, expected 0"
This error appears on every command and i can't do anything with my
database. Is it possible to solve this problem ?

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Noname (#1)
Re: pg_index_indrelid_index error, any ideas ??

aw_contact@inbox.ru writes:

I've got an error from postgresql server -
"ERROR: root page 1 of "pg_index_indrelid_index" has level 512, expected 0"
This error appears on every command and i can't do anything with my
database. Is it possible to solve this problem ?

See REINDEX.  Also you ought to run some memory and disk diagnostics
--- it looks like some part of your hardware dropped a bit.

regards, tom lane