当前位置：Gxlcms > 数据库问题 > nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link fai

nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link fai

时间：2021-07-01 10:21:17 帮助过：6人阅读

 

通过查找资料，可能是wait_timeout设置过小导致的，尝试加大wait_timeout的值后，系统恢复正常。

更改过程如下：

##查看MySQL配置 root@localhost:mysql.sock [finance]>show global variables like ‘wait_timeout‘;  +---------------+-------+ | Variable_name | Value | +---------------+-------+ | wait_timeout  | 10    | +---------------+-------+ 1 row in set (0.01 sec) root@localhost:mysql.sock [finance]>show global variables like ‘%interactive_timeout%‘; +---------------------+-------+ | Variable_name       | Value | +---------------------+-------+ | interactive_timeout | 28800 | +---------------------+-------+   ##先修改全局的值为300，重启后将恢复原值 root@localhost:mysql.sock [finance]>set global wait_timeout=300;
 root@localhost:mysql.sock [finance]>show global variables like ‘wait_timeout‘; +--------------------------+----------+ | Variable_name            | Value    | +--------------------------+----------+ | wait_timeout             | 300      | +--------------------------+----------+   ##修改my.cnf，保证MySQL重启后依然生效 [mysqld]   wait_timeout=300     ## wait_timeout扩展 MySQL服务器默认的“wait_timeout”默认是28800秒即8小时，意味着如果一个连接的空闲时间超过8个小时，MySQL将自动断开该连接，而连接池却认为该连接还是有效的(因为并未校验连接的有效性)，当应用申请使用该连接时，就会导致上面的报错。
 解决方法：   修改my.cnf：  [mysqld]   wait_timeout=31536000   interactive_timeout=31536000    将过期时间修改为1年。    Error Log日志如下： 技术分享 
  1. The last packet successfully received from the server was 9,369 milliseconds ago.  The last packet sent successfully to the server was 0<span style="color: #000000"> milliseconds ago.
  2. ; SQL []; Communications link failure
  3.  
  4. The last packet successfully received from the server was </span>9,369 milliseconds ago.  The last packet sent successfully to the server was 0<span style="color: #000000"> milliseconds ago.; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  5.  
  6. The last packet successfully received from the server was </span>9,369 milliseconds ago.  The last packet sent successfully to the server was 0<span style="color: #000000"> milliseconds ago.
  7. at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:</span>98<span style="color: #000000">)
  8. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:</span>73<span style="color: #000000">)
  9. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:</span>81<span style="color: #000000">)
  10. at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:</span>73<span style="color: #000000">)
  11. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:</span>371<span style="color: #000000">)
  12. at com.sun.proxy.$Proxy11.selectList(Unknown Source)
  13. at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:</span>198<span style="color: #000000">)
  14. at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:</span>119<span style="color: #000000">)
  15. at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:</span>63<span style="color: #000000">)
  16. at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:</span>52<span style="color: #000000">)
  17. at com.sun.proxy.$Proxy12.searchRules(Unknown Source)
  18. at com.tianlian.order.server.finance.service.impl.poundage.WPOSPoundageServiceImpl.searchRules(WPOSPoundageServiceImpl.java:</span>55<span style="color: #000000">)
  19. at com.tianlian.order.server.finance.service.impl.poundage.WPOSPoundageServiceImpl$$FastClassBySpringCGLIB$$aec2fff5.invoke(</span><generated><span style="color: #000000">)
  20. at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:</span>204<span style="color: #000000">)
  21. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:</span>720<span style="color: #000000">)
  22. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:</span>157<span style="color: #000000">)
  23. at com.alibaba.druid.support.spring.stat.DruidStatInterceptor.invoke(DruidStatInterceptor.java:</span>72<span style="color: #000000">)
  24. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:</span>179<span style="color: #000000">)
  25. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:</span>655<span style="color: #000000">)
  26. at com.tianlian.order.server.finance.service.impl.poundage.WPOSPoundageServiceImpl$$EnhancerBySpringCGLIB$$db4e378e.searchRules(</span><generated><span style="color: #000000">)
  27. at com.alibaba.dubbo.common.bytecode.Wrapper0.invokeMethod(Wrapper0.java)
  28. at com.alibaba.dubbo.rpc.proxy.javassist.JavassistProxyFactory$</span>1.doInvoke(JavassistProxyFactory.java:46<span style="color: #000000">)
  29. at com.alibaba.dubbo.rpc.proxy.AbstractProxyInvoker.invoke(AbstractProxyInvoker.java:</span>72<span style="color: #000000">)
  30. at com.alibaba.dubbo.rpc.protocol.InvokerWrapper.invoke(InvokerWrapper.java:</span>53<span style="color: #000000">)
  31. at com.alibaba.dubbo.rpc.filter.ExceptionFilter.invoke(ExceptionFilter.java:</span>64<span style="color: #000000">)
  32. at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$</span>1.invoke(ProtocolFilterWrapper.java:91<span style="color: #000000">)
  33. at com.alibaba.dubbo.rpc.filter.TimeoutFilter.invoke(TimeoutFilter.java:</span>42<span style="color: #000000">)
  34. at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$</span>1.invoke(ProtocolFilterWrapper.java:91<span style="color: #000000">)
  35. at com.alibaba.dubbo.monitor.support.MonitorFilter.invoke(MonitorFilter.java:</span>75<span style="color: #000000">)
  36. at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$</span>1.invoke(ProtocolFilterWrapper.java:91<span style="color: #000000">)
  37. at com.alibaba.dubbo.rpc.protocol.dubbo.filter.TraceFilter.invoke(TraceFilter.java:</span>78<span style="color: #000000">)
  38. at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$</span>1.invoke(ProtocolFilterWrapper.java:91<span style="color: #000000">)
  39. at com.alibaba.dubbo.rpc.filter.ContextFilter.invoke(ContextFilter.java:</span>60<span style="color: #000000">)
  40. at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$</span>1.invoke(ProtocolFilterWrapper.java:91<span style="color: #000000">)
  41. at com.alibaba.dubbo.rpc.filter.GenericFilter.invoke(GenericFilter.java:</span>112<span style="color: #000000">)
  42. at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$</span>1.invoke(ProtocolFilterWrapper.java:91<span style="color: #000000">)
  43. at com.alibaba.dubbo.rpc.filter.ClassLoaderFilter.invoke(ClassLoaderFilter.java:</span>38<span style="color: #000000">)
  44. at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$</span>1.invoke(ProtocolFilterWrapper.java:91<span style="color: #000000">)
  45. at com.alibaba.dubbo.rpc.filter.EchoFilter.invoke(EchoFilter.java:</span>38<span style="color: #000000">)
  46. at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$</span>1.invoke(ProtocolFilterWrapper.java:91<span style="color: #000000">)
  47. at com.alibaba.dubbo.rpc.protocol.dubbo.DubboProtocol$</span>1.reply(DubboProtocol.java:108<span style="color: #000000">)
  48. at com.alibaba.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.handleRequest(HeaderExchangeHandler.java:</span>84<span style="color: #000000">)
  49. at com.alibaba.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.received(HeaderExchangeHandler.java:</span>170<span style="color: #000000">)
  50. at com.alibaba.dubbo.remoting.transport.DecodeHandler.received(DecodeHandler.java:</span>52<span style="color: #000000">)
  51. at com.alibaba.dubbo.remoting.transport.dispatcher.ChannelEventRunnable.run(ChannelEventRunnable.java:</span>82<span style="color: #000000">)
  52. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:</span>1145<span style="color: #000000">)
  53. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:</span>615<span style="color: #000000">)
  54. at java.lang.Thread.run(Thread.java:</span>722<span style="color: #000000">)
  55. Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure</span>
Error log

nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link fai

标签：cep   lte   runnable   app   程序   默认   link   jdbc   received   

人气教程排行

本站所有资源全部来源于网络，若本站发布的内容侵害到您的隐私或者利益，请联系我们删除！