OceanBase 数据库 V4.x 版本中因 __all_virtual_sql_audit 查询超时导致死锁信息无法成功记录到视图 __all_virtual_deadlock_event_history

observer.log.20250522093419634:[2025-05-22 09:31:30.850761] WDIAG [DETECT] get_holding_sql (ob_deadlock_detector_mgr.cpp:724) [2291672][T1008_L0_G0][T1008][YB421EB5210D-0006358C007B9E0C-0-0] [lt=10][errcode=-4012] failed to get sql history in transaction(tmp_ret=-4012, tmp_ret="OB_TIMEOUT", sql_hisory=[], ret=-4012, ret="OB_TIMEOUT", sess_id=3221522956, trans_id=234417352, hold_seq=3, holding_sql_request_time=, holding_sql=)
observer.log.20250522093419634:[2025-05-22 09:31:30.850785] WDIAG [DETECT] get_trans_history_sql_from_audit_ (ob_deadlock_detector_mgr.cpp:632) [2291672][T1008_L0_G0][T1008][YB421EB5210D-0006358C007B9E0C-0-0] [lt=22][errcode=-4012] fail to get holding sql(ret=-4012, ret="OB_TIMEOUT", collected_info={binary_key:{type:0, trans_id:{txid:234417352}}, tenant_id:1008, addr:"30.181.33.13:2882", detector_id:124167, report_time:1747877485940101, created_time:1747877485806902, event_id:8771658490551833432, role:"victim", start_delay:0, priority:{priority_range:0, priority_value:18444996196237813895}, user_report_info:{module_name:"transaction", resource_visitor:"{session_id:3221522956}(associated:3221522956):{txid:234417352}", blocked_seq:230298032, required_resource:"{addr:"30.181.33.13:2882"}:{ls:1001}:{tablet:215998}:{row_key:{"NUMBER":"1"}}", extra_columns_names:["wait_sql"], extra_columns_values:["Y0-0000000000000000-0-0:UPDATE t1_deadlock_test SET status = 4 where id = 1"], valid_extra_column_size:1}}, collect_info_msg={dest_key:{type:0, trans_id:{txid:234417352}}, collected_info:[{binary_key:{type:0, trans_id:{txid:234417352}}, tenant_id:1008, addr:"30.181.33.13:2882", detector_id:124167, report_time:1747877485940101, created_time:1747877485806902, event_id:8771658490551833432, role:"victim", start_delay:0, priority:{priority_range:0, priority_value:18444996196237813895}, user_report_info:{module_name:"transaction", resource_visitor:"{session_id:3221522956}(associated:3221522956):{txid:234417352}", blocked_seq:230298032, required_resource:"{addr:"30.181.33.13:2882"}:{ls:1001}:{tablet:215998}:{row_key:{"NUMBER":"1"}}", extra_columns_names:["wait_sql"], extra_columns_values:["Y0-0000000000000000-0-0:UPDATE t1_deadlock_test SET status = 4 where id = 1"], valid_extra_column_size:1}}, {binary_key:{type:0, trans_id:{txid:234416446}}, tenant_id:1008, addr:"30.181.33.13:2882", detector_id:124164, report_time:1747877485940683, created_time:1747877479470494, event_id:8771658490551833432, role:"witness", start_delay:0, priority:{priority_range:0, priority_value:18444996196254803618}, user_report_info:{module_name:"transaction", resource_visitor:"{session_id:3221665687}(associated:3221665687):{txid:234416446}", blocked_seq:3, required_resource:"{addr:"30.181.33.13:2882"}:{ls:1001}:{tablet:215998}:{row_key:{"NUMBER":"2"}}", extra_columns_names:["wait_sql"], extra_columns_values:["Y0-0000000000000000-0-0:UPDATE t1_deadlock_test SET status = 2 where id = 2"], valid_extra_column_size:1}}]}, holding_seq=3, idx=0, last_idx=1)