Skip site navigation (1) Skip section navigation (2)

Re: dangling connections

From: Daryl Stultz <daryl(dot)stultz(at)opentempo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: dangling connections
Date: 2012-05-19 13:24:25
Message-ID: CANYnOKQQgyFOudDqiEn8yDrU41J-cvhUNhX=D7GoyuNNn5nTWQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Wed, May 16, 2012 at 7:38 AM, Daryl Stultz <daryl(dot)stultz(at)opentempo(dot)com>wrote:

>
>> On Tue, May 15, 2012 at 3:31 AM, Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>wrote:
>>
>>>
>>> select client_addr, client_port from pg_stat_activity;
>>>
>>>
My system failed again last night. After shutting down Tomcat netstat shows
the machine having a dozen or so connections in FIN_WAIT1 state. I guess
this just means they are in the process of shutting down. I didn't check
again later to see if they went away.

With tomcat shut down, I ran the suggested query against PG. I also ran
netstat on the database server. Both showed active connections (ESTABLISHED
in the case of netstat) with the app server. Netstat on the app server
shows no connections for the ports listed by the DB server. Checking on
things the next morning I find that the app server has connections to the
database server that the database server doesn't think it has open.

Anyone have any ideas?

Thanks.

/Daryl

-- 
Daryl Stultz
_____________________________________
6 Degrees Software and Consulting, Inc.
http://www.6degrees.com
http://www.opentempo.com
mailto:daryl(dot)stultz(at)opentempo(dot)com

In response to

pgsql-admin by date

Next:From: Vincent DautremontDate: 2012-05-22 16:44:41
Subject: out of memory error
Previous:From: Robert BruccoleriDate: 2012-05-18 22:29:43
Subject: Problem with SSL certificate setup; please disregard -- solution found.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group