异常解决com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

最新推荐文章于 2025-06-20 16:24:44 发布

转载最新推荐文章于 2025-06-20 16:24:44 发布 · 959 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/travelinglightforever/p/7780641.html

文章标签：

#java #数据库 #大数据

本文记录了一次数据库连接异常的情况，具体表现为与MySQL数据库的通信链接失败。通过详细的堆栈跟踪信息，可以发现问题是由于尝试连接到未启动的服务所导致。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

21:37:08,815 DEBUG BasicResourcePool:1831 - An exception occurred while acquiring a poolable resource. Will retry.
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
   at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)
   at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1137)
   at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:355)
   at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2490)
   at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2527)
   at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2309)
   at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)
   at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
   at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)
   at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:419)
   at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:344)
   at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
   at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
   at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
   at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
   at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
   at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
   at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
   at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
Caused by: java.net.ConnectException: Connection refused: connect
   at java.net.DualStackPlainSocketImpl.connect0(Native Method)
   at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)
   at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
   at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
   at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
   at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
   at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
   at java.net.Socket.connect(Socket.java:579)
   at java.net.Socket.connect(Socket.java:528)
   at java.net.Socket.<init>(Socket.java:425)
   at java.net.Socket.<init>(Socket.java:241)
   at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:258)
   at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:305)
   ... 20 more
21:37:08,815 DEBUG BasicResourcePool:1831 - An exception occurred while acquiring a poolable resource. Will retry.
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
******************************************************************************