kpioneer123 commented on issue #7380: URL: https://github.com/apache/shardingsphere/issues/7380#issuecomment-707578395
``` 16:21:46.289 INFO [rpcDispatch_RMROLE_1_2_16] io.seata.core.rpc.processor.client.RmBranchRollbackProcessor - rm handle branch rollback process:xid=39.106.112.246:8091:59316262546804736,branchId=59316289696534528,branchType=AT,resourceId=jdbc:mysql://rdsql815s2568iryqn93o.mysql.rds.aliyuncs.com:3306/bookdb,applicationData=null 16:21:46.289 INFO [rpcDispatch_RMROLE_1_2_16] io.seata.rm.AbstractRMHandler - Branch Rollbacking: 39.106.112.246:8091:59316262546804736 59316289696534528 jdbc:mysql://rdsql815s2568iryqn93o.mysql.rds.aliyuncs.com:3306/bookdb 16:21:46.289 INFO [rpcDispatch_RMROLE_1_2_16] ShardingSphere-SQL - Logic SQL: SELECT * FROM undo_log WHERE branch_id = ? AND xid = ? FOR UPDATE 16:21:46.289 INFO [rpcDispatch_RMROLE_1_2_16] ShardingSphere-SQL - SQLStatement: SelectStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.SelectStatement@2288caf6, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@455b880b), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@455b880b, projectionsContext=ProjectionsContext(startIndex=7, stopIndex=7, distinctRow=false, projections=[ShorthandProjection(owner=Optional.empty, actualColumns=[ColumnProjection(owner=null, name=id, alias=Optional.empty), ColumnProjection(owner=null, name=branch_id, alias=Optional.empty), ColumnProjection(owner=null, name=xid, alias=Optional.empty), ColumnProjection(owner=null, name=context, alias=Optional.empty), ColumnProjection(owner=null, name=rollback_info, alias=Optional.empty), ColumnProjection(owner=null, name=log_status, alias=Optional.empty), ColumnProjection( owner=null, name=log_created, alias=Optional.empty), ColumnProjection(owner=null, name=log_modified, alias=Optional.empty)])]), groupByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.groupby.GroupByContext@4b9c6ed0, orderByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.orderby.OrderByContext@4fa3e37b, paginationContext=org.apache.shardingsphere.sql.parser.binder.segment.select.pagination.PaginationContext@aa164eb, containsSubquery=false) 16:21:46.290 INFO [rpcDispatch_RMROLE_1_2_16] ShardingSphere-SQL - Actual SQL: master ::: SELECT * FROM undo_log WHERE branch_id = ? AND xid = ? FOR UPDATE ::: [59316289696534528, 39.106.112.246:8091:59316262546804736] 16:21:46.299 INFO [rpcDispatch_RMROLE_1_2_16] ShardingSphere-SQL - Logic SQL: INSERT INTO undo_log (branch_id, xid, context, rollback_info, log_status, log_created, log_modified) VALUES (?, ?, ?, ?, ?, now(6), now(6)) 16:21:46.299 INFO [rpcDispatch_RMROLE_1_2_16] ShardingSphere-SQL - SQLStatement: InsertStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.InsertStatement@1752ab9b, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@6b093c12), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@6b093c12, columnNames=[branch_id, xid, context, rollback_info, log_status, log_created, log_modified], insertValueContexts=[InsertValueContext(parametersCount=5, valueExpressions=[ParameterMarkerExpressionSegment(startIndex=109, stopIndex=109, parameterMarkerIndex=0), ParameterMarkerExpressionSegment(startIndex=112, stopIndex=112, parameterMarkerIndex=1), ParameterMarkerExpressionSegment(startIndex=115, stopIndex=115, parameterMarkerIndex=2), ParameterMarkerExpressionSegment(startIndex=118, stopIndex=118, parameterMarkerIndex=3), ParameterMarkerExpressionSegment(startIndex =121, stopIndex=121, parameterMarkerIndex=4), org.apache.shardingsphere.sql.parser.sql.segment.dml.item.ExpressionProjectionSegment@76b93bb9, org.apache.shardingsphere.sql.parser.sql.segment.dml.item.ExpressionProjectionSegment@398f6f04], parameters=[59316289696534528, 39.106.112.246:8091:59316262546804736, serializer=jackson, javax.sql.rowset.serial.SerialBlob@484b02, 1])], generatedKeyContext=Optional.empty) 16:21:46.299 INFO [rpcDispatch_RMROLE_1_2_16] ShardingSphere-SQL - Actual SQL: master ::: INSERT INTO undo_log (branch_id, xid, context, rollback_info, log_status, log_created, log_modified) VALUES (?, ?, ?, ?, ?, now(6), now(6)) ::: [59316289696534528, 39.106.112.246:8091:59316262546804736, serializer=jackson, javax.sql.rowset.serial.SerialBlob@484b02, 1] 16:21:46.308 INFO [rpcDispatch_RMROLE_1_2_16] io.seata.rm.datasource.undo.AbstractUndoLogManager - xid 39.106.112.246:8091:59316262546804736 branch 59316289696534528, undo_log added with GlobalFinished 16:21:46.316 INFO [rpcDispatch_RMROLE_1_2_16] io.seata.rm.AbstractRMHandler - Branch Rollbacked result: PhaseTwo_Rollbacked 16:21:46.316 DEBUG [rpcDispatch_RMROLE_1_2_16] io.seata.core.rpc.processor.client.RmBranchRollbackProcessor - branch rollback result:xid=39.106.112.246:8091:59316262546804736,branchId=59316289696534528,branchStatus=PhaseTwo_Rollbacked,result code =Success,getMsg =null 16:21:46.316 DEBUG [rpcDispatch_RMROLE_1_2_16] io.seata.core.rpc.netty.AbstractNettyRemoting - write message:xid=39.106.112.246:8091:59316262546804736,branchId=59316289696534528,branchStatus=PhaseTwo_Rollbacked,result code =Success,getMsg =null, channel:[id: 0x8fc0eea4, L:/10.1.1.125:57843 - R:/39.106.112.246:8091],active?true,writable?true,isopen?true 16:21:46.323 DEBUG [NettyClientSelector_RMROLE_1_1] io.seata.core.rpc.netty.AbstractNettyRemoting - io.seata.core.rpc.netty.RmNettyRemotingClient@3020083c msgId:12, body:xid=39.106.112.246:8091:59316262546804736,branchId=59316288803147776,branchType=AT,resourceId=jdbc:mysql://rdsql815s2568iryqn93o.mysql.rds.aliyuncs.com:3306/sharding_2,applicationData=null 16:21:46.323 INFO [rpcDispatch_RMROLE_1_3_16] io.seata.core.rpc.processor.client.RmBranchRollbackProcessor - rm handle branch rollback process:xid=39.106.112.246:8091:59316262546804736,branchId=59316288803147776,branchType=AT,resourceId=jdbc:mysql://rdsql815s2568iryqn93o.mysql.rds.aliyuncs.com:3306/sharding_2,applicationData=null 16:21:46.323 INFO [rpcDispatch_RMROLE_1_3_16] io.seata.rm.AbstractRMHandler - Branch Rollbacking: 39.106.112.246:8091:59316262546804736 59316288803147776 jdbc:mysql://rdsql815s2568iryqn93o.mysql.rds.aliyuncs.com:3306/sharding_2 16:21:46.323 INFO [rpcDispatch_RMROLE_1_3_16] ShardingSphere-SQL - Logic SQL: SELECT * FROM undo_log WHERE branch_id = ? AND xid = ? FOR UPDATE 16:21:46.323 INFO [rpcDispatch_RMROLE_1_3_16] ShardingSphere-SQL - SQLStatement: SelectStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.SelectStatement@2288caf6, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@421f9cc3), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@421f9cc3, projectionsContext=ProjectionsContext(startIndex=7, stopIndex=7, distinctRow=false, projections=[ShorthandProjection(owner=Optional.empty, actualColumns=[])]), groupByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.groupby.GroupByContext@4cd86af0, orderByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.orderby.OrderByContext@48e7f7b3, paginationContext=org.apache.shardingsphere.sql.parser.binder.segment.select.pagination.PaginationContext@de560cb, containsSubquery=false) 16:21:46.323 INFO [rpcDispatch_RMROLE_1_3_16] ShardingSphere-SQL - Actual SQL: sharding_2 ::: SELECT * FROM undo_log WHERE branch_id = ? AND xid = ? FOR UPDATE ::: [59316288803147776, 39.106.112.246:8091:59316262546804736] 16:21:46.333 INFO [rpcDispatch_RMROLE_1_3_16] ShardingSphere-SQL - Logic SQL: INSERT INTO undo_log (branch_id, xid, context, rollback_info, log_status, log_created, log_modified) VALUES (?, ?, ?, ?, ?, now(6), now(6)) 16:21:46.333 INFO [rpcDispatch_RMROLE_1_3_16] ShardingSphere-SQL - SQLStatement: InsertStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.InsertStatement@1752ab9b, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@4b8f5d06), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@4b8f5d06, columnNames=[branch_id, xid, context, rollback_info, log_status, log_created, log_modified], insertValueContexts=[InsertValueContext(parametersCount=5, valueExpressions=[ParameterMarkerExpressionSegment(startIndex=109, stopIndex=109, parameterMarkerIndex=0), ParameterMarkerExpressionSegment(startIndex=112, stopIndex=112, parameterMarkerIndex=1), ParameterMarkerExpressionSegment(startIndex=115, stopIndex=115, parameterMarkerIndex=2), ParameterMarkerExpressionSegment(startIndex=118, stopIndex=118, parameterMarkerIndex=3), ParameterMarkerExpressionSegment(startIndex =121, stopIndex=121, parameterMarkerIndex=4), org.apache.shardingsphere.sql.parser.sql.segment.dml.item.ExpressionProjectionSegment@76b93bb9, org.apache.shardingsphere.sql.parser.sql.segment.dml.item.ExpressionProjectionSegment@398f6f04], parameters=[59316288803147776, 39.106.112.246:8091:59316262546804736, serializer=jackson, javax.sql.rowset.serial.SerialBlob@484b02, 1])], generatedKeyContext=Optional.empty) 16:21:46.333 INFO [rpcDispatch_RMROLE_1_3_16] ShardingSphere-SQL - Actual SQL: sharding_4 ::: INSERT INTO undo_log (branch_id, xid, context, rollback_info, log_status, log_created, log_modified) VALUES (?, ?, ?, ?, ?, now(6), now(6)) ::: [59316288803147776, 39.106.112.246:8091:59316262546804736, serializer=jackson, javax.sql.rowset.serial.SerialBlob@484b02, 1] 16:21:46.349 INFO [rpcDispatch_RMROLE_1_3_16] io.seata.rm.datasource.undo.AbstractUndoLogManager - xid 39.106.112.246:8091:59316262546804736 branch 59316288803147776, undo_log added with GlobalFinished 16:21:46.358 INFO [rpcDispatch_RMROLE_1_3_16] io.seata.rm.AbstractRMHandler - Branch Rollbacked result: PhaseTwo_Rollbacked 16:21:46.358 DEBUG [rpcDispatch_RMROLE_1_3_16] io.seata.core.rpc.processor.client.RmBranchRollbackProcessor - branch rollback result:xid=39.106.112.246:8091:59316262546804736,branchId=59316288803147776,branchStatus=PhaseTwo_Rollbacked,result code =Success,getMsg =null 16:21:46.358 DEBUG [rpcDispatch_RMROLE_1_3_16] io.seata.core.rpc.netty.AbstractNettyRemoting - write message:xid=39.106.112.246:8091:59316262546804736,branchId=59316288803147776,branchStatus=PhaseTwo_Rollbacked,result code =Success,getMsg =null, channel:[id: 0x8fc0eea4, L:/10.1.1.125:57843 - R:/39.106.112.246:8091],active?true,writable?true,isopen?true 16:21:46.366 DEBUG [NettyClientSelector_TMROLE_1_1] io.seata.core.rpc.netty.AbstractNettyRemoting - io.seata.core.rpc.netty.TmNettyRemotingClient@58b87dd6 msgId:5, body:MergeResultMessage globalStatus=Rollbacked,ResultCode=Success,Msg=null 16:21:46.366 DEBUG [main] io.seata.core.context.RootContext - unbind 39.106.112.246:8091:59316262546804736 16:21:46.366 DEBUG [main] io.seata.tm.api.DefaultGlobalTransaction - Suspending current transaction,xid = 39.106.112.246:8091:59316262546804736 16:21:46.367 INFO [main] io.seata.tm.api.DefaultGlobalTransaction - [39.106.112.246:8091:59316262546804736] rollback status: Rollbacked ``` ---------------------------------------------------------------- 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: [email protected]
