X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 34168D1C9AB
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  8 Aug 2003 17:40:18 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 63974-02
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  8 Aug 2003 14:38:50 -0300 (ADT)
Received: from vianet-express.com.br (unknown [200.161.16.186])
	by svr1.postgresql.org (Postfix) with ESMTP id B967ED1C4BF
	for <pgsql-sql@postgresql.org>; Fri,  8 Aug 2003 14:40:03 -0300 (ADT)
Received: from netterm ([192.168.1.7])
	by vianet-express.com.br (8.11.4/8.11.4) with SMTP id h78Haix02771
	for <pgsql-sql@postgresql.org>; Fri, 8 Aug 2003 14:36:44 -0300
Message-ID: <02b401c35dd4$3122a5b0$0701a8c0@netterm>
From: "Eric Anderson Vianet SAO" <eric@vianet-express.com.br>
To: <pgsql-sql@postgresql.org>
Subject: unexpected chunk value
Date: Fri, 8 Aug 2003 14:40:42 -0300
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_02B1_01C35DBB.0B81F680"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.50.4807.1700
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=2.6 tagged_above=0.0 required=5.0 tests=BAYES_30,
	HTML_20_30, RCVD_IN_OSIRUSOFT_COM, RCVD_IN_SBL
X-Spam-Level: **
X-Archive-Number: 200308/76
X-Sequence-Number: 14692

This is a multi-part message in MIME format.

------=_NextPart_000_02B1_01C35DBB.0B81F680
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


hello all

When i tried =B4pg_dump -v -f dump.dmp dtbtransporte=B4 I got the error:

pg_dump: restoring data for table tbdmovimento

pg_dump: dumping out the contents of table tbdmovimento

pg_dump: ERROR: unexpected chunk number 8 (expected 0) for toast value 6935=
693

pg_dump: lost synchronization with server, resetting connection

pg_dump: SQL command to dump the contents of table "tbdmovimento" failed: P=
Qendcopy() failed.

pg_dump: Error message from server: pg_dump: The command was: COPY "tbdmovi=
mento" TO stdout;

pg_dump: *** aborted because of error



So I=B4ve ran a query to see which pg_toast from this tbdmovimento

So I shutdown de postmaster and up a standalone backend and reindexed the d=
atabase (REINDEX DATABASE dtbtransporte FORCE). All this after a vacuum ana=
lyze.

How the pg_dump still returns above error, I=B4ve tried to REINDEX the inde=
x pg_toast_16557. Reindex ran ok, but the pg_dump still returns this error.



any ideas.

tnx

Eric

=20

------=_NextPart_000_02B1_01C35DBB.0B81F680
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.3502.5390" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>
<DIV><FONT size=3D2>
<P><FONT face=3DArial>hello all</FONT></P>
<P><FONT face=3DArial>When i tried =B4pg_dump -v -f dump.dmp dtbtransporte=
=B4 I got=20
the error:</FONT></P>
<P>pg_dump: restoring data for table tbdmovimento</P>
<P>pg_dump: dumping out the contents of table tbdmovimento</P>
<P>pg_dump: ERROR: unexpected chunk number 8 (expected 0) for toast value=
=20
6935693</P>
<P>pg_dump: lost synchronization with server, resetting connection</P>
<P>pg_dump: SQL command to dump the contents of table "tbdmovimento" failed=
:=20
PQendcopy() failed.</P>
<P>pg_dump: Error message from server: pg_dump: The command was: COPY=20
"tbdmovimento" TO stdout;</P>
<P>pg_dump: *** aborted because of error</P>
<P>&nbsp;</P>
<P><FONT face=3DArial>So I=B4ve ran a query to see which pg_toast from this=
=20
tbdmovimento</FONT></P>
<P><FONT face=3DArial>So I shutdown de postmaster and up a standalone backe=
nd and=20
reindexed the database (REINDEX DATABASE dtbtransporte FORCE). All this aft=
er a=20
vacuum analyze.</FONT></P>
<P><FONT face=3DArial>How the pg_dump still returns above error, I=B4ve tri=
ed to=20
REINDEX the index pg_toast_16557. Reindex ran ok, but the pg_dump still ret=
urns=20
this error.</FONT></P>
<P>&nbsp;</P>
<P><FONT face=3DArial>any ideas.</FONT></P>
<P><FONT face=3DArial>tnx</FONT></P>
<P><FONT=20
face=3DArial>Eric</FONT></P></FONT></DIV></FONT>&nbsp;</DIV></BODY></HTML>

------=_NextPart_000_02B1_01C35DBB.0B81F680--