Re: [ADMIN] ERROR: could not open relation 16388/24734/51896: Cannot open or remove a file containing a running program.

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

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin