Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id D9C646500D5 for ; Mon, 15 Sep 2008 13:25:48 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 12391-02-6 for ; Mon, 15 Sep 2008 13:25:45 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id BFC7564FF9E for ; Mon, 15 Sep 2008 13:25:29 -0300 (ADT) Received: from jd-laptop (or-69-34-217-90.sta.embarqhsd.net [69.34.217.90]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id m8FGSoFZ031138 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Mon, 15 Sep 2008 09:28:51 -0700 Date: Mon, 15 Sep 2008 09:27:02 -0700 From: Joshua Drake To: KKreuzer@kbtoys.com Cc: pgsql-admin@postgresql.org Subject: Re: ERROR: could not open relation 16388/24734/51896: Cannot open or remove a file containing a running program. Message-ID: <20080915092702.48848629@jd-laptop> In-Reply-To: References: Organization: Command Prompt, Inc. X-Mailer: Claws Mail 3.5.0 (GTK+ 2.12.9; i486-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Mon, 15 Sep 2008 09:28:52 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200809/134 X-Sequence-Number: 30227 On Mon, 15 Sep 2008 11:31:21 -0400 KKreuzer@kbtoys.com wrote: > Hi > While running a VACUUM ANALYZE > The process aborts and I receive the following message in the log: > > ERROR: could not open relation 16388/24734/51896: Cannot open or > remove a file containing a running program. > STATEMENT: VACUUM ANALYZE > > 51896 refers to an index on a table with over 10,000,000 rows. Your index is corrupted. Drop the index and recreate it. See if that solves the vacuum analyze problem. Note, you may have further corruption. Sincerely, Joshua D. Drake -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ United States PostgreSQL Association: http://www.postgresql.us/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate