Re: Skunkweb & PostgreSQL idle transactions

Hi JC --

Sounds to me like you might not have the appropriate caching service
turned on -- psycopgcache, for instance (depends on which driver you
are using) -- and transactions where you perform a SELECT aren't being
terminated.  

If you are using PyDO2 (OK, I know you aren't, but please do use it
for new applications), you want to put a rollback function of your own
in the CleanupRequest hook.

Cheers,

js

On Tue, Sep 05, 2006 at 10:55:44AM -0700, Juan Carlos Leon wrote:
> 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
> _______________________________________________
> Skunkweb-list mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/skunkweb-list
> 

-- 
Jacob Smullyan

-------------------------------------------------------------------------
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