pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
missing chunk number 0 for toast value 32067496
2+ messages / 2 participants
[nested] [flat]

* missing chunk number 0 for toast value 32067496
@ 2003-05-20 14:05  Eric Anderson Vianet SAO <eric@vianet-express.com.br>
  0 siblings, 1 reply; 2+ messages in thread

From: Eric Anderson Vianet SAO @ 2003-05-20 14:05 UTC (permalink / raw)
  To: pgsql-sql

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

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: missing chunk number 0 for toast value 32067496
@ 2003-05-20 19:25  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Eric Anderson Vianet SAO <eric@vianet-express.com.br>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2003-05-20 19:25 UTC (permalink / raw)
  To: Eric Anderson Vianet SAO <eric@vianet-express.com.br>; +Cc: 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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2003-05-20 19:25 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-05-20 14:05 missing chunk number 0 for toast value 32067496 Eric Anderson Vianet SAO <eric@vianet-express.com.br>
2003-05-20 19:25 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox