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

最新推荐文章于 2024-07-02 20:42:01 发布
最新推荐文章于 2024-07-02 20:42:01 发布
阅读量597 收藏
点赞数
文章标签： mysql sql 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/u011205527/article/details/115626296
版权 
2021-04-12 15:56:05.254 [http-nio-8080-exec-1] ERROR org.apache.tomcat.jdbc.pool.ConnectionPool - Unable to create initial connections of pool.
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:425)
	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:342)
	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2188)
	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2221)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2016)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:776)
	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
	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:425)
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
	at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:310)
	at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:203)
	at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:735)
	at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:667)
	at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:482)
	at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:154)
	at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:118)
	at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:107)
	at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:131)
	at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:246)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:447)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:277)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673)
	at com.hy.software.service.impl.SoftwareServiceImpl$$EnhancerBySpringCGLIB$$8bb1a584.addSoftware(<generated>)
	at com.hy.software.controller.SoftwareController.addSoftware(SoftwareController.java:53)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:635)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317)
	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:150)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214)
	at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177)
	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)
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 com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:211)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:301)
	... 106 common frames omitted

报错的原因是我的mysql没启动；电脑刚重启，mysql没起来，启动项目报错了；解决这问题把mysql起来就好了

小 柠&甯&凝&宁&寜？
关注
mysql连接错误：com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
快乐学习
06-19 1万+
一、遇到问题在电脑上面有多个mysql版本的时候。可能会启用之前的mysql版本的执行路径，所以导致出现了这个mysql连接错误。二、找到报错具体原因。三、解决办法：一般是由于服务里面的mysql没有启动，去把MySQL的服务启动一下就好了
全网多种方法解决com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure的问题
念兮为美
03-07 6041
解决com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure错误
java image类初始化,无法初始化类javax.imageio.ImageIO
weixin_30774211的博客
03-10 1410
我试图将一个spring web应用程序部署到运行在windows azure上的生产环境中的tomcat 7(尝试过ubuntu和windows datacenter vm).遗憾的是,我在生成与ImageIo一起使用的缩略图时检索到错误(下面的堆栈跟踪).在开发过程中,我也使用了tomcat 7,所以我真的不明白,生产网络服务器有什么不同.当我尝试通过“ImageIO.scanForPlugi...
记一次 win10 tomcat服务报Could not initialize class javax.imageio.ImageIO
weixin_44756008的博客
05-12 729
在其他环境都正常的服务，重新在win10部署后用了图片压缩突然报Could not initialize class javax.imageio.ImageIO，网上找了很多文章都是说在Linux系统出现的问题，如果是windows系统出现的问题，可能是因为tomcat服务权限不够的问题，因为当初创建服务时没有用admin用户去创建。解决办法，在服务里重新修改服务登录身份配置就行。如果是Linux出现的，用如下解决办法。
com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure异常处理
最新发布
weixin_43811057的博客
07-02 312
【代码】com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure异常处理。
Invalid icc profile: duplicate sequence numbers
秀才的专栏
07-01 4383
处理图片时报异常信息：javax.imageio.IIOException: Invalid icc profile: duplicate sequence numbers报异常的图片：网上有人遇到了同样的异常信息，并使用插件解决了问题：http://stackoverflow.com/questions/32023809/javax-imageio-iioexception-invalid-ic
阿里RAP本地Ubuntu部署图片验证码显示出来 ： Could not initialize class javax.imageio.ImageIO
HeavenAndHell的专栏
04-03 2179
到tomcat bin 路径下 sed -i ‘/-Djava.io.tmpdir=/a-Djava.awt.headless=true \’ ./catalina.sh
Linux系统下项目出现Could not initialize class javax.imageio.ImageIO错误
hewenhaoxiansen的博客
02-14 3310
修改tomcat bin目录下的 catalina.sh 文件 在文件大概35%内容附近 加上JAVA_OPTS="-Djava.awt.headless=true"
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packe
qq_44724114的博客
10-08 705
啥都先别想，去自己的druid；properties文件看一下配置是不是有错误 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. a
异常解决：Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
一个抽风的女Ren的博客
07-06 6917
这个异常通常有如下信息: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet successfully received from the server was 59,977 milliseconds ago. The last packet sent successfully to the server was 1 milliseconds ago.
若依微服务项目报错解决：com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
猿小白的博客
04-24 1124
在每次重启数据库的时候，登录系统会报错。第一次会出现用户名不存在等情况，后台会报错，前端依旧可以进入，或者等待时间5分钟，期间不做任何操作，重新登录，这个问题就会复现，复现这个问题最快的方法就是重启数据库。
javax.imageio-1.0.5.jar
12-25
javax.imageio-1.0.5.jar, java处理图片的库。 从maven中央仓库下载的。实测可用。
Kaptcha Liunx 运行 报Could not initialize class javax.imageio.ImageIO 问题处理
chuzhejin5690的博客
05-21 1893
google的Kaptcha验证码 在Liunx下运行 报Could not initialize class javax.imageio.ImageIO 网上找了一下原因有两种说法 ： 1、使用了系统自带的open sdk 造成的。 --解决方法：替换成oracle的jdk； 2...
Java 运行时发生 NoClassDefFoundError: Could not initialize class 的解决方法
亦碎流年的博客
05-18 10万+
在编译时没有异常的程序，在运行时抛出异常称 NoClassDefFoundError: Could not initialize class {类名}。 根据 Java 官方文档，NoClassDefFoundError 是由于 JVM 或 ClassLoader 实例为了调用某个类的方法或 new 类的新的实例，而试图加载该类的定义时，却无法找到其定义，而抛出的异常。需要注意，对于抛出该异常的情况，试图找到的类的定义在编译时存在，只是在运行时不知所踪。 NoClassDefFoundError 总的来
项目部署至服务器Could not initialize class javax.imageio.ImageIo和Servlet.init() for servlet Kapthcha threw e
博客
10-14 2237
今天在将项目部署到服务器的时候，原来在本地可以运行的验证码放到服务器不能加载，由于本身就对Linux不是很熟悉，花了不少功夫。 先来看一下我的错误： 错误报的500，是服务器端的错误 把生成验证码的网址单独拉出来看看具体是什么错误： 看了这个错误页面，首先将错误定位到下面的Root Cause Could not initialize class javax.imageio.ImageIo 下...
java.lang.NoClassDefFoundError: Could not initialize class xxx 原因及解决方法
热门推荐
轻松囧的专栏
06-01 21万+
NoClassDefFoundError产生的原因有好几种，这里记录静态变量或静态块引起的。具体抛出的异常类似： java.lang.NoClassDefFoundError: Could not initialize class xxx JVM在加载类的时候，会初始化类里的静态变量，或执行静态块，如果这个时候抛出了异常，该类就会加载失败，那么以后任何使用到这个类的地方，都会抛出NoClass...
java.lang.NoClassDefFoundError: Could not initialize class异常
weixin_30448685的博客
08-13 1万+
oClassDefFoundError发生在编译时对应的类可用，而运行时在Java的classpath路径中，对应的类不可用导致的错误。通过查找资料，容易发生此类异常的原因是： 　　- 类依赖的class或者jar不存在 　　- 类文件存在，但是存在不同的域中1. 对应的Class在java的classpath中不可用； 2. 你可能用jar命令运行你的程序，但类并没有在jar文件...
java.lang.NoClassDefFoundError: Could not initialize class XXX
因为低调所以牛逼
09-22 2万+
估计会有好多博友有到过相同的问题，手足无措，我也遇到过这个有关Spring框架的坑爹问题，其实问题如果查到原因了，就会觉得好简单，就好比科学家们计算数字里面少了一个小数点的问题，废话不多说，说下我的解决思路。 1.报错字面上意思就是，“少注解，没有实例化 ，找不到类”。所以我就沿着这个线索开始在业务层找问题 2.果然，问题被本屌丝找到了， 如果@service  后面没有显示指定
java.lang.NoClassDefFoundError: Could not initialize class sun.awt.X11Graphi
u010473140的博客
05-26 8798
现象：项目中使用的二维码图片无法展示，查看图片链接报错500 解决方法：修改Tomcat的 bin/catalina.sh，找到 "$_RUNJAVA" $JAVA_OPTS $CATALINA_OPTS \ -Djava.endorsed.dirs="$JAVA_ENDORSED_DIRS" -classpath "$CLASSPATH" \ -Djava.security.manager \ -Djava.security.policy=="$CATALINA_B...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值