pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedFATAL 2: PageIndexTupleDelete
4+ messages / 3 participants
[nested] [flat]
* FATAL 2: PageIndexTupleDelete
@ 2003-11-17 11:20 cristi <cristi@dmhi.ct.ro>
0 siblings, 2 replies; 4+ messages in thread
From: cristi @ 2003-11-17 11:20 UTC (permalink / raw)
To: pgsql-sql
salt=# vacuum full;
FATAL 2: PageIndexTupleDelete: corrupted page pointers: lower = 12289, upper =
1, special = 60672
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.
Why do I have this error message and how can I fix it?
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: FATAL 2: PageIndexTupleDelete
@ 2003-11-17 23:46 Gaetano Mendola <mendola@bigfoot.com>
parent: cristi <cristi@dmhi.ct.ro>
1 sibling, 0 replies; 4+ messages in thread
From: Gaetano Mendola @ 2003-11-17 23:46 UTC (permalink / raw)
To: pgsql-sql; +Cc: cristi <cristi@dmhi.ct.ro>
cristi wrote:
> salt=# vacuum full;
>
> FATAL 2: PageIndexTupleDelete: corrupted page pointers: lower = 12289,
> upper =
>
> 1, special = 60672
>
> server closed the connection unexpectedly
>
> This probably means the server terminated abnormally
>
> before or while processing the request.
>
> The connection to the server was lost. Attempting reset: Succeeded.
>
>
>
> Why do I have this error message and how can I fix it?
Wich version are you running, and what about
give us informations on your platform ?
Regards
Gaetano Mendola
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: FATAL 2: PageIndexTupleDelete
@ 2003-11-20 04:19 Tom Lane <tgl@sss.pgh.pa.us>
parent: cristi <cristi@dmhi.ct.ro>
1 sibling, 1 reply; 4+ messages in thread
From: Tom Lane @ 2003-11-20 04:19 UTC (permalink / raw)
To: cristi <cristi@dmhi.ct.ro>; +Cc: 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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: FATAL 2: PageIndexTupleDelete
@ 2003-11-21 06:20 cristi <cristi@dmhi.ct.ro>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 4+ messages in thread
From: cristi @ 2003-11-21 06:20 UTC (permalink / raw)
To: 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
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2003-11-21 06:20 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-11-17 11:20 FATAL 2: PageIndexTupleDelete cristi <cristi@dmhi.ct.ro>
2003-11-17 23:46 ` Gaetano Mendola <mendola@bigfoot.com>
2003-11-20 04:19 ` Tom Lane <tgl@sss.pgh.pa.us>
2003-11-21 06:20 ` cristi <cristi@dmhi.ct.ro>
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