【 使用环境 】生产环境 or 测试环境
【 OB or 其他组件 】
【 使用版本 】4.2.1
【问题描述】通过OCP创建集群报错：Can’t connect to MySQL server on ‘127.1’ (115)
【复现路径】
【附件及日志】推荐使用OceanBase敏捷诊断工具obdiag收集诊断信息,详情参见链接（右键跳转查看）：
【SOP系列 22 】——故障诊断第一步(自助诊断和诊断信息收集)
subtask_2187.log (561.5 KB)
【备注】基于 LLM 和开源文档 RAG 的论坛小助手已开放测试，在发帖时输入 [@论坛小助手] 即可召唤小助手，欢迎试用！
麻烦提供一份observer日志
~/oceanbase/log下
没有这个目录，这个命令是OCP主机下面还是observer集群下面
tail -n 1000 /home/admin/oceanbase/log/observer.log
ob节点下
是不是创建集群时候的参数配置有问题 [errcode=-4147] Invalid config
能看的出来什么参数有问题吗，我都是一步一步跟着文档来的
需要提供一下参数。
__min_full_resource_pool_memory 268435456
system_memory 10G
datafile_disk_percentage 50
errcode=-4147 Invalid config, value out of [1073741824,) (for reference only).
name=__min_full_resource_pool_memory, value=268435456, ret=-4147
可能是这个参数设置小了，你改成1073741824试试
好的，还有我请问一下通过OCP安装的集群有没有obshell这个工具
修改了那个参数没用，还是一样报错，起不来集群
报错变了，你当前log和data是否同盘部署了？ 报错log空间不足
是这样，我磁盘才100G
有没有什么参数来设置日志磁盘大小
log_disk_size 部署里面应该有，建议log大小为内存大小的3-4倍
2025-09-05 17:01:34.903 INFO 10 — [pool-manual-subtask-executor14,bdd799fa8f154689,a8e3dcc1fa65] c.o.o.c.t.e.runner.JavaSubtaskRunner : Retry subtask, id=4357, context=Context{parallelIdx=-1, stringMap={ob_log_disk_path=/data/log1, task_instance_id=3829, agent_async_task_token_map={“4342”:“0d7ec9fb-6b79-4531-841d-00960efd53a7”}, task_operation=retry, cluster_type=PRIMARY, ob_install_path=/home/admin/oceanbase, ob_sql_port=2881, link_obproxy=false, primary_zone=zone1;zone2;zone3, cluster_id=8, operation_scope=Cluster, ob_svr_port=2882, zone2.idc=IDC2, sub_task_instance_id=4357, cluster_version=4.2.1.0, cluster_name=obcluster, target_server_status=RUNNING, mix_rpm_names={“zone3”:“oceanbase-4.2.1.0-100000182023092722.el7.x86_64.rpm”,“zone2”:“oceanbase-4.2.1.0-100000182023092722.el7.x86_64.rpm”,“zone1”:“oceanbase-4.2.1.0-100000182023092722.el7.x86_64.rpm”}, startup_option_string=__min_full_resource_pool_memory=1073741824,system_memory=10G, ob_version=4.2.1.0, service_name=obcluster:1757034773, target_zone_status=RUNNING, zone3.idc=IDC3, ob_cluster_id=1757034773, zone1.idc=IDC1, root_sys_password=, service_type=OB_CLUSTER, obproxy_proxyro_password=, dep_rpm_names={}, connection_mode=direct, target_cluster_status=RUNNING, latest_execution_start_time=2025-09-05T17:01:34.660+08:00, ob_data_disk_path=/data/1}, listMap={zone3.host_ids=[4], root_servers=[2, 3, 4], ob_connect_address_list=[10.168.206.6:2881, 10.168.201.193:2881, 10.168.201.194:2881], server_ids=[20, 21, 22], zone2.host_ids=[3], host_ids=[2, 3, 4], zone1.host_ids=[2], zone_names=[zone1, zone2, zone3]}}, executor=10.168.202.36
2025-09-05 17:01:34.906 INFO 10 — [pool-manual-subtask-executor14,bdd799fa8f154689,a8e3dcc1fa65] c.o.o.s.t.b.c.SetSysPrimaryZoneTask : need to do nothing when rollback
2025-09-05 17:01:34.923 INFO 10 — [pool-manual-subtask-executor14,bdd799fa8f154689,a8e3dcc1fa65] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.168.206.6, sql port:2881
2025-09-05 17:01:34.927 INFO 10 — [pool-manual-subtask-executor14,bdd799fa8f154689,a8e3dcc1fa65] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.168.206.6, sql port:2881
2025-09-05 17:01:34.931 INFO 10 — [pool-manual-subtask-executor14,bdd799fa8f154689,a8e3dcc1fa65] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000]
2025-09-05 17:01:34.941 INFO 10 — [pool-manual-subtask-executor14,bdd799fa8f154689,a8e3dcc1fa65] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select max(value) value from oceanbase.__all_virtual_sys_parameter_stat where name = ‘min_observer_version’
2025-09-05 17:01:34.950 INFO 10 — [pool-manual-subtask-executor14,bdd799fa8f154689,a8e3dcc1fa65] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.168.206.6, sql port:2881
2025-09-05 17:01:34.954 INFO 10 — [pool-manual-subtask-executor14,bdd799fa8f154689,a8e3dcc1fa65] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000]
2025-09-05 17:01:34.958 INFO 10 — [pool-manual-subtask-executor14,bdd799fa8f154689,a8e3dcc1fa65] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: ALTER TENANT sys PRIMARY_ZONE = ?, args: [zone1;zone2;zone3]
2025-09-05 17:01:34.969 ERROR 10 — [pool-manual-subtask-executor14,bdd799fa8f154689,a8e3dcc1fa65] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] update failed, sql:[ALTER TENANT sys PRIMARY_ZONE = ?], error message:[PreparedStatementCallback; SQL [ALTER TENANT sys PRIMARY_ZONE = ?]; (conn=3221487821) The RootServer is not the master; nested exception is java.sql.SQLTransientConnectionException: (conn=3221487821) The RootServer is not the master]
2025-09-05 17:01:34.973 INFO 10 — [pool-manual-subtask-executor14,bdd799fa8f154689,a8e3dcc1fa65] c.o.ocp.obsdk.connector.ConnectTemplate : Last Trace Info:[YB420AA8CE06-00063E09FD2275D8-0-0]
2025-09-05 17:01:34.977 WARN 10 — [pool-manual-subtask-executor14,bdd799fa8f154689,a8e3dcc1fa65] c.o.o.c.t.engine.runner.RunnerFactory : Execute task failed, subtask=SubtaskInstanceOverview{id=4357, name=Set sys primary zone, state=FAILED, operation=RETRY, className=com.oceanbase.ocp.service.task.business.cluster.SetSysPrimaryZoneTask, seriesId=10, startTime=2025-09-05T16:55:47.873+08:00, endTime=null}
com.oceanbase.ocp.obsdk.exception.OceanBaseException: (conn=3221487821) The RootServer is not the master
at com.oceanbase.ocp.obsdk.connector.ConnectTemplate.customizeException(ConnectTemplate.java:419) ~[obsdk-4.1.0-20230720.jar!/:4.1.0-20230720]
at com.oceanbase.ocp.obsdk.connector.ConnectTemplate.customizeException(ConnectTemplate.java:411) ~[obsdk-4.1.0-20230720.jar!/:4.1.0-20230720]
at com.oceanbase.ocp.obsdk.connector.ConnectTemplate.customizeException(ConnectTemplate.java:406) ~[obsdk-4.1.0-20230720.jar!/:4.1.0-20230720]
at com.oceanbase.ocp.obsdk.connector.ConnectTemplate.updateInner(ConnectTemplate.java:273) ~[obsdk-4.1.0-20230720.jar!/:4.1.0-20230720]
at com.oceanbase.ocp.obsdk.connector.ConnectTemplate.update(ConnectTemplate.java:241) ~[obsdk-4.1.0-20230720.jar!/:4.1.0-20230720]
at com.oceanbase.ocp.obsdk.operator.tenant.MysqlTenantOperator.modifyPrimaryZone(MysqlTenantOperator.java:294) ~[obsdk-4.1.0-20230720.jar!/:4.1.0-20230720]
at com.oceanbase.ocp.service.task.business.cluster.SetSysPrimaryZoneTask.run(SetSysPrimaryZoneTask.java:41) ~[ocp-service-4.1.0-20230720.jar!/:4.1.0-20230720]
at com.oceanbase.ocp.core.task.runtime.Subtask.retry(Subtask.java:49) ~[ocp-core-4.1.0-20230720.jar!/:4.1.0-20230720]
at com.oceanbase.ocp.core.task.engine.runner.JavaSubtaskRunner.retry(JavaSubtaskRunner.java:71) ~[ocp-core-4.1.0-20230720.jar!/:4.1.0-20230720]
at com.oceanbase.ocp.core.task.engine.runner.JavaSubtaskRunner.doRun(JavaSubtaskRunner.java:34) ~[ocp-core-4.1.0-20230720.jar!/:4.1.0-20230720]
at com.oceanbase.ocp.core.task.engine.runner.JavaSubtaskRunner.run(JavaSubtaskRunner.java:25) ~[ocp-co
re-4.1.0-20230720.jar!/:4.1.0-20230720]
at com.oceanbase.ocp.core.task.engine.runner.RunnerFactory.doRun(RunnerFactory.java:111) ~[ocp-core-4.1.0-20230720.jar!/:4.1.0-20230720]
at com.oceanbase.ocp.core.task.engine.runner.RunnerFactory.redirectOutputIfNotSysSchedule(RunnerFactory.java:183) ~[ocp-core-4.1.0-20230720.jar!/:4.1.0-20230720]
at com.oceanbase.ocp.core.task.engine.runner.RunnerFactory.run(RunnerFactory.java:101) ~[ocp-core-4.1.0-20230720.jar!/:4.1.0-20230720]
at com.oceanbase.ocp.core.task.engine.coordinator.worker.subtask.ReadySubtaskWorker.lambda$null$1(ReadySubtaskWorker.java:127) ~[ocp-core-4.1.0-20230720.jar!/:4.1.0-20230720]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[na:1.8.0_312]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_312]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_312]
at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_312]
Caused by: java.sql.SQLTransientConnectionException: (conn=3221487821) The RootServer is not the master
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:128) ~[oceanbase-client-2.4.2.jar!/:na]
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:202) ~[oceanbase-client-2.4.2.jar!/:na]
at com.oceanbase.jdbc.OceanBaseStatement.executeExceptionEpilogue(OceanBaseStatement.java:315) ~[oceanbase-client-2.4.2.jar!/:na]
at com.oceanbase.jdbc.JDBC4PreparedStatement.executeInternal(JDBC4PreparedStatement.java:243) ~[oceanbase-client-2.4.2.jar!/:na]
at com.oceanbase.jdbc.JDBC4PreparedStatement.execute(JDBC4PreparedStatement.java:161) ~[oceanbase-client-2.4.2.jar!/:na]
at com.oceanbase.jdbc.JDBC4PreparedStatement.executeUpdate(JDBC4PreparedStatement.java:195) ~[oceanbase-client-2.4.2.jar!/:na]
at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeUpdate(DruidPooledPreparedStatement.java:255) ~[druid-1.2.8.jar!/:1.2.8]
at org.springframework.jdbc.cor
e.JdbcTemplate.lambda$update$2(JdbcTemplate.java:965) ~[spring-jdbc-5.3.26.jar!/:5.3.26]
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:651) ~[spring-jdbc-5.3.26.jar!/:5.3.26]
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:960) ~[spring-jdbc-5.3.26.jar!/:5.3.26]
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:1015) ~[spring-jdbc-5.3.26.jar!/:5.3.26]
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:1025) ~[spring-jdbc-5.3.26.jar!/:5.3.26]
at com.oceanbase.ocp.obsdk.connector.ConnectTemplate.updateInner(ConnectTemplate.java:269) ~[obsdk-4.1.0-20230720.jar!/:4.1.0-20230720]
… 15 common frames omitted
Caused by: com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException: The RootServer is not the master
at com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException.of(OceanBaseSqlException.java:79) ~[oceanbase-client-2.4.2.jar!/:na]
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:199) ~[oceanbase-client-2.4.2.jar!/:na]
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:180) ~[oceanbase-client-2.4.2.jar!/:na]
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:372) ~[oceanbase-client-2.4.2.jar!/:na]
at com.oceanbase.jdbc.JDBC4PreparedStatement.executeInternal(JDBC4PreparedStatement.java:234) ~[oceanbase-client-2.4.2.jar!/:na]
… 24 common frames omitted
Caused by: java.sql.SQLException: The RootServer is not the master
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:2192) ~[oceanbase-client-2.4.2.jar!/:na]
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:2057) ~[oceanbase-client-2.4.2.jar!/:na]
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1951) ~[oceanbase-client-2.4.2.jar
!/:na]
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:370) ~[oceanbase-client-2.4.2.jar!/:na]
… 25 common frames omitted
Set state for subtask: 4357, operation:RETRY, state: FAILED
