From: Joshua Drake <jd@commandprompt.com>
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.
Date: Mon, 15 Sep 2008 09:27:02 -0700
Message-ID: <20080915092702.48848629@jd-laptop> (raw)
In-Reply-To: <OFDDADDA97.3839F62D-ON852574C5.00550BC6-852574C5.0055448E@kbtoys.com>
References: <OFDDADDA97.3839F62D-ON852574C5.00550BC6-852574C5.0055448E@kbtoys.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jd@commandprompt.com, KKreuzer@kbtoys.com
Subject: Re: ERROR: could not open relation 16388/24734/51896: Cannot open or remove a file containing a running program.
In-Reply-To: <20080915092702.48848629@jd-laptop>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox