Re: again trouble

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: again trouble
Дата
Msg-id 9150.1026480578@sss.pgh.pa.us
обсуждение исходный текст
Ответ на again trouble  ("Henrik Steffen" <steffen@city-map.de>)
Список pgsql-general
"Henrik Steffen" <steffen@city-map.de> writes:
> vacuum verbose analyze zugriffsrechte
> ERROR:  IndexSupportInitialize: no pg_index entry for index 14958692

> tom, could this again be due to a broken SD-RAM chip?

Perhaps.  It's certainly looking more and more like you've got some
kind of hardware problem ... Postgres is just not this flaky for most
people ;-).

If you wanted to dig into it, you could pg_filedump
pg_index_indrelid_index and look to see why it doesn't have an entry for
14958692.  My bet is that the entry is indeed there, but is not being
found --- either its own key is corrupted, or some nearby keys are
corrupted in a way that renders them out-of-order, causing binary search
to conclude the desired key is not present.  A single-bit error in the
key field would certainly suffice to cause such a problem.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: 7.2.1 optimises very badly against 7.2
Следующее
От: Tom Lane
Дата:
Сообщение: Re: plpgsql Cursor Mismatched Parentheses