You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2020/12/01 05:41:12 UTC

[GitHub] [shardingsphere] xtuer opened a new issue #8435: Create DataSource using YamlOrchestrationShardingDataSourceFactory error

xtuer opened a new issue #8435:
URL: https://github.com/apache/shardingsphere/issues/8435


   ## Question
   When loading configuration from Zookeeper follow the [orchestration doc](https://shardingsphere.apache.org/document/legacy/4.x/document/cn/manual/sharding-jdbc/configuration/config-yaml/#%E6%B2%BB%E7%90%86).
   
   It throws error like:
   Factory method 'dataSource' threw exception; nested exception is Cannot create property=orchestration
   for JavaBean=org.apache.shardingsphere.shardingjdbc.orchestration.internal.yaml.YamlOrchestrationShardingRuleConfiguration@3aefae67
    in 'reader', line 2, column 1:
       orchestration:
       ^
   No single argument constructor found for class org.apache.shardingsphere.orchestration.center.yaml.config.YamlCenterRepositoryConfiguration : null
   
   Environment:
   JDK: Java 8
   Zookeeper 3.6.1
   Sharding-JDBC 4.1.1
   
   
   ## What I did as follow:
   1. import dependencies in build.gradle
   ```
   dependencies {
   	implementation (
   			'org.springframework.boot:spring-boot-starter-web',
   			'org.mybatis.spring.boot:mybatis-spring-boot-starter:2.1.1',
   			'org.apache.shardingsphere:sharding-jdbc-core:4.1.1',
   
   			'org.apache.shardingsphere:sharding-jdbc-orchestration:4.1.1',
   	)
   
   	implementation('org.apache.shardingsphere:sharding-orchestration-center-zookeeper-curator:4.1.1') {
   		exclude group: 'org.apache.curator', module: 'curator-framework'
   		exclude group: 'org.apache.curator', module: 'curator-recipes'
   		exclude group: 'org.apache.curator', module: 'curator-client'
   	}
   	implementation(
   			'org.apache.curator:curator-framework:3.3.0',
   			'org.apache.curator:curator-recipes:3.3.0',
   	)
   
   	runtimeOnly('mysql:mysql-connector-java:5.1.46')
   
   	testImplementation 'org.springframework.boot:spring-boot-starter-test'
   }
   ```
   
   2. Sharding-JDBC yaml configuration
   ```
   orchestration:
     name: orchestration-sharding-data-source
     overwrite: true
     registry:
       type: zookeeper
       serverLists: localhost:2181
       namespace: sharding-sphere-orchestration
   
   dataSources:
     ds0: !!com.zaxxer.hikari.HikariDataSource
       driverClassName: com.mysql.jdbc.Driver
       jdbcUrl: jdbc:mysql://localhost:3306/demo_ds_0
       username: root
       password: root
     ds1: !!com.zaxxer.hikari.HikariDataSource
       driverClassName: com.mysql.jdbc.Driver
       jdbcUrl: jdbc:mysql://localhost:3306/demo_ds_1
       username: root
       password: root
   
   shardingRule:
     tables:
       user:
         actualDataNodes: ds${0..1}.user
         databaseStrategy:
           inline:
             shardingColumn: user_id
             algorithmExpression: ds${user_id % 2}
     defaultTableStrategy:
       none:
   ```
   
   3. Create DataSource Using Java Code
   ```java
   @Configuration
   public class AppConfig {
       @Bean
       public DataSource dataSource() throws IOException, SQLException {
           File yamlCfg = new File(new ClassPathResource("sharding-jdbc.yml").getURI());
           DataSource dataSource = YamlOrchestrationShardingDataSourceFactory.createDataSource(yamlCfg);
   
           return dataSource;
       }
   }
   ```
   
   


----------------------------------------------------------------
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.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] xtuer commented on issue #8435: Create DataSource using YamlOrchestrationShardingDataSourceFactory error

Posted by GitBox <gi...@apache.org>.
xtuer commented on issue #8435:
URL: https://github.com/apache/shardingsphere/issues/8435#issuecomment-737689900


   > @xtuer could you provide example codes for reproduce this issue (such as a github link).
   
   Thank you for your reply, please access to the repo [sharding-jdbc-orchestration-test](https://github.com/xtuer/sharding-jdbc-orchestration-test) to download the project and run to reproduce the error.


----------------------------------------------------------------
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.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] menghaoranss commented on issue #8435: Create DataSource using YamlOrchestrationShardingDataSourceFactory error

Posted by GitBox <gi...@apache.org>.
menghaoranss commented on issue #8435:
URL: https://github.com/apache/shardingsphere/issues/8435#issuecomment-740550547


   Could you provide more stack logs


----------------------------------------------------------------
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.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] menghaoranss commented on issue #8435: Create DataSource using YamlOrchestrationShardingDataSourceFactory error

Posted by GitBox <gi...@apache.org>.
menghaoranss commented on issue #8435:
URL: https://github.com/apache/shardingsphere/issues/8435#issuecomment-737615551


   @xtuer could you provide example codes for reproduce this issue (such as a github link).


----------------------------------------------------------------
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.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] menghaoranss commented on issue #8435: Create DataSource using YamlOrchestrationShardingDataSourceFactory error

Posted by GitBox <gi...@apache.org>.
menghaoranss commented on issue #8435:
URL: https://github.com/apache/shardingsphere/issues/8435#issuecomment-740438254


   The 4.x document looks a little inconsistent, please try with the configuration below:
   
   ```
   orchestration:
     demo_yaml_ds_sharding:
       orchestrationType: config_center,registry_center
       instanceType: zookeeper
       serverLists: localhost:2181
       namespace: orchestration-yaml-demo
       props:
         overwrite: true
   ```
   
   And you can download the source code by [4.1.1-tag](https://github.com/apache/shardingsphere/releases/tag/4.1.1), 
   there are  examples in the source code,thank you for your feedback!
   
   
   
   


----------------------------------------------------------------
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.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] menghaoranss commented on issue #8435: Create DataSource using YamlOrchestrationShardingDataSourceFactory error

Posted by GitBox <gi...@apache.org>.
menghaoranss commented on issue #8435:
URL: https://github.com/apache/shardingsphere/issues/8435#issuecomment-917926174


   The NPE caused by Hikari with governance has been fixed in 5.x version, please try with latest version, I will close this issue later. 


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] xtuer commented on issue #8435: Create DataSource using YamlOrchestrationShardingDataSourceFactory error

Posted by GitBox <gi...@apache.org>.
xtuer commented on issue #8435:
URL: https://github.com/apache/shardingsphere/issues/8435#issuecomment-751145579


   @menghaoranss Is there any progress?


----------------------------------------------------------------
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.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] xtuer commented on issue #8435: Create DataSource using YamlOrchestrationShardingDataSourceFactory error

Posted by GitBox <gi...@apache.org>.
xtuer commented on issue #8435:
URL: https://github.com/apache/shardingsphere/issues/8435#issuecomment-757644507


   @menghaoranss ???


----------------------------------------------------------------
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.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] xtuer commented on issue #8435: Create DataSource using YamlOrchestrationShardingDataSourceFactory error

Posted by GitBox <gi...@apache.org>.
xtuer commented on issue #8435:
URL: https://github.com/apache/shardingsphere/issues/8435#issuecomment-740509975


   > The 4.x document looks a little inconsistent, please try with the configuration below:
   > 
   > ```
   > orchestration:
   >   demo_yaml_ds_sharding:
   >     orchestrationType: config_center,registry_center
   >     instanceType: zookeeper
   >     serverLists: localhost:2181
   >     namespace: orchestration-yaml-demo
   >     props:
   >       overwrite: true
   > ```
   > 
   > And you can download the source code by [4.1.1-tag](https://github.com/apache/shardingsphere/releases/tag/4.1.1),
   > there are examples in the source code,thank you for your feedback!
   
   Thank you very much for you affords and follow the above configuration the Application can upload the configuration into Zookeeper and starts up successfully.
   
   But when I **comment dataSources and shardingRule sections, and set overwrite as false** so that it can load the configurations from Zookeeper, unfortunately, it prompts errors:
   ```
   Error creating bean with name 'dataSource' defined in class path resource [com/xtuer/AppConfig.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [javax.sql.DataSource]: Factory method 'dataSource' threw exception; nested exception is java.lang.reflect.InvocationTargetException
   ```
   
   Below is the configuration above mentioned:
   ```
   #dataSources:
   #  ds0: !!com.zaxxer.hikari.HikariDataSource
   #    driverClassName: com.mysql.jdbc.Driver
   #    jdbcUrl: jdbc:mysql://localhost:3306/demo_ds_0
   #    username: root
   #    password: root
   #  ds1: !!com.zaxxer.hikari.HikariDataSource
   #    driverClassName: com.mysql.jdbc.Driver
   #    jdbcUrl: jdbc:mysql://localhost:3306/demo_ds_1
   #    username: root
   #    password: root
   #
   #shardingRule:
   #  tables:
   #    user:
   #      actualDataNodes: ds${0..1}.user
   #      databaseStrategy:
   #        inline:
   #          shardingColumn: user_id
   #          algorithmExpression: ds${user_id % 2}
   #  defaultTableStrategy:
   #    none:
   
   orchestration:
     demo_yaml_ds_sharding:
       orchestrationType: config_center,registry_center
       instanceType: zookeeper
       serverLists: localhost:2181
       namespace: orchestration-yaml-demo
       props:
         overwrite: false
   ```


----------------------------------------------------------------
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.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] xtuer commented on issue #8435: Create DataSource using YamlOrchestrationShardingDataSourceFactory error

Posted by GitBox <gi...@apache.org>.
xtuer commented on issue #8435:
URL: https://github.com/apache/shardingsphere/issues/8435#issuecomment-741329795


   ```
   2020-12-08 17:42:33.045  INFO 2496 --- [           main] org.apache.zookeeper.ZooKeeper           : Client environment:java.io.tmpdir=C:\Users\Biao\AppData\Local\Temp\
   2020-12-08 17:42:33.045  INFO 2496 --- [           main] org.apache.zookeeper.ZooKeeper           : Client environment:java.compiler=<NA>
   2020-12-08 17:42:33.045  INFO 2496 --- [           main] org.apache.zookeeper.ZooKeeper           : Client environment:os.name=Windows 10
   2020-12-08 17:42:33.045  INFO 2496 --- [           main] org.apache.zookeeper.ZooKeeper           : Client environment:os.arch=amd64
   2020-12-08 17:42:33.045  INFO 2496 --- [           main] org.apache.zookeeper.ZooKeeper           : Client environment:os.version=10.0
   2020-12-08 17:42:33.045  INFO 2496 --- [           main] org.apache.zookeeper.ZooKeeper           : Client environment:user.name=Biao
   2020-12-08 17:42:33.046  INFO 2496 --- [           main] org.apache.zookeeper.ZooKeeper           : Client environment:user.home=C:\Users\Biao
   2020-12-08 17:42:33.046  INFO 2496 --- [           main] org.apache.zookeeper.ZooKeeper           : Client environment:user.dir=D:\workspace\Java\sharding-jdbc
   2020-12-08 17:42:33.046  INFO 2496 --- [           main] org.apache.zookeeper.ZooKeeper           : Initiating client connection, connectString=localhost:2181 sessionTimeout=60000 watcher=org.apache.curator.ConnectionState@a7f0ab6
   2020-12-08 17:42:33.062  INFO 2496 --- [127.0.0.1:2181)] org.apache.zookeeper.ClientCnxn          : Opening socket connection to server 127.0.0.1/127.0.0.1:2181. Will not attempt to authenticate using SASL (unknown error)
   2020-12-08 17:42:33.063  INFO 2496 --- [127.0.0.1:2181)] org.apache.zookeeper.ClientCnxn          : Socket connection established to 127.0.0.1/127.0.0.1:2181, initiating session
   2020-12-08 17:42:33.077  INFO 2496 --- [127.0.0.1:2181)] org.apache.zookeeper.ClientCnxn          : Session establishment complete on server 127.0.0.1/127.0.0.1:2181, sessionid = 0x1000082851d0011, negotiated timeout = 40000
   2020-12-08 17:42:33.081  INFO 2496 --- [ain-EventThread] o.a.c.f.state.ConnectionStateManager     : State change: CONNECTED
   2020-12-08 17:42:33.157  INFO 2496 --- [           main] o.a.c.f.imps.CuratorFrameworkImpl        : Starting
   2020-12-08 17:42:33.157  INFO 2496 --- [           main] org.apache.zookeeper.ZooKeeper           : Initiating client connection, connectString=localhost:2181 sessionTimeout=60000 watcher=org.apache.curator.ConnectionState@4c98a6d5
   2020-12-08 17:42:33.158  INFO 2496 --- [0:0:0:0:1:2181)] org.apache.zookeeper.ClientCnxn          : Opening socket connection to server 0:0:0:0:0:0:0:1/0:0:0:0:0:0:0:1:2181. Will not attempt to authenticate
   using SASL (unknown error)
   2020-12-08 17:42:33.159  INFO 2496 --- [0:0:0:0:1:2181)] org.apache.zookeeper.ClientCnxn          : Socket connection established to 0:0:0:0:0:0:0:1/0:0:0:0:0:0:0:1:2181, initiating session
   2020-12-08 17:42:33.160  INFO 2496 --- [0:0:0:0:1:2181)] org.apache.zookeeper.ClientCnxn          : Session establishment complete on server 0:0:0:0:0:0:0:1/0:0:0:0:0:0:0:1:2181, sessionid = 0x1000082851d0012, negotiated timeout = 40000
   2020-12-08 17:42:33.160  INFO 2496 --- [ain-EventThread] o.a.c.f.state.ConnectionStateManager     : State change: CONNECTED
   2020-12-08 17:42:33.228  WARN 2496 --- [           main] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'myController': Unsatisfied dependency expressed through field 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [com/xtuer/AppConfig.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [javax.sql.DataSource]: Factory method 'dataSource' threw exception; nested exception is java.lang.reflect.InvocationTargetException
   2020-12-08 17:42:33.230  INFO 2496 --- [           main] o.apache.catalina.core.StandardService   : Stopping service [Tomcat]
   2020-12-08 17:42:33.238  INFO 2496 --- [           main] ConditionEvaluationReportLoggingListener :
   
   Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
   2020-12-08 17:42:33.248 ERROR 2496 --- [           main] o.s.boot.SpringApplication               : Application run failed
   
   org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'myController': Unsatisfied dependency expressed through field 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [com/xtuer/AppConfig.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [javax.sql.DataSource]: Factory method 'dataSource' threw exception; nested exception is java.lang.reflect.InvocationTargetException
           at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:643) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:130) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:399) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1422) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:594) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:323) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:226) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:895) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:878) ~[spring-context-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:550) ~[spring-context-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:143) ~[spring-boot-2.3.0.RELEASE.jar:2.3.0.RELEASE]
           at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:758) [spring-boot-2.3.0.RELEASE.jar:2.3.0.RELEASE]
           at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:750) [spring-boot-2.3.0.RELEASE.jar:2.3.0.RELEASE]
           at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:397) [spring-boot-2.3.0.RELEASE.jar:2.3.0.RELEASE]
           at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) [spring-boot-2.3.0.RELEASE.jar:2.3.0.RELEASE]
           at org.springframework.boot.SpringApplication.run(SpringApplication.java:1237) [spring-boot-2.3.0.RELEASE.jar:2.3.0.RELEASE]
           at org.springframework.boot.SpringApplication.run(SpringApplication.java:1226) [spring-boot-2.3.0.RELEASE.jar:2.3.0.RELEASE]
           at com.xtuer.Application.main(Application.java:9) [main/:na]
   Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [com/xtuer/AppConfig.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [javax.sql.DataSource]: Factory method 'dataSource' threw exception; nested exception is java.lang.reflect.InvocationTargetException
           at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:656) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:484) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1338) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1177) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:557) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:323) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:226) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1306) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1226) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:640) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           ... 20 common frames omitted
   Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [javax.sql.DataSource]: Factory method 'dataSource' threw exception; nested exception is java.lang.reflect.InvocationTargetException
           at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:185) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:651) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           ... 33 common frames omitted
   Caused by: java.lang.reflect.InvocationTargetException: null
           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_251]
           at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_251]
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_251]
           at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_251]
           at org.apache.shardingsphere.underlying.common.config.DataSourceConfiguration.createDataSource(DataSourceConfiguration.java:111) ~[shardingsphere-common-4.1.1.jar:4.1.1]
           at org.apache.shardingsphere.shardingjdbc.orchestration.internal.util.DataSourceConverter.lambda$getDataSourceMap$0(DataSourceConverter.java:43) ~[sharding-jdbc-orchestration-4.1.1.jar:4.1.1]
           at java.util.stream.Collectors.lambda$toMap$58(Collectors.java:1321) ~[na:1.8.0_251]
           at java.util.stream.ReduceOps$3ReducingSink.accept(ReduceOps.java:169) ~[na:1.8.0_251]
           at java.util.HashMap$EntrySpliterator.forEachRemaining(HashMap.java:1699) ~[na:1.8.0_251]
           at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:482) ~[na:1.8.0_251]
           at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:472) ~[na:1.8.0_251]
           at java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:708) ~[na:1.8.0_251]
           at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234) ~[na:1.8.0_251]
           at java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:499) ~[na:1.8.0_251]
           at org.apache.shardingsphere.shardingjdbc.orchestration.internal.util.DataSourceConverter.getDataSourceMap(DataSourceConverter.java:43) ~[sharding-jdbc-orchestration-4.1.1.jar:4.1.1]
           at org.apache.shardingsphere.shardingjdbc.orchestration.internal.datasource.OrchestrationShardingDataSource.<init>(OrchestrationShardingDataSource.java:62) ~[sharding-jdbc-orchestration-4.1.1.jar:4.1.1]
           at org.apache.shardingsphere.shardingjdbc.orchestration.api.yaml.YamlOrchestrationShardingDataSourceFactory.createDataSource(YamlOrchestrationShardingDataSourceFactory.java:106) ~[sharding-jdbc-orchestration-4.1.1.jar:4.1.1]
           at org.apache.shardingsphere.shardingjdbc.orchestration.api.yaml.YamlOrchestrationShardingDataSourceFactory.createDataSource(YamlOrchestrationShardingDataSourceFactory.java:59) ~[sharding-jdbc-orchestration-4.1.1.jar:4.1.1]
           at com.xtuer.AppConfig.dataSource(AppConfig.java:20) ~[main/:na]
           at com.xtuer.AppConfig$$EnhancerBySpringCGLIB$$9cf04aa4.CGLIB$dataSource$0(<generated>) ~[main/:na]
           at com.xtuer.AppConfig$$EnhancerBySpringCGLIB$$9cf04aa4$$FastClassBySpringCGLIB$$15e4feff.invoke(<generated>) ~[main/:na]
           at org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:244) ~[spring-core-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:331) ~[spring-context-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at com.xtuer.AppConfig$$EnhancerBySpringCGLIB$$9cf04aa4.dataSource(<generated>) ~[main/:na]
           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_251]
           at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_251]
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_251]
           at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_251]
           at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:154) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           ... 34 common frames omitted
   Caused by: java.lang.NullPointerException: null
           at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331) ~[na:1.8.0_251]
           at java.lang.ClassLoader.loadClass(ClassLoader.java:351) ~[na:1.8.0_251]
           at com.zaxxer.hikari.HikariConfig.attemptFromContextLoader(HikariConfig.java:945) ~[HikariCP-3.4.5.jar:na]
           at com.zaxxer.hikari.HikariConfig.setExceptionOverrideClassName(HikariConfig.java:853) ~[HikariCP-3.4.5.jar:na]
           ... 63 common frames omitted
   
   2020-12-08 17:42:33.251  WARN 2496 --- [           main] o.s.boot.SpringApplication               : Unable to close ApplicationContext
   
   org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.boot.autoconfigure.availability.ApplicationAvailabilityAutoConfiguration': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration': Initialization of bean failed; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'org.springframework.context.annotation.ConfigurationClassPostProcessor.importRegistry' available
           at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:603) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:323) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:226) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:409) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1338) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1177) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:557) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:323) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:226) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:207) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.context.event.AbstractApplicationEventMulticaster.retrieveApplicationListeners(AbstractApplicationEventMulticaster.java:245) ~[spring-context-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.context.event.AbstractApplicationEventMulticaster.getApplicationListeners(AbstractApplicationEventMulticaster.java:197) ~[spring-context-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:134) ~[spring-context-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:403) ~[spring-context-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:360) ~[spring-context-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.boot.availability.AvailabilityChangeEvent.publish(AvailabilityChangeEvent.java:81) ~[spring-boot-2.3.0.RELEASE.jar:2.3.0.RELEASE]
           at org.springframework.boot.availability.AvailabilityChangeEvent.publish(AvailabilityChangeEvent.java:67) ~[spring-boot-2.3.0.RELEASE.jar:2.3.0.RELEASE]
           at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.doClose(ServletWebServerApplicationContext.java:167) ~[spring-boot-2.3.0.RELEASE.jar:2.3.0.RELEASE]
           at org.springframework.context.support.AbstractApplicationContext.close(AbstractApplicationContext.java:978) ~[spring-context-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.boot.SpringApplication.handleRunFailure(SpringApplication.java:814) [spring-boot-2.3.0.RELEASE.jar:2.3.0.RELEASE]
           at org.springframework.boot.SpringApplication.run(SpringApplication.java:325) [spring-boot-2.3.0.RELEASE.jar:2.3.0.RELEASE]
           at org.springframework.boot.SpringApplication.run(SpringApplication.java:1237) [spring-boot-2.3.0.RELEASE.jar:2.3.0.RELEASE]
           at org.springframework.boot.SpringApplication.run(SpringApplication.java:1226) [spring-boot-2.3.0.RELEASE.jar:2.3.0.RELEASE]
           at com.xtuer.Application.main(Application.java:9) [main/:na]
   Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration': Initialization of bean
   failed; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'org.springframework.context.annotation.ConfigurationClassPostProcessor.importRegistry' available
           at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:603) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:323) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:226) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:409) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1338) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1177) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:557) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:323) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:226) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:207) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.aop.framework.autoproxy.BeanFactoryAdvisorRetrievalHelper.findAdvisorBeans(BeanFactoryAdvisorRetrievalHelper.java:91) ~[spring-aop-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.aop.framework.autoproxy.AbstractAdvisorAutoProxyCreator.findCandidateAdvisors(AbstractAdvisorAutoProxyCreator.java:109) ~[spring-aop-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.aop.framework.autoproxy.AbstractAdvisorAutoProxyCreator.findEligibleAdvisors(AbstractAdvisorAutoProxyCreator.java:94) ~[spring-aop-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.aop.framework.autoproxy.AbstractAdvisorAutoProxyCreator.getAdvicesAndAdvisorsForBean(AbstractAdvisorAutoProxyCreator.java:76) ~[spring-aop-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.aop.framework.autoproxy.AbstractAutoProxyCreator.wrapIfNecessary(AbstractAutoProxyCreator.java:347) ~[spring-aop-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.aop.framework.autoproxy.AbstractAutoProxyCreator.postProcessAfterInitialization(AbstractAutoProxyCreator.java:299) ~[spring-aop-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsAfterInitialization(AbstractAutowireCapableBeanFactory.java:431) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1800) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:595) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           ... 28 common frames omitted
   Caused by: org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'org.springframework.context.annotation.ConfigurationClassPostProcessor.importRegistry' available
           at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanDefinition(DefaultListableBeanFactory.java:814) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractBeanFactory.getMergedLocalBeanDefinition(AbstractBeanFactory.java:1282) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:297) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:207) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.context.annotation.ConfigurationClassPostProcessor$ImportAwareBeanPostProcessor.postProcessBeforeInitialization(ConfigurationClassPostProcessor.java:456) ~[spring-context-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:416) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1788) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:595) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
           ... 51 common frames omitted
   ```


----------------------------------------------------------------
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.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] menghaoranss closed issue #8435: Create DataSource using YamlOrchestrationShardingDataSourceFactory error

Posted by GitBox <gi...@apache.org>.
menghaoranss closed issue #8435:
URL: https://github.com/apache/shardingsphere/issues/8435


   


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org