OB4351+obinlog423失败

[toc]

社区版本

线下测试环境:

observer 4.3.5.1 最新版

obproxy 4.3.3.0-5 最新版

obbinlog 4.2.3 最新版

另一套4.2.5OB 线下环境环境创建obbinlog正常:

obproxy 4.3.3.0-5

observer 4.2.5.1

obbinlog 4.2.3

obbinlog server服务器信息

cat /etc/issue
\S
Kernel \r on an \m

uname -r
5.4.210-4.ve1.x86_64

cat /etc/redhat-release
CentOS Linux release 7.9.2009 (Core)

OCP里租户开通binlog超时失败,重复删除binlog集群,新创建也是该错误

登录binlog server 2983端口改binlog实例convert_running: No

mysql> show binlog instances\G
*************************** 1. row ***************************
           name: t0ty98ag8r
     ob_cluster: xxxxx
      ob_tenant: mysql2
             ip: 10.xxx
           port: 8100
           zone: 
         region: 
          group: 
        running: Yes
          state: Running
  obcdc_running: Yes
    obcdc_state: Running
   service_mode: enabled
convert_running: No
  convert_delay: 1969847

grep -i ‘err’ libobcdc.log

[2025-04-16 17:09:23.061262] EDIAG [TLOG.FETCHER] handle (ob_log_ls_fetch_stream.cpp:206) [2100201][LogStreaWorkThr][T0][Y0-0000000000000000-0-0] [lt=25][errcode=-4000] handle FETCH_LOG task fail(ret=-4000, ret=“OB_ERROR”) BACKTRACE:0x1063b1ca 0x1018d3c6 0x104b95b4 0x104b8da6 0x104b8a3a 0x104b8edb 0x14a1bc7e 0x14a1b064 0x14c81efd 0x293fa74b 0x29404725 0x2940025c 0x7f2d0b699ea5 0x7f2d08d87b0d
[2025-04-16 17:09:23.061280] EDIAG [TLOG.FETCHER] handle (ob_ls_worker.cpp:349) [2100201][LogStreaWorkThr][T0][Y0-0000000000000000-0-0] [lt=17][errcode=-4000] handle fetch stream task fail(ret=-4000, ret=“OB_ERROR”, task=0x7f2c3260faa0) BACKTRACE:0x1063b1ca 0x1018d3c6 0x1018c9f3 0x1018c49c 0x1018c13c 0x1018bf2a 0x14c828ae 0x14c81f24 0x293fa74b 0x29404725 0x2940025c 0x7f2d0b699ea5 0x7f2d08d87b0d

数据字典刷新配置已经修改为1h,重试几次还是binlog实例异常

详细binlog_instance和libcdc 日志如下
binlog_instance_libobcdc.log.rar (362.8 KB)

binlog_instance_libobcdc.tar.gz (856.0 KB)

@论坛小助手

看着报错 是因为找不到Failed to open index file: ./data/mysql-bin.index, errno: 2(No such file or directory)

另外看你那边用的是 ob435bp1, obbinlog 4.2.3 目前还没有适配ob435bp1,所以这个问题可能是版本不适配引起的。如果想适配 ob435bp1,需要手动安装一下 ob435bp1 的 obcdc。https://www.oceanbase.com/docs/community-oblogproxy-doc-1000000001493746

2 个赞

ll -h data
total 8.0K
-rw-r–r-- 1 root root 155 Apr 16 17:09 mysql-bin.000001
-rw-r–r-- 1 root root 45 Apr 16 17:09 mysql-bin.index