Re: missing chunk number 0 for toast value 32067496

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Eric Anderson Vianet SAO" <eric(at)vianet-express(dot)com(dot)br>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: missing chunk number 0 for toast value 32067496
Date: 2003-05-20 19:25:29
Message-ID: 1104.1053458729@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Eric Anderson Vianet SAO" <eric(at)vianet-express(dot)com(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Kevin Ready 2003-05-20 22:49:42 Another sub-select problem...
Previous Message Stephan Szabo 2003-05-20 17:49:42 Re: how to do this query?