2024-09-29 10:37:02.749 INFO 8 --- [manual-subtask-executor15,6b1ac79c09c8ac26,b247d57100644110] c.o.o.c.t.e.runner.JavaSubtaskRunner : Run subtask, id=7039517, context=Context{parallelIdx=-1, stringMap={dp_ob_poc.1691672001.watched_parameters={"server_permanent_offline_time":"86400"}, ob_log_disk_path=/data/log1, task_instance_id=7033843, task_operation=execute, zone_name=zone3, ob_run_path=/home/admin/oceanbase, ob_install_path=/home/admin/oceanbase, ob_sql_port=2881, cluster_id=2, ob_disk_path_style=DEFAULT, ob_svr_port=2882, host.2.zone=zone3, ob_cluster_parameter_map=server_permanent_offline_time=60s, sub_task_instance_name=Delete observer, watched_scenario=DELETE_SERVER, sub_task_instance_id=7039517, cluster_name=dp_ob_poc, target_server_status=RUNNING, mix_rpm_names={"zone3":"oceanbase-4.2.1.8-108000052024072217.el7.x86_64.rpm","zone2":"oceanbase-4.2.1.8-108000052024072217.el7.x86_64.rpm","zone1":"oceanbase-4.2.1.8-108000052024072217.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=1691672001, host_id=2, dep_rpm_names={}, target_cluster_status=RUNNING, ob_run_user=admin, latest_execution_start_time=2024-09-29T10:37:02.679+08:00, former_server_status=PROCESS_STOPPED, ob_data_disk_path=/data/1, mix_obs_rpm={}}, listMap={root_server_ips=[xx.xx.xx.69, xx.xx.xx.169], server_ids=[2], exists_server_addrs=[xx.xx.xx.169:2882, xx.xx.xx.69:2882], host_ids=[2], zone_names=[zone3]}}, executor=xx.xx.xx.232 2024-09-29 10:37:02.752 INFO 8 --- [manual-subtask-executor15,6b1ac79c09c8ac26,b247d57100644110] c.o.o.s.t.b.server.DeleteObServerTask : begin to delete server by ob cmd, clusterId=2, serverId=2 2024-09-29 10:37:02.773 INFO 8 --- [manual-subtask-executor15,6b1ac79c09c8ac26,b247d57100644110] c.o.o.s.t.b.server.ObServerTaskHandler : begin to delete server, svrIp=xx.xx.xx.xx, svrPort=2882 2024-09-29 10:37:02.776 INFO 8 --- [manual-subtask-executor15,6b1ac79c09c8ac26,b247d57100644110] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-09-29 10:37:02.780 INFO 8 --- [manual-subtask-executor15,6b1ac79c09c8ac26,b247d57100644110] 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: [xx.xx.xx.xx, 2882] 2024-09-29 10:37:02.785 INFO 8 --- [manual-subtask-executor15,6b1ac79c09c8ac26,b247d57100644110] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-09-29 10:37:02.788 INFO 8 --- [manual-subtask-executor15,6b1ac79c09c8ac26,b247d57100644110] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [600000000] 2024-09-29 10:37:02.791 INFO 8 --- [manual-subtask-executor15,6b1ac79c09c8ac26,b247d57100644110] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: alter system delete server ? zone=?, args: [xx.xx.xx.xx:2882, zone3] 2024-09-29 10:37:02.798 WARN 8 --- [manual-subtask-executor15,6b1ac79c09c8ac26,b247d57100644110] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] update failed, sql:[alter system delete server ? zone=?], error message:[PreparedStatementCallback; SQL [alter system delete server ? zone=?]; (conn=2625562) Invalid argument; nested exception is java.sql.SQLTransientConnectionException: (conn=2625562) Invalid argument] 2024-09-29 10:37:02.801 INFO 8 --- [manual-subtask-executor15,6b1ac79c09c8ac26,b247d57100644110] c.o.ocp.obsdk.connector.ConnectTemplate : Last Trace Info:[YB420A330345-00062027D16C204F-0-0] 2024-09-29 10:37:02.803 INFO 8 --- [manual-subtask-executor15,6b1ac79c09c8ac26,b247d57100644110] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-09-29 10:37:02.806 WARN 8 --- [manual-subtask-executor15,6b1ac79c09c8ac26,b247d57100644110] c.o.o.o.o.cluster.MysqlClusterOperator : delete server from zone failed, error message: (conn=2625562) Invalid argument 2024-09-29 10:37:02.808 INFO 8 --- [manual-subtask-executor15,6b1ac79c09c8ac26,b247d57100644110] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-09-29 10:37:02.810 INFO 8 --- [manual-subtask-executor15,6b1ac79c09c8ac26,b247d57100644110] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [600000000] 2024-09-29 10:37:02.813 INFO 8 --- [manual-subtask-executor15,6b1ac79c09c8ac26,b247d57100644110] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: alter system delete server ?, args: [xx.xx.xx.xx:2882] 2024-09-29 10:37:02.817 WARN 8 --- [manual-subtask-executor15,6b1ac79c09c8ac26,b247d57100644110] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] update failed, sql:[alter system delete server ?], error message:[PreparedStatementCallback; SQL [alter system delete server ?]; (conn=2625562) Invalid argument; nested exception is java.sql.SQLTransientConnectionException: (conn=2625562) Invalid argument] 2024-09-29 10:37:02.820 INFO 8 --- [manual-subtask-executor15,6b1ac79c09c8ac26,b247d57100644110] c.o.ocp.obsdk.connector.ConnectTemplate : Last Trace Info:[YB420A330345-00062027D16C2054-0-0] 2024-09-29 10:37:02.822 INFO 8 --- [manual-subtask-executor15,6b1ac79c09c8ac26,b247d57100644110] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-09-29 10:37:02.824 ERROR 8 --- [manual-subtask-executor15,6b1ac79c09c8ac26,b247d57100644110] 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: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.deleteServer(MysqlClusterOperator.java:627) 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.ocea nbase.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: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: 7039517, operation:EXECUTE, state: FAILED