From cristi@dmhi.ct.ro Mon Nov  17 11:20:35 2003
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 0C3D3D1D8D2
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 17 Nov 2003 11:20:35 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 37739-10
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 17 Nov 2003 07:20:05 -0400 (AST)
Received: from dmhi.ct.ro (dmhi.ct.ro [193.226.151.66])
	by svr1.postgresql.org (Postfix) with ESMTP id 736DCD1D88A
	for <pgsql-sql@postgresql.org>; Mon, 17 Nov 2003 07:20:01 -0400 (AST)
Received: from [192.168.1.114] (helo=aaa)
	by dmhi.ct.ro with smtp (Exim 3.03 #1) id 1ALjHO-0007nt-00
	for pgsql-sql@postgresql.org; Mon, 17 Nov 2003 15:18:58 +0200
Message-ID: <004801c3acfc$c6b395e0$7201a8c0@aaa>
From: "cristi" <cristi@dmhi.ct.ro>
To: <pgsql-sql@postgresql.org>
Subject: FATAL 2: PageIndexTupleDelete
Date: Mon, 17 Nov 2003 13:20:16 +0200
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0045_01C3AD0D.8A34C4C0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2615.200
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=0.6 tagged_above=0.0 required=5.0 tests=HTML_30_40
X-Spam-Level: 
X-Archive-Number: 200311/192
X-Sequence-Number: 16007

This is a multi-part message in MIME format.

------=_NextPart_000_0045_01C3AD0D.8A34C4C0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

salt=3D# vacuum full;

FATAL 2: PageIndexTupleDelete: corrupted page pointers: lower =3D 12289, up=
per =3D

1, special =3D 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.

=20

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


------=_NextPart_000_0045_01C3AD0D.8A34C4C0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2614.3500" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>
<DIV><FONT size=3D2>
<P>salt=3D# vacuum full;</P>
<P>FATAL 2: PageIndexTupleDelete: corrupted page pointers: lower =3D 12289,=
 upper=20
=3D</P>
<P>1, special =3D 60672</P>
<P>server closed the connection unexpectedly</P>
<P>This probably means the server terminated abnormally</P>
<P>before or while processing the request.</P>
<P>The connection to the server was lost. Attempting reset: Succeeded.</P>
<P><FONT face=3DArial></FONT>&nbsp;</P>
<P><FONT face=3DArial>Why do I have this error message and how can I fix=20
it?</FONT></P></FONT></DIV></FONT></DIV></BODY></HTML>

------=_NextPart_000_0045_01C3AD0D.8A34C4C0--





From mendola@bigfoot.com Mon Nov  17 23:48:24 2003
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 65EF8D1BB92
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 17 Nov 2003 23:48:24 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 79037-10
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 17 Nov 2003 19:47:55 -0400 (AST)
Received: from pns.mm.eutelsat.org (pns.mm.eutelsat.org [194.214.173.227])
	by svr1.postgresql.org (Postfix) with ESMTP id 1650DD1BB42
	for <pgsql-sql@postgresql.org>; Mon, 17 Nov 2003 19:47:52 -0400 (AST)
Received: from nts-03.mm.eutelsat.org (localhost [127.0.0.1])
	by pns.mm.eutelsat.org (8.11.6/linuxconf) with ESMTP id hAHNomB06211;
	Tue, 18 Nov 2003 00:50:48 +0100
Received: from bigfoot.com (accesspoint.mm.eutelsat.org [194.214.173.4])
	by nts-03.mm.eutelsat.org (8.11.6/linuxconf) with ESMTP id hAHNbDR28891;
	Tue, 18 Nov 2003 00:37:13 +0100
Message-ID: <3FB95DEA.6000509@bigfoot.com>
Date: Tue, 18 Nov 2003 00:46:50 +0100
From: Gaetano Mendola <mendola@bigfoot.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
	rv:1.5) Gecko/20031013 Thunderbird/0.3
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
Cc: cristi <cristi@dmhi.ct.ro>
Subject: Re: FATAL 2: PageIndexTupleDelete
References: <004801c3acfc$c6b395e0$7201a8c0@aaa>
In-Reply-To: <004801c3acfc$c6b395e0$7201a8c0@aaa>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200311/207
X-Sequence-Number: 16022

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





From tgl@sss.pgh.pa.us Thu Nov  20 04:19:57 2003
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 43FBCD1B510
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 20 Nov 2003 04:19:57 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 37422-09
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 20 Nov 2003 00:19:25 -0400 (AST)
Received: from sss.pgh.pa.us (unknown [192.204.191.242])
	by svr1.postgresql.org (Postfix) with ESMTP id D4AF3D1B4F6
	for <pgsql-sql@postgresql.org>; Thu, 20 Nov 2003 00:19:24 -0400 (AST)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.12.10/8.12.10) with ESMTP id hAK4J619001037;
	Wed, 19 Nov 2003 23:19:06 -0500 (EST)
To: "cristi" <cristi@dmhi.ct.ro>
Cc: pgsql-sql@postgresql.org
Subject: Re: FATAL 2: PageIndexTupleDelete 
In-reply-to: <004801c3acfc$c6b395e0$7201a8c0@aaa> 
References: <004801c3acfc$c6b395e0$7201a8c0@aaa>
Comments: In-reply-to "cristi" <cristi@dmhi.ct.ro>
	message dated "Mon, 17 Nov 2003 13:20:16 +0200"
Date: Wed, 19 Nov 2003 23:19:05 -0500
Message-ID: <1036.1069301945@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200311/248
X-Sequence-Number: 16063

"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



From cristi@dmhi.ct.ro Fri Nov  21 06:21:16 2003
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (neptune.hub.org [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 76DE2D1D458
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 21 Nov 2003 06:21:16 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 03049-03
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 21 Nov 2003 02:20:46 -0400 (AST)
Received: from dmhi.ct.ro (dmhi.ct.ro [193.226.151.66])
	by svr1.postgresql.org (Postfix) with ESMTP id E7D17D1D247
	for <pgsql-sql@postgresql.org>; Fri, 21 Nov 2003 02:20:36 -0400 (AST)
Received: from [192.168.2.114] (helo=aaa)
	by dmhi.ct.ro with smtp (Exim 3.03 #1) id 1AN6VU-0003aL-00
	for pgsql-sql@postgresql.org; Fri, 21 Nov 2003 10:19:12 +0200
Message-ID: <003e01c3aff7$8475c740$7202a8c0@aaa>
From: "cristi" <cristi@dmhi.ct.ro>
To: <pgsql-sql@postgresql.org>
References: <004801c3acfc$c6b395e0$7201a8c0@aaa>
	<1036.1069301945@sss.pgh.pa.us>
Subject: Re: FATAL 2: PageIndexTupleDelete 
Date: Fri, 21 Nov 2003 08:20:10 +0200
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200311/254
X-Sequence-Number: 16069

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
>