1 详细异常信息

The last packet sent successfully to the server was  milliseconds ago. The driver has not received any packets from the server.

        at sun.reflect.GeneratedConstructorAccessor35.newInstance(Unknown Source)

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

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

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

        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:)

        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:)

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

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

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

        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:)

        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:)

        at sun.reflect.GeneratedConstructorAccessor31.newInstance(Unknown Source)

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

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

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

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

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

        at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:)

        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:)

        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:)

        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:)

        at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:)

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

        at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:)

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

Caused by: java.net.ConnectException: Connection refused (Connection refused)

        at java.net.PlainSocketImpl.socketConnect(Native Method)

        at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:)

        at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:)

        at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:)

        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:)

        at java.net.Socket.connect(Socket.java:)

        at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:)

        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:)

        ...  more

om.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was  milliseconds ago. The driver has not received any packets from the server.

        at sun.reflect.GeneratedConstructorAccessor39.newInstance(Unknown Source)

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

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

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

        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:)

        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:)

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

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

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

        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:)

        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:)

        at sun.reflect.GeneratedConstructorAccessor34.newInstance(Unknown Source)

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

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

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

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

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

        at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:)

        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:)

        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:)

        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:)

        at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:)

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

        at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:)

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

                                                                                                                                                                      ,-      %

        at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:)

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

Caused by: java.net.ConnectException: Connection refused (Connection refused)

        at java.net.PlainSocketImpl.socketConnect(Native Method)

        at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:)

        at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:)

        at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:)

        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:)

        at java.net.Socket.connect(Socket.java:)

        at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:)

        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:)

        ...  more

// :: WARN resourcepool.BasicResourcePool: com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@2767a64c -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (). Last acquisition attempt exception:

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was  milliseconds ago. The driver has not received any packets from the server.

        at sun.reflect.GeneratedConstructorAccessor39.newInstance(Unknown Source)

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

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

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

        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:)

        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:)

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

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

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

        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:)

        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:)

        at sun.reflect.GeneratedConstructorAccessor34.newInstance(Unknown Source)

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

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

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

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

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

        at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:)

        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:)

        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:)

        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:)

        at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:)

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

        at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:)

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

Caused by: java.net.ConnectException: Connection refused (Connection refused)

        at java.net.PlainSocketImpl.socketConnect(Native Method)

        at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:)

        at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:)

        at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:)

2 自己是在Spark程序里面调用的mysql的程序，因为是分布式环境，所以不一定是在本机调用mysql连接

分布式环境 不要用localhost的配置，导致远程主机找不到 

最新文章

  1. 千呼万唤始出来，微软Power BI简体中文版官网终于上线了，中文文档也全了。。
  2. psutil 模块
  3. Struts2学习笔记（拦截器配置添加）
  4. error LNK2019: 无法解析的外部符号 _WinMain@16，该符号在函数 ___tmainCRTStartup 中被引用
  5. 【kAri OJ】621. 廖神的树
  6. opencv编程解决warning C4003: “max”宏的实参不足
  7. Flash图表控件FusionCharts如何在图表标绘非连续数据
  8. C# Asp.net中的AOP框架 Microsoft.CCI， Mono.Cecil， Typemock Open-AOP API， PostSharp -摘自网络 （可以利用反射 Attribute 进行面向切面编程 可以用在记录整个方法的Log方面）
  9. javascript之变量、作用域、作用域链
  10. java 优化
  11. C# 常用函数和方法集
  12. MVC的验证 jquery.validate.unobtrusive
  13. ASP.NET Web API是如何根据请求选择Action的？[上篇]
  14. javascript语句语义大全（7）
  15. HDU 6097---Mindis(二分)
  16. mac 常用技巧
  17. js 筛选数据
  18. JAVA中日期转换和日期计算的方法
  19. java replaceall 使用正则表达式替换单等号，不替换其他相关的等号。
  20. 08: CORS实现跨域请求

热门文章

  1. 你应该知道的 MySQL 的锁
  2. Django 1.x版本与2.x版本 区别
  3. 某CTF比赛writeup
  4. 【并行计算-CUDA开发】Apple's OpenCL——再谈Local Memory
  5. 【Python】【demo实验28】【练习实例】【递归函数练习】
  6. centos git clone 报错 fatal: HTTP request failed 解决办法
  7. GIT SSH-KEY配置以及问题解决
  8. c++学习笔记之类模板
  9. PHP数组和对象之间的互换
  10. 第二天:python数据类型及常用方法