Re: dangling connections

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