Re: FATAL 2: PageIndexTupleDelete - Mailing list pgsql-sql

From Tom Lane
Subject Re: FATAL 2: PageIndexTupleDelete
Date
Msg-id 1036.1069301945@sss.pgh.pa.us
Whole thread Raw
In response to FATAL 2: PageIndexTupleDelete  ("cristi" <cristi@dmhi.ct.ro>)
List 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 by date:

Previous
From: "Iain"
Date:
Subject: Re: fmgr_info: function 15238119: cache lookup failed
Next
From: Erik Thiele
Date:
Subject: current_date timezone documentation suggestion