Postgres Pro
Downloads
Home   >   mailing lists

Re: ERROR: missing chunk number 0 for toast value 382548694 in pg_toast_847386 - Mailing list pgsql-general

From Vibhor Kumar
Subject Re: ERROR: missing chunk number 0 for toast value 382548694 in pg_toast_847386
Date
Msg-id 132BC6A6-0C40-46BD-8CF3-43F23BD9A749@enterprisedb.com
Whole thread Raw
In response to ERROR: missing chunk number 0 for toast value 382548694 in pg_toast_847386  (Michael Harris <michael.harris@ericsson.com>)
Responses Re: ERROR: missing chunk number 0 for toast value 382548694 in pg_toast_847386  (Michael Harris <michael.harris@ericsson.com>)
List pgsql-general
Tree view 
On Feb 28, 2011, at 5:55 AM, Michael Harris wrote:

> ERROR:  missing chunk number 0 for toast value 382548694 in pg_toast_847386



This seems more like a corrupted toast table.

Did you try to reindex the pg_toast_847386?
REINDEX table pg_toast.pg_toast_847386;
VACUUM ANALYZE <tablename>;


Thanks & Regards,
Vibhor Kumar
vibhor.kumar@enterprisedb.com
Blog:http://vibhork.blogspot.com

pgsql-general by date:

Previous
From: Robert Treat
Date:
Subject: Re: PG on two nodes with shared disk ocfs2 & drbd
Next
From: Robert Treat
Date:
Subject: Re: Question about switchover with PG9 replication