[GitHub] [shardingsphere] qq379872286 commented on issue #13562: Always route to write-data-source when i use readwrite-splitting

[GitBox]

qq379872286 commented on issue #13562:
URL: 
https://github.com/apache/shardingsphere/issues/13562#issuecomment-980638973


   > > same in 5.0.0
   > 
   > Hi @qq379872286 Could you provide your configuration?
   
   Hi @RaigorJiang 
   
   
**shardingsphere-5.0.0\examples\shardingsphere-jdbc-example\single-feature-example\readwrite-splitting-example\readwrite-splitting-spring-boot-mybatis-example\src\main\resources\application-readwrite-splitting.properties:**
   
   
   spring.shardingsphere.datasource.names=write-ds,read-ds-0,read-ds-1
   
   
spring.shardingsphere.datasource.write-ds.jdbc-url=jdbc:mysql://localhost:3306/demo_write_ds?serverTimezone=UTC&useSSL=false&useUnicode=true&characterEncoding=UTF-8
   
spring.shardingsphere.datasource.write-ds.type=com.zaxxer.hikari.HikariDataSource
   
spring.shardingsphere.datasource.write-ds.driver-class-name=com.mysql.jdbc.Driver
   spring.shardingsphere.datasource.write-ds.username=root
   spring.shardingsphere.datasource.write-ds.password=root
   
   
spring.shardingsphere.datasource.read-ds-0.jdbc-url=jdbc:mysql://localhost:3306/demo_read_ds_0?serverTimezone=UTC&useSSL=false&useUnicode=true&characterEncoding=UTF-8
   
spring.shardingsphere.datasource.read-ds-0.type=com.zaxxer.hikari.HikariDataSource
   
spring.shardingsphere.datasource.read-ds-0.driver-class-name=com.mysql.jdbc.Driver
   spring.shardingsphere.datasource.read-ds-0.username=root
   spring.shardingsphere.datasource.read-ds-0.password=root
   
   
spring.shardingsphere.datasource.read-ds-1.jdbc-url=jdbc:mysql://localhost:3306/demo_read_ds_1?serverTimezone=UTC&useSSL=false&useUnicode=true&characterEncoding=UTF-8
   
spring.shardingsphere.datasource.read-ds-1.type=com.zaxxer.hikari.HikariDataSource
   
spring.shardingsphere.datasource.read-ds-1.driver-class-name=com.mysql.jdbc.Driver
   spring.shardingsphere.datasource.read-ds-1.username=root
   spring.shardingsphere.datasource.read-ds-1.password=root
   
   
spring.shardingsphere.rules.readwrite-splitting.load-balancers.round_robin.type=ROUND_ROBIN
   
spring.shardingsphere.rules.readwrite-splitting.data-sources.pr_ds.write-data-source-name=write-ds
   
spring.shardingsphere.rules.readwrite-splitting.data-sources.pr_ds.read-data-source-names=read-ds-0,read-ds-1
   
spring.shardingsphere.rules.readwrite-splitting.data-sources.pr_ds.load-balancer-name=round_robin
   spring.shardingsphere.props.sql-show=true
   
   
   
   **RUN logs：**
   
   
   
   [INFO ] 2021-11-27 22:28:10,491 --main-- 
[org.apache.shardingsphere.example.readwrite.splitting.spring.boot.mybatis.ReadwriteSplittingSpringBootMybatisExample]
 Starting ReadwriteSplittingSpringBootMybatisExample on DESKTOP-Q67659K with 
PID 29564 
(C:\javaDev\shardingsphere-5.0.0\examples\shardingsphere-jdbc-example\single-feature-example\readwrite-splitting-example\readwrite-splitting-spring-boot-mybatis-example\target\classes
 started by 37987 in C:\javaDev\shardingsphere-5.0.0\examples) 
   [INFO ] 2021-11-27 22:28:10,498 --main-- 
[org.apache.shardingsphere.example.readwrite.splitting.spring.boot.mybatis.ReadwriteSplittingSpringBootMybatisExample]
 The following profiles are active: readwrite-splitting 
   [INFO ] 2021-11-27 22:28:11,072 --main-- 
[org.springframework.context.annotation.AnnotationConfigApplicationContext] 
Refreshing 
org.springframework.context.annotation.AnnotationConfigApplicationContext@37afeb11:
 startup date [Sat Nov 27 22:28:11 CST 2021]; root of context hierarchy 
   [INFO ] 2021-11-27 22:28:12,644 --main-- 
[org.springframework.context.support.PostProcessorRegistrationDelegate$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) 
   [INFO ] 2021-11-27 22:28:12,651 --main-- 
[org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker]
 Bean 
'org.springframework.boot.context.properties.ConversionServiceDeducer$Factory' 
of type 
[org.springframework.boot.context.properties.ConversionServiceDeducer$Factory] 
is not eligible for getting processed by all BeanPostProcessors (for example: 
not eligible for auto-proxying) 
   [INFO ] 2021-11-27 22:28:12,673 --main-- 
[org.springframework.context.support.PostProcessorRegistrationDelegate$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) 
   [INFO ] 2021-11-27 22:28:13,089 --main-- 
[org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker]
 Bean 'org.apache.shardingsphere.spring.boot.ShardingSphereAutoConfiguration' 
of type 
[org.apache.shardingsphere.spring.boot.ShardingSphereAutoConfiguration$$EnhancerBySpringCGLIB$$af7b038d]
 is not eligible for getting processed by all BeanPostProcessors (for example: 
not eligible for auto-proxying) 
   [INFO ] 2021-11-27 22:28:13,529 --main-- 
[com.zaxxer.hikari.HikariDataSource] HikariPool-1 - Starting... 
   [INFO ] 2021-11-27 22:28:13,783 --main-- 
[com.zaxxer.hikari.HikariDataSource] HikariPool-1 - Start completed. 
   [INFO ] 2021-11-27 22:28:13,806 --main-- 
[com.zaxxer.hikari.HikariDataSource] HikariPool-2 - Starting... 
   [INFO ] 2021-11-27 22:28:13,814 --main-- 
[com.zaxxer.hikari.HikariDataSource] HikariPool-2 - Start completed. 
   [INFO ] 2021-11-27 22:28:13,814 --main-- 
[com.zaxxer.hikari.HikariDataSource] HikariPool-3 - Starting... 
   [INFO ] 2021-11-27 22:28:13,822 --main-- 
[com.zaxxer.hikari.HikariDataSource] HikariPool-3 - Start completed. 
   [INFO ] 2021-11-27 22:28:17,292 --main-- 
[org.quartz.impl.StdSchedulerFactory] Using default implementation for 
ThreadExecutor 
   [INFO ] 2021-11-27 22:28:17,315 --main-- 
[org.quartz.core.SchedulerSignalerImpl] Initialized Scheduler Signaller of 
type: class org.quartz.core.SchedulerSignalerImpl 
   [INFO ] 2021-11-27 22:28:17,315 --main-- [org.quartz.core.QuartzScheduler] 
Quartz Scheduler v.2.3.2 created. 
   [INFO ] 2021-11-27 22:28:17,317 --main-- [org.quartz.simpl.RAMJobStore] 
RAMJobStore initialized. 
   [INFO ] 2021-11-27 22:28:17,318 --main-- [org.quartz.core.QuartzScheduler] 
Scheduler meta-data: Quartz Scheduler (v2.3.2) 'quartzScheduler' with 
instanceId 'NON_CLUSTERED'
     Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally.
     NOT STARTED.
     Currently in standby mode.
     Number of jobs executed: 0
     Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 10 threads.
     Using job-store 'org.quartz.simpl.RAMJobStore' - which does not support 
persistence. and is not clustered.
    
   [INFO ] 2021-11-27 22:28:17,318 --main-- 
[org.quartz.impl.StdSchedulerFactory] Quartz scheduler 'quartzScheduler' 
initialized from an externally provided properties instance. 
   [INFO ] 2021-11-27 22:28:17,318 --main-- 
[org.quartz.impl.StdSchedulerFactory] Quartz scheduler version: 2.3.2 
   [INFO ] 2021-11-27 22:28:17,318 --main-- [org.quartz.core.QuartzScheduler] 
JobFactory set to: 
org.springframework.boot.autoconfigure.quartz.AutowireCapableBeanJobFactory@e91b4f4
 
   [INFO ] 2021-11-27 22:28:17,442 --main-- 
[org.springframework.jmx.export.annotation.AnnotationMBeanExporter] Registering 
beans for JMX exposure on startup 
   [INFO ] 2021-11-27 22:28:17,452 --main-- 
[org.springframework.context.support.DefaultLifecycleProcessor] Starting beans 
in phase 2147483647 
   [INFO ] 2021-11-27 22:28:17,452 --main-- 
[org.springframework.scheduling.quartz.SchedulerFactoryBean] Starting Quartz 
Scheduler now 
   [INFO ] 2021-11-27 22:28:17,452 --main-- [org.quartz.core.QuartzScheduler] 
Scheduler quartzScheduler_$_NON_CLUSTERED started. 
   [INFO ] 2021-11-27 22:28:17,464 --main-- 
[org.apache.shardingsphere.example.readwrite.splitting.spring.boot.mybatis.ReadwriteSplittingSpringBootMybatisExample]
 Started ReadwriteSplittingSpringBootMybatisExample in 8.208 seconds (JVM 
running for 11.082) 
   [INFO ] 2021-11-27 22:28:18,719 --main-- [ShardingSphere-SQL] Logic SQL: 
CREATE TABLE IF NOT EXISTS t_order (order_id BIGINT AUTO_INCREMENT, user_id INT 
NOT NULL, address_id BIGINT NOT NULL, status VARCHAR(50), PRIMARY KEY 
(order_id)); 
   [INFO ] 2021-11-27 22:28:18,720 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLCreateTableStatement(containsNotExistClause=true) 
   [INFO ] 2021-11-27 22:28:18,720 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: CREATE TABLE IF NOT EXISTS t_order (order_id BIGINT 
AUTO_INCREMENT, user_id INT NOT NULL, address_id BIGINT NOT NULL, status 
VARCHAR(50), PRIMARY KEY (order_id)); 
   [INFO ] 2021-11-27 22:28:18,819 --main-- [ShardingSphere-SQL] Logic SQL: 
CREATE TABLE IF NOT EXISTS t_order_item (order_item_id BIGINT AUTO_INCREMENT, 
order_id BIGINT, user_id INT NOT NULL, status VARCHAR(50) , PRIMARY KEY 
(order_item_id)); 
   [INFO ] 2021-11-27 22:28:18,819 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLCreateTableStatement(containsNotExistClause=true) 
   [INFO ] 2021-11-27 22:28:18,820 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: CREATE TABLE IF NOT EXISTS t_order_item (order_item_id BIGINT 
AUTO_INCREMENT, order_id BIGINT, user_id INT NOT NULL, status VARCHAR(50) , 
PRIMARY KEY (order_item_id)); 
   [INFO ] 2021-11-27 22:28:18,840 --main-- [ShardingSphere-SQL] Logic SQL: 
TRUNCATE TABLE t_order; 
   [INFO ] 2021-11-27 22:28:18,840 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLTruncateStatement() 
   [INFO ] 2021-11-27 22:28:18,840 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: TRUNCATE TABLE t_order; 
   [INFO ] 2021-11-27 22:28:18,867 --main-- [ShardingSphere-SQL] Logic SQL: 
TRUNCATE TABLE t_order_item; 
   [INFO ] 2021-11-27 22:28:18,867 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLTruncateStatement() 
   [INFO ] 2021-11-27 22:28:18,867 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: TRUNCATE TABLE t_order_item; 
   [INFO ] 2021-11-27 22:28:18,894 --main-- [ShardingSphere-SQL] Logic SQL: 
CREATE TABLE IF NOT EXISTS t_address (address_id BIGINT NOT NULL, address_name 
VARCHAR(100) NOT NULL, PRIMARY KEY (address_id)); 
   [INFO ] 2021-11-27 22:28:18,894 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLCreateTableStatement(containsNotExistClause=true) 
   [INFO ] 2021-11-27 22:28:18,894 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: CREATE TABLE IF NOT EXISTS t_address (address_id BIGINT NOT NULL, 
address_name VARCHAR(100) NOT NULL, PRIMARY KEY (address_id)); 
   [INFO ] 2021-11-27 22:28:18,909 --main-- [ShardingSphere-SQL] Logic SQL: 
TRUNCATE TABLE t_address; 
   [INFO ] 2021-11-27 22:28:18,909 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLTruncateStatement() 
   [INFO ] 2021-11-27 22:28:18,909 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: TRUNCATE TABLE t_address; 
   [INFO ] 2021-11-27 22:28:19,247 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_address (address_id, address_name) VALUES (?, ?); 
   [INFO ] 2021-11-27 22:28:19,247 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,247 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: INSERT INTO t_address (address_id, address_name) VALUES (?, ?); 
::: [1, address_1] 
   [INFO ] 2021-11-27 22:28:19,259 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_address (address_id, address_name) VALUES (?, ?); 
   [INFO ] 2021-11-27 22:28:19,259 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,259 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: INSERT INTO t_address (address_id, address_name) VALUES (?, ?); 
::: [2, address_2] 
   [INFO ] 2021-11-27 22:28:19,265 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_address (address_id, address_name) VALUES (?, ?); 
   [INFO ] 2021-11-27 22:28:19,265 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,265 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: INSERT INTO t_address (address_id, address_name) VALUES (?, ?); 
::: [3, address_3] 
   [INFO ] 2021-11-27 22:28:19,274 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_address (address_id, address_name) VALUES (?, ?); 
   [INFO ] 2021-11-27 22:28:19,275 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,275 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: INSERT INTO t_address (address_id, address_name) VALUES (?, ?); 
::: [4, address_4] 
   [INFO ] 2021-11-27 22:28:19,281 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_address (address_id, address_name) VALUES (?, ?); 
   [INFO ] 2021-11-27 22:28:19,281 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,281 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: INSERT INTO t_address (address_id, address_name) VALUES (?, ?); 
::: [5, address_5] 
   [INFO ] 2021-11-27 22:28:19,287 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_address (address_id, address_name) VALUES (?, ?); 
   [INFO ] 2021-11-27 22:28:19,287 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,287 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: INSERT INTO t_address (address_id, address_name) VALUES (?, ?); 
::: [6, address_6] 
   [INFO ] 2021-11-27 22:28:19,293 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_address (address_id, address_name) VALUES (?, ?); 
   [INFO ] 2021-11-27 22:28:19,293 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,294 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: INSERT INTO t_address (address_id, address_name) VALUES (?, ?); 
::: [7, address_7] 
   [INFO ] 2021-11-27 22:28:19,299 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_address (address_id, address_name) VALUES (?, ?); 
   [INFO ] 2021-11-27 22:28:19,299 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,299 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: INSERT INTO t_address (address_id, address_name) VALUES (?, ?); 
::: [8, address_8] 
   [INFO ] 2021-11-27 22:28:19,305 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_address (address_id, address_name) VALUES (?, ?); 
   [INFO ] 2021-11-27 22:28:19,305 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,305 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: INSERT INTO t_address (address_id, address_name) VALUES (?, ?); 
::: [9, address_9] 
   [INFO ] 2021-11-27 22:28:19,311 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_address (address_id, address_name) VALUES (?, ?); 
   [INFO ] 2021-11-27 22:28:19,311 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,311 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: INSERT INTO t_address (address_id, address_name) VALUES (?, ?); 
::: [10, address_10] 
   -------------- Process Success Begin ---------------
   ---------------------------- Insert Data ----------------------------
   [INFO ] 2021-11-27 22:28:19,336 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, ?); 
   [INFO ] 2021-11-27 22:28:19,336 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,336 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, 
?); ::: [1, 1, INSERT_TEST] 
   [INFO ] 2021-11-27 22:28:19,350 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, ?, ?); 
   [INFO ] 2021-11-27 22:28:19,351 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,351 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, ?, 
?); ::: [1, 1, INSERT_TEST] 
   [INFO ] 2021-11-27 22:28:19,354 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, ?); 
   [INFO ] 2021-11-27 22:28:19,354 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,355 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, 
?); ::: [2, 2, INSERT_TEST] 
   [INFO ] 2021-11-27 22:28:19,357 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, ?, ?); 
   [INFO ] 2021-11-27 22:28:19,357 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,357 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, ?, 
?); ::: [2, 2, INSERT_TEST] 
   [INFO ] 2021-11-27 22:28:19,359 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, ?); 
   [INFO ] 2021-11-27 22:28:19,360 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,360 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, 
?); ::: [3, 3, INSERT_TEST] 
   [INFO ] 2021-11-27 22:28:19,362 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, ?, ?); 
   [INFO ] 2021-11-27 22:28:19,362 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,362 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, ?, 
?); ::: [3, 3, INSERT_TEST] 
   [INFO ] 2021-11-27 22:28:19,364 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, ?); 
   [INFO ] 2021-11-27 22:28:19,365 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,365 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, 
?); ::: [4, 4, INSERT_TEST] 
   [INFO ] 2021-11-27 22:28:19,367 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, ?, ?); 
   [INFO ] 2021-11-27 22:28:19,367 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,367 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, ?, 
?); ::: [4, 4, INSERT_TEST] 
   [INFO ] 2021-11-27 22:28:19,369 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, ?); 
   [INFO ] 2021-11-27 22:28:19,369 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,369 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, 
?); ::: [5, 5, INSERT_TEST] 
   [INFO ] 2021-11-27 22:28:19,371 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, ?, ?); 
   [INFO ] 2021-11-27 22:28:19,372 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,372 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, ?, 
?); ::: [5, 5, INSERT_TEST] 
   [INFO ] 2021-11-27 22:28:19,374 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, ?); 
   [INFO ] 2021-11-27 22:28:19,374 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,374 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, 
?); ::: [6, 6, INSERT_TEST] 
   [INFO ] 2021-11-27 22:28:19,376 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, ?, ?); 
   [INFO ] 2021-11-27 22:28:19,376 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,376 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, ?, 
?); ::: [6, 6, INSERT_TEST] 
   [INFO ] 2021-11-27 22:28:19,378 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, ?); 
   [INFO ] 2021-11-27 22:28:19,378 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,378 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, 
?); ::: [7, 7, INSERT_TEST] 
   [INFO ] 2021-11-27 22:28:19,380 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, ?, ?); 
   [INFO ] 2021-11-27 22:28:19,380 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,380 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, ?, 
?); ::: [7, 7, INSERT_TEST] 
   [INFO ] 2021-11-27 22:28:19,382 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, ?); 
   [INFO ] 2021-11-27 22:28:19,382 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,382 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, 
?); ::: [8, 8, INSERT_TEST] 
   [INFO ] 2021-11-27 22:28:19,384 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, ?, ?); 
   [INFO ] 2021-11-27 22:28:19,384 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,384 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, ?, 
?); ::: [8, 8, INSERT_TEST] 
   [INFO ] 2021-11-27 22:28:19,386 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, ?); 
   [INFO ] 2021-11-27 22:28:19,386 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,386 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, 
?); ::: [9, 9, INSERT_TEST] 
   [INFO ] 2021-11-27 22:28:19,388 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, ?, ?); 
   [INFO ] 2021-11-27 22:28:19,388 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,388 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, ?, 
?); ::: [9, 9, INSERT_TEST] 
   [INFO ] 2021-11-27 22:28:19,390 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, ?); 
   [INFO ] 2021-11-27 22:28:19,391 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,391 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, 
?); ::: [10, 10, INSERT_TEST] 
   [INFO ] 2021-11-27 22:28:19,393 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, ?, ?); 
   [INFO ] 2021-11-27 22:28:19,393 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,393 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, ?, 
?); ::: [10, 10, INSERT_TEST] 
   ---------------------------- Print Order Data -----------------------
   [INFO ] 2021-11-27 22:28:19,448 --main-- [ShardingSphere-SQL] Logic SQL: 
SELECT * FROM t_order; 
   [INFO ] 2021-11-27 22:28:19,448 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLSelectStatement(limit=Optional.empty, lock=Optional.empty, 
window=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,448 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: SELECT * FROM t_order; 
   order_id: 1, user_id: 1, address_id: 1, status: INSERT_TEST
   order_id: 2, user_id: 2, address_id: 2, status: INSERT_TEST
   order_id: 3, user_id: 3, address_id: 3, status: INSERT_TEST
   order_id: 4, user_id: 4, address_id: 4, status: INSERT_TEST
   order_id: 5, user_id: 5, address_id: 5, status: INSERT_TEST
   order_id: 6, user_id: 6, address_id: 6, status: INSERT_TEST
   order_id: 7, user_id: 7, address_id: 7, status: INSERT_TEST
   order_id: 8, user_id: 8, address_id: 8, status: INSERT_TEST
   order_id: 9, user_id: 9, address_id: 9, status: INSERT_TEST
   order_id: 10, user_id: 10, address_id: 10, status: INSERT_TEST
   ---------------------------- Print OrderItem Data -------------------
   [INFO ] 2021-11-27 22:28:19,483 --main-- [ShardingSphere-SQL] Logic SQL: 
SELECT * from t_order_item 
   [INFO ] 2021-11-27 22:28:19,483 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLSelectStatement(limit=Optional.empty, lock=Optional.empty, 
window=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,483 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: SELECT * from t_order_item 
   order_item_id:1, order_id: 1, user_id: 1, status: INSERT_TEST
   order_item_id:2, order_id: 2, user_id: 2, status: INSERT_TEST
   order_item_id:3, order_id: 3, user_id: 3, status: INSERT_TEST
   order_item_id:4, order_id: 4, user_id: 4, status: INSERT_TEST
   order_item_id:5, order_id: 5, user_id: 5, status: INSERT_TEST
   order_item_id:6, order_id: 6, user_id: 6, status: INSERT_TEST
   order_item_id:7, order_id: 7, user_id: 7, status: INSERT_TEST
   order_item_id:8, order_id: 8, user_id: 8, status: INSERT_TEST
   order_item_id:9, order_id: 9, user_id: 9, status: INSERT_TEST
   order_item_id:10, order_id: 10, user_id: 10, status: INSERT_TEST
   ---------------------------- Delete Data ----------------------------
   [INFO ] 2021-11-27 22:28:19,515 --main-- [ShardingSphere-SQL] Logic SQL: 
DELETE FROM t_order WHERE order_id = ?; 
   [INFO ] 2021-11-27 22:28:19,515 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLDeleteStatement(orderBy=Optional.empty, limit=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,515 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: DELETE FROM t_order WHERE order_id = ?; ::: [1] 
   [INFO ] 2021-11-27 22:28:19,519 --main-- [ShardingSphere-SQL] Logic SQL: 
DELETE FROM t_order_item WHERE order_id = ?; 
   [INFO ] 2021-11-27 22:28:19,519 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLDeleteStatement(orderBy=Optional.empty, limit=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,519 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: DELETE FROM t_order_item WHERE order_id = ?; ::: [1] 
   [INFO ] 2021-11-27 22:28:19,522 --main-- [ShardingSphere-SQL] Logic SQL: 
DELETE FROM t_order WHERE order_id = ?; 
   [INFO ] 2021-11-27 22:28:19,522 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLDeleteStatement(orderBy=Optional.empty, limit=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,522 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: DELETE FROM t_order WHERE order_id = ?; ::: [2] 
   [INFO ] 2021-11-27 22:28:19,524 --main-- [ShardingSphere-SQL] Logic SQL: 
DELETE FROM t_order_item WHERE order_id = ?; 
   [INFO ] 2021-11-27 22:28:19,524 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLDeleteStatement(orderBy=Optional.empty, limit=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,524 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: DELETE FROM t_order_item WHERE order_id = ?; ::: [2] 
   [INFO ] 2021-11-27 22:28:19,527 --main-- [ShardingSphere-SQL] Logic SQL: 
DELETE FROM t_order WHERE order_id = ?; 
   [INFO ] 2021-11-27 22:28:19,527 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLDeleteStatement(orderBy=Optional.empty, limit=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,527 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: DELETE FROM t_order WHERE order_id = ?; ::: [3] 
   [INFO ] 2021-11-27 22:28:19,529 --main-- [ShardingSphere-SQL] Logic SQL: 
DELETE FROM t_order_item WHERE order_id = ?; 
   [INFO ] 2021-11-27 22:28:19,529 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLDeleteStatement(orderBy=Optional.empty, limit=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,529 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: DELETE FROM t_order_item WHERE order_id = ?; ::: [3] 
   [INFO ] 2021-11-27 22:28:19,532 --main-- [ShardingSphere-SQL] Logic SQL: 
DELETE FROM t_order WHERE order_id = ?; 
   [INFO ] 2021-11-27 22:28:19,532 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLDeleteStatement(orderBy=Optional.empty, limit=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,532 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: DELETE FROM t_order WHERE order_id = ?; ::: [4] 
   [INFO ] 2021-11-27 22:28:19,534 --main-- [ShardingSphere-SQL] Logic SQL: 
DELETE FROM t_order_item WHERE order_id = ?; 
   [INFO ] 2021-11-27 22:28:19,534 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLDeleteStatement(orderBy=Optional.empty, limit=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,534 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: DELETE FROM t_order_item WHERE order_id = ?; ::: [4] 
   [INFO ] 2021-11-27 22:28:19,536 --main-- [ShardingSphere-SQL] Logic SQL: 
DELETE FROM t_order WHERE order_id = ?; 
   [INFO ] 2021-11-27 22:28:19,536 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLDeleteStatement(orderBy=Optional.empty, limit=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,536 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: DELETE FROM t_order WHERE order_id = ?; ::: [5] 
   [INFO ] 2021-11-27 22:28:19,539 --main-- [ShardingSphere-SQL] Logic SQL: 
DELETE FROM t_order_item WHERE order_id = ?; 
   [INFO ] 2021-11-27 22:28:19,539 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLDeleteStatement(orderBy=Optional.empty, limit=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,539 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: DELETE FROM t_order_item WHERE order_id = ?; ::: [5] 
   [INFO ] 2021-11-27 22:28:19,541 --main-- [ShardingSphere-SQL] Logic SQL: 
DELETE FROM t_order WHERE order_id = ?; 
   [INFO ] 2021-11-27 22:28:19,541 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLDeleteStatement(orderBy=Optional.empty, limit=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,541 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: DELETE FROM t_order WHERE order_id = ?; ::: [6] 
   [INFO ] 2021-11-27 22:28:19,544 --main-- [ShardingSphere-SQL] Logic SQL: 
DELETE FROM t_order_item WHERE order_id = ?; 
   [INFO ] 2021-11-27 22:28:19,544 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLDeleteStatement(orderBy=Optional.empty, limit=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,544 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: DELETE FROM t_order_item WHERE order_id = ?; ::: [6] 
   [INFO ] 2021-11-27 22:28:19,545 --main-- [ShardingSphere-SQL] Logic SQL: 
DELETE FROM t_order WHERE order_id = ?; 
   [INFO ] 2021-11-27 22:28:19,546 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLDeleteStatement(orderBy=Optional.empty, limit=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,546 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: DELETE FROM t_order WHERE order_id = ?; ::: [7] 
   [INFO ] 2021-11-27 22:28:19,548 --main-- [ShardingSphere-SQL] Logic SQL: 
DELETE FROM t_order_item WHERE order_id = ?; 
   [INFO ] 2021-11-27 22:28:19,548 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLDeleteStatement(orderBy=Optional.empty, limit=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,548 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: DELETE FROM t_order_item WHERE order_id = ?; ::: [7] 
   [INFO ] 2021-11-27 22:28:19,550 --main-- [ShardingSphere-SQL] Logic SQL: 
DELETE FROM t_order WHERE order_id = ?; 
   [INFO ] 2021-11-27 22:28:19,550 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLDeleteStatement(orderBy=Optional.empty, limit=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,550 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: DELETE FROM t_order WHERE order_id = ?; ::: [8] 
   [INFO ] 2021-11-27 22:28:19,552 --main-- [ShardingSphere-SQL] Logic SQL: 
DELETE FROM t_order_item WHERE order_id = ?; 
   [INFO ] 2021-11-27 22:28:19,553 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLDeleteStatement(orderBy=Optional.empty, limit=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,555 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: DELETE FROM t_order_item WHERE order_id = ?; ::: [8] 
   [INFO ] 2021-11-27 22:28:19,557 --main-- [ShardingSphere-SQL] Logic SQL: 
DELETE FROM t_order WHERE order_id = ?; 
   [INFO ] 2021-11-27 22:28:19,557 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLDeleteStatement(orderBy=Optional.empty, limit=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,557 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: DELETE FROM t_order WHERE order_id = ?; ::: [9] 
   [INFO ] 2021-11-27 22:28:19,559 --main-- [ShardingSphere-SQL] Logic SQL: 
DELETE FROM t_order_item WHERE order_id = ?; 
   [INFO ] 2021-11-27 22:28:19,559 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLDeleteStatement(orderBy=Optional.empty, limit=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,559 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: DELETE FROM t_order_item WHERE order_id = ?; ::: [9] 
   [INFO ] 2021-11-27 22:28:19,561 --main-- [ShardingSphere-SQL] Logic SQL: 
DELETE FROM t_order WHERE order_id = ?; 
   [INFO ] 2021-11-27 22:28:19,561 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLDeleteStatement(orderBy=Optional.empty, limit=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,561 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: DELETE FROM t_order WHERE order_id = ?; ::: [10] 
   [INFO ] 2021-11-27 22:28:19,563 --main-- [ShardingSphere-SQL] Logic SQL: 
DELETE FROM t_order_item WHERE order_id = ?; 
   [INFO ] 2021-11-27 22:28:19,563 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLDeleteStatement(orderBy=Optional.empty, limit=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,563 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: DELETE FROM t_order_item WHERE order_id = ?; ::: [10] 
   ---------------------------- Print Order Data -----------------------
   [INFO ] 2021-11-27 22:28:19,565 --main-- [ShardingSphere-SQL] Logic SQL: 
SELECT * FROM t_order; 
   [INFO ] 2021-11-27 22:28:19,565 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLSelectStatement(limit=Optional.empty, lock=Optional.empty, 
window=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,565 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: SELECT * FROM t_order; 
   ---------------------------- Print OrderItem Data -------------------
   [INFO ] 2021-11-27 22:28:19,567 --main-- [ShardingSphere-SQL] Logic SQL: 
SELECT * from t_order_item 
   [INFO ] 2021-11-27 22:28:19,568 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLSelectStatement(limit=Optional.empty, lock=Optional.empty, 
window=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,568 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: SELECT * from t_order_item 
   -------------- Process Success Finish --------------
   [INFO ] 2021-11-27 22:28:19,579 --main-- [ShardingSphere-SQL] Logic SQL: 
SELECT * FROM t_order where order_id = ?; 
   [INFO ] 2021-11-27 22:28:19,579 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLSelectStatement(limit=Optional.empty, lock=Optional.empty, 
window=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,579 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: SELECT * FROM t_order where order_id = ?; ::: [1] 
   null
   [INFO ] 2021-11-27 22:28:19,580 --main-- [ShardingSphere-SQL] Logic SQL: 
SELECT * FROM t_order where order_id = ?; 
   [INFO ] 2021-11-27 22:28:19,580 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLSelectStatement(limit=Optional.empty, lock=Optional.empty, 
window=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,580 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: SELECT * FROM t_order where order_id = ?; ::: [2] 
   null
   [INFO ] 2021-11-27 22:28:19,582 --main-- [ShardingSphere-SQL] Logic SQL: 
SELECT * FROM t_order where order_id = ?; 
   [INFO ] 2021-11-27 22:28:19,582 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLSelectStatement(limit=Optional.empty, lock=Optional.empty, 
window=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,582 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: SELECT * FROM t_order where order_id = ?; ::: [3] 
   null
   [INFO ] 2021-11-27 22:28:19,584 --main-- [ShardingSphere-SQL] Logic SQL: 
SELECT * FROM t_order where order_id = ?; 
   [INFO ] 2021-11-27 22:28:19,584 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLSelectStatement(limit=Optional.empty, lock=Optional.empty, 
window=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,584 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: SELECT * FROM t_order where order_id = ?; ::: [4] 
   null
   [INFO ] 2021-11-27 22:28:19,586 --main-- [ShardingSphere-SQL] Logic SQL: 
SELECT * FROM t_order where order_id = ?; 
   [INFO ] 2021-11-27 22:28:19,586 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLSelectStatement(limit=Optional.empty, lock=Optional.empty, 
window=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,586 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: SELECT * FROM t_order where order_id = ?; ::: [5] 
   null
   [INFO ] 2021-11-27 22:28:19,588 --main-- [ShardingSphere-SQL] Logic SQL: 
SELECT * FROM t_order where order_id = ?; 
   [INFO ] 2021-11-27 22:28:19,588 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLSelectStatement(limit=Optional.empty, lock=Optional.empty, 
window=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,588 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: SELECT * FROM t_order where order_id = ?; ::: [6] 
   null
   [INFO ] 2021-11-27 22:28:19,590 --main-- [ShardingSphere-SQL] Logic SQL: 
SELECT * FROM t_order where order_id = ?; 
   [INFO ] 2021-11-27 22:28:19,590 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLSelectStatement(limit=Optional.empty, lock=Optional.empty, 
window=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,590 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: SELECT * FROM t_order where order_id = ?; ::: [7] 
   null
   [INFO ] 2021-11-27 22:28:19,592 --main-- [ShardingSphere-SQL] Logic SQL: 
SELECT * FROM t_order where order_id = ?; 
   [INFO ] 2021-11-27 22:28:19,592 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLSelectStatement(limit=Optional.empty, lock=Optional.empty, 
window=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,592 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: SELECT * FROM t_order where order_id = ?; ::: [8] 
   null
   [INFO ] 2021-11-27 22:28:19,594 --main-- [ShardingSphere-SQL] Logic SQL: 
SELECT * FROM t_order where order_id = ?; 
   [INFO ] 2021-11-27 22:28:19,594 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLSelectStatement(limit=Optional.empty, lock=Optional.empty, 
window=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,594 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: SELECT * FROM t_order where order_id = ?; ::: [9] 
   null
   [INFO ] 2021-11-27 22:28:19,596 --main-- [ShardingSphere-SQL] Logic SQL: 
SELECT * FROM t_order where order_id = ?; 
   [INFO ] 2021-11-27 22:28:19,596 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLSelectStatement(limit=Optional.empty, lock=Optional.empty, 
window=Optional.empty) 
   [INFO ] 2021-11-27 22:28:19,596 --main-- [ShardingSphere-SQL] Actual SQL: 
write-ds ::: SELECT * FROM t_order where order_id = ?; ::: [10] 
   null
   [INFO ] 2021-11-27 22:28:19,604 --main-- 
[org.springframework.context.annotation.AnnotationConfigApplicationContext] 
Closing 
org.springframework.context.annotation.AnnotationConfigApplicationContext@37afeb11:
 startup date [Sat Nov 27 22:28:11 CST 2021]; root of context hierarchy 
   [INFO ] 2021-11-27 22:28:19,606 --main-- 
[org.springframework.context.support.DefaultLifecycleProcessor] Stopping beans 
in phase 2147483647 
   [INFO ] 2021-11-27 22:28:19,607 --main-- [org.quartz.core.QuartzScheduler] 
Scheduler quartzScheduler_$_NON_CLUSTERED paused. 
   [INFO ] 2021-11-27 22:28:19,607 --main-- 
[org.springframework.scheduling.quartz.SchedulerFactoryBean] Shutting down 
Quartz Scheduler 
   [INFO ] 2021-11-27 22:28:19,607 --main-- [org.quartz.core.QuartzScheduler] 
Scheduler quartzScheduler_$_NON_CLUSTERED shutting down. 
   [INFO ] 2021-11-27 22:28:19,607 --main-- [org.quartz.core.QuartzScheduler] 
Scheduler quartzScheduler_$_NON_CLUSTERED paused. 
   [INFO ] 2021-11-27 22:28:19,609 --main-- [org.quartz.core.QuartzScheduler] 
Scheduler quartzScheduler_$_NON_CLUSTERED shutdown complete. 
   [INFO ] 2021-11-27 22:28:19,609 --main-- 
[org.springframework.jmx.export.annotation.AnnotationMBeanExporter] 
Unregistering JMX-exposed beans on shutdown 
   [INFO ] 2021-11-27 22:28:19,610 --main-- 
[com.zaxxer.hikari.HikariDataSource] HikariPool-1 - Shutdown initiated... 
   [INFO ] 2021-11-27 22:28:19,623 --main-- 
[com.zaxxer.hikari.HikariDataSource] HikariPool-1 - Shutdown completed. 
   [INFO ] 2021-11-27 22:28:19,623 --main-- 
[com.zaxxer.hikari.HikariDataSource] HikariPool-2 - Shutdown initiated... 
   [INFO ] 2021-11-27 22:28:19,631 --main-- 
[com.zaxxer.hikari.HikariDataSource] HikariPool-2 - Shutdown completed. 
   [INFO ] 2021-11-27 22:28:19,632 --main-- 
[com.zaxxer.hikari.HikariDataSource] HikariPool-3 - Shutdown initiated... 
   [INFO ] 2021-11-27 22:28:19,636 --main-- 
[com.zaxxer.hikari.HikariDataSource] HikariPool-3 - Shutdown completed. 
   
   Process finished with exit code 0
   
   
   
   
   
   when I changed the properties file like this:
   
   
   
**spring.shardingsphere.rules.readwrite-splitting.data-sources.pr_ds.write-data-source-name=read-ds-0**
   
   
   
   
   
   
   
   
   
   
   **Then the logs ：**
   
   
   
   
   
   
   [INFO ] 2021-11-27 22:32:27,399 --main-- 
[org.apache.shardingsphere.example.readwrite.splitting.spring.boot.mybatis.ReadwriteSplittingSpringBootMybatisExample]
 The following profiles are active: readwrite-splitting 
   [INFO ] 2021-11-27 22:32:28,128 --main-- 
[org.springframework.context.annotation.AnnotationConfigApplicationContext] 
Refreshing 
org.springframework.context.annotation.AnnotationConfigApplicationContext@4567f35d:
 startup date [Sat Nov 27 22:32:28 CST 2021]; root of context hierarchy 
   [INFO ] 2021-11-27 22:32:29,688 --main-- 
[org.springframework.context.support.PostProcessorRegistrationDelegate$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) 
   [INFO ] 2021-11-27 22:32:29,695 --main-- 
[org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker]
 Bean 
'org.springframework.boot.context.properties.ConversionServiceDeducer$Factory' 
of type 
[org.springframework.boot.context.properties.ConversionServiceDeducer$Factory] 
is not eligible for getting processed by all BeanPostProcessors (for example: 
not eligible for auto-proxying) 
   [INFO ] 2021-11-27 22:32:29,713 --main-- 
[org.springframework.context.support.PostProcessorRegistrationDelegate$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) 
   [INFO ] 2021-11-27 22:32:30,133 --main-- 
[org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker]
 Bean 'org.apache.shardingsphere.spring.boot.ShardingSphereAutoConfiguration' 
of type 
[org.apache.shardingsphere.spring.boot.ShardingSphereAutoConfiguration$$EnhancerBySpringCGLIB$$c40c93b7]
 is not eligible for getting processed by all BeanPostProcessors (for example: 
not eligible for auto-proxying) 
   [INFO ] 2021-11-27 22:32:30,491 --main-- 
[com.zaxxer.hikari.HikariDataSource] HikariPool-1 - Starting... 
   [INFO ] 2021-11-27 22:32:30,730 --main-- 
[com.zaxxer.hikari.HikariDataSource] HikariPool-1 - Start completed. 
   [INFO ] 2021-11-27 22:32:30,752 --main-- 
[com.zaxxer.hikari.HikariDataSource] HikariPool-2 - Starting... 
   [INFO ] 2021-11-27 22:32:30,759 --main-- 
[com.zaxxer.hikari.HikariDataSource] HikariPool-2 - Start completed. 
   [INFO ] 2021-11-27 22:32:30,760 --main-- 
[com.zaxxer.hikari.HikariDataSource] HikariPool-3 - Starting... 
   [INFO ] 2021-11-27 22:32:30,766 --main-- 
[com.zaxxer.hikari.HikariDataSource] HikariPool-3 - Start completed. 
   [INFO ] 2021-11-27 22:32:34,089 --main-- 
[org.quartz.impl.StdSchedulerFactory] Using default implementation for 
ThreadExecutor 
   [INFO ] 2021-11-27 22:32:34,112 --main-- 
[org.quartz.core.SchedulerSignalerImpl] Initialized Scheduler Signaller of 
type: class org.quartz.core.SchedulerSignalerImpl 
   [INFO ] 2021-11-27 22:32:34,112 --main-- [org.quartz.core.QuartzScheduler] 
Quartz Scheduler v.2.3.2 created. 
   [INFO ] 2021-11-27 22:32:34,114 --main-- [org.quartz.simpl.RAMJobStore] 
RAMJobStore initialized. 
   [INFO ] 2021-11-27 22:32:34,115 --main-- [org.quartz.core.QuartzScheduler] 
Scheduler meta-data: Quartz Scheduler (v2.3.2) 'quartzScheduler' with 
instanceId 'NON_CLUSTERED'
     Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally.
     NOT STARTED.
     Currently in standby mode.
     Number of jobs executed: 0
     Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 10 threads.
     Using job-store 'org.quartz.simpl.RAMJobStore' - which does not support 
persistence. and is not clustered.
    
   [INFO ] 2021-11-27 22:32:34,115 --main-- 
[org.quartz.impl.StdSchedulerFactory] Quartz scheduler 'quartzScheduler' 
initialized from an externally provided properties instance. 
   [INFO ] 2021-11-27 22:32:34,115 --main-- 
[org.quartz.impl.StdSchedulerFactory] Quartz scheduler version: 2.3.2 
   [INFO ] 2021-11-27 22:32:34,115 --main-- [org.quartz.core.QuartzScheduler] 
JobFactory set to: 
org.springframework.boot.autoconfigure.quartz.AutowireCapableBeanJobFactory@d611f1c
 
   [INFO ] 2021-11-27 22:32:34,249 --main-- 
[org.springframework.jmx.export.annotation.AnnotationMBeanExporter] Registering 
beans for JMX exposure on startup 
   [INFO ] 2021-11-27 22:32:34,261 --main-- 
[org.springframework.context.support.DefaultLifecycleProcessor] Starting beans 
in phase 2147483647 
   [INFO ] 2021-11-27 22:32:34,261 --main-- 
[org.springframework.scheduling.quartz.SchedulerFactoryBean] Starting Quartz 
Scheduler now 
   [INFO ] 2021-11-27 22:32:34,261 --main-- [org.quartz.core.QuartzScheduler] 
Scheduler quartzScheduler_$_NON_CLUSTERED started. 
   [INFO ] 2021-11-27 22:32:34,275 --main-- 
[org.apache.shardingsphere.example.readwrite.splitting.spring.boot.mybatis.ReadwriteSplittingSpringBootMybatisExample]
 Started ReadwriteSplittingSpringBootMybatisExample in 8.567 seconds (JVM 
running for 12.366) 
   [INFO ] 2021-11-27 22:32:35,386 --main-- [ShardingSphere-SQL] Logic SQL: 
CREATE TABLE IF NOT EXISTS t_order (order_id BIGINT AUTO_INCREMENT, user_id INT 
NOT NULL, address_id BIGINT NOT NULL, status VARCHAR(50), PRIMARY KEY 
(order_id)); 
   [INFO ] 2021-11-27 22:32:35,386 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLCreateTableStatement(containsNotExistClause=true) 
   [INFO ] 2021-11-27 22:32:35,387 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: CREATE TABLE IF NOT EXISTS t_order (order_id BIGINT 
AUTO_INCREMENT, user_id INT NOT NULL, address_id BIGINT NOT NULL, status 
VARCHAR(50), PRIMARY KEY (order_id)); 
   [INFO ] 2021-11-27 22:32:35,461 --main-- [ShardingSphere-SQL] Logic SQL: 
CREATE TABLE IF NOT EXISTS t_order_item (order_item_id BIGINT AUTO_INCREMENT, 
order_id BIGINT, user_id INT NOT NULL, status VARCHAR(50) , PRIMARY KEY 
(order_item_id)); 
   [INFO ] 2021-11-27 22:32:35,461 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLCreateTableStatement(containsNotExistClause=true) 
   [INFO ] 2021-11-27 22:32:35,461 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: CREATE TABLE IF NOT EXISTS t_order_item (order_item_id BIGINT 
AUTO_INCREMENT, order_id BIGINT, user_id INT NOT NULL, status VARCHAR(50) , 
PRIMARY KEY (order_item_id)); 
   [INFO ] 2021-11-27 22:32:35,484 --main-- [ShardingSphere-SQL] Logic SQL: 
TRUNCATE TABLE t_order; 
   [INFO ] 2021-11-27 22:32:35,484 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLTruncateStatement() 
   [INFO ] 2021-11-27 22:32:35,484 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: TRUNCATE TABLE t_order; 
   [INFO ] 2021-11-27 22:32:35,508 --main-- [ShardingSphere-SQL] Logic SQL: 
TRUNCATE TABLE t_order_item; 
   [INFO ] 2021-11-27 22:32:35,508 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLTruncateStatement() 
   [INFO ] 2021-11-27 22:32:35,508 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: TRUNCATE TABLE t_order_item; 
   [INFO ] 2021-11-27 22:32:35,531 --main-- [ShardingSphere-SQL] Logic SQL: 
CREATE TABLE IF NOT EXISTS t_address (address_id BIGINT NOT NULL, address_name 
VARCHAR(100) NOT NULL, PRIMARY KEY (address_id)); 
   [INFO ] 2021-11-27 22:32:35,531 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLCreateTableStatement(containsNotExistClause=true) 
   [INFO ] 2021-11-27 22:32:35,531 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: CREATE TABLE IF NOT EXISTS t_address (address_id BIGINT NOT NULL, 
address_name VARCHAR(100) NOT NULL, PRIMARY KEY (address_id)); 
   [INFO ] 2021-11-27 22:32:35,547 --main-- [ShardingSphere-SQL] Logic SQL: 
TRUNCATE TABLE t_address; 
   [INFO ] 2021-11-27 22:32:35,548 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLTruncateStatement() 
   [INFO ] 2021-11-27 22:32:35,548 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: TRUNCATE TABLE t_address; 
   [INFO ] 2021-11-27 22:32:35,827 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_address (address_id, address_name) VALUES (?, ?); 
   [INFO ] 2021-11-27 22:32:35,828 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:32:35,828 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: INSERT INTO t_address (address_id, address_name) VALUES (?, ?); 
::: [1, address_1] 
   [INFO ] 2021-11-27 22:32:35,836 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_address (address_id, address_name) VALUES (?, ?); 
   [INFO ] 2021-11-27 22:32:35,836 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:32:35,836 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: INSERT INTO t_address (address_id, address_name) VALUES (?, ?); 
::: [2, address_2] 
   [INFO ] 2021-11-27 22:32:35,841 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_address (address_id, address_name) VALUES (?, ?); 
   [INFO ] 2021-11-27 22:32:35,841 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:32:35,841 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: INSERT INTO t_address (address_id, address_name) VALUES (?, ?); 
::: [3, address_3] 
   [INFO ] 2021-11-27 22:32:35,847 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_address (address_id, address_name) VALUES (?, ?); 
   [INFO ] 2021-11-27 22:32:35,848 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:32:35,848 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: INSERT INTO t_address (address_id, address_name) VALUES (?, ?); 
::: [4, address_4] 
   [INFO ] 2021-11-27 22:32:35,854 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_address (address_id, address_name) VALUES (?, ?); 
   [INFO ] 2021-11-27 22:32:35,854 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:32:35,854 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: INSERT INTO t_address (address_id, address_name) VALUES (?, ?); 
::: [5, address_5] 
   [INFO ] 2021-11-27 22:32:35,859 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_address (address_id, address_name) VALUES (?, ?); 
   [INFO ] 2021-11-27 22:32:35,859 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:32:35,859 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: INSERT INTO t_address (address_id, address_name) VALUES (?, ?); 
::: [6, address_6] 
   [INFO ] 2021-11-27 22:32:35,865 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_address (address_id, address_name) VALUES (?, ?); 
   [INFO ] 2021-11-27 22:32:35,865 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:32:35,865 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: INSERT INTO t_address (address_id, address_name) VALUES (?, ?); 
::: [7, address_7] 
   [INFO ] 2021-11-27 22:32:35,870 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_address (address_id, address_name) VALUES (?, ?); 
   [INFO ] 2021-11-27 22:32:35,870 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:32:35,870 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: INSERT INTO t_address (address_id, address_name) VALUES (?, ?); 
::: [8, address_8] 
   [INFO ] 2021-11-27 22:32:35,875 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_address (address_id, address_name) VALUES (?, ?); 
   [INFO ] 2021-11-27 22:32:35,876 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:32:35,876 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: INSERT INTO t_address (address_id, address_name) VALUES (?, ?); 
::: [9, address_9] 
   [INFO ] 2021-11-27 22:32:35,881 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_address (address_id, address_name) VALUES (?, ?); 
   [INFO ] 2021-11-27 22:32:35,881 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:32:35,881 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: INSERT INTO t_address (address_id, address_name) VALUES (?, ?); 
::: [10, address_10] 
   -------------- Process Success Begin ---------------
   ---------------------------- Insert Data ----------------------------
   [INFO ] 2021-11-27 22:32:35,902 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, ?); 
   [INFO ] 2021-11-27 22:32:35,902 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:32:35,902 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, 
?); ::: [1, 1, INSERT_TEST] 
   [INFO ] 2021-11-27 22:32:35,915 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, ?, ?); 
   [INFO ] 2021-11-27 22:32:35,915 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:32:35,915 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, 
?, ?); ::: [1, 1, INSERT_TEST] 
   [INFO ] 2021-11-27 22:32:35,918 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, ?); 
   [INFO ] 2021-11-27 22:32:35,919 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:32:35,919 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, 
?); ::: [2, 2, INSERT_TEST] 
   [INFO ] 2021-11-27 22:32:35,921 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, ?, ?); 
   [INFO ] 2021-11-27 22:32:35,921 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:32:35,921 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, 
?, ?); ::: [2, 2, INSERT_TEST] 
   [INFO ] 2021-11-27 22:32:35,923 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, ?); 
   [INFO ] 2021-11-27 22:32:35,923 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:32:35,923 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, 
?); ::: [3, 3, INSERT_TEST] 
   [INFO ] 2021-11-27 22:32:35,925 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, ?, ?); 
   [INFO ] 2021-11-27 22:32:35,925 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:32:35,925 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, 
?, ?); ::: [3, 3, INSERT_TEST] 
   [INFO ] 2021-11-27 22:32:35,927 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, ?); 
   [INFO ] 2021-11-27 22:32:35,927 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:32:35,927 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, 
?); ::: [4, 4, INSERT_TEST] 
   [INFO ] 2021-11-27 22:32:35,929 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, ?, ?); 
   [INFO ] 2021-11-27 22:32:35,929 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:32:35,929 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, 
?, ?); ::: [4, 4, INSERT_TEST] 
   [INFO ] 2021-11-27 22:32:35,931 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, ?); 
   [INFO ] 2021-11-27 22:32:35,931 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:32:35,931 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, 
?); ::: [5, 5, INSERT_TEST] 
   [INFO ] 2021-11-27 22:32:35,933 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, ?, ?); 
   [INFO ] 2021-11-27 22:32:35,933 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:32:35,933 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, 
?, ?); ::: [5, 5, INSERT_TEST] 
   [INFO ] 2021-11-27 22:32:35,935 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, ?); 
   [INFO ] 2021-11-27 22:32:35,935 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:32:35,935 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, 
?); ::: [6, 6, INSERT_TEST] 
   [INFO ] 2021-11-27 22:32:35,937 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, ?, ?); 
   [INFO ] 2021-11-27 22:32:35,937 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:32:35,937 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, 
?, ?); ::: [6, 6, INSERT_TEST] 
   [INFO ] 2021-11-27 22:32:35,940 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, ?); 
   [INFO ] 2021-11-27 22:32:35,940 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:32:35,940 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, 
?); ::: [7, 7, INSERT_TEST] 
   [INFO ] 2021-11-27 22:32:35,942 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, ?, ?); 
   [INFO ] 2021-11-27 22:32:35,942 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:32:35,942 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, 
?, ?); ::: [7, 7, INSERT_TEST] 
   [INFO ] 2021-11-27 22:32:35,944 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, ?); 
   [INFO ] 2021-11-27 22:32:35,944 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:32:35,944 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, 
?); ::: [8, 8, INSERT_TEST] 
   [INFO ] 2021-11-27 22:32:35,946 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, ?, ?); 
   [INFO ] 2021-11-27 22:32:35,946 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:32:35,946 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, 
?, ?); ::: [8, 8, INSERT_TEST] 
   [INFO ] 2021-11-27 22:32:35,948 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, ?); 
   [INFO ] 2021-11-27 22:32:35,949 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:32:35,949 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, 
?); ::: [9, 9, INSERT_TEST] 
   [INFO ] 2021-11-27 22:32:35,950 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, ?, ?); 
   [INFO ] 2021-11-27 22:32:35,951 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:32:35,951 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, 
?, ?); ::: [9, 9, INSERT_TEST] 
   [INFO ] 2021-11-27 22:32:35,952 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, ?); 
   [INFO ] 2021-11-27 22:32:35,952 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:32:35,953 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, 
?); ::: [10, 10, INSERT_TEST] 
   [INFO ] 2021-11-27 22:32:35,955 --main-- [ShardingSphere-SQL] Logic SQL: 
INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, ?, ?); 
   [INFO ] 2021-11-27 22:32:35,955 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLInsertStatement(setAssignment=Optional.empty, 
onDuplicateKeyColumns=Optional.empty) 
   [INFO ] 2021-11-27 22:32:35,955 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, 
?, ?); ::: [10, 10, INSERT_TEST] 
   ---------------------------- Print Order Data -----------------------
   [INFO ] 2021-11-27 22:32:36,007 --main-- [ShardingSphere-SQL] Logic SQL: 
SELECT * FROM t_order; 
   [INFO ] 2021-11-27 22:32:36,007 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLSelectStatement(limit=Optional.empty, lock=Optional.empty, 
window=Optional.empty) 
   [INFO ] 2021-11-27 22:32:36,007 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: SELECT * FROM t_order; 
   order_id: 1, user_id: 1, address_id: 1, status: INSERT_TEST
   order_id: 2, user_id: 2, address_id: 2, status: INSERT_TEST
   order_id: 3, user_id: 3, address_id: 3, status: INSERT_TEST
   order_id: 4, user_id: 4, address_id: 4, status: INSERT_TEST
   order_id: 5, user_id: 5, address_id: 5, status: INSERT_TEST
   order_id: 6, user_id: 6, address_id: 6, status: INSERT_TEST
   order_id: 7, user_id: 7, address_id: 7, status: INSERT_TEST
   order_id: 8, user_id: 8, address_id: 8, status: INSERT_TEST
   order_id: 9, user_id: 9, address_id: 9, status: INSERT_TEST
   order_id: 10, user_id: 10, address_id: 10, status: INSERT_TEST
   ---------------------------- Print OrderItem Data -------------------
   [INFO ] 2021-11-27 22:32:36,039 --main-- [ShardingSphere-SQL] Logic SQL: 
SELECT * from t_order_item 
   [INFO ] 2021-11-27 22:32:36,039 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLSelectStatement(limit=Optional.empty, lock=Optional.empty, 
window=Optional.empty) 
   [INFO ] 2021-11-27 22:32:36,039 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: SELECT * from t_order_item 
   order_item_id:1, order_id: 1, user_id: 1, status: INSERT_TEST
   order_item_id:2, order_id: 2, user_id: 2, status: INSERT_TEST
   order_item_id:3, order_id: 3, user_id: 3, status: INSERT_TEST
   order_item_id:4, order_id: 4, user_id: 4, status: INSERT_TEST
   order_item_id:5, order_id: 5, user_id: 5, status: INSERT_TEST
   order_item_id:6, order_id: 6, user_id: 6, status: INSERT_TEST
   order_item_id:7, order_id: 7, user_id: 7, status: INSERT_TEST
   order_item_id:8, order_id: 8, user_id: 8, status: INSERT_TEST
   order_item_id:9, order_id: 9, user_id: 9, status: INSERT_TEST
   order_item_id:10, order_id: 10, user_id: 10, status: INSERT_TEST
   ---------------------------- Delete Data ----------------------------
   [INFO ] 2021-11-27 22:32:36,068 --main-- [ShardingSphere-SQL] Logic SQL: 
DELETE FROM t_order WHERE order_id = ?; 
   [INFO ] 2021-11-27 22:32:36,068 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLDeleteStatement(orderBy=Optional.empty, limit=Optional.empty) 
   [INFO ] 2021-11-27 22:32:36,068 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: DELETE FROM t_order WHERE order_id = ?; ::: [1] 
   [INFO ] 2021-11-27 22:32:36,072 --main-- [ShardingSphere-SQL] Logic SQL: 
DELETE FROM t_order_item WHERE order_id = ?; 
   [INFO ] 2021-11-27 22:32:36,072 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLDeleteStatement(orderBy=Optional.empty, limit=Optional.empty) 
   [INFO ] 2021-11-27 22:32:36,072 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: DELETE FROM t_order_item WHERE order_id = ?; ::: [1] 
   [INFO ] 2021-11-27 22:32:36,074 --main-- [ShardingSphere-SQL] Logic SQL: 
DELETE FROM t_order WHERE order_id = ?; 
   [INFO ] 2021-11-27 22:32:36,074 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLDeleteStatement(orderBy=Optional.empty, limit=Optional.empty) 
   [INFO ] 2021-11-27 22:32:36,074 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: DELETE FROM t_order WHERE order_id = ?; ::: [2] 
   [INFO ] 2021-11-27 22:32:36,076 --main-- [ShardingSphere-SQL] Logic SQL: 
DELETE FROM t_order_item WHERE order_id = ?; 
   [INFO ] 2021-11-27 22:32:36,076 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLDeleteStatement(orderBy=Optional.empty, limit=Optional.empty) 
   [INFO ] 2021-11-27 22:32:36,076 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: DELETE FROM t_order_item WHERE order_id = ?; ::: [2] 
   [INFO ] 2021-11-27 22:32:36,079 --main-- [ShardingSphere-SQL] Logic SQL: 
DELETE FROM t_order WHERE order_id = ?; 
   [INFO ] 2021-11-27 22:32:36,079 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLDeleteStatement(orderBy=Optional.empty, limit=Optional.empty) 
   [INFO ] 2021-11-27 22:32:36,079 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: DELETE FROM t_order WHERE order_id = ?; ::: [3] 
   [INFO ] 2021-11-27 22:32:36,081 --main-- [ShardingSphere-SQL] Logic SQL: 
DELETE FROM t_order_item WHERE order_id = ?; 
   [INFO ] 2021-11-27 22:32:36,081 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLDeleteStatement(orderBy=Optional.empty, limit=Optional.empty) 
   [INFO ] 2021-11-27 22:32:36,081 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: DELETE FROM t_order_item WHERE order_id = ?; ::: [3] 
   [INFO ] 2021-11-27 22:32:36,083 --main-- [ShardingSphere-SQL] Logic SQL: 
DELETE FROM t_order WHERE order_id = ?; 
   [INFO ] 2021-11-27 22:32:36,083 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLDeleteStatement(orderBy=Optional.empty, limit=Optional.empty) 
   [INFO ] 2021-11-27 22:32:36,083 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: DELETE FROM t_order WHERE order_id = ?; ::: [4] 
   [INFO ] 2021-11-27 22:32:36,085 --main-- [ShardingSphere-SQL] Logic SQL: 
DELETE FROM t_order_item WHERE order_id = ?; 
   [INFO ] 2021-11-27 22:32:36,085 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLDeleteStatement(orderBy=Optional.empty, limit=Optional.empty) 
   [INFO ] 2021-11-27 22:32:36,085 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: DELETE FROM t_order_item WHERE order_id = ?; ::: [4] 
   [INFO ] 2021-11-27 22:32:36,087 --main-- [ShardingSphere-SQL] Logic SQL: 
DELETE FROM t_order WHERE order_id = ?; 
   [INFO ] 2021-11-27 22:32:36,087 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLDeleteStatement(orderBy=Optional.empty, limit=Optional.empty) 
   [INFO ] 2021-11-27 22:32:36,087 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: DELETE FROM t_order WHERE order_id = ?; ::: [5] 
   [INFO ] 2021-11-27 22:32:36,089 --main-- [ShardingSphere-SQL] Logic SQL: 
DELETE FROM t_order_item WHERE order_id = ?; 
   [INFO ] 2021-11-27 22:32:36,089 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLDeleteStatement(orderBy=Optional.empty, limit=Optional.empty) 
   [INFO ] 2021-11-27 22:32:36,089 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: DELETE FROM t_order_item WHERE order_id = ?; ::: [5] 
   [INFO ] 2021-11-27 22:32:36,091 --main-- [ShardingSphere-SQL] Logic SQL: 
DELETE FROM t_order WHERE order_id = ?; 
   [INFO ] 2021-11-27 22:32:36,091 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLDeleteStatement(orderBy=Optional.empty, limit=Optional.empty) 
   [INFO ] 2021-11-27 22:32:36,091 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: DELETE FROM t_order WHERE order_id = ?; ::: [6] 
   [INFO ] 2021-11-27 22:32:36,092 --main-- [ShardingSphere-SQL] Logic SQL: 
DELETE FROM t_order_item WHERE order_id = ?; 
   [INFO ] 2021-11-27 22:32:36,093 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLDeleteStatement(orderBy=Optional.empty, limit=Optional.empty) 
   [INFO ] 2021-11-27 22:32:36,093 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: DELETE FROM t_order_item WHERE order_id = ?; ::: [6] 
   [INFO ] 2021-11-27 22:32:36,095 --main-- [ShardingSphere-SQL] Logic SQL: 
DELETE FROM t_order WHERE order_id = ?; 
   [INFO ] 2021-11-27 22:32:36,096 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLDeleteStatement(orderBy=Optional.empty, limit=Optional.empty) 
   [INFO ] 2021-11-27 22:32:36,096 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: DELETE FROM t_order WHERE order_id = ?; ::: [7] 
   [INFO ] 2021-11-27 22:32:36,098 --main-- [ShardingSphere-SQL] Logic SQL: 
DELETE FROM t_order_item WHERE order_id = ?; 
   [INFO ] 2021-11-27 22:32:36,098 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLDeleteStatement(orderBy=Optional.empty, limit=Optional.empty) 
   [INFO ] 2021-11-27 22:32:36,098 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: DELETE FROM t_order_item WHERE order_id = ?; ::: [7] 
   [INFO ] 2021-11-27 22:32:36,100 --main-- [ShardingSphere-SQL] Logic SQL: 
DELETE FROM t_order WHERE order_id = ?; 
   [INFO ] 2021-11-27 22:32:36,100 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLDeleteStatement(orderBy=Optional.empty, limit=Optional.empty) 
   [INFO ] 2021-11-27 22:32:36,100 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: DELETE FROM t_order WHERE order_id = ?; ::: [8] 
   [INFO ] 2021-11-27 22:32:36,102 --main-- [ShardingSphere-SQL] Logic SQL: 
DELETE FROM t_order_item WHERE order_id = ?; 
   [INFO ] 2021-11-27 22:32:36,102 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLDeleteStatement(orderBy=Optional.empty, limit=Optional.empty) 
   [INFO ] 2021-11-27 22:32:36,102 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: DELETE FROM t_order_item WHERE order_id = ?; ::: [8] 
   [INFO ] 2021-11-27 22:32:36,105 --main-- [ShardingSphere-SQL] Logic SQL: 
DELETE FROM t_order WHERE order_id = ?; 
   [INFO ] 2021-11-27 22:32:36,105 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLDeleteStatement(orderBy=Optional.empty, limit=Optional.empty) 
   [INFO ] 2021-11-27 22:32:36,105 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: DELETE FROM t_order WHERE order_id = ?; ::: [9] 
   [INFO ] 2021-11-27 22:32:36,108 --main-- [ShardingSphere-SQL] Logic SQL: 
DELETE FROM t_order_item WHERE order_id = ?; 
   [INFO ] 2021-11-27 22:32:36,108 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLDeleteStatement(orderBy=Optional.empty, limit=Optional.empty) 
   [INFO ] 2021-11-27 22:32:36,108 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: DELETE FROM t_order_item WHERE order_id = ?; ::: [9] 
   [INFO ] 2021-11-27 22:32:36,110 --main-- [ShardingSphere-SQL] Logic SQL: 
DELETE FROM t_order WHERE order_id = ?; 
   [INFO ] 2021-11-27 22:32:36,110 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLDeleteStatement(orderBy=Optional.empty, limit=Optional.empty) 
   [INFO ] 2021-11-27 22:32:36,110 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: DELETE FROM t_order WHERE order_id = ?; ::: [10] 
   [INFO ] 2021-11-27 22:32:36,112 --main-- [ShardingSphere-SQL] Logic SQL: 
DELETE FROM t_order_item WHERE order_id = ?; 
   [INFO ] 2021-11-27 22:32:36,112 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLDeleteStatement(orderBy=Optional.empty, limit=Optional.empty) 
   [INFO ] 2021-11-27 22:32:36,112 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: DELETE FROM t_order_item WHERE order_id = ?; ::: [10] 
   ---------------------------- Print Order Data -----------------------
   [INFO ] 2021-11-27 22:32:36,114 --main-- [ShardingSphere-SQL] Logic SQL: 
SELECT * FROM t_order; 
   [INFO ] 2021-11-27 22:32:36,114 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLSelectStatement(limit=Optional.empty, lock=Optional.empty, 
window=Optional.empty) 
   [INFO ] 2021-11-27 22:32:36,115 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: SELECT * FROM t_order; 
   ---------------------------- Print OrderItem Data -------------------
   [INFO ] 2021-11-27 22:32:36,116 --main-- [ShardingSphere-SQL] Logic SQL: 
SELECT * from t_order_item 
   [INFO ] 2021-11-27 22:32:36,116 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLSelectStatement(limit=Optional.empty, lock=Optional.empty, 
window=Optional.empty) 
   [INFO ] 2021-11-27 22:32:36,116 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: SELECT * from t_order_item 
   -------------- Process Success Finish --------------
   [INFO ] 2021-11-27 22:32:36,129 --main-- [ShardingSphere-SQL] Logic SQL: 
SELECT * FROM t_order where order_id = ?; 
   [INFO ] 2021-11-27 22:32:36,129 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLSelectStatement(limit=Optional.empty, lock=Optional.empty, 
window=Optional.empty) 
   [INFO ] 2021-11-27 22:32:36,129 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: SELECT * FROM t_order where order_id = ?; ::: [1] 
   null
   [INFO ] 2021-11-27 22:32:36,131 --main-- [ShardingSphere-SQL] Logic SQL: 
SELECT * FROM t_order where order_id = ?; 
   [INFO ] 2021-11-27 22:32:36,131 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLSelectStatement(limit=Optional.empty, lock=Optional.empty, 
window=Optional.empty) 
   [INFO ] 2021-11-27 22:32:36,131 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: SELECT * FROM t_order where order_id = ?; ::: [2] 
   null
   [INFO ] 2021-11-27 22:32:36,133 --main-- [ShardingSphere-SQL] Logic SQL: 
SELECT * FROM t_order where order_id = ?; 
   [INFO ] 2021-11-27 22:32:36,133 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLSelectStatement(limit=Optional.empty, lock=Optional.empty, 
window=Optional.empty) 
   [INFO ] 2021-11-27 22:32:36,133 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: SELECT * FROM t_order where order_id = ?; ::: [3] 
   null
   [INFO ] 2021-11-27 22:32:36,135 --main-- [ShardingSphere-SQL] Logic SQL: 
SELECT * FROM t_order where order_id = ?; 
   [INFO ] 2021-11-27 22:32:36,135 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLSelectStatement(limit=Optional.empty, lock=Optional.empty, 
window=Optional.empty) 
   [INFO ] 2021-11-27 22:32:36,135 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: SELECT * FROM t_order where order_id = ?; ::: [4] 
   null
   [INFO ] 2021-11-27 22:32:36,137 --main-- [ShardingSphere-SQL] Logic SQL: 
SELECT * FROM t_order where order_id = ?; 
   [INFO ] 2021-11-27 22:32:36,137 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLSelectStatement(limit=Optional.empty, lock=Optional.empty, 
window=Optional.empty) 
   [INFO ] 2021-11-27 22:32:36,137 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: SELECT * FROM t_order where order_id = ?; ::: [5] 
   null
   [INFO ] 2021-11-27 22:32:36,139 --main-- [ShardingSphere-SQL] Logic SQL: 
SELECT * FROM t_order where order_id = ?; 
   [INFO ] 2021-11-27 22:32:36,139 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLSelectStatement(limit=Optional.empty, lock=Optional.empty, 
window=Optional.empty) 
   [INFO ] 2021-11-27 22:32:36,139 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: SELECT * FROM t_order where order_id = ?; ::: [6] 
   null
   [INFO ] 2021-11-27 22:32:36,141 --main-- [ShardingSphere-SQL] Logic SQL: 
SELECT * FROM t_order where order_id = ?; 
   [INFO ] 2021-11-27 22:32:36,141 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLSelectStatement(limit=Optional.empty, lock=Optional.empty, 
window=Optional.empty) 
   [INFO ] 2021-11-27 22:32:36,141 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: SELECT * FROM t_order where order_id = ?; ::: [7] 
   null
   [INFO ] 2021-11-27 22:32:36,143 --main-- [ShardingSphere-SQL] Logic SQL: 
SELECT * FROM t_order where order_id = ?; 
   [INFO ] 2021-11-27 22:32:36,143 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLSelectStatement(limit=Optional.empty, lock=Optional.empty, 
window=Optional.empty) 
   [INFO ] 2021-11-27 22:32:36,143 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: SELECT * FROM t_order where order_id = ?; ::: [8] 
   null
   [INFO ] 2021-11-27 22:32:36,146 --main-- [ShardingSphere-SQL] Logic SQL: 
SELECT * FROM t_order where order_id = ?; 
   [INFO ] 2021-11-27 22:32:36,146 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLSelectStatement(limit=Optional.empty, lock=Optional.empty, 
window=Optional.empty) 
   [INFO ] 2021-11-27 22:32:36,146 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: SELECT * FROM t_order where order_id = ?; ::: [9] 
   null
   [INFO ] 2021-11-27 22:32:36,148 --main-- [ShardingSphere-SQL] Logic SQL: 
SELECT * FROM t_order where order_id = ?; 
   [INFO ] 2021-11-27 22:32:36,148 --main-- [ShardingSphere-SQL] SQLStatement: 
MySQLSelectStatement(limit=Optional.empty, lock=Optional.empty, 
window=Optional.empty) 
   [INFO ] 2021-11-27 22:32:36,148 --main-- [ShardingSphere-SQL] Actual SQL: 
read-ds-0 ::: SELECT * FROM t_order where order_id = ?; ::: [10] 
   null
   [INFO ] 2021-11-27 22:32:36,155 --main-- 
[org.springframework.context.annotation.AnnotationConfigApplicationContext] 
Closing 
org.springframework.context.annotation.AnnotationConfigApplicationContext@4567f35d:
 startup date [Sat Nov 27 22:32:28 CST 2021]; root of context hierarchy 
   [INFO ] 2021-11-27 22:32:36,157 --main-- 
[org.springframework.context.support.DefaultLifecycleProcessor] Stopping beans 
in phase 2147483647 
   [INFO ] 2021-11-27 22:32:36,158 --main-- [org.quartz.core.QuartzScheduler] 
Scheduler quartzScheduler_$_NON_CLUSTERED paused. 
   [INFO ] 2021-11-27 22:32:36,158 --main-- 
[org.springframework.scheduling.quartz.SchedulerFactoryBean] Shutting down 
Quartz Scheduler 
   [INFO ] 2021-11-27 22:32:36,158 --main-- [org.quartz.core.QuartzScheduler] 
Scheduler quartzScheduler_$_NON_CLUSTERED shutting down. 
   [INFO ] 2021-11-27 22:32:36,158 --main-- [org.quartz.core.QuartzScheduler] 
Scheduler quartzScheduler_$_NON_CLUSTERED paused. 
   [INFO ] 2021-11-27 22:32:36,158 --main-- [org.quartz.core.QuartzScheduler] 
Scheduler quartzScheduler_$_NON_CLUSTERED shutdown complete. 
   [INFO ] 2021-11-27 22:32:36,159 --main-- 
[org.springframework.jmx.export.annotation.AnnotationMBeanExporter] 
Unregistering JMX-exposed beans on shutdown 
   [INFO ] 2021-11-27 22:32:36,160 --main-- 
[com.zaxxer.hikari.HikariDataSource] HikariPool-1 - Shutdown initiated... 
   [INFO ] 2021-11-27 22:32:36,171 --main-- 
[com.zaxxer.hikari.HikariDataSource] HikariPool-1 - Shutdown completed. 
   [INFO ] 2021-11-27 22:32:36,171 --main-- 
[com.zaxxer.hikari.HikariDataSource] HikariPool-2 - Shutdown initiated... 
   [INFO ] 2021-11-27 22:32:36,179 --main-- 
[com.zaxxer.hikari.HikariDataSource] HikariPool-2 - Shutdown completed. 
   [INFO ] 2021-11-27 22:32:36,180 --main-- 
[com.zaxxer.hikari.HikariDataSource] HikariPool-3 - Shutdown initiated... 
   [INFO ] 2021-11-27 22:32:36,185 --main-- 
[com.zaxxer.hikari.HikariDataSource] HikariPool-3 - Shutdown completed. 
   
   Process finished with exit code 0
   
   
   


-- 
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-unsubscr...@shardingsphere.apache.org

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