【 使用环境 】生产环境 or 测试环境
【 OB or 其他组件 】
ob: 4.3.3.1 OceanBase 构建版本号：4.3.3.1-101000012024102216
obp:4.3.2.0-26
ocp:4.3.2 版本号: 4.3.2-20240925174740
【问题描述】
如以下监控图所示，事物回滚 比提示多了好几倍，请问这种情况正常吗？
使用obdiag检查也没有异常
[root@OBDB-01 log]# obdiag rca run --scene=transaction_rollback
No time option provided, default processing is based on the last 30 minutes
gather log from_time: 2024-10-30 09:42:37, to_time: 2024-10-30 10:13:37
Gather Ob Log Summary:
+---------------+------------------+--------+--------+------------+
| Node | Status | Size | Time | PackPath |
+===============+==================+========+========+============+
| 192.168.51.11 | Error:Empty file | 0.000B | 1 s | |
+---------------+------------------+--------+--------+------------+
| 192.168.51.12 | Error:Empty file | 0.000B | 1 s | |
+---------------+------------------+--------+--------+------------+
| 192.168.51.13 | Error:Empty file | 0.000B | 2 s | |
+---------------+------------------+--------+--------+------------+
For result details, please run cmd ' cat /home/admin/obproxy/log/obdiag_rca/obdiag_transaction_rollback_20241030101237/trans_is_killed/obdiag_gather_pack_20241030101237/result_summary.txt '
rca finished. For more details, the result on './obdiag_rca//obdiag_transaction_rollback_20241030101237'
You can get the suggest by 'cat ./obdiag_rca//obdiag_transaction_rollback_20241030101237/record'
Trace ID: 6e2f0a8a-9664-11ef-a448-90e2baa8770a
If you want to view detailed obdiag logs, please run: obdiag display-trace 6e2f0a8a-9664-11ef-a448-90e2baa8770a
[root@OBDB-01 log]# cat ./obdiag_rca//obdiag_transaction_rollback_20241030101237/record
+---------------------------------------+
| record |
+------+--------------------------------+
| step | info |
+------+--------------------------------+
| 1 | syslog_level data is WDIAG |
| 2 | no log about 'trans is killed' |
+------+--------------------------------+
The suggest:
observer.log里大量 can not do batch insert opt日志：
[2024-10-30 10:18:01.166768] INFO [SQL.PC] check_can_do_insert_opt (ob_plan_cache.cpp:996) [175078][T1004_L0_G0][T1004][YB42C0A8330B-000625A485D63512-0-0] [lt=1] can not do batch insert opt(ret=0, can_do_batch=false, upd_params_count=0, ins_params_count=0, batch_count=0, pc_ctx.raw_sql_=INSERT INTO set_hold_member_20241030^M
(^M
period_no, set_m, member_id, set_no, dict_no_type_id,^M
hold_m, max_loss, pay_water, set_type_no^M
)^M
VALUES^M
(20241030124,1.00000,729, '7331', 11,^M
1.00000, 0, 0, '117331'),(20241030124,1.00000,729, '7337', 11,^M
1.00000, 0, 0, '117337')^M
ON DUPLICATE KEY UPDATE^M
set_m=set_m-VALUES(set_m),^M
hold_m = hold_m + VALUES(hold_m)^M
;)
[2024-10-30 10:18:01.167304] INFO [STORAGE.TRANS] rollback (ob_memtable_context.cpp:844) [174289][T1002_L0_G0][T1002][YB42C0A8330B-000625A3DE39F431-0-0] [lt=0] memtable handle rollback to successfuly(from_seq_no={branch:0, seq:15792}, to_seq_no={branch:0, seq:15786}, remove_cnt=1, elapsed=0, this={ObIMvccCtx={alloc_type=0 ctx_descriptor=0 min_table_version=1729562416268256 max_table_version=1730064641355736 trans_version={val:4611686018427387903, v:0} commit_version={val:0, v:0} lock_wait_start_ts=0 replay_compact_version={val:0, v:0}} end_code=0 tx_status=0 is_readonly=false ref=0 trans_id={txid:319403343} ls_id=1001 row_callback[alloc:8, free:0, unsubmit:8] redo[fill:0,sync_succ:0, sync_fail:0] main_list_len=11 pending_log_size=502 callback_list:{cnt=1 stat:[tx_end=0, rollback_to=2, fast_commit=0, remove_memtable=0, ext_info_log=0] detail:[(log_epoch,length,logged,synced,appended,removed,unlog_removed,branch_removed)|0:(1,11,0,0,13,2,2,0)|]}})
[2024-10-30 10:18:01.167794] INFO [STORAGE.TRANS] rollback (ob_memtable_context.cpp:844) [175078][T1004_L0_G0][T1004][YB42C0A8330B-000625A485D63512-0-0] [lt=0] memtable handle rollback to successfuly(from_seq_no={branch:0, seq:13698}, to_seq_no={branch:0, seq:13696}, remove_cnt=1, elapsed=0, this={ObIMvccCtx={alloc_type=0 ctx_descriptor=0 min_table_version=1730094182157976 max_table_version=1730094672019448 trans_version={val:4611686018427387903, v:0} commit_version={val:0, v:0} lock_wait_start_ts=0 replay_compact_version={val:0, v:0}} end_code=0 tx_status=0 is_readonly=false ref=0 trans_id={txid:27779777} ls_id=1001 row_callback[alloc:14, free:0, unsubmit:14] redo[fill:0,sync_succ:0, sync_fail:0] main_list_len=19 pending_log_size=981 callback_list:{cnt=1 stat:[tx_end=0, rollback_to=3, fast_commit=0, remove_memtable=0, ext_info_log=0] detail:[(log_epoch,length,logged,synced,appended,removed,unlog_removed,branch_removed)|0:(1,19,0,0,22,3,3,0)|]}})