2025-03-04 08:35:26.824 INFO 17347 --- [pool-manual-subtask-executor16,012553f39fcb48b5,ff56b92b696b] c.o.o.c.t.e.runner.JavaSubtaskRunner : Run subtask, id=58099, context=Context{parallelIdx=-1, stringMap={ob_log_disk_path=/data/log1, task_instance_id=58766, task_operation=execute, zone_name=zone1, ob_run_path=/home/admin/oceanbase, ob_install_path=/home/admin/oceanbase, ndcatl.1740736713.watched_parameters={"server_permanent_offline_time":"3600s"}, ob_sql_port=2881, cluster_id=2, ob_disk_path_style=DEFAULT, ob_svr_port=2882, host.2.zone=zone1, ob_cluster_parameter_map=server_permanent_offline_time=60s, sub_task_instance_name=Delete observer, watched_scenario=DELETE_SERVER, sub_task_instance_id=58099, cluster_name=ndcatl, target_server_status=RUNNING, mix_rpm_names={"zone4":"oceanbase-ce-4.2.1.8-108000022024072217.el7.x86_64.rpm","zone3":"oceanbase-ce-4.2.1.8-108000022024072217.el7.x86_64.rpm","zone2":"oceanbase-ce-4.2.1.8-108000022024072217.el7.x86_64.rpm","zone1":"oceanbase-ce-4.2.1.8-108000022024072217.el7.x86_64.rpm"}, startup_option_string=, ob_version=4.2.1.8, former_cluster_status=RUNNING, target_zone_status=RUNNING, former_zone_status=RUNNING, server_id=2, ob_cluster_id=1740736713, host_id=2, dep_rpm_names={"zone4":["oceanbase-ce-libs-4.2.1.8-108000022024072217.el7.x86_64.rpm","oceanbase-ce-utils-4.2.1.8-108000022024072217.el7.x86_64.rpm"],"zone3":["oceanbase-ce-libs-4.2.1.8-108000022024072217.el7.x86_64.rpm","oceanbase-ce-utils-4.2.1.8-108000022024072217.el7.x86_64.rpm"],"zone2":["oceanbase-ce-libs-4.2.1.8-108000022024072217.el7.x86_64.rpm","oceanbase-ce-utils-4.2.1.8-108000022024072217.el7.x86_64.rpm"],"zone1":["oceanbase-ce-libs-4.2.1.8-108000022024072217.el7.x86_64.rpm","oceanbase-ce-utils-4.2.1.8-108000022024072217.el7.x86_64.rpm"]}, target_cluster_status=RUNNING, ob_run_user=admin, latest_execution_start_time=2025-03-04T08:35:26.573+08:00, former_server_status=PROCESS_STOPPED, ob_data_disk_path=/data/1, mix_obs_rpm={}}, listMap={root_server_ips=[10.38.36.243, 10.38.36.241], server_ids=[2], exi sts_server_addrs=[10.38.36.241:2882, 10.38.36.243:2882, 10.38.36.240:2882], host_ids=[2], zone_names=[zone1]}}, executor=10.38.36.237 2025-03-04 08:35:26.834 INFO 17347 --- [pool-manual-subtask-executor16,012553f39fcb48b5,ff56b92b696b] c.o.o.s.t.b.server.DeleteObServerTask : begin to delete server by ob cmd, clusterId=2, serverId=2 2025-03-04 08:35:26.981 INFO 17347 --- [pool-manual-subtask-executor16,012553f39fcb48b5,ff56b92b696b] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.38.36.243, sql port:2881 2025-03-04 08:35:26.987 INFO 17347 --- [pool-manual-subtask-executor16,012553f39fcb48b5,ff56b92b696b] c.o.o.s.t.b.server.ObServerTaskHandler : begin to delete server, svrIp=10.38.36.239, svrPort=2882 2025-03-04 08:35:26.992 INFO 17347 --- [pool-manual-subtask-executor16,012553f39fcb48b5,ff56b92b696b] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.38.36.243, sql port:2881 2025-03-04 08:35:26.997 INFO 17347 --- [pool-manual-subtask-executor16,012553f39fcb48b5,ff56b92b696b] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2025-03-04 08:35:27.004 INFO 17347 --- [pool-manual-subtask-executor16,012553f39fcb48b5,ff56b92b696b] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT zone, svr_ip, svr_port, sql_port AS inner_port, with_rootserver, UPPER(`status`) AS `status`, build_version, UNIX_TIMESTAMP(NVL(`stop_time`, 0))*1000000 AS stop_time, UNIX_TIMESTAMP(NVL(`start_service_time`, 0))*1000000 AS start_service_time, UNIX_TIMESTAMP(NVL(`block_migrate_in_time`, 0))*1000000 AS block_migrate_in_time FROM DBA_OB_SERVERS WHERE svr_ip = ? AND svr_port = ?, args: [10.38.36.239, 2882] 2025-03-04 08:35:27.012 INFO 17347 --- [pool-manual-subtask-executor16,012553f39fcb48b5,ff56b92b696b] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.38.36.243, sql port:2881 2025-03-04 08:35:27.018 INFO 17347 --- [pool-manual-subtask-executor16,012553f39fcb48b5,ff56b92b696b] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2025-03-04 08:35:27.023 INFO 17347 --- [pool-manual-subtask-executor16,012553f39fcb48b5,ff56b92b696b] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [600000000] 2025-03-04 08:35:27.028 INFO 17347 --- [pool-manual-subtask-executor16,012553f39fcb48b5,ff56b92b696b] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: alter system delete server ?, args: [10.38.36.239:2882] 2025-03-04 08:35:27.038 WARN 17347 --- [pool-manual-subtask-executor16,012553f39fcb48b5,ff56b92b696b] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] update failed, sql:[alter system delete server ?], error message:[PreparedStatementCallback; SQL [alter system delete server ?]; (conn=3222478213) Invalid argument; nested exception is java.sql.SQLTransientConnectionException: (conn=3222478213) Invalid argument] 2025-03-04 08:35:27.044 INFO 17347 --- [pool-manual-subtask-executor16,012553f39fcb48b5,ff56b92b696b] c.o.ocp.obsdk.connector.ConnectTemplate : Last Trace Info:[YB420A2624F3-00062F6C3CE802DC-0-0] 2025-03-04 08:35:27.048 INFO 17347 --- [pool-manual-subtask-executor16,012553f39fcb48b5,ff56b92b696b] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2025-03-04 08:35:27.055 ERROR 17347 --- [pool-manual-subtask-executor16,012553f39fcb48b5,ff56b92b696b] c.o.o.c.t.e.c.w.subtask.SubtaskExecutor : Invalid argument java.sql.SQLException: Invalid argument at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:2192) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:2057) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1951) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:370) at com.oceanbase.jdbc.JDBC4PreparedStatement.executeInternal(JDBC4PreparedStatement.java:234) at com.oceanbase.jdbc.JDBC4PreparedStatement.execute(JDBC4PreparedStatement.java:161) at com.oceanbase.jdbc.JDBC4PreparedStatement.executeUpdate(JDBC4PreparedStatement.java:195) at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeUpdate(DruidPooledPreparedStatement.java:255) at org.springframework.jdbc.core.JdbcTemplate.lambda$update$2(JdbcTemplate.java:973) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:656) at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:968) at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:1023) at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:1033) at com.oceanbase.ocp.obsdk.connector.ConnectTemplate.updateInner(ConnectTemplate.java:294) at com.oceanbase.ocp.obsdk.connector.ConnectTemplate.update(ConnectTemplate.java:283) at com.oceanbase.ocp.obsdk.operator.cluster.MysqlClusterOperator.deleteServer(MysqlClusterOperator.java:614) at com.oceanbase.ocp.service.task.business.server.ObServerTaskHandler.deleteObServer(ObServerTaskHandler.java:248) at com.oceanbase.ocp.service.task.business.server.ObServerTaskHandler.deleteObServer(ObServerTaskHandler.java:210) at com.oceanbase.ocp.service.task.business.server.DeleteObServerTask.run(DeleteObServerTask.java:48) 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.RunnerFactory.doRun(RunnerFactory.java:76) at com.oceanbase.ocp.core.task.engine.coordinator.worker.subtask.SubtaskExecutor.doRun(SubtaskExecutor.java:203) at com.oceanbase.ocp.core.task.engine.coordinator.worker.subtask.SubtaskExecutor.redirectConsoleOutput(SubtaskExecutor.java:197) at com.oceanbase.ocp.core.task.engine.coordinator.worker.subtask.SubtaskExecutor.lambda$submit$2(SubtaskExecutor.java:134) 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:748) Set state for subtask: 58099, operation:EXECUTE, state: FAILED