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: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin

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 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-2017 The PostgreSQL Global Development Group