Hinsteny opened a new issue, #662:
URL: https://github.com/apache/incubator-seata-samples/issues/662
### Ⅰ. Issue Description
When i test the case under at-sample, there has an error
'java.sql.SQLNonTransientConnectionException: Public Key Retrieval is not
allowed' that the account application connecting the MYSQL Server DB.
### Ⅱ. Describe what happened
If there is an exception, please attach the exception trace:
```
2024-04-24 07:46:55.917 ERROR 1 --- [ main]
o.s.boot.SpringApplication : Application run failed
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'dataSource' defined in class path resource
[org/springframework/boot/autoconfigure/jdbc/DataSourceConfiguration$Hikari.class]:
Initialization of bean failed; nested exception is
java.lang.IllegalStateException: can not init dataSource
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:628)
~[spring-beans-5.3.26.jar!/:5.3.26]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542)
~[spring-beans-5.3.26.jar!/:5.3.26]
at
org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)
~[spring-beans-5.3.26.jar!/:5.3.26]
at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
~[spring-beans-5.3.26.jar!/:5.3.26]
at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333)
~[spring-beans-5.3.26.jar!/:5.3.26]
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208)
~[spring-beans-5.3.26.jar!/:5.3.26]
at
org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:955)
~[spring-beans-5.3.26.jar!/:5.3.26]
at
org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:920)
~[spring-context-5.3.26.jar!/:5.3.26]
at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583)
~[spring-context-5.3.26.jar!/:5.3.26]
at
org.springframework.boot.SpringApplication.refresh(SpringApplication.java:731)
~[spring-boot-2.7.10.jar!/:2.7.10]
at
org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:408)
~[spring-boot-2.7.10.jar!/:2.7.10]
at
org.springframework.boot.SpringApplication.run(SpringApplication.java:307)
~[spring-boot-2.7.10.jar!/:2.7.10]
at
org.springframework.boot.SpringApplication.run(SpringApplication.java:1303)
~[spring-boot-2.7.10.jar!/:2.7.10]
at
org.springframework.boot.SpringApplication.run(SpringApplication.java:1292)
~[spring-boot-2.7.10.jar!/:2.7.10]
at
org.apache.dubbo.samples.seata.order.OrderApplication.main(OrderApplication.java:29)
~[classes!/:na]
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:na]
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[na:na]
at
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:na]
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
~[na:na]
at
org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49)
~[app.jar:na]
at
org.springframework.boot.loader.Launcher.launch(Launcher.java:108) ~[app.jar:na]
at org.springframework.boot.loader.Launcher.launch(Launcher.java:58)
~[app.jar:na]
at
org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:65)
~[app.jar:na]
Caused by: java.lang.IllegalStateException: can not init dataSource
at
io.seata.rm.datasource.DataSourceProxy.init(DataSourceProxy.java:105)
~[seata-all-2.0.0.jar!/:2.0.0]
at
io.seata.rm.datasource.DataSourceProxy.<init>(DataSourceProxy.java:90)
~[seata-all-2.0.0.jar!/:2.0.0]
at
io.seata.rm.datasource.DataSourceProxy.<init>(DataSourceProxy.java:75)
~[seata-all-2.0.0.jar!/:2.0.0]
at
io.seata.spring.annotation.datasource.SeataAutoDataSourceProxyCreator.buildProxy(SeataAutoDataSourceProxyCreator.java:115)
~[seata-all-2.0.0.jar!/:2.0.0]
at
io.seata.spring.annotation.datasource.SeataAutoDataSourceProxyCreator.wrapIfNecessary(SeataAutoDataSourceProxyCreator.java:89)
~[seata-all-2.0.0.jar!/:2.0.0]
at
org.springframework.aop.framework.autoproxy.AbstractAutoProxyCreator.postProcessAfterInitialization(AbstractAutoProxyCreator.java:293)
~[spring-aop-5.3.26.jar!/:5.3.26]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsAfterInitialization(AbstractAutowireCapableBeanFactory.java:455)
~[spring-beans-5.3.26.jar!/:5.3.26]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1808)
~[spring-beans-5.3.26.jar!/:5.3.26]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620)
~[spring-beans-5.3.26.jar!/:5.3.26]
... 22 common frames omitted
Caused by: java.sql.SQLNonTransientConnectionException: Public Key Retrieval
is not allowed
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
~[mysql-connector-j-8.0.32.jar!/:8.0.32]
at
com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
~[mysql-connector-j-8.0.32.jar!/:8.0.32]
at
com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:824)
~[mysql-connector-j-8.0.32.jar!/:8.0.32]
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:444)
~[mysql-connector-j-8.0.32.jar!/:8.0.32]
at
com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:237)
~[mysql-connector-j-8.0.32.jar!/:8.0.32]
at
com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
~[mysql-connector-j-8.0.32.jar!/:8.0.32]
at
com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
~[HikariCP-4.0.3.jar!/:na]
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:364)
~[HikariCP-4.0.3.jar!/:na]
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206)
~[HikariCP-4.0.3.jar!/:na]
at
com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:476)
~[HikariCP-4.0.3.jar!/:na]
at
com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561)
~[HikariCP-4.0.3.jar!/:na]
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115)
~[HikariCP-4.0.3.jar!/:na]
at
com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
~[HikariCP-4.0.3.jar!/:na]
at
io.seata.rm.datasource.DataSourceProxy.init(DataSourceProxy.java:95)
~[seata-all-2.0.0.jar!/:2.0.0]
... 30 common frames omitted
```
### Ⅲ. Describe what you expected to happen
### Ⅳ. How to reproduce it (as minimally and precisely as possible)
1. cd incubator-seata-samples/at-sample/dubbo-samples-seata
2. mvn clean package -DskipTests
3. docker build account image
4. kubectl create deployment
### Ⅴ. Anything else we need to know?
Nothing
### Ⅵ. Environment:
- JDK version(e.g. `java -version`): openjdk 11
- Seata client/server version: 2.0.0
- Database version: MYSQL Server 8.0
- OS(e.g. `uname -a`): MacOS M2 Version 14.4.1
- Docker Version: 24.0.6
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
