【 使用环境 】测试环境
【 OB 】v4.3.1
【 OCP】版本号: 4.3.1-20240805192406
【问题描述】使用OCP创建的OB集群，在OCP点击添加observer节点，到了add observer这个流程也是报错超时，无法添加
【复现路径】OCP添加observer
【附件及日志】
2024-09-11 14:21:41.410 INFO 26467 — [manual-subtask-executor15,a4cfea886a10a90f,21451a6148f5eef6] c.o.ocp.obsdk.connector.ConnectTemplate : Last Trace Info:[YB420A15081A-000621C87DEFEAEE-0-0]
2024-09-11 14:21:41.411 INFO 26467 — [manual-subtask-executor15,a4cfea886a10a90f,21451a6148f5eef6] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] slow query, durationMillis=599957, sql=alter system add server ? zone ?
2024-09-11 14:21:41.412 INFO 26467 — [manual-subtask-executor15,a4cfea886a10a90f,21451a6148f5eef6] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000]
2024-09-11 14:21:41.414 ERROR 26467 — [manual-subtask-executor15,a4cfea886a10a90f,21451a6148f5eef6] c.o.o.c.t.e.c.w.subtask.SubtaskExecutor : Timeout
java.sql.SQLException: Timeout
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:2347)
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:2210)
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:2098)
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:399)
at com.oceanbase.jdbc.JDBC4PreparedStatement.executeInternal(JDBC4PreparedStatement.java:247)
at com.oceanbase.jdbc.JDBC4PreparedStatement.execute(JDBC4PreparedStatement.java:170)
at com.oceanbase.jdbc.JDBC4PreparedStatement.executeUpdate(JDBC4PreparedStatement.java:204)
at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeUpdate(DruidPooledPreparedStatement.java:255)
at org.springframework.jdbc.core.JdbcTemplate.lambda$update$2(JdbcTemplate.java:967)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:650)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:962)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:1017)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:1027)
at com.oceanbase.ocp.obsdk.connector.ConnectTemplate.updateInner(ConnectTemplate.java:293)
at com.oceanbase.ocp.obsdk.connector.ConnectTemplate.update(ConnectTemplate.java:282)
at com.oceanbase.ocp.obsdk.operator.cluster.MysqlClusterOperator.addServer(MysqlClusterOperator.java:613)
at com.oceanbase.ocp.service.task.business.server.ObServerTaskHandler.addObServer(ObServerTaskHandler.java:196)
at com.oceanbase.ocp.service.task.business.server.AddObServerTask.run(AddObServerTask.java:53)
at com.oceanbase.ocp.core.task.engine.runner.JavaSubtaskRunner.execute(JavaSubtaskRunner.java:64)
at com.oceanbase.ocp.core.task.engine.runner.JavaSubta
skRunner.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.RunnerFactory.doRun(RunnerFactory.java:76)
at com.oceanbase.ocp.core.task.engine.coordinator.worker.subtask.SubtaskExecutor.doRun(SubtaskExecutor.java:206)
at com.oceanbase.ocp.core.task.engine.coordinator.worker.subtask.SubtaskExecutor.redirectConsoleOutput(SubtaskExecutor.java:200)
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: 2008969, operation:EXECUTE, state: FAILED
rootservice.log (6.4 MB)
