| 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-11-01 23:56:02 |
| Message-ID: | 116.1320191762@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:
> On Tue, Oct 25, 2011 at 2:20 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jaime Casanova | 2011-11-02 01:18:51 | Re: Disable Streaming Replication ==> Stop WAL Sender on master and WAL receiver on Slave |
| Previous Message | Roger Niederland | 2011-11-01 22:54:38 | variable not found in subplan target list |