I had a similar issue with JDBC and it got fixed by adding this
parameter 'numTestsPerEvictionRun' => '3',
'auth' => 'Container',
'driverClassName' => 'oracle.jdbc.OracleDriver',
'maxActive' => '30',
'maxIdle' => '8',
'maxWait' => '-1',
'minIdle' => '1',
'factory' =>
'org.apache.tomcat.jdbc.pool.DataSourceFactory',
'testWhileIdle' => 'true',
'testOnReturn' => 'false',
'validationQuery' => 'SELECT 1 FROM DUAL',
'testOnBorrow' => 'true',
'maxWait' => '-1',
'initialSize' => '1',
'removeAbandoned' => 'true',
'logAbandoned' => 'true',
'jmxEnabled' => 'true',
'jdbcInterceptors' =>
'org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer',
'validationInterval' => '30000',
'timeBetweenEvictionRunsMillis' => '30000',
'minEvictableIdleTimeMillis' => '30000',
'removeAbandonedTimeout' => '60',
'numTestsPerEvictionRun' => '3',
On Thu, Aug 27, 2020 at 1:44 PM Christopher Schultz
<ch...@christopherschultz.net> wrote:
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA256
>
> Gokhan,
>
> On 8/27/20 05:47, Gokhan Akgul wrote:
> > Hi ,
> >
> > I have been facing the deadlock issue for the last 2 months about
> > JDBCPoolCleaner Thread .
> >
> > Following config set in context.xml
> >
> > <Resource name="jdbc/database" auth="Container"
> > type="javax.sql.DataSource"
> > factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
> > driverClassName="com.mysql.jdbc.Driver"
> > url="jdbc:mysql://adress:3306/db?useUnicode=true&characterEncoding
> =latin5&characterResultSet=latin5&zeroDateTimeBehavior=convertTo
> Null&autoReconnect=true&interactiveClient=true"
> >
> >
> username="user"
> > password="pass" initialSize="10" maxActive="30" maxIdle="15"
> > minIdle="10" maxWait="30000" timeBetweenEvictionRunsMillis="5000"
> > minEvictableIdleTimeMillis="60000" removeAbandonedTimeout="600"
> > removeAbandoned="true" logAbandoned="false" testWhileIdle="true"
> > testOnBorrow="true" testOnReturn="false" validationQuery="/* ping
> > */ SELECT 1" validationInterval="30000" jmxEnabled="true"
> > jdbcInterceptors="ConnectionState;StatementFinalizer;ResetAbandonedTim
> er;SlowQueryReport"
> >
> >
> />
> >
> >
> >
> > Thread dump
> >
> > Tomcat JDBC Pool Cleaner[63445188:1598345711425] id=16
> > state=BLOCKED - waiting to lock <0x57dcb0b7> (a
> > com.mysql.jdbc.JDBC4PreparedStatement) owned by
> > http-nio-8080-exec-8 id=25 at
> > com.mysql.jdbc.PreparedStatement.realClose(PreparedStatement.java:3078
> )
> >
> >
> at
> com.mysql.jdbc.ConnectionImpl.closeAllOpenStatements(ConnectionImpl.java
> :1584)
> > at
> > com.mysql.jdbc.ConnectionImpl.realClose(ConnectionImpl.java:4364)
> > at com.mysql.jdbc.ConnectionImpl.close(ConnectionImpl.java:1556) at
> > org.apache.tomcat.jdbc.pool.PooledConnection.disconnect(PooledConnecti
> on.java:388)
> >
> >
> at
> org.apache.tomcat.jdbc.pool.PooledConnection.release(PooledConnection.ja
> va:618)
> > at
> > org.apache.tomcat.jdbc.pool.ConnectionPool.release(ConnectionPool.java
> :612)
> >
> >
> at
> org.apache.tomcat.jdbc.pool.ConnectionPool.abandon(ConnectionPool.java:5
> 69)
> > at
> > org.apache.tomcat.jdbc.pool.ConnectionPool.checkAbandoned(ConnectionPo
> ol.java:999)
> >
> >
> at
> org.apache.tomcat.jdbc.pool.ConnectionPool$PoolCleaner.run(ConnectionPoo
> l.java:1468)
> > at java.util.TimerThread.mainLoop(Timer.java:555) at
> > java.util.TimerThread.run(Timer.java:505)
> >
> > Locked synchronizers: count = 1 -
> > java.util.concurrent.locks.ReentrantReadWriteLock$NonfairSync@58039868
> >
> >
> >
> >
> > http-nio-8080-exec-8 id=25 state=BLOCKED - waiting to lock
> > <0x42de9995> (a com.mysql.jdbc.JDBC4Connection) owned by Tomcat
> > JDBC Pool Cleaner[63445188:1598345711425] id=16 at
> > com.mysql.jdbc.ConnectionImpl.useAnsiQuotedIdentifiers(ConnectionImpl.
> java:5435)
> >
> >
> at
> com.mysql.jdbc.DatabaseMetaData.getIdentifierQuoteString(DatabaseMetaDat
> a.java:3269)
> > at
> > com.mysql.jdbc.DatabaseMetaData.<init>(DatabaseMetaData.java:675)
> > at
> > com.mysql.jdbc.JDBC4DatabaseMetaData.<init>(JDBC4DatabaseMetaData.java
> :39)
> >
> >
> at sun.reflect.GeneratedConstructorAccessor24.newInstance(Unknown Source
> )
> > at
> > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingCo
> nstructorAccessorImpl.java:45)
> >
> >
> at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
> > at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at
> > com.mysql.jdbc.DatabaseMetaData.getInstance(DatabaseMetaData.java:657)
> >
> >
> at com.mysql.jdbc.ConnectionImpl.getMetaData(ConnectionImpl.java:3064)
> > at
> > com.mysql.jdbc.ConnectionImpl.getMetaData(ConnectionImpl.java:3056)
> >
> >
> at
> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:231
> 5)
> > at sun.reflect.GeneratedMethodAccessor43.invoke(Unknown Source) at
> > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess
> orImpl.java:43)
> >
> >
> at java.lang.reflect.Method.invoke(Method.java:606)
> > at
> > org.apache.tomcat.jdbc.pool.interceptor.AbstractQueryReport$StatementP
> roxy.invoke(AbstractQueryReport.java:210)
> >
> >
> at com.sun.proxy.$Proxy44.executeQuery(Unknown Source)
> > at sun.reflect.GeneratedMethodAccessor43.invoke(Unknown Source) at
> > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess
> orImpl.java:43)
> >
> >
> at java.lang.reflect.Method.invoke(Method.java:606)
> > at
> > org.apache.tomcat.jdbc.pool.interceptor.AbstractQueryReport$StatementP
> roxy.invoke(AbstractQueryReport.java:210)
> >
> >
> at com.sun.proxy.$Proxy44.executeQuery(Unknown Source)
> > at sun.reflect.GeneratedMethodAccessor43.invoke(Unknown Source) at
> > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess
> orImpl.java:43)
> >
> >
> at java.lang.reflect.Method.invoke(Method.java:606)
> > at
> > org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(Stat
> ementFacade.java:114)
> >
> >
> at com.sun.proxy.$Proxy44.executeQuery(Unknown Source)
> > at
> > org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:2
> 08)
> >
> >
> at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
> > at org.hibernate.loader.Loader.doQuery(Loader.java:802) at
> > org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loa
> der.java:274)
> >
> >
> at org.hibernate.loader.Loader.doList(Loader.java:2542)
> > at
> > org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
> > at org.hibernate.loader.Loader.list(Loader.java:2271) at
> > org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459) at
> > org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.jav
> a:365)
> >
> >
> at
> org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:19
> 6)
> > at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268) at
> > org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) at
> > org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:246)
> >
> > ......
> >
> > at
> > com.gg.healthcheck.servlet.HealthCheckServlet.getServiceStatus(HealthC
> heckServlet.java:68)
> >
> >
> at
> com.gg.healthcheck.servlet.HealthCheckServlet.doGet(HealthCheckServlet.j
> ava:45)
> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:626) at
> > javax.servlet.http.HttpServlet.service(HttpServlet.java:733) at
> > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appli
> cationFilterChain.java:231)
> >
> >
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
> erChain.java:166)
> > at
> > org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
> >
> >
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
> tionFilterChain.java:193)
> > at
> > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFi
> lterChain.java:166)
> >
> >
> at
> org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(
> CharacterEncodingFilter.java:88)
> > at
> > org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRe
> questFilter.java:107)
> >
> >
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
> tionFilterChain.java:193)
> > at
> > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFi
> lterChain.java:166)
> >
> >
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
> e.java:199)
> > at
> > org.apache.catalina.core.StandardContextValve.invoke(StandardContextVa
> lve.java:96)
> >
> >
> at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authenticator
> Base.java:543)
> > at
> > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.ja
> va:139)
> >
> >
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
> :81)
> > at
> > org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAcces
> sLogValve.java:690)
> >
> >
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
> java:87)
> > at
> > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java
> :343)
> >
> >
> at
> org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:61
> 5)
> > at
> > org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLigh
> t.java:65)
> >
> >
> at
> org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractPro
> tocol.java:818)
> > at
> > org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoi
> nt.java:1626)
> >
> >
> at
> org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.j
> ava:49)
> > - locked
> > org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper@526aa725 at
> > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.j
> ava:1145)
> >
> >
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.ja
> va:615)
> > at
> > org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThr
> ead.java:61)
> >
> >
> at java.lang.Thread.run(Thread.java:745)
> >
> > Locked synchronizers: count = 1 -
> > java.util.concurrent.ThreadPoolExecutor$Worker@21c6b5b9
> >
> >
> >
> >
> >
> > Tomcat version : 8.8.57 Java 7 Application is a simple spring mvc
> > application. Runs on Kubernetes
> >
> > Do you have any idea how to solve it?
>
> What makes you think there is deadlock here?
>
> - -chris
> -----BEGIN PGP SIGNATURE-----
> Comment: Using GnuPG with Thunderbird - https://www.enigmail.net/
>
> iQIzBAEBCAAdFiEEMmKgYcQvxMe7tcJcHPApP6U8pFgFAl9H8P0ACgkQHPApP6U8
> pFgXJA//aP2tqTjJiYz+SqwwH8V8Ad/HoP78ucJe0sCC6C8WeGjulIsSZ/Wouxmv
> YyReEoCTCwuIaIDWJDrbZVyHutZdkWeQFrs/v+sk/AsTiBHFSYtXxtZoDihy5Qt7
> vAOXDpC3Oplo19g8hqreDLZsKaSIBJPBAgdI229OvqCgDfAjbqqoMQDLDyQPZqdP
> Y+1WJ+4Alge9C1SVoVYFECl4gh+sdVJIwx+hqkBcyztzgEOuJmCyL3jHx7WP5v7t
> leEQxY6yikaWqqWjo69rHNtTwJYgkr39Uhr7EgvrXcxSdAze6Suzt8NxdirXDA6z
> hnjVAONXxgx4Mu8XDu0OPgwjfLHkYJqEqxlfKuZ28LMTX4rdJU4aVCB3skSHPGEy
> B15EapoVJBbdxT5hTlWr6dAzj8Lt8Nrda6qt4HWpJBvxvikek1MsamYrkOkeGkiW
> SiHGxV0KetvIC1S1lwbh0n01tt/Jzunm9RTGa3IBM4V7NotfXk4JHAUU47LDSbD+
> qX2k+m/dSuFmjLxE1UM4UBLm0LV7Njp6l0oEezx6be1BjnRLB376LlJjtEwIJjgr
> 5QMjEPz1Gfey/72gDipaQQEsO5lZmO3u1ThJUnKOboX3QQgJMi6dBGxZmo87JaaO
> jE0I1ABApjEWOQclv7Pe3k4ckCFzc7asEDXp7PWZdnVE7NrvnhM=
> =WV5I
> -----END PGP SIGNATURE-----
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
> For additional commands, e-mail: users-h...@tomcat.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
