dongoewang opened a new issue, #6382: URL: https://github.com/apache/incubator-seata/issues/6382
<!-- Please do not use this issue template to report security vulnerabilities but refer to our [security policy](https://github.com/seata/seata/security/policy). --> - [ ] I have searched the [issues](https://github.com/seata/seata/issues) of this repository and believe that this is not a duplicate. ### Ⅰ. Issue Description in log rollback status is rollbacked，but table still have data ### Ⅱ. Describe what happened If there is an exception, please attach the exception trace: ``` Just paste your stack trace here! "C:\Program Files\Java\jdk1.8.0_361\bin\java.exe" -agentlib:jdwp=transport=dt_socket,address=127.0.0.1:62966,suspend=y,server=n -javaagent:C:\Users\dongzh\AppData\Local\JetBrains\IntelliJIdea2023.1\captureAgent\debugger-agent.jar -Dfile.encoding=UTF-8 -classpath C:\Users\dongzh\AppData\Local\Temp\classpath1750783487.jar org.apache.shardingsphere.example.sharding.jdbc.ExampleMain Connected to the target VM, address: '127.0.0.1:62966', transport: 'socket' [INFO ] 2024-02-29 09:34:49,723 --main-- [org.apache.curator.framework.imps.CuratorFrameworkImpl] Starting [INFO ] 2024-02-29 09:34:49,738 --main-- [org.apache.zookeeper.ZooKeeper] Client environment:zookeeper.version=3.7.1-a2fb57c55f8e59cdd76c34b357ad5181df1258d5, built on 2022-05-07 06:45 UTC [INFO ] 2024-02-29 09:34:49,738 --main-- [org.apache.zookeeper.ZooKeeper] Client environment:host.name=you [INFO ] 2024-02-29 09:34:49,738 --main-- [org.apache.zookeeper.ZooKeeper] Client environment:java.version=1.8.0_361 [INFO ] 2024-02-29 09:34:49,738 --main-- [org.apache.zookeeper.ZooKeeper] Client environment:java.vendor=Oracle Corporation [INFO ] 2024-02-29 09:34:49,738 --main-- [org.apache.zookeeper.ZooKeeper] Client environment:java.home=C:\Program Files\Java\jdk1.8.0_361\jre [INFO ] 2024-02-29 09:34:49,738 --main-- [org.apache.zookeeper.ZooKeeper] Client environment:java.class.path=C:\Users\dongzh\AppData\Local\Temp\classpath1750783487.jar;C:\Users\dongzh\AppData\Local\JetBrains\IntelliJIdea2023.1\captureAgent\debugger-agent.jar [INFO ] 2024-02-29 09:34:49,738 --main-- [org.apache.zookeeper.ZooKeeper] Client environment:java.library.path=C:\Program Files\Java\jdk1.8.0_361\bin;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\Program Files\Common Files\Oracle\Java\javapath;C:\Program Files\Java\jdk1.8.0_361\bin;C:\Program Files\Java\jdk1.8.0_361\jre\bin;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C;\Program Files\dotnet\;\软件\微信开发者工具\微信web开发者工具\dll;D:\软件\nodeJs\;D;\软件\nodeJs\node_global;C;\Program Files\dotnet\;D:\maven\apache-maven-3.9.0-bin\apache-maven-3.9.0\bin\;D:\Mysql\mysql-8.0.32-winx64\mysql-8.0.32-winx64\bin;D:\dongzh\installed\Git\cmd;C:\Program Files (x86)\Pandoc\;D:\dongzh\installed\Erlang OTP\bin;C:\Program Files\Docker\Docker\resources\bin;C:\Program Files\dotnet\;%ZOOKEEPER_HOME%\bin;D:\dongzh\installed\p ython\Scripts\;D:\dongzh\installed\python\;C:\Users\dongzh\AppData\Local\Microsoft\WindowsApps;;C:\Users\dongzh\AppData\Local\Programs\Microsoft VS Code\bin;. [INFO ] 2024-02-29 09:34:49,738 --main-- [org.apache.zookeeper.ZooKeeper] Client environment:java.io.tmpdir=C:\Users\dongzh\AppData\Local\Temp\ [INFO ] 2024-02-29 09:34:49,738 --main-- [org.apache.zookeeper.ZooKeeper] Client environment:java.compiler=<NA> [INFO ] 2024-02-29 09:34:49,738 --main-- [org.apache.zookeeper.ZooKeeper] Client environment:os.name=Windows 11 [INFO ] 2024-02-29 09:34:49,738 --main-- [org.apache.zookeeper.ZooKeeper] Client environment:os.arch=amd64 [INFO ] 2024-02-29 09:34:49,738 --main-- [org.apache.zookeeper.ZooKeeper] Client environment:os.version=10.0 [INFO ] 2024-02-29 09:34:49,738 --main-- [org.apache.zookeeper.ZooKeeper] Client environment:user.name=dongzh [INFO ] 2024-02-29 09:34:49,738 --main-- [org.apache.zookeeper.ZooKeeper] Client environment:user.home=C:\Users\dongzh [INFO ] 2024-02-29 09:34:49,738 --main-- [org.apache.zookeeper.ZooKeeper] Client environment:user.dir=D:\dongzh\workspace\shardingsphere-5.4.0\examples\shardingsphere-example-generator\target\generated-sources\shardingsphere-jdbc-sample\sharding--jdbc--cluster-zookeeper--base-seata [INFO ] 2024-02-29 09:34:49,738 --main-- [org.apache.zookeeper.ZooKeeper] Client environment:os.memory.free=382MB [INFO ] 2024-02-29 09:34:49,738 --main-- [org.apache.zookeeper.ZooKeeper] Client environment:os.memory.max=7214MB [INFO ] 2024-02-29 09:34:49,738 --main-- [org.apache.zookeeper.ZooKeeper] Client environment:os.memory.total=487MB [INFO ] 2024-02-29 09:34:49,741 --main-- [org.apache.zookeeper.ZooKeeper] Initiating client connection, connectString=localhost:2181 sessionTimeout=60000 watcher=org.apache.curator.ConnectionState@7fbdb894 [INFO ] 2024-02-29 09:34:49,745 --main-- [org.apache.zookeeper.common.X509Util] Setting -D jdk.tls.rejectClientInitiatedRenegotiation=true to disable client-initiated TLS renegotiation [INFO ] 2024-02-29 09:34:49,753 --main-- [org.apache.zookeeper.ClientCnxnSocket] jute.maxbuffer value is 1048575 Bytes [INFO ] 2024-02-29 09:34:49,760 --main-- [org.apache.zookeeper.ClientCnxn] zookeeper.request.timeout value is 0. feature enabled=false [INFO ] 2024-02-29 09:34:49,765 --main-SendThread(localhost:2181)-- [org.apache.zookeeper.ClientCnxn] Opening socket connection to server localhost/127.0.0.1:2181. [INFO ] 2024-02-29 09:34:49,765 --main-SendThread(localhost:2181)-- [org.apache.zookeeper.ClientCnxn] SASL config status: Will not attempt to authenticate using SASL (unknown error) [INFO ] 2024-02-29 09:34:49,766 --main-- [org.apache.curator.framework.imps.CuratorFrameworkImpl] Default schema [INFO ] 2024-02-29 09:34:49,767 --main-SendThread(localhost:2181)-- [org.apache.zookeeper.ClientCnxn] Socket connection established, initiating session, client: /127.0.0.1:62972, server: localhost/127.0.0.1:2181 [INFO ] 2024-02-29 09:34:49,814 --main-SendThread(localhost:2181)-- [org.apache.zookeeper.ClientCnxn] Session establishment complete on server localhost/127.0.0.1:2181, session id = 0x100000388a100bc, negotiated timeout = 40000 [INFO ] 2024-02-29 09:34:49,824 --main-EventThread-- [org.apache.curator.framework.state.ConnectionStateManager] State change: CONNECTED [INFO ] 2024-02-29 09:34:50,250 --main-- [com.zaxxer.hikari.HikariDataSource] HikariPool-1 - Starting... [INFO ] 2024-02-29 09:34:50,426 --main-- [com.zaxxer.hikari.HikariDataSource] HikariPool-1 - Start completed. [INFO ] 2024-02-29 09:34:51,414 --main-- [io.seata.core.rpc.netty.NettyClientBootstrap] NettyClientBootstrap has started [INFO ] 2024-02-29 09:34:51,423 --main-- [io.seata.core.rpc.netty.NettyClientChannelManager] will connect to 127.0.0.1:8091 [INFO ] 2024-02-29 09:34:51,488 --main-- [io.seata.core.rpc.netty.NettyPoolableFactory] NettyPool create channel to transactionRole:TMROLE,address:127.0.0.1:8091,msg:< RegisterTMRequest{applicationId='jdbc-test', transactionServiceGroup='my_test_tx_group'} > [WARN ] 2024-02-29 09:34:51,711 --NettyClientSelector_TMROLE_1_1-- [io.seata.common.loader.EnhancedServiceLoader$InnerEnhancedServiceLoader] Load [io.seata.serializer.hessian.HessianSerializer] class fail. com/caucho/hessian/io/AbstractHessianOutput [INFO ] 2024-02-29 09:34:51,735 --main-- [io.seata.core.rpc.netty.TmNettyRemotingClient] register TM success. client version:1.5.2, server version:1.4.0,channel:[id: 0x262f1494, L:/127.0.0.1:62978 - R:/127.0.0.1:8091] [INFO ] 2024-02-29 09:34:51,741 --main-- [io.seata.core.rpc.netty.NettyPoolableFactory] register success, cost 51 ms, version:1.4.0,role:TMROLE,channel:[id: 0x262f1494, L:/127.0.0.1:62978 - R:/127.0.0.1:8091] [INFO ] 2024-02-29 09:34:51,754 --main-- [io.seata.rm.datasource.AsyncWorker] Async Commit Buffer Limit: 10000 [INFO ] 2024-02-29 09:34:51,755 --main-- [io.seata.rm.datasource.xa.ResourceManagerXA] ResourceManagerXA init ... [INFO ] 2024-02-29 09:34:51,761 --main-- [io.seata.core.rpc.netty.NettyClientBootstrap] NettyClientBootstrap has started [INFO ] 2024-02-29 09:34:51,816 --main-- [io.seata.core.rpc.netty.NettyClientChannelManager] will connect to 127.0.0.1:8091 [INFO ] 2024-02-29 09:34:51,816 --main-- [io.seata.core.rpc.netty.RmNettyRemotingClient] RM will register :jdbc:mysql://localhost:3306/demo_ds_2 [INFO ] 2024-02-29 09:34:51,817 --main-- [io.seata.core.rpc.netty.NettyPoolableFactory] NettyPool create channel to transactionRole:RMROLE,address:127.0.0.1:8091,msg:< RegisterRMRequest{resourceIds='jdbc:mysql://localhost:3306/demo_ds_2', applicationId='jdbc-test', transactionServiceGroup='my_test_tx_group'} > [INFO ] 2024-02-29 09:34:51,821 --main-- [io.seata.core.rpc.netty.RmNettyRemotingClient] register RM success. client version:1.5.2, server version:1.4.0,channel:[id: 0x98bc22f7, L:/127.0.0.1:62981 - R:/127.0.0.1:8091] [INFO ] 2024-02-29 09:34:51,821 --main-- [io.seata.core.rpc.netty.NettyPoolableFactory] register success, cost 3 ms, version:1.4.0,role:RMROLE,channel:[id: 0x98bc22f7, L:/127.0.0.1:62981 - R:/127.0.0.1:8091] [INFO ] 2024-02-29 09:34:51,829 --main-- [io.seata.core.rpc.netty.RmNettyRemotingClient] will register resourceId:jdbc:mysql://localhost:3306/demo_ds_2 [INFO ] 2024-02-29 09:34:51,831 --main-- [io.seata.core.rpc.netty.RmNettyRemotingClient] will register resourceId:jdbc:mysql://localhost:3306/demo_ds_2 [INFO ] 2024-02-29 09:34:51,831 --NettyClientSelector_RMROLE_1_1-- [io.seata.rm.AbstractRMHandler] the rm client received response msg [version=1.4.0,extraData=null,identified=true,resultCode=null,msg=null] from tc server. [INFO ] 2024-02-29 09:34:51,833 --NettyClientSelector_RMROLE_1_1-- [io.seata.rm.AbstractRMHandler] the rm client received response msg [version=1.4.0,extraData=null,identified=true,resultCode=null,msg=null] from tc server. [INFO ] 2024-02-29 09:34:52,064 --rpcDispatch_RMROLE_1_1_24-- [io.seata.core.rpc.processor.client.RmBranchRollbackProcessor] rm handle branch rollback process:xid=10.168.8.120:8091:506171276403376128,branchId=506171280484433920,branchType=AT,resourceId=jdbc:mysql://localhost:3306/demo_ds_2,applicationData={"skipCheckLock":true} [INFO ] 2024-02-29 09:34:52,065 --rpcDispatch_RMROLE_1_1_24-- [io.seata.rm.AbstractRMHandler] Branch Rollbacking: 10.168.8.120:8091:506171276403376128 506171280484433920 jdbc:mysql://localhost:3306/demo_ds_2 [WARN ] 2024-02-29 09:34:52,130 --rpcDispatch_RMROLE_1_1_24-- [io.seata.common.loader.EnhancedServiceLoader$InnerEnhancedServiceLoader] Load [io.seata.rm.datasource.undo.parser.ProtostuffUndoLogParser] class fail. io/protostuff/runtime/IdStrategy [INFO ] 2024-02-29 09:34:52,315 --rpcDispatch_RMROLE_1_1_24-- [io.seata.rm.datasource.undo.AbstractUndoLogManager] xid 10.168.8.120:8091:506171276403376128 branch 506171280484433920, undo_log added with GlobalFinished [INFO ] 2024-02-29 09:34:52,316 --rpcDispatch_RMROLE_1_1_24-- [io.seata.rm.AbstractRMHandler] Branch Rollbacked result: PhaseTwo_Rollbacked [INFO ] 2024-02-29 09:34:52,993 --main-- [org.apache.curator.utils.Compatibility] Using org.apache.zookeeper.server.quorum.MultipleAddresses [INFO ] 2024-02-29 09:34:53,651 --main-- [ShardingSphere-SQL] Logic SQL: CREATE TABLE IF NOT EXISTS t_order (order_id BIGINT NOT NULL AUTO_INCREMENT, order_type INT(11), user_id INT NOT NULL, address_id BIGINT NOT NULL, status VARCHAR(50), PRIMARY KEY (order_id)) [INFO ] 2024-02-29 09:34:53,651 --main-- [ShardingSphere-SQL] Actual SQL: ds_2 ::: CREATE TABLE IF NOT EXISTS t_order (order_id BIGINT NOT NULL AUTO_INCREMENT, order_type INT(11), user_id INT NOT NULL, address_id BIGINT NOT NULL, status VARCHAR(50), PRIMARY KEY (order_id)) [INFO ] 2024-02-29 09:34:53,651 --main-- [ShardingSphere-SQL] Actual SQL: ds_1 ::: CREATE TABLE IF NOT EXISTS t_order (order_id BIGINT NOT NULL AUTO_INCREMENT, order_type INT(11), user_id INT NOT NULL, address_id BIGINT NOT NULL, status VARCHAR(50), PRIMARY KEY (order_id)) [INFO ] 2024-02-29 09:34:53,651 --main-- [ShardingSphere-SQL] Actual SQL: ds_0 ::: CREATE TABLE IF NOT EXISTS t_order (order_id BIGINT NOT NULL AUTO_INCREMENT, order_type INT(11), user_id INT NOT NULL, address_id BIGINT NOT NULL, status VARCHAR(50), PRIMARY KEY (order_id)) [INFO ] 2024-02-29 09:34:53,858 --main-- [ShardingSphere-SQL] Logic SQL: CREATE TABLE IF NOT EXISTS t_order_item (order_item_id BIGINT NOT NULL AUTO_INCREMENT, order_id BIGINT NOT NULL, user_id INT NOT NULL, phone VARCHAR(50), status VARCHAR(50), PRIMARY KEY (order_item_id)) [INFO ] 2024-02-29 09:34:53,858 --main-- [ShardingSphere-SQL] Actual SQL: ds_2 ::: CREATE TABLE IF NOT EXISTS t_order_item (order_item_id BIGINT NOT NULL AUTO_INCREMENT, order_id BIGINT NOT NULL, user_id INT NOT NULL, phone VARCHAR(50), status VARCHAR(50), PRIMARY KEY (order_item_id)) [INFO ] 2024-02-29 09:34:53,858 --main-- [ShardingSphere-SQL] Actual SQL: ds_1 ::: CREATE TABLE IF NOT EXISTS t_order_item (order_item_id BIGINT NOT NULL AUTO_INCREMENT, order_id BIGINT NOT NULL, user_id INT NOT NULL, phone VARCHAR(50), status VARCHAR(50), PRIMARY KEY (order_item_id)) [INFO ] 2024-02-29 09:34:53,858 --main-- [ShardingSphere-SQL] Actual SQL: ds_0 ::: CREATE TABLE IF NOT EXISTS t_order_item (order_item_id BIGINT NOT NULL AUTO_INCREMENT, order_id BIGINT NOT NULL, user_id INT NOT NULL, phone VARCHAR(50), status VARCHAR(50), PRIMARY KEY (order_item_id)) [INFO ] 2024-02-29 09:34:53,949 --main-- [ShardingSphere-SQL] Logic SQL: CREATE TABLE IF NOT EXISTS t_address (address_id BIGINT NOT NULL, address_name VARCHAR(100) NOT NULL, PRIMARY KEY (address_id)) [INFO ] 2024-02-29 09:34:53,949 --main-- [ShardingSphere-SQL] Actual SQL: ds_0 ::: CREATE TABLE IF NOT EXISTS t_address (address_id BIGINT NOT NULL, address_name VARCHAR(100) NOT NULL, PRIMARY KEY (address_id)) [INFO ] 2024-02-29 09:34:54,252 --main-- [ShardingSphere-SQL] Logic SQL: TRUNCATE TABLE t_order [INFO ] 2024-02-29 09:34:54,252 --main-- [ShardingSphere-SQL] Actual SQL: ds_2 ::: TRUNCATE TABLE t_order [INFO ] 2024-02-29 09:34:54,252 --main-- [ShardingSphere-SQL] Actual SQL: ds_1 ::: TRUNCATE TABLE t_order [INFO ] 2024-02-29 09:34:54,252 --main-- [ShardingSphere-SQL] Actual SQL: ds_0 ::: TRUNCATE TABLE t_order [INFO ] 2024-02-29 09:34:54,274 --main-- [ShardingSphere-SQL] Logic SQL: TRUNCATE TABLE t_order_item [INFO ] 2024-02-29 09:34:54,274 --main-- [ShardingSphere-SQL] Actual SQL: ds_2 ::: TRUNCATE TABLE t_order_item [INFO ] 2024-02-29 09:34:54,274 --main-- [ShardingSphere-SQL] Actual SQL: ds_1 ::: TRUNCATE TABLE t_order_item [INFO ] 2024-02-29 09:34:54,274 --main-- [ShardingSphere-SQL] Actual SQL: ds_0 ::: TRUNCATE TABLE t_order_item [INFO ] 2024-02-29 09:34:54,292 --main-- [ShardingSphere-SQL] Logic SQL: TRUNCATE TABLE t_address [INFO ] 2024-02-29 09:34:54,293 --main-- [ShardingSphere-SQL] Actual SQL: ds_0 ::: TRUNCATE TABLE t_address [INFO ] 2024-02-29 09:34:54,304 --main-- [org.apache.shardingsphere.example.sharding.jdbc.service.ExampleService] -------------- Process Success Begin --------------- [INFO ] 2024-02-29 09:34:54,304 --main-- [org.apache.shardingsphere.example.sharding.jdbc.service.ExampleService] ---------------------------- Insert Data ---------------------------- [INFO ] 2024-02-29 09:34:54,393 --main-- [io.seata.tm.TransactionManagerHolder] TransactionManager Singleton io.seata.tm.DefaultTransactionManager@6d4c7248 [INFO ] 2024-02-29 09:34:54,398 --main-- [io.seata.tm.api.DefaultGlobalTransaction] Begin new global transaction [10.168.8.120:8091:506400528226811904] [INFO ] 2024-02-29 09:34:55,104 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_order (user_id, order_type, address_id, status) VALUES (?, ?, ?, ?) [INFO ] 2024-02-29 09:34:55,104 --main-- [ShardingSphere-SQL] Actual SQL: ds_1 ::: INSERT INTO t_order (user_id, order_type, address_id, status, order_id) VALUES (?, ?, ?, ?, ?) ::: [1, 1, 1, INSERT_TEST, 969894608366469120] [INFO ] 2024-02-29 09:34:55,440 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_order_item (order_id, user_id, phone, status) VALUES (?, ?, ?, ?) [INFO ] 2024-02-29 09:34:55,440 --main-- [ShardingSphere-SQL] Actual SQL: ds_1 ::: INSERT INTO t_order_item (order_id, user_id, phone, status, order_item_id) VALUES (?, ?, ?, ?, ?) ::: [969894608366469120, 1, 13800000001, INSERT_TEST, 969894612707573760] [INFO ] 2024-02-29 09:34:55,449 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_address (address_id, address_name) VALUES (?, ?) [INFO ] 2024-02-29 09:34:55,449 --main-- [ShardingSphere-SQL] Actual SQL: ds_0 ::: INSERT INTO t_address (address_id, address_name) VALUES (?, ?) ::: [1, address_test_1] [INFO ] 2024-02-29 09:34:55,455 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_order (user_id, order_type, address_id, status) VALUES (?, ?, ?, ?) [INFO ] 2024-02-29 09:34:55,455 --main-- [ShardingSphere-SQL] Actual SQL: ds_0 ::: INSERT INTO t_order (user_id, order_type, address_id, status, order_id) VALUES (?, ?, ?, ?, ?) ::: [2, 0, 2, INSERT_TEST, 969894612766294017] [INFO ] 2024-02-29 09:34:55,458 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_order_item (order_id, user_id, phone, status) VALUES (?, ?, ?, ?) [INFO ] 2024-02-29 09:34:55,459 --main-- [ShardingSphere-SQL] Actual SQL: ds_0 ::: INSERT INTO t_order_item (order_id, user_id, phone, status, order_item_id) VALUES (?, ?, ?, ?, ?) ::: [969894612766294017, 2, 13800000001, INSERT_TEST, 969894612783071232] [INFO ] 2024-02-29 09:34:55,461 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_address (address_id, address_name) VALUES (?, ?) [INFO ] 2024-02-29 09:34:55,461 --main-- [ShardingSphere-SQL] Actual SQL: ds_0 ::: INSERT INTO t_address (address_id, address_name) VALUES (?, ?) ::: [2, address_test_2] [INFO ] 2024-02-29 09:34:55,463 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_order (user_id, order_type, address_id, status) VALUES (?, ?, ?, ?) [INFO ] 2024-02-29 09:34:55,463 --main-- [ShardingSphere-SQL] Actual SQL: ds_1 ::: INSERT INTO t_order (user_id, order_type, address_id, status, order_id) VALUES (?, ?, ?, ?, ?) ::: [3, 1, 3, INSERT_TEST, 969894612804042753] [INFO ] 2024-02-29 09:34:55,466 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_order_item (order_id, user_id, phone, status) VALUES (?, ?, ?, ?) [INFO ] 2024-02-29 09:34:55,466 --main-- [ShardingSphere-SQL] Actual SQL: ds_1 ::: INSERT INTO t_order_item (order_id, user_id, phone, status, order_item_id) VALUES (?, ?, ?, ?, ?) ::: [969894612804042753, 3, 13800000001, INSERT_TEST, 969894612812431360] [INFO ] 2024-02-29 09:34:55,468 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_address (address_id, address_name) VALUES (?, ?) [INFO ] 2024-02-29 09:34:55,468 --main-- [ShardingSphere-SQL] Actual SQL: ds_0 ::: INSERT INTO t_address (address_id, address_name) VALUES (?, ?) ::: [3, address_test_3] [INFO ] 2024-02-29 09:34:55,470 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_order (user_id, order_type, address_id, status) VALUES (?, ?, ?, ?) [INFO ] 2024-02-29 09:34:55,470 --main-- [ShardingSphere-SQL] Actual SQL: ds_0 ::: INSERT INTO t_order (user_id, order_type, address_id, status, order_id) VALUES (?, ?, ?, ?, ?) ::: [4, 0, 4, INSERT_TEST, 969894612833402881] [INFO ] 2024-02-29 09:34:55,472 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_order_item (order_id, user_id, phone, status) VALUES (?, ?, ?, ?) [INFO ] 2024-02-29 09:34:55,472 --main-- [ShardingSphere-SQL] Actual SQL: ds_0 ::: INSERT INTO t_order_item (order_id, user_id, phone, status, order_item_id) VALUES (?, ?, ?, ?, ?) ::: [969894612833402881, 4, 13800000001, INSERT_TEST, 969894612841791488] [INFO ] 2024-02-29 09:34:55,474 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_address (address_id, address_name) VALUES (?, ?) [INFO ] 2024-02-29 09:34:55,474 --main-- [ShardingSphere-SQL] Actual SQL: ds_0 ::: INSERT INTO t_address (address_id, address_name) VALUES (?, ?) ::: [4, address_test_4] [INFO ] 2024-02-29 09:34:55,475 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_order (user_id, order_type, address_id, status) VALUES (?, ?, ?, ?) [INFO ] 2024-02-29 09:34:55,475 --main-- [ShardingSphere-SQL] Actual SQL: ds_1 ::: INSERT INTO t_order (user_id, order_type, address_id, status, order_id) VALUES (?, ?, ?, ?, ?) ::: [5, 1, 5, INSERT_TEST, 969894612854374401] [INFO ] 2024-02-29 09:34:55,478 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_order_item (order_id, user_id, phone, status) VALUES (?, ?, ?, ?) [INFO ] 2024-02-29 09:34:55,478 --main-- [ShardingSphere-SQL] Actual SQL: ds_1 ::: INSERT INTO t_order_item (order_id, user_id, phone, status, order_item_id) VALUES (?, ?, ?, ?, ?) ::: [969894612854374401, 5, 13800000001, INSERT_TEST, 969894612862763008] [INFO ] 2024-02-29 09:34:55,480 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_address (address_id, address_name) VALUES (?, ?) [INFO ] 2024-02-29 09:34:55,480 --main-- [ShardingSphere-SQL] Actual SQL: ds_0 ::: INSERT INTO t_address (address_id, address_name) VALUES (?, ?) ::: [5, address_test_5] [INFO ] 2024-02-29 09:34:55,482 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_order (user_id, order_type, address_id, status) VALUES (?, ?, ?, ?) [INFO ] 2024-02-29 09:34:55,483 --main-- [ShardingSphere-SQL] Actual SQL: ds_0 ::: INSERT INTO t_order (user_id, order_type, address_id, status, order_id) VALUES (?, ?, ?, ?, ?) ::: [6, 0, 6, INSERT_TEST, 969894612883734529] [INFO ] 2024-02-29 09:34:55,485 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_order_item (order_id, user_id, phone, status) VALUES (?, ?, ?, ?) [INFO ] 2024-02-29 09:34:55,485 --main-- [ShardingSphere-SQL] Actual SQL: ds_0 ::: INSERT INTO t_order_item (order_id, user_id, phone, status, order_item_id) VALUES (?, ?, ?, ?, ?) ::: [969894612883734529, 6, 13800000001, INSERT_TEST, 969894612892123136] [INFO ] 2024-02-29 09:34:55,486 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_address (address_id, address_name) VALUES (?, ?) [INFO ] 2024-02-29 09:34:55,486 --main-- [ShardingSphere-SQL] Actual SQL: ds_0 ::: INSERT INTO t_address (address_id, address_name) VALUES (?, ?) ::: [6, address_test_6] [INFO ] 2024-02-29 09:34:55,488 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_order (user_id, order_type, address_id, status) VALUES (?, ?, ?, ?) [INFO ] 2024-02-29 09:34:55,488 --main-- [ShardingSphere-SQL] Actual SQL: ds_1 ::: INSERT INTO t_order (user_id, order_type, address_id, status, order_id) VALUES (?, ?, ?, ?, ?) ::: [7, 1, 7, INSERT_TEST, 969894612908900353] [INFO ] 2024-02-29 09:34:55,490 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_order_item (order_id, user_id, phone, status) VALUES (?, ?, ?, ?) [INFO ] 2024-02-29 09:34:55,490 --main-- [ShardingSphere-SQL] Actual SQL: ds_1 ::: INSERT INTO t_order_item (order_id, user_id, phone, status, order_item_id) VALUES (?, ?, ?, ?, ?) ::: [969894612908900353, 7, 13800000001, INSERT_TEST, 969894612917288960] [INFO ] 2024-02-29 09:34:55,491 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_address (address_id, address_name) VALUES (?, ?) [INFO ] 2024-02-29 09:34:55,491 --main-- [ShardingSphere-SQL] Actual SQL: ds_0 ::: INSERT INTO t_address (address_id, address_name) VALUES (?, ?) ::: [7, address_test_7] [INFO ] 2024-02-29 09:34:55,493 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_order (user_id, order_type, address_id, status) VALUES (?, ?, ?, ?) [INFO ] 2024-02-29 09:34:55,493 --main-- [ShardingSphere-SQL] Actual SQL: ds_0 ::: INSERT INTO t_order (user_id, order_type, address_id, status, order_id) VALUES (?, ?, ?, ?, ?) ::: [8, 0, 8, INSERT_TEST, 969894612925677569] [INFO ] 2024-02-29 09:34:55,495 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_order_item (order_id, user_id, phone, status) VALUES (?, ?, ?, ?) [INFO ] 2024-02-29 09:34:55,495 --main-- [ShardingSphere-SQL] Actual SQL: ds_0 ::: INSERT INTO t_order_item (order_id, user_id, phone, status, order_item_id) VALUES (?, ?, ?, ?, ?) ::: [969894612925677569, 8, 13800000001, INSERT_TEST, 969894612934066176] [INFO ] 2024-02-29 09:34:55,496 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_address (address_id, address_name) VALUES (?, ?) [INFO ] 2024-02-29 09:34:55,496 --main-- [ShardingSphere-SQL] Actual SQL: ds_0 ::: INSERT INTO t_address (address_id, address_name) VALUES (?, ?) ::: [8, address_test_8] [INFO ] 2024-02-29 09:34:55,498 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_order (user_id, order_type, address_id, status) VALUES (?, ?, ?, ?) [INFO ] 2024-02-29 09:34:55,498 --main-- [ShardingSphere-SQL] Actual SQL: ds_1 ::: INSERT INTO t_order (user_id, order_type, address_id, status, order_id) VALUES (?, ?, ?, ?, ?) ::: [9, 1, 9, INSERT_TEST, 969894612950843393] [INFO ] 2024-02-29 09:34:55,500 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_order_item (order_id, user_id, phone, status) VALUES (?, ?, ?, ?) [INFO ] 2024-02-29 09:34:55,500 --main-- [ShardingSphere-SQL] Actual SQL: ds_1 ::: INSERT INTO t_order_item (order_id, user_id, phone, status, order_item_id) VALUES (?, ?, ?, ?, ?) ::: [969894612950843393, 9, 13800000001, INSERT_TEST, 969894612955037696] [INFO ] 2024-02-29 09:34:55,501 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_address (address_id, address_name) VALUES (?, ?) [INFO ] 2024-02-29 09:34:55,501 --main-- [ShardingSphere-SQL] Actual SQL: ds_0 ::: INSERT INTO t_address (address_id, address_name) VALUES (?, ?) ::: [9, address_test_9] [INFO ] 2024-02-29 09:34:55,503 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_order (user_id, order_type, address_id, status) VALUES (?, ?, ?, ?) [INFO ] 2024-02-29 09:34:55,503 --main-- [ShardingSphere-SQL] Actual SQL: ds_0 ::: INSERT INTO t_order (user_id, order_type, address_id, status, order_id) VALUES (?, ?, ?, ?, ?) ::: [10, 0, 10, INSERT_TEST, 969894612967620609] [INFO ] 2024-02-29 09:34:55,504 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_order_item (order_id, user_id, phone, status) VALUES (?, ?, ?, ?) [INFO ] 2024-02-29 09:34:55,504 --main-- [ShardingSphere-SQL] Actual SQL: ds_0 ::: INSERT INTO t_order_item (order_id, user_id, phone, status, order_item_id) VALUES (?, ?, ?, ?, ?) ::: [969894612967620609, 10, 13800000001, INSERT_TEST, 969894612976009216] [INFO ] 2024-02-29 09:34:55,505 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_address (address_id, address_name) VALUES (?, ?) [INFO ] 2024-02-29 09:34:55,505 --main-- [ShardingSphere-SQL] Actual SQL: ds_0 ::: INSERT INTO t_address (address_id, address_name) VALUES (?, ?) ::: [10, address_test_10] [INFO ] 2024-02-29 09:34:55,509 --rpcDispatch_RMROLE_1_2_24-- [io.seata.core.rpc.processor.client.RmBranchRollbackProcessor] rm handle branch rollback process:xid=10.168.8.120:8091:506400528226811904,branchId=506400532161069056,branchType=AT,resourceId=jdbc:mysql://localhost:3306/demo_ds_2,applicationData={"skipCheckLock":true} [INFO ] 2024-02-29 09:34:55,509 --rpcDispatch_RMROLE_1_2_24-- [io.seata.rm.AbstractRMHandler] Branch Rollbacking: 10.168.8.120:8091:506400528226811904 506400532161069056 jdbc:mysql://localhost:3306/demo_ds_2 [INFO ] 2024-02-29 09:34:55,512 --rpcDispatch_RMROLE_1_2_24-- [io.seata.rm.datasource.undo.AbstractUndoLogManager] xid 10.168.8.120:8091:506400528226811904 branch 506400532161069056, undo_log added with GlobalFinished [INFO ] 2024-02-29 09:34:55,512 --rpcDispatch_RMROLE_1_2_24-- [io.seata.rm.AbstractRMHandler] Branch Rollbacked result: PhaseTwo_Rollbacked [INFO ] 2024-02-29 09:34:55,514 --main-- [io.seata.tm.api.DefaultGlobalTransaction] Suspending current transaction, xid = 10.168.8.120:8091:506400528226811904 [INFO ] 2024-02-29 09:34:55,515 --main-- [io.seata.tm.api.DefaultGlobalTransaction] [10.168.8.120:8091:506400528226811904] rollback status: Rollbacked ### Ⅲ. Describe what you expected to happen ### Ⅳ. How to reproduce it (as minimally and precisely as possible) 1：please create db demo_ds_0, demo_ds_1, demo_ds_2 2：create table 【undo_log】 CREATE TABLE IF NOT EXISTS undo_log ( branch_id BIGINT NOT NULL COMMENT 'branch transaction id', xid VARCHAR(128) NOT NULL COMMENT 'global transaction id', context VARCHAR(128) NOT NULL COMMENT 'undo_log context,such as serialization', rollback_info LONGBLOB NOT NULL COMMENT 'rollback info', log_status INT(11) NOT NULL COMMENT '0:normal status,1:defense status', log_created DATETIME(6) NOT NULL COMMENT 'create datetime', log_modified DATETIME(6) NOT NULL COMMENT 'modify datetime', UNIQUE KEY ux_undo_log (xid, branch_id) ) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARSET = utf8mb4 COMMENT ='AT transaction mode undo table'; ALTER TABLE undo_log ADD INDEX ix_log_created (log_created); 3：git clone sample：https://github.com/dongoewang/sharding--jdbc--cluster-zookeeper--base-seata.git 4：modify configure.java  Minimal yet complete reproducer code (or URL to code): ### Ⅴ. Anything else we need to know? ### Ⅵ. Environment: - JDK version(e.g. `java -version`): - jdk 8 - Seata client/server version: - 1.5.2 - Database version:mysql 8.0.1 - OS(e.g. `uname -a`): - Others: -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
