Postgres Pro
Downloads
Home   >   mailing lists

Re: failing 8.1.4 autovacuum - Mailing list pgsql-general

From Tom Lane
Subject Re: failing 8.1.4 autovacuum
Date
Msg-id 721.1161644295@sss.pgh.pa.us
Whole thread Raw
In response to failing 8.1.4 autovacuum  ("Ed L." <pgsql@bluepolka.net>)
List pgsql-general
Tree view 
"Ed L." <pgsql@bluepolka.net> writes:
> I have an 8.1.4 autovac process running on HP-UX 11.23 IA64 and
> repeatedly failing with the following error:
>     ERROR:  failed to re-find parent key in "audit_idx1"

> Will a reindex or drop index make this problem go away?

Probably.

> Is there anything I can do to help identify the underlying issue?

Can you send me a copy of the physical index file?

            regards, tom lane

pgsql-general by date:

Previous
From: "Brandon Metcalf"
Date:
Subject: Re: missing FROM-clause entry
Next
From: "Ed L."
Date:
Subject: Re: failing 8.1.4 autovacuum