Postgres Pro
Downloads
Home   >   mailing lists

Thread: missing chunk number 0 for toast value 32067496

missing chunk number 0 for toast value 32067496

From
"Eric Anderson Vianet SAO"
Date:
Hi all
 
When I try vacuum (vacuumdb -e -f -z -v -t table -d database) it works untill certain point.
so, it return´s the error "missing chunk for toast value 32067496"
 
how could i fix it?
 
tnx
 
Eric Anderson Martins Miranda
Net Admin @ Via Net SAO

Re: missing chunk number 0 for toast value 32067496

From
Tom Lane
Date:
"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