Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

C3P0连接池 Deadlocked PoolThread #651

Closed
zhangandyhui opened this issue Dec 4, 2018 · 2 comments
Closed

C3P0连接池 Deadlocked PoolThread #651

zhangandyhui opened this issue Dec 4, 2018 · 2 comments

Comments

@zhangandyhui
Copy link

2018-11-29 19:55:41 xxl-job-admin [com.mchange.v2.async.ThreadPoolAsynchronousRunner]-[C3P0PooledConnectionPoolManager[identityToken->z8kflt9y44kulz17l9g12|66d138e2]-AdminTaskTimer]-[log]-[220]-[WARN] com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@324185f4 -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
2018-11-29 19:55:41 xxl-job-admin [com.mchange.v2.async.ThreadPoolAsynchronousRunner]-[C3P0PooledConnectionPoolManager[identityToken->z8kflt9y44kulz17l9g12|66d138e2]-AdminTaskTimer]-[log]-[220]-[WARN] com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@324185f4 -- APPARENT DEADLOCK!!! Complete Status:
Managed Threads: 3
Active Threads: 3
Active Tasks:
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@673ed7b3
on thread: C3P0PooledConnectionPoolManager[identityToken->z8kflt9y44kulz17l9g12|66d138e2]-HelperThread-#0
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@3d9de759
on thread: C3P0PooledConnectionPoolManager[identityToken->z8kflt9y44kulz17l9g12|66d138e2]-HelperThread-#2
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@5fc8d46c
on thread: C3P0PooledConnectionPoolManager[identityToken->z8kflt9y44kulz17l9g12|66d138e2]-HelperThread-#1
Pending Tasks:
com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTask@680efaae
com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTask@799c2b53
Pool thread stack traces:
Thread[C3P0PooledConnectionPoolManager[identityToken->z8kflt9y44kulz17l9g12|66d138e2]-HelperThread-#0,5,main]
java.net.PlainSocketImpl.socketConnect(Native Method)
java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:345)
java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
java.net.Socket.connect(Socket.java:589)
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:211)
com.mysql.jdbc.MysqlIO.(MysqlIO.java:300)
com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2186)
com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2219)
com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2014)
com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:776)
com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47)
sun.reflect.GeneratedConstructorAccessor140.newInstance(Unknown Source)
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
java.lang.reflect.Constructor.newInstance(Constructor.java:422)
com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386)
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
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->z8kflt9y44kulz17l9g12|66d138e2]-HelperThread-#2,5,main]
java.net.PlainSocketImpl.socketConnect(Native Method)
java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:345)
java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
java.net.Socket.connect(Socket.java:589)
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:211)
com.mysql.jdbc.MysqlIO.(MysqlIO.java:300)
com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2186)
com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2219)
com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2014)
com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:776)
com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47)
sun.reflect.GeneratedConstructorAccessor140.newInstance(Unknown Source)
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
java.lang.reflect.Constructor.newInstance(Constructor.java:422)
com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386)
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
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->z8kflt9y44kulz17l9g12|66d138e2]-HelperThread-#1,5,main]
java.net.PlainSocketImpl.socketConnect(Native Method)
java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:345)
java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
java.net.Socket.connect(Socket.java:589)
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:211)
com.mysql.jdbc.MysqlIO.(MysqlIO.java:300)
com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2186)
com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2219)
com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2014)
com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:776)
com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47)
sun.reflect.GeneratedConstructorAccessor140.newInstance(Unknown Source)
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
java.lang.reflect.Constructor.newInstance(Constructor.java:422)
com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386)
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
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)
@hiNikos
Copy link

hiNikos commented Dec 31, 2018

host文件配置好localhost地址

@xuxueli
Copy link
Owner

xuxueli commented Feb 26, 2019

可以参考：https://blog.csdn.net/zfmsa/article/details/84293680

@xuxueli xuxueli closed this as completed Feb 26, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@xuxueli @zhangandyhui @hiNikos