From: Tom Lane <tgl@sss.pgh.pa.us>
To: cristi <cristi@dmhi.ct.ro>
Cc: pgsql-sql@postgresql.org
Subject: Re: FATAL 2: PageIndexTupleDelete
Date: Wed, 19 Nov 2003 23:19:05 -0500
Message-ID: <1036.1069301945@sss.pgh.pa.us> (raw)
In-Reply-To: <004801c3acfc$c6b395e0$7201a8c0@aaa>
References: <004801c3acfc$c6b395e0$7201a8c0@aaa>
"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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, cristi@dmhi.ct.ro
Subject: Re: FATAL 2: PageIndexTupleDelete
In-Reply-To: <1036.1069301945@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox