Re: FATAL 2: PageIndexTupleDelete

Поиск
Список
Период
Сортировка
От cristi
Тема Re: FATAL 2: PageIndexTupleDelete
Дата
Msg-id 003e01c3aff7$8475c740$7202a8c0@aaa
обсуждение исходный текст
Ответ на FATAL 2: PageIndexTupleDelete  ("cristi" <cristi@dmhi.ct.ro>)
Список pgsql-sql
Yes, you right!
I used pg_dump command and now is working.
Thank you very much!

PS.
I have version 7.2.2 on RH 8.0

> > 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 по дате отправления:

Предыдущее
От: "Jerry Wintrode"
Дата:
Сообщение: Re: Need another way to do this, my sql much to slow...
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Expressional Indexes