springcloud子模块启动报msyql连接错误

最新推荐文章于 2023-12-30 09:54:26 发布
最新推荐文章于 2023-12-30 09:54:26 发布
阅读量100 收藏
点赞数
文章标签： spring cloud java mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_55088285/article/details/130796028
版权 
	at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:86)
	at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
	at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:81)
	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
	at com.sun.proxy.$Proxy283.query(Unknown Source)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
	... 31 common frames omitted
Caused by: java.sql.SQLException: null
	at com.alibaba.druid.pool.DruidDataSource.getConnectionInternal(DruidDataSource.java:1707)
	at com.alibaba.druid.pool.DruidDataSource.getConnectionDirect(DruidDataSource.java:1427)
	at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:5059)
	at com.alibaba.druid.filter.FilterAdapter.dataSource_getConnection(FilterAdapter.java:2756)
	at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:5055)
	at com.alibaba.druid.filter.stat.StatFilter.dataSource_getConnection(StatFilter.java:726)
	at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:5055)
	at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1405)
	at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1397)
	at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:100)
	at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)
	at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
	... 43 common frames omitted
Caused by: java.lang.InterruptedException: null
	at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2034)
	at com.alibaba.druid.pool.DruidDataSource.takeLast(DruidDataSource.java:2218)
	at com.alibaba.druid.pool.DruidDataSource.getConnectionInternal(DruidDataSource.java:1690)
	... 55 common frames omitted

2023-05-21 19:47:10.800 ERROR  --- : com.alibaba.druid.pool.DruidDataSource   : create connection SQLException, url: jdbc:mysql://111.198.38.3:3306/haspm_user?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=GMT%2B8&allowMultiQueries=true&allowPublicKeyRetrieval=true, errorCode 0, state 08S01

com.mysql.cj.jdbc.exceptions.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 com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:828)
	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448)
	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241)
	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
	at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:156)
	at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:787)
	at com.alibaba.druid.filter.FilterEventAdapter.connection_connect(FilterEventAdapter.java:38)
	at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:150)
	at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:251)
	at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:150)
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1659)
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1723)
	at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2838)
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: 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.GeneratedConstructorAccessor98.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
	at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
	at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
	at com.mysql.cj.NativeSession.connect(NativeSession.java:120)
	at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:948)
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:818)
	... 12 common frames omitted
Caused by: java.net.ConnectException: Connection refused (Connection refused)
	at java.net.PlainSocketImpl.socketConnect(Native Method)
	at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
	at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
	at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
	at java.net.Socket.connect(Socket.java:589)
	at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:156)
	at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
	... 15 common frames omitted

2023-05-21 19:47:11.037  INFO  --- : com.alibaba.druid.pool.DruidDataSource   : {dataSource-1} closing ...
2023-05-21 19:47:11.039  INFO  --- : com.alibaba.druid.pool.DruidDataSource   : {dataSource-1} closed
 : com.alibaba.druid.pool.DruidDataSource   : create connection SQLException, url: jdbc:mysql://111.198.38.3:3306/accident_platform?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=GMT%2B8&allowMultiQueries=true&allowPublicKeyRetrieval=true, errorCode 0, state 08S01

com.mysql.cj.jdbc.exceptions.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 com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:828)
	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448)
	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241)
	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
	at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:156)
	at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:787)
	at com.alibaba.druid.filter.FilterEventAdapter.connection_connect(FilterEventAdapter.java:38)
	at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:150)
	at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:251)
	at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:150)
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1659)
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1723)
	at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2838)
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: 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.GeneratedConstructorAccessor98.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
	at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
	at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
	at com.mysql.cj.NativeSession.connect(NativeSession.java:120)
	at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:948)
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:818)
	... 12 common frames omitted
Caused by: java.net.ConnectException: Connection refused (Connection refused)
	at java.net.PlainSocketImpl.socketConnect(Native Method)
	at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
	at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
	at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
	at java.net.Socket.connect(Socket.java:589)
	at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:156)
	at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
	... 15 common frames omitted

永恒奔跑，寻理持
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
详解SpringCloud mysql实现配置中心
08-26
主要介绍了详解SpringCloud mysql实现配置中心，小编觉得挺不错的，现在分享给大家，也给大家做个参考。一起跟随小编过来看看吧
mysql启动错误之mysql启动报1067错误解决方法
09-10
MYSQL启动报1067错误，系统日志中是“服务 mysql 意外停止” Mysql日志中则是：Plugin 'FEDERATED' is disabled,下面给出解决方法
SpringCloud项目集成多个SpringBoot连接数据库成功
09-18
集成了多个SpringBoot项目的SpringCloud项目，并且连接MySQL数据库成功的小Demo。需要进行系统开发可直接在这个基础上添加Controller和Service内容。下载前请先看项目的执行步骤及架构链接是否合适您使用：https://blog.csdn.net/qq_36688143/article/details/82755240
Spring Cloud + React+ Mysql写的一个中型的游戏分享网站源码.zip
05-19
一个游戏分享平台源码，前后端分离系统：Spring Cloud全家桶 + React全家桶，使用Nacos作为服务发现注册中心及配置中心 + Open Feign 服务调用 + Mysql + Redis。 SpringCloud微服务项目 写一个中型的游戏分享网站 后端技术运用Spring+SpringMVC+SpringBoot + SpringCloud微服务全家桶 数据库中间件Mybatis 缓存数据库Redis（未来可能引入MongoDB做消息缓存及日志处理） 数据库MysSQL 安全框架Shiro ...... 前端方面React + antd + styled-components + react-transition-group 做页面展示及渲染 通讯axios 数据缓存仓库redux 中间件： immutable + lodash + events + history + react-router + react-router等其他相关中间件 + action处理异步请求中间件：thunk + saga （主要saga） ......
mysql服务无法启动报错误1067解决方法(mysql启动错误1067 )
09-10
mysql服务无法启动报错误1067解决方法，大家参考使用吧
springcloud 项目搭建遇到的各种问题总结
huyunqiang111的博客
07-09 5227
第一次访问无法负载均衡 ribbon.eureka.enable = true 数据源自动配置错误 Failed to auto-configure a DataSource: 'spring.datasource.url' is not specified and no embedded data 解决方法： @SpringBootApplication(exclude ...
determine embedded database driver：SpringCloud多模块项目连接数据库失败
FromNowOnUntilTheEnd
08-31 384
controller模块调用别的模块，连接数据库，一直报找不到mapper文件 Cannot determine embedded database driver class for database type NONE   需要在controller的application.yml加上扫描内容   mybatis:   mapper-locations: classpath:mappe...
springcloud搭建常见错误记录
音符跳跃每天···的博客
04-29 301
因刚入门，最近搭建springcloud遇到一些坑，折腾了也有点久，所以记录下。 1：报错：Failed to configure a DataSource: 'url' attribute is not specified and no embedd 这个错误原因有点多需要一步一步排查 一：查看是否导入了mysql-connector-java这个jar包. 二：数据库名称，账户，密码，数据库url地址是否填写错误， 三：子项目和config-server是否导入了...
Spring Cloud常见问题
Robin_hc的博客
02-23 1905
文章目录Spring Cloud常见问题ruoyi-cloud版本1. RuoYiSystemApplication启动失败，数据库连接失败2.nacos 客户端无法连接3.启动时候Invalid bound statement (not found):*.*.mapper.SysConfigMapper.selectConfigList 报错 Spring Cloud常见问题 ruoyi-cloud版本 *初次使用请一定要参考博客码云项目RuoYi-Cloud启动跳坑指南 1. RuoYiSyst
建立springboot项目遇到：Cannot resolve com.mysql:mysql-connector-java:unknown报错
热门推荐
m0_64511052的博客
02-06 1万+
建立springboot项目遇到：Cannot resolve com.mysql:mysql-connector-java:unknown报错
springboot项目启动报找不到数据库连接配置url的错误
江畔独步寻欢的博客
01-21 4737
在学习springcloud入门案例的时候，启动服务工程发现报错： 1.问题记录： APPLICATION FAILED TO START Description: Failed to configure a DataSource: ‘url’ attribute is not specified and no embedded datasource could be configured. Reason: Failed to determine a suitable driver class Actio
数据库连接错误：Communications link failure due to underlying exception
xinan_xin的博客
03-03 9068
过了年回来，调整好状态后，继续进行springcloud的学习！今天的学习中又碰到了一个之前没碰到的问题，数据库连接错误：Communications link failure due to underlying exception，具体错误信息如下所示：[org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Throwa...
JavaWeb乱七八糟的报错及其原因和解决办法（持续更新中。。。）
最新发布
CJW的博客
12-30 464
java開發常見錯誤原因及解決辦法記錄
SpringBoot + Mybatis + Druid多数据源集成的心得
weixin_34409741的博客
01-05 305
2019独角兽企业重金招聘Python工程师标准>>> ...
Druid 1.1.23日志打印ERROR DruidAbstractDataSource discard long time none received connection问题分析
bufegar0的博客
09-02 6056
问题背景 druid升级至1.1.23版本后，控制台经常会提示： [mate-system:192.168.3.6:20002] 2020-09-02 07:15:08.797 ERROR 43542 [] [XNIO-1 task-1] com.alibaba.druid.pool.DruidAbstractDataSource discard long time none received connection. , jdbcUrl : jdbc:mysql://127.0.0.1:3306/matex
druid discard long time none received connection
quietbxj的博客
09-19 2520
使用数据库框架druid，报异常：discard long time none received connection。 druid的版本问题，从最新的1.1.23 回退到 1.1.22可解决。
Mina Logging Filter日志过滤器知识介绍
纸上得来终觉浅，绝知此事要躬行
06-16 6184
原文地址：Mina Logging Filter（Apache Mina User Guide Chapter12 Logging Filter） 1.1.1. 背景 Apache MINA使用一个允许基于MINA应用程序的开发人员使用他们自己的日志系统。 1.1.1.1. SLF4J Mina使用简单的Java日志Facade(SLF4J)。你可以在这里找到SLF4J信息。这个日志记
dubbo调用超时回滚_微服务痛点基于Dubbo + Seata的分布式事务(AT模式)
weixin_39886205的博客
12-28 1609
前言Seata 是一款开源的分布式事务解决方案，致力于提供高性能和简单易用的分布式事务服务。Seata 将为用户提供了 AT、TCC、SAGA 和 XA 事务模式，为用户打造一站式的分布式解决方案。对于Seata不太了解的朋友，可以看下我之前写的文章: 微服务开发的最大痛点-分布式事务SEATA入门简介。AT模式AT模式怎么理解AT模式下，每个数据库被当做是一个Resource,Seat...
springcloud同时连接mysql和mongodb
10-10
Spring Cloud提供了多个组件，可以帮助我们在微服务架构中同时连接MySQL和MongoDB数据库。 首先，我们可以使用Spring Data JPA来连接MySQL数据库。Spring Data JPA是Spring框架的一部分，它提供了一种简化数据访问...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值