Tomcat/Struts app hanging (Waiting for xx instance(s) to be deallocated)

[Robert Weeks]

Hello -

I am seeing a perplexing problem with an app I am using with Tomcat 
(4.1.24), struts (1.1) and MySql (4.0.12) running on RH.

It seems that after a certain amount of time, the whole app freezes and 
tomcat has to be restarted, and the top of the daily log that is 
created/appended says:

2003-10-07 11:37:45 StandardWrapper[:action]: Waiting for 38 
instance(s) to be deallocated
2003-10-07 11:37:55 WebappLoader[]: Deploying class repositories to 
work directory /usr/local/jakarta-tomcat-4.1.24/work/Standalone/xxx...

The number of instances is variable.

I have seen a number of queries on the 'Waiting for xx instance(s)...' 
around - but I cannot seem to find an answer to this problem.

Is anyone else seeing this?

I am using org.apache.commons.dbcp.BasicDataSource for the datasource:

<data-sources>
   <data-source type="org.apache.commons.dbcp.BasicDataSource">
     <set-property
        property="autoCommit"
        value="false"/>
     <set-property
        property="driverClassName"
        value="com.mysql.jdbc.Driver"/>
     <set-property
        property="maxActive"
        value="30"/>
     <set-property
        property="url"
        value="jdbc:mysql://localhost/xxxx"/>
     <set-property
        property="username"
        value="xxxx"/>
     <set-property
        property="password"
        value="xxxx"/>
     <set-property
        property="validationQuery"
        value="SELECT COUNT(*) FROM Users" />
   </data-source>
 </data-sources>


Thanks for any help.

--
Robert B. Weeks
[EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]