############{EXECUTE}{2024-06-25T18:15:49.893+08:00}############ 2024-06-25 18:15:50.162 INFO 138827 --- [pool-manual-subtask-executor16,d8082f2ca31e41f1,d40afcda6f46] c.o.o.c.t.e.runner.JavaSubtaskRunner : Run subtask, id=29, context=Context{parallelIdx=-1, stringMap={old_config_url=, task_instance_id=3, task_operation=execute, cluster_type=PRIMARY, service_version=4.3.1.0, host_credential_id=1, cluster_id=1, sub_task_instance_name=Create resource manager for default user, sub_task_instance_id=29, cluster_version=4.3.1.0, cluster_name=ocp_422, target_server_status=RUNNING, subtask_splitter=host_ids, ssh_port=22, service_name=ocp_422:1719302517, target_zone_status=RUNNING, ob_connect_address=172.20.17.86:2881, ob_cluster_id=1719302517, root_sys_password=******, service_type=OB_CLUSTER, obproxy_proxyro_password=******, ob_data_dir=/data/1, connection_mode=direct, target_cluster_status=RUNNING, latest_execution_start_time=2024-06-25T18:15:49.884+08:00}, listMap={add_region_ids=[2], server_ids=[1], add_idc_ids=[1], all_host_ids=[1], add_host_ids=[1], host_ids=[1], zone_names=[zone1]}}, executor=172.20.17.86 2024-06-25 18:15:50.215 INFO 138827 --- [pool-manual-subtask-executor16,d8082f2ca31e41f1,d40afcda6f46] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-06-25 18:15:50.217 INFO 138827 --- [pool-manual-subtask-executor16,d8082f2ca31e41f1,d40afcda6f46] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT CONSUMER_GROUP FROM DBA_RSRC_CONSUMER_GROUPS 2024-06-25 18:15:50.224 INFO 138827 --- [pool-manual-subtask-executor16,d8082f2ca31e41f1,d40afcda6f46] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-06-25 18:15:50.226 INFO 138827 --- [pool-manual-subtask-executor16,d8082f2ca31e41f1,d40afcda6f46] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT PLAN FROM DBA_RSRC_PLANS 2024-06-25 18:15:50.254 INFO 138827 --- [pool-manual-subtask-executor16,d8082f2ca31e41f1,d40afcda6f46] c.o.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, clusterName=ocp_422, tenantName=sys, dbUser=root 2024-06-25 18:15:50.257 INFO 138827 --- [pool-manual-subtask-executor16,d8082f2ca31e41f1,d40afcda6f46] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-06-25 18:15:50.259 INFO 138827 --- [pool-manual-subtask-executor16,d8082f2ca31e41f1,d40afcda6f46] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT CONSUMER_GROUP FROM DBA_RSRC_CONSUMER_GROUPS 2024-06-25 18:15:50.263 INFO 138827 --- [pool-manual-subtask-executor16,d8082f2ca31e41f1,d40afcda6f46] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-06-25 18:15:50.265 INFO 138827 --- [pool-manual-subtask-executor16,d8082f2ca31e41f1,d40afcda6f46] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT CONSUMER_GROUP, ATTRIBUTE, VALUE FROM DBA_RSRC_GROUP_MAPPINGS WHERE CONSUMER_GROUP IS NOT NULL AND CONSUMER_GROUP <> '' 2024-06-25 18:15:50.292 INFO 138827 --- [pool-manual-subtask-executor16,d8082f2ca31e41f1,d40afcda6f46] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-06-25 18:15:50.294 INFO 138827 --- [pool-manual-subtask-executor16,d8082f2ca31e41f1,d40afcda6f46] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: call DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP (CONSUMER_GROUP => 'ocp_monitor_group', COMMENT => 'reserve thread for default user'); 2024-06-25 18:15:50.581 INFO 138827 --- [pool-manual-subtask-executor16,d8082f2ca31e41f1,d40afcda6f46] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-06-25 18:15:50.584 INFO 138827 --- [pool-manual-subtask-executor16,d8082f2ca31e41f1,d40afcda6f46] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: call DBMS_RESOURCE_MANAGER.SET_CONSUMER_GROUP_MAPPING (ATTRIBUTE => 'USER', VALUE => 'ocp_monitor', CONSUMER_GROUP => 'ocp_monitor_group'); 2024-06-25 18:15:50.607 INFO 138827 --- [pool-manual-subtask-executor16,d8082f2ca31e41f1,d40afcda6f46] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-06-25 18:15:50.610 INFO 138827 --- [pool-manual-subtask-executor16,d8082f2ca31e41f1,d40afcda6f46] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT CONSUMER_GROUP, COMMENTS FROM DBA_RSRC_CONSUMER_GROUPS WHERE CONSUMER_GROUP = ?, args: [ocp_monitor_group] 2024-06-25 18:15:50.617 INFO 138827 --- [pool-manual-subtask-executor16,d8082f2ca31e41f1,d40afcda6f46] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-06-25 18:15:50.620 INFO 138827 --- [pool-manual-subtask-executor16,d8082f2ca31e41f1,d40afcda6f46] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT CONSUMER_GROUP, ATTRIBUTE, VALUE FROM DBA_RSRC_GROUP_MAPPINGS WHERE CONSUMER_GROUP IS NOT NULL AND CONSUMER_GROUP <> '' AND CONSUMER_GROUP IN (:groupNames), args: [[ocp_monitor_group]] 2024-06-25 18:15:50.655 INFO 138827 --- [pool-manual-subtask-executor16,d8082f2ca31e41f1,d40afcda6f46] c.o.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, clusterName=ocp_422, tenantName=sys, dbUser=root 2024-06-25 18:15:50.658 INFO 138827 --- [pool-manual-subtask-executor16,d8082f2ca31e41f1,d40afcda6f46] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-06-25 18:15:50.661 INFO 138827 --- [pool-manual-subtask-executor16,d8082f2ca31e41f1,d40afcda6f46] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT PLAN FROM DBA_RSRC_PLANS 2024-06-25 18:15:50.663 INFO 138827 --- [pool-manual-subtask-executor16,d8082f2ca31e41f1,d40afcda6f46] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-06-25 18:15:50.666 INFO 138827 --- [pool-manual-subtask-executor16,d8082f2ca31e41f1,d40afcda6f46] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: call DBMS_RESOURCE_MANAGER.CREATE_PLAN (PLAN => 'ocp_monitor_plan', COMMENT => 'resource plan for default user'); 2024-06-25 18:15:50.683 INFO 138827 --- [pool-manual-subtask-executor16,d8082f2ca31e41f1,d40afcda6f46] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-06-25 18:15:50.685 INFO 138827 --- [pool-manual-subtask-executor16,d8082f2ca31e41f1,d40afcda6f46] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: call DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE (PLAN => 'ocp_monitor_plan', GROUP_OR_SUBPLAN => 'ocp_monitor_group', MGMT_P1 => 40, UTILIZATION_LIMIT => 80); 2024-06-25 18:15:50.704 WARN 138827 --- [pool-manual-subtask-executor16,d8082f2ca31e41f1,d40afcda6f46] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] execute failed, sql:[call DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE (PLAN => 'ocp_monitor_plan', GROUP_OR_SUBPLAN => 'ocp_monitor_group', MGMT_P1 => 40, UTILIZATION_LIMIT => 80);], error message:[StatementCallback; SQL [call DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE (PLAN => 'ocp_monitor_plan', GROUP_OR_SUBPLAN => 'ocp_monitor_group', MGMT_P1 => 40, UTILIZATION_LIMIT => 80);]; (conn=3221493624) not run io_calibration yet; nested exception is java.sql.SQLTransientConnectionException: (conn=3221493624) not run io_calibration yet] 2024-06-25 18:15:50.708 INFO 138827 --- [pool-manual-subtask-executor16,d8082f2ca31e41f1,d40afcda6f46] c.o.ocp.obsdk.connector.ConnectTemplate : Last Trace Info:[YB42AC141156-00061BB27DCEE169-0-0] 2024-06-25 18:15:50.712 ERROR 138827 --- [pool-manual-subtask-executor16,d8082f2ca31e41f1,d40afcda6f46] c.o.o.c.t.e.c.w.subtask.SubtaskExecutor : not run io_calibration yet java.sql.SQLException: not run io_calibration yet 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:324) at com.oceanbase.jdbc.OceanBaseStatement.executeInternal(OceanBaseStatement.java:489) at com.oceanbase.jdbc.OceanBaseStatement.execute(OceanBaseStatement.java:676) at com.oceanbase.jdbc.OceanBaseStatement.execute(OceanBaseStatement.java:643) at com.alibaba.druid.pool.DruidPooledStatement.execute(DruidPooledStatement.java:644) at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:427) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:383) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:436) at com.oceanbase.ocp.obsdk.connector.ConnectTemplate.execute(ConnectTemplate.java:308) at com.oceanbase.ocp.obsdk.connector.ObConnectTemplate.executeMysqlPl(ObConnectTemplate.java:97) at com.oceanbase.ocp.obsdk.connector.ObConnectTemplate.executePl(ObConnectTemplate.java:88) at com.oceanbase.ocp.obsdk.accessor.resource.AbstractResourceAccessor.createPlanDirective(AbstractResourceAccessor.java:176) at com.oceanbase.ocp.obops.internal.resource.TenantResourceServiceImpl.createResourcePlan(TenantResourceServiceImpl.java:331) at com.oceanbase.ocp.obops.internal.resource.DefaultUserResourceManagerServiceImpl.createResourcePlanForUser(DefaultUserResourceManagerServiceImpl.java:120) at com.oceanbase.ocp.service.task.business.cluster.CreateResourceManagerForDefaultUserTask.run(Create ResourceManagerForDefaultUserTask.java:76) 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:750) Set state for subtask: 29, operation:EXECUTE, state: FAILED