pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedERROR: could not open relation 16388/24734/51896: Cannot open or remove a file containing a running program.
2+ messages / 2 participants
[nested] [flat]
* ERROR: could not open relation 16388/24734/51896: Cannot open or remove a file containing a running program.
@ 2008-09-15 15:31 KKreuzer@kbtoys.com
2008-09-15 16:27 ` Re: ERROR: could not open relation 16388/24734/51896: Cannot open or remove a file containing a running program. Joshua Drake <jd@commandprompt.com>
0 siblings, 1 reply; 2+ messages in thread
From: KKreuzer@kbtoys.com @ 2008-09-15 15:31 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: ERROR: could not open relation 16388/24734/51896: Cannot open or remove a file containing a running program.
2008-09-15 15:31 ERROR: could not open relation 16388/24734/51896: Cannot open or remove a file containing a running program. KKreuzer@kbtoys.com
@ 2008-09-15 16:27 ` Joshua Drake <jd@commandprompt.com>
0 siblings, 0 replies; 2+ messages in thread
From: Joshua Drake @ 2008-09-15 16:27 UTC (permalink / raw)
To: KKreuzer@kbtoys.com; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-09-15 16:27 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-09-15 15:31 ERROR: could not open relation 16388/24734/51896: Cannot open or remove a file containing a running program. KKreuzer@kbtoys.com
2008-09-15 16:27 ` Joshua Drake <jd@commandprompt.com>
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