Andrew Hammond writes:
> On Tue, Oct 25, 2011 at 2:20 PM, Tom Lane 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
Daniele Varrazzo writes:
> On Wed, Oct 26, 2011 at 1:04 AM, Andrew Hammond
> wrote:
>> On Tue, Oct 25, 2011 at 4:53 PM, Tom Lane 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
On Wed, Oct 26, 2011 at 1:04 AM, Andrew Hammond
wrote:
> On Tue, Oct 25, 2011 at 4:53 PM, Tom Lane 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 (any
On Tue, Oct 25, 2011 at 4:53 PM, Tom Lane wrote:
> Andrew Hammond writes:
> > On Tue, Oct 25, 2011 at 4:11 PM, Tom Lane wrote:
> >> Hmm, that's pretty interesting ... are there any nearby autovacuums of
> >> pg_toast_2619?
>
> > Several, both before and after the error message:
>
> Well, it see
Andrew Hammond writes:
> On Tue, Oct 25, 2011 at 4:11 PM, Tom Lane wrote:
>> Hmm, that's pretty interesting ... are there any nearby autovacuums of
>> pg_toast_2619?
> Several, both before and after the error message:
Well, it seems clear that somehow the vacuum deleted a toast tuple that
the o
On Tue, Oct 25, 2011 at 4:11 PM, Tom Lane wrote:
> Andrew Hammond writes:
> > The following occur in the log file immediately before the
> > error message above.
>
> Hmm, that's pretty interesting ... are there any nearby autovacuums of
> pg_toast_2619?
>
Several, both before and after the erro
Andrew Hammond writes:
> The following occur in the log file immediately before the
> error message above.
Hmm, that's pretty interesting ... are there any nearby autovacuums of
pg_toast_2619?
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postg
On Tue, Oct 25, 2011 at 2:20 PM, Tom Lane wrote:
> Andrew Hammond 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 t
Andrew Hammond 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
On Tue, Oct 25, 2011 at 3:47 PM, Andrew Hammond
wrote:
> I found the following error message in my logfiles.
> 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
> Oct 24 04:05:57 db-app02 p
I found the following error message in my logfiles.
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
Oct 24 04:05:57 db-app02 postgres[24640]: [2-2]
user=nutricate,db=admin_production STATEMEN
11 matches
Mail list logo