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 2022/07/19 05:31:48 UTC

[GitHub] [shardingsphere] 110117 opened a new issue, #19348: How to configure multiple data sources

110117 opened a new issue, #19348:
URL: https://github.com/apache/shardingsphere/issues/19348

   2022-07-17  INFO [ io.seata.core.rpc.processor.client.RmUndoLogProcessor - rm handle undo log process:UndoLogDeleteRequest{resourceId='jdbc:postgresql://xx.xx.xx.xx', saveDays=7, branchType=AT} Main library
   2022-07-17  INFO [] io.seata.core.rpc.processor.client.RmUndoLogProcessor - rm handle undo log process:UndoLogDeleteRequest{resourceId='jdbc:postgresql://xx.xx.xx.xx', saveDays=7, branchType=AT} Slave library
   2022-07-17  INFO [] io.seata.core.rpc.processor.client.RmUndoLogProcessor - rm handle undo log process:UndoLogDeleteRequest{resourceId='jdbc:postgresql://xx.xx.xx.xx', saveDays=7, branchType=AT} Main library
   2022-07-17  INFO [] io.seata.core.rpc.processor.client.RmUndoLogProcessor - rm handle undo log process:UndoLogDeleteRequest{resourceId='jdbc:postgresql://xx.xx.xx.xx', saveDays=7, branchType=AT} Slave library
   2022-07-17  ERROR [] io.seata.rm.RMHandlerAT - Failed to delete expired undo_log, error:ERROR: cannot execute DELETE in a read-only transaction
   org.postgresql.util.PSQLException: ERROR: cannot execute DELETE in a read-only transaction
           at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2674)
           at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2364)
           at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:354)
           at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:484)
           at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:404)
           at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:162)
           at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:130)
           at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeUpdate(DruidPooledPreparedStatement.java:255)
           at io.seata.rm.datasource.undo.postgresql.PostgresqlUndoLogManager.deleteUndoLogByLogCreated(PostgresqlUndoLogManager.java:59)
           at io.seata.rm.RMHandlerAT.handle(RMHandlerAT.java:59)
           at io.seata.rm.DefaultRMHandler.handle(DefaultRMHandler.java:73)
           at io.seata.core.protocol.transaction.UndoLogDeleteRequest.handle(UndoLogDeleteRequest.java:70)
           at io.seata.rm.AbstractRMHandler.onRequest(AbstractRMHandler.java:150)
   


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

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


[GitHub] [shardingsphere] 110117 commented on issue #19348: How to configure multiple data sources

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

   @linghengqian 
   I think my problem is very simple. 
   Sharding takes over my data source, and the read-write is separated. 
   The write library is only responsible for writing data, and the read library is only responsible for reading data. 
   The data source of my middleware Seata is the same as that of sharding. Now I need to distinguish this data source so that Seata can only recognize the write library. So my question is: how can I only get the data source of the write library


-- 
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] 110117 commented on issue #19348: How to configure multiple data sources

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

     datasource:
         names: master0,master0slave0,master1,master1slave0
         master0:
           type: com.alibaba.druid.pool.DruidDataSource
           driver-class-name: org.postgresql.Driver
           url: jdbc:postgresql://xxx
           username: xx
           password: xx
           #durid连接池的属性
           initial-size: 10
           max-active: 100
           min-idle: 5
           max-wait: 30000
           validation-query: select 0
           time-between-eviction-runs-millis: 60000
           min-evictableIdle-time-millis: 1800000
           pool-prepared-statements: true
           max-pool-prepared-statement-per-connection-size: 100
           test-on-borrow: false
           test-on-return: false
           test-while-idle: true
         master0slave0:
           type: com.alibaba.druid.pool.DruidDataSource
           driver-class-name: org.postgresql.Driver
           url: jdbc:postgresql://xx
           username: postgres
           password: postgres
      rules:
         readwrite-splitting:
           load-balancers:
             round-robin:
               type: ROUND_ROBIN
           data-sources:
             ds-0:
               write-data-source-name: master0   **this is master Libaray**
               read-data-source-names: master0slave0  **this is slave Libaray**
               load-balancer-name: round-robin
             ds-1:
               write-data-source-name: master1  **this is master Libaray**
               read-data-source-names: master1slave0  **this is slave Libaray**
               load-balancer-name: round-robin
   
   > * ERROR
   
   
   
   > 
   
   Seata


-- 
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] 110117 commented on issue #19348: How to configure multiple data sources

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

   write-data-source-name is mater library   read-data-source-names is slave library


-- 
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] terrymanu commented on issue #19348: How to configure multiple data sources

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

   What is `main database` for you? It is better to explain some concepts first.
   Please illustrate your goal. 


-- 
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] terrymanu commented on issue #19348: How to configure multiple data sources

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

   > Master library
   
   What is `Master library`?


-- 
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] linghengqian commented on issue #19348: How to configure multiple data sources

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

   Your issue description sounds completely irrelevant to the problem you're trying to deal with, and it doesn't help anyone understand what the problem is.


-- 
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] 110117 commented on issue #19348: How to configure multiple data sources

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

   `  datasource:
         names: master0,master0slave0,master1,master1slave0
         master0:
           type: com.alibaba.druid.pool.DruidDataSource
           driver-class-name: org.postgresql.Driver
           url: jdbc:postgresql://xxx
           username: postgres
           password: postgres
         master0slave0:
           type: com.alibaba.druid.pool.DruidDataSource
           driver-class-name: org.postgresql.Driver
           url: jdbc:postgresql://xxxx
           username: postgres
           password: postgres
         master1:
           type: com.alibaba.druid.pool.DruidDataSource
           driver-class-name: org.postgresql.Driver
           url: jdbc:postgresql://xxx
           username: postgres
           password: postgres
         master1slave0:
           type: com.alibaba.druid.pool.DruidDataSource
           driver-class-name: org.postgresql.Driver
           url: jdbc:postgresql://xxx
           username: postgres
           password: postgres
           #
       props:
         sql-show: true
       rules:
         readwrite-splitting:
           load-balancers:
             round-robin:
               type: ROUND_ROBIN
           data-sources:
             ds-0:
               write-data-source-name: master0  #**this is master Libaray**
               read-data-source-names: master0slave0  #**this is slave Libaray**
               load-balancer-name: round-robin
             ds-1:
               write-data-source-name: master1
               read-data-source-names: master1slave0
               load-balancer-name: round-robin`


-- 
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] 110117 commented on issue #19348: How to configure multiple data sources

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

   \*  datasource:
         names: master0,master0slave0,master1,master1slave0
         master0:
           type: com.alibaba.druid.pool.DruidDataSource
           driver-class-name: org.postgresql.Driver
           url: jdbc:postgresql://xxx
           username: postgres
           password: postgres
           #durid连接池的属性
           initial-size: 10
           max-active: 100
           min-idle: 5
           max-wait: 30000
           validation-query: select 0
           time-between-eviction-runs-millis: 60000
           min-evictableIdle-time-millis: 1800000
           pool-prepared-statements: true
           max-pool-prepared-statement-per-connection-size: 100
           test-on-borrow: false
           test-on-return: false
           test-while-idle: true
         master0slave0:
           type: com.alibaba.druid.pool.DruidDataSource
           driver-class-name: org.postgresql.Driver
           url: jdbc:postgresql://xxxx
           username: postgres
           password: postgres
           #省略durid连接池的属性
         master1:
           type: com.alibaba.druid.pool.DruidDataSource
           driver-class-name: org.postgresql.Driver
           url: jdbc:postgresql://xxx
           username: postgres
           password: postgres
           #省略durid连接池的属性
         master1slave0:
           type: com.alibaba.druid.pool.DruidDataSource
           driver-class-name: org.postgresql.Driver
           url: jdbc:postgresql://xxx
           username: postgres
           password: postgres
           #省略durid连接池的属性
       # 在日志中打印 SQ
       props:
         sql-show: true
       rules:
         readwrite-splitting:
           load-balancers:
             round-robin:
               type: ROUND_ROBIN
           data-sources:
             ds-0:
               write-data-source-name: master0
               read-data-source-names: master0slave0
               load-balancer-name: round-robin
             ds-1:
               write-data-source-name: master1
               read-data-source-names: master1slave0
               load-balancer-name: round-robin\*


-- 
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] linghengqian commented on issue #19348: How to configure multiple data sources

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

   - When ShardingSphere masks the concept of real databases and tables, the concept of getting the primary database becomes rather obscure, and operations on the primary database should actually be client-side-unaware. The necessary operations on the master library are actually performed through DistSQL. 
   
   - I have to point out, what does the middleware you mean have to do with your inexplicable ERROR LOG? 😕


-- 
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] 110117 commented on issue #19348: How to configure multiple data sources

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

   Middleware Seata scheduled task delete undo_ Log,
   
   Deleted undo from library_ Log, sharding agent the data source of the slave database, resulting in the deletion of the slave database undo_ Log times is wrong


-- 
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] linghengqian commented on issue #19348: How to configure multiple data sources

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

   This is not the standard YAML 1.1 format. You need to format markdown.


-- 
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] linghengqian commented on issue #19348: How to configure multiple data sources

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

   - From the adjustments I remember, it is designed to be an unlikely thing for an individual to handle the main database of read-write separation individually, although this may have been the case in the past. 
   
   - But the actual solution shouldn't be this line of thinking, which is why I confused you about the reproduction steps of your LOG.


-- 
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] 110117 commented on issue #19348: How to configure multiple data sources

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

     Middleware Seata scheduled task delete undo_log,
   
   Deleted undo slave library undo_log, sharding agent the data source of the slave database, resulting in the deletion of the slave database undo_ Log times is wrong


-- 
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] 110117 closed issue #19348: How to configure multiple data sources

Posted by GitBox <gi...@apache.org>.
110117 closed issue #19348: How to configure multiple data sources
URL: https://github.com/apache/shardingsphere/issues/19348


-- 
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] terrymanu commented on issue #19348: How to configure multiple data sources

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

   ShardingSphere is faced to sharding, the basic feature is config multiple data sources.
   What is your question?


-- 
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] 110117 commented on issue #19348: How to configure multiple data sources

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

   ![Uploading image.png…]()
   11


-- 
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] 110117 commented on issue #19348: How to configure multiple data sources

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

   datasource:
   names: master0,master0slave0,master1,master1slave0
   master0:
   type: com.alibaba.druid.pool.DruidDataSource
   driver-class-name: org.postgresql.Driver
   url: jdbc:postgresql://xxx
   username: postgres
   password: postgres
   master0slave0:
   type: com.alibaba.druid.pool.DruidDataSource
   driver-class-name: org.postgresql.Driver
   url: jdbc:postgresql://xxxx
   username: postgres
   password: postgres
   master1:
   type: com.alibaba.druid.pool.DruidDataSource
   driver-class-name: org.postgresql.Driver
   url: jdbc:postgresql://xxx
   username: postgres
   password: postgres
   master1slave0:
   type: com.alibaba.druid.pool.DruidDataSource
   driver-class-name: org.postgresql.Driver
   url: jdbc:postgresql://xxx
   username: postgres
   password: postgres
   #
   props:
   sql-show: true
   rules:
   readwrite-splitting:
   load-balancers:
   round-robin:
   type: ROUND_ROBIN
   data-sources:
   ds-0:
   write-data-source-name: master0
   read-data-source-names: master0slave0
   load-balancer-name: round-robin
   ds-1:
   write-data-source-name: master1
   read-data-source-names: master1slave0
   load-balancer-name: round-robin


-- 
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] 110117 commented on issue #19348: How to configure multiple data sources

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

   datasource:
   names: master0,master0slave0,master1,master1slave0
   master0:
   type: com.alibaba.druid.pool.DruidDataSource
   driver-class-name: org.postgresql.Driver
   url: jdbc:postgresql://xxx
   username: postgres
   password: postgres
   master0slave0:
   type: com.alibaba.druid.pool.DruidDataSource
   driver-class-name: org.postgresql.Driver
   url: jdbc:postgresql://xxxx
   username: postgres
   password: postgres
   master1:
   type: com.alibaba.druid.pool.DruidDataSource
   driver-class-name: org.postgresql.Driver
   url: jdbc:postgresql://xxx
   username: postgres
   password: postgres
   master1slave0:
   type: com.alibaba.druid.pool.DruidDataSource
   driver-class-name: org.postgresql.Driver
   url: jdbc:postgresql://xxx
   username: postgres
   password: postgres
   #
   props:
   sql-show: true
   rules:
   readwrite-splitting:
   load-balancers:
   round-robin:
   type: ROUND_ROBIN
   data-sources:
   ds-0:
   write-data-source-name: master0
   read-data-source-names: master0slave0
   load-balancer-name: round-robin
   ds-1:
   write-data-source-name: master1
   read-data-source-names: master1slave0
   load-balancer-name: round-robin


-- 
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] 110117 commented on issue #19348: How to configure multiple data sources

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

     datasource:
         names: master0,master0slave0,master1,master1slave0
         master0:
           type: com.alibaba.druid.pool.DruidDataSource
           driver-class-name: org.postgresql.Driver
           url: jdbc:postgresql://xxx
           username: xx
           password: xx
           #durid连接池的属性
           initial-size: 10
           max-active: 100
           min-idle: 5
           max-wait: 30000
           validation-query: select 0
           time-between-eviction-runs-millis: 60000
           min-evictableIdle-time-millis: 1800000
           pool-prepared-statements: true
           max-pool-prepared-statement-per-connection-size: 100
           test-on-borrow: false
           test-on-return: false
           test-while-idle: true
         master0slave0:
           type: com.alibaba.druid.pool.DruidDataSource
           driver-class-name: org.postgresql.Driver
           url: jdbc:postgresql://xx
           username: postgres
           password: postgres
      rules:
         readwrite-splitting:
           load-balancers:
             round-robin:
               type: ROUND_ROBIN
           data-sources:
             ds-0:
               write-data-source-name: master0   **this is master Libaray**
               read-data-source-names: master0slave0  **this is slave Libaray**
               load-balancer-name: round-robin
             ds-1:
               write-data-source-name: master1  **this is master Libaray**
               read-data-source-names: master1slave0  **this is slave Libaray**
               load-balancer-name: round-robin


-- 
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] linghengqian commented on issue #19348: How to configure multiple data sources

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

   - This is not the normal error reporting and processing logic, and you are not providing enough information. 
   
   - Providing a `docker-compose.yml` involving your related middleware, and a minimally reproducible amplifier containing the corresponding unit tests, will help others understand what's going on.


-- 
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] terrymanu commented on issue #19348: How to configure multiple data sources

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

   > write-data-source-name is master library read-data-source-names is slave library
   What is `slave library` ...?
   


-- 
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] 110117 commented on issue #19348: How to configure multiple data sources

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

   How to obtain the data source of the main database? When I use other middleware, I need to do some data processing on the data source of the main database


-- 
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] 110117 commented on issue #19348: How to configure multiple data sources

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

   main database is Master library and slave database is slave Library, Read write separation,How to obtain the data source of the master library? When I use other middleware, I need to do some data processing on the data source of the master library。I don't know. Can you understand this description


-- 
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] 110117 commented on issue #19348: How to configure multiple data sources

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

   >   datasource:
         names: master0,master0slave0,master1,master1slave0
         master0:
           type: com.alibaba.druid.pool.DruidDataSource
           driver-class-name: org.postgresql.Driver
           url: jdbc:postgresql://xxx
           username: postgres
           password: postgres
           #durid连接池的属性
           initial-size: 10
           max-active: 100
           min-idle: 5
           max-wait: 30000
           validation-query: select 0
           time-between-eviction-runs-millis: 60000
           min-evictableIdle-time-millis: 1800000
           pool-prepared-statements: true
           max-pool-prepared-statement-per-connection-size: 100
           test-on-borrow: false
           test-on-return: false
           test-while-idle: true
         master0slave0:
           type: com.alibaba.druid.pool.DruidDataSource
           driver-class-name: org.postgresql.Driver
           url: jdbc:postgresql://xxxx
           username: postgres
           password: postgres
           #省略durid连接池的属性
         master1:
           type: com.alibaba.druid.pool.DruidDataSource
           driver-class-name: org.postgresql.Driver
           url: jdbc:postgresql://xxx
           username: postgres
           password: postgres
           #省略durid连接池的属性
         master1slave0:
           type: com.alibaba.druid.pool.DruidDataSource
           driver-class-name: org.postgresql.Driver
           url: jdbc:postgresql://xxx
           username: postgres
           password: postgres
           #省略durid连接池的属性
       # 在日志中打印 SQ
       props:
         sql-show: true
       rules:
         readwrite-splitting:
           load-balancers:
             round-robin:
               type: ROUND_ROBIN
           data-sources:
             ds-0:
               write-data-source-name: master0
               read-data-source-names: master0slave0
               load-balancer-name: round-robin
             ds-1:
               write-data-source-name: master1
               read-data-source-names: master1slave0
               load-balancer-name: round-robin


-- 
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] 110117 commented on issue #19348: How to configure multiple data sources

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

   `2022-07-21 09:46:44.940  INFO [appName=scm-coordination,traceId=,spanId=] org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'redisson' of type [org.redisson.Redisson] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
   2022-07-21 09:46:44.974  INFO [appName=scm-coordination,traceId=,spanId=] org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'simpleLockAdvisor' of type [org.springframework.aop.support.DefaultPointcutAdvisor] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
   2022-07-21 09:46:44.979  INFO [appName=scm-coordination,traceId=,spanId=] org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'readLockAdvisor' of type [org.springframework.aop.support.DefaultPointcutAdvisor] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
   2022-07-21 09:46:44.981  INFO [appName=scm-coordination,traceId=,spanId=] org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'writeLockAdvisor' of type [org.springframework.aop.support.DefaultPointcutAdvisor] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
   2022-07-21 09:46:44.987  INFO [appName=scm-coordination,traceId=,spanId=] org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'multiLockAdvisor' of type [org.springframework.aop.support.DefaultPointcutAdvisor] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
   2022-07-21 09:46:44.988  INFO [appName=scm-coordination,traceId=,spanId=] org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'com.ssss.kkkk.shardingjdbc.common.TransactionConfiguration' of type [com.ssss.kkkk.shardingjdbc.common.TransactionConfiguration] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
   2022-07-21 09:46:45.024  INFO [appName=scm-coordination,traceId=,spanId=] org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'spring.shardingsphere.rules-org.apache.shardingsphere.readwritesplitting.spring.boot.rule.YamlReadwriteSplittingRuleSpringBootConfiguration' of type [org.apache.shardingsphere.readwritesplitting.spring.boot.rule.YamlReadwriteSplittingRuleSpringBootConfiguration] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
   2022-07-21 09:46:45.028  INFO [appName=scm-coordination,traceId=,spanId=] org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.apache.shardingsphere.readwritesplitting.spring.boot.ReadwriteSplittingRuleSpringbootConfiguration' of type [org.apache.shardingsphere.readwritesplitting.spring.boot.ReadwriteSplittingRuleSpringbootConfiguration$$EnhancerBySpringCGLIB$$deb73766] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
   2022-07-21 09:46:45.049  INFO [appName=scm-coordination,traceId=,spanId=] org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'round-robin' of type [org.apache.shardingsphere.readwritesplitting.algorithm.RoundRobinReplicaLoadBalanceAlgorithm] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
   2022-07-21 09:46:45.053  INFO [appName=scm-coordination,traceId=,spanId=] org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'readWriteSplittingRuleConfiguration' of type [org.apache.shardingsphere.readwritesplitting.algorithm.config.AlgorithmProvidedReadwriteSplittingRuleConfiguration] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
   2022-07-21 09:46:45.092  INFO [appName=scm-coordination,traceId=,spanId=] org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'spring.shardingsphere.rules-org.apache.shardingsphere.sharding.spring.boot.rule.YamlShardingRuleSpringBootConfiguration' of type [org.apache.shardingsphere.sharding.spring.boot.rule.YamlShardingRuleSpringBootConfiguration] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
   2022-07-21 09:46:45.098  INFO [appName=scm-coordination,traceId=,spanId=] org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.apache.shardingsphere.sharding.spring.boot.ShardingRuleSpringBootConfiguration' of type [org.apache.shardingsphere.sharding.spring.boot.ShardingRuleSpringBootConfiguration$$EnhancerBySpringCGLIB$$c137b706] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
   2022-07-21 09:46:45.115  INFO [appName=scm-coordination,traceId=,spanId=] org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'chain-bill-state-log-inline' of type [org.apache.shardingsphere.sharding.algorithm.sharding.inline.InlineShardingAlgorithm] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
   2022-07-21 09:46:45.125  INFO [appName=scm-coordination,traceId=,spanId=] org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'database-inline' of type [org.apache.shardingsphere.sharding.algorithm.sharding.inline.InlineShardingAlgorithm] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
   2022-07-21 09:46:45.126  INFO [appName=scm-coordination,traceId=,spanId=] org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'chain-total-costs-inline' of type [org.apache.shardingsphere.sharding.algorithm.sharding.inline.InlineShardingAlgorithm] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
   2022-07-21 09:46:45.127  INFO [appName=scm-coordination,traceId=,spanId=] org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'chain-cost-log-inline' of type [org.apache.shardingsphere.sharding.algorithm.sharding.inline.InlineShardingAlgorithm] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
   2022-07-21 09:46:45.128  INFO [appName=scm-coordination,traceId=,spanId=] org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'chain-bill-inline' of type [org.apache.shardingsphere.sharding.algorithm.sharding.inline.InlineShardingAlgorithm] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
   2022-07-21 09:46:45.128  INFO [appName=scm-coordination,traceId=,spanId=] org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'chain-cost-factory-inline' of type [org.apache.shardingsphere.sharding.algorithm.sharding.inline.InlineShardingAlgorithm] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
   2022-07-21 09:46:45.142  INFO [appName=scm-coordination,traceId=,spanId=] org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'snowflake' of type [org.apache.shardingsphere.sharding.algorithm.keygen.SnowflakeKeyGenerateAlgorithm] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
   2022-07-21 09:46:45.148  INFO [appName=scm-coordination,traceId=,spanId=] org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'shardingRuleConfiguration' of type [org.apache.shardingsphere.sharding.algorithm.config.AlgorithmProvidedShardingRuleConfiguration] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
   2022-07-21 09:46:45.159  INFO [appName=scm-coordination,traceId=,spanId=] org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'modeConfiguration' of type [org.apache.shardingsphere.infra.config.mode.ModeConfiguration] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
   2022-07-21 09:46:45.410  WARN [appName=scm-coordination,traceId=,spanId=] org.springframework.boot.web.servlet.context.AnnotationConfigServletWebServerApplicationContext - Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'seataBeanPostProcessor' defined in class path resource [com/alibaba/cloud/seata/feign/SeataFeignClientAutoConfiguration$FeignBeanPostProcessorConfiguration.class]: BeanPostProcessor before instantiation of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.cache.annotation.ProxyCachingConfiguration': BeanPostProcessor before instantiation of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.cache.jcache.config.ProxyJCacheConfiguration': BeanPostProcessor before instan
 tiation of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration': BeanPostProcessor before instantiation of bean failed; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'pointcutAdvisor' defined in class path resource [com/sjky/king/shardingjdbc/common/TransactionConfiguration.class]: Unsatisfied dependency expressed through method 'pointcutAdvisor' parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'txInterceptor' defined in class path resource [com/sjky/king/shardingjdbc/common/TransactionConfiguration.class]: Unsatisfied dependency expressed through method 'txInterceptor' parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean
  with name 'txManager' defined in class path resource [com/sjky/king/shardingjdbc/common/TransactionConfiguration.class]: Unsatisfied dependency expressed through method 'txManager' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'shardingSphereDataSource' defined in class path resource [org/apache/shardingsphere/spring/boot/ShardingSphereAutoConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [javax.sql.DataSource]: Factory method 'shardingSphereDataSource' threw exception; nested exception is java.lang.NoSuchMethodException: org.apache.shardingsphere.driver.jdbc.core.datasource.ShardingSphereDataSource.<init>()
   2022-07-21 09:46:45.475  INFO [appName=scm-coordination,traceId=,spanId=] org.springframework.boot.autoconfigure.logging.ConditionEvaluationReportLoggingListener - 
   
   Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
   2022-07-21 09:46:45.546 ERROR [appName=scm-coordination,traceId=,spanId=] org.springframework.boot.SpringApplication - Application run failed
   org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'seataBeanPostProcessor' defined in class path resource [com/alibaba/cloud/seata/feign/SeataFeignClientAutoConfiguration$FeignBeanPostProcessorConfiguration.class]: BeanPostProcessor before instantiation of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.cache.annotation.ProxyCachingConfiguration': BeanPostProcessor before instantiation of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.cache.jcache.config.ProxyJCacheConfiguration': BeanPostProcessor before instantiation of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration': BeanPostProcessor before instantiatio
 n of bean failed; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'pointcutAdvisor' defined in class path resource [com/sjky/king/shardingjdbc/common/TransactionConfiguration.class]: Unsatisfied dependency expressed through method 'pointcutAdvisor' parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'txInterceptor' defined in class path resource [com/sjky/king/shardingjdbc/common/TransactionConfiguration.class]: Unsatisfied dependency expressed through method 'txInterceptor' parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'txManager' defined in class path resource [com/sjky/king/shardingjdbc/common/TransactionConfiguration.class]: Unsatisfied dependency expressed through method 'txManager' parameter 0; nested exception is org.springframework.beans.factory.BeanC
 reationException: Error creating bean with name 'shardingSphereDataSource' defined in class path resource [org/apache/shardingsphere/spring/boot/ShardingSphereAutoConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [javax.sql.DataSource]: Factory method 'shardingSphereDataSource' threw exception; nested exception is java.lang.NoSuchMethodException: org.apache.shardingsphere.driver.jdbc.core.datasource.ShardingSphereDataSource.<init>()
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:537)
       at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)
       at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
       at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333)
       at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:213)
       at org.springframework.context.support.PostProcessorRegistrationDelegate.registerBeanPostProcessors(PostProcessorRegistrationDelegate.java:270)
       at org.springframework.context.support.AbstractApplicationContext.registerBeanPostProcessors(AbstractApplicationContext.java:762)
       at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:567)
       at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:145)
       at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:732)
       at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:414)
       at org.springframework.boot.SpringApplication.run(SpringApplication.java:302)
       at org.springframework.boot.SpringApplication.run(SpringApplication.java:1303)
       at org.springframework.boot.SpringApplication.run(SpringApplication.java:1292)
       at com.sjky.coordination.admin.AdminApplication.main(AdminApplication.java:14)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
       at java.lang.reflect.Method.invoke(Method.java:498)
       at com.intellij.rt.execution.CommandLineWrapper.main(CommandLineWrapper.java:66)
   Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.cache.annotation.ProxyCachingConfiguration': BeanPostProcessor before instantiation of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.cache.jcache.config.ProxyJCacheConfiguration': BeanPostProcessor before instantiation of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration': BeanPostProcessor before instantiation of bean failed; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'pointcutAdvisor' defined in class path resource [com/sjky/king/shardingjdbc/common/TransactionConfiguration.class]: Unsatisfied dependency expressed through method 'pointcutAdvisor'
  parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'txInterceptor' defined in class path resource [com/sjky/king/shardingjdbc/common/TransactionConfiguration.class]: Unsatisfied dependency expressed through method 'txInterceptor' parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'txManager' defined in class path resource [com/sjky/king/shardingjdbc/common/TransactionConfiguration.class]: Unsatisfied dependency expressed through method 'txManager' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'shardingSphereDataSource' defined in class path resource [org/apache/shardingsphere/spring/boot/ShardingSphereAutoConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to i
 nstantiate [javax.sql.DataSource]: Factory method 'shardingSphereDataSource' threw exception; nested exception is java.lang.NoSuchMethodException: org.apache.shardingsphere.driver.jdbc.core.datasource.ShardingSphereDataSource.<init>()
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:537)
       at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)
       at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
       at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333)
       at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208)
       at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:410)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1352)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1195)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542)
       at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)
       at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
       at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333)
       at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:213)
       at org.springframework.aop.framework.autoproxy.BeanFactoryAdvisorRetrievalHelper.findAdvisorBeans(BeanFactoryAdvisorRetrievalHelper.java:91)
       at org.springframework.aop.framework.autoproxy.AbstractAdvisorAutoProxyCreator.findCandidateAdvisors(AbstractAdvisorAutoProxyCreator.java:111)
       at org.springframework.aop.aspectj.annotation.AnnotationAwareAspectJAutoProxyCreator.findCandidateAdvisors(AnnotationAwareAspectJAutoProxyCreator.java:92)
       at org.springframework.aop.aspectj.autoproxy.AspectJAwareAdvisorAutoProxyCreator.shouldSkip(AspectJAwareAdvisorAutoProxyCreator.java:101)
       at org.springframework.aop.framework.autoproxy.AbstractAutoProxyCreator.postProcessBeforeInstantiation(AbstractAutoProxyCreator.java:253)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInstantiation(AbstractAutowireCapableBeanFactory.java:1160)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.resolveBeforeInstantiation(AbstractAutowireCapableBeanFactory.java:1135)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:531)
       ... 19 common frames omitted
   Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.cache.jcache.config.ProxyJCacheConfiguration': BeanPostProcessor before instantiation of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration': BeanPostProcessor before instantiation of bean failed; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'pointcutAdvisor' defined in class path resource [com/sjky/king/shardingjdbc/common/TransactionConfiguration.class]: Unsatisfied dependency expressed through method 'pointcutAdvisor' parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'txInterceptor' defined in class path resource [com/sjky/king/shardingjdbc/common/TransactionConfi
 guration.class]: Unsatisfied dependency expressed through method 'txInterceptor' parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'txManager' defined in class path resource [com/sjky/king/shardingjdbc/common/TransactionConfiguration.class]: Unsatisfied dependency expressed through method 'txManager' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'shardingSphereDataSource' defined in class path resource [org/apache/shardingsphere/spring/boot/ShardingSphereAutoConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [javax.sql.DataSource]: Factory method 'shardingSphereDataSource' threw exception; nested exception is java.lang.NoSuchMethodException: org.apache.shardingsphere.driver.jdbc.core.datasource.ShardingSphereDataSource.<i
 nit>()
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:537)
       at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)
       at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
       at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333)
       at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208)
       at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:410)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1352)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1195)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542)
       at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)
       at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
       at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333)
       at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:213)
       at org.springframework.aop.framework.autoproxy.BeanFactoryAdvisorRetrievalHelper.findAdvisorBeans(BeanFactoryAdvisorRetrievalHelper.java:91)
       at org.springframework.aop.framework.autoproxy.AbstractAdvisorAutoProxyCreator.findCandidateAdvisors(AbstractAdvisorAutoProxyCreator.java:111)
       at org.springframework.aop.aspectj.annotation.AnnotationAwareAspectJAutoProxyCreator.findCandidateAdvisors(AnnotationAwareAspectJAutoProxyCreator.java:92)
       at org.springframework.aop.aspectj.autoproxy.AspectJAwareAdvisorAutoProxyCreator.shouldSkip(AspectJAwareAdvisorAutoProxyCreator.java:101)
       at org.springframework.aop.framework.autoproxy.AbstractAutoProxyCreator.postProcessBeforeInstantiation(AbstractAutoProxyCreator.java:253)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInstantiation(AbstractAutowireCapableBeanFactory.java:1160)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.resolveBeforeInstantiation(AbstractAutowireCapableBeanFactory.java:1135)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:531)
       ... 40 common frames omitted
   Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration': BeanPostProcessor before instantiation of bean failed; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'pointcutAdvisor' defined in class path resource [com/sjky/king/shardingjdbc/common/TransactionConfiguration.class]: Unsatisfied dependency expressed through method 'pointcutAdvisor' parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'txInterceptor' defined in class path resource [com/sjky/king/shardingjdbc/common/TransactionConfiguration.class]: Unsatisfied dependency expressed through method 'txInterceptor' parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'txManager' defined 
 in class path resource [com/sjky/king/shardingjdbc/common/TransactionConfiguration.class]: Unsatisfied dependency expressed through method 'txManager' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'shardingSphereDataSource' defined in class path resource [org/apache/shardingsphere/spring/boot/ShardingSphereAutoConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [javax.sql.DataSource]: Factory method 'shardingSphereDataSource' threw exception; nested exception is java.lang.NoSuchMethodException: org.apache.shardingsphere.driver.jdbc.core.datasource.ShardingSphereDataSource.<init>()
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:537)
       at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)
       at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
       at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333)
       at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208)
       at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:410)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1352)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1195)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542)
       at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)
       at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
       at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333)
       at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:213)
       at org.springframework.aop.framework.autoproxy.BeanFactoryAdvisorRetrievalHelper.findAdvisorBeans(BeanFactoryAdvisorRetrievalHelper.java:91)
       at org.springframework.aop.framework.autoproxy.AbstractAdvisorAutoProxyCreator.findCandidateAdvisors(AbstractAdvisorAutoProxyCreator.java:111)
       at org.springframework.aop.aspectj.annotation.AnnotationAwareAspectJAutoProxyCreator.findCandidateAdvisors(AnnotationAwareAspectJAutoProxyCreator.java:92)
       at org.springframework.aop.aspectj.autoproxy.AspectJAwareAdvisorAutoProxyCreator.shouldSkip(AspectJAwareAdvisorAutoProxyCreator.java:101)
       at org.springframework.aop.framework.autoproxy.AbstractAutoProxyCreator.postProcessBeforeInstantiation(AbstractAutoProxyCreator.java:253)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInstantiation(AbstractAutowireCapableBeanFactory.java:1160)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.resolveBeforeInstantiation(AbstractAutowireCapableBeanFactory.java:1135)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:531)
       ... 61 common frames omitted
   Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'pointcutAdvisor' defined in class path resource [com/sjky/king/shardingjdbc/common/TransactionConfiguration.class]: Unsatisfied dependency expressed through method 'pointcutAdvisor' parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'txInterceptor' defined in class path resource [com/sjky/king/shardingjdbc/common/TransactionConfiguration.class]: Unsatisfied dependency expressed through method 'txInterceptor' parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'txManager' defined in class path resource [com/sjky/king/shardingjdbc/common/TransactionConfiguration.class]: Unsatisfied dependency expressed through method 'txManager' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error c
 reating bean with name 'shardingSphereDataSource' defined in class path resource [org/apache/shardingsphere/spring/boot/ShardingSphereAutoConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [javax.sql.DataSource]: Factory method 'shardingSphereDataSource' threw exception; nested exception is java.lang.NoSuchMethodException: org.apache.shardingsphere.driver.jdbc.core.datasource.ShardingSphereDataSource.<init>()
       at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:800)
       at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:541)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1352)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1195)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542)
       at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)
       at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
       at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333)
       at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:213)
       at org.springframework.aop.framework.autoproxy.BeanFactoryAdvisorRetrievalHelper.findAdvisorBeans(BeanFactoryAdvisorRetrievalHelper.java:91)
       at org.springframework.aop.framework.autoproxy.AbstractAdvisorAutoProxyCreator.findCandidateAdvisors(AbstractAdvisorAutoProxyCreator.java:111)
       at org.springframework.aop.aspectj.annotation.AnnotationAwareAspectJAutoProxyCreator.findCandidateAdvisors(AnnotationAwareAspectJAutoProxyCreator.java:92)
       at org.springframework.aop.aspectj.autoproxy.AspectJAwareAdvisorAutoProxyCreator.shouldSkip(AspectJAwareAdvisorAutoProxyCreator.java:101)
       at org.springframework.aop.framework.autoproxy.AbstractAutoProxyCreator.postProcessBeforeInstantiation(AbstractAutoProxyCreator.java:253)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInstantiation(AbstractAutowireCapableBeanFactory.java:1160)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.resolveBeforeInstantiation(AbstractAutowireCapableBeanFactory.java:1135)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:531)
       ... 82 common frames omitted
   Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'txInterceptor' defined in class path resource [com/sjky/king/shardingjdbc/common/TransactionConfiguration.class]: Unsatisfied dependency expressed through method 'txInterceptor' parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'txManager' defined in class path resource [com/sjky/king/shardingjdbc/common/TransactionConfiguration.class]: Unsatisfied dependency expressed through method 'txManager' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'shardingSphereDataSource' defined in class path resource [org/apache/shardingsphere/spring/boot/ShardingSphereAutoConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [javax.sql
 .DataSource]: Factory method 'shardingSphereDataSource' threw exception; nested exception is java.lang.NoSuchMethodException: org.apache.shardingsphere.driver.jdbc.core.datasource.ShardingSphereDataSource.<init>()
       at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:800)
       at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:541)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1352)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1195)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542)
       at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)
       at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
       at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333)
       at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208)
       at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276)
       at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1389)
       at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1309)
       at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:887)
       at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:791)
       ... 99 common frames omitted
   Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'txManager' defined in class path resource [com/sjky/king/shardingjdbc/common/TransactionConfiguration.class]: Unsatisfied dependency expressed through method 'txManager' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'shardingSphereDataSource' defined in class path resource [org/apache/shardingsphere/spring/boot/ShardingSphereAutoConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [javax.sql.DataSource]: Factory method 'shardingSphereDataSource' threw exception; nested exception is java.lang.NoSuchMethodException: org.apache.shardingsphere.driver.jdbc.core.datasource.ShardingSphereDataSource.<init>()
       at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:800)
       at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:541)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1352)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1195)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542)
       at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)
       at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
       at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333)
       at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208)
       at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276)
       at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1389)
       at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1309)
       at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:887)
       at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:791)
       ... 113 common frames omitted
   Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'shardingSphereDataSource' defined in class path resource [org/apache/shardingsphere/spring/boot/ShardingSphereAutoConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [javax.sql.DataSource]: Factory method 'shardingSphereDataSource' threw exception; nested exception is java.lang.NoSuchMethodException: org.apache.shardingsphere.driver.jdbc.core.datasource.ShardingSphereDataSource.<init>()
       at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:658)
       at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:638)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1352)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1195)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542)
       at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)
       at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
       at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333)
       at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208)
       at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276)
       at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1389)
       at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1309)
       at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:887)
       at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:791)
       ... 127 common frames omitted
   Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [javax.sql.DataSource]: Factory method 'shardingSphereDataSource' threw exception; nested exception is java.lang.NoSuchMethodException: org.apache.shardingsphere.driver.jdbc.core.datasource.ShardingSphereDataSource.<init>()
       at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:185)
       at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:653)
       ... 141 common frames omitted
   Caused by: java.lang.NoSuchMethodException: org.apache.shardingsphere.driver.jdbc.core.datasource.ShardingSphereDataSource.<init>()
       at java.lang.Class.getConstructor0(Class.java:3082)
       at java.lang.Class.getConstructor(Class.java:1825)
       at org.apache.shardingsphere.infra.config.datasource.creator.impl.AbstractDataSourceCreator.buildDataSource(AbstractDataSourceCreator.java:58)
       at org.apache.shardingsphere.infra.config.datasource.creator.impl.DefaultDataSourceCreator.createDataSource(DefaultDataSourceCreator.java:38)
       at org.apache.shardingsphere.infra.config.datasource.DataSourceConverter.getDataSource(DataSourceConverter.java:48)
       at org.apache.shardingsphere.infra.config.datasource.DataSourceConverter.lambda$getDataSourceMap$0(DataSourceConverter.java:68)
       at java.util.stream.Collectors.lambda$toMap$58(Collectors.java:1321)
       at java.util.stream.ReduceOps$3ReducingSink.accept(ReduceOps.java:169)
       at java.util.Iterator.forEachRemaining(Iterator.java:116)
       at java.util.Spliterators$IteratorSpliterator.forEachRemaining(Spliterators.java:1801)
       at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:481)
       at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:471)
       at java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:708)
       at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
       at java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:499)
       at org.apache.shardingsphere.infra.config.datasource.DataSourceConverter.getDataSourceMap(DataSourceConverter.java:68)
       at org.apache.shardingsphere.mode.manager.standalone.StandaloneContextManagerBuilder.getChangedDataSources(StandaloneContextManagerBuilder.java:167)
       at org.apache.shardingsphere.mode.manager.standalone.StandaloneContextManagerBuilder.loadDataSourcesMap(StandaloneContextManagerBuilder.java:120)
       at org.apache.shardingsphere.mode.manager.standalone.StandaloneContextManagerBuilder.build(StandaloneContextManagerBuilder.java:73)
       at org.apache.shardingsphere.driver.jdbc.core.datasource.ShardingSphereDataSource.createContextManager(ShardingSphereDataSource.java:75)
       at org.apache.shardingsphere.driver.jdbc.core.datasource.ShardingSphereDataSource.<init>(ShardingSphereDataSource.java:61)
       at org.apache.shardingsphere.driver.api.ShardingSphereDataSourceFactory.createDataSource(ShardingSphereDataSourceFactory.java:79)
       at org.apache.shardingsphere.spring.boot.ShardingSphereAutoConfiguration.shardingSphereDataSource(ShardingSphereAutoConfiguration.java:93)
       at org.apache.shardingsphere.spring.boot.ShardingSphereAutoConfiguration$$EnhancerBySpringCGLIB$$8b5aeaa1.CGLIB$shardingSphereDataSource$1(<generated>)
       at org.apache.shardingsphere.spring.boot.ShardingSphereAutoConfiguration$$EnhancerBySpringCGLIB$$8b5aeaa1$$FastClassBySpringCGLIB$$b5565787.invoke(<generated>)
       at org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:244)
       at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:331)
       at org.apache.shardingsphere.spring.boot.ShardingSphereAutoConfiguration$$EnhancerBySpringCGLIB$$8b5aeaa1.shardingSphereDataSource(<generated>)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
       at java.lang.reflect.Method.invoke(Method.java:498)
       at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:154)
       ... 142 common frames omitted
   Disconnected from the target VM, address: '127.0.0.1:58606', transport: 'socket'
   
   Process finished with exit code 1`  
   
   Another question:
   This error will be reported every time the configuration file has not been changed. Just put the configuration file on Nacos with the same code


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