On Wed, May 16, 2012 at 7:38 AM, Daryl Stultz
<daryl.stultz@opentempo.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.comhttp://www.opentempo.commailto:
daryl.stultz@opentempo.com