search

alibaba / nacos

an easy-to-use dynamic service discovery, configuration and service management platform for building cloud native applications.
https://nacos.io
Apache License 2.0
30.39k stars 12.87k forks source link

docker-compose v2.3.2运行一段时间后总会无法重启： java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up. #12259

Closed qx517971976 closed 5 months ago

qx517971976 commented 5 months ago

用的是 example里的standalone-mysql-8.yaml，只是mysql8的数据库换成了自己搭建的，刚开始都能用，但是一段时间后nacos会无法使用，之后重启就一直报数据库连不上，数据库连接数只有100多，最大100000，已经第三次删库重建了。。。，docker-compose如下： version: "3.8" services: nacos: image: nacos/nacos-server:v2.3.2 container_name: nacos environment:

报错日志如下： nacos | 2024-06-20 20:06:58,589 ERROR Startup errors : nacos | nacos | org.springframework.context.ApplicationContextException: Unable to start web server; nested exception is org.springframework.boot.web.server.WebServerException: Unable to start embedded Tomcat nacos | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.onRefresh(ServletWebServerApplicationContext.java:165) nacos | at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:585) nacos | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:147) nacos | at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:732) nacos | at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:409) nacos | at org.springframework.boot.SpringApplication.run(SpringApplication.java:308) nacos | at org.springframework.boot.SpringApplication.run(SpringApplication.java:1300) nacos | at org.springframework.boot.SpringApplication.run(SpringApplication.java:1289) nacos | at com.alibaba.nacos.Nacos.main(Nacos.java:48) nacos | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) nacos | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) nacos | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) nacos | at java.lang.reflect.Method.invoke(Method.java:498) nacos | at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49) nacos | at org.springframework.boot.loader.Launcher.launch(Launcher.java:108) nacos | at org.springframework.boot.loader.Launcher.launch(Launcher.java:58) nacos | at org.springframework.boot.loader.PropertiesLauncher.main(PropertiesLauncher.java:467) nacos | Caused by: org.springframework.boot.web.server.WebServerException: Unable to start embedded Tomcat nacos | at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.initialize(TomcatWebServer.java:142) nacos | at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.(TomcatWebServer.java:104) nacos | at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.getTomcatWebServer(TomcatServletWebServerFactory.java:481) nacos | at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.getWebServer(TomcatServletWebServerFactory.java:211) nacos | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.createWebServer(ServletWebServerApplicationContext.java:184) nacos | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.onRefresh(ServletWebServerApplicationContext.java:162) nacos | ... 16 common frames omitted nacos | Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'basicAuthenticationFilter' defined in class path resource [com/alibaba/nacos/prometheus/filter/PrometheusAuthFilter.class]: Unsatisfied dependency expressed through method 'basicAuthenticationFilter' parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'nacosAuthConfig' defined in URL [jar:file:/home/nacos/target/nacos-server.jar!/BOOT-INF/lib/default-auth-plugin-2.3.2.jar!/com/alibaba/nacos/plugin/auth/impl/NacosAuthConfig.class]: Unsatisfied dependency expressed through constructor parameter 3; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'nacosUserDetailsServiceImpl': Unsatisfied dependency expressed through field 'userPersistService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'externalUserPersistServiceImpl': Invocation of init method failed; nested exception is java.lang.RuntimeException: java.lang.RuntimeException: [db-load-error]load jdbc.properties error nacos | at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:801) nacos | at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:536) nacos | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1352) nacos | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1195) nacos | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582) nacos | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) nacos | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) nacos | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) nacos | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) nacos | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:213) nacos | at org.springframework.boot.web.servlet.ServletContextInitializerBeans.getOrderedBeansOfType(ServletContextInitializerBeans.java:213) nacos | at org.springframework.boot.web.servlet.ServletContextInitializerBeans.getOrderedBeansOfType(ServletContextInitializerBeans.java:204) nacos | at org.springframework.boot.web.servlet.ServletContextInitializerBeans.addServletContextInitializerBeans(ServletContextInitializerBeans.java:98) nacos | at org.springframework.boot.web.servlet.ServletContextInitializerBeans.(ServletContextInitializerBeans.java:86) nacos | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.getServletContextInitializerBeans(ServletWebServerApplicationContext.java:262) nacos | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.selfInitialize(ServletWebServerApplicationContext.java:236) nacos | at org.springframework.boot.web.embedded.tomcat.TomcatStarter.onStartup(TomcatStarter.java:53) nacos | at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:4904) nacos | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171) nacos | at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1332) nacos | at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1322) nacos | at java.util.concurrent.FutureTask.run(FutureTask.java:266) nacos | at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) nacos | at java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:134) nacos | at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:866) nacos | at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:794) nacos | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171) nacos | at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1332) nacos | at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1322) nacos | at java.util.concurrent.FutureTask.run(FutureTask.java:266) nacos | at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) nacos | at java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:134) nacos | at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:866) nacos | at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:248) nacos | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171) nacos | at org.apache.catalina.core.StandardService.startInternal(StandardService.java:433) nacos | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171) nacos | at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:921) nacos | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171) nacos | at org.apache.catalina.startup.Tomcat.start(Tomcat.java:489) nacos | at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.initialize(TomcatWebServer.java:123) nacos | ... 21 common frames omitted nacos | Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'nacosAuthConfig' defined in URL [jar:file:/home/nacos/target/nacos-server.jar!/BOOT-INF/lib/default-auth-plugin-2.3.2.jar!/com/alibaba/nacos/plugin/auth/impl/NacosAuthConfig.class]: Unsatisfied dependency expressed through constructor parameter 3; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'nacosUserDetailsServiceImpl': Unsatisfied dependency expressed through field 'userPersistService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'externalUserPersistServiceImpl': Invocation of init method failed; nested exception is java.lang.RuntimeException: java.lang.RuntimeException: [db-load-error]load jdbc.properties error nacos | at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:801) nacos | at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:224) nacos | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1372) nacos | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1222) nacos | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582) nacos | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) nacos | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) nacos | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) nacos | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) nacos | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) nacos | at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:405) nacos | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1352) nacos | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1195) nacos | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582) nacos | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) nacos | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) nacos | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) nacos | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) nacos | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) nacos | at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) nacos | at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1391) nacos | at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1311) nacos | at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:911) nacos | at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:788) nacos | ... 61 common frames omitted nacos | Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'nacosUserDetailsServiceImpl': Unsatisfied dependency expressed through field 'userPersistService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'externalUserPersistServiceImpl': Invocation of init method failed; nested exception is java.lang.RuntimeException: java.lang.RuntimeException: [db-load-error]load jdbc.properties error nacos | at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:713) nacos | at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:693) nacos | at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:119) nacos | at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:408) nacos | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1431) nacos | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:619) nacos | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) nacos | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) nacos | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) nacos | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) nacos | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) nacos | at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) nacos | at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1391) nacos | at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1311) nacos | at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:911) nacos | at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:788) nacos | ... 84 common frames omitted nacos | Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'externalUserPersistServiceImpl': Invocation of init method failed; nested exception is java.lang.RuntimeException: java.lang.RuntimeException: [db-load-error]load jdbc.properties error nacos | at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:160) nacos | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:440) nacos | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1796) nacos | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620) nacos | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) nacos | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) nacos | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) nacos | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) nacos | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) nacos | at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) nacos | at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1391) nacos | at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1311) nacos | at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:710) nacos | ... 99 common frames omitted nacos | Caused by: java.lang.RuntimeException: java.lang.RuntimeException: [db-load-error]load jdbc.properties error nacos | at com.alibaba.nacos.persistence.datasource.DynamicDataSource.getDataSource(DynamicDataSource.java:60) nacos | at com.alibaba.nacos.plugin.auth.impl.persistence.ExternalUserPersistServiceImpl.init(ExternalUserPersistServiceImpl.java:55) nacos | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) nacos | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) nacos | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) nacos | at java.lang.reflect.Method.invoke(Method.java:498) nacos | at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:389) nacos | at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:333) nacos | at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:157) nacos | ... 111 common frames omitted nacos | Caused by: java.lang.RuntimeException: [db-load-error]load jdbc.properties error nacos | at com.alibaba.nacos.persistence.datasource.ExternalDataSourceServiceImpl.init(ExternalDataSourceServiceImpl.java:119) nacos | at com.alibaba.nacos.persistence.datasource.DynamicDataSource.getDataSource(DynamicDataSource.java:55) nacos | ... 119 common frames omitted nacos | Caused by: java.io.IOException: java.lang.RuntimeException: java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up. nacos | at com.alibaba.nacos.persistence.datasource.ExternalDataSourceServiceImpl.reload(ExternalDataSourceServiceImpl.java:168) nacos | at com.alibaba.nacos.persistence.datasource.ExternalDataSourceServiceImpl.init(ExternalDataSourceServiceImpl.java:116) nacos | ... 120 common frames omitted nacos | Caused by: java.lang.RuntimeException: java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up. nacos | at com.alibaba.nacos.persistence.utils.ConnectionCheckUtil.checkDataSourceConnection(ConnectionCheckUtil.java:42) nacos | at com.alibaba.nacos.persistence.datasource.ExternalDataSourceServiceImpl.lambda$reload$0(ExternalDataSourceServiceImpl.java:138) nacos | at com.alibaba.nacos.persistence.datasource.ExternalDataSourceProperties.build(ExternalDataSourceProperties.java:97) nacos | at com.alibaba.nacos.persistence.datasource.ExternalDataSourceServiceImpl.reload(ExternalDataSourceServiceImpl.java:136) nacos | ... 121 common frames omitted nacos | Caused by: java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up. nacos | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:111) nacos | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:98) nacos | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:90) nacos | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:64) nacos | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:74) nacos | at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:895) nacos | at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:820) nacos | at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:446) nacos | at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:239) nacos | at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:188) nacos | at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) nacos | at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:354) nacos | at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:202) nacos | at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:473) nacos | at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:554) nacos | at com.zaxxer.hikari.pool.HikariPool.(HikariPool.java:115) nacos | at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) nacos | at com.alibaba.nacos.persistence.utils.ConnectionCheckUtil.checkDataSourceConnection(ConnectionCheckUtil.java:40) nacos | ... 124 common frames omitted nacos | Caused by: com.mysql.cj.exceptions.CJException: Public Key Retrieval is not allowed nacos | at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) nacos | at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) nacos | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) nacos | at java.lang.reflect.Constructor.newInstance(Constructor.java:423) nacos | at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62) nacos | at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) nacos | at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:150) nacos | at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:123) nacos | at com.mysql.cj.protocol.a.authentication.CachingSha2PasswordPlugin.nextAuthenticationStep(CachingSha2PasswordPlugin.java:153) nacos | at com.mysql.cj.protocol.a.authentication.CachingSha2PasswordPlugin.nextAuthenticationStep(CachingSha2PasswordPlugin.java:49) nacos | at com.mysql.cj.protocol.a.NativeAuthenticationProvider.proceedHandshakeWithPluggableAuthentication(NativeAuthenticationProvider.java:443) nacos | at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:213) nacos | at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1430) nacos | at com.mysql.cj.NativeSession.connect(NativeSession.java:134) nacos | at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:839) nacos | ... 136 common frames omitted nacos | Caused by: com.mysql.cj.exceptions.UnableToConnectException: Public Key Retrieval is not allowed nacos | at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) nacos | at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) nacos | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) nacos | at java.lang.reflect.Constructor.newInstance(Constructor.java:423) nacos | at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62) nacos | at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:86) nacos | at com.mysql.cj.protocol.a.authentication.CachingSha2PasswordPlugin.nextAuthenticationStep(CachingSha2PasswordPlugin.java:130) nacos | ... 142 common frames omitted nacos | 2024-06-20 20:06:58,594 WARN [WatchFileCenter] start close nacos | nacos | 2024-06-20 20:06:58,595 WARN [WatchFileCenter] start to shutdown this watcher which is watch : /home/nacos/conf nacos | nacos | 2024-06-20 20:06:58,602 WARN [WatchFileCenter] already closed nacos | nacos | 2024-06-20 20:06:58,603 WARN [NotifyCenter] Start destroying Publisher nacos | nacos | 2024-06-20 20:06:58,603 WARN [NotifyCenter] Destruction of the end nacos | nacos | 2024-06-20 20:06:58,603 ERROR Nacos failed to start, please see /home/nacos/logs/nacos.log for more details. nacos | nacos | 2024-06-20 20:06:58,633 INFO nacos | nacos | Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled. nacos | nacos | 2024-06-20 20:06:58,673 ERROR Application run failed nacos | nacos | org.springframework.context.ApplicationContextException: Unable to start web server; nested exception is org.springframework.boot.web.server.WebServerException: Unable to start embedded Tomcat nacos | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.onRefresh(ServletWebServerApplicationContext.java:165) nacos | at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:585) nacos | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:147) nacos | at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:732) nacos | at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:409) nacos | at org.springframework.boot.SpringApplication.run(SpringApplication.java:308) nacos | at org.springframework.boot.SpringApplication.run(SpringApplication.java:1300) nacos | at org.springframework.boot.SpringApplication.run(SpringApplication.java:1289) nacos | at com.alibaba.nacos.Nacos.main(Nacos.java:48) nacos | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) nacos | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) nacos | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) nacos | at java.lang.reflect.Method.invoke(Method.java:498) nacos | at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49) nacos | at org.springframework.boot.loader.Launcher.launch(Launcher.java:108) nacos | at org.springframework.boot.loader.Launcher.launch(Launcher.java:58) nacos | at org.springframework.boot.loader.PropertiesLauncher.main(PropertiesLauncher.java:467) nacos | Caused by: org.springframework.boot.web.server.WebServerException: Unable to start embedded Tomcat nacos | at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.initialize(TomcatWebServer.java:142) nacos | at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.(TomcatWebServer.java:104) nacos | at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.getTomcatWebServer(TomcatServletWebServerFactory.java:481) nacos | at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.getWebServer(TomcatServletWebServerFactory.java:211) nacos | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.createWebServer(ServletWebServerApplicationContext.java:184) nacos | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.onRefresh(ServletWebServerApplicationContext.java:162) nacos | ... 16 common frames omitted nacos | Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'basicAuthenticationFilter' defined in class path resource [com/alibaba/nacos/prometheus/filter/PrometheusAuthFilter.class]: Unsatisfied dependency expressed through method 'basicAuthenticationFilter' parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'nacosAuthConfig' defined in URL [jar:file:/home/nacos/target/nacos-server.jar!/BOOT-INF/lib/default-auth-plugin-2.3.2.jar!/com/alibaba/nacos/plugin/auth/impl/NacosAuthConfig.class]: Unsatisfied dependency expressed through constructor parameter 3; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'nacosUserDetailsServiceImpl': Unsatisfied dependency expressed through field 'userPersistService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'externalUserPersistServiceImpl': Invocation of init method failed; nested exception is java.lang.RuntimeException: java.lang.RuntimeException: [db-load-error]load jdbc.properties error nacos | at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:801) nacos | at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:536) nacos | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1352) nacos | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1195) nacos | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582) nacos | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) nacos | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) nacos | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) nacos | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) nacos | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:213) nacos | at org.springframework.boot.web.servlet.ServletContextInitializerBeans.getOrderedBeansOfType(ServletContextInitializerBeans.java:213) nacos | at org.springframework.boot.web.servlet.ServletContextInitializerBeans.getOrderedBeansOfType(ServletContextInitializerBeans.java:204) nacos | at org.springframework.boot.web.servlet.ServletContextInitializerBeans.addServletContextInitializerBeans(ServletContextInitializerBeans.java:98) nacos | at org.springframework.boot.web.servlet.ServletContextInitializerBeans.(ServletContextInitializerBeans.java:86) nacos | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.getServletContextInitializerBeans(ServletWebServerApplicationContext.java:262) nacos | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.selfInitialize(ServletWebServerApplicationContext.java:236) nacos | at org.springframework.boot.web.embedded.tomcat.TomcatStarter.onStartup(TomcatStarter.java:53) nacos | at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:4904) nacos | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171) nacos | at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1332) nacos | at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1322) nacos | at java.util.concurrent.FutureTask.run(FutureTask.java:266) nacos | at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) nacos | at java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:134) nacos | at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:866) nacos | at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:794) nacos | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171) nacos | at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1332) nacos | at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1322) nacos | at java.util.concurrent.FutureTask.run(FutureTask.java:266) nacos | at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) nacos | at java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:134) nacos | at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:866) nacos | at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:248) nacos | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171) nacos | at org.apache.catalina.core.StandardService.startInternal(StandardService.java:433) nacos | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171) nacos | at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:921) nacos | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171) nacos | at org.apache.catalina.startup.Tomcat.start(Tomcat.java:489) nacos | at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.initialize(TomcatWebServer.java:123) nacos | ... 21 common frames omitted nacos | Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'nacosAuthConfig' defined in URL [jar:file:/home/nacos/target/nacos-server.jar!/BOOT-INF/lib/default-auth-plugin-2.3.2.jar!/com/alibaba/nacos/plugin/auth/impl/NacosAuthConfig.class]: Unsatisfied dependency expressed through constructor parameter 3; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'nacosUserDetailsServiceImpl': Unsatisfied dependency expressed through field 'userPersistService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'externalUserPersistServiceImpl': Invocation of init method failed; nested exception is java.lang.RuntimeException: java.lang.RuntimeException: [db-load-error]load jdbc.properties error nacos | at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:801) nacos | at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:224) nacos | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1372) nacos | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1222) nacos | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582) nacos | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) nacos | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) nacos | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) nacos | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) nacos | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) nacos | at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:405) nacos | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1352) nacos | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1195) nacos | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582) nacos | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) nacos | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) nacos | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) nacos | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) nacos | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) nacos | at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) nacos | at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1391) nacos | at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1311) nacos | at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:911) nacos | at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:788) nacos | ... 61 common frames omitted nacos | Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'nacosUserDetailsServiceImpl': Unsatisfied dependency expressed through field 'userPersistService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'externalUserPersistServiceImpl': Invocation of init method failed; nested exception is java.lang.RuntimeException: java.lang.RuntimeException: [db-load-error]load jdbc.properties error nacos | at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:713) nacos | at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:693) nacos | at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:119) nacos | at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:408) nacos | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1431) nacos | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:619) nacos | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) nacos | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) nacos | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) nacos | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) nacos | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) nacos | at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) nacos | at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1391) nacos | at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1311) nacos | at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:911) nacos | at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:788) nacos | ... 84 common frames omitted nacos | Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'externalUserPersistServiceImpl': Invocation of init method failed; nested exception is java.lang.RuntimeException: java.lang.RuntimeException: [db-load-error]load jdbc.properties error nacos | at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:160) nacos | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:440) nacos | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1796) nacos | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620) nacos | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) nacos | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) nacos | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) nacos | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) nacos | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) nacos | at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) nacos | at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1391) nacos | at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1311) nacos | at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:710) nacos | ... 99 common frames omitted nacos | Caused by: java.lang.RuntimeException: java.lang.RuntimeException: [db-load-error]load jdbc.properties error nacos | at com.alibaba.nacos.persistence.datasource.DynamicDataSource.getDataSource(DynamicDataSource.java:60) nacos | at com.alibaba.nacos.plugin.auth.impl.persistence.ExternalUserPersistServiceImpl.init(ExternalUserPersistServiceImpl.java:55) nacos | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) nacos | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) nacos | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) nacos | at java.lang.reflect.Method.invoke(Method.java:498) nacos | at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:389) nacos | at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:333) nacos | at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:157) nacos | ... 111 common frames omitted nacos | Caused by: java.lang.RuntimeException: [db-load-error]load jdbc.properties error nacos | at com.alibaba.nacos.persistence.datasource.ExternalDataSourceServiceImpl.init(ExternalDataSourceServiceImpl.java:119) nacos | at com.alibaba.nacos.persistence.datasource.DynamicDataSource.getDataSource(DynamicDataSource.java:55) nacos | ... 119 common frames omitted nacos | Caused by: java.io.IOException: java.lang.RuntimeException: java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up. nacos | at com.alibaba.nacos.persistence.datasource.ExternalDataSourceServiceImpl.reload(ExternalDataSourceServiceImpl.java:168) nacos | at com.alibaba.nacos.persistence.datasource.ExternalDataSourceServiceImpl.init(ExternalDataSourceServiceImpl.java:116) nacos | ... 120 common frames omitted nacos | Caused by: java.lang.RuntimeException: java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up. nacos | at com.alibaba.nacos.persistence.utils.ConnectionCheckUtil.checkDataSourceConnection(ConnectionCheckUtil.java:42) nacos | at com.alibaba.nacos.persistence.datasource.ExternalDataSourceServiceImpl.lambda$reload$0(ExternalDataSourceServiceImpl.java:138) nacos | at com.alibaba.nacos.persistence.datasource.ExternalDataSourceProperties.build(ExternalDataSourceProperties.java:97) nacos | at com.alibaba.nacos.persistence.datasource.ExternalDataSourceServiceImpl.reload(ExternalDataSourceServiceImpl.java:136) nacos | ... 121 common frames omitted nacos | Caused by: java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up. nacos | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:111) nacos | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:98) nacos | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:90) nacos | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:64) nacos | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:74) nacos | at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:895) nacos | at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:820) nacos | at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:446) nacos | at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:239) nacos | at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:188) nacos | at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) nacos | at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:354) nacos | at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:202) nacos | at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:473) nacos | at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:554) nacos | at com.zaxxer.hikari.pool.HikariPool.(HikariPool.java:115) nacos | at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) nacos | at com.alibaba.nacos.persistence.utils.ConnectionCheckUtil.checkDataSourceConnection(ConnectionCheckUtil.java:40) nacos | ... 124 common frames omitted nacos | Caused by: com.mysql.cj.exceptions.CJException: Public Key Retrieval is not allowed nacos | at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) nacos | at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) nacos | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) nacos | at java.lang.reflect.Constructor.newInstance(Constructor.java:423) nacos | at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62) nacos | at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) nacos | at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:150) nacos | at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:123) nacos | at com.mysql.cj.protocol.a.authentication.CachingSha2PasswordPlugin.nextAuthenticationStep(CachingSha2PasswordPlugin.java:153) nacos | at com.mysql.cj.protocol.a.authentication.CachingSha2PasswordPlugin.nextAuthenticationStep(CachingSha2PasswordPlugin.java:49) nacos | at com.mysql.cj.protocol.a.NativeAuthenticationProvider.proceedHandshakeWithPluggableAuthentication(NativeAuthenticationProvider.java:443) nacos | at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:213) nacos | at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1430) nacos | at com.mysql.cj.NativeSession.connect(NativeSession.java:134) nacos | at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:839) nacos | ... 136 common frames omitted nacos | Caused by: com.mysql.cj.exceptions.UnableToConnectException: Public Key Retrieval is not allowed nacos | at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) nacos | at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) nacos | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) nacos | at java.lang.reflect.Constructor.newInstance(Constructor.java:423) nacos | at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62) nacos | at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:86) nacos | at com.mysql.cj.protocol.a.authentication.CachingSha2PasswordPlugin.nextAuthenticationStep(CachingSha2PasswordPlugin.java:130) nacos | ... 142 common frames omitted

wuchubuzai2018 commented 5 months ago

通过你的错误提示，可以看到一个核心的错误描述: Public Key Retrieval is not allowed 建议去掉JDBC URL中的allowPublicKeyRet参数试试，这个参数我是没用过。 看网上的说法是这样的： https://www.jianshu.com/p/928eb43d0073 https://blog.csdn.net/weixin_55599565/article/details/125140094

qx517971976 commented 5 months ago

通过你的错误提示，可以看到一个核心的错误描述: Public Key Retrieval is not allowed 建议去掉JDBC URL中的allowPublicKeyRet参数试试，这个参数我是没用过。 看网上的说法是这样的： https://www.jianshu.com/p/928eb43d0073 https://blog.csdn.net/weixin_55599565/article/details/125140094

通过你的错误提示，可以看到一个核心的错误描述: Public Key Retrieval is not allowed 建议去掉JDBC URL中的allowPublicKeyRet参数试试，这个参数我是没用过。 看网上的说法是这样的： https://www.jianshu.com/p/928eb43d0073 https://blog.csdn.net/weixin_55599565/article/details/125140094

谢谢，是我写错了jdbc，最后那个参数完整的是allowPublicKeyRetrieval=true

ayewei commented 3 months ago

为了允许公钥检索，你可以通过在 JDBC URL 中添加参数 allowPublicKeyRetrieval=true 来解决这个问题

        - name: MYSQL_SERVICE_DB_PARAM
          value: "allowPublicKeyRetrieval=true"