七月 02, 2021 9:40:35 下午 com.mchange.v2.async.ThreadPoolAsynchronousRunner
警告: com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@d2b15b3 -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
七月 02, 2021 9:40:35 下午 com.mchange.v2.async.ThreadPoolAsynchronousRunner
警告: com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@d2b15b3 -- APPARENT DEADLOCK!!! Complete Status:
Managed Threads: 3
Active Threads: 3
Active Tasks:
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@3ecea66
on thread: C3P0PooledConnectionPoolManager[identityToken->1hgerr5aispb6kv1sn2ndc|37527ce6]-HelperThread-#2
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@7d37ec3
on thread: C3P0PooledConnectionPoolManager[identityToken->1hgerr5aispb6kv1sn2ndc|37527ce6]-HelperThread-#1
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@42d1e05d
on thread: C3P0PooledConnectionPoolManager[identityToken->1hgerr5aispb6kv1sn2ndc|37527ce6]-HelperThread-#0
Pending Tasks:
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@1702f339
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@73598465
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@6f60c9ab
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@22fe1f12
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@22e5bb4f
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@1d2079da
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@7464c644
Pool thread stack traces:
Thread[C3P0PooledConnectionPoolManager[identityToken->1hgerr5aispb6kv1sn2ndc|37527ce6]-HelperThread-#2,5,main]
java.net.DualStackPlainSocketImpl.connect0(Native Method)
java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)
java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
java.net.Socket.connect(Socket.java:589)
com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:155)
com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
com.mysql.cj.NativeSession.connect(NativeSession.java:144)
com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:953)
com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:823)
com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:453)
com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246)
com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1176)
com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1163)
com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1908)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
数据库死锁了
下面的是数据库配置：
<!-- c3p0连接池的私有属性 -->
<property name="maxPoolSize" value="30"/>
<property name="initialPoolSize" value="10"></property>
<property name="minPoolSize" value="10"/>
<!-- 关闭连接后不自动commit -->
<property name="autoCommitOnClose" value="false"/>
<!-- 获取连接超时时间 -->
<property name="checkoutTimeout" value="10000"/>
<!-- 当获取连接失败重试次数 -->
<property name="acquireRetryAttempts" value="2"/>
</bean>