tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Colin Ingarfield <colin...@gmail.com>
Subject Re: how to enable debug logging for Tomcat jdbc pool (Tomcat 6.0.32)
Date Wed, 21 Mar 2012 16:11:43 GMT
I added the 3 abandoned settings but I don't see any indication in the
tomcat log that connections are being abandoned.  I also made the max pool
size pretty small.. my application would have failed quickly if all the
connections we're being incorrectly held up.

Anything else I can try?  Thanks again for your  help.

-- Colin

On Wed, Mar 21, 2012 at 10:41 AM, Filip Hanik Mailing Lists <
devlists@hanik.com> wrote:

> Got it, thank you.
> The other way this can happen is if the application checks out a
> connection and then never returns it, and expects it to be used.
> For this you will want to enable
>
> removeAbandonedTimeout="60"
> removeAbandoned="true"
> logAbandoned="true"
>
> this should tell you pretty quickly if you got a component that is hogging
> the connection. So test that first. Now if that is the case, there is a way
> to fix that:
>
> 1. remove the above settings
> 2. compile and configure the interceptor described in:
>   https://issues.apache.org/bugzilla/show_bug.cgi?id=52024
> In this interceptor, when a failure occurs, it automatically reconnects
> and retries the operation. And that is the only way to get around the
> problem (assuming my assumption is correct)
>
>
> Filip
> ----- Original Message -----
> > From: "Colin Ingarfield" <colini98@gmail.com>
> > To: users@tomcat.apache.org
> > Sent: Wednesday, March 21, 2012 9:30:46 AM
> > Subject: Re: how to enable debug logging for Tomcat jdbc pool (Tomcat
> 6.0.32)
> >
> > My configuration:
> >
> >    <Resource auth="Container"
> >     name="jdbc/cdb.mysql"
> >     defaultAutoCommit="false"
> >     driverClassName="com.mysql.jdbc.Driver"
> >     factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
> >     url="jdbc:mysql://XXXXX.com/XXXX_dev?sessionVariables=TRANSACTION
> > ISOLATION LEVEL READ COMMITTED"
> >     username="XXXXX"
> >     password="XXXXX"
> >
> >     maxActive="100"
> >     maxIdle="100"
> >     minIdle="10"
> >     initialSize="10"
> >     maxWait="10000"
> >     testOnBorrow="true"
> >     type="javax.sql.DataSource"
> >     validationQuery="SELECT 1"/>
> >
> >
> > I have testOnBorrow and validationQuery set as you suggest, so I do
> > not
> > think that is the issue.
> >
> > Thanks,
> > Colin
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message