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 AE93BD1DA34 for ; Fri, 20 Feb 2004 14:15:43 +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 90307-03 for ; Fri, 20 Feb 2004 10:15:44 -0400 (AST) Received: from bonito.ulb.ac.be (mailhost.ulb.ac.be [164.15.59.220]) by svr1.postgresql.org (Postfix) with ESMTP id 9CC49D1D132 for ; Fri, 20 Feb 2004 10:15:39 -0400 (AST) Received: from mach.vub.ac.be (mach.ulb.ac.be [164.15.128.3]) by bonito.ulb.ac.be (8.8.8/3.17.1.ap (resu)) id PAA10865; Fri, 20 Feb 2004 15:15:07 +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 PAA26760; Fri, 20 Feb 2004 15:15:41 +0100 (MET) for Message-ID: <40361699.10605@scmbb.ulb.ac.be> Date: Fri, 20 Feb 2004 15:15:53 +0100 From: Olivier Hubaut User-Agent: Mozilla Thunderbird 0.5 (Macintosh/20040208) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: PgSQL Admin Subject: Re: ANALYZE crashes randomly References: <40349522.8090401@scmbb.ulb.ac.be> <1732.1077201014@sss.pgh.pa.us> <4035EC17.10607@scmbb.ulb.ac.be> <27320.1077285812@sss.pgh.pa.us> In-Reply-To: <27320.1077285812@sss.pgh.pa.us> 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/289 X-Sequence-Number: 12463 Tom Lane wrote: > Olivier Hubaut writes: > >>>>PANIC: could not open transaction-commit log directory >>>>(/usr/local/pgsql/annot/pg_clog): Too many open files > > >>But it's amazing to me that i had to reduce it so much as the postmaster >>is almost the only application running on this server. > > > Oh, wait, I bet you are running into the per-process open file limit not > the kernel limit. The per-process limit is usually pretty low on > Darwin, and checking the code I see > > xldir = opendir(XLogDir); > if (xldir == NULL) > ereport(PANIC, > (errcode_for_file_access(), > errmsg("could not open transaction log directory \"%s\": %m", > XLogDir))); > > That is, we don't have a fallback path to recover when the error is > ENFILE or EMFILE. Looks to me like all the opendir() calls in the > backend ought to be handled by fd.c with code to release other open > files at need. > > In the meantime, though, it seems fishy that Postgres wouldn't have > detected and allowed for the per-process file limit. Which version of > OS X did you say you were using? > > regards, tom lane > > Once again, thanks for your help For the moment, we are running on OS X 10.2.8 but we'll change soon for OS X 10.3 -- Signature en cours de maintenance, Veuillez patienter...