| From: | Olivier Hubaut <olivier(at)scmbb(dot)ulb(dot)ac(dot)be> |
|---|---|
| To: | PgSQL Admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | ANALYZE crashes randomly |
| Date: | 2004-02-19 10:51:14 |
| Message-ID: | 40349522.8090401@scmbb.ulb.ac.be |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guy Smith | 2004-02-19 10:52:16 | Concerned about previous version still in place |
| Previous Message | Tom Lane | 2004-02-19 06:30:17 | Re: Knowing postgres processes.. |