Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group