Skip site navigation (1) Skip section navigation (2)

ANALYZE crashes randomly

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 (view raw or flat)
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...

Responses

pgsql-admin by date

Next:From: Guy SmithDate: 2004-02-19 10:52:16
Subject: Concerned about previous version still in place
Previous:From: Tom LaneDate: 2004-02-19 06:30:17
Subject: Re: Knowing postgres processes..

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group