创建 Binlog 任务 失败

ysql>
mysql> CREATE BINLOG FOR TENANT OB_test.Lemon
→ TO USER root PASSWORD Yq***l
→ WITH CLUSTER URL http://10.***.21:8080/services?Action=ObRootServiceInfo&User_ID=alibaba&UID=ocpmaster&ObRegion=OB_test&version=1
→ , REPLICATE NUM 2;
ERROR 1236 (HY000): Binlog service configuration item initialization failed

[2025-10-11 16:35:24.658805] [info] status_thread.cpp(94): METRICS:[MEM:10661/64145MB,16.62%][UDISK:320797/502936MB,63.78%][CPU:31,0%][LOAD1,5:3%,27%][NETIO:18KB/s,9KB/s]
[2025-10-11 16:35:24.658932] [info] status_thread.cpp(77): METRICS:[CLIENT_ID:/data/oblogproxy][PID:1441365][MEM:35/64145MB,0.05456%][UDISK:4100/502936MB,0.8152%][CPU:31,0.09734%][NETIO:14KB/s,9KB/s]
[2025-10-11 16:35:25.336666] [info] event_dispatch.cpp(52): On connect from [OBM][,]10.38.61.144:2983-10.38.90.153:53408/4
[2025-10-11 16:35:25.337065] [error] connection.cpp(152): Unexpected seq num, expected value is 1, actual value is 51
[2025-10-11 16:35:25.337179] [info] connection.cpp(89): Closed connection [OBM][,]10.38.61.144:2983-10.38.90.153:53408/4
[2025-10-11 16:35:26.050963] [info] mysql_connecton_wrapper.cpp(93): The number of connections in the connection pool is:28
[2025-10-11 16:35:26.406054] [info] database_protocol.cpp(4181): Begin to update instance gtid mapping data
[2025-10-11 16:35:27.339681] [info] event_dispatch.cpp(52): On connect from [OBM][,]10.38.61.144:2983-10.38.90.153:49458/4
[2025-10-11 16:35:27.340741] [error] connection.cpp(152): Unexpected seq num, expected value is 1, actual value is 51
[2025-10-11 16:35:27.340919] [info] connection.cpp(89): Closed connection [OBM][,]10.38.61.144:2983-10.38.90.153:49458/4
[2025-10-11 16:35:29.342043] [info] event_dispatch.cpp(52): On connect from [OBM][,]10.38.61.144:2983-10.38.90.153:19809/4
[2025-10-11 16:35:29.342299] [error] connection.cpp(152): Unexpected seq num, expected value is 1, actual value is 51
[2025-10-11 16:35:29.342405] [info] connection.cpp(89): Closed connection [OBM][,]10.38.61.144:2983-10.38.90.153:19809/4
[2025-10-11 16:35:29.449618] [info] database_protocol.cpp(4181): Begin to update instance gtid mapping data
[2025-10-11 16:35:31.344056] [info] event_dispatch.cpp(52): On connect from [OBM][,]10.38.61.144:2983-10.38.90.153:35167/4
[2025-10-11 16:35:31.344286] [error] connection.cpp(152): Unexpected seq num, expected value is 1, actual value is 51
[2025-10-11 16:35:31.344363] [info] connection.cpp(89): Closed connection [OBM][,]10.38.61.144:2983-10.38.90.153:35167/4
[2025-10-11 16:35:32.500212] [info] database_protocol.cpp(4181): Begin to update instance gtid mapping data @论坛小助手

对于您提到的在 OceanBase 中创建 Binlog 任务时遇到的错误 ‘Binlog service configuration item initialization failed’,我们可以使用 obdiag 工具来收集相关信息,以便进一步诊断问题。

日志采集场景: 配置项初始化失败
由于提供的日志采集场景列表中并没有直接与 Binlog 服务配置项初始化失败相匹配的选项,我们可以选择最接近的或通用的场景进行日志收集,例如“未知问题”。这将帮助我们获得可能与问题相关的信息。
日志采集命令: obdiag gather scene run --scene=observer.unknown

请您按照上述命令收集日志,并将收集到的日志压缩包提供给我们。此外,为了更准确地定位问题,还需要您提供一些额外的信息:

  1. 您能否提供具体的错误日志内容?这有助于我们理解具体的配置项初始化失败的原因。
  2. 您当前使用的 OceanBase 版本是什么?
  3. 创建 Binlog 任务的具体步骤是什么?是否可以重现该错误?
  4. 在遇到此问题之前,您是否有更改过任何与 Binlog 相关的配置项?
  5. 该问题是否仅在特定的数据库或表上发生?
  6. 您尝试过重新启动 OceanBase 服务吗?如果有,问题是否有所改善?

这些问题的答案将对我们解决问题非常有帮助。感谢您的配合!

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

OceanBase 版本号
4.3.5.2
binlog obbinlog-ce-4.2.10-

error记录

SHOW PARAMETERS LIKE ‘cluster’;
SHOW TENANT;
SHOW PARAMETERS LIKE ‘obconfig_url’;
上面的信息 提供一下