Postgres Pro
Downloads
Home   >   mailing lists

Re: missing chunk 0 for toast value ... - Mailing list pgsql-general

From Tom Lane
Subject Re: missing chunk 0 for toast value ...
Date
Msg-id 28935.1319577616@sss.pgh.pa.us
Whole thread Raw
In response to missing chunk 0 for toast value ...  (Andrew Hammond <andrew.george.hammond@gmail.com>)
Responses Re: missing chunk 0 for toast value ...  (Andrew Hammond <andrew.george.hammond@gmail.com>)
List pgsql-general
Tree view 
Andrew Hammond <andrew.george.hammond@gmail.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

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: missing chunk 0 for toast value ...
Next
From: "Rob_pg"
Date:
Subject: Re: writing a foreign data wrapper for hdfs, but getting and undefined symbol error for hdfsConnect