ob反复建库导致obbinlog instance挂了

【 使用环境 】 测试环境
【 OB or 其他组件 】
【 使用版本 】obbinlog版本4.2.5-100000042025052216 observer版本 OceanBase_CE 4.3.5.2 (r102020032025070315-563ee271f78ff8521c8e0e09ae682065b065a046) (Built Jul 3 2025 15:55:00)
obproxy (OceanBase 4.3.4.0 1)

【问题描述】启动binlog server后,多次执行添加和删除数据库操作报错
【复现路径】问题出现前后相关操作
【附件及日志】推荐使用OceanBase敏捷诊断工具obdiag收集诊断信息,详情参见链接(右键跳转查看):

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

【备注】基于 LLM 和开源文档 RAG 的论坛小助手已开放测试,在发帖时输入 [@论坛小助手] 即可召唤小助手,欢迎试用!

logproxy.log (812.9 KB)

1 个赞

根据您的描述,看起来 obbinlog 服务在进行添加和删除数据库操作时出现了异常,导致服务挂掉。这种情况可能与 binlog 服务的配置、日志记录、以及与 Observer 和 ObProxy 之间的交互有关。为了更准确地定位问题,您可以先使用 obdiag 工具进行日志采集,然后将日志发送给我们进行进一步分析。

日志采集

日志采集场景: obbinlog 挂掉问题
日志采集命令:

obdiag gather scene run --scene=observer.obbinlog_crash

根因分析

目前 obdiag 并没有直接针对 obbinlog 挂掉的根因分析场景,但我们可以从日志中提取有用的信息来分析问题。因此,主要依赖于日志采集的结果。

下一步

请您执行上述日志采集命令,并将生成的日志文件压缩包发送给我们。这将帮助我们更好地理解问题的根源。

为了更好地诊断问题,请您提供以下信息:

  1. obbinlog 的具体配置文件内容(如 binlog_server.conf)。
  2. 在执行添加和删除数据库操作时的具体错误日志或错误消息。
  3. obbinlog 服务的启动命令及其参数。
  4. obproxy 和 observer 的日志中是否有与 obbinlog 相关的错误或警告信息。
  5. 系统资源监控信息(如 CPU、内存、磁盘 I/O 使用情况)在 obbinlog 挂掉前后的情况。

感谢您的配合,我们将尽快为您解决问题。

附上敏捷诊断工具 obdiag 使用帮助链接

2 个赞

是整个obbinlog的服务 宕机了么?还是binlog实例宕机了?
sysctl -a | grep pattern 看看这个设置没有

2 个赞

ulimit -c 如果查出来 不为零
看一下 这个文件下 是否有core文件生成
image

1 个赞

看着创建库也失败了 这个截图报错 是observer.log的日志信息么?

1 个赞

libobcdc.log.stderr,创建数据库成功了,应该说instance挂了

BUG吗

1 个赞

学习学习!

1 个赞

老师发下其他的日志,看起来有报错内存泄漏
logproxy.log (812.9 KB)
binlog_instance.log (49.9 KB)
libobcdc.log (12.7 MB)

[2025-07-22 16:10:10.942540] INFO [TLOG] parse_ddl_info (ob_log_part_trans_task.cpp:1769) [134892][][T0][YDED0A0B087A-0000000002B00002-0-0] [lt=18] [STAT] [DDL] [PARSE] OP_TYPE=OB_DDL_TRUNCATE_TABLE(59) SCHEMA_VERSION=1753171723430112 VERSION_DELAY=[87.512423 sec] EXEC_TENANT_ID=1004 TABLE_ID=500009 TENANT_ID=1004 DB_ID=500001 TG_ID=-1 DDL_STMT=[truncate table t1] CONTAIN_DDL=1 IS_VALID=1

[2025-07-22 16:10:10.942620] INFO [TLOG] parse_ddl_info (ob_log_part_trans_task.cpp:1769) [134892][][T0][YDED0A0B087A-0000000002B00002-0-0] [lt=52] [STAT] [DDL] [PARSE] OP_TYPE=OB_DDL_UPDATE_TABLE_SCHEMA_VERSION(50) SCHEMA_VERSION=1753171723430120 VERSION_DELAY=[87.512498 sec] EXEC_TENANT_ID=1004 TABLE_ID=500009 TENANT_ID=1004 DB_ID=500001 TG_ID=-1 DDL_STMT=[] CONTAIN_DDL=0 IS_VALID=0

[2025-07-22 16:10:10.942657] INFO [TLOG] parse_ddl_info (ob_log_part_trans_task.cpp:1769) [134892][][T0][YDED0A0B087A-0000000002B00002-0-0] [lt=23] [STAT] [DDL] [PARSE] OP_TYPE=OB_DDL_END_SIGN(1503) SCHEMA_VERSION=1753171723430128 VERSION_DELAY=[87.512528 sec] EXEC_TENANT_ID=1004 TABLE_ID=0 TENANT_ID=1004 DB_ID=0 TG_ID=0 DDL_STMT=[] CONTAIN_DDL=0 IS_VALID=0

[2025-07-22 16:10:10.954463] WDIAG [SHARE] deserialize_ (ob_rpc_struct.cpp:10715) [134884][][T0][YDED0A0B087A-0000000001D00006-0-0] [lt=0][errcode=-4016] failed to deserialize_for_create_tablet_schemas(ret=-4016, ret=“OB_ERR_UNEXPECTED”)

[2025-07-22 16:10:10.954524] WDIAG deserialize (ob_rpc_struct.cpp:10703) [134884][][T0][YDED0A0B087A-0000000001D00006-0-0] [lt=58][errcode=-4016] deserialize_ fail(slen=301, pos=52, ret=-4016)

[2025-07-22 16:10:10.954553] EDIAG [TLOG.PARSER] parse_from_multi_data_source_buf (ob_cdc_tablet_to_table_info.cpp:122) [134884][][T0][YDED0A0B087A-0000000001D00006-0-0] [lt=20][errcode=-4016] deserialize create_tablet_arg failed(ret=-4016, ret=“OB_ERR_UNEXPECTED”, tls_id={tenant_id:1004, ls_id:{id:1002}}, multi_data_source_node={register_no_:0, seq_no_:1, has_submitted_:false, has_synced_:false, type:“CREATE_TABLET_NEW_MDS”, data_.length():307, has_deserialized_buffer_ctx_:false}, create_tablet_arg=id:{id:-1}, major_frozen_scn:{val:18446744073709551615, v:3}, need_check_tablet_cnt:false, is_old_mds:false, tablets:[], tablet_extra_infos:[], clog_checkpoint_scn:{val:18446744073709551615, v:3}, create_type:1, mds_checkpoint_scn:{val:18446744073709551615, v:3}, buf_len=307, pos=307) BACKTRACE:0x1321a326 0x12e8ba16 0x1311a3c0 0x13119cc6 0x13119931 0x130d394a 0x173e4627 0x173e3e15 0x176f4bd1 0x176f4913 0x17883035 0x17882afa 0x1774a6cd 0x17749a18 0x17814e89 0x2e05ed05 0x2e05a83c 0x7fd00d2a4ea5 0x7fd00a99296d

[2025-07-22 16:10:10.955416] EDIAG [TLOG] parse_tablet_change_mds_ (ob_log_part_trans_task.cpp:3795) [134884][][T0][YDED0A0B087A-0000000001D00006-0-0] [lt=857][errcode=-4016] parse_from_multi_data_source_buf to tablet_change_info failed(ret=-4016, ret=“OB_ERR_UNEXPECTED”, tls_id={tenant_id:1004, ls_id:{id:1002}}, trans_id={txid:5248182}, multi_data_source_node={lsn:{lsn:1480293106}, tx_buf_node:{register_no_:0, seq_no_:1, has_submitted_:false, has_synced_:false, type:“CREATE_TABLET_NEW_MDS”, data_.length():307, has_deserialized_buffer_ctx_:false}}, tx_buf_node={register_no_:0, seq_no_:1, has_submitted_:false, has_synced_:false, type:“CREATE_TABLET_NEW_MDS”, data_.length():307, has_deserialized_buffer_ctx_:false}) BACKTRACE:0x1321a326 0x12e8ba16 0x130def1a 0x130de896 0x130de502 0x12d2d69b 0x176fe34e 0x176f4cc2 0x176f4913 0x17883035 0x17882afa 0x1774a6cd 0x17749a18 0x17814e89 0x2e05ed05 0x2e05a83c 0x7fd00d2a4ea5 0x7fd00a99296d

[2025-07-22 16:10:10.955620] EDIAG [TLOG] parse_multi_data_source_data (ob_log_part_trans_task.cpp:2988) [134884][][T0][YDED0A0B087A-0000000001D00006-0-0] [lt=201][errcode=-4016] parse_tablet_change_mds_ failed(ret=-4016, ret=“OB_ERR_UNEXPECTED”, tls_id={tenant_id:1004, ls_id:{id:1002}}, trans_id={txid:5248182}, mds_node={lsn:{lsn:1480293106}, tx_buf_node:{register_no_:0, seq_no_:1, has_submitted_:false, has_synced_:false, type:“CREATE_TABLET_NEW_MDS”, data_.length():307, has_deserialized_buffer_ctx_:false}}, idx=1, this={state:1, type:“DML_TRANS”, type:1, cluster_id:1751943680, exec_tenant_id:0, tls_id:{tenant_id:1004, ls_id:{id:1002}}, trans_id:{txid:5248182}, trans_type:“DIST”, is_xa_or_dup:false, is_trans_committed:true, trans_commit_version:1753171723448564000, prepare_ts:1753171723431771001, prepare_log_lsn:{lsn:1480293648}, commit_ts:1753171723448564000, commit_log_lsn:{lsn:1480293995}, participant_count:2, participants:[{id_:{id:1}, offset_:{lsn:2021989594}}, {id_:{id:1002}, offset_:{lsn:1480293648}}], trace_id:"", trace_info:"", sorted_log_entry_info:{fetched_log_entry_count:2, recorded_lsn_count:2, fetched_log_entry_arr:{sorted_treeify_list:{count:2}, is_tree_mode:false, auto_treeify_mode:true, is_tree_empty:true, list:{sorted_linked_list:{count:2}, is_list_empty:false, l_head:{val:{lsn:{lsn:1480293106}, next:null}}, l_tail:{val:{lsn:{lsn:1480293648}, next:null}}, l_tail:{val:{lsn:{lsn:1480293648}, next:null}}, is_unique:true}, auto_treeify_threshold:32, auto_untreeify_threshold:30}, recorded_lsn_arr:[{lsn:1480293106}, {lsn:1480293648}]}, sorted_redo_list:{ready_node_num:1, redo_sorted_progress:{dispatched_redo_count:0, sorted_redo_count:0, sorted_row_seq_no:0}, cur_dispatch_redo:{list:{sorted_treeify_list:{count:1}, is_tree_mode:false, auto_treeify_mode:true, is_tree_empty:true, list:{sorted_linked_list:{count:1}, is_list_empty:false, l_head:{val:log_lsn=[1480293648]size=65, pos=0, next=0}, l_tail:{val:log_lsn=[1480293648]size=65, pos=0, next=0}, l_tail:{val:log_lsn=[1480293648]size=65, pos=0, next=0}, is_unique:true}, auto_treeify_threshold:32, auto_untreeify_threshold:30}, node_ptr:{val:log_lsn=[1480293648]size=65, pos=0, next=0}}, cur_sort_redo:{list:{sorted_treeify_list:{count:1}, is_tree_mode:false, auto_treeify_mode:true, is_tree_empty:true, list:{sorted_linked_list:{count:1}, is_list_empty:false, l_head:{val:log_lsn=[1480293648]size=65, pos=0, next=0}, l_tail:{val:log_lsn=[1480293648]size=65, pos=0, next=0}, l_tail:{val:log_lsn=[1480293648]size=65, pos=0, next=0}, is_unique:true}, auto_treeify_threshold:32, auto_untreeify_threshold:30}, node_ptr:{val:log_lsn=[1480293648]size=65, pos=0, next=0}}, cur_sort_stmt:null, is_dml_stmt_iter_end:false}, rollback_list:{head:null, tail:null, num:0}, part_tx_fetch_state:6, ref_cnt:2, multi_data_source_node_arr:[{lsn:{lsn:1480293106}, tx_buf_node:{register_no_:0, seq_no_:1, has_submitted_:false, has_synced_:false, type:“DELETE_TABLET_NEW_MDS”, data_.length():24, has_deserialized_buffer_ctx_:false}}, {lsn:{lsn:1480293106}, tx_buf_node:{register_no_:0, seq_no_:1, has_submitted_:false, has_synced_:false, type:“CREATE_TABLET_NEW_MDS”, data_.length():307, has_deserialized_buffer_ctx_:false}}], multi_data_source_info:has_ls_table_op: false, is_ddl_trans: 0, tablet_change_info: [{cmd:2, create_tablet_cnt:0, delete_tablet_cnt:1, exchange_tablet_cnt:0}]}, checkpoint_seq:46, global_trans_seq:0, global_schema_version:-1, local_schema_version:-1, stmt_list:{head:null, tail:null, num:0}, is_data_ready:true, wait_formatted_cond:null, output_br_count_by_turn:0, next_task:null}) BACKTRACE:0x1321a326 0x12e8ba16 0x1311a3c0 0x13119cc6 0x13119931 0x130d394a 0x176f4fdd 0x176f49b7 0x17883035 0x17882afa 0x1774a6cd 0x17749a18 0x17814e89 0x2e05ed05 0x2e05a83c 0x7fd00d2a4ea5 0x7fd00a99296d

[2025-07-22 16:10:10.955871] EDIAG [TLOG] add_ready_participant_ (ob_log_trans_ctx.cpp:505) [134884][][T0][YDED0A0B087A-0000000001D00006-0-0] [lt=248][errcode=-4016] parse_multi_data_source_data failed(ret=-4016, ret=“OB_ERR_UNEXPECTED”, part_trans_task={state:1, type:“DML_TRANS”, type:1, cluster_id:1751943680, exec_tenant_id:0, tls_id:{tenant_id:1004, ls_id:{id:1002}}, trans_id:{txid:5248182}, trans_type:“DIST”, is_xa_or_dup:false, is_trans_committed:true, trans_commit_version:1753171723448564000, prepare_ts:1753171723431771001, prepare_log_lsn:{lsn:1480293648}, commit_ts:1753171723448564000, commit_log_lsn:{lsn:1480293995}, participant_count:2, participants:[{id_:{id:1}, offset_:{lsn:2021989594}}, {id_:{id:1002}, offset_:{lsn:1480293648}}], trace_id:"", trace_info:"", sorted_log_entry_info:{fetched_log_entry_count:2, recorded_lsn_count:2, fetched_log_entry_arr:{sorted_treeify_list:{count:2}, is_tree_mode:false, auto_treeify_mode:true, is_tree_empty:true, list:{sorted_linked_list:{count:2}, is_list_empty:false, l_head:{val:{lsn:{lsn:1480293106}, next:null}}, l_tail:{val:{lsn:{lsn:1480293648}, next:null}}, l_tail:{val:{lsn:{lsn:1480293648}, next:null}}, is_unique:true}, auto_treeify_threshold:32, auto_untreeify_threshold:30}, recorded_lsn_arr:[{lsn:1480293106}, {lsn:1480293648}]}, sorted_redo_list:{ready_node_num:1, redo_sorted_progress:{dispatched_redo_count:0, sorted_redo_count:0, sorted_row_seq_no:0}, cur_dispatch_redo:{list:{sorted_treeify_list:{count:1}, is_tree_mode:false, auto_treeify_mode:true, is_tree_empty:true, list:{sorted_linked_list:{count:1}, is_list_empty:false, l_head:{val:log_lsn=[1480293648]size=65, pos=0, next=0}, l_tail:{val:log_lsn=[1480293648]size=65, pos=0, next=0}, l_tail:{val:log_lsn=[1480293648]size=65, pos=0, next=0}, is_unique:true}, auto_treeify_threshold:32, auto_untreeify_threshold:30}, node_ptr:{val:log_lsn=[1480293648]size=65, pos=0, next=0}}, cur_sort_redo:{list:{sorted_treeify_list:{count:1}, is_tree_mode:false, auto_treeify_mode:true, is_tree_empty:true, list:{sorted_linked_list:{count:1}, is_list_empty:false, l_head:{val:log_lsn=[1480293648]size=65, pos=0, next=0}, l_tail:{val:log_lsn=[1480293648]size=65, pos=0, next=0}, l_tail:{val:log_lsn=[1480293648]size=65, pos=0, next=0}, is_unique:true}, auto_treeify_threshold:32, auto_untreeify_threshold:30}, node_ptr:{val:log_lsn=[1480293648]size=65, pos=0, next=0}}, cur_sort_stmt:null, is_dml_stmt_iter_end:false}, rollback_list:{head:null, tail:null, num:0}, part_tx_fetch_state:6, ref_cnt:2, multi_data_source_node_arr:[{lsn:{lsn:1480293106}, tx_buf_node:{register_no_:0, seq_no_:1, has_submitted_:false, has_synced_:false, type:“DELETE_TABLET_NEW_MDS”, data_.length():24, has_deserialized_buffer_ctx_:false}}, {lsn:{lsn:1480293106}, tx_buf_node:{register_no_:0, seq_no_:1, has_submitted_:false, has_synced_:false, type:“CREATE_TABLET_NEW_MDS”, data_.length():307, has_deserialized_buffer_ctx_:false}}], multi_data_source_info:has_ls_table_op: false, is_ddl_trans: 0, tablet_change_info: [{cmd:2, create_tablet_cnt:0, delete_tablet_cnt:1, exchange_tablet_cnt:0}]}, checkpoint_seq:46, global_trans_seq:0, global_schema_version:-1, local_schema_version:-1, stmt_list:{head:null, tail:null, num:0}, is_data_ready:true, wait_formatted_cond:null, output_br_count_by_turn:0, next_task:null}) BACKTRACE:0x1321a326 0x12e8ba16 0x1303d593 0x1303d23c 0x1303cedc 0x1303ccca 0x178851e2 0x178831a1 0x17882afa 0x1774a6cd 0x17749a18 0x17814e89 0x2e05ed05 0x2e05a83c 0x7fd00d2a4ea5 0x7fd00a99296d

[2025-07-22 16:10:10.956111] EDIAG [TLOG] add_participant (ob_log_trans_ctx.cpp:287) [134884][][T0][YDED0A0B087A-0000000001D00006-0-0] [lt=238][errcode=-4016] add_ready_participant_ fail(ret=-4016, ret=“OB_ERR_UNEXPECTED”, part_trans_task={state:1, type:“DML_TRANS”, type:1, cluster_id:1751943680, exec_tenant_id:0, tls_id:{tenant_id:1004, ls_id:{id:1002}}, trans_id:{txid:5248182}, trans_type:“DIST”, is_xa_or_dup:false, is_trans_committed:true, trans_commit_version:1753171723448564000, prepare_ts:1753171723431771001, prepare_log_lsn:{lsn:1480293648}, commit_ts:1753171723448564000, commit_log_lsn:{lsn:1480293995}, participant_count:2, participants:[{id_:{id:1}, offset_:{lsn:2021989594}}, {id_:{id:1002}, offset_:{lsn:1480293648}}], trace_id:"", trace_info:"", sorted_log_entry_info:{fetched_log_entry_count:2, recorded_lsn_count:2, fetched_log_entry_arr:{sorted_treeify_list:{count:2}, is_tree_mode:false, auto_treeify_mode:true, is_tree_empty:true, list:{sorted_linked_list:{count:2}, is_list_empty:false, l_head:{val:{lsn:{lsn:1480293106}, next:null}}, l_tail:{val:{lsn:{lsn:1480293648}, next:null}}, l_tail:{val:{lsn:{lsn:1480293648}, next:null}}, is_unique:true}, auto_treeify_threshold:32, auto_untreeify_threshold:30}, recorded_lsn_arr:[{lsn:1480293106}, {lsn:1480293648}]}, sorted_redo_list:{ready_node_num:1, redo_sorted_progress:{dispatched_redo_count:0, sorted_redo_count:0, sorted_row_seq_no:0}, cur_dispatch_redo:{list:{sorted_treeify_list:{count:1}, is_tree_mode:false, auto_treeify_mode:true, is_tree_empty:true, list:{sorted_linked_list:{count:1}, is_list_empty:false, l_head:{val:log_lsn=[1480293648]size=65, pos=0, next=0}, l_tail:{val:log_lsn=[1480293648]size=65, pos=0, next=0}, l_tail:{val:log_lsn=[1480293648]size=65, pos=0, next=0}, is_unique:true}, auto_treeify_threshold:32, auto_untreeify_threshold:30}, node_ptr:{val:log_lsn=[1480293648]size=65, pos=0, next=0}}, cur_sort_redo:{list:{sorted_treeify_list:{count:1}, is_tree_mode:false, auto_treeify_mode:true, is_tree_empty:true, list:{sorted_linked_list:{count:1}, is_list_empty:false, l_head:{val:log_lsn=[1480293648]size=65, pos=0, next=0}, l_tail:{val:log_lsn=[1480293648]size=65, pos=0, next=0}, l_tail:{val:log_lsn=[1480293648]size=65, pos=0, next=0}, is_unique:true}, auto_treeify_threshold:32, auto_untreeify_threshold:30}, node_ptr:{val:log_lsn=[1480293648]size=65, pos=0, next=0}}, cur_sort_stmt:null, is_dml_stmt_iter_end:false}, rollback_list:{head:null, tail:null, num:0}, part_tx_fetch_state:6, ref_cnt:2, multi_data_source_node_arr:[{lsn:{lsn:1480293106}, tx_buf_node:{register_no_:0, seq_no_:1, has_submitted_:false, has_synced_:false, type:“DELETE_TABLET_NEW_MDS”, data_.length():24, has_deserialized_buffer_ctx_:false}}, {lsn:{lsn:1480293106}, tx_buf_node:{register_no_:0, seq_no_:1, has_submitted_:false, has_synced_:false, type:“CREATE_TABLET_NEW_MDS”, data_.length():307, has_deserialized_buffer_ctx_:false}}], multi_data_source_info:has_ls_table_op: false, is_ddl_trans: 0, tablet_change_info: [{cmd:2, create_tablet_cnt:0, delete_tablet_cnt:1, exchange_tablet_cnt:0}]}, checkpoint_seq:46, global_trans_seq:0, global_schema_version:-1, local_schema_version:-1, stmt_list:{head:null, tail:null, num:0}, is_data_ready:true, wait_formatted_cond:null, output_br_count_by_turn:0, next_task:null}, is_part_trans_served=true, is_all_participants_ready=false) BACKTRACE:0x1321a326 0x12e8ba16 0x12fcf521 0x12fcef8c 0x12fcebff 0x12fce9e4 0x178833f9 0x17882b22 0x1774a6cd 0x17749a18 0x17814e89 0x2e05ed05 0x2e05a83c 0x7fd00d2a4ea5 0x7fd00a99296d

[2025-07-22 16:10:10.956329] EDIAG [TLOG.SEQUENCER] handle_part_trans_task_ (ob_log_sequencer1.cpp:605) [134884][][T0][YDED0A0B087A-0000000001D00006-0-0] [lt=215][errcode=-4016] add participant fail(ret=-4016, ret=“OB_ERR_UNEXPECTED”, part_trans_task={state:1, type:“DML_TRANS”, type:1, cluster_id:1751943680, exec_tenant_id:0, tls_id:{tenant_id:1004, ls_id:{id:1002}}, trans_id:{txid:5248182}, trans_type:“DIST”, is_xa_or_dup:false, is_trans_committed:true, trans_commit_version:1753171723448564000, prepare_ts:1753171723431771001, prepare_log_lsn:{lsn:1480293648}, commit_ts:1753171723448564000, commit_log_lsn:{lsn:1480293995}, participant_count:2, participants:[{id_:{id:1}, offset_:{lsn:2021989594}}, {id_:{id:1002}, offset_:{lsn:1480293648}}], trace_id:"", trace_info:"", sorted_log_entry_info:{fetched_log_entry_count:2, recorded_lsn_count:2, fetched_log_entry_arr:{sorted_treeify_list:{count:2}, is_tree_mode:false, auto_treeify_mode:true, is_tree_empty:true, list:{sorted_linked_list:{count:2}, is_list_empty:false, l_head:{val:{lsn:{lsn:1480293106}, next:null}}, l_tail:{val:{lsn:{lsn:1480293648}, next:null}}, l_tail:{val:{lsn:{lsn:1480293648}, next:null}}, is_unique:true}, auto_treeify_threshold:32, auto_untreeify_threshold:30}, recorded_lsn_arr:[{lsn:1480293106}, {lsn:1480293648}]}, sorted_redo_list:{ready_node_num:1, redo_sorted_progress:{dispatched_redo_count:0, sorted_redo_count:0, sorted_row_seq_no:0}, cur_dispatch_redo:{list:{sorted_treeify_list:{count:1}, is_tree_mode:false, auto_treeify_mode:true, is_tree_empty:true, list:{sorted_linked_list:{count:1}, is_list_empty:false, l_head:{val:log_lsn=[1480293648]size=65, pos=0, next=0}, l_tail:{val:log_lsn=[1480293648]size=65, pos=0, next=0}, l_tail:{val:log_lsn=[1480293648]size=65, pos=0, next=0}, is_unique:true}, auto_treeify_threshold:32, auto_untreeify_threshold:30}, node_ptr:{val:log_lsn=[1480293648]size=65, pos=0, next=0}}, cur_sort_redo:{list:{sorted_treeify_list:{count:1}, is_tree_mode:false, auto_treeify_mode:true, is_tree_empty:true, list:{sorted_linked_list:{count:1}, is_list_empty:false, l_head:{val:log_lsn=[1480293648]size=65, pos=0, next=0}, l_tail:{val:log_lsn=[1480293648]size=65, pos=0, next=0}, l_tail:{val:log_lsn=[1480293648]size=65, pos=0, next=0}, is_unique:true}, auto_treeify_threshold:32, auto_untreeify_threshold:30}, node_ptr:{val:log_lsn=[1480293648]size=65, pos=0, next=0}}, cur_sort_stmt:null, is_dml_stmt_iter_end:false}, rollback_list:{head:null, tail:null, num:0}, part_tx_fetch_state:6, ref_cnt:2, multi_data_source_node_arr:[{lsn:{lsn:1480293106}, tx_buf_node:{register_no_:0, seq_no_:1, has_submitted_:false, has_synced_:false, type:“DELETE_TABLET_NEW_MDS”, data_.length():24, has_deserialized_buffer_ctx_:false}}, {lsn:{lsn:1480293106}, tx_buf_node:{register_no_:0, seq_no_:1, has_submitted_:false, has_synced_:false, type:“CREATE_TABLET_NEW_MDS”, data_.length():307, has_deserialized_buffer_ctx_:false}}], multi_data_source_info:has_ls_table_op: false, is_ddl_trans: 0, tablet_change_info: [{cmd:2, create_tablet_cnt:0, delete_tablet_cnt:1, exchange_tablet_cnt:0}]}, checkpoint_seq:46, global_trans_seq:0, global_schema_version:-1, local_schema_version:-1, stmt_list:{head:null, tail:null, num:0}, is_data_ready:true, wait_formatted_cond:null, output_br_count_by_turn:0, next_task:null}, *trans_ctx={state:“PREPARED”, trx_sort_elem:{trans_id:{txid:5248182}, trans_commit_version:1753171723448564000}, seq:0, participants:{obj:NULL, tls_id:{tenant_id:1004, ls_id:{id:1}}}, participant_count:2, ready_participant_objs:null, ready_participant_count:0, total_br_count:0, committed_br_count:0, revertable_participant_count:0, is_trans_redo_dispatched:false, is_trans_sorted:false}) BACKTRACE:0x1321a326 0x12e8ba16 0x130c9571 0x130c8fec 0x130c8c64 0x12d6cd75 0x1774bb9a 0x1774a83c 0x17749a18 0x17814e89 0x2e05ed05 0x2e05a83c 0x7fd00d2a4ea5 0x7fd00a99296d

[2025-07-22 16:10:10.956587] EDIAG [TLOG.SEQUENCER] handle (ob_log_sequencer1.cpp:505) [134884][][T0][YDED0A0B087A-0000000001D00006-0-0] [lt=255][errcode=-4016] handle_part_trans_task_ fail(ret=-4016, ret=“OB_ERR_UNEXPECTED”, thread_index=2, part_trans_task={state:1, type:“DML_TRANS”, type:1, cluster_id:1751943680, exec_tenant_id:0, tls_id:{tenant_id:1004, ls_id:{id:1002}}, trans_id:{txid:5248182}, trans_type:“DIST”, is_xa_or_dup:false, is_trans_committed:true, trans_commit_version:1753171723448564000, prepare_ts:1753171723431771001, prepare_log_lsn:{lsn:1480293648}, commit_ts:1753171723448564000, commit_log_lsn:{lsn:1480293995}, participant_count:2, participants:[{id_:{id:1}, offset_:{lsn:2021989594}}, {id_:{id:1002}, offset_:{lsn:1480293648}}], trace_id:"", trace_info:"", sorted_log_entry_info:{fetched_log_entry_count:2, recorded_lsn_count:2, fetched_log_entry_arr:{sorted_treeify_list:{count:2}, is_tree_mode:false, auto_treeify_mode:true, is_tree_empty:true, list:{sorted_linked_list:{count:2}, is_list_empty:false, l_head:{val:{lsn:{lsn:1480293106}, next:null}}, l_tail:{val:{lsn:{lsn:1480293648}, next:null}}, l_tail:{val:{lsn:{lsn:1480293648}, next:null}}, is_unique:true}, auto_treeify_threshold:32, auto_untreeify_threshold:30}, recorded_lsn_arr:[{lsn:1480293106}, {lsn:1480293648}]}, sorted_redo_list:{ready_node_num:1, redo_sorted_progress:{dispatched_redo_count:0, sorted_redo_count:0, sorted_row_seq_no:0}, cur_dispatch_redo:{list:{sorted_treeify_list:{count:1}, is_tree_mode:false, auto_treeify_mode:true, is_tree_empty:true, list:{sorted_linked_list:{count:1}, is_list_empty:false, l_head:{val:log_lsn=[1480293648]size=65, pos=0, next=0}, l_tail:{val:log_lsn=[1480293648]size=65, pos=0, next=0}, l_tail:{val:log_lsn=[1480293648]size=65, pos=0, next=0}, is_unique:true}, auto_treeify_threshold:32, auto_untreeify_threshold:30}, node_ptr:{val:log_lsn=[1480293648]size=65, pos=0, next=0}}, cur_sort_redo:{list:{sorted_treeify_list:{count:1}, is_tree_mode:false, auto_treeify_mode:true, is_tree_empty:true, list:{sorted_linked_list:{count:1}, is_list_empty:false, l_head:{val:log_lsn=[1480293648]size=65, pos=0, next=0}, l_tail:{val:log_lsn=[1480293648]size=65, pos=0, next=0}, l_tail:{val:log_lsn=[1480293648]size=65, pos=0, next=0}, is_unique:true}, auto_treeify_threshold:32, auto_untreeify_threshold:30}, node_ptr:{val:log_lsn=[1480293648]size=65, pos=0, next=0}}, cur_sort_stmt:null, is_dml_stmt_iter_end:false}, rollback_list:{head:null, tail:null, num:0}, part_tx_fetch_state:6, ref_cnt:2, multi_data_source_node_arr:[{lsn:{lsn:1480293106}, tx_buf_node:{register_no_:0, seq_no_:1, has_submitted_:false, has_synced_:false, type:“DELETE_TABLET_NEW_MDS”, data_.length():24, has_deserialized_buffer_ctx_:false}}, {lsn:{lsn:1480293106}, tx_buf_node:{register_no_:0, seq_no_:1, has_submitted_:false, has_synced_:false, type:“CREATE_TABLET_NEW_MDS”, data_.length():307, has_deserialized_buffer_ctx_:false}}], multi_data_source_info:has_ls_table_op: false, is_ddl_trans: 0, tablet_change_info: [{cmd:2, create_tablet_cnt:0, delete_tablet_cnt:1, exchange_tablet_cnt:0}]}, checkpoint_seq:46, global_trans_seq:0, global_schema_version:-1, local_schema_version:-1, stmt_list:{head:null, tail:null, num:0}, is_data_ready:true, wait_formatted_cond:null, output_br_count_by_turn:0, next_task:null}) BACKTRACE:0x1321a326 0x12e8ba16 0x130c9571 0x130c8fec 0x130c8c64 0x12d6cd75 0x1774a98d 0x17749a4f 0x17814e89 0x2e05ed05 0x2e05a83c 0x7fd00d2a4ea5 0x7fd00a99296d

[2025-07-22 16:10:10.956743] INFO [TLOG] handle_error (ob_log_instance.cpp:2040) [134884][][T0][YDED0A0B087A-0000000001D00006-0-0] [lt=152] HANDLE_ERROR: err_cb=0x7fcff79c46e0, errno=-4016, errmsg=“Sequencer thread exits, thread_index=2, err=-4016”


看着是binlog425不支持ob435bp2造成的问题
如果想使用可以更新一下cdc版本或者等到下一个版本发版
https://www.oceanbase.com/docs/common-oblogproxy-doc-1000000003053719

1 个赞