Обсуждение: pg_index_indrelid_index error, any ideas ??

Поиск
Список
Период
Сортировка

pg_index_indrelid_index error, any ideas ??

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



Re: pg_index_indrelid_index error, any ideas ??

От
Tom Lane
Дата:
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