binlog 服务任务未正常运行

binlog 服务版本4.2.3-1cf30a786ba8c4984ddb24d5273a1d826b2ab11e
oceanbase 版本 OceanBase_CE 4.3.5.0
binlog 任务创建成功后查看
mysql> show binlog instances;
±-----------±-----------±----------±------------±-----±-----±-------±------±--------±--------±--------------±------------±-------------±----------------±--------------±------------±------------±-------------±--------±-----------------------------------------------±---------+
| name | ob_cluster | ob_tenant | ip | port | zone | region | group | running | state | obcdc_running | obcdc_state | service_mode | convert_running | convert_delay | convert_rps | convert_eps | convert_iops | dumpers | version | odp_addr |
±-----------±-----------±----------±------------±-----±-----±-------±------±--------±--------±--------------±------------±-------------±----------------±--------------±------------±------------±-------------±--------±-----------------------------------------------±---------+
| bzou0esgu9 | dknow | core | 172.26.11.9 | 8101 | | | | Yes | Running | Yes | Running | enabled | No | 5782 | 0 | 0 | 0 | 0 | 4.2.3-1cf30a786ba8c4984ddb24d5273a1d826b2ab11e | NULL |
| d5jipkilml | dknow | core | 172.26.11.8 | 8100 | | | | Yes | Running | Yes | Running | enabled | No | 5336 | 0 | 0 | 0 | 0 | 4.2.3-1cf30a786ba8c4984ddb24d5273a1d826b2ab11e | NULL |
±-----------±-----------±----------±------------±-----±-----±-------±------±--------±--------±--------------±------------±-------------±----------------±--------------±------------±------------±-------------±--------±-----------------------------------------------±---------+

convert_running 是 no
查看 run/instance/log/binlog_instance.log,没有 ediag 相关日志,有error 日志:
[2025-05-02 09:58:10.293257] [error] gtid_manager.cpp(450): Failed to open gtid seq file: binlog_tenant_gtid_seq.meta, error: 2(No such file or directory)
[2025-05-02 09:58:10.293262] [info] gtid_manager.cpp(289): Failed to open gtid seq file: binlog_tenant_gtid_seq.meta, error: 2(No such file or directory)
[2025-05-02 09:58:10.293269] [error] binlog_index.cpp(118): Failed to open binlog index file: ./data/mysql-bin.index, error: 2(No such file or directory)
[2025-05-02 09:58:10.293272] [error] binlog_index.cpp(49): Failed to open index file: ./data/mysql-bin.index, errno: 2(No such file or directory)
[2025-05-02 09:58:10.408630] [error] binlog_index.cpp(118): Failed to open binlog index file: ./data/mysql-bin.index, error: 2(No such file or directory)

查看 run/d5jipkilml/log/libobcdc.log,发现 ediag 日志:
[2025-05-02 11:39:13.270812] EDIAG [TLOG.FETCHER] get_result (ob_log_start_lsn_locator.cpp:929) [572707][][T0][YBC87AC1A0B08-0000000000100001-0-0] [lt=17][errcode=-4016] request start lsn from all server fail(tls_id={tenant_id:1002, ls_id:{id:1}}, start_tstamp_ns=1746091545867460000, svr_cnt=3, svr_list_consumed=3, result_svr_list_idx=-1, svr_list=[{svr:“172.26.11.21:2882”, rpc_executed:true, rpc_err:0, svr_err:0, ls_err:-4233, start_lsn:{lsn:18446744073709551615}, start_log_tstamp:18446744073709551615, trace_id:YBC87AC1A0B08-000000000050762D-0-0}, {svr:“172.26.11.28:2882”, rpc_executed:true, rpc_err:0, svr_err:0, ls_err:-4233, start_lsn:{lsn:18446744073709551615}, start_log_tstamp:18446744073709551615, trace_id:YBC87AC1A0B08-000000000060EC59-0-0}, {svr:“172.26.11.35:2882”, rpc_executed:true, rpc_err:0, svr_err:0, ls_err:-4233, start_lsn:{lsn:18446744073709551615}, start_log_tstamp:18446744073709551615, trace_id:YBC87AC1A0B08-000000000060EC5A-0-0}]) BACKTRACE:0x1063b1ca 0x1018d3c6 0x102a9fe5 0x102a9a76 0x102a96e4 0x102a94cb 0x14b3f5e0 0x14a128c6 0x14901acd 0x14900eb3 0x14900298 0x149ad98f 0x7f115f87d1ca 0x7f115ce1f8d3
[2025-05-02 11:39:13.270857] EDIAG [TLOG.FETCHER] locate_lsn_ (ob_log_ls_fetch_ctx.cpp:976) [572707][][T0][YBC87AC1A0B08-0000000000100001-0-0] [lt=45][errcode=0] start lsn locate fail(start_lsn_locate_req={state:2, tls_id:{tenant_id:1002, ls_id:{id:1}}, start_tstamp_ns:1746091545867460000, svr_cnt:3, svr_list_consumed:3, result_svr_list_idx:-1, cur_max_start_lsn:{lsn:18446744073709551615}, cur_max_start_log_tstamp:-1, succ_locate_count:0, svr_list:[{svr:“172.26.11.21:2882”, rpc_executed:true, rpc_err:0, svr_err:0, ls_err:-4233, start_lsn:{lsn:18446744073709551615}, start_log_tstamp:18446744073709551615, trace_id:YBC87AC1A0B08-000000000050762D-0-0}, {svr:“172.26.11.28:2882”, rpc_executed:true, rpc_err:0, svr_err:0, ls_err:-4233, start_lsn:{lsn:18446744073709551615}, start_log_tstamp:18446744073709551615, trace_id:YBC87AC1A0B08-000000000060EC59-0-0}, {svr:“172.26.11.35:2882”, rpc_executed:true, rpc_err:0, svr_err:0, ls_err:-4233, start_lsn:{lsn:18446744073709551615}, start_log_tstamp:18446744073709551615, trace_id:YBC87AC1A0B08-000000000060EC5A-0-0}], fetching_mode:“Integrated Fetching Mode”, archive_locate_rs:{start_lsn:{lsn:18446744073709551615}, loc_err:0}}) BACKTRACE:0x1063b1ca 0x1018d3c6 0x103135d3 0x1031302c 0x10312cda 0x10312ad1 0x14a144d1 0x14a128db 0x14901acd 0x14900eb3 0x14900298 0x149ad98f 0x7f115f87d1ca 0x7f115ce1f8d3

2 个赞

找不到文件或者目录错误啊

2 个赞

data 下有 mysql-bin.000001和 mysql-bin.index 文件,没有 binlog_tenant_gtid_seq.meta ,这个文件不是 binlog 服务自己生成吗?难道要手动创建

2 个赞

:wave: :wave: :wave:

1 个赞

:+1: :+1: :+1:

1 个赞

:+1: :+1: :+1:

clog日志被回收了 导致的拉取不到日志