2024-04-11 20:12:10.746 INFO 23707 --- [pool-manual-subtask-executor15,7c7cf3e176494880,e65a5f0a0529] c.o.o.c.t.e.runner.JavaSubtaskRunner : Run subtask, id=3246, context=Context{parallelIdx=0, stringMap={ob_log_disk_path=/webapps/obdata/redo, task_instance_id=3284, task_operation=execute, ob_run_path=/home/admin/oceanbase, service_version=4.2.2.1, ob_install_path=/home/admin/oceanbase, host.4.zone=zone1, ob_sql_port=2881, cluster_id=1, ob_disk_path_style=OBD, ob_svr_port=2882, sub_task_instance_name=Add observer, sub_task_instance_id=3246, cluster_name=myob, target_server_status=RUNNING, mix_rpm_names={"zone1":"oceanbase-ce-4.2.2.1-101000012024030709.el7.x86_64.rpm"}, startup_option_string=, subtask_splitter=host_ids, service_name=myob:1712818952, target_zone_status=RUNNING, ob_cluster_id=1712818952, service_type=OB_CLUSTER, dep_rpm_names={"zone1":["oceanbase-ce-libs-4.2.2.1-101000012024030709.el7.x86_64.rpm","oceanbase-ce-utils-4.2.2.1-101000012024030709.el7.x86_64.rpm"]}, ob_run_user=admin, target_cluster_status=RUNNING, latest_execution_start_time=2024-04-11T20:12:10.138+08:00, ob_data_disk_path=/webapps/obdata/data, mix_obs_rpm={}}, listMap={root_server_ips=[xx.xx.xx.75], server_ids=[4], exists_server_addrs=[xx.xx.xx.75:2882, xx.xx.xx.11:2882, xx.xx.xx.15:2882], host_ids=[4], exists_running_server_addrs=[xx.xx.xx.75:2882, xx.xx.xx.11:2882, xx.xx.xx.15:2882], zone_names=[zone1]}}, executor=xx.xx.xx.75 2024-04-11 20:12:10.802 INFO 23707 --- [pool-manual-subtask-executor15,7c7cf3e176494880,e65a5f0a0529] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:xx.xx.xx.75, sql port:2881 2024-04-11 20:12:10.805 INFO 23707 --- [pool-manual-subtask-executor15,7c7cf3e176494880,e65a5f0a0529] c.o.o.s.t.b.server.ObServerTaskHandler : begin to add server, zoneName=zone1, svrIp=xx.xx.xx.14, svrPort=2882 2024-04-11 20:12:10.811 INFO 23707 --- [pool-manual-subtask-executor15,7c7cf3e176494880,e65a5f0a0529] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:xx.xx.xx.75, sql port:2881 2024-04-11 20:12:10.815 INFO 23707 --- [pool-manual-subtask-executor15,7c7cf3e176494880,e65a5f0a0529] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-04-11 20:12:10.818 INFO 23707 --- [pool-manual-subtask-executor15,7c7cf3e176494880,e65a5f0a0529] 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.14, 2882] 2024-04-11 20:12:10.821 INFO 23707 --- [pool-manual-subtask-executor15,7c7cf3e176494880,e65a5f0a0529] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:xx.xx.xx.75, sql port:2881 2024-04-11 20:12:10.824 INFO 23707 --- [pool-manual-subtask-executor15,7c7cf3e176494880,e65a5f0a0529] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-04-11 20:12:10.827 INFO 23707 --- [pool-manual-subtask-executor15,7c7cf3e176494880,e65a5f0a0529] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [600000000] 2024-04-11 20:12:10.830 INFO 23707 --- [pool-manual-subtask-executor15,7c7cf3e176494880,e65a5f0a0529] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: alter system add server ? zone ?, args: [xx.xx.xx.14:2882, zone1] 2024-04-11 20:12:10.843 WARN 23707 --- [pool-manual-subtask-executor15,7c7cf3e176494880,e65a5f0a0529] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] update failed, sql:[alter system add server ? zone ?], error message:[PreparedStatementCallback; SQL [alter system add server ? zone ?]; (conn=3221645277) Not supported feature or function; nested exception is java.sql.SQLFeatureNotSupportedException: (conn=3221645277) Not supported feature or function] 2024-04-11 20:12:10.847 INFO 23707 --- [pool-manual-subtask-executor15,7c7cf3e176494880,e65a5f0a0529] c.o.ocp.obsdk.connector.ConnectTemplate : Last Trace Info:[YB42C0A84D4B-000615CCE0CAEEBB-0-0] 2024-04-11 20:12:10.851 INFO 23707 --- [pool-manual-subtask-executor15,7c7cf3e176494880,e65a5f0a0529] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-04-11 20:12:10.856 ERROR 23707 --- [pool-manual-subtask-executor15,7c7cf3e176494880,e65a5f0a0529] c.o.o.c.t.e.c.w.subtask.SubtaskExecutor : Not supported feature or function java.sql.SQLException: Not supported feature or function 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.addServer(MysqlClusterOperator.java:606) 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) a t 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:750) Set state for subtask: 3246, operation:EXECUTE, state: FAILED