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
vaiism@(protected)


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@(protected)
For additional commands, e-mail: tomcat-user-help@(protected)