From eric@vianet-express.com.br Tue May  20 13:56:18 2003
X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (unknown [64.117.224.193])
	by developer.postgresql.org (Postfix) with ESMTP id C498A924F93
	for <pgsql-sql@postgresql.org>; Tue, 20 May 2003 09:56:18 -0400 (EDT)
Received: from developer.postgresql.org ([64.117.224.193])
	by localhost (developer.postgresql.org [64.117.224.193:10024])
	(amavisd-new) with ESMTP id 58992-03 for <pgsql-sql@postgresql.org>;
	Tue, 20 May 2003 09:56:00 -0400 (EDT)
Received: from vianet-express.com.br (unknown [200.161.16.186])
	by developer.postgresql.org (Postfix) with ESMTP id 1D1CE924F87
	for <pgsql-sql@postgresql.org>; Tue, 20 May 2003 09:55:57 -0400 (EDT)
Received: from netterm ([192.168.1.7])
	by vianet-express.com.br (8.11.4/8.11.4) with SMTP id h4KDnjP02712
	for <pgsql-sql@postgresql.org>; Tue, 20 May 2003 10:49:46 -0300
Message-ID: <009101c31ed8$e4a89ad0$0701a8c0@netterm>
From: "Eric Anderson Vianet SAO" <eric@vianet-express.com.br>
To: <pgsql-sql@postgresql.org>
Subject: missing chunk number 0 for toast value 32067496
Date: Tue, 20 May 2003 11:05:38 -0300
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_008E_01C31EBF.BEC05B50"
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
X-Archive-Number: 200305/383
X-Sequence-Number: 13548

This is a multi-part message in MIME format.

------=_NextPart_000_008E_01C31EBF.BEC05B50
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi all

When I try vacuum (vacuumdb -e -f -z -v -t table -d database) it works unti=
ll certain point.=20
so, it return=B4s the error "missing chunk for toast value 32067496"

how could i fix it?

tnx

Eric Anderson Martins Miranda
Net Admin @ Via Net SAO

------=_NextPart_000_008E_01C31EBF.BEC05B50
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><FONT face=3DArial size=3D2>Hi all</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>When I try vacuum (vacuumdb -e -f -z -v -t=
 table -d=20
database) it works untill certain point. </FONT></DIV>
<DIV><FONT face=3DArial size=3D2>so, it return=B4s the error "missing chunk=
 for toast=20
value 32067496"</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>how could i fix it?</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>tnx</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Eric Anderson Martins Miranda<BR>Net Admin=
 @ Via=20
Net SAO</FONT></DIV></BODY></HTML>

------=_NextPart_000_008E_01C31EBF.BEC05B50--




From tgl@sss.pgh.pa.us Tue May  20 19:25:47 2003
X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (unknown [64.117.224.193])
	by developer.postgresql.org (Postfix) with ESMTP id CAE58925070
	for <pgsql-sql@postgresql.org>; Tue, 20 May 2003 15:25:47 -0400 (EDT)
Received: from developer.postgresql.org ([64.117.224.193])
	by localhost (developer.postgresql.org [64.117.224.193:10024])
	(amavisd-new) with ESMTP id 73926-08 for <pgsql-sql@postgresql.org>;
	Tue, 20 May 2003 15:25:41 -0400 (EDT)
Received: from sss.pgh.pa.us (unknown [192.204.191.242])
	by developer.postgresql.org (Postfix) with ESMTP id F10369251B1
	for <pgsql-sql@postgresql.org>; Tue, 20 May 2003 15:25:35 -0400 (EDT)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h4KJPUU6001105;
	Tue, 20 May 2003 15:25:30 -0400 (EDT)
To: "Eric Anderson Vianet SAO" <eric@vianet-express.com.br>
Cc: pgsql-sql@postgresql.org
Subject: Re: missing chunk number 0 for toast value 32067496 
In-reply-to: <009101c31ed8$e4a89ad0$0701a8c0@netterm> 
References: <009101c31ed8$e4a89ad0$0701a8c0@netterm>
Comments: In-reply-to "Eric Anderson Vianet SAO" <eric@vianet-express.com.br>
	message dated "Tue, 20 May 2003 11:05:38 -0300"
Date: Tue, 20 May 2003 15:25:29 -0400
Message-ID: <1104.1053458729@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: by amavisd-new
X-Archive-Number: 200305/399
X-Sequence-Number: 13564

"Eric Anderson Vianet SAO" <eric@vianet-express.com.br> writes:
> When I try vacuum (vacuumdb -e -f -z -v -t table -d database) it works unti=
> ll certain point.=20
> so, it return=B4s the error "missing chunk for toast value 32067496"

> how could i fix it?

You could try reindexing the toast table associated with whichever table
is getting the failure.  Not sure that will help, but it's worth trying.

			regards, tom lane