ANALYZE crashes randomly

Поиск
Список
Период
Сортировка
От Olivier Hubaut
Тема ANALYZE crashes randomly
Дата
Msg-id 40349522.8090401@scmbb.ulb.ac.be
обсуждение исходный текст
Ответы Re: ANALYZE crashes randomly
Список pgsql-admin
Hi,

On PostgreSQL 7.3.3 on MacOS X 10.2, the ANALYZE command sometimes crash
and I don't know why! I've tried it some binaries copies of the DB, it's
a totally random behaviour.

When it crahes, I get this message:

PANIC:  could not open transaction-commit log directory
(/usr/local/pgsql/annot/pg_clog): Too many open files
server closed the connection unexpectedly
         This probably means the server terminated abnormally
         before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.

Does anyone know how to resolve it?

--
Signature en cours de maintenance,
Veuillez patienter...

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Knowing postgres processes..
Следующее
От: "Guy Smith"
Дата:
Сообщение: Concerned about previous version still in place