-----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: [email protected] For additional commands, e-mail: [email protected]
