Possible postgre serverlog file handle leak

From: "Crowe, Eric" <ECC(at)dolby(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Possible postgre serverlog file handle leak
Date: 2009-04-14 17:35:00
Message-ID: 05BB196AB3DA6C4BBE11AB6C957581FE1783E5C1@sfo-exch-01.dolby.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greetings,

We recently upgraded from 7.4.1 to 8.3.6 postgre and have come across
what appears to be a postgre serverlog file handle leak.

Interestly enough, the serverlog file handles (over 100 of them) are
being maintained by our application server process. We are using JBoss
4.2.3 with Hibernate and the postgresql-8.3-604.jdbc3.jar

An issue was first noticed by receiving the "too many open files" error
message within the application server process. Though, I don't have
information on what file handles were open at the time of the error;
analyzing the the file handles later are concerning with so many
references to the postgre serverlog. We are running a linux variant and
this concern was discovered through lsof.

We had been running postgre 7.4.1 for years without this issue so this
does feel like a degredation. There have been quite a few changes in
8.3 postgre in regards to logging so perhaps there is some fine tuning
that could be done with the log configuration? Has anyone else on this
forum seen this problem and/or know of a solution to it?

Many thanks in advance,

Eric Crowe

-----------------------------------------
This message (including any attachments) may contain confidential
information intended for a specific individual and purpose. If you
are not the intended recipient, delete this message. If you are
not the intended recipient, disclosing, copying, distributing, or
taking any action based on this message is strictly prohibited.

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-04-14 17:41:59 Re: Move databases from Pg 7.2.1 to 8.3.x
Previous Message Joshua D. Drake 2009-04-14 17:21:20 Re: Move databases from Pg 7.2.1 to 8.3.x