--- title: 执行超大 SQL，审计日志无法审计到，OBServer 日志报错 ret=-4024 的原因和解决方法-OceanBase数据库使用指南 description: 了解OceanBase数据库在实际应用中关于 执行超大 SQL，审计日志无法审计到，OBServer 日志报错 ret=-4024 的原因和解决方法相关的常见问题和使用技巧，帮助您快速解决 执行超大 SQL，审计日志无法审计到，OBServer 日志报错 ret=-4024 的原因和解决方法的难题。 --- 切换语言 - 简体中文 - English 划线反馈 # 执行超大 SQL，审计日志无法审计到，OBServer 日志报错 ret=-4024 的原因和解决方法 更新时间：2026-05-09 09:36 适用版本： V1.4.x、V2.1.x、V2.2.x、V3.1.x、V3.2.x、V4.0.x、V4.1.x、V4.2.x 内容类型：Troubleshoot ## 问题现象 开启审计功能后，执行超大 SQL 无法审计到。 关键日志报错 add new log 添加审计日志失败，报错 ret=-4024。 ```shell observer.log.20240705153627851:[2024-07-05 15:34:18.592591] WDIAG [STORAGE.TRANS] add_new_log (ob_tx_log.h:1183) [1416591][T1004_L0_G0][T1004][xxxxx-xxxxx-xxxxx-xxxxx] [lt=5][errcode=-4024] [TxLogBlock] add new log(ret=-4024, tx_log_body={LOG_TYPE:64, scheduler_:"xxx.xxx.xxx.xxx:xxxx", participants_:[{id:1001}], upstream_:{id:-1}, is_sub2pc_:false, is_dup_tx_:false, can_elr_:true, incremental_participants_:[], cluster_version_:17180000515, app_trace_id_str_:"", app_trace_info_:"", prev_record_lsn_:{lsn:18446744073709551615}, redo_lsns_:[{lsn:26554116942679}, {lsn:26554116980196}, {lsn:26554116998961}, {lsn:26554117036335}, {lsn:26554117073799}, {lsn:26554117092515}, {lsn:26554117129984}, {lsn:26554117167869}, {lsn:26554117186523}, {lsn:26554117242730}, {lsn:26554117261955}, {lsn:26554117299406}, {lsn:26554117336745}, {lsn:26554117355394}, {lsn:26554117392838}, {lsn:26554117430173}, {lsn:26554117448830}, {lsn:26554117486795}, {lsn:26554117524673}, {lsn:26554117543959}, {lsn:26554117581395}, {lsn:26554117618783}, {lsn:26554117655624}, {lsn:26554117693026}, {lsn:26554117711694}, {lsn:26554117749061}, {lsn:26554117786548}, {lsn:26554117824001}, {lsn:26554117842702}, {lsn:26554117880150}, {lsn:26554117917547}, {lsn:26554117955047}], xid_:{gtrid_str:"", bqual_str:"", format_id:1, gtrid_str_.ptr():"data_size:0, data:", bqual_str_.ptr():"data_size:0, data:", g_hv:0, b_hv:0}}, *this={fill_buf_:{buf:null, use_default_buf:true}, replay_buf_:null, len_:2048, pos_:768, cur_log_type_:0, cb_arg_array_:[{log_type:0x1, arg:null}], big_segment_buf_:NULL}, tmp_pos=768) observer.log.20240705153627851:[2024-07-05 15:34:18.592659] WDIAG [STORAGE.TRANS] add_new_log (ob_tx_log.h:1183) [1416591][T1004_L0_G0][T1004][xxxxx-xxxxx-xxxxx-xxxxx] [lt=32][errcode=-4024] [TxLogBlock] add new log(ret=-4024, tx_log_body={LOG_TYPE:64, scheduler_:"xxx.xxx.xxx.xxx:xxx", participants_:[{id:1001}], upstream_:{id:-1}, is_sub2pc_:false, is_dup_tx_:false, can_elr_:true, incremental_participants_:[], cluster_version_:17180000515, app_trace_id_str_:"", app_trace_info_:"", prev_record_lsn_:{lsn:18446744073709551615}, redo_lsns_:[{lsn:26554116942679}, {lsn:26554116980196}, {lsn:26554116998961}, {lsn:26554117036335}, {lsn:26554117073799}, {lsn:26554117092515}, {lsn:26554117129984}, {lsn:26554117167869}, {lsn:26554117186523}, {lsn:26554117242730}, {lsn:26554117261955}, {lsn:26554117299406}, {lsn:26554117336745}, {lsn:26554117355394}, {lsn:26554117392838}, {lsn:26554117430173}, {lsn:26554117448830}, {lsn:26554117486795}, {lsn:26554117524673}, {lsn:26554117543959}, {lsn:26554117581395}, {lsn:26554117618783}, {lsn:26554117655624}, {lsn:26554117693026}, {lsn:26554117711694}, {lsn:26554117749061}, {lsn:26554117786548}, {lsn:26554117824001}, {lsn:26554117842702}, {lsn:26554117880150}, {lsn:26554117917547}, {lsn:26554117955047}], xid_:{gtrid_str:"", bqual_str:"", format_id:1, gtrid_str_.ptr():"data_size:0, data:", bqual_str_.ptr():"data_size:0, data:", g_hv:0, b_hv:0}}, *this={fill_buf_:{buf:null, use_default_buf:true}, replay_buf_:null, len_:2048, pos_:57, cur_log_type_:0, cb_arg_array_:[], big_segment_buf_:NULL}, tmp_pos=57) observer.log.20240705153627851:[2024-07-05 15:34:18.592677] WDIAG [STORAGE.TRANS] submit_redo_commit_info_log_ (ob_trans_part_ctx.cpp:3000) [1416591][T1004_L0_G0][T1004][xxxxx-xxxxx-xxxxx-xxxxx] [lt=17][errcode=-4024] add new log failed(ret=-4024, ret="OB_BUF_NOT_ENOUGH", *this={this:0x7efe75601b50, trans_id:{txid:3175775088}, tenant_id:1004, is_exiting:false, trans_expired_time:1720251258263215, cluster_version:17180000515, trans_need_wait_wrap:{receive_gts_ts_:[mts=0], need_wait_interval_us:0}, stc:[mts=1720164858592374], ctx_create_time:1720164858263215}{ls_id:{id:1001}, session_id:3221611577, part_trans_action:2, pending_write:0, exec_info:{state:10, upstream:{id:-1}, participants:[{id:1001}], incremental_participants:[], prev_record_lsn:{lsn:18446744073709551615}, redo_lsns:[{lsn:26554116942679}, {lsn:26554116980196}, {lsn:26554116998961}, {lsn:26554117036335}, {lsn:26554117073799}, {lsn:26554117092515}, {lsn:26554117129984}, {lsn:26554117167869}, {lsn:26554117186523}, {lsn:26554117242730}, {lsn:26554117261955}, {lsn:26554117299406}, {lsn:26554117336745}, {lsn:26554117355394}, {lsn:26554117392838}, {lsn:26554117430173}, {lsn:26554117448830}, {lsn:26554117486795}, {lsn:26554117524673}, {lsn:26554117543959}, {lsn:26554117581395}, {lsn:26554117618783}, {lsn:26554117655624}, {lsn:26554117693026}, {lsn:26554117711694}, {lsn:26554117749061}, {lsn:26554117786548}, {lsn:26554117824001}, {lsn:26554117842702}, {lsn:26554117880150}, {lsn:26554117917547}, {lsn:26554117955047}], redo_log_no:266, multi_data_source:[], scheduler:"xxx.xxx.xxx.xxx:xxxx", prepare_version:{val:18446744073709551615, v:3}, trans_type:0, next_log_entry_no:266, max_applied_log_ts:{val:1720164858578418197, v:0}, max_applying_log_ts:{val:1720164858578418197, v:0}, max_applying_part_log_no:0, max_submitted_seq_no:1720164858590948, checksum:0, checksum_scn:{val:0, v:0}, max_durable_lsn:{lsn:26554125319598}, data_complete:false, is_dup_tx:false, prepare_log_info_arr:[], xid:{gtrid_str:"", bqual_str:"", format_id:1, gtrid_str_.ptr():"data_size:0, data:", bqual_str_.ptr():"data_size:0, data:", g_hv:0, b_hv:0}, need_checksum:true, is_sub2pc:false}, sub_state:{flag:0}, is_leaf():false, is_root():false, busy_cbs_.get_size():1, final_log_cb_:{ObTxBaseLogCb:{base_ts:{val:18446744073709551615, v:3}, log_ts:{val:18446744073709551615, v:3}, lsn:{lsn:18446744073709551615}, submit_ts:0}, this:0x7efe75604b10, is_inited_:true, trans_id:{txid:3175775088}, ls_id:{id:1001}, ctx:0x7efe75601b50, tx_data_guard:{tx_data:NULL}, is_callbacked_:false, is_dynamic_:false, mds_range_:{range_array_.count():0, range_array_:[]}, cb_arg_array_:[], first_part_scn_:{val:18446744073709551615, v:3}}, ctx_tx_data_:{ctx_mgr_:0x7efe518c6030, tx_data_guard_:{tx_data:{tx_id:{txid:3175775088}, ref_cnt:1, state:"RUNNING", commit_version:{val:1720164858592379453, v:0}, start_scn:{val:1720164858215543355, v:0}, end_scn:{val:18446744073709551615, v:3}, undo_status_list:{head:0x7efe2e57cc50, undo_node_cnt:1{{undo_action:{undo_from:1720164858590873, undo_to:1720164858579312}}}}}}, read_only_:false}, role_state_:0, start_replay_ts_:{val:18446744073709551615, v:3}, start_recover_ts_:{val:18446744073709551615, v:3}, is_incomplete_replay_ctx_:false, mt_ctx_:{ObIMvccCtx={alloc_type=0 ctx_descriptor=0 min_table_version=1720151292009616 max_table_version=1720151292009616 trans_version={val:1720164858592379453, 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:3175775088} ls_id=1001 callback_alloc_count=10242 callback_free_count=5263 checksum=0 tmp_checksum=1158591252 checksum_scn={val:1720164858574841675, v:0} redo_filled_count=10247 redo_sync_succ_count=10241 redo_sync_fail_count=0 main_list_length=4982 unsynced_cnt=4 unsubmitted_cnt_=0 cb_statistics:[main=10249, slave=0, merge=0, tx_end=0, rollback_to=4, fast_commit=5263, remove_memtable=0]}, coord_prepare_info_arr_:[], upstream_state:10, retain_cause:-1, 2pc_role:-1, collected:[], ref:4, rec_log_ts:{val:1720164858215543355, v:0}, prev_rec_log_ts:{val:18446744073709551615, v:3}, lastest_snapshot:{val:18446744073709551615, v:3}, state_info_array:[], last_request_ts:1720164858590872, block_frozen_memtable:null}) observer.log.20240705153627851:[2024-07-05 15:34:44.709007] WDIAG [STORAGE.TRANS] add_new_log (ob_tx_log.h:1183) [1411246][T1004_L0_G0][T1004][xxxxx-xxxxx-xxxxx-xxxxx] [lt=7][errcode=-4024] [TxLogBlock] add new log(ret=-4024, tx_log_body={LOG_TYPE:64, scheduler_:"xxx.xxx.xxx.xxx:xxxx", participants_:[{id:1001}], upstream_:{id:-1}, is_sub2pc_:false, is_dup_tx_:false, can_elr_:true, incremental_participants_:[], cluster_version_:17180000515, app_trace_id_str_:"", app_trace_info_:"", prev_record_lsn_:{lsn:18446744073709551615}, redo_lsns_:[{lsn:26555645360370}, {lsn:26555645453192}, {lsn:26555645545795}, {lsn:26555645638467}, {lsn:26555645712597}, {lsn:26555645786621}, {lsn:26555645861074}, {lsn:26555645972314}, {lsn:26555646046815}, {lsn:26555646158259}, {lsn:26555646232249}, {lsn:26555646287965}, {lsn:26555646380565}, {lsn:26555646454434}, {lsn:26555646510195}, {lsn:26555646565964}, {lsn:26555646603209}, {lsn:26555646677517}, {lsn:26555646696225}, {lsn:26555646714887}, {lsn:26555646770619}, {lsn:26555646826479}, {lsn:26555646882139}, {lsn:26555647030253}, {lsn:26555647085906}, {lsn:26555647215613}, {lsn:26555647252787}, {lsn:26555647271532}, {lsn:26555647345891}, {lsn:26555647364571}, {lsn:26555647438499}, {lsn:26555647553542}], xid_:{gtrid_str:"", bqual_str:"", format_id:1, gtrid_str_.ptr():"data_size:0, data:", bqual_str_.ptr():"data_size:0, data:", g_hv:0, b_hv:0}}, *this={fill_buf_:{buf:null, use_default_buf:true}, replay_buf_:null, len_:2048, pos_:767, cur_log_type_:0, cb_arg_array_:[{log_type:0x1, arg:null}], big_segment_buf_:NULL}, tmp_pos=767) observer.log.20240705153627851:[2024-07-05 15:34:44.709057] WDIAG [STORAGE.TRANS] add_new_log (ob_tx_log.h:1183) [1411246][T1004_L0_G0][T1004][xxxxx-xxxxx-xxxxx-xxxxx] [lt=41][errcode=-4024] [TxLogBlock] add new log(ret=-4024, tx_log_body={LOG_TYPE:64, scheduler_:"xxx.xxx.xxxx.xxx:xxxx", participants_:[{id:1001}], upstream_:{id:-1}, is_sub2pc_:false, is_dup_tx_:false, can_elr_:true, incremental_participants_:[], cluster_version_:17180000515, app_trace_id_str_:"", app_trace_info_:"", prev_record_lsn_:{lsn:18446744073709551615}, redo_lsns_:[{lsn:26555645360370}, {lsn:26555645453192}, {lsn:26555645545795}, {lsn:26555645638467}, {lsn:26555645712597}, {lsn:26555645786621}, {lsn:26555645861074}, {lsn:26555645972314}, {lsn:26555646046815}, {lsn:26555646158259}, {lsn:26555646232249}, {lsn:26555646287965}, {lsn:26555646380565}, {lsn:26555646454434}, {lsn:26555646510195}, {lsn:26555646565964}, {lsn:26555646603209}, {lsn:26555646677517}, {lsn:26555646696225}, {lsn:26555646714887}, {lsn:26555646770619}, {lsn:26555646826479}, {lsn:26555646882139}, {lsn:26555647030253}, {lsn:26555647085906}, {lsn:26555647215613}, {lsn:26555647252787}, {lsn:26555647271532}, {lsn:26555647345891}, {lsn:26555647364571}, {lsn:26555647438499}, {lsn:26555647553542}], xid_:{gtrid_str:"", bqual_str:"", format_id:1, gtrid_str_.ptr():"data_size:0, data:", bqual_str_.ptr():"data_size:0, data:", g_hv:0, b_hv:0}}, *this={fill_buf_:{buf:null, use_default_buf:true}, replay_buf_:null, len_:2048, pos_:57, cur_log_type_:0, cb_arg_array_:[], big_segment_buf_:NULL}, tmp_pos=57) ``` ## 问题原因 在 OceanBase 数据库 V4.2.4 版本之前，审计日志无法审计到超长 SQL，目前审计日志一条日志记录的上限是 64k，这 64k 包含执行的 SQL 和记录的其他审计信息，执行的 SQL 大小约超过 60k 左右，就无法成功写到审计日志。 ## 问题的风险及影响 审计日志丢失信息。 ## 影响租户 影响 OceanBase 数据库中的 SYS 租户和 Oracle 租户以及 MySQL 租户。 ## 适用版本 OceanBase 数据库企业版 V4.2.4（oceanbase-4.2.4.0-100000252024070621）之前版本。 ## 解决方法 升级至问题已修复版本。目前已修复的版本包括 OceanBase 数据库企业版 V4.2.4（oceanbase-4.2.4.0-100000252024070621）及之后版本。 Previous [OceanBase 数据库 V4.x 版本 Oracle 模式租户下，跨用户访问 INDEX 的 DDL，报错 ORA-31603: object 'XXXXX' of type INDEX not found 的原因和解决方法](https://www.oceanbase.com/knowledge-base/oceanbase-database-1000000001928611) Next [业务无感知的列加密功能特性说明](https://www.oceanbase.com/knowledge-base/oceanbase-database-1000000003956169) ![有帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*y6ocSqN8cqsAAAAAAAAAAAAAARQnAQ)![无帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*BG9IQJyLHF8AAAAAAAAAAAAAARQnAQ)![反馈](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*eTWdQKCRKHwAAAAAAAAAAAAAARQnAQ)[AI](https://www.oceanbase.com/obi) 咨询热线