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 116.1320191762@sss.pgh.pa.us
Whole thread Raw
In response to Re: missing chunk 0 for toast value ...  (Andrew Hammond <andrew.george.hammond@gmail.com>)
List pgsql-general
Andrew Hammond <andrew.george.hammond@gmail.com> writes:
> On Tue, Oct 25, 2011 at 2:20 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> 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?

> This is 9.0.4.

I've applied a patch for this:
http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=7f797d27fe0be5200ad5fd5af6cefcee30c8e24a

It turns out that the problem is very significantly harder to reproduce
pre-9.0, which may explain why you hadn't seen it before ... but it does
exist, at least as far back as 8.2, and probably in every version that
has TOAST tables.

            regards, tom lane

pgsql-general by date:

Previous
From: Roger Niederland
Date:
Subject: variable not found in subplan target list
Next
From: Tom Lane
Date:
Subject: Re: Server hitting 100% CPU usage, system comes to a crawl.