Skunkweb & PostgreSQL idle transactions

Hi there, 

I have the following setup: 

Apache/skunkweb on box [A] FC5
PostgreSQL on box [B] RHL 9 

For some reason all SQL requests from PyDO to Postgres
stay idle and don't terminate. This causes the db to
use all allow connections. I turned on cached
connections on sw.conf by passing the connect string
in the variable PostgreSQLConnectParams = {} 

Also these variables are set as follow: 

useCompileMemoryCache = 1
userModuleCleanup = 0

I'm using the version of PyDO that comes out when
checking out using SVN. 


ideas? 


[root@dbinternal root]# ps -ef | grep postgres
postgres  2008     1  0 11:22 ?        00:00:00
/usr/bin/postmaster -p 5432
postgres  2010  2008  0 11:22 ?        00:00:00
postgres: stats buffer process   
postgres  2011  2010  0 11:22 ?        00:00:00
postgres: stats collector process   
postgres  2385  2008  0 12:10 ?        00:00:00
postgres: apache CSHL 144.48.1.212 idle in transaction
postgres  2387  2008  0 12:10 ?        00:00:00
postgres: apache CSHL 144.48.1.212 idle in transaction
postgres  2822  2008  0 12:59 ?        00:00:12
postgres: apache CSHL 144.48.1.213 idle in transaction
postgres  2824  2008  0 12:59 ?        00:00:10
postgres: apache CSHL 144.48.1.213 idle in transaction
postgres  2829  2008  0 12:59 ?        00:00:04
postgres: apache CSHL 144.48.1.213 idle in transaction
postgres  2833  2008  0 12:59 ?        00:00:21
postgres: apache CSHL 144.48.1.213 idle in transaction
postgres  2835  2008  0 12:59 ?        00:00:04
postgres: apache CSHL 144.48.1.213 idle in transaction
postgres  2845  2008  0 13:00 ?        00:00:09
postgres: apache CSHL 144.48.1.213 idle in transaction
postgres  2851  2008  0 13:00 ?        00:00:05
postgres: apache CSHL 144.48.1.213 idle in transaction
postgres  2889  2008  0 13:06 ?        00:00:07
postgres: apache CSHL 144.48.1.213 idle in transaction
postgres  2891  2008  0 13:06 ?        00:00:15
postgres: apache CSHL 144.48.1.213 idle in transaction
postgres  2917  2008  0 13:07 ?        00:00:04
postgres: apache CSHL 144.48.1.213 idle in transaction
postgres  2920  2008  0 13:09 ?        00:00:16
postgres: apache CSHL 144.48.1.213 idle in transaction
postgres  2922  2008  0 13:09 ?        00:00:12
postgres: apache CSHL 144.48.1.213 idle in transaction
postgres  2944  2008  0 13:15 ?        00:00:08
postgres: apache CSHL 144.48.1.213 idle in transaction
postgres  3055  2008  0 13:39 ?        00:00:00
postgres: apache CSHL 144.48.1.213 idle in transaction
postgres  3132  2008  0 13:47 ?        00:00:00
postgres: apache CSHL 144.48.1.212 idle in transaction
postgres  3312  2008  0 14:01 ?        00:00:05
postgres: apache CSHL 144.48.1.213 idle in transaction
postgres  3336  2008  0 14:04 ?        00:00:04
postgres: apache CSHL 144.48.1.213 idle in transaction
postgres  3338  2008  0 14:06 ?        00:00:00
postgres: apache CSHL 144.48.1.212 idle in transaction
postgres  3358  2008  0 14:11 ?        00:00:00
postgres: apache CSHL 144.48.1.212 idle in transaction
postgres  3385  2008  0 14:16 ?        00:00:00
postgres: apache CSHL 144.48.1.212 idle in transaction
postgres  3399  2008  0 14:17 ?        00:00:00
postgres: apache CSHL 144.48.1.212 idle in transaction
postgres  3400  2008  0 14:17 ?        00:00:00
postgres: apache CSHL 144.48.1.212 idle in transaction
root      3403  3165  0 14:17 pts/0    00:00:00 grep
postgres
[root@dbinternal root]# 



cheers, 


--JC




-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642