Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 3A36C9FB28E for ; Wed, 29 Nov 2006 17:14:44 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 07141-05 for ; Wed, 29 Nov 2006 17:14:21 -0400 (AST) X-Greylist: delayed 00:22:06.55145 by SQLgrey-1.7.4 Received: from Mercury.turbocorp.com (mercury.turbocorp.com [198.212.166.40]) by postgresql.org (Postfix) with ESMTP id 76A069FB282 for ; Wed, 29 Nov 2006 17:14:23 -0400 (AST) Received: from [198.212.166.11] (Charon.turbocorp.com [198.212.166.11]) by Mercury.turbocorp.com (8.13.1/8.13.1) with ESMTP id kATKjnol010374; Wed, 29 Nov 2006 15:45:50 -0500 Message-ID: <456DF2DE.3060002@turbocorp.com> Date: Wed, 29 Nov 2006 15:51:42 -0500 From: John Allgood User-Agent: Thunderbird 1.5.0.7 (X11/20060911) MIME-Version: 1.0 To: "pgsql -admin"@postgresql.org CC: Terry Lee Tucker , "J. D. Pearson" , Geoffrey Subject: Out of file-descriptors message Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50 X-Spam-Level: X-Archive-Number: 200611/243 X-Sequence-Number: 23770 Hello All We are having an issue and it appears to be with file descriptors. We are running PostgreSQL 7.4.13 on RHEL 3.0 box. This system is running Redhat Cluster Suite with each system running multiple postmasters. The error has occurred on both boxes and we can't find any consistencies on what is causing the problem. I don't see this message in dmesg or any other log file. It only appears in this single database. There are other databases running on the same host but from different postmasters and I don't see the same message. A couple of things to add is that this has happened on another machine from a different database. When this problem has been reoccurring for a period of several days the server get fenced by the other machine. Don't know if related but seems to happen at the time when the descriptors error is occurring. Here is a snippet from the log of one of the databases. 2006-11-29 14:57:51 [3823] LOG: out of file descriptors: Too many open files; release and retry 2006-11-29 14:58:01 [3823] LOG: out of file descriptors: Too many open files; release and retry 2006-11-29 15:00:26 [3823] LOG: out of file descriptors: Too many open files; release and retry -- **John Allgood** /*/Senior Systems Administrator/*/ **Turbo Logistics - Division of Ozburn-Hessey Logistics** **2251 Jesse Jewell Pky. NE** **Gainesville, GA 30507****** **tel (678) 989-3051 fax (770) 531-7878** **john@turbocorp.com** **www.turbocorp.com**