【 使用环境 测试环境
【 OB or 其他组件 】binlog 服务组件
【 使用版本 】 版本号: OCP 4.3.5-20250319105844
【问题描述】添加debian11系统云主机进行 binlog 服务部署，报出错误无法继续
2025-03-24 19:11:57.186 ERROR 1071879 --- [manual-subtask-executor14,752b1c5639f514b4,7f429831587697bc] c.o.o.c.t.e.c.w.subtask.SubtaskExecutor : OCP-Agent task bc2b7f43-6884-4da0-a8df-09ce18875ff5 failed, error message: OcpAgentError: code = 15000, message = Failed to execute binlog command, message: start binlog failed, logFile: /obdata/binlogservice/log/deploy.log
com.oceanbase.ocp.core.exception.UnexpectedException: [OCP UnexpectedException]: status=500 INTERNAL_SERVER_ERROR, errorCode=AGENT_TASK_FAILED, args=bc2b7f43-6884-4da0-a8df-09ce18875ff5,OcpAgentError: code = 15000, message = Failed to execute binlog command, message: start binlog failed, logFile: /obdata/binlogservice/log/deploy.log
at com.oceanbase.ocp.core.i18n.ErrorCodes$Kind$10.exception(ErrorCodes.java:1814)
at com.oceanbase.ocp.core.i18n.ErrorCodes.exception(ErrorCodes.java:1669)
at com.oceanbase.ocp.core.util.ExceptionUtils.newException(ExceptionUtils.java:169)
at com.oceanbase.ocp.core.util.ExceptionUtils.throwException(ExceptionUtils.java:162)
at com.oceanbase.ocp.service.task.util.AgentAsyncTaskHelper.checkSuccess(AgentAsyncTaskHelper.java:279)
at com.oceanbase.ocp.service.task.util.AgentAsyncTaskHelper.waitForExecuteFinish(AgentAsyncTaskHelper.java:225)
at com.oceanbase.ocp.service.task.util.AgentAsyncTaskHelper.deployBinlogServer(AgentAsyncTaskHelper.java:186)
at com.oceanbase.ocp.binlog.internal.BinlogHostOperationService.deployBinlogServer(BinlogHostOperationService.java:51)
at com.oceanbase.ocp.binlog.internal.BinlogOperationManager.deployBinlogServer(BinlogOperationManager.java:104)
at com.oceanbase.ocp.binlog.internal.task.DeployBinlogServerTask.run(DeployBinlogServerTask.java:33)
at com.oceanbase.ocp.core.task.engine.runner.JavaSubtaskRunner.execute(JavaSubtaskRunner.java:64)
at com.oceanbase.ocp.core.task.engine.runner.JavaSubtaskRunner.doRun(JavaSubtaskRunner.java:32)
at com.oceanbase.ocp.core.task.engine.runner.JavaSubtaskRunner.run(JavaSubtaskRunner.java:26)
at com.oceanbase.ocp.core.task.engine.runner.RunnerFact
ory.doRun(RunnerFactory.java:76)
at com.oceanbase.ocp.core.task.engine.coordinator.worker.subtask.SubtaskExecutor.doRun(SubtaskExecutor.java:207)
at com.oceanbase.ocp.core.task.engine.coordinator.worker.subtask.SubtaskExecutor.redirectConsoleOutput(SubtaskExecutor.java:201)
at com.oceanbase.ocp.core.task.engine.coordinator.worker.subtask.SubtaskExecutor.lambda$submit$2(SubtaskExecutor.java:137)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:750)
Set state for subtask: 1000092, operation:EXECUTE, state: FAILED
尝试查看 /obdata/binlogservice/log/deploy.log
2025-03-24 19:11:49 root execute ./deploy.sh: DEPLOY_PATH=/obdata/binlogservice
2025-03-24 19:11:49 root execute ./deploy.sh: DEPLOY_CONF_FILE=/obdata/binlogservice/env/ocp-deploy-conf.json
2025-03-24 19:11:49 root execute ./deploy.sh: JQ_VERSION: jq-1.6
2025-03-24 19:11:49 root execute ./deploy.sh: MYSQL_VERSION: mysql Ver 15.1 Distrib 10.5.23-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper
2025-03-24 19:11:49 root execute ./deploy.sh: DIFF_VERSION: diff (GNU diffutils) 3.7
Copyright (C) 2018 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <https://gnu.org/licenses/gpl.html>.
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.
Written by Paul Eggert, Mike Haertel, David Hayes,
Richard Stallman, and Len Tower.
2025-03-24 19:11:49 root execute ./deploy.sh: *** 1. Init machine env... OK
2025-03-24 19:11:49 root execute ./deploy.sh: Given node_ip: 10.10.130.209
2025-03-24 19:11:49 root execute ./deploy.sh: METADB_INFO = host: 10.44.50.11, database: binlog_database, port: 2881, user: root@elephant, node_ip: 10.10.130.209
2025-03-24 19:11:49 root execute ./deploy.sh: !! Warning: Unexpected user parameters, sys user: , may cause startup failed
2025-03-24 19:11:49 root execute ./deploy.sh: *** 2. Verify parameters from [/obdata/binlogservice/env/ocp-deploy-conf.json]... OK
2025-03-24 19:11:49 root execute ./deploy.sh: SCHEMA_SQL=/obdata/binlogservice/conf/schema.sql
2025-03-24 19:11:50 root execute ./deploy.sh: *** 3. Init metadb... OK
2025-03-24 19:11:50 root execute ./deploy.sh: CONF_FILE=/obdata/binlogservice/conf/conf.json
2025-03-24 19:11:50 root execute ./deploy.sh: *** 3. Modify binlog conf... OK
DEPLOY_PATH : /obdata/binlogservice
2025-03-24 19:11:50 root execute ./deploy.sh: *** 4. Start binlog... OK
2025-03-24 19:11:50 root execute ./deploy.sh: BINLOG_STATUS=DEPLOY_PATH : /obdata/binlogservice
dba@dba-obtest-0:/obdata/binlogservice/conf$ cat conf.json
{
"service_port": 2983,
"encode_threadpool_size": 8,
"encode_queue_size": 20000,
"max_packet_bytes": 67108864,
"record_queue_size": 20000,
"read_timeout_us": 100000,
"read_fail_interval_us": 1000000,
"read_wait_num": 20000,
"send_timeout_us": 2000000,
"send_fail_interval_us": 1000000,
"check_quota_enable": false,
"check_clog_enable": true,
"command_timeout_s": 10,
"log_quota_size_mb": 5120,
"log_quota_day": 7,
"log_gc_interval_s": 43200,
"log_level": 2,
"loh_flush_strategy": 1,
"log_flush_level": 2,
"log_flush_period_s": 1,
"log_max_file_size_mb": 1024,
"log_retention_h": 360,
"oblogreader_path_retain_hour": 168,
"oblogreader_lease_s": 300,
"oblogreader_path": "./run",
"bin_path": "./bin",
"oblogreader_timezone_conf": "../../conf/timezone_info.conf",
"oblogreader_obcdc_path_template": "../../obcdc/obcdc-%s.x-access/libobcdcaccess.so",
"oblogreader_obcdc_ce_path_template": "../../obcdc/obcdc-ce-%s.x-access/libobcdcaccess.so",
"allow_all_tenant": true,
"auth_user": false,
"auth_use_rs": false,
"auth_allow_sys_user": true,
"ob_sys_username": "",
"ob_sys_password": "",
"counter_interval_s": 2,
"metric_enable": true,
"metric_interval_s": 10,
"prometheus_port": 2984,
"debug": false,
"verbose": false,
"verbose_packet": false,
"verbose_record_read": false,
"readonly": false,
"count_record": false,
"channel_type": "plain",
"tls_ca_cert_file": "",
"tls_cert_file": "",
"tls_key_file": "",
"tls_verify_peer": true,
"liboblog_tls": false,
"liboblog_tls_cert_path": "",
"binlog_log_bin_basename": "./run",
"binlog_timezone_conf": "../../conf/timezone_info.conf",
"binlog_obcdc_path_template": "../../obcdc/obcdc-%s.x-access/libobcdcaccess.so",
"binlog_obcdc_ce_path_template": "../../obcdc/obcdc-ce-%s.x-access/libobcdcaccess.so",
"binlog_ignore_unsupported_event": true,
"binlog_max_event_buffer_bytes": 67108864,
"binlog_mode": true,
"table_whitelist": "",
"binlog_nof_work_threads": 16,
"binlog_bc_work_threads": 2,
"binlog_sql_work_threads": 4,
"binlog_max_file_size_bytes": 536870912,
"binlog_convert_timeout_us": 10000,
"binlog_checksum": true,
"binlog_heartbeat_interval_us": 100000,
"binlog_log_heartbeat_interval_times": 10,
"binlog_ddl_convert_jvm_options": "-Djava.class.path=../../deps/lib/etransfer.jar|-Xmx256M|-Xtrace|-XX:+CreateMinidumpOnCrash",
"binlog_ddl_convert_class": "com/alipay/oms/etransfer/util/OB2MySQLConvertTool",
"binlog_ddl_convert_func": "parser",
"binlog_ddl_convert_func_param": "(Ljava/lang/String;Ljava/lang/String;Z)Ljava/lang/String;",
"binlog_gtid_display": true,
"binlog_ddl_convert": true,
"binlog_ddl_convert_ignore_unsupported_ddl": true,
"binlog_memory_limit": "3G",
"binlog_working_mode": "storage",
"binlog_recover_backup": true,
"start_tcp_port": 8100,
"reserved_ports_num": 256,
"cluster_mode": true,
"gtid_seq_compressed_interval_s": 10,
"gtid_seq_compressed_trx_size": 100000,
"gtid_marking_step_size": 100000,
"gtid_inspector_s": 900,
"gtid_memory_cache_seconds": 7200,
"gtid_heartbeat_duration_s": 3600,
"enable_gtid_inspector": true,
"database_ip": "10.44.50.11",
"database_port": 2881,
"database_name": "binlog_database",
"database_properties": "",
"user": "root@elephant",
"password": "PWD44ele__",
"node_ip": "10.180.130.209",
"enable_resource_check": true,
"cpu_mem_disk_net_weighted": "1:1:1:1",
"node_cpu_limit_threshold_percent": 80,
"node_mem_limit_threshold_percent": 85,
"node_disk_limit_threshold_percent": 70,
"recovery_point_strategy": "fast",
"enable_dumper_cpu_precheck": false,
"max_dumper_num": 128,
"max_task_execution_time_s": 600,
"default_defer_drop_sec": 7200,
"default_instance_replicate_num": 1,
"enable_auth": false,
"prometheus_unused_metric_clear_interval_s": 900,
"max_delete_rows": 10000,
"max_instance_startup_wait_sec": 60,
"min_pool_size": 30,
"max_pool_size": 1000,
"binlog_convert_ring_buffer_size": 1024,
"binlog_convert_number_of_concurrences": 12,
"binlog_convert_thread_size": 16,
"binlog_serialize_ring_buffer_size": 1024,
"binlog_serialize_thread_size": 10,
"binlog_serialize_parallel_size": 8,
"binlog_release_ring_buffer_size": 1024,
"binlog_release_thread_size": 4,
"binlog_release_parallel_size": 2,
"preallocated_memory_bytes": 2097152,
"preallocated_expansion_memory_bytes": 8192,
"binlog_purge_binlog_threads": 2,
"binlog_obi_column_work_threads": 10
}
不知道问题出在哪 ？ 可不可以帮忙查看一下，看下问题如何处理。 @论坛小助手
