Verify your max connection is set high enough for the amount of traffic you
see in your access logs that would be making a call to the DB. Possible
code is not properly closing DB connections. Remove abandoned connections.
add to your data source config
<Resource
name="xxxxxxxxDS"
auth="Container"
url="jdbc:mysql://<FQDN>:3306/XXXXXX"
driverClassName="com.mysql.jdbc.Driver"
password="XXXXXXXXX"
username="user"
type="javax.sql.DataSource"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
testWhileIdle="true"
testOnBorrow="true"
testOnReturn="false"
validationQuery="SELECT 1"
validationInterval="30000"
timeBetweenEvictionRunsMillis="30000"
* maxActive="10"*
minIdle="10"
maxWait="10000"
initialSize="10"
* removeAbandonedTimeout="60"*
* removeAbandoned="true"*
* logAbandoned="true"*
minEvictableIdleTimeMillis="30000"
jmxEnabled="true"
/>
On Thu, Feb 15, 2018 at 6:03 AM, Mark Thomas <[email protected]> wrote:
> On 15/02/18 00:35, Halder, Arpan [ITSUS Non J&J] wrote:
> > Hi All,
> >
> > Need urgent help. We are using apache tomcat version -7.0.67 and
> sporadically facing issue that application become unresponsive and below
> error message encountered in Catalina.out log:
> >
> > ExceptionCannot get a connection, pool error Timeout waiting for idle
> object
> > Exception in detailorg.apache.tomcat.dbcp.dbcp.SQLNestedException:
> Cannot get a connection, pool error Timeout waiting for idle object
> > within doFilter of Session Filter
> > url :::::/SPECTRA/login
> > Chain.doFilter()..
> > Inside Login Method.........
> >
> > We had to restart tomcat service every time and issue gets resolved for
> the time being and again reappears sporadically. Could you please advise if
> we need to change any tomcat setting to mitigate this issue from happening
> in future.
> >
> > Please let us know if you need anything else from my side in this
> regards. Thank you in advance.
>
> It sounds like you have a connection leak in your application. Enable
> abandoned connection logging to find out where the leaked connections
> are being created.
>
> Mark
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
>
--
*Peggy Bauer*
CAO Production Support
214-770-1782
