项目连接数据库，线程死锁，C3P0数据源

最新推荐文章于 2024-04-01 14:14:52 发布

vx公众号（ICT通信人家园）

最新推荐文章于 2024-04-01 14:14:52 发布

阅读量464

点赞数

分类专栏： java入门

本文链接：https://blog.csdn.net/hacker1520/article/details/79861626

版权

博客详细记录了在项目中遇到的由于使用C3P0数据源导致的线程死锁问题。错误提示显示了一个APPARENT DEADLOCK。经过排查，作者发现问题是由于数据库URL配置为IPv4地址且该地址发生变化所致。解决方案是将数据库连接URL改为127.0.0.1，以避免IP地址变化带来的问题。

摘要由CSDN通过智能技术生成

突然报以下错误；

-----------------------------------

警告: com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@942abc6 -- APPARENT DEADLOCK!!! Complete Status:

Managed Threads: 3
Active Threads: 3
Active Tasks:
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@46b84ea5 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1)
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@5a38c12f (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2)
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@77b4cf42 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0)
Pending Tasks:
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@22de1e72
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@2697b1ea
Pool thread stack traces:
Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1,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)
java.net.Socket.connect(Socket.java:538)
java.net.Socket.<init>(Socket.java:434)
java.net.Socket.<init>(Socket.java:244)
com.mysql.jdbc.Stand