oblogproxy 创建binlog 任务后,binlog 服务任务未正常运行

【 使用环境 】测试环境
【 OB or 其他组件 】oblogproxy
【 使用版本 】obbinlog-ce-4.2.3
【问题描述】oblogproxy 创建binlog 任务几分钟后, binlog 实例服务由Running 状态转为 Offline状态
【复现路径】问题出现前后相关操作
【附件及日志】推荐使用OceanBase敏捷诊断工具obdiag收集诊断信息,详情参见链接(右键跳转查看):

相关环境说明:
OBServer 版本:OceanBase_CE 4.3.5.1
ob-configserver 版本:ob-configserver-1.0.1
obproxy版本:obproxy_ce-4.3.4.0

binlog 实例服务创建语句如下:

CREATE BINLOG FOR TENANT `ob_1panel`.`oceanbase` TO USER `root` PASSWORD `xxx`  WITH CLUSTER URL 'http://0.0.0.0:8080/services?Action=ObRootServiceInfo&ObCluster=ob_1panel', REPLICATE NUM 1;

起初binlog 服务为Running 状态

MySQL [(none)]> SHOW BINLOG INSTANCES\G
*************************** 1. row ***************************
           name: wdqp3g6plx
     ob_cluster: ob_1panel
      ob_tenant: oceanbase
             ip: 127.0.0.1
           port: 8106
           zone: 
         region: 
          group: 
        running: Yes
          state: Running
  obcdc_running: Yes
    obcdc_state: Running
   service_mode: enabled
convert_running: No
  convert_delay: 2344
    convert_rps: 0
    convert_eps: 0
   convert_iops: 0
        dumpers: 0
        version: 4.2.3-1cf30a786ba8c4984ddb24d5273a1d826b2ab11e
       odp_addr: NULL
1 row in set (0.01 sec)

过几分钟后,就变为 Offline状态了

在run 路径下可以看到有相关binlog 文件生成

[root@VM-0-5-centos oblogproxy]# ls run/wdqp3g6plx/data/
mysql-bin.000001  mysql-bin.000002  mysql-bin.000003  mysql-bin.000004  mysql-bin.index

run/wdqp3g6plx/log/binlog_instance.log 有error 日志

[2025-05-14 10:57:37.731628] [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-14 10:57:37.732146] [info] gtid_manager.cpp(289): Failed to open gtid seq file: binlog_tenant_gtid_seq.meta, error: 2(No such file or directory)

run/wdqp3g6plx/log/libobcdc.log 中截取部分WDIAG 日志如下

WDIAG [TLOG] get_server_count (ob_log_route_service.cpp:719) [25071][][T0][Y60150ACE0005-0000000000E00001-0-0] [lt=41][errcode=-4018] LSRouterMap get failed(ret=-4018, ret="OB_ENTRY_NOT_EXIST", router_key={cluster_id:1746683032, tenant_id:1002, ls_id:{id:1}})

WDIAG get_mysql_type (obsm_utils.cpp:499) [25048][Formatter_9][T0][Y60150ACE0005-0000000003B00001-0-0] [lt=17][errcode=-4016] unexpected mysql_type=65535

binlog 日志打包如下(部分敏感信息已做脱敏处理)
instance_log.tar.gz (1.3 MB)

麻烦各位大佬帮忙看一下,十分感谢

binlog423不支持ob4351 建议安装binlog424 已经适配ob4351

2 个赞

感谢 淇铭老师指点,我下载binlog424 重新试试

感谢 淇铭老师, 更换 binlog424 后问题顺利解决了