X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 6D16ED1E12E for ; Thu, 19 Feb 2004 10:51:06 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 01532-04 for ; Thu, 19 Feb 2004 06:51:12 -0400 (AST) Received: from guppy.vub.ac.be (guppy.vub.ac.be [134.184.129.2]) by svr1.postgresql.org (Postfix) with ESMTP id 328EBD1E12C for ; Thu, 19 Feb 2004 06:50:58 -0400 (AST) Received: from mach.vub.ac.be (mach.vub.ac.be [134.184.129.3]) by guppy.vub.ac.be (8.9.1b+Sun/3.17.1.ap (guppy)) id LAA20223; Thu, 19 Feb 2004 11:51:04 +0100 (MET) for Received: from scmbb.ulb.ac.be (ucmbsgi10.ulb.ac.be [164.15.109.34]) by mach.vub.ac.be (8.9.3/3.13.5.aejp (mach)) id LAA12143; Thu, 19 Feb 2004 11:51:04 +0100 (MET) for Message-ID: <40349522.8090401@scmbb.ulb.ac.be> Date: Thu, 19 Feb 2004 11:51:14 +0100 From: Olivier Hubaut User-Agent: Mozilla Thunderbird 0.5 (Macintosh/20040208) X-Accept-Language: en-us, en MIME-Version: 1.0 To: PgSQL Admin Subject: ANALYZE crashes randomly Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/277 X-Sequence-Number: 12451 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...