【 使用环境 】测试环境
【 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)
麻烦各位大佬帮忙看一下,十分感谢