kpioneer123 commented on issue #7380: URL: https://github.com/apache/shardingsphere/issues/7380#issuecomment-707603938
``` 17:05:16.545 WARN [main] io.seata.common.loader.EnhancedServiceLoader$InnerEnhancedServiceLoader - Load [io.seata.rm.datasource.undo.parser.ProtostuffUndoLogParser] class fail. io/protostuff/runtime/IdStrategy 17:05:16.639 INFO [main] 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)) 17:05:16.639 INFO [main] ShardingSphere-SQL - SQLStatement: InsertStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.InsertStatement@1e512b3, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@a69c4c3), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@a69c4c3, 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, par ameterMarkerIndex=4), org.apache.shardingsphere.sql.parser.sql.segment.dml.item.ExpressionProjectionSegment@26b3eb48, org.apache.shardingsphere.sql.parser.sql.segment.dml.item.ExpressionProjectionSegment@45db8ba6], parameters=[59327239145230336, 39.106.112.246:8091:59327210615574528, serializer=jackson, javax.sql.rowset.serial.SerialBlob@9a960756, 0])], generatedKeyContext=Optional.empty) 17:05:16.639 INFO [main] 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)) ::: [59327239145230336, 39.106.112.246:8091:59327210615574528, serializer=jackson, javax.sql.rowset.serial.SerialBlob@9a960756, 0] 17:05:16.754 INFO [main] 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)) 17:05:16.754 INFO [main] ShardingSphere-SQL - SQLStatement: InsertStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.InsertStatement@1e512b3, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@d015dba), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@d015dba, 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, par ameterMarkerIndex=4), org.apache.shardingsphere.sql.parser.sql.segment.dml.item.ExpressionProjectionSegment@26b3eb48, org.apache.shardingsphere.sql.parser.sql.segment.dml.item.ExpressionProjectionSegment@45db8ba6], parameters=[59327240088948736, 39.106.112.246:8091:59327210615574528, serializer=jackson, javax.sql.rowset.serial.SerialBlob@c1e37e95, 0])], generatedKeyContext=Optional.empty) 17:05:16.754 INFO [main] 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)) ::: [59327240088948736, 39.106.112.246:8091:59327210615574528, serializer=jackson, javax.sql.rowset.serial.SerialBlob@c1e37e95, 0] 17:05:16.789 WARN [main] io.seata.rm.datasource.exec.mysql.MySQLInsertExecutor - Fail to get auto-generated keys, use 'SELECT LAST_INSERT_ID()' instead. Be cautious, statement could be polluted. Recommend you set the statement to return generated keys. 17:05:16.867 INFO [rpcDispatch_RMROLE_1_1_16] io.seata.core.rpc.processor.client.RmBranchRollbackProcessor - rm handle branch rollback process:xid=39.106.112.246:8091:59327210615574528,branchId=59327240336412672,branchType=AT,resourceId=jdbc:mysql://rdsql815s2568iryqn93o.mysql.rds.aliyuncs.com:3306/bookdb,applicationData=null 17:05:16.869 INFO [rpcDispatch_RMROLE_1_1_16] io.seata.rm.AbstractRMHandler - Branch Rollbacking: 39.106.112.246:8091:59327210615574528 59327240336412672 jdbc:mysql://rdsql815s2568iryqn93o.mysql.rds.aliyuncs.com:3306/bookdb 17:05:16.875 INFO [rpcDispatch_RMROLE_1_1_16] ShardingSphere-SQL - Logic SQL: SELECT * FROM undo_log WHERE branch_id = ? AND xid = ? FOR UPDATE 17:05:16.875 INFO [rpcDispatch_RMROLE_1_1_16] ShardingSphere-SQL - SQLStatement: SelectStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.SelectStatement@33c3bf06, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@53259ec5), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@53259ec5, 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@19817df0, orderByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.orderby.OrderByContext@6526579, paginationContext=org.apache.shardingsphere.sql.parser.binder.segment.select.pagination.PaginationContext@28c7d13a, containsSubquery=false) 17:05:16.875 INFO [rpcDispatch_RMROLE_1_1_16] ShardingSphere-SQL - Actual SQL: master ::: SELECT * FROM undo_log WHERE branch_id = ? AND xid = ? FOR UPDATE ::: [59327240336412672, 39.106.112.246:8091:59327210615574528] 17:05:16.963 INFO [rpcDispatch_RMROLE_1_1_16] ShardingSphere-SQL - Logic SQL: SELECT * FROM undo_log WHERE (id ) in ( (?) ) 17:05:16.963 INFO [rpcDispatch_RMROLE_1_1_16] ShardingSphere-SQL - SQLStatement: SelectStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.SelectStatement@59e1e96b, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@555bd339), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@555bd339, 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@3db02a72, orderByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.orderby.OrderByContext@6f56f3cf, paginationContext=org.apache.shardingsphere.sql.parser.binder.segment.select.pagination.PaginationContext@392af5ff, containsSubquery=false) 17:05:16.963 INFO [rpcDispatch_RMROLE_1_1_16] ShardingSphere-SQL - Actual SQL: master ::: SELECT * FROM undo_log WHERE (id ) in ( (?) ) ::: [79] 17:05:16.973 INFO [rpcDispatch_RMROLE_1_1_16] ShardingSphere-SQL - Logic SQL: DELETE FROM undo_log WHERE id = ? 17:05:16.973 INFO [rpcDispatch_RMROLE_1_1_16] ShardingSphere-SQL - SQLStatement: DeleteStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.DeleteStatement@2f4dd49f, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@3b2fc111), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@3b2fc111) 17:05:16.973 INFO [rpcDispatch_RMROLE_1_1_16] ShardingSphere-SQL - Actual SQL: master ::: DELETE FROM undo_log WHERE id = ? ::: [79] 17:05:16.978 INFO [rpcDispatch_RMROLE_1_1_16] ShardingSphere-SQL - Logic SQL: SELECT * FROM book_punch_count WHERE (id ) in ( (?) ) 17:05:16.978 INFO [rpcDispatch_RMROLE_1_1_16] ShardingSphere-SQL - SQLStatement: SelectStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.SelectStatement@5aeaee3, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@2c7c667a), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@2c7c667a, 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=book_id, alias=Optional.empty), ColumnProjection(owner=null, name=start_date, alias=Optional.empty), ColumnProjection(owner=null, name=type, alias=Optional.empty), ColumnProjection(owner=null, name=count, alias=Optional.empty), ColumnProjection(owner=null, name=create_time, alias=Optional.empty), ColumnProjection(owner= null, name=update_time, alias=Optional.empty)])]), groupByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.groupby.GroupByContext@6d54b646, orderByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.orderby.OrderByContext@28b6d5b4, paginationContext=org.apache.shardingsphere.sql.parser.binder.segment.select.pagination.PaginationContext@223bd2a3, containsSubquery=false) 17:05:16.978 INFO [rpcDispatch_RMROLE_1_1_16] ShardingSphere-SQL - Actual SQL: master ::: SELECT * FROM book_punch_count WHERE (id ) in ( (?) ) ::: [136] 17:05:16.983 INFO [rpcDispatch_RMROLE_1_1_16] ShardingSphere-SQL - Logic SQL: DELETE FROM book_punch_count WHERE id = ? 17:05:16.983 INFO [rpcDispatch_RMROLE_1_1_16] ShardingSphere-SQL - SQLStatement: DeleteStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.DeleteStatement@3b10382c, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@47424b27), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@47424b27) 17:05:16.983 INFO [rpcDispatch_RMROLE_1_1_16] ShardingSphere-SQL - Actual SQL: master ::: DELETE FROM book_punch_count WHERE id = ? ::: [136] 17:05:16.988 INFO [rpcDispatch_RMROLE_1_1_16] ShardingSphere-SQL - Logic SQL: SELECT * FROM book_fans WHERE (id ) in ( (?) ) 17:05:16.988 INFO [rpcDispatch_RMROLE_1_1_16] ShardingSphere-SQL - SQLStatement: SelectStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.SelectStatement@3ae648d2, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@7cbc4d8b), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@7cbc4d8b, 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=book_id, alias=Optional.empty), ColumnProjection(owner=null, name=user_id, alias=Optional.empty), ColumnProjection(owner=null, name=fans_type, alias=Optional.empty), ColumnProjection(owner=null, name=punch_start_date, alias=Optional.empty), ColumnProjection(owner=null, name=punch_last_date, alias=Optional.empty), Colum nProjection(owner=null, name=create_time, alias=Optional.empty), ColumnProjection(owner=null, name=update_time, alias=Optional.empty), ColumnProjection(owner=null, name=running_days, alias=Optional.empty), ColumnProjection(owner=null, name=total_days, alias=Optional.empty)])]), groupByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.groupby.GroupByContext@4657db68, orderByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.orderby.OrderByContext@1319abf6, paginationContext=org.apache.shardingsphere.sql.parser.binder.segment.select.pagination.PaginationContext@43895733, containsSubquery=false) 17:05:16.988 INFO [rpcDispatch_RMROLE_1_1_16] ShardingSphere-SQL - Actual SQL: master ::: SELECT * FROM book_fans WHERE (id ) in ( (?) ) ::: [567] 17:05:16.993 INFO [rpcDispatch_RMROLE_1_1_16] ShardingSphere-SQL - Logic SQL: DELETE FROM book_fans WHERE id = ? 17:05:16.993 INFO [rpcDispatch_RMROLE_1_1_16] ShardingSphere-SQL - SQLStatement: DeleteStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.DeleteStatement@7babcfdc, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@72122f55), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@72122f55) 17:05:16.993 INFO [rpcDispatch_RMROLE_1_1_16] ShardingSphere-SQL - Actual SQL: master ::: DELETE FROM book_fans WHERE id = ? ::: [567] 17:05:16.998 INFO [rpcDispatch_RMROLE_1_1_16] ShardingSphere-SQL - Logic SQL: DELETE FROM undo_log WHERE branch_id = ? AND xid = ? 17:05:16.998 INFO [rpcDispatch_RMROLE_1_1_16] ShardingSphere-SQL - SQLStatement: DeleteStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.DeleteStatement@2a5c71e4, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@f2c9e5c), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@f2c9e5c) 17:05:16.998 INFO [rpcDispatch_RMROLE_1_1_16] ShardingSphere-SQL - Actual SQL: master ::: DELETE FROM undo_log WHERE branch_id = ? AND xid = ? ::: [59327240336412672, 39.106.112.246:8091:59327210615574528] 17:05:17.007 INFO [rpcDispatch_RMROLE_1_1_16] io.seata.rm.datasource.undo.AbstractUndoLogManager - xid 39.106.112.246:8091:59327210615574528 branch 59327240336412672, undo_log deleted with GlobalFinished 17:05:17.016 INFO [rpcDispatch_RMROLE_1_1_16] io.seata.rm.AbstractRMHandler - Branch Rollbacked result: PhaseTwo_Rollbacked 17:05:17.023 INFO [rpcDispatch_RMROLE_1_2_16] io.seata.core.rpc.processor.client.RmBranchRollbackProcessor - rm handle branch rollback process:xid=39.106.112.246:8091:59327210615574528,branchId=59327240088948736,branchType=AT,resourceId=jdbc:mysql://rdsql815s2568iryqn93o.mysql.rds.aliyuncs.com:3306/bookdb,applicationData=null 17:05:17.023 INFO [rpcDispatch_RMROLE_1_2_16] io.seata.rm.AbstractRMHandler - Branch Rollbacking: 39.106.112.246:8091:59327210615574528 59327240088948736 jdbc:mysql://rdsql815s2568iryqn93o.mysql.rds.aliyuncs.com:3306/bookdb 17:05:17.023 INFO [rpcDispatch_RMROLE_1_2_16] ShardingSphere-SQL - Logic SQL: SELECT * FROM undo_log WHERE branch_id = ? AND xid = ? FOR UPDATE 17:05:17.023 INFO [rpcDispatch_RMROLE_1_2_16] ShardingSphere-SQL - SQLStatement: SelectStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.SelectStatement@33c3bf06, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@7ddb5072), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@7ddb5072, 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@731ca1b9, orderByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.orderby.OrderByContext@77233b02, paginationContext=org.apache.shardingsphere.sql.parser.binder.segment.select.pagination.PaginationContext@3221ab82, containsSubquery=false) 17:05:17.023 INFO [rpcDispatch_RMROLE_1_2_16] ShardingSphere-SQL - Actual SQL: master ::: SELECT * FROM undo_log WHERE branch_id = ? AND xid = ? FOR UPDATE ::: [59327240088948736, 39.106.112.246:8091:59327210615574528] 17:05:17.037 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)) 17:05:17.037 INFO [rpcDispatch_RMROLE_1_2_16] ShardingSphere-SQL - SQLStatement: InsertStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.InsertStatement@1e512b3, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@6dcc8f4d), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@6dcc8f4d, 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@26b3eb48, org.apache.shardingsphere.sql.parser.sql.segment.dml.item.ExpressionProjectionSegment@45db8ba6], parameters=[59327240088948736, 39.106.112.246:8091:59327210615574528, serializer=jackson, javax.sql.rowset.serial.SerialBlob@484b02, 1])], generatedKeyContext=Optional.empty) 17:05:17.037 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)) ::: [59327240088948736, 39.106.112.246:8091:59327210615574528, serializer=jackson, javax.sql.rowset.serial.SerialBlob@484b02, 1] 17:05:17.048 INFO [rpcDispatch_RMROLE_1_2_16] io.seata.rm.datasource.undo.AbstractUndoLogManager - xid 39.106.112.246:8091:59327210615574528 branch 59327240088948736, undo_log added with GlobalFinished 17:05:17.056 INFO [rpcDispatch_RMROLE_1_2_16] io.seata.rm.AbstractRMHandler - Branch Rollbacked result: PhaseTwo_Rollbacked 17:05:17.062 INFO [rpcDispatch_RMROLE_1_3_16] io.seata.core.rpc.processor.client.RmBranchRollbackProcessor - rm handle branch rollback process:xid=39.106.112.246:8091:59327210615574528,branchId=59327239145230336,branchType=AT,resourceId=jdbc:mysql://rdsql815s2568iryqn93o.mysql.rds.aliyuncs.com:3306/sharding_2,applicationData=null 17:05:17.062 INFO [rpcDispatch_RMROLE_1_3_16] io.seata.rm.AbstractRMHandler - Branch Rollbacking: 39.106.112.246:8091:59327210615574528 59327239145230336 jdbc:mysql://rdsql815s2568iryqn93o.mysql.rds.aliyuncs.com:3306/sharding_2 17:05:17.063 INFO [rpcDispatch_RMROLE_1_3_16] ShardingSphere-SQL - Logic SQL: SELECT * FROM undo_log WHERE branch_id = ? AND xid = ? FOR UPDATE 17:05:17.063 INFO [rpcDispatch_RMROLE_1_3_16] ShardingSphere-SQL - SQLStatement: SelectStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.SelectStatement@33c3bf06, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@559a46b3), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@559a46b3, 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@5b5da270, orderByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.orderby.OrderByContext@5f622dc3, paginationContext=org.apache.shardingsphere.sql.parser.binder.segment.select.pagination.PaginationContext@1a60a84b, containsSubquery=false) 17:05:17.063 INFO [rpcDispatch_RMROLE_1_3_16] ShardingSphere-SQL - Actual SQL: sharding_0 ::: SELECT * FROM undo_log WHERE branch_id = ? AND xid = ? FOR UPDATE ::: [59327239145230336, 39.106.112.246:8091:59327210615574528] 17:05:17.073 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)) 17:05:17.073 INFO [rpcDispatch_RMROLE_1_3_16] ShardingSphere-SQL - SQLStatement: InsertStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.InsertStatement@1e512b3, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@65729911), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@65729911, 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@26b3eb48, org.apache.shardingsphere.sql.parser.sql.segment.dml.item.ExpressionProjectionSegment@45db8ba6], parameters=[59327239145230336, 39.106.112.246:8091:59327210615574528, serializer=jackson, javax.sql.rowset.serial.SerialBlob@484b02, 1])], generatedKeyContext=Optional.empty) 17:05:17.073 INFO [rpcDispatch_RMROLE_1_3_16] ShardingSphere-SQL - Actual SQL: sharding_5 ::: INSERT INTO undo_log (branch_id, xid, context, rollback_info, log_status, log_created, log_modified) VALUES (?, ?, ?, ?, ?, now(6), now(6)) ::: [59327239145230336, 39.106.112.246:8091:59327210615574528, serializer=jackson, javax.sql.rowset.serial.SerialBlob@484b02, 1] 17:05:17.089 INFO [rpcDispatch_RMROLE_1_3_16] io.seata.rm.datasource.undo.AbstractUndoLogManager - xid 39.106.112.246:8091:59327210615574528 branch 59327239145230336, undo_log added with GlobalFinished 17:05:17.096 INFO [rpcDispatch_RMROLE_1_3_16] io.seata.rm.AbstractRMHandler - Branch Rollbacked result: PhaseTwo_Rollbacked 17:05:17.105 INFO [main] io.seata.tm.api.DefaultGlobalTransaction - [39.106.112.246:8091:59327210615574528] 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]
