nacos持久化连接MySQL报错Nacos Server did not start because dumpservice bean construction failure : No Data

r囧r小猫 2022-09-11 04:23 19阅读 0赞

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dumpService': Invocation of init method failed; nested exception is java.lang.RuntimeException: Nacos Server did not start because dumpservice bean construction failure :
    No DataSource set
    	at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:139)
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:419)
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1737)
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:576)
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:498)
    	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320)
    	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
    	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318)
    	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
    	at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:273)
    	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1237)
    	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1164)
    	at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:857)
    	at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:760)
    	... 19 common frames omitted
    Caused by: java.lang.RuntimeException: Nacos Server did not start because dumpservice bean construction failure :
    No DataSource set
    	at com.alibaba.nacos.config.server.service.dump.DumpService.init(DumpService.java:141)
    	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:363)
    	at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:307)
    	at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:136)
    	... 32 common frames omitted
    
    
    Process finished with exit code 1

上面的错误：  
问题是无法和MySQL数据进行连接，需要检查下面二个地方：  
第一：characterEncoding=utf8&connectTimeout=10000&autoReconnect=true&useUnicode=true&useSSL=false&serverTimezone=UTC  
第二：  
db.url.0=jdbc:mysql://xxx.x.x.x:3306/nacos?characterEncoding=utf8&connectTimeout=10000&autoReconnect=true&useUnicode=true&useSSL=false&serverTimezone=UTC  
你会发现我们使用localhost的时候，nacos可以访问到数据库，一旦切换成IP就无法连接都数据库，这个时候需要查看本地的MySQL 的版本是不是5.6+，同时需要查看MySQL的users表是否配置了可以IP访问，下图为：

![在这里插入图片描述][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6I-c6bif55qE56qB5Y-Y_size_20_color_FFFFFF_t_70_g_se_x_16]  
这样就可以连上数据库，nacos启动就成功

[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6I-c6bif55qE56qB5Y-Y_size_20_color_FFFFFF_t_70_g_se_x_16]: /images/20220828/7d448c7d1f3c4177b1905c645681964c.png