pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: John Allgood <john@turbocorp.com>
To: pgsql -admin <@postgresql.org>
Cc: Terry Lee Tucker <terry@leetuckert.net>
Cc: J. D. Pearson <jpearson@turbocorp.com>
Cc: Geoffrey <esoteric@3times25.net>
Subject: Out of file-descriptors message
Date: Wed, 29 Nov 2006 15:51:42 -0500
Message-ID: <456DF2DE.3060002@turbocorp.com> (raw)

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** <mailto:john@turbocorp.com>
**www.turbocorp.com** <http://www.turbocorp.com;





view thread (18+ messages)  latest in thread

Message-ID: <456DF2DE.3060002@turbocorp.com>
Permalink:  ../456DF2DE.3060002@turbocorp.com/
Also on:    postgresql.org/message-id/456DF2DE.3060002@turbocorp.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: john@turbocorp.com, @postgresql.org, terry@leetuckert.net, jpearson@turbocorp.com, esoteric@3times25.net
  Subject: Re: Out of file-descriptors message
  In-Reply-To: <456DF2DE.3060002@turbocorp.com>
  References: <456DF2DE.3060002@turbocorp.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox