2024-02-04 16:31:45.212 INFO 3317586 --- [pool-manual-subtask-executor16,bb208161c5e647f6,bc1f3e0dea6e] c.o.o.c.t.e.runner.JavaSubtaskRunner : Run subtask, id=836, context=Context{parallelIdx=0, stringMap={tenant_id=3, cluster_id=1, subtask_splitter=zone_names, task_instance_id=780, former_tenant_status=NORMAL, task_operation=execute, latest_execution_start_time=2024-02-04T16:31:45.044+08:00, sub_task_instance_name=Alter resource pool unit spec, target_tenant_status=NORMAL, sub_task_instance_id=836}, listMap={unit_count_list=[null], unit_spec_name_list=[S0], zone_names=[zone1]}}, executor=10.0.1.131 2024-02-04 16:31:45.217 INFO 3317586 --- [pool-manual-subtask-executor16,bb208161c5e647f6,bc1f3e0dea6e] .o.o.i.t.t.AlterResourcePoolUnitSpecTask : begin to alter resource pool unit spec, tenantId=3, zoneName=zone1, unitSpecName=S0 2024-02-04 16:31:45.258 INFO 3317586 --- [pool-manual-subtask-executor16,bb208161c5e647f6,bc1f3e0dea6e] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.1.131, sql port:2881 2024-02-04 16:31:45.264 INFO 3317586 --- [pool-manual-subtask-executor16,bb208161c5e647f6,bc1f3e0dea6e] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.1.131, sql port:2881 2024-02-04 16:31:45.269 INFO 3317586 --- [pool-manual-subtask-executor16,bb208161c5e647f6,bc1f3e0dea6e] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-02-04 16:31:45.296 INFO 3317586 --- [pool-manual-subtask-executor16,bb208161c5e647f6,bc1f3e0dea6e] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT /*+ QUERY_TIMEOUT(60000000) */ time_to_usec(t1.MODIFY_TIME) AS UPDATE_TIME, t1.RESOURCE_POOL_ID, t1.NAME, t1.UNIT_COUNT, t1.UNIT_CONFIG_ID, t1.ZONE_LIST, t1.TENANT_ID, t1.REPLICA_TYPE, t2.NAME AS UNIT_CONFIG_NAME, t2.MAX_CPU, t2.MIN_CPU, t2.MEMORY_SIZE AS MAX_MEMORY, t2.MEMORY_SIZE AS MIN_MEMORY, t2.LOG_DISK_SIZE, t2.MAX_IOPS, t2.MIN_IOPS, t2.IOPS_WEIGHT FROM oceanbase.DBA_OB_RESOURCE_POOLS AS t1 JOIN oceanbase.DBA_OB_UNIT_CONFIGS AS t2 ON t1.UNIT_CONFIG_ID = t2.UNIT_CONFIG_ID AND t1.tenant_id = ?, args: [1004] 2024-02-04 16:31:45.305 INFO 3317586 --- [pool-manual-subtask-executor16,bb208161c5e647f6,bc1f3e0dea6e] c.o.o.o.i.t.ResourcePoolServiceImpl : current unit config: ObUnitConfig(unitConfigId=1002, name=ocp_monitor_unit, maxCpu=2.0, minCpu=2.0, maxMemory=8589934592, minMemory=8589934592, logDiskSize=25769803776, maxIops=9223372036854775807, minIops=9223372036854775807, iopsWeight=2, maxDiskSize=null, maxSessionNum=null), target unit spec: UnitSpec(id=4, name=S0, type=SYSTEM, group=standard, maxCpuCoreCount=0.5, minCpuCoreCount=0.5, maxMemoryByte=2147483648, maxMemorySize=2, minMemoryByte=2147483648, minMemorySize=2, logDiskSizeByte=null, maxIops=null, minIops=null, iopsWeight=null, notRecommended=null, unitSpecLimit=null) 2024-02-04 16:31:45.311 INFO 3317586 --- [pool-manual-subtask-executor16,bb208161c5e647f6,bc1f3e0dea6e] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.1.131, sql port:2881 2024-02-04 16:31:45.315 INFO 3317586 --- [pool-manual-subtask-executor16,bb208161c5e647f6,bc1f3e0dea6e] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-02-04 16:31:45.320 INFO 3317586 --- [pool-manual-subtask-executor16,bb208161c5e647f6,bc1f3e0dea6e] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: CREATE RESOURCE UNIT `config_ocp_monitor_zone1_S0_hvj` MAX_CPU = ?, MIN_CPU = ?, MEMORY_SIZE = ?, args: [0.5, 0.5, 2147483648] 2024-02-04 16:31:45.329 WARN 3317586 --- [pool-manual-subtask-executor16,bb208161c5e647f6,bc1f3e0dea6e] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] update failed, sql:[CREATE RESOURCE UNIT `config_ocp_monitor_zone1_S0_hvj` MAX_CPU = ?, MIN_CPU = ?, MEMORY_SIZE = ?], error message:[PreparedStatementCallback; SQL [CREATE RESOURCE UNIT `config_ocp_monitor_zone1_S0_hvj` MAX_CPU = ?, MIN_CPU = ?, MEMORY_SIZE = ?]; (conn=3221488265) invalid MAX_CPU value, min value is 1; nested exception is java.sql.SQLTransientConnectionException: (conn=3221488265) invalid MAX_CPU value, min value is 1] 2024-02-04 16:31:45.336 INFO 3317586 --- [pool-manual-subtask-executor16,bb208161c5e647f6,bc1f3e0dea6e] c.o.ocp.obsdk.connector.ConnectTemplate : Last Trace Info:[YB420A000183-00061088F69D853F-0-0] 2024-02-04 16:31:45.343 ERROR 3317586 --- [pool-manual-subtask-executor16,bb208161c5e647f6,bc1f3e0dea6e] c.o.o.c.t.e.c.w.subtask.SubtaskExecutor : invalid MAX_CPU value, min value is 1 java.sql.SQLException: invalid MAX_CPU value, min value is 1 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:265) at com.oceanbase.ocp.obsdk.operator.resource.MysqlResourceOperator.createUnitConfig(MysqlResourceOperator.java:229) at com.oceanbase.ocp.obops.internal.tenant.ResourcePoolServiceImpl.baseModifyResourcePool(ResourcePoolServiceImpl.java:414) at com.oceanbase.ocp.obops.internal.tenant.ResourcePoolServiceImpl.modifyResourcePool(ResourcePoolServiceImpl.java:384) at com.oceanbase.ocp.obops.internal.tenant. task.AlterResourcePoolUnitSpecTask.run(AlterResourcePoolUnitSpecTask.java:44) at com.oceanbase.ocp.core.task.engine.runner.JavaSubtaskRunner.execute(JavaSubtaskRunner.java:59) at com.oceanbase.ocp.core.task.engine.runner.JavaSubtaskRunner.doRun(JavaSubtaskRunner.java:31) at com.oceanbase.ocp.core.task.engine.runner.JavaSubtaskRunner.run(JavaSubtaskRunner.java:25) 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:193) at com.oceanbase.ocp.core.task.engine.coordinator.worker.subtask.SubtaskExecutor.redirectConsoleOutput(SubtaskExecutor.java:187) at com.oceanbase.ocp.core.task.engine.coordinator.worker.subtask.SubtaskExecutor.lambda$submit$2(SubtaskExecutor.java:124) 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: 836, operation:EXECUTE, state: FAILED