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

Поиск
Список
Период
Сортировка
От KKreuzer@kbtoys.com
Тема ERROR: could not open relation 16388/24734/51896: Cannot open or remove a file containing a running program.
Дата
Msg-id OFDDADDA97.3839F62D-ON852574C5.00550BC6-852574C5.0055448E@kbtoys.com
обсуждение исходный текст
Ответы Re: ERROR: could not open relation 16388/24734/51896: Cannot open or remove a file containing a running program.
Список 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

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Heavy postgres process
Следующее
От: mkrist@binf.ku.dk
Дата:
Сообщение: Trouble setting up access privileges