breezeLoganGithub opened a new issue #15979:
URL: https://github.com/apache/shardingsphere/issues/15979
myconfig is :
server:
# 服务器的HTTP端口，默认为80
port: 8080
# Spring配置
spring:
shardingsphere:
# 数据源配置
datasource:
# 数据源名称，多数据源以逗号分隔
names: db0,db1 #
db0:
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: com.mysql.cj.jdbc.Driver
url:
jdbc:mysql://192.168.18.128:3307/shardingsphere?characterEncoding=utf8&useSSL=false&serverTimezone=Asia/Shanghai
username: root
password: 123456
db1:
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: com.mysql.cj.jdbc.Driver
url:
jdbc:mysql://192.168.18.128:3308/shardingsphere?characterEncoding=utf8&useSSL=false&serverTimezone=Asia/Shanghai
username: root
password: 123456
# 规则配置
rules:
replica-query:
data-sources:
shardingsphere:
primary-data-source-name: db0
replica-data-source-names: db1
load-balancer-name: msdb
load-balancers:
round-robin:
type: ROUND_ROBIN
props:
default: 0
sharding:
tables:
# 逻辑表名称
t_order:
# 行表达式标识符可以使用 ${...} 或 $->{...}，但前者与 Spring 本身的属性文件占位符冲突，因此在
Spring 环境中使用行表达式标识符建议使用 $->{...}
actual-data-nodes: msdb.t_order$->{def lst=[];for (int
i=0;i<100;i++){if(i==0){lst.add('')}else{lst.add('_'+i)}};lst}
# 分表策略
table-strategy:
standard:
# 分片列名称
sharding-column: sharding_id
# 分片算法名称
sharding-algorithm-name: table-inline
# 分片算法配置
sharding-algorithms:
table-inline:
# 分片算法类型
type: INLINE
props:
# 分片算法的行表达式
algorithm-expression:
t_order$->{if(sharding_id==0){''}else{'_'+sharding_id}}
# 分布式序列算法配置
key-generators:
snowflake:
# 分布式序列算法（雪花算法：SNOWFLAKE； UUID：UUID）
type: SNOWFLAKE
# 分布式序列算法属性配置
props:
# 工作机器唯一标识
worker-id: 123
props:
# 展示修改以后的sql语句
sql-show: true
I use the v5.0.0
when I start App,I get the error
"C:\Program Files\Java\jdk1.8.0_271\bin\java.exe" -XX:TieredStopAtLevel=1
-noverify -Dspring.output.ansi.enabled=always -Dcom.sun.management.jmxremote
-Dspring.jmx.enabled=true -Dspring.liveBeansView.mbeanDomain
-Dspring.application.admin.enabled=true "-javaagent:C:\Program
Files\JetBrains\IntelliJ IDEA 2020.2.3\lib\idea_rt.jar=52133:C:\Program
Files\JetBrains\IntelliJ IDEA 2020.2.3\bin" -Dfile.encoding=UTF-8 -classpath
"C:\Program Files\Java\jdk1.8.0_271\jre\lib\charsets.jar;C:\Program
Files\Java\jdk1.8.0_271\jre\lib\deploy.jar;C:\Program
Files\Java\jdk1.8.0_271\jre\lib\ext\access-bridge-64.jar;C:\Program
Files\Java\jdk1.8.0_271\jre\lib\ext\cldrdata.jar;C:\Program
Files\Java\jdk1.8.0_271\jre\lib\ext\dnsns.jar;C:\Program
Files\Java\jdk1.8.0_271\jre\lib\ext\jaccess.jar;C:\Program
Files\Java\jdk1.8.0_271\jre\lib\ext\jfxrt.jar;C:\Program
Files\Java\jdk1.8.0_271\jre\lib\ext\localedata.jar;C:\Program
Files\Java\jdk1.8.0_271\jre\lib\ext\nashorn.jar;C:\Program
Files\Java\jdk1.8.0_271\jre
\lib\ext\sunec.jar;C:\Program
Files\Java\jdk1.8.0_271\jre\lib\ext\sunjce_provider.jar;C:\Program
Files\Java\jdk1.8.0_271\jre\lib\ext\sunmscapi.jar;C:\Program
Files\Java\jdk1.8.0_271\jre\lib\ext\sunpkcs11.jar;C:\Program
Files\Java\jdk1.8.0_271\jre\lib\ext\zipfs.jar;C:\Program
Files\Java\jdk1.8.0_271\jre\lib\javaws.jar;C:\Program
Files\Java\jdk1.8.0_271\jre\lib\jce.jar;C:\Program
Files\Java\jdk1.8.0_271\jre\lib\jfr.jar;C:\Program
Files\Java\jdk1.8.0_271\jre\lib\jfxswt.jar;C:\Program
Files\Java\jdk1.8.0_271\jre\lib\jsse.jar;C:\Program
Files\Java\jdk1.8.0_271\jre\lib\management-agent.jar;C:\Program
Files\Java\jdk1.8.0_271\jre\lib\plugin.jar;C:\Program
Files\Java\jdk1.8.0_271\jre\lib\resources.jar;C:\Program
Files\Java\jdk1.8.0_271\jre\lib\rt.jar;C:\mywork\DistributedArchitecture\shardingsphere\target\classes;C:\soft\apache-maven-3.6.3\repository\org\springframework\boot\spring-boot-starter-web\2.4.5\spring-boot-starter-web-2.4.5.jar;C:\soft\apache-maven-3.6.3\repository\org\springframew
ork\boot\spring-boot-starter\2.4.5\spring-boot-starter-2.4.5.jar;C:\soft\apache-maven-3.6.3\repository\org\springframework\boot\spring-boot\2.4.5\spring-boot-2.4.5.jar;C:\soft\apache-maven-3.6.3\repository\org\springframework\boot\spring-boot-autoconfigure\2.4.5\spring-boot-autoconfigure-2.4.5.jar;C:\soft\apache-maven-3.6.3\repository\org\springframework\boot\spring-boot-starter-logging\2.4.5\spring-boot-starter-logging-2.4.5.jar;C:\soft\apache-maven-3.6.3\repository\ch\qos\logback\logback-classic\1.2.3\logback-classic-1.2.3.jar;C:\soft\apache-maven-3.6.3\repository\ch\qos\logback\logback-core\1.2.3\logback-core-1.2.3.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\logging\log4j\log4j-to-slf4j\2.13.3\log4j-to-slf4j-2.13.3.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\logging\log4j\log4j-api\2.13.3\log4j-api-2.13.3.jar;C:\soft\apache-maven-3.6.3\repository\org\slf4j\jul-to-slf4j\1.7.30\jul-to-slf4j-1.7.30.jar;C:\soft\apache-maven-3.6.3\repository\jakarta\annotation\jakart
a.annotation-api\1.3.5\jakarta.annotation-api-1.3.5.jar;C:\soft\apache-maven-3.6.3\repository\org\yaml\snakeyaml\1.27\snakeyaml-1.27.jar;C:\soft\apache-maven-3.6.3\repository\org\springframework\boot\spring-boot-starter-json\2.4.5\spring-boot-starter-json-2.4.5.jar;C:\soft\apache-maven-3.6.3\repository\com\fasterxml\jackson\core\jackson-databind\2.11.4\jackson-databind-2.11.4.jar;C:\soft\apache-maven-3.6.3\repository\com\fasterxml\jackson\core\jackson-annotations\2.11.4\jackson-annotations-2.11.4.jar;C:\soft\apache-maven-3.6.3\repository\com\fasterxml\jackson\core\jackson-core\2.11.4\jackson-core-2.11.4.jar;C:\soft\apache-maven-3.6.3\repository\com\fasterxml\jackson\datatype\jackson-datatype-jdk8\2.11.4\jackson-datatype-jdk8-2.11.4.jar;C:\soft\apache-maven-3.6.3\repository\com\fasterxml\jackson\datatype\jackson-datatype-jsr310\2.11.4\jackson-datatype-jsr310-2.11.4.jar;C:\soft\apache-maven-3.6.3\repository\com\fasterxml\jackson\module\jackson-module-parameter-names\2.11.4\jackson-mod
ule-parameter-names-2.11.4.jar;C:\soft\apache-maven-3.6.3\repository\org\springframework\boot\spring-boot-starter-tomcat\2.4.5\spring-boot-starter-tomcat-2.4.5.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\tomcat\embed\tomcat-embed-core\9.0.45\tomcat-embed-core-9.0.45.jar;C:\soft\apache-maven-3.6.3\repository\org\glassfish\jakarta.el\3.0.3\jakarta.el-3.0.3.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\tomcat\embed\tomcat-embed-websocket\9.0.45\tomcat-embed-websocket-9.0.45.jar;C:\soft\apache-maven-3.6.3\repository\org\springframework\spring-web\5.3.6\spring-web-5.3.6.jar;C:\soft\apache-maven-3.6.3\repository\org\springframework\spring-beans\5.3.6\spring-beans-5.3.6.jar;C:\soft\apache-maven-3.6.3\repository\org\springframework\spring-webmvc\5.3.6\spring-webmvc-5.3.6.jar;C:\soft\apache-maven-3.6.3\repository\org\springframework\spring-aop\5.3.6\spring-aop-5.3.6.jar;C:\soft\apache-maven-3.6.3\repository\org\springframework\spring-context\5.3.6\spring-context-5.3.6.jar;C:\
soft\apache-maven-3.6.3\repository\org\springframework\spring-expression\5.3.6\spring-expression-5.3.6.jar;C:\soft\apache-maven-3.6.3\repository\org\mybatis\spring\boot\mybatis-spring-boot-starter\2.0.1\mybatis-spring-boot-starter-2.0.1.jar;C:\soft\apache-maven-3.6.3\repository\org\springframework\boot\spring-boot-starter-jdbc\2.4.5\spring-boot-starter-jdbc-2.4.5.jar;C:\soft\apache-maven-3.6.3\repository\com\zaxxer\HikariCP\3.4.5\HikariCP-3.4.5.jar;C:\soft\apache-maven-3.6.3\repository\org\springframework\spring-jdbc\5.3.6\spring-jdbc-5.3.6.jar;C:\soft\apache-maven-3.6.3\repository\org\springframework\spring-tx\5.3.6\spring-tx-5.3.6.jar;C:\soft\apache-maven-3.6.3\repository\org\mybatis\spring\boot\mybatis-spring-boot-autoconfigure\2.0.1\mybatis-spring-boot-autoconfigure-2.0.1.jar;C:\soft\apache-maven-3.6.3\repository\org\mybatis\mybatis\3.5.1\mybatis-3.5.1.jar;C:\soft\apache-maven-3.6.3\repository\org\mybatis\mybatis-spring\2.0.1\mybatis-spring-2.0.1.jar;C:\soft\apache-maven-3.6.3\r
epository\com\alibaba\druid\1.1.22\druid-1.1.22.jar;C:\soft\apache-maven-3.6.3\repository\mysql\mysql-connector-java\8.0.23\mysql-connector-java-8.0.23.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-jdbc-core-spring-boot-starter\5.0.0\shardingsphere-jdbc-core-spring-boot-starter-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-sharding-spring-boot-starter\5.0.0\shardingsphere-sharding-spring-boot-starter-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-sharding-core\5.0.0\shardingsphere-sharding-core-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-sharding-api\5.0.0\shardingsphere-sharding-api-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-infra-common\5.0.0\shardingsphere-infra-common-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-spi\5.0.0\shar
dingsphere-spi-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-sharding-distsql-handler\5.0.0\shardingsphere-sharding-distsql-handler-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-sharding-distsql-statement\5.0.0\shardingsphere-sharding-distsql-statement-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-sharding-distsql-parser\5.0.0\shardingsphere-sharding-distsql-parser-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-sql-parser-spi\5.0.0\shardingsphere-sql-parser-spi-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-infra-binder\5.0.0\shardingsphere-infra-binder-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-infra-parser\5.0.0\shardingsphere-infra-parser-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere
-infra-route\5.0.0\shardingsphere-infra-route-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-infra-rewrite\5.0.0\shardingsphere-infra-rewrite-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-infra-merge\5.0.0\shardingsphere-infra-merge-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-system-datetime\5.0.0\shardingsphere-system-datetime-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-infra-datetime-spi\5.0.0\shardingsphere-infra-datetime-spi-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\codehaus\groovy\groovy\2.4.19\groovy-2.4.19-indy.jar;C:\soft\apache-maven-3.6.3\repository\commons-codec\commons-codec\1.15\commons-codec-1.15.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-shadow-spring-boot-starter\5.0.0\shardingsphere-shadow-spring-boot-starter-5.0.0.jar;C:\soft\apache-maven-3.6.3
\repository\org\apache\shardingsphere\shardingsphere-shadow-core\5.0.0\shardingsphere-shadow-core-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-shadow-api\5.0.0\shardingsphere-shadow-api-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-shadow-distsql-handler\5.0.0\shardingsphere-shadow-distsql-handler-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-shadow-distsql-statement\5.0.0\shardingsphere-shadow-distsql-statement-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-shadow-distsql-parser\5.0.0\shardingsphere-shadow-distsql-parser-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-encrypt-spring-boot-starter\5.0.0\shardingsphere-encrypt-spring-boot-starter-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-encrypt-core\5.0.0\shardingsphere-encrypt-
core-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-encrypt-api\5.0.0\shardingsphere-encrypt-api-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-encrypt-distsql-handler\5.0.0\shardingsphere-encrypt-distsql-handler-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-encrypt-distsql-statement\5.0.0\shardingsphere-encrypt-distsql-statement-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-encrypt-distsql-parser\5.0.0\shardingsphere-encrypt-distsql-parser-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-readwrite-splitting-spring-boot-starter\5.0.0\shardingsphere-readwrite-splitting-spring-boot-starter-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-readwrite-splitting-core\5.0.0\shardingsphere-readwrite-splitting-core-5.0.0.jar;C:\soft\apache-maven-3
.6.3\repository\org\apache\shardingsphere\shardingsphere-readwrite-splitting-api\5.0.0\shardingsphere-readwrite-splitting-api-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-readwrite-splitting-distsql-handler\5.0.0\shardingsphere-readwrite-splitting-distsql-handler-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-readwrite-splitting-distsql-statement\5.0.0\shardingsphere-readwrite-splitting-distsql-statement-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-readwrite-splitting-distsql-parser\5.0.0\shardingsphere-readwrite-splitting-distsql-parser-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-jdbc-spring-boot-starter-infra\5.0.0\shardingsphere-jdbc-spring-boot-starter-infra-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-jdbc-transaction-spring\5.0.0\shardingsphere-jdbc-transaction-
spring-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-transaction-core\5.0.0\shardingsphere-transaction-core-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-transaction-api\5.0.0\shardingsphere-transaction-api-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-infra-executor\5.0.0\shardingsphere-infra-executor-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-infra-optimize\5.0.0\shardingsphere-infra-optimize-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\calcite\calcite-core\1.27.0\calcite-core-1.27.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\calcite\calcite-linq4j\1.27.0\calcite-linq4j-1.27.0.jar;C:\soft\apache-maven-3.6.3\repository\com\esri\geometry\esri-geometry-api\2.2.0\esri-geometry-api-2.2.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\calcite\avatica\avatica-core\1.18.0\avatica-core-1.
18.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\calcite\avatica\avatica-metrics\1.18.0\avatica-metrics-1.18.0.jar;C:\soft\apache-maven-3.6.3\repository\com\google\protobuf\protobuf-java\3.6.1\protobuf-java-3.6.1.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\httpcomponents\httpclient\4.5.13\httpclient-4.5.13.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\httpcomponents\httpcore\4.4.14\httpcore-4.4.14.jar;C:\soft\apache-maven-3.6.3\repository\com\fasterxml\jackson\dataformat\jackson-dataformat-yaml\2.11.4\jackson-dataformat-yaml-2.11.4.jar;C:\soft\apache-maven-3.6.3\repository\com\google\uzaygezen\uzaygezen-core\0.2\uzaygezen-core-0.2.jar;C:\soft\apache-maven-3.6.3\repository\log4j\log4j\1.2.17\log4j-1.2.17.jar;C:\soft\apache-maven-3.6.3\repository\com\yahoo\datasketches\sketches-core\0.9.0\sketches-core-0.9.0.jar;C:\soft\apache-maven-3.6.3\repository\com\yahoo\datasketches\memory\0.9.0\memory-0.9.0.jar;C:\soft\apache-maven-3.6.3\repository\net\hydromatic\aggdes
igner-algorithm\6.0\aggdesigner-algorithm-6.0.jar;C:\soft\apache-maven-3.6.3\repository\commons-lang\commons-lang\2.4\commons-lang-2.4.jar;C:\soft\apache-maven-3.6.3\repository\commons-logging\commons-logging\1.1.3\commons-logging-1.1.3.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\commons\commons-dbcp2\2.8.0\commons-dbcp2-2.8.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\commons\commons-pool2\2.9.0\commons-pool2-2.9.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\commons\commons-lang3\3.11\commons-lang3-3.11.jar;C:\soft\apache-maven-3.6.3\repository\commons-io\commons-io\2.4\commons-io-2.4.jar;C:\soft\apache-maven-3.6.3\repository\org\codehaus\janino\commons-compiler\3.1.3\commons-compiler-3.1.3.jar;C:\soft\apache-maven-3.6.3\repository\org\codehaus\janino\janino\3.1.3\janino-3.1.3.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-jdbc-core\5.0.0\shardingsphere-jdbc-core-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apac
he\shardingsphere\shardingsphere-sql-parser-sql92\5.0.0\shardingsphere-sql-parser-sql92-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-sql-parser-engine\5.0.0\shardingsphere-sql-parser-engine-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-sql-parser-statement\5.0.0\shardingsphere-sql-parser-statement-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\commons\commons-collections4\4.2\commons-collections4-4.2.jar;C:\soft\apache-maven-3.6.3\repository\org\antlr\antlr4-runtime\4.9.2\antlr4-runtime-4.9.2.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-sql-parser-mysql\5.0.0\shardingsphere-sql-parser-mysql-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-sql-parser-postgresql\5.0.0\shardingsphere-sql-parser-postgresql-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-sql-parser-oracle\5
.0.0\shardingsphere-sql-parser-oracle-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-sql-parser-sqlserver\5.0.0\shardingsphere-sql-parser-sqlserver-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-authority-core\5.0.0\shardingsphere-authority-core-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-authority-api\5.0.0\shardingsphere-authority-api-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-single-table-core\5.0.0\shardingsphere-single-table-core-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-single-table-api\5.0.0\shardingsphere-single-table-api-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-infra-context\5.0.0\shardingsphere-infra-context-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-distsql-pars
er-engine\5.0.0\shardingsphere-distsql-parser-engine-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-distsql-parser-statement\5.0.0\shardingsphere-distsql-parser-statement-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-memory-mode-core\5.0.0\shardingsphere-memory-mode-core-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-mode-core\5.0.0\shardingsphere-mode-core-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-standalone-mode-core\5.0.0\shardingsphere-standalone-mode-core-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-standalone-mode-repository-api\5.0.0\shardingsphere-standalone-mode-repository-api-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-standalone-mode-repository-file\5.0.0\shardingsphere-standalone-mode-repository-file-5.0.0.jar;C:
\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-cluster-mode-core\5.0.0\shardingsphere-cluster-mode-core-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-cluster-mode-repository-api\5.0.0\shardingsphere-cluster-mode-repository-api-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-db-discovery-core\5.0.0\shardingsphere-db-discovery-core-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-db-discovery-api\5.0.0\shardingsphere-db-discovery-api-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-db-discovery-distsql-handler\5.0.0\shardingsphere-db-discovery-distsql-handler-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-db-discovery-distsql-statement\5.0.0\shardingsphere-db-discovery-distsql-statement-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\sharding
sphere\shardingsphere-db-discovery-distsql-parser\5.0.0\shardingsphere-db-discovery-distsql-parser-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\shardingsphere-db-discovery-mgr\5.0.0\shardingsphere-db-discovery-mgr-5.0.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\elasticjob\elasticjob-lite-core\3.0.1\elasticjob-lite-core-3.0.1.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\elasticjob\elasticjob-api\3.0.1\elasticjob-api-3.0.1.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\elasticjob\elasticjob-infra-common\3.0.1\elasticjob-infra-common-3.0.1.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\elasticjob\elasticjob-registry-center\3.0.1\elasticjob-registry-center-3.0.1.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\curator\curator-framework\5.1.0\curator-framework-5.1.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\curator\curator-client\5.1.0\curator-client-5.1.
0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\zookeeper\zookeeper\3.6.0\zookeeper-3.6.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\zookeeper\zookeeper-jute\3.6.0\zookeeper-jute-3.6.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\yetus\audience-annotations\0.5.0\audience-annotations-0.5.0.jar;C:\soft\apache-maven-3.6.3\repository\io\netty\netty-handler\4.1.63.Final\netty-handler-4.1.63.Final.jar;C:\soft\apache-maven-3.6.3\repository\io\netty\netty-common\4.1.63.Final\netty-common-4.1.63.Final.jar;C:\soft\apache-maven-3.6.3\repository\io\netty\netty-resolver\4.1.63.Final\netty-resolver-4.1.63.Final.jar;C:\soft\apache-maven-3.6.3\repository\io\netty\netty-buffer\4.1.63.Final\netty-buffer-4.1.63.Final.jar;C:\soft\apache-maven-3.6.3\repository\io\netty\netty-transport\4.1.63.Final\netty-transport-4.1.63.Final.jar;C:\soft\apache-maven-3.6.3\repository\io\netty\netty-codec\4.1.63.Final\netty-codec-4.1.63.Final.jar;C:\soft\apache-maven-3.6.3\repository\io\netty\net
ty-transport-native-epoll\4.1.63.Final\netty-transport-native-epoll-4.1.63.Final.jar;C:\soft\apache-maven-3.6.3\repository\io\netty\netty-transport-native-unix-common\4.1.63.Final\netty-transport-native-unix-common-4.1.63.Final.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\curator\curator-recipes\5.1.0\curator-recipes-5.1.0.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\elasticjob\elasticjob-simple-executor\3.0.1\elasticjob-simple-executor-3.0.1.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\elasticjob\elasticjob-executor-kernel\3.0.1\elasticjob-executor-kernel-3.0.1.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\elasticjob\elasticjob-error-handler-general\3.0.1\elasticjob-error-handler-general-3.0.1.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\elasticjob\elasticjob-error-handler-spi\3.0.1\elasticjob-error-handler-spi-3.0.1.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\
elasticjob\elasticjob-dataflow-executor\3.0.1\elasticjob-dataflow-executor-3.0.1.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\elasticjob\elasticjob-script-executor\3.0.1\elasticjob-script-executor-3.0.1.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\commons\commons-exec\1.3\commons-exec-1.3.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\elasticjob\elasticjob-http-executor\3.0.1\elasticjob-http-executor-3.0.1.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\elasticjob\elasticjob-tracing-rdb\3.0.1\elasticjob-tracing-rdb-3.0.1.jar;C:\soft\apache-maven-3.6.3\repository\org\apache\shardingsphere\elasticjob\elasticjob-tracing-api\3.0.1\elasticjob-tracing-api-3.0.1.jar;C:\soft\apache-maven-3.6.3\repository\com\google\code\gson\gson\2.8.6\gson-2.8.6.jar;C:\soft\apache-maven-3.6.3\repository\org\quartz-scheduler\quartz\2.3.2\quartz-2.3.2.jar;C:\soft\apache-maven-3.6.3\repository\com\mchange\mchange-commons-java\0.2.15\mchan
ge-commons-java-0.2.15.jar;C:\soft\apache-maven-3.6.3\repository\com\google\guava\guava\29.0-jre\guava-29.0-jre.jar;C:\soft\apache-maven-3.6.3\repository\com\google\guava\failureaccess\1.0.1\failureaccess-1.0.1.jar;C:\soft\apache-maven-3.6.3\repository\com\google\guava\listenablefuture\9999.0-empty-to-avoid-conflict-with-guava\listenablefuture-9999.0-empty-to-avoid-conflict-with-guava.jar;C:\soft\apache-maven-3.6.3\repository\com\google\code\findbugs\jsr305\3.0.2\jsr305-3.0.2.jar;C:\soft\apache-maven-3.6.3\repository\org\checkerframework\checker-qual\2.11.1\checker-qual-2.11.1.jar;C:\soft\apache-maven-3.6.3\repository\com\google\errorprone\error_prone_annotations\2.3.4\error_prone_annotations-2.3.4.jar;C:\soft\apache-maven-3.6.3\repository\org\slf4j\slf4j-api\1.7.30\slf4j-api-1.7.30.jar;C:\soft\apache-maven-3.6.3\repository\org\slf4j\jcl-over-slf4j\1.7.30\jcl-over-slf4j-1.7.30.jar;C:\soft\apache-maven-3.6.3\repository\javax\xml\bind\jaxb-api\2.3.1\jaxb-api-2.3.1.jar;C:\soft\apache-m
aven-3.6.3\repository\com\sun\xml\bind\jaxb-core\2.3.0\jaxb-core-2.3.0.jar;C:\soft\apache-maven-3.6.3\repository\com\sun\xml\bind\jaxb-impl\2.3.0\jaxb-impl-2.3.0.jar;C:\soft\apache-maven-3.6.3\repository\javax\annotation\javax.annotation-api\1.3.2\javax.annotation-api-1.3.2.jar;C:\soft\apache-maven-3.6.3\repository\javax\activation\javax.activation-api\1.2.0\javax.activation-api-1.2.0.jar;C:\soft\apache-maven-3.6.3\repository\com\jayway\jsonpath\json-path\2.4.0\json-path-2.4.0.jar;C:\soft\apache-maven-3.6.3\repository\net\minidev\json-smart\2.3\json-smart-2.3.jar;C:\soft\apache-maven-3.6.3\repository\net\minidev\accessors-smart\1.2\accessors-smart-1.2.jar;C:\soft\apache-maven-3.6.3\repository\org\ow2\asm\asm\5.0.4\asm-5.0.4.jar;C:\soft\apache-maven-3.6.3\repository\org\apiguardian\apiguardian-api\1.1.0\apiguardian-api-1.1.0.jar;C:\soft\apache-maven-3.6.3\repository\org\springframework\spring-core\5.3.6\spring-core-5.3.6.jar;C:\soft\apache-maven-3.6.3\repository\org\springframework\s
pring-jcl\5.3.6\spring-jcl-5.3.6.jar" com.logan.App
. ____ _ __ _ _
/\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
\\/ ___)| |_)| | | | | || (_| | ) ) ) )
' |____| .__|_| |_|_| |_\__, | / / / /
=========|_|==============|___/=/_/_/_/
:: Spring Boot :: (v2.4.5)
2022-03-10 20:26:14.036 INFO 3260 --- [ main] com.logan.App
: Starting App using Java 1.8.0_271 on LoganBook with PID
3260 (C:\mywork\DistributedArchitecture\shardingsphere\target\classes started
by Logan in C:\mywork\DistributedArchitecture\shardingsphere)
2022-03-10 20:26:14.038 INFO 3260 --- [ main] com.logan.App
: No active profile set, falling back to default profiles:
default
2022-03-10 20:26:14.711 INFO 3260 --- [ main]
trationDelegate$BeanPostProcessorChecker : Bean
'stringToNoneShardingStrategyConfigurationConverter' of type
[org.apache.shardingsphere.spring.boot.converter.StringToNoneShardingStrategyConfigurationConverter]
is not eligible for getting processed by all BeanPostProcessors (for example:
not eligible for auto-proxying)
2022-03-10 20:26:14.715 INFO 3260 --- [ main]
trationDelegate$BeanPostProcessorChecker : Bean
'spring.shardingsphere-org.apache.shardingsphere.spring.boot.prop.SpringBootPropertiesConfiguration'
of type
[org.apache.shardingsphere.spring.boot.prop.SpringBootPropertiesConfiguration]
is not eligible for getting processed by all BeanPostProcessors (for example:
not eligible for auto-proxying)
2022-03-10 20:26:14.853 INFO 3260 --- [ main]
trationDelegate$BeanPostProcessorChecker : Bean
'org.apache.shardingsphere.spring.boot.ShardingSphereAutoConfiguration' of type
[org.apache.shardingsphere.spring.boot.ShardingSphereAutoConfiguration$$EnhancerBySpringCGLIB$$6b61ea66]
is not eligible for getting processed by all BeanPostProcessors (for example:
not eligible for auto-proxying)
2022-03-10 20:26:15.041 INFO 3260 --- [ main]
o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s):
8080 (http)
2022-03-10 20:26:15.048 INFO 3260 --- [ main]
o.apache.catalina.core.StandardService : Starting service [Tomcat]
2022-03-10 20:26:15.049 INFO 3260 --- [ main]
org.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache
Tomcat/9.0.45]
2022-03-10 20:26:15.190 INFO 3260 --- [ main]
o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring embedded
WebApplicationContext
2022-03-10 20:26:15.190 INFO 3260 --- [ main]
w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext:
initialization completed in 1022 ms
2022-03-10 20:26:15.305 INFO 3260 --- [ main]
o.s.s.concurrent.ThreadPoolTaskExecutor : Initializing ExecutorService
'applicationTaskExecutor'
2022-03-10 20:26:15.499 INFO 3260 --- [ main]
com.alibaba.druid.pool.DruidDataSource : {dataSource-1} inited
2022-03-10 20:26:15.615 INFO 3260 --- [ main]
com.alibaba.druid.pool.DruidDataSource : {dataSource-2} inited
2022-03-10 20:26:15.732 ERROR 3260 --- [ main]
.a.s.i.m.s.b.l.TableMetaDataLoaderEngine : Dialect load table meta data error
org.apache.shardingsphere.infra.exception.ShardingSphereException:
java.util.concurrent.ExecutionException: java.lang.NullPointerException
at
org.apache.shardingsphere.infra.metadata.schema.builder.loader.TableMetaDataLoaderEngine.loadByDialect(TableMetaDataLoaderEngine.java:99)
~[shardingsphere-infra-common-5.0.0.jar:5.0.0]
at
org.apache.shardingsphere.infra.metadata.schema.builder.loader.TableMetaDataLoaderEngine.load(TableMetaDataLoaderEngine.java:66)
~[shardingsphere-infra-common-5.0.0.jar:5.0.0]
at
org.apache.shardingsphere.sharding.metadata.ShardingTableMetaDataBuilder.load(ShardingTableMetaDataBuilder.java:64)
[shardingsphere-sharding-core-5.0.0.jar:5.0.0]
at
org.apache.shardingsphere.sharding.metadata.ShardingTableMetaDataBuilder.load(ShardingTableMetaDataBuilder.java:51)
[shardingsphere-sharding-core-5.0.0.jar:5.0.0]
at
org.apache.shardingsphere.infra.metadata.schema.builder.TableMetaDataBuilder.load(TableMetaDataBuilder.java:65)
[shardingsphere-infra-common-5.0.0.jar:5.0.0]
at
org.apache.shardingsphere.infra.metadata.schema.loader.SchemaLoader.load(SchemaLoader.java:71)
[shardingsphere-infra-common-5.0.0.jar:5.0.0]
at
org.apache.shardingsphere.mode.manager.memory.MemoryContextManagerBuilder.build(MemoryContextManagerBuilder.java:54)
[shardingsphere-memory-mode-core-5.0.0.jar:5.0.0]
at
org.apache.shardingsphere.driver.jdbc.core.datasource.ShardingSphereDataSource.createContextManager(ShardingSphereDataSource.java:75)
[shardingsphere-jdbc-core-5.0.0.jar:5.0.0]
at
org.apache.shardingsphere.driver.jdbc.core.datasource.ShardingSphereDataSource.<init>(ShardingSphereDataSource.java:61)
[shardingsphere-jdbc-core-5.0.0.jar:5.0.0]
at
org.apache.shardingsphere.driver.api.ShardingSphereDataSourceFactory.createDataSource(ShardingSphereDataSourceFactory.java:79)
[shardingsphere-jdbc-core-5.0.0.jar:5.0.0]
at
org.apache.shardingsphere.spring.boot.ShardingSphereAutoConfiguration.shardingSphereDataSource(ShardingSphereAutoConfiguration.java:93)
[shardingsphere-jdbc-core-spring-boot-starter-5.0.0.jar:5.0.0]
at
org.apache.shardingsphere.spring.boot.ShardingSphereAutoConfiguration$$EnhancerBySpringCGLIB$$6b61ea66.CGLIB$shardingSphereDataSource$2(<generated>)
[shardingsphere-jdbc-core-spring-boot-starter-5.0.0.jar:5.0.0]
at
org.apache.shardingsphere.spring.boot.ShardingSphereAutoConfiguration$$EnhancerBySpringCGLIB$$6b61ea66$$FastClassBySpringCGLIB$$e4a46908.invoke(<generated>)
[shardingsphere-jdbc-core-spring-boot-starter-5.0.0.jar:5.0.0]
at
org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:244)
[spring-core-5.3.6.jar:5.3.6]
at
org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:331)
[spring-context-5.3.6.jar:5.3.6]
at
org.apache.shardingsphere.spring.boot.ShardingSphereAutoConfiguration$$EnhancerBySpringCGLIB$$6b61ea66.shardingSphereDataSource(<generated>)
[shardingsphere-jdbc-core-spring-boot-starter-5.0.0.jar:5.0.0]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.8.0_271]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[na:1.8.0_271]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:1.8.0_271]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_271]
at
org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:154)
[spring-beans-5.3.6.jar:5.3.6]
at
org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:653)
[spring-beans-5.3.6.jar:5.3.6]
at
org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:638)
[spring-beans-5.3.6.jar:5.3.6]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1334)
[spring-beans-5.3.6.jar:5.3.6]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1177)
[spring-beans-5.3.6.jar:5.3.6]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:564)
[spring-beans-5.3.6.jar:5.3.6]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:524)
[spring-beans-5.3.6.jar:5.3.6]
at
org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)
[spring-beans-5.3.6.jar:5.3.6]
at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
~[spring-beans-5.3.6.jar:5.3.6]
at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333)
[spring-beans-5.3.6.jar:5.3.6]
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208)
[spring-beans-5.3.6.jar:5.3.6]
at
org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:944)
~[spring-beans-5.3.6.jar:5.3.6]
at
org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:918)
~[spring-context-5.3.6.jar:5.3.6]
at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583)
~[spring-context-5.3.6.jar:5.3.6]
at
org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:144)
~[spring-boot-2.4.5.jar:2.4.5]
at
org.springframework.boot.SpringApplication.refresh(SpringApplication.java:782)
~[spring-boot-2.4.5.jar:2.4.5]
at
org.springframework.boot.SpringApplication.refresh(SpringApplication.java:774)
~[spring-boot-2.4.5.jar:2.4.5]
at
org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:439)
~[spring-boot-2.4.5.jar:2.4.5]
at
org.springframework.boot.SpringApplication.run(SpringApplication.java:339)
~[spring-boot-2.4.5.jar:2.4.5]
at
org.springframework.boot.SpringApplication.run(SpringApplication.java:1340)
~[spring-boot-2.4.5.jar:2.4.5]
at
org.springframework.boot.SpringApplication.run(SpringApplication.java:1329)
~[spring-boot-2.4.5.jar:2.4.5]
at com.logan.App.main(App.java:15) ~[classes/:na]
Caused by: java.util.concurrent.ExecutionException:
java.lang.NullPointerException
at java.util.concurrent.FutureTask.report(FutureTask.java:122)
~[na:1.8.0_271]
at java.util.concurrent.FutureTask.get(FutureTask.java:192)
~[na:1.8.0_271]
at
org.apache.shardingsphere.infra.metadata.schema.builder.loader.TableMetaDataLoaderEngine.loadByDialect(TableMetaDataLoaderEngine.java:93)
~[shardingsphere-infra-common-5.0.0.jar:5.0.0]
... 41 common frames omitted
Caused by: java.lang.NullPointerException: null
at
org.apache.shardingsphere.infra.metadata.schema.builder.loader.dialect.MySQLTableMetaDataLoader.loadColumnMetaDataMap(MySQLTableMetaDataLoader.java:71)
~[shardingsphere-infra-common-5.0.0.jar:5.0.0]
at
org.apache.shardingsphere.infra.metadata.schema.builder.loader.dialect.MySQLTableMetaDataLoader.load(MySQLTableMetaDataLoader.java:60)
~[shardingsphere-infra-common-5.0.0.jar:5.0.0]
at
org.apache.shardingsphere.infra.metadata.schema.builder.loader.TableMetaDataLoaderEngine.lambda$loadByDialect$0(TableMetaDataLoaderEngine.java:89)
~[shardingsphere-infra-common-5.0.0.jar:5.0.0]
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
~[na:1.8.0_271]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
~[na:1.8.0_271]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
~[na:1.8.0_271]
at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_271]
2022-03-10 20:26:15.733 WARN 3260 --- [ main]
ConfigServletWebServerApplicationContext : Exception encountered during context
initialization - cancelling refresh attempt:
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.NullPointerException
2022-03-10 20:26:15.733 INFO 3260 --- [ main]
o.s.s.concurrent.ThreadPoolTaskExecutor : Shutting down ExecutorService
'applicationTaskExecutor'
2022-03-10 20:26:15.735 INFO 3260 --- [ main]
o.apache.catalina.core.StandardService : Stopping service [Tomcat]
2022-03-10 20:26:15.742 INFO 3260 --- [ main]
ConditionEvaluationReportLoggingListener :
Error starting ApplicationContext. To display the conditions report re-run
your application with 'debug' enabled.
2022-03-10 20:26:15.756 ERROR 3260 --- [ main]
o.s.boot.SpringApplication : Application run failed
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.NullPointerException
at
org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:658)
~[spring-beans-5.3.6.jar:5.3.6]
at
org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:638)
~[spring-beans-5.3.6.jar:5.3.6]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1334)
~[spring-beans-5.3.6.jar:5.3.6]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1177)
~[spring-beans-5.3.6.jar:5.3.6]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:564)
~[spring-beans-5.3.6.jar:5.3.6]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:524)
~[spring-beans-5.3.6.jar:5.3.6]
at
org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)
~[spring-beans-5.3.6.jar:5.3.6]
at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
~[spring-beans-5.3.6.jar:5.3.6]
at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333)
~[spring-beans-5.3.6.jar:5.3.6]
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208)
~[spring-beans-5.3.6.jar:5.3.6]
at
org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:944)
~[spring-beans-5.3.6.jar:5.3.6]
at
org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:918)
~[spring-context-5.3.6.jar:5.3.6]
at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583)
~[spring-context-5.3.6.jar:5.3.6]
at
org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:144)
~[spring-boot-2.4.5.jar:2.4.5]
at
org.springframework.boot.SpringApplication.refresh(SpringApplication.java:782)
[spring-boot-2.4.5.jar:2.4.5]
at
org.springframework.boot.SpringApplication.refresh(SpringApplication.java:774)
[spring-boot-2.4.5.jar:2.4.5]
at
org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:439)
[spring-boot-2.4.5.jar:2.4.5]
at
org.springframework.boot.SpringApplication.run(SpringApplication.java:339)
[spring-boot-2.4.5.jar:2.4.5]
at
org.springframework.boot.SpringApplication.run(SpringApplication.java:1340)
[spring-boot-2.4.5.jar:2.4.5]
at
org.springframework.boot.SpringApplication.run(SpringApplication.java:1329)
[spring-boot-2.4.5.jar:2.4.5]
at com.logan.App.main(App.java:15) [classes/:na]
Caused by: org.springframework.beans.BeanInstantiationException: Failed to
instantiate [javax.sql.DataSource]: Factory method 'shardingSphereDataSource'
threw exception; nested exception is java.lang.NullPointerException
at
org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:185)
~[spring-beans-5.3.6.jar:5.3.6]
at
org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:653)
~[spring-beans-5.3.6.jar:5.3.6]
... 20 common frames omitted
Caused by: java.lang.NullPointerException: null
at
org.apache.shardingsphere.infra.metadata.schema.builder.loader.common.TableMetaDataLoader.load(TableMetaDataLoader.java:48)
~[shardingsphere-infra-common-5.0.0.jar:5.0.0]
at
org.apache.shardingsphere.infra.metadata.schema.builder.loader.TableMetaDataLoaderEngine.loadByDefault(TableMetaDataLoaderEngine.java:79)
~[shardingsphere-infra-common-5.0.0.jar:5.0.0]
at
org.apache.shardingsphere.infra.metadata.schema.builder.loader.TableMetaDataLoaderEngine.load(TableMetaDataLoaderEngine.java:69)
~[shardingsphere-infra-common-5.0.0.jar:5.0.0]
at
org.apache.shardingsphere.sharding.metadata.ShardingTableMetaDataBuilder.load(ShardingTableMetaDataBuilder.java:64)
~[shardingsphere-sharding-core-5.0.0.jar:5.0.0]
at
org.apache.shardingsphere.sharding.metadata.ShardingTableMetaDataBuilder.load(ShardingTableMetaDataBuilder.java:51)
~[shardingsphere-sharding-core-5.0.0.jar:5.0.0]
at
org.apache.shardingsphere.infra.metadata.schema.builder.TableMetaDataBuilder.load(TableMetaDataBuilder.java:65)
~[shardingsphere-infra-common-5.0.0.jar:5.0.0]
at
org.apache.shardingsphere.infra.metadata.schema.loader.SchemaLoader.load(SchemaLoader.java:71)
~[shardingsphere-infra-common-5.0.0.jar:5.0.0]
at
org.apache.shardingsphere.mode.manager.memory.MemoryContextManagerBuilder.build(MemoryContextManagerBuilder.java:54)
~[shardingsphere-memory-mode-core-5.0.0.jar:5.0.0]
at
org.apache.shardingsphere.driver.jdbc.core.datasource.ShardingSphereDataSource.createContextManager(ShardingSphereDataSource.java:75)
~[shardingsphere-jdbc-core-5.0.0.jar:5.0.0]
at
org.apache.shardingsphere.driver.jdbc.core.datasource.ShardingSphereDataSource.<init>(ShardingSphereDataSource.java:61)
~[shardingsphere-jdbc-core-5.0.0.jar:5.0.0]
at
org.apache.shardingsphere.driver.api.ShardingSphereDataSourceFactory.createDataSource(ShardingSphereDataSourceFactory.java:79)
~[shardingsphere-jdbc-core-5.0.0.jar:5.0.0]
at
org.apache.shardingsphere.spring.boot.ShardingSphereAutoConfiguration.shardingSphereDataSource(ShardingSphereAutoConfiguration.java:93)
~[shardingsphere-jdbc-core-spring-boot-starter-5.0.0.jar:5.0.0]
at
org.apache.shardingsphere.spring.boot.ShardingSphereAutoConfiguration$$EnhancerBySpringCGLIB$$6b61ea66.CGLIB$shardingSphereDataSource$2(<generated>)
~[shardingsphere-jdbc-core-spring-boot-starter-5.0.0.jar:5.0.0]
at
org.apache.shardingsphere.spring.boot.ShardingSphereAutoConfiguration$$EnhancerBySpringCGLIB$$6b61ea66$$FastClassBySpringCGLIB$$e4a46908.invoke(<generated>)
~[shardingsphere-jdbc-core-spring-boot-starter-5.0.0.jar:5.0.0]
at
org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:244)
~[spring-core-5.3.6.jar:5.3.6]
at
org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:331)
~[spring-context-5.3.6.jar:5.3.6]
at
org.apache.shardingsphere.spring.boot.ShardingSphereAutoConfiguration$$EnhancerBySpringCGLIB$$6b61ea66.shardingSphereDataSource(<generated>)
~[shardingsphere-jdbc-core-spring-boot-starter-5.0.0.jar:5.0.0]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.8.0_271]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[na:1.8.0_271]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:1.8.0_271]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_271]
at
org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:154)
~[spring-beans-5.3.6.jar:5.3.6]
... 21 common frames omitted
Process finished with exit code 1
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
