Re: missing chunk number 0 for toast value 32067496 - Mailing list pgsql-sql

From Tom Lane
Subject Re: missing chunk number 0 for toast value 32067496
Date
Msg-id 1104.1053458729@sss.pgh.pa.us
Whole thread Raw
In response to missing chunk number 0 for toast value 32067496  ("Eric Anderson Vianet SAO" <eric@vianet-express.com.br>)
List pgsql-sql
"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


pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: how to do this query?
Next
From: edouard.boucher@free.fr
Date:
Subject: selecting entire row on which one field is the minimum