Re: missing chunk 0 for toast value ...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andrew Hammond <andrew(dot)george(dot)hammond(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: missing chunk 0 for toast value ...
Date: 2011-10-25 21:20:16
Message-ID: 28935.1319577616@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Andrew Hammond <andrew(dot)george(dot)hammond(at)gmail(dot)com> writes:
> Oct 24 04:05:57 db-app02 postgres[24640]: [2-1]
> user=nutricate,db=admin_production ERROR: missing chunk number 0 for
> toast value
> 2411466 in pg_toast_2619

Hmm ... pg_toast_2619 is pg_statistic's toast table. Is this 9.0.x,
and are you by any chance in the habit of running CLUSTER or VACUUM FULL
on your system catalogs? Could one have been running in the background
when this happened?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob_pg 2011-10-25 21:24:47 Re: writing a foreign data wrapper for hdfs, but getting and undefined symbol error for hdfsConnect
Previous Message Merlin Moncure 2011-10-25 21:07:39 Re: missing chunk 0 for toast value ...