Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id EF8B99FBE8A for ; Thu, 25 Oct 2007 05:42:56 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 68597-03 for ; Thu, 25 Oct 2007 05:42:53 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from oxford.xeocode.com (unknown [87.127.95.196]) by postgresql.org (Postfix) with ESMTP id 6DB329FB7DD for ; Thu, 25 Oct 2007 05:42:52 -0300 (ADT) Received: from localhost ([127.0.0.1] helo=oxford.xeocode.com) by oxford.xeocode.com with esmtp (Exim 4.67) (envelope-from ) id 1IkyIQ-0005hu-4z; Thu, 25 Oct 2007 09:42:30 +0100 To: "Tom Lane" Cc: "Otniel Michael" , Subject: Re: ERROR: failed to re-find parent key in "pk_ep07" In-Reply-To: <6415.1193287511@sss.pgh.pa.us> (Tom Lane's message of "Thu\, 25 Oct 2007 00\:45\:11 -0400") User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.1 (gnu/linux) X-Draft-From: ("nnimap+mail01.enterprisedb.com:INBOX.sql" 1229) References: <30805.43598.qm@web51009.mail.re2.yahoo.com> <6415.1193287511@sss.pgh.pa.us> From: Gregory Stark Organization: EnterpriseDB Date: Thu, 25 Oct 2007 09:42:28 +0100 Message-ID: <87bqanmvpn.fsf@oxford.xeocode.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/114 X-Sequence-Number: 29486 "Tom Lane" writes: > Otniel Michael writes: >> When i was vacuum the database, the vacuum if failed. And I get this error. Any ideas an to fix this? >> ERROR: failed to re-find parent key in "pk_ep07" > > Update to a newer PG version, possibly? This symptom has been seen > before... It was fixed in these bug-fix releases: 7.4.15, 8.0.10, and 8.1.6 which were released on August 1st of this year. There have actually been 3 to 4 more bug-fix releases since those too. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com