tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Parsons Technical Services" <parsonstechni...@earthlink.net>
Subject Re: tomcat fails db connection
Date Sun, 13 Feb 2005 00:14:42 GMT
Regurgitated:

Using db pool.
DB responding to other apps (outside Tomcat).


Run

 >mysqladmin extended-status -u username -p

 and see how many connections are open.

Compare to the max connections in the connection pool.

Try adding the removeAbandoned parameters to the dbcp setup.
Set log to true.
Sounds like you have a leak and are using up all of your connections in the 
pool.

Doug

----- Original Message ----- 
From: "Daniele" <daniele.innocenti@email.it>
To: <tomcat-user@jakarta.apache.org>
Sent: Saturday, February 12, 2005 2:06 PM
Subject: tomcat fails db connection


> Hi everybody,
>
> I've a problem with an application running under tomcat 4.1.27.
> Every one-two days tomcat stops connecting to the database.
> Tomcat is still responding, but no queries can be executed. Restarting 
> tomcat solves the problem.
>
> We have apache 2.0.47 and jk2 connector, and DBCP to connect to a mysql 
> database which lies on a different machine.
> Both the pc's OS are RH enterprise.
>
> There aren't connections left on the db (at least "show processlist" 
> doesn't show them).
> The tomcat logs don't tell anything but the sqlException about db not 
> responding.
> Mysql is always up and our perl scripts keep going without any problems. 
> That must be a tomcat or dbcb issue, I guess.
>
> What could be the problem? Any ideas?
>
> Daniele Innocenti
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
> 



---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message