Re: missing chunk 0 for toast value ...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)com>
Cc: Andrew Hammond <andrew(dot)george(dot)hammond(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: missing chunk 0 for toast value ...
Date: 2011-10-26 14:39:34
Message-ID: 12734.1319639974@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)com> writes:
> On Wed, Oct 26, 2011 at 1:04 AM, Andrew Hammond
> <andrew(dot)george(dot)hammond(at)gmail(dot)com> wrote:
>> On Tue, Oct 25, 2011 at 4:53 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>>> [ pokes around for a bit ... ] Hmm, can you say how the failing query
>>> was submitted, exactly? I'm wondering if it came in via simple Query
>>> (PQexec) or extended-query protocol (anything with parameters).

>> The command was sent from a python via django-1.2.1 using psycopg2-2.2.1

> PQexec then.

Thanks for the followup. My current theory is that that's unrelated,
though --- it now seems that this is just a race condition in the use of
toasted pg_statistic entries. See
http://archives.postgresql.org/pgsql-hackers/2011-10/msg01366.php

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2011-10-26 14:42:19 Re: pglesslog for Postgres 9.1.1
Previous Message Simon Riggs 2011-10-26 14:15:59 Re: Large Rows