com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@390508 -- APP

最新推荐文章于 2024-07-10 21:37:49 发布
最新推荐文章于 2024-07-10 21:37:49 发布
阅读量443 收藏
点赞数
分类专栏： Java 文章标签： java hibernate thread c3p0 mchange
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/lh19900706/article/details/84131410
版权
最近项目运行时总是出现这个警告，改过很多次数据库连接池配置也没弄好，现在终于解决了。之前出错的连接池配置: 

<property name="minPoolSize" value="5" />
<property name="maxPoolSize" value="50" />
<property name="maxIdleTime" value="1800" />
<property name="acquireIncrement" value="2" />
<property name="maxStatements" value="0" />
<property name="initialPoolSize" value="10" />
<property name="idleConnectionTestPeriod" value="30" />
<property name="acquireRetryAttempts" value="30" />

出错信息： 
WARN - com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@390508 -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
WARN - com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@390508 -- APPARENT DEADLOCK!!! Complete Status: 
	Managed Threads: 3
	Active Threads: 3
	Active Tasks: 
		com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@1e5ed7b (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2)
		com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@4a4e31 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0)
		com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@538cc2 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1)
	Pending Tasks: 
		com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@13e2b4a
		com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@8c1852
Pool thread stack traces:
	Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2,5,main]
		java.net.SocketInputStream.socketRead0(Native Method)
		java.net.SocketInputStream.read(SocketInputStream.java:129)
		java.io.DataInputStream.readFully(DataInputStream.java:178)
		java.io.DataInputStream.readFully(DataInputStream.java:152)
		net.sourceforge.jtds.jdbc.SharedSocket.readPacket(SharedSocket.java:826)
		net.sourceforge.jtds.jdbc.SharedSocket.getNetPacket(SharedSocket.java:707)
		net.sourceforge.jtds.jdbc.ResponseStream.getPacket(ResponseStream.java:466)
		net.sourceforge.jtds.jdbc.ResponseStream.read(ResponseStream.java:103)
		net.sourceforge.jtds.jdbc.ResponseStream.peek(ResponseStream.java:88)
		net.sourceforge.jtds.jdbc.TdsCore.wait(TdsCore.java:3870)
		net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1042)
		net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:406)
		net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:696)
		net.sourceforge.jtds.jdbc.JtdsDatabaseMetaData.getTables(JtdsDatabaseMetaData.java:1823)
		com.mchange.v2.c3p0.impl.DefaultConnectionTester.activeCheckConnectionNoQuery(DefaultConnectionTester.java:185)
		com.mchange.v2.c3p0.impl.DefaultConnectionTester.activeCheckConnection(DefaultConnectionTester.java:62)
		com.mchange.v2.c3p0.AbstractConnectionTester.activeCheckConnection(AbstractConnectionTester.java:67)
		com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.testPooledConnection(C3P0PooledConnectionPool.java:368)
		com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.refurbishIdleResource(C3P0PooledConnectionPool.java:310)
		com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask.run(BasicResourcePool.java:1999)
		com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
	Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0,5,main]
		java.net.SocketInputStream.socketRead0(Native Method)
		java.net.SocketInputStream.read(SocketInputStream.java:129)
		java.io.DataInputStream.readFully(DataInputStream.java:178)
		java.io.DataInputStream.readFully(DataInputStream.java:152)
		net.sourceforge.jtds.jdbc.SharedSocket.readPacket(SharedSocket.java:826)
		net.sourceforge.jtds.jdbc.SharedSocket.getNetPacket(SharedSocket.java:707)
		net.sourceforge.jtds.jdbc.ResponseStream.getPacket(ResponseStream.java:466)
		net.sourceforge.jtds.jdbc.ResponseStream.read(ResponseStream.java:103)
		net.sourceforge.jtds.jdbc.ResponseStream.peek(ResponseStream.java:88)
		net.sourceforge.jtds.jdbc.TdsCore.wait(TdsCore.java:3870)
		net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1042)
		net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:406)
		net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:696)
		net.sourceforge.jtds.jdbc.JtdsDatabaseMetaData.getTables(JtdsDatabaseMetaData.java:1823)
		com.mchange.v2.c3p0.impl.DefaultConnectionTester.activeCheckConnectionNoQuery(DefaultConnectionTester.java:185)
		com.mchange.v2.c3p0.impl.DefaultConnectionTester.activeCheckConnection(DefaultConnectionTester.java:62)
		com.mchange.v2.c3p0.AbstractConnectionTester.activeCheckConnection(AbstractConnectionTester.java:67)
		com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.testPooledConnection(C3P0PooledConnectionPool.java:368)
		com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.refurbishIdleResource(C3P0PooledConnectionPool.java:310)
		com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask.run(BasicResourcePool.java:1999)
		com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
	Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1,5,main]
		java.net.SocketInputStream.socketRead0(Native Method)
		java.net.SocketInputStream.read(SocketInputStream.java:129)
		java.io.DataInputStream.readFully(DataInputStream.java:178)
		java.io.DataInputStream.readFully(DataInputStream.java:152)
		net.sourceforge.jtds.jdbc.SharedSocket.readPacket(SharedSocket.java:826)
		net.sourceforge.jtds.jdbc.SharedSocket.getNetPacket(SharedSocket.java:707)
		net.sourceforge.jtds.jdbc.ResponseStream.getPacket(ResponseStream.java:466)
		net.sourceforge.jtds.jdbc.ResponseStream.read(ResponseStream.java:103)
		net.sourceforge.jtds.jdbc.ResponseStream.peek(ResponseStream.java:88)
		net.sourceforge.jtds.jdbc.TdsCore.wait(TdsCore.java:3870)
		net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1042)
		net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:406)
		net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:696)
		net.sourceforge.jtds.jdbc.JtdsDatabaseMetaData.getTables(JtdsDatabaseMetaData.java:1823)
		com.mchange.v2.c3p0.impl.DefaultConnectionTester.activeCheckConnectionNoQuery(DefaultConnectionTester.java:185)
		com.mchange.v2.c3p0.impl.DefaultConnectionTester.activeCheckConnection(DefaultConnectionTester.java:62)
		com.mchange.v2.c3p0.AbstractConnectionTester.activeCheckConnection(AbstractConnectionTester.java:67)
		com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.testPooledConnection(C3P0PooledConnectionPool.java:368)
		com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.refurbishIdleResource(C3P0PooledConnectionPool.java:310)
		com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask.run(BasicResourcePool.java:1999)
		com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)

当连接池配置改为 

<property name="minPoolSize" value="0" />
<property name="maxPoolSize" value="50" />
<property name="maxIdleTime" value="1800" />
<!-- 当连接池耗尽时候，一次获得连接数-->
<property name="acquireIncrement" value="5" />
<property name="maxStatements" value="0" />
<!-- 当连接池连接耗尽时，客户端getConnection(),所等待的时间-->
<property name="checkoutTimeout" value="20000"/>
<property name="idleConnectionTestPeriod" value="120" />
<!-- 当连接失效时，获得连接的次数，0为无限次（重连）-->
<property name="acquireRetryAttempts" value="30" />

新的出错信息： 
WARN - SQL Error: 0, SQLState: null
ERROR - An attempt by a client to checkout a Connection has timed out.
WARN - SQL Error: 0, SQLState: null
ERROR - An attempt by a client to checkout a Connection has timed out.
org.hibernate.exception.GenericJDBCException: Cannot open connection
	at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
	at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)
	at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
	at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
	at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547)
	at org.hibernate.loader.Loader.doQuery(Loader.java:673)
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
	at org.hibernate.loader.Loader.doList(Loader.java:2220)
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
	at org.hibernate.loader.Loader.list(Loader.java:2099)
	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
	at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
	at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
	at com.chinanfs.nfp.systemManage.user.dao.impl.UserDaoImpl.queryObjectById(UserDaoImpl.java:489)
	at com.chinanfs.nfp.systemManage.user.service.impl.UserServiceImpl.queryObjectById(UserServiceImpl.java:347)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
	at $Proxy35.queryObjectById(Unknown Source)
	at com.chinanfs.nfp.systemManage.user.action.UserAction.queryObject(UserAction.java:377)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:441)
	at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:280)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:243)
	at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:165)
	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
	at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:252)
	at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
	at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:122)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
	at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
	at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
	at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:179)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
	at org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:75)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
	at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:94)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
	at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:235)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
	at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:89)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
	at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:130)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
	at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:267)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
	at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
	at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:138)
	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
	at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:165)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
	at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
	at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:179)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
	at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:176)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
	at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
	at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:488)
	at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
	at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:91)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
	at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
	at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
	at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:527)
	at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
	at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:82)
	at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
	... 99 more
Caused by: com.mchange.v2.resourcepool.TimeoutException: A client timed out while waiting to acquire a resource from com.mchange.v2.resourcepool.BasicResourcePool@87b71b -- timeout at awaitAvailable()
	at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1317)
	at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)
	at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
	... 102 more

[b]问题已解决，配置为：[/b] 

<property name="minPoolSize" value="0" />
<property name="maxPoolSize" value="15" />
<property name="maxIdleTime" value="1800" />
<!-- 当连接池耗尽时候，一次获得连接数-->
<property name="acquireIncrement" value="5" />
<property name="maxStatements" value="0" />
<!-- 当连接池连接耗尽时，客户端getConnection(),所等待的时间-->
<property name="idleConnectionTestPeriod" value="120" />
<!-- 当连接失效时，获得连接的次数，0为无限次（重连）-->
<property name="acquireRetryAttempts" value="30" />
lh19900706
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
死锁 com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector
amyzhang1234的博客
01-08 3665
最近在IDEA中启动Tomcat经常会碰到这个错误，起初、一直没在意，现在碰到的次数多了，就去查看下这个问题，现描述如下： =2018-01-08 14:27:30,216 WARN [com.mchange.v2.async.ThreadPoolAsynchronousRunner] - com.mchange.v2.async.ThreadPoolAsynchronousRu...
mchange-commons-java-0.2.11.jar
12-31
《mchange-commons-java-0.2.11.jar：深入了解Maven依赖与Java库的构建》 在Java开发中，我们经常会遇到各种各样的jar文件，它们是Java应用程序的基础，提供了丰富的功能和API。"mchange-commons-java-0.2.11.jar...
连接数据库发生异常com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primar
jiyidianranyikeyan的专栏
12-03 1万+
<br />总的来说可以分为以下情况：<br />1：数据库的连接信息出现错误<br />2：相关的数据库的服务并没有开启<br /> <br /> <br /> 
WARN [com.mchange.v2.async.ThreadPoolAsynchronousRunner] - com.mchange.v2.as
梁同学与Android
11-30 2582
出现这种问题，先看一下数据库是否启动了，尝试一下是否能够正常连接，连接失败的话就去我的电脑，右击管理，找到服务的选项，手动开启 手动或者重新启动 第二种方法： 在下面这里也是可以开启的 ...
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@d3ade7 ,项目启动错误
热门推荐
lgh_ken的专栏
06-29 2万+
在用hibernate，spring，struts，3个框架的做项目的时候，运行tomcat，报了下面一推错误：  [0629 18:12:30 285 WARN ]     ThreadPoolAsynchronousRunner.java:608 - com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetect
c3p0 连接MySQL8出现com.mchange.v2.async.ThreadPoolAsynchronousRunner问题
TylerPY的博客
03-31 1701
MySQL8使用c3p0数据池连接时出现如下错误： 解决方法如下：（仅供参考，我就是这么解决的） 使用数据池连接数据库 1.c3p0 连接数据库 本人用的是mysql8，jdbc驱动用的是mysql-connector-java-8.0.19.jar 下载地址：https://dev.mysql.com/downloads/connector/j/ 加载完jdbc驱动复制到当前项目下，习惯...
怀疑 c3p0多次连接数据库失败后，会阻塞休眠
hitwangzhuo的专栏
12-23 1367
测试热源提出一个非必现的bug，说断开数据库后，再连上，部分数据会永远都不被处理入库。 找到原因后，完善了保证数据一致性的逻辑。但是为神马是非必现呢？ 自己折腾了几次，基本都重现了，但是每次不被处理的文件并不多。在数据库连不上的很长一段时间里，居然只有几个文件发生了问题，是不符合逻辑的。 继续深入分析，查看了断开数据库时日志，发现里面会有休眠字样的内容。据此得到以下怀疑： 1.首先，c...
[com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector.run(ThreadPoolAsynchronousR（已解决）
车马去闲闲——落日满秋山
04-01 304
使用tomcat启动程序时，报错。出现该警告的原因：数据库连接失败。
mchange-commons-java-0.2.19.jar
01-24
c3p0依赖包mchange-commons-java-0.2.19.jar； 特别说明：c3p0（c3p0-0.9.5.5.bin.tgz）的lib包里面含此mchange-commons-java-0.2.19.jar文件。
c3p0-0.9.5.2.jar，mchange-commons-java-0.2.11.jar，mysql-connector-java-8.0.11.jar
07-22
连接mysql8.0以上版本可能用到基础jar包，包括c3p0-0.9.5.2.jar，mchange-commons-java-0.2.11.jar，mysql-connector-java-8.0.11.jar三部分
mchange-commons-java-0.2.20.jar
09-24
下载地址：https://blog.csdn.net/bmyy7mwk/article/details/81150466，直接点击Files--->jar可直接下载
mchange-commons-java-0.2.3.jar.zip
04-17
mchange-commons-java.jar 各个版本，免费下载 mchange-commons-java.jar 是一个java 开发库， 提供许多常用的工具类和功能，包括数据库连接池、线程池、反射、集合操作等。
Tomcat启动项目出现com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector错误
weixin_43951534的博客
05-15 5397
15-May-2019 22:40:16.500 警告 [Timer-0] com.mchange.v2.async.ThreadPoolAsynchronousRunnerDeadlockDetector.runcom.mchange.v2.async.ThreadPoolAsynchronousRunnerDeadlockDetector.run com.mchange.v2.async.Th...
c3p0报错：com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@8988e90 -- APPARENT DEADLO
weixin_55051400的博客
06-26 2009
最近在跟着学校学习动态javaweb，利c3p0时出现如下错误，大概意思连接超时，找了好多，都说是c3p0配置文件的问题，最后发现与mysql版本有关，从8降低到5.5，成功查到了数据库内容报错内容如下
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@4c6a5c15 -- APPARENT DEADLOCK!!!
Lan_Se_Tian_Ma的博客
07-09 1412
配置文件写错的可能性不大，应该是版本问题： mysql数据库版本 和 Java使用的mysql架包版本不相同 会导致报死锁异常 例： mysql数据库 8.0.15 版 Java就得使用 mysql 8.0.15 的架包 mysql 5.5 版 Java就得使用 5.1.39 的架包 不一定要对应一摸一样的版本，但首位版本号必须相同 下面写好的工具类和配置文件，可以直接...
(已解决)C3P0数据库使用配置文件链接，报错:com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector run...
avw0108的博客
04-11 3201
本帖简单来说，注意配置的xml文件中的“&”的写法，改成xml文件中支持的“&amp;”即可解决问题。 其他类型的错误排查及排查步骤见下方 因为hibernate和spring等开源框架均使用C3P0来做来创建和管理连接。所以打算自己来体验一下C3P创建的具体过程，在使用C3P0指定的配置文件来创建连接执行简单操作测试时，出现了以下的错误： 四月 11, 201...
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector
weixin_33928137的博客
06-21 672
警告:com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@21eb3f-- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!2013-7-26 10:16:25 com.mchange....
配置Java开发环境
最新发布
Broken_x的博客
07-10 1545
Java开发环境配置
java.lang.ClassNotFoundException: com.mchange.v2.cfg.MConfig
09-21
java.lang.ClassNotFoundException: com.mchange.v2.cfg.MConfig是指在Java程序中找不到类com.mchange.v2.cfg.MConfig。解决这个问题的方法是将mchange-commons的版本换成mchange-commons-java-0.2.11版本或者将c3p0的版本换成0.9.5.2版本。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值