oracle c3p0 死锁,C3P0老是莫名其妙就线程死锁,但不影响程序

代码如下:2016-06-3022:40:38[WARN]-[Thread:C3P0PooledConnectionPoolManager[identityToken->1hge15w9h18tqorr1ltqcj|33d5cdd]-AdminTaskTimer]-[com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDet..

weixin_39760433

985人浏览 · 2021-04-11 07:41:32

weixin_39760433 · 2021-04-11 07:41:32 发布

代码如下:

2016-06-30 22:40:38

[WARN]-[Thread: C3P0PooledConnectionPoolManager[identityToken->

1hge15w9h18tqorr1ltqcj|33d5cdd]-AdminTaskTimer]-

[com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector.run()]

: com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@4f6d8d30

-- APPARENT DEADLOCK!!!

Creating emergency threads for unassigned pending tasks!

2016-06-30 22:40:38

[WARN]-[Thread: C3P0PooledConnectionPoolManager[identityToken->

1hge15w9h18tqorr1ltqcj|33d5cdd]-AdminTaskTimer]-

[com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector.run()]

: com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@4f6d8d30

-- APPARENT DEADLOCK!!! Complete Status:

Managed Threads: 3

Active Threads: 3

Active Tasks:

com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@41b09cda

on thread: C3P0PooledConnectionPoolManager[identityToken->1hge15w9h18tqorr1ltqcj|33d5cdd]-HelperThread-#2

com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@3209cde7

on thread: C3P0PooledConnectionPoolManager[identityToken->1hge15w9h18tqorr1ltqcj|33d5cdd]-HelperThread-#0

com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@21ad125b

on thread: C3P0PooledConnectionPoolManager[identityToken->1hge15w9h18tqorr1ltqcj|33d5cdd]-HelperThread-#1

Pending Tasks:

com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask@699025a2

com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask@7696e4d2

com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask@2c88d3d1

com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask@4b0a552e

com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask@135e657f

com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask@1a597ec8

com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask@699289fb

com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@13a0f3e3

com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@2bebc626

com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@41dff51

com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@4d6520f3

com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@2a565937

com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@afb3f98

com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@750c19c9

Pool thread stack traces:

Thread[C3P0PooledConnectionPoolManager[identityToken->1hge15w9h18tqorr1ltqcj|33d5cdd]-HelperThread-#1,5,main]

java.net.SocketInputStream.socketRead0(Native Method)

java.net.SocketInputStream.read(SocketInputStream.java:152)

java.net.SocketInputStream.read(SocketInputStream.java:122)

com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:114)

com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:161)

com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:189)

com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3036)

com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:624)

com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1110)

com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2395)

com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2428)

com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2213)

com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:797)

com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47)

sun.reflect.GeneratedConstructorAccessor41.newInstance(Unknown Source)

sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

java.lang.reflect.Constructor.newInstance(Constructor.java:526)

com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:389)

com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)

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:1138)

com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125)

com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)

com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870)

com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)

Thread[C3P0PooledConnectionPoolManager[identityToken->1hge15w9h18tqorr1ltqcj|33d5cdd]-HelperThread-#0,5,main]