Re: FATAL 2: PageIndexTupleDelete

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: FATAL 2: PageIndexTupleDelete
Дата
Msg-id 1036.1069301945@sss.pgh.pa.us
обсуждение исходный текст
Ответ на FATAL 2: PageIndexTupleDelete  ("cristi" <cristi@dmhi.ct.ro>)
Список pgsql-sql
"cristi" <cristi@dmhi.ct.ro> writes:
> FATAL 2: PageIndexTupleDelete: corrupted page pointers: lower =3D 12289, up=
> per =3D
> 1, special =3D 60672

> Why do I have this error message and how can I fix it?

This is a data-corruption problem.  Have you had any system crashes or
other odd behavior lately?

As far as recovering, you can probably fix the broken index with
REINDEX, if the corruption doesn't extend further than the index that's
being complained of.  Otherwise you might have to resort to a dump and
reload.

You should also think about updating your Postgres installation.  You
didn't say what version you're running (naughty naughty, that's required
info in any trouble report) but I can tell from the spelling of the
error message that it's not a current release.
        regards, tom lane


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

Предыдущее
От: "Iain"
Дата:
Сообщение: Re: fmgr_info: function 15238119: cache lookup failed
Следующее
От: Erik Thiele
Дата:
Сообщение: current_date timezone documentation suggestion