Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id C92559FA3A3 for ; Thu, 26 Oct 2006 18:37:31 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 45088-04 for ; Thu, 26 Oct 2006 18:37:25 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 1CCD29FA38F for ; Thu, 26 Oct 2006 18:37:24 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 0539456427; Thu, 26 Oct 2006 16:37:24 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Thu, 26 Oct 2006 16:37:21 -0500 Date: Thu, 26 Oct 2006 16:37:21 -0500 From: "Jim C. Nasby" To: Mike Goldner Cc: pgsql-admin@postgresql.org Subject: Re: Vacuum Problems (locking) Message-ID: <20061026213721.GJ26892@nasby.net> References: <1161806057.2095.154.camel@localhost.localdomain> <1161806429.2095.157.camel@localhost.localdomain> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1161806429.2095.157.camel@localhost.localdomain> X-Operating-System: FreeBSD 6.1-RELEASE-p10 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.13 (2006-08-11) X-Hashcash: 1:20:061026:mgoldner@agmednet.com::zkB45bzlIKl7uSTb:0000000000000000 0000000000000000000000009NXW X-Hashcash: 1:20:061026:pgsql-admin@postgresql.org::Prt0FGXWgxhcoC7O:00000000000 000000000000000000000000639x X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.078 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200610/190 X-Sequence-Number: 23493 On Wed, Oct 25, 2006 at 04:00:29PM -0400, Mike Goldner wrote: > I just noticed that my nightly vacuum failed the previous three nights > with the following error: > > [2032-jbossdb-postgres-2006-10-24 04:12:30.019 EDT]ERROR: failed to re- > find parent key in "jms_messages_pkey" > [2032-jbossdb-postgres-2006-10-24 04:12:30.019 EDT]STATEMENT: VACUUM > ANALYZE; > > I'm not sure if it is related, but it seems pertinent. Well, vacuuming a lot of databases once a day is bad enough. Not vacuuming for 3 days... IIRC you can fix that issue by reindexing jms_messages_pkey. -- Jim Nasby jim@nasby.net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)