OBD 部署社区版OceanBase 麒麟系统 V10 x86_64 ObceanBase启动后大概半小时内会崩溃

【 使用环境 】测试环境
【 OB or 其他组件 】五
【 使用版本 】4.3.5.1 e17
【问题描述】数据库启动后,正常连接,但是半小时内会崩溃
【复现路径】问题出现前后相关操作
【附件及日志】推荐使用OceanBase敏捷诊断工具obdiag收集诊断信息,详情参见链接(右键跳转查看):

【SOP系列 22 】——故障诊断第一步(自助诊断和诊断信息收集)

【备注】基于 LLM 和开源文档 RAG 的论坛小助手已开放测试,在发帖时输入 [@论坛小助手] 即可召唤小助手,欢迎试用!
[2025-03-28 11:53:05.334023] INFO [PL] dump_module (ob_llvm_helper.cpp:644) [73674][T1_L0_G28][T1][YB427F000001-0006315ECC632B38-0-0] [lt=75] Dump LLVM Compile Module!
(s.str().c_str()="; ModuleID = ‘PL/SQL’
source_filename = “PL/SQL”
target datalayout = “e-m:e-p270:32:32-p271:32:32-p272:64:64-i64:64-f80:128-n8:16:32:64-S128”

%pl_exec_context = type { i64, i64, i64, %seg_param_store*, %obj*, i32*, i64, i8, i64 }
%seg_param_store = type { i64, i32, %wrapper_allocator, %seg_pointer_array, i64, i64 }
%wrapper_allocator = type { i64, i64 }
%seg_pointer_array = type { i64, [1 x i64], i64, [1 x i64], i64, i64, i64, i32, %wrapper_allocator, i8, %memory_context }
%memory_context = type { i64, i64, i64 }
%obj = type { %obj_meta, i32, i64 }
%obj_meta = type { i8, i8, i8, i8 }
%objparam = type { %obj, i64, i32, %obj.0, i32, i32, %obj_meta }
%obj.0 = type { i64, i8 }
%data_type = type { %obj_meta, i64, i32, i8, i8 }
%unwind_exception = type { i64 }
%pl_condition_value = type { i64, i64, i8
, i64, i64, i8 }

declare i32 ""spi_calc_expr_at_idx(%pl_exec_context*, i64, i64, %objparam*)

declare i32 ""spi_calc_package_expr(%pl_exec_context*, i64, i64, %objparam*)

declare i32 ""spi_convert_objparam(%pl_exec_context*, %objparam*, i64, %objparam*, i8)

declare i32 ""spi_set_variable_to_expr(%pl_exec_context*, i64, %objparam*, i8, i8)

declare i32 ""spi_query_into_expr_idx(%pl_exec_context*, i8*, i64, i64*, i64, %data_type*, i64, i8*, i64*, i8, i8, i8)

declare i32 ""spi_end_trans(%pl_exec_context*, i8*, i8)

declare i32 ""spi_update_location(%pl_exec_context*, i64)

declare i32 ""spi_execute_with_expr_idx(%pl_exec_context*, i8*, i64, i64*, i64, i64*, i64, %data_type*, i64, i8*, i64*, i8, i8, i8, i8)

declare i32 ""spi_execute_immediate(%pl_exec_context*, i64, i64, i64*, i64, i64*, i64, %data_type*, i64, i8*, i64*, i8, i8, i8)

declare i32 ""spi_alloc_complex_var(%pl_exec_context*, i8, i64, i64, i32, i64*, i64)

declare i32 ""spi_construct_collection(%pl_exec_context*, i64, %objparam*)

declare i32 ""spi_clear_diagnostic_area(%pl_exec_context*)

declare i32 ""spi_extend_collection(%pl_exec_context*, i64, i64, i64, i64, i64)

declare i32 ""spi_delete_collection(%pl_exec_context*, i64, i64, i64, i64)

declare i32 ""spi_trim_collection(%pl_exec_context*, i64, i64, i64)

declare i32 ""spi_cursor_init(%pl_exec_context*, i64)

declare i32 ""spi_cursor_open_with_param_idx(%pl_exec_context*, i8*, i8*, i64, i8, i8, i64*, i64, i64, i64, i64, i64*, i64*, i64, i8)

declare i32 ""spi_dynamic_open(%pl_exec_context*, i64, i64*, i64, i64, i64, i64)

declare i32 ""spi_cursor_fetch(%pl_exec_context*, i64, i64, i64, i64*, i64, %data_type*, i64, i8*, i64*, i8, i64, %data_type*, i64, i8)

declare i32 ""spi_cursor_close(%pl_exec_context*, i64, i64, i64, i8)

declare i32 ""spi_destruct_collection(%pl_exec_context*, i64)

declare i32 ""spi_reset_composite(i64, i8, i32)

declare i32 ""spi_sub_nestedtable(%pl_exec_context*, i64, i64, i32, i32)

declare i32 ""spi_copy_datum(%pl_exec_context*, i64, %obj*, %obj*, %data_type*, i64)

declare i32 ""spi_destruct_obj(%pl_exec_context*, %obj*)

declare i32 ""spi_set_pl_exception_code(%pl_exec_context*, i64, i8, i32)

declare i32 ""spi_get_pl_exception_code(%pl_exec_context*, i64*)

declare i32 ""spi_raise_application_error(%pl_exec_context*, i64, i64)

declare i32 ""spi_check_early_exit(%pl_exec_context*)

declare i32 ""spi_pipe_row_to_result(%pl_exec_context*, %objparam*)

declare i32 ""spi_check_exception_handler_legal(%pl_exec_context*, i64)

declare i32 ""spi_interface_impl(%pl_exec_context*, i8*)

declare i32 ""spi_process_nocopy_params(%pl_exec_context*, i64, i8)

declare i32 ""spi_add_ref_cursor_refcount(%pl_exec_context*, %obj*, i64)

declare i32 ""spi_handle_ref_cursor_refcount(%pl_exec_context*, i64, i64, i64, i64)

declare i32 ""spi_update_package_change_info(%pl_exec_context*, i64, i64)

declare i32 ""spi_check_composite_not_null(%objparam*)

declare i32 ""spi_process_resignal(%pl_exec_context*, i64, i64, i8*, i64*, i8*, i8)

declare i32 ""spi_check_autonomous_trans(%pl_exec_context*)

declare i32 ""spi_opaque_assign_null(i64)

declare i32 ""spi_pl_profiler_before_record(%pl_exec_context*, i64, i64)

declare i32 ""spi_init_composite(i64, i64, i8, i8)

declare i32 ""spi_get_parent_allocator(i64, i64*)

declare i32 ""spi_get_current_expr_allocator(%pl_exec_context*, i64*)

declare i32 ""spi_pl_profiler_after_record(%pl_exec_context*, i64, i64)

declare %unwind_exception* eh_create_exception(i64, i64, i64, i64, %pl_condition_value*)

declare i32 _Unwind_RaiseException(%unwind_exception*)

declare void _Unwind_Resume(%unwind_exception*)

declare i32 eh_personality(i32, i32, i64, i8, i8)

declare i32 eh_convert_exception(i8, i32, i64*, i64*, i8**, i64*)

declare i64 eh_classify_exception(i8*)

declare void eh_debug_int64(i8*, i64, i64)

declare void eh_debug_int64ptr(i8*, i64, i64*)

declare void eh_debug_int32(i8*, i64, i32)

declare void eh_debug_int32ptr(i8*, i64, i32*)

declare void eh_debug_int8(i8*, i64, i8)

declare void eh_debug_int8ptr(i8*, i64, i8*)

declare void eh_debug_obj(i8*, i64, %obj*)

declare void eh_debug_objparam(i8*, i64, %objparam*)

declare i32 pl_execute(%pl_exec_context*, i64, i64, i64*, i64, i64, i64, i64, i64*, i64)

declare i32 ""set_user_type_var(%pl_exec_context*, i64, i64, i32)

declare i32 ""set_implicit_cursor_in_forall(%pl_exec_context*, i8)

declare i32 unset_implicit_cursor_in_forall(%pl_exec_context*)
“)
[2025-03-28 11:53:05.346839] INFO [SHARE] adaptive_update_limit (ob_share_throttle_define.cpp:112) [73120][T1_TenantWeakRe][T1][YB427F000001-0006315ECB333AF1-0-0] [lt=89] adaptive update(Tenant ID=1, Config Specify Resource Limit(MB)=1023, TxShare Current Memory Limit(MB)=914, Holding Memory(MB)=191, Tenant Remain Memory(MB)=1204, Usable Remain Memory(MB)=722, Last Update Limit Timestamp=1743133985346349, Is Updated=true)
[2025-03-28 11:53:05.356241] INFO [PL] compile_module (ob_llvm_helper.cpp:625) [73674][T1_L0_G28][T1][YB427F000001-0006315ECC632B38-0-0] [lt=120] ================Optimized LLVM Module================
[2025-03-28 11:53:05.360105] INFO [PL] dump_module (ob_llvm_helper.cpp:644) [73674][T1_L0_G28][T1][YB427F000001-0006315ECC632B38-0-0] [lt=70] Dump LLVM Compile Module!
(s.str().c_str()=”; ModuleID = ‘PL/SQL’
source_filename = “PL/SQL”
target datalayout = “e-m:e-p270:32:32-p271:32:32-p272:64:64-i64:64-f80:128-n8:16:32:64-S128”

%pl_exec_context = type { i64, i64, i64, %seg_param_store*, %obj*, i32*, i64, i8, i64 }
%seg_param_store = type { i64, i32, %wrapper_allocator, %seg_pointer_array, i64, i64 }
%wrapper_allocator = type { i64, i64 }
%seg_pointer_array = type { i64, [1 x i64], i64, [1 x i64], i64, i64, i64, i32, %wrapper_allocator, i8, %memory_context }
%memory_context = type { i64, i64, i64 }
%obj = type { %obj_meta, i32, i64 }
%obj_meta = type { i8, i8, i8, i8 }
%objparam = type { %obj, i64, i32, %obj.0, i32, i32, %obj_meta }
%obj.0 = type { i64, i8 }
%data_type = type { %obj_meta, i64, i32, i8, i8 }
%unwind_exception = type { i64 }
%pl_condition_value = type { i64, i64, i8
, i64, i64, i8 }

declare i32 ""spi_calc_expr_at_idx(%pl_exec_context*, i64, i64, %objparam*)

declare i32 ""spi_calc_package_expr(%pl_exec_context*, i64, i64, %objparam*)

declare i32 ""spi_convert_objparam(%pl_exec_context*, %objparam*, i64, %objparam*, i8)

declare i32 ""spi_set_variable_to_expr(%pl_exec_context*, i64, %objparam*, i8, i8)

declare i32 ""spi_query_into_expr_idx(%pl_exec_context*, i8*, i64, i64*, i64, %data_type*, i64, i8*, i64*, i8, i8, i8)

declare i32 ""spi_end_trans(%pl_exec_context*, i8*, i8)

declare i32 ""spi_update_location(%pl_exec_context*, i64)

declare i32 ""spi_execute_with_expr_idx(%pl_exec_context*, i8*, i64, i64*, i64, i64*, i64, %data_type*, i64, i8*, i64*, i8, i8, i8, i8)

declare i32 ""spi_execute_immediate(%pl_exec_context*, i64, i64, i64*, i64, i64*, i64, %data_type*, i64, i8*, i64*, i8, i8, i8)

declare i32 ""spi_alloc_complex_var(%pl_exec_context*, i8, i64, i64, i32, i64*, i64)

declare i32 ""spi_construct_collection(%pl_exec_context*, i64, %objparam*)

declare i32 ""spi_clear_diagnostic_area(%pl_exec_context*)

declare i32 ""spi_extend_collection(%pl_exec_context*, i64, i64, i64, i64, i64)

declare i32 ""spi_delete_collection(%pl_exec_context*, i64, i64, i64, i64)

declare i32 ""spi_trim_collection(%pl_exec_context*, i64, i64, i64)

declare i32 ""spi_cursor_init(%pl_exec_context*, i64)

declare i32 ""spi_cursor_open_with_param_idx(%pl_exec_context*, i8*, i8*, i64, i8, i8, i64*, i64, i64, i64, i64, i64*, i64*, i64, i8)

declare i32 ""spi_dynamic_open(%pl_exec_context*, i64, i64*, i64, i64, i64, i64)

declare i32 ""spi_cursor_fetch(%pl_exec_context*, i64, i64, i64, i64*, i64, %data_type*, i64, i8*, i64*, i8, i64, %data_type*, i64, i8)

declare i32 ""spi_cursor_close(%pl_exec_context*, i64, i64, i64, i8)

declare i32 ""spi_destruct_collection(%pl_exec_context*, i64)

declare i32 ""spi_reset_composite(i64, i8, i32)

declare i32 ""spi_sub_nestedtable(%pl_exec_context*, i64, i64, i32, i32)

declare i32 ""spi_copy_datum(%pl_exec_context*, i64, %obj*, %obj*, %data_type*, i64)

declare i32 ""spi_destruct_obj(%pl_exec_context*, %obj*)

declare i32 ""spi_set_pl_exception_code(%pl_exec_context*, i64, i8, i32)

declare i32 ""spi_get_pl_exception_code(%pl_exec_context*, i64*)

declare i32 ""spi_raise_application_error(%pl_exec_context*, i64, i64)

declare i32 ""spi_check_early_exit(%pl_exec_context*)

declare i32 ""spi_pipe_row_to_result(%pl_exec_context*, %objparam*)

declare i32 ""spi_check_exception_handler_legal(%pl_exec_context*, i64)

declare i32 ""spi_interface_impl(%pl_exec_context*, i8*)

declare i32 ""spi_process_nocopy_params(%pl_exec_context*, i64, i8)

declare i32 ""spi_add_ref_cursor_refcount(%pl_exec_context*, %obj*, i64)

declare i32 ""spi_handle_ref_cursor_refcount(%pl_exec_context*, i64, i64, i64, i64)

declare i32 ""spi_update_package_change_info(%pl_exec_context*, i64, i64)

declare i32 ""spi_check_composite_not_null(%objparam*)

declare i32 ""spi_process_resignal(%pl_exec_context*, i64, i64, i8*, i64*, i8*, i8)

declare i32 ""spi_check_autonomous_trans(%pl_exec_context*)

declare i32 ""spi_opaque_assign_null(i64)

declare i32 ""spi_pl_profiler_before_record(%pl_exec_context*, i64, i64)

declare i32 ""spi_init_composite(i64, i64, i8, i8)

declare i32 ""spi_get_parent_allocator(i64, i64*)

declare i32 ""spi_get_current_expr_allocator(%pl_exec_context*, i64*)

declare i32 ""spi_pl_profiler_after_record(%pl_exec_context*, i64, i64)

declare %unwind_exception* eh_create_exception(i64, i64, i64, i64, %pl_condition_value*)

declare i32 _Unwind_RaiseException(%unwind_exception*)

declare void _Unwind_Resume(%unwind_exception*)

declare i32 eh_personality(i32, i32, i64, i8, i8)

declare i32 eh_convert_exception(i8, i32, i64*, i64*, i8**, i64*)

declare i64 eh_classify_exception(i8*)

declare void eh_debug_int64(i8*, i64, i64)

declare void eh_debug_int64ptr(i8*, i64, i64*)

declare void eh_debug_int32(i8*, i64, i32)

declare void eh_debug_int32ptr(i8*, i64, i32*)

declare void eh_debug_int8(i8*, i64, i8)

declare void eh_debug_int8ptr(i8*, i64, i8*)

declare void eh_debug_obj(i8*, i64, %obj*)

declare void eh_debug_objparam(i8*, i64, %objparam*)

declare i32 pl_execute(%pl_exec_context*, i64, i64, i64*, i64, i64, i64, i64, i64*, i64)

declare i32 ""set_user_type_var(%pl_exec_context*, i64, i64, i32)

declare i32 ""set_implicit_cursor_in_forall(%pl_exec_context*, i8)

declare i32 unset_implicit_cursor_in_forall(%pl_exec_context*)

define i32 gather_table_stats(%pl_exec_context* %hidden_exec_ctx, i64 %argc, [17 x i64]* %argv) personality i32 (i32, i32, i64, i8, i8)* eh_personality {
entry:
%int_alloca = alloca i32, align 4
store i32 0, i32* %int_alloca, align 4
%stmt_id = alloca i64, align 8
%string = alloca [19 x i8], align 1
%string.repack = getelementptr inbounds [19 x i8], [19 x i8]* %string, i64 0, i64 0
store i8 71, i8* %string.repack, align 1
%string.repack314 = getelementptr inbounds [19 x i8], [19 x i8]* %string, i64 0, i64 1
store i8 65, i8* %string.repack314, align 1
%string.repack315 = getelementptr inbounds [19 x i8], [19 x i8]* %string, i64 0, i64 2
store i8 84, i8* %string.repack315, align 1
%string.repack316 = getelementptr inbounds [19 x i8], [19 x i8]* %string, i64 0, i64 3
store i8 72, i8* %string.repack316, align 1
%string.repack317 = getelementptr inbounds [19 x i8], [19 x i8]* %string, i64 0, i64 4
store i8 69, i8* %string.repack317, align 1
%string.repack318 = getelementptr inbounds [19 x i8], [19 x i8]* %string, i64 0, i64 5
store i8 82, i8* %string.repack318, align 1
%string.repack319 = getelementptr inbounds [19 x i8], [19 x i8]* %string, i64 0, i64 6
store i8 95, i8* %string.repack319, align 1
%string.repack320 = getelementptr inbounds [19 x i8], [19 x i8]* %string, i64 0, i64 7
store i8 84, i8* %string.repack320, align 1
%string.repack321 = getelementptr inbounds [19 x i8], [19 x i8]* %string, i64 0, i64 8
store i8 65, i8* %string.repack321, align 1
%string.repack322 = getelementptr inbounds [19 x i8], [19 x i8]* %string, i64 0, i64 9
store i8 66, i8* %string.repack322, align 1
%string.repack323 = getelementptr inbounds [19 x i8], [19 x i8]* %string, i64 0, i64 10
store i8 76, i8* %string.repack323, align 1
%string.repack324 = getelementptr inbounds [19 x i8], [19 x i8]* %string, i64 0, i64 11
store i8 69, i8* %string.repack324, align 1
%string.repack325 = getelementptr inbounds [19 x i8], [19 x i8]* %string, i64 0, i64 12
store i8 95, i8* %string.repack325, align 1
%string.repack326 = getelementptr inbounds [19 x i8], [19 x i8]* %string, i64 0, i64 13
store i8 83, i8* %string.repack326, align 1
%string.repack327 = getelementptr inbounds [19 x i8], [19 x i8]* %string, i64 0, i64 14
store i8 84, i8* %string.repack327, align 1
%string.repack328 = getelementptr inbounds [19 x i8], [19 x i8]* %string, i64 0, i64 15
store i8 65, i8* %string.repack328, align 1
%string.repack329 = getelementptr inbounds [19 x i8], [19 x i8]* %string, i64 0, i64 16
store i8 84, i8* %string.repack329, align 1
%string.repack330 = getelementptr inbounds [19 x i8], [19 x i8]* %string, i64 0, i64 17
store i8 83, i8* %string.repack330, align 1
%string.repack331 = getelementptr inbounds [19 x i8], [19 x i8]* %string, i64 0, i64 18
store i8 0, i8* %string.repack331, align 1
%string_to_char = getelementptr inbounds [19 x i8], [19 x i8]* %string, i64 0, i64 0
%spi_interface_impl = call i32 ""spi_interface_impl(%pl_exec_context* %hidden_exec_ctx, i8* nonnull %string_to_char)
store i32 %spi_interface_impl, i32* %int_alloca, align 4
store i64 0, i64* %stmt_id, align 8
%0 = icmp eq i32 %spi_interface_impl, 0
br i1 %0, label %ob_success, label %ob_fail

ob_success: ; preds = %reset_ret_block, %entry
%load_ret92 = load i32, i32* %int_alloca, align 4
ret i32 %load_ret92

ob_fail: ; preds = %entry
%exception_type = alloca i64, align 8
%error_code = alloca i64, align 8
%sql_state = alloca i8*, align 8
%str_len = alloca i64, align 8
%load_ret = load i32, i32* %int_alloca, align 4
%line_number = load i64, i64* %stmt_id, align 8
%convert_exception = call i32 eh_convert_exception(i8 0, i32 %load_ret, i64* nonnull %exception_type, i64* nonnull %error_code, i8** nonnull %sql_state, i64* nonnull %str_len)
%load_type = load i64, i64* %exception_type, align 8
%load_error_code = load i64, i64* %error_code, align 8
%load_sql_state = load i8*, i8** %sql_state, align 8
%load_str_len = load i64, i64* %str_len, align 8
%1 = getelementptr inbounds %pl_exec_context, %pl_exec_context* %hidden_exec_ctx, i64 0, i32 5
%2 = load i32*, i32** %1, align 8
store i32 %load_ret, i32* %2, align 4
%3 = getelementptr inbounds %pl_exec_context, %pl_exec_context* %hidden_exec_ctx, i64 0, i32 8
%4 = load i64, i64* %3, align 8
%5 = getelementptr inbounds %pl_exec_context, %pl_exec_context* %hidden_exec_ctx, i64 0, i32 6
%6 = load i64, i64* %5, align 8
%7 = getelementptr inbounds %pl_exec_context, %pl_exec_context* %hidden_exec_ctx, i64 0, i32 1
%8 = load i64, i64* %7, align 8
%handler_condition = alloca %pl_condition_value, align 8
%extract_arg85 = getelementptr inbounds %pl_condition_value, %pl_condition_value* %handler_condition, i64 0, i32 0
store i64 %load_type, i64* %extract_arg85, align 8
%extract_arg86 = getelementptr inbounds %pl_condition_value, %pl_condition_value* %handler_condition, i64 0, i32 1
store i64 %load_error_code, i64* %extract_arg86, align 8
%extract_arg87 = getelementptr inbounds %pl_condition_value, %pl_condition_value* %handler_condition, i64 0, i32 2
store i8* %load_sql_state, i8** %extract_arg87, align 8
%extract_arg88 = getelementptr inbounds %pl_condition_value, %pl_condition_value* %handler_condition, i64 0, i32 3
store i64 %load_str_len, i64* %extract_arg88, align 8
%extract_arg89 = getelementptr inbounds %pl_condition_value, %pl_condition_value* %handler_condition, i64 0, i32 4
store i64 %line_number, i64* %extract_arg89, align 8
%extract_arg90 = getelementptr inbounds %pl_condition_value, %pl_condition_value* %handler_condition, i64 0, i32 5
store i8 0, i8* %extract_arg90, align 8
%create_exception = call %unwind_exception* eh_create_exception(i64 %4, i64 %6, i64 %line_number, i64 %8, %pl_condition_value* nonnull %handler_condition)
switch i64 %load_error_code, label %normal_raise_block [
i64 1262, label %raise_exception
i64 1265, label %raise_exception
i64 1642, label %raise_exception
]

raise_exception: ; preds = %normal_raise_block, %ob_fail, %ob_fail, %ob_fail
%raise_exception91 = call i32 _Unwind_RaiseException(%unwind_exception* %create_exception)
unreachable

normal_raise_block: ; preds = %ob_fail
%get_exception_class = call i64 eh_classify_exception(i8* %load_sql_state)
%get_exception_class.off = add i64 %get_exception_class, -3
%switch = icmp ult i64 %get_exception_class.off, 2
br i1 %switch, label %reset_ret_block, label %raise_exception

reset_ret_block: ; preds = %normal_raise_block
store i32 0, i32* %int_alloca, align 4
br label %ob_success
}
")
[2025-03-28 11:53:05.360535] INFO [STORAGE] gc_tables_in_queue (ob_tenant_meta_mem_mgr.cpp:612) [73083][T1_TimerWK2][T1][Y0-0000000000000000-0-0] [lt=93] gc tables in queue: recycle 0 table(ret=0, tablet_buffer_pool_={typeid(T).name():“N9oceanbase7storage15ObMetaObjBufferINS0_8ObTabletELl3788EEE”, sizeof(T):3824, used_obj_cnt:1108, free_obj_hold_cnt:0, allocator used:4263584, allocator total:4569600}, large_tablet_buffer_pool_={typeid(T).name():“N9oceanbase7storage15ObMetaObjBufferINS0_8ObTabletELl65448EEE”, sizeof(T):65480, used_obj_cnt:0, free_obj_hold_cnt:0, allocator used:0, allocator total:0}, full_tablet_creator_={tiny_allocator_.used():0, tiny_allocator_.total():194432, full allocator used:1600, full allocator total:259968}, tablets_mem=4829568, tablets_mem_limit=429496720, ddl_kv_pool_={typeid(T).name():“N9oceanbase7storage7ObDDLKVE”, sizeof(T):1024, used_obj_cnt:0, free_obj_hold_cnt:0, allocator used:0, allocator total:0}, memtable_pool_={typeid(T).name():“N9oceanbase8memtable10ObMemtableE”, sizeof(T):1984, used_obj_cnt:112, free_obj_hold_cnt:0, allocator used:229376, allocator total:261120}, pending_cnt=0, wait_gc_count=0, tablet count=1108)
[2025-03-28 11:53:05.392681] INFO [RPC.OBRPC] on_disconnect (ob_rpc_net_handler.cpp:338) [72960][RpcIO][T0][Y0-0000000000000000-0-0] [lt=70] connection disconnect(easy_connection_str(c)=0.0.0.0_127.0.0.1:46096_123_0x14bd7d1ed3a0 tp=0 t=1743133011891851-1743133984951759 s=0 r=0 io=1747316/636047 sq=635719)
[2025-03-28 11:53:05.393103] INFO [RPC.OBRPC] on_disconnect (ob_rpc_net_handler.cpp:338) [72963][RpcIO][T0][Y0-0000000000000000-0-0] [lt=65] connection disconnect(easy_connection_str(c)=0.0.0.0_127.0.0.1:46128_129_0x14bd7d1ed840 tp=0 t=1743133011985560-1743133985201545 s=0 r=0 io=1746455/646147 sq=645929)
CRASH ERROR!!! IP=55a6839933a0, RBP=14bd15649a70, sig=4, sig_code=2, sig_addr=0x55a6839933a0, RLIMIT_CORE=unlimited, timestamp=1743133985394008, tid=73674, tname=T1_L0_G28, trace_id=YB427F000001-0006315ECC632B38-0-0, lbt=0x1f96b218 0x1f1b698d 0x14bd98f9c2bf 0x8bb63a0 0x9be8a9c 0x9c0812c 0x9c08505 0x9be51fd 0x9a466c5 0xa5f92d9 0xa5fa810 0xa5f85ef 0x924c3cf 0x924cafc 0x9253edc 0x9253edc 0x924ed8d 0x92176d1 0x92177b1 0x9217ad3 0x9224c5c 0x9226bd3 0x9226edb 0x9237427 0x1ef0327a 0x1eee447d 0xebf34b2 0xebf0fc5 0xebe4b4b 0xec2577e 0xec5339b 0xec473c9 0xeaa14cd 0xea7362e 0x14a77faa 0x11bba464 0x7c4fe26 0x7923e9c 0x792151d 0x7c4d9c4 0x7c4cd09 0x7c482ee 0x7cf5030 0x7cf4929 0xf8dbc1a 0xf8f4a69 0x81cfe74 0x78b043b 0x789e118 0xfc77118, SQL_ID=E9E2014C8CE705871C555597A6A32456, SQL_STRING=CALL DBMS_STATS.ASYNC_GATHER_STATS_JOB_PROC(600000000);
这是日志文件

您好,您提的这个技术问题可能牵涉到 OceanBase 企业版范围内的功能细节;针对此类问题,建议你通过以下方式寻求帮助:

  1. 如你所在的企业客户已签署 OceanBase 企业版销售合同,请你联系客户经理;

  2. 如你所在的企业客户尚未签署 OceanBase 企业版销售合同,你可通过OceanBase官网商务咨询页面留下你的联系方式,OceanBase企业版的业务顾问会在一个工作日内与你联系。

另外,我们欢迎你使用社区版,并在论坛/社群中分享你对社区版本的想法、经验和问题,与其他社区成员共同交流。

(小助手的答复已结束,如未能解决您的问题,请继续提问并等待其他同学的回复,谢谢!)

麻烦发一下yaml文件和obd安装部署日志


obd.log (1.0 MB)

mini-local-example.txt (2.5 KB)

lscpu看一下有没有avx指令集。当前如果没avx指令集会导致ob运行崩溃

架构: x86_64
CPU 运行模式: 32-bit, 64-bit
字节序: Little Endian
Address sizes: 40 bits physical, 48 bits virtual
CPU: 8
在线 CPU 列表: 0-7
每个核的线程数: 1
每个座的核数: 1
座: 8
NUMA 节点: 1
厂商 ID: GenuineIntel
BIOS Vendor ID: GenuineIntel
CPU 系列: 6
型号: 37
型号名称: Intel(R) Xeon(R) CPU E7- 4820 @ 2.00GHz
BIOS Model name: Intel(R) Xeon(R) CPU E7- 4820 @ 2.00GHz
步进: 1
CPU MHz: 1995.000
BogoMIPS: 3990.00
超管理器厂商: VMware
虚拟化类型: 完全
L1d 缓存: 256 KiB
L1i 缓存: 256 KiB
L2 缓存: 2 MiB
L3 缓存: 144 MiB
NUMA 节点0 CPU: 0-7
Vulnerability Gather data sampling: Not affected
Vulnerability Itlb multihit: KVM: Vulnerable
Vulnerability L1tf: Mitigation; PTE Inversion
Vulnerability Mds: Vulnerable: Clear CPU buffers attempted, no microcode; SMT Host state unknown
Vulnerability Meltdown: Mitigation; PTI
Vulnerability Mmio stale data: Unknown: No mitigations
Vulnerability Retbleed: Not affected
Vulnerability Spec store bypass: Vulnerable
Vulnerability Spectre v1: Mitigation; usercopy/swapgs barriers and __user pointer sanitization
Vulnerability Spectre v2: Mitigation; Retpolines, STIBP disabled, RSB filling, PBRSB-eIBRS Not affected
Vulnerability Srbds: Not affected
Vulnerability Tsx async abort: Not affected
标记: fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts mmx fxsr sse sse2 ss syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts nopl xtopology tsc
_reliable nonstop_tsc cpuid aperfmperf pni pclmulqdq ssse3 cx16 sse4_1 sse4_2 x2apic popcnt aes hypervisor lahf_lm pti dtherm ida arat
没有avx指令集合

没有avx目前不支持安装使用ob

麻烦咨询下 有其他的解决方案吗? 更换版本或使用企业版吗

更换CPU,目前ob版本都需要avx指令集 :joy:

谢谢 :joy: