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

Поиск
Список
Период
Сортировка
От Joshua Drake
Тема Re: ERROR: could not open relation 16388/24734/51896: Cannot open or remove a file containing a running program.
Дата
Msg-id 20080915092702.48848629@jd-laptop
обсуждение исходный текст
Ответ на ERROR: could not open relation 16388/24734/51896: Cannot open or remove a file containing a running program.  (KKreuzer@kbtoys.com)
Список 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



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

Предыдущее
От: mkrist@binf.ku.dk
Дата:
Сообщение: Trouble setting up access privileges
Следующее
От: "c k"
Дата:
Сообщение: Functions