You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/02/20 03:04:14 UTC
[GitHub] [shardingsphere] jmbkeyes opened a new issue #9447: Fail in ensuring the transaction with seata and shardingsphere-jdbc
jmbkeyes opened a new issue #9447:
URL: https://github.com/apache/shardingsphere/issues/9447
## Question
**For English only**, other languages will not accept.
I have several databases (e.g. bc2019,bc2020), and every database has 12 tables which are divided by the shard column month.
when I want to execute the sql via jdbc template to updated the all related records in all tables, I tried to use seata to ensure the transaction but without success.
below is the part of the test code. It seems that GlobalTransaction does not work as excepted, Could someone help me?
` @RequestMapping(value = "/2")
@GlobalTransactional(rollbackFor = Exception.class)
public Object getCheckInRecords2(@RequestParam(value = "rollback", defaultValue = "false")Boolean rollback) throws Exception {
String sql = "update trainee_checkin_checkout set centerId=-centerId where centerId=269 and traineeId=5";
Long ticks = System.currentTimeMillis();
jdbcTemplate.execute(sql);
System.out.println("cost:" + (System.currentTimeMillis() - ticks));
if(rollback){
throw new Exception("test");
}
return "ok";
}`
Before asking a question, make sure you have:
- Googled your question.
- Searched open and closed [GitHub issues](https://github.com/apache/shardingsphere/issues).
- Read documentation: [ShardingSphere Doc](https://shardingsphere.apache.org/document/current/en/overview).
Please pay attention on issues you submitted, because we maybe need more details.
If no response anymore and we cannot reproduce it on current information, we will **close it**.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] jmbkeyes edited a comment on issue #9447: Fail in ensuring the transaction with seata and shardingsphere-jdbc
Posted by GitBox <gi...@apache.org>.
jmbkeyes edited a comment on issue #9447:
URL: https://github.com/apache/shardingsphere/issues/9447#issuecomment-785619944
Thanks, @yu199195
About the deadlock, I add sharding column in sql, it's ok now, but not know why?
And I have another issue, use shardingsphere-jdbc with seata, some records are not rollback occasionally if exception are thrown.
I have written a demo spring boot app(https://github.com/jmbkeyes/shardingsphere-jdbc-seata-demo), attached the 3 test databases in \db\test_db_with_data.sql, and sharding-proxy config files in shardingproxy-config.
You can reproduce the issue via the following steps.
1. download the source, and open the projcect via idea
2. change db connection info in application.yml, and set the seata related configurations, change db connection info in shardingproxy config files.
3. run the spring boot app
4. access the test api http://{ip}:9090/api/test/2?rollback=true (the api just sets records' centerId=-centerId, and then raises an exception in order to rollback updates) #repeatly do this step lots of times.
5. check the changed data select * from trainee_checkin_checkout where centerId<0 via sharding-proxy
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] yu199195 edited a comment on issue #9447: Fail in ensuring the transaction with seata and shardingsphere-jdbc
Posted by GitBox <gi...@apache.org>.
yu199195 edited a comment on issue #9447:
URL: https://github.com/apache/shardingsphere/issues/9447#issuecomment-785538218
@jmbkeyes hi,
1. you must add this dependency in you pom.xml
```xml
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>shardingsphere-transaction-base-seata-at</artifactId>
<version>${shardingsphere.version}</version>
</dependency>
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>shardingsphere-jdbc-core-spring-boot-starter</artifactId>
<version>${shardingsphere.version}</version>
</dependency>
<dependency>
<groupId>io.seata</groupId>
<artifactId>seata-rm-datasource</artifactId>
<version>${seata.version}</version>
</dependency>
<dependency>
<groupId>io.seata</groupId>
<artifactId>seata-tm</artifactId>
<version>${seata.version}</version>
</dependency>
<dependency>
<groupId>io.seata</groupId>
<artifactId>seata-codec-all</artifactId>
<version>${seata.version}</version>
</dependency>
```
2. you must add this annotaion on the method, like this :
```java
@ShardingTransactionType(TransactionType.BASE)
public void you_method() {
}
```
3. if you have dead lock, may be the seata buildBeforImage UndoLog bug, you can provider issue to seata .
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] yu199195 commented on issue #9447: Fail in ensuring the transaction with seata and shardingsphere-jdbc
Posted by GitBox <gi...@apache.org>.
yu199195 commented on issue #9447:
URL: https://github.com/apache/shardingsphere/issues/9447#issuecomment-787698243
@jmbkeyes we will release 5.0.0 as soon as possible
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] yu199195 commented on issue #9447: Fail in ensuring the transaction with seata and shardingsphere-jdbc
Posted by GitBox <gi...@apache.org>.
yu199195 commented on issue #9447:
URL: https://github.com/apache/shardingsphere/issues/9447#issuecomment-785538218
@jmbkeyes hi,
1. you must add this jar in you pom.xml
```xml
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>shardingsphere-transaction-base-seata-at</artifactId>
<version>${shardingsphere.version}</version>
</dependency>
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>shardingsphere-jdbc-core-spring-boot-starter</artifactId>
<version>${shardingsphere.version}</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency>
<groupId>io.seata</groupId>
<artifactId>seata-rm-datasource</artifactId>
</dependency>
<dependency>
<groupId>io.seata</groupId>
<artifactId>seata-tm</artifactId>
<version>${seata.version}</version>
</dependency>
<dependency>
<groupId>io.seata</groupId>
<artifactId>seata-codec-all</artifactId>
<version>${seata.version}</version>
</dependency>
```
2. you must add this annotaion on the metheod， like this :
```java
@ShardingTransactionType(TransactionType.BASE)
public void you_method() {
}
```
3. if you have dead lock, may be the seata buildBeforImage UndoLog bug, you can provider issue to seata
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] yu199195 commented on issue #9447: Fail in ensuring the transaction with seata and shardingsphere-jdbc
Posted by GitBox <gi...@apache.org>.
yu199195 commented on issue #9447:
URL: https://github.com/apache/shardingsphere/issues/9447#issuecomment-785678985
@jmbkeyes HI
1. about deadlock，The fewer rows you update, the less likely you are to deadlock.
2. i have no time to see you project, you can try to work it out yourself.
3. you can see this project : [transaction-example] (https://github.com/apache/shardingsphere/tree/master/examples/shardingsphere-jdbc-example/transaction-example)
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] yu199195 edited a comment on issue #9447: Fail in ensuring the transaction with seata and shardingsphere-jdbc
Posted by GitBox <gi...@apache.org>.
yu199195 edited a comment on issue #9447:
URL: https://github.com/apache/shardingsphere/issues/9447#issuecomment-785678985
@jmbkeyes HI
1. about deadlock，The fewer rows you update, the less likely you are to deadlock.
2. i have no time to see you project, you can try to work it out yourself.
3. you can see this project [transaction-example] (https://github.com/apache/shardingsphere/tree/master/examples/shardingsphere-jdbc-example/transaction-example)
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] jmbkeyes commented on issue #9447: Fail in ensuring the transaction with seata and shardingsphere-jdbc
Posted by GitBox <gi...@apache.org>.
jmbkeyes commented on issue #9447:
URL: https://github.com/apache/shardingsphere/issues/9447#issuecomment-783874498
Thanks for your feedback.
I try to add the shard column "month" in where condition, and exception isn't thrown any more.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] yu199195 commented on issue #9447: Fail in ensuring the transaction with seata and shardingsphere-jdbc
Posted by GitBox <gi...@apache.org>.
yu199195 commented on issue #9447:
URL: https://github.com/apache/shardingsphere/issues/9447#issuecomment-783841220
@jmbkeyes XA or TCC or AT module in Seata？ you can provide question in seata community
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] jmbkeyes edited a comment on issue #9447: Fail in ensuring the transaction with seata and shardingsphere-jdbc
Posted by GitBox <gi...@apache.org>.
jmbkeyes edited a comment on issue #9447:
URL: https://github.com/apache/shardingsphere/issues/9447#issuecomment-785619944
Thanks, @yu199195
About the deadlock, I add sharding column in sql, it's ok now, but not know why?
I have another issue, use shardingsphere-jdbc with seata, some records are not rollback occasionally if exception are thrown.
I have written a demo spring boot app(https://github.com/jmbkeyes/shardingsphere-jdbc-seata-demo), attached the 3 test databases in \db\test_db_with_data.sql, and sharding-proxy config files in shardingproxy-config.
**shardingsphere-jdbc4.1.1
shardingsphere-proxy4.1.1
seata1.4.1**
You can reproduce the issue via the following steps.
1. download the source, and open the projcect via idea
2. change db connection info in application.yml, and set the seata related configurations, change db connection info in shardingproxy config files.
3. run the spring boot app
4. access the test api http://{ip}:9090/api/test/2?rollback=true (the api just sets records' centerId=-centerId, and then raises an exception in order to rollback updates) #repeatly do this step lots of times.
5. check the changed data select * from trainee_checkin_checkout where centerId<0 via sharding-proxy, rollback failed if records are returned.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] jmbkeyes edited a comment on issue #9447: Fail in ensuring the transaction with seata and shardingsphere-jdbc
Posted by GitBox <gi...@apache.org>.
jmbkeyes edited a comment on issue #9447:
URL: https://github.com/apache/shardingsphere/issues/9447#issuecomment-785619944
Thanks, @yu199195
About the deadlock, I add sharding column in sql, it's ok now, but not know why?
And I have another issue, use shardingsphere-jdbc with seata, some records are not rollback occasionally if exception are thrown.
I have written a demo spring boot app(https://github.com/jmbkeyes/shardingsphere-jdbc-seata-demo), attached the 3 test databases in \db\test_db_with_data.sql, and sharding-proxy config files in shardingproxy-config.
You can reproduce the issue via following steps.
1. download the source, and open the projcect via idea
2. change db connection info in application.yml, and set the seata related configurations, change db connection info in shardingproxy config files.
3. run the spring boot app
4. access the test api http://{ip}:9090/api/test/2?rollback=true (the api just sets records' centerId=-centerId, and then raises an exception in order to rollback updates) #repeatly do this step lots of times.
5. check the changed data select * from trainee_checkin_checkout where centerId<0 via sharding-proxy
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] terrymanu commented on issue #9447: Fail in ensuring the transaction with seata and shardingsphere-jdbc
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #9447:
URL: https://github.com/apache/shardingsphere/issues/9447#issuecomment-927255538
The seata version of ShardingSphere is 1.0.0, it is better to upgrade the version, please see #12739.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] yu199195 commented on issue #9447: Fail in ensuring the transaction with seata and shardingsphere-jdbc
Posted by GitBox <gi...@apache.org>.
yu199195 commented on issue #9447:
URL: https://github.com/apache/shardingsphere/issues/9447#issuecomment-783863529
@jmbkeyes when seata build after images undo ，mybe this data lock by other tanrsaction， you can provide question in seata community
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] jmbkeyes commented on issue #9447: Fail in ensuring the transaction with seata and shardingsphere-jdbc
Posted by GitBox <gi...@apache.org>.
jmbkeyes commented on issue #9447:
URL: https://github.com/apache/shardingsphere/issues/9447#issuecomment-787692654
@yu199195
I download the example code, and do some test, and it works as expected. I compared my demo project and the downloaded example code, the main difference is that my demo project is using (org.apache.shardingsphere:sharding-jdbc-spring-boot-starter:4.1.1,org.apache.shardingsphere:sharding-transaction-base-seata-at:4.1.1), and example code is using (org.apache.shardingsphere:shardingsphere-jdbc-core-spring-boot-starter:5.0.0-alpha,org.apache.shardingsphere:shardingsphere-transaction-base-seata-at:5.0.0-alpha). And I upgrade sharding-jdbc to 5.0.0-alpha, my demo project works as expected.
But alpha is not stable for production, right?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] jmbkeyes edited a comment on issue #9447: Fail in ensuring the transaction with seata and shardingsphere-jdbc
Posted by GitBox <gi...@apache.org>.
jmbkeyes edited a comment on issue #9447:
URL: https://github.com/apache/shardingsphere/issues/9447#issuecomment-785619944
Thanks, @yu199195
About the deadlock, I add sharding column in sql, it's ok now, but not know why?
And I have another issue, use shardingsphere-jdbc with seata, some records are not rollback occasionally if exception are thrown.
I have written a demo spring boot app(https://github.com/jmbkeyes/shardingsphere-jdbc-seata-demo), attached the 3 test databases in \db\test_db_with_data.sql, and sharding-proxy config files in shardingproxy-config.
You can reproduce the issue via the following steps.
1. download the source, and open the projcect via idea
2. change db connection info in application.yml, and set the seata related configurations, change db connection info in shardingproxy config files.
3. run the spring boot app
4. access the test api http://{ip}:9090/api/test/2?rollback=true (the api just sets records' centerId=-centerId, and then raises an exception in order to rollback updates) #repeatly do this step lots of times.
5. check the changed data select * from trainee_checkin_checkout where centerId<0 via sharding-proxy, rollback failed if records are returned.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] yu199195 edited a comment on issue #9447: Fail in ensuring the transaction with seata and shardingsphere-jdbc
Posted by GitBox <gi...@apache.org>.
yu199195 edited a comment on issue #9447:
URL: https://github.com/apache/shardingsphere/issues/9447#issuecomment-785538218
@jmbkeyes hi,
1. you must add this jar in you pom.xml
```xml
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>shardingsphere-transaction-base-seata-at</artifactId>
<version>${shardingsphere.version}</version>
</dependency>
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>shardingsphere-jdbc-core-spring-boot-starter</artifactId>
<version>${shardingsphere.version}</version>
</dependency>
<dependency>
<groupId>io.seata</groupId>
<artifactId>seata-rm-datasource</artifactId>
<version>${seata.version}</version>
</dependency>
<dependency>
<groupId>io.seata</groupId>
<artifactId>seata-tm</artifactId>
<version>${seata.version}</version>
</dependency>
<dependency>
<groupId>io.seata</groupId>
<artifactId>seata-codec-all</artifactId>
<version>${seata.version}</version>
</dependency>
```
2. you must add this annotaion on the metheod， like this :
```java
@ShardingTransactionType(TransactionType.BASE)
public void you_method() {
}
```
3. if you have dead lock, may be the seata buildBeforImage UndoLog bug, you can provider issue to seata
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] jmbkeyes commented on issue #9447: Fail in ensuring the transaction with seata and shardingsphere-jdbc
Posted by GitBox <gi...@apache.org>.
jmbkeyes commented on issue #9447:
URL: https://github.com/apache/shardingsphere/issues/9447#issuecomment-783860561
AT module in seata.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] jmbkeyes edited a comment on issue #9447: Fail in ensuring the transaction with seata and shardingsphere-jdbc
Posted by GitBox <gi...@apache.org>.
jmbkeyes edited a comment on issue #9447:
URL: https://github.com/apache/shardingsphere/issues/9447#issuecomment-785619944
Thanks, @yu199195
About the deadlock, I add sharding column in sql, it's ok now, but not know why?
I have another issue, use shardingsphere-jdbc with seata, some records are not rollback occasionally if exception are thrown.
I have written a demo spring boot app(https://github.com/jmbkeyes/shardingsphere-jdbc-seata-demo), attached the 3 test databases in \db\test_db_with_data.sql, and sharding-proxy config files in shardingproxy-config.
**Version of used middlewares：
shardingsphere-jdbc4.1.1
shardingsphere-proxy4.1.1
seata1.4.1**
You can reproduce the issue via the following steps.
1. download the source, and open the projcect via idea
2. change db connection info in application.yml, and set the seata related configurations, change db connection info in shardingproxy config files.
3. run the spring boot app
4. access the test api http://{ip}:9090/api/test/2?rollback=true (the api just sets records' centerId=-centerId, and then raises an exception in order to rollback updates) #repeatly do this step lots of times.
5. check the changed data select * from trainee_checkin_checkout where centerId<0 via sharding-proxy, rollback failed if records are returned.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] jmbkeyes edited a comment on issue #9447: Fail in ensuring the transaction with seata and shardingsphere-jdbc
Posted by GitBox <gi...@apache.org>.
jmbkeyes edited a comment on issue #9447:
URL: https://github.com/apache/shardingsphere/issues/9447#issuecomment-785619944
Thanks, @yu199195
About the deadlock, I add sharding column in sql, it's ok now, but not know why?
And I have another issue, use shardingsphere-jdbc with seata, some records are not rollback occasionally if exception are thrown.
I have written a demo spring boot app(https://github.com/jmbkeyes/shardingsphere-jdbc-seata-demo), attached the 3 test databases in \db\test_db_with_data.sql, and sharding-proxy config files in shardingproxy-config.
You can reproduce the issue via following steps.
1. download the source, and open the projcect via idea
2. change db connection info in application.yml, and set the seata related configurations, change db connection info in shardingproxy config files.
3. run the spring boot app
4. access the test api http://{ip}:9090/api/test/2?rollback=true (the api just sets records' centerId=-centerId, and then raises an exception in order to rollback updates.
5. check the changed data select * from trainee_checkin_checkout where centerId<0 via sharding-proxy
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] jmbkeyes edited a comment on issue #9447: Fail in ensuring the transaction with seata and shardingsphere-jdbc
Posted by GitBox <gi...@apache.org>.
jmbkeyes edited a comment on issue #9447:
URL: https://github.com/apache/shardingsphere/issues/9447#issuecomment-783874498
@yu199195 Thanks for your feedback.
I try to add the shard column "month" in where condition, and exception isn't thrown any more. BTW, why does the annotation @GlobalTransaction not work?
No log: Begin new global transaction
2021-02-23 13:01:17.983 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Logic SQL: update trainee_checkin_checkout set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5
2021-02-23 13:01:17.983 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : SQLStatement: UpdateStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.UpdateStatement@24f5b5eb, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@2f344c2b), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@2f344c2b)
2021-02-23 13:01:17.983 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2018 ::: update trainee_checkin_checkout_1 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2018 ::: update trainee_checkin_checkout_10 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2018 ::: update trainee_checkin_checkout_11 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2018 ::: update trainee_checkin_checkout_12 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2018 ::: update trainee_checkin_checkout_2 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2018 ::: update trainee_checkin_checkout_3 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2018 ::: update trainee_checkin_checkout_4 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2018 ::: update trainee_checkin_checkout_5 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2018 ::: update trainee_checkin_checkout_6 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2018 ::: update trainee_checkin_checkout_7 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2018 ::: update trainee_checkin_checkout_8 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2018 ::: update trainee_checkin_checkout_9 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2019 ::: update trainee_checkin_checkout_1 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2019 ::: update trainee_checkin_checkout_10 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2019 ::: update trainee_checkin_checkout_11 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2019 ::: update trainee_checkin_checkout_12 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2019 ::: update trainee_checkin_checkout_2 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2019 ::: update trainee_checkin_checkout_3 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2019 ::: update trainee_checkin_checkout_4 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2019 ::: update trainee_checkin_checkout_5 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2019 ::: update trainee_checkin_checkout_6 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2019 ::: update trainee_checkin_checkout_7 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2019 ::: update trainee_checkin_checkout_8 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2019 ::: update trainee_checkin_checkout_9 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2020 ::: update trainee_checkin_checkout_1 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2020 ::: update trainee_checkin_checkout_10 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2020 ::: update trainee_checkin_checkout_11 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2020 ::: update trainee_checkin_checkout_12 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2020 ::: update trainee_checkin_checkout_2 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2020 ::: update trainee_checkin_checkout_3 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2020 ::: update trainee_checkin_checkout_4 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2020 ::: update trainee_checkin_checkout_5 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2020 ::: update trainee_checkin_checkout_6 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2020 ::: update trainee_checkin_checkout_7 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2020 ::: update trainee_checkin_checkout_8 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2020 ::: update trainee_checkin_checkout_9 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] jmbkeyes edited a comment on issue #9447: Fail in ensuring the transaction with seata and shardingsphere-jdbc
Posted by GitBox <gi...@apache.org>.
jmbkeyes edited a comment on issue #9447:
URL: https://github.com/apache/shardingsphere/issues/9447#issuecomment-785619944
Thanks, @yu199195
About the deadlock, I add sharding column in sql, it's ok now, but not know why?
I have another issue, use shardingsphere-jdbc with seata, some records are not rollback occasionally if exception are thrown.
I have written a demo spring boot app(https://github.com/jmbkeyes/shardingsphere-jdbc-seata-demo), attached the 3 test databases in \db\test_db_with_data.sql, and sharding-proxy config files in shardingproxy-config.
**Version of used middlewares
shardingsphere-jdbc4.1.1
shardingsphere-proxy4.1.1
seata1.4.1**
You can reproduce the issue via the following steps.
1. download the source, and open the projcect via idea
2. change db connection info in application.yml, and set the seata related configurations, change db connection info in shardingproxy config files.
3. run the spring boot app
4. access the test api http://{ip}:9090/api/test/2?rollback=true (the api just sets records' centerId=-centerId, and then raises an exception in order to rollback updates) #repeatly do this step lots of times.
5. check the changed data select * from trainee_checkin_checkout where centerId<0 via sharding-proxy, rollback failed if records are returned.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] terrymanu closed issue #9447: Fail in ensuring the transaction with seata and shardingsphere-jdbc
Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #9447:
URL: https://github.com/apache/shardingsphere/issues/9447
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] jmbkeyes edited a comment on issue #9447: Fail in ensuring the transaction with seata and shardingsphere-jdbc
Posted by GitBox <gi...@apache.org>.
jmbkeyes edited a comment on issue #9447:
URL: https://github.com/apache/shardingsphere/issues/9447#issuecomment-783874498
Thanks for your feedback.
I try to add the shard column "month" in where condition, and exception isn't thrown any more. BTW, why does the annotation @GlobalTransaction not work?
No log: Begin new global transaction
2021-02-23 13:01:17.983 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Logic SQL: update trainee_checkin_checkout set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5
2021-02-23 13:01:17.983 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : SQLStatement: UpdateStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.UpdateStatement@24f5b5eb, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@2f344c2b), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@2f344c2b)
2021-02-23 13:01:17.983 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2018 ::: update trainee_checkin_checkout_1 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2018 ::: update trainee_checkin_checkout_10 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2018 ::: update trainee_checkin_checkout_11 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2018 ::: update trainee_checkin_checkout_12 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2018 ::: update trainee_checkin_checkout_2 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2018 ::: update trainee_checkin_checkout_3 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2018 ::: update trainee_checkin_checkout_4 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2018 ::: update trainee_checkin_checkout_5 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2018 ::: update trainee_checkin_checkout_6 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2018 ::: update trainee_checkin_checkout_7 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2018 ::: update trainee_checkin_checkout_8 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2018 ::: update trainee_checkin_checkout_9 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2019 ::: update trainee_checkin_checkout_1 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2019 ::: update trainee_checkin_checkout_10 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2019 ::: update trainee_checkin_checkout_11 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2019 ::: update trainee_checkin_checkout_12 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2019 ::: update trainee_checkin_checkout_2 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2019 ::: update trainee_checkin_checkout_3 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2019 ::: update trainee_checkin_checkout_4 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2019 ::: update trainee_checkin_checkout_5 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2019 ::: update trainee_checkin_checkout_6 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2019 ::: update trainee_checkin_checkout_7 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2019 ::: update trainee_checkin_checkout_8 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2019 ::: update trainee_checkin_checkout_9 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2020 ::: update trainee_checkin_checkout_1 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2020 ::: update trainee_checkin_checkout_10 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2020 ::: update trainee_checkin_checkout_11 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2020 ::: update trainee_checkin_checkout_12 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2020 ::: update trainee_checkin_checkout_2 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2020 ::: update trainee_checkin_checkout_3 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2020 ::: update trainee_checkin_checkout_4 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2020 ::: update trainee_checkin_checkout_5 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2020 ::: update trainee_checkin_checkout_6 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2020 ::: update trainee_checkin_checkout_7 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2020 ::: update trainee_checkin_checkout_8 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
2021-02-23 13:01:17.984 INFO 18588 --- [nio-9090-exec-1] ShardingSphere-SQL : Actual SQL: bocaicheckin2020 ::: update trainee_checkin_checkout_9 set centerId=-centerId where month in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and centerId=269 and traineeId=5 ::: [201601, 201602, 201603, 201604, 201605, 201606, 201607, 201608, 201609, 201610, 201611, 201612, 201701, 201702, 201703, 201704, 201705, 201706, 201707, 201708, 201709, 201710, 201711, 201712, 201801, 201802, 201803, 201804, 201805, 201806, 201807, 201808, 201809, 201810, 201811, 201812, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911, 201912, 202001, 202002, 202003, 202004, 202005, 202006, 202007, 202008, 202009, 202010, 202011, 202012]
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] jmbkeyes edited a comment on issue #9447: Fail in ensuring the transaction with seata and shardingsphere-jdbc
Posted by GitBox <gi...@apache.org>.
jmbkeyes edited a comment on issue #9447:
URL: https://github.com/apache/shardingsphere/issues/9447#issuecomment-785619944
Thanks, @yu199195
About the deadlock, I add sharding column in sql, it's ok now, but not know why?
I have another issue, use shardingsphere-jdbc with seata, some records are not rollback occasionally if exception are thrown.
I have written a demo spring boot app(https://github.com/jmbkeyes/shardingsphere-jdbc-seata-demo), attached the 3 test databases in \db\test_db_with_data.sql, and sharding-proxy config files in shardingproxy-config.
**
Version of used middlewares
shardingsphere-jdbc4.1.1
shardingsphere-proxy4.1.1
seata1.4.1**
You can reproduce the issue via the following steps.
1. download the source, and open the projcect via idea
2. change db connection info in application.yml, and set the seata related configurations, change db connection info in shardingproxy config files.
3. run the spring boot app
4. access the test api http://{ip}:9090/api/test/2?rollback=true (the api just sets records' centerId=-centerId, and then raises an exception in order to rollback updates) #repeatly do this step lots of times.
5. check the changed data select * from trainee_checkin_checkout where centerId<0 via sharding-proxy, rollback failed if records are returned.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] jmbkeyes commented on issue #9447: Fail in ensuring the transaction with seata and shardingsphere-jdbc
Posted by GitBox <gi...@apache.org>.
jmbkeyes commented on issue #9447:
URL: https://github.com/apache/shardingsphere/issues/9447#issuecomment-785619944
Thanks, @yu199195
About the deadlock, I add sharding column in sql, it's ok now, but not know why?
And I have another issue, use shardingsphere-jdbc with seata, some records are not rollback occasionally if exception are thrown.
I have written a demo spring boot app(https://github.com/jmbkeyes/shardingsphere-jdbc-seata-demo), attached the 3 test database in \db\test_db_with_data.sql, and sharding-proxy config files in shardingproxy-config.
You can reproduce the issue via following steps.
1. download the source, and open the projcect via idea
2. change db connection info in application.yml, and set the seata related configurations, change db connection info in shardingproxy config files.
3. run the spring boot app
4. access the test api http://{ip}:9090/api/test/2?rollback=true (the api just sets records' centerId=-centerId, and then raises an exception in order to rollback updates.
5. check the changed data select * from trainee_checkin_checkout where centerId<0 via sharding-proxy
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org