Thread: ERROR: could not open relation 16388/24734/51896: Cannot open or remove a file containing a running program.
ERROR: could not open relation 16388/24734/51896: Cannot open or remove a file containing a running program.
From
KKreuzer@kbtoys.com
Date:
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.
The process runs nightly with this being the first time I have a problem.
It runs at 2:45 am where there should be no contention.
select version() ;
"PostgreSQL 8.2.6 on powerpc-ibm-aix5.2.0.0, compiled by GCC gcc (GCC) 4.0.0"
Any input would be appreciated.
Keith Kreuzer
ext 3424
Re: ERROR: could not open relation 16388/24734/51896: Cannot open or remove a file containing a running program.
From
Joshua Drake
Date:
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