Re: [GENERAL] Idle in Transaction and hung connections

2004-04-30 Thread Gregory S. Williamson
/29/2004 7:27 PM To: Gregory S. Williamson Cc: Tom Lane; [EMAIL PROTECTED] Subject:Re: [GENERAL] Idle in Transaction and hung connections On Thu, 29 Apr 2004, Gregory S. Williamson wrote: Tom -- Thanks for the suggestion, and the rapid response on something which may

Re: [GENERAL] Idle in Transaction and hung connections

2004-04-29 Thread Kris Jurka
On Thu, 29 Apr 2004, Gregory S. Williamson wrote: Tom -- Thanks for the suggestion, and the rapid response on something which may not be truely a postgres issue (perhaps more a JDBC thing)! This behavior is fixed in the 7.5 cvs version of the JDBC driver if you'd like to try it out.

[GENERAL] Idle in Transaction and hung connections

2004-04-29 Thread Gregory S. Williamson
Dear peoples, Periodically we are getting runaway postgres processes on our Linux (2.4.21-0.13 on Dell servers), using 7.4 and GIS (0.8 USE_GEOS=1 USE_PROJ=1 USE_STATS=1). All of the queries come in from remote servers using JDBC/proxool; once every 4 hours we have a process on the client side