【已解决】com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failureThe last p

谁践踏了优雅 2024-04-01 08:21 5阅读 0赞

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:118)  
at com.alibaba.druid.filter.stat.StatFilter.connection\_connect(StatFilter.java:232)  
at com.alibaba.druid.filter.FilterChainImpl.connection\_connect(FilterChainImpl.java:112)  
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1645)  
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1709)  
at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:901)  
at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1379)  
at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1375)  
at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:79)  
at org.springframework.jdbc.datasource.lookup.AbstractRoutingDataSource.getConnection(AbstractRoutingDataSource.java:194)  
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)  
at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:80)  
at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:67)  
at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:337)  
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 org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:89)  
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)  
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)  
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)  
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)  
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)  
at java.lang.reflect.Method.invoke(Method.java:498)  
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)  
at com.sun.proxy.$Proxy104.selectList(Unknown Source)  
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)  
at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)  
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)  
at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)  
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)  
at com.sun.proxy.$Proxy105.selectConfigList(Unknown Source)  
at com.ruoyi.system.service.impl.SysConfigServiceImpl.loadingConfigCache(SysConfigServiceImpl.java:171)  
at com.ruoyi.system.service.impl.SysConfigServiceImpl.init(SysConfigServiceImpl.java:40)  
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)  
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)  
at java.lang.reflect.Method.invoke(Method.java:498)  
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:389)  
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:333)  
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:157)  
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:440)  
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1796)  
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620)  
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542)  
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)  
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)  
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333)  
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208)  
at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276)  
at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1389)  
at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1309)  
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:656)  
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:639)  
at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:119)  
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:399)  
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1431)  
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:619)  
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542)  
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)  
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)  
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333)  
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208)  
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:953)  
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:918)  
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583)  
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:145)  
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:780)  
at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:453)  
at org.springframework.boot.SpringApplication.run(SpringApplication.java:343)  
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1370)  
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1359)  
at com.ruoyi.RuoYiApplication.main(RuoYiApplication.java:18)  
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)  
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)  
at java.lang.reflect.Method.invoke(Method.java:498)  
at org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:49)  
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure

### 解决办法： ###

数据库连接后面加上：

useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&useSSL=false