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

From: Vibhor Kumar <vibhor(dot)kumar(at)enterprisedb(dot)com>
To: Michael Harris <michael(dot)harris(at)ericsson(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: ERROR: missing chunk number 0 for toast value 382548694 in pg_toast_847386
Date: 2011-02-28 04:06:25
Message-ID: 132BC6A6-0C40-46BD-8CF3-43F23BD9A749@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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(dot)kumar(at)enterprisedb(dot)com
Blog:http://vibhork.blogspot.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert Treat 2011-02-28 04:11:54 Re: Question about switchover with PG9 replication
Previous Message Jack Su 2011-02-28 03:44:20 Win32 8.3.3 install fail (sufficient privileges to install system services)