2023-12-21 09:36:00.461 INFO 228566 --- [pool-ocp-schedules-16,,] c.o.o.b.spring.BootstrapRunListener : contextPrepared 2023-12-21 09:36:00.461 INFO 228566 --- [pool-ocp-schedules-16,,] c.o.o.b.spring.BootstrapRunListener : register bean ProgressHandler 2023-12-21 09:36:00.461 INFO 228566 --- [pool-ocp-schedules-16,,] o.s.boot.SpringApplication : The following 2 profiles are active: "composite", "default" 2023-12-21 09:36:00.463 INFO 228566 --- [pool-subtask-coordinator2,,] c.o.ocp.task.dao.SubtaskAccessor : Set state for subtask: 1000649, operation:EXECUTE, state: RUNNING 2023-12-21 09:36:00.481 INFO 228566 --- [pool-subtask-coordinator2,,] c.o.o.t.e.c.w.s.ReadySubtaskWorker : Submit ready task, entity=SubtaskInstanceOverview{id=1000649, name=Collect all tenants mini compactions, state=RUNNING, operation=EXECUTE, className=com.oceanbase.ocp.obops.internal.tenant.task.CollectAllTenantCompactionTask, seriesId=0, startTime=2023-12-21T09:36:00.456+08:00, endTime=null} 2023-12-21 09:36:00.486 INFO 228566 --- [pool-ocp-schedules-16,,] c.o.o.b.spring.BootstrapRunListener : contextLoaded 2023-12-21 09:36:00.491 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,c78da67a09d4] c.o.o.t.engine.runner.JavaSubtaskRunner : Run subtask, id=1000649, context=Context{parallelIdx=-1, stringMap={prohibit_rollback=false, task_instance_id=1000649, task_operation=execute, latest_execution_start_time=2023-12-21T09:36:00.455+08:00, sub_task_instance_id=1000649}, listMap={}}, executor=10.253.208.63 2023-12-21 09:36:00.491 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,c78da67a09d4] o.o.i.t.t.CollectAllTenantCompactionTask : Begin to collect all tenants major compaction info 2023-12-21 09:36:00.496 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,c78da67a09d4] o.i.t.TenantCompactionCollectServiceImpl : Begin to collect major compaction info for tenant:sys 2023-12-21 09:36:00.497 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,c78da67a09d4] c.o.o.c.obsdk.ConnectPropertiesBuilder : build connect address for sys tenant, obServerAddrList=[ObServerAddr(address=10.253.208.65, port=2881), ObServerAddr(address=10.253.208.67, port=2881), ObServerAddr(address=10.253.208.172, port=2881)] 2023-12-21 09:36:00.498 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,c78da67a09d4] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:36:00.498 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,c78da67a09d4] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:36:00.498 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,c78da67a09d4] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:36:00.499 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,c78da67a09d4] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select max(value) value from oceanbase.__all_virtual_sys_parameter_stat where name = 'min_observer_version' 2023-12-21 09:36:00.506 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,c78da67a09d4] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:36:00.506 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,c78da67a09d4] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:36:00.507 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,c78da67a09d4] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT tenant_id, global_broadcast_scn AS broadcast_scn, is_error AS error, status, frozen_scn, last_scn, is_suspended AS suspend, info, start_time, last_finish_time FROM CDB_OB_MAJOR_COMPACTION WHERE tenant_id = ?, args: [1] 2023-12-21 09:36:00.508 INFO 228566 --- [pool-ocp-schedules-16,,] o.s.boot.SpringApplication : Started application in 0.504 seconds (JVM running for 77738.84) 2023-12-21 09:36:00.508 INFO 228566 --- [pool-ocp-schedules-16,,] c.o.o.b.spring.BootstrapRunListener : started 2023-12-21 09:36:00.509 INFO 228566 --- [pool-ocp-schedules-16,,] c.o.o.b.spring.BootstrapRunListener : Ready, timeTaken=PT0.504484108S 2023-12-21 09:36:00.512 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,c78da67a09d4] o.i.t.TenantCompactionCollectServiceImpl : current compaction frozen scn:1703095202917758401, broadcast scn:1703095202917758401, saved frozen scn:1703095202917758401 2023-12-21 09:36:00.514 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,c78da67a09d4] o.i.t.TenantCompactionCollectServiceImpl : Finish to collect major compaction info for tenant:sys 2023-12-21 09:36:00.523 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,c78da67a09d4] o.i.t.TenantCompactionCollectServiceImpl : Begin to collect major compaction info for tenant:ocp_mate 2023-12-21 09:36:00.523 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,c78da67a09d4] c.o.o.c.obsdk.ConnectPropertiesBuilder : get credential from obsdk context, clusterName=obcluster, tenantName=sys, dbUser=root 2023-12-21 09:36:00.523 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,c78da67a09d4] c.o.o.c.obsdk.ConnectPropertiesBuilder : build connect address for sys tenant, obServerAddrList=[ObServerAddr(address=10.253.208.65, port=2881), ObServerAddr(address=10.253.208.67, port=2881), ObServerAddr(address=10.253.208.172, port=2881)] 2023-12-21 09:36:00.524 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,c78da67a09d4] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:36:00.525 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,c78da67a09d4] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:36:00.525 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,c78da67a09d4] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:36:00.525 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,c78da67a09d4] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select max(value) value from oceanbase.__all_virtual_sys_parameter_stat where name = 'min_observer_version' 2023-12-21 09:36:00.530 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,c78da67a09d4] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:36:00.530 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,c78da67a09d4] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:36:00.530 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,c78da67a09d4] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT tenant_id, global_broadcast_scn AS broadcast_scn, is_error AS error, status, frozen_scn, last_scn, is_suspended AS suspend, info, start_time, last_finish_time FROM CDB_OB_MAJOR_COMPACTION WHERE tenant_id = ?, args: [1002] 2023-12-21 09:36:00.533 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,c78da67a09d4] o.i.t.TenantCompactionCollectServiceImpl : current compaction frozen scn:1703095201688828412, broadcast scn:1703095201688828412, saved frozen scn:1703095201688828412 2023-12-21 09:36:00.533 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,c78da67a09d4] o.i.t.TenantCompactionCollectServiceImpl : Finish to collect major compaction info for tenant:ocp_mate 2023-12-21 09:36:00.538 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,c78da67a09d4] o.o.i.t.t.CollectAllTenantCompactionTask : Finish to collect all tenants major compaction info 2023-12-21 09:36:00.551 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,c78da67a09d4] c.o.ocp.task.dao.SubtaskAccessor : Set state for subtask: 1000649, operation:EXECUTE, state: SUCCESSFUL 2023-12-21 09:36:00.605 INFO 228566 --- [pool-ocp-schedules-16,,] c.o.o.b.spring.DataSourceInterceptor : dataSource dataSource already initialized. skipped 2023-12-21 09:36:00.643 INFO 228566 --- [pool-ocp-schedules-16,,] c.o.ocp.core.property.PropertyService : Refresh config properties done 2023-12-21 09:36:13.988 ERROR 228566 --- [pool-metric-archive-second-7,,] c.o.o.m.storage.RollupMetricDataDao : Archive node list to table metric_data_second error, e = PreparedStatementCallback; uncategorized SQLException for SQL [INSERT INTO `metric_data_second` (`series_id`, `timestamp`, `data`, `interval`) VALUES (?, ?, ?, ?)]; SQL state [HY000]; error code [1526]; (conn=3670022) Table has no partition for value; nested exception is java.sql.BatchUpdateException: (conn=3670022) Table has no partition for value 2023-12-21 09:36:13.997 ERROR 228566 --- [pool-metric-archive-second-7,,] c.o.o.m.service.OcpMetricArchiveService : Archive second nodes failed. org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [REPLACE INTO `metric_data_second` (`series_id`, `timestamp`, `data`, `interval`) VALUES (?, ?, ?, ?)]; SQL state [HY000]; error code [1526]; (conn=3670022) Table has no partition for value; nested exception is java.sql.BatchUpdateException: (conn=3670022) Table has no partition for value at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1542) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:667) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:691) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1034) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1088) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at com.oceanbase.ocp.monitor.storage.RollupMetricDataDao.write(RollupMetricDataDao.java:77) ~[ocp-express-monitor-service-4.2.0-20230731.jar!/:4.2.0-20230731] at com.oceanbase.ocp.monitor.service.OcpMetricArchiveService.lambda$archiveSecond$1(OcpMetricArchiveService.java:106) ~[ocp-express-monitor-service-4.2.0-20230731.jar!/:4.2.0-20230731] at com.oceanbase.ocp.monitor.meter.MeterUtils.time(MeterUtils.java:64) ~[ocp-express-monitor-service-4.2.0-20230731.jar!/:4.2.0-20230731] at com.oceanbase.ocp.monitor.meter.DistributionSummaryGroup.time(DistributionSummaryGroup.java:110) ~[ocp-express-monitor-service-4.2.0-20230731.jar!/:4.2.0-20230731] at com.oceanbase.ocp.monitor.service.OcpMetricArchiveService.archiveSecond(OcpMetricArchiveService.java:98) ~[ocp-express-monitor-service-4.2.0-20230731.jar!/:4.2.0-20230731] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[na:1.8.0_222] at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) ~[na:1.8.0_222] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) ~[na:1.8.0_222] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) ~[na:1.8.0_222] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_222] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_222] at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_222] Caused by: java.sql.BatchUpdateException: (conn=3670022) Table has no partition for value at com.oceanbase.jdbc.OceanBaseStatement.executeBatchExceptionEpilogue(OceanBaseStatement.java:445) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.OceanBaseStatement.executeBatchExceptionEpilogue(OceanBaseStatement.java:448) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.JDBC4PreparedStatement.executeBatch(JDBC4PreparedStatement.java:315) ~[oceanbase-client-2.4.3.jar!/:na] at com.alibaba.druid.filter.FilterChainImpl.statement_executeBatch(FilterChainImpl.java:3118) ~[druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.filter.FilterAdapter.statement_executeBatch(FilterAdapter.java:2507) ~[druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.filter.FilterEventAdapter.statement_executeBatch(FilterEventAdapter.java:279) ~[druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.filter.FilterChainImpl.statement_executeBatch(FilterChainImpl.java:3116) ~[druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.proxy.jdbc.StatementProxyImpl.executeBatch(StatementProxyImpl.java:202) ~[druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeBatch(DruidPooledPreparedStatement.java:565) ~[druid-1.2.8.jar!/:1.2.8] at org.springframework.jdbc.core.JdbcTemplate.lambda$batchUpdate$4(JdbcTemplate.java:1048) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:651) ~[spring-jdbc-5.3.27.jar!/:5.3.27] ... 15 common frames omitted Caused by: java.sql.SQLTransientConnectionException: (conn=3670022) Table has no partition for value at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:128) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:202) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.OceanBaseStatement.executeBatchExceptionEpilogue(OceanBaseStatement.java:441) ~[oceanbase-client-2.4.3.jar!/:na] ... 25 common frames omitted Caused by: com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException: Table has no partition for value at com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException.of(OceanBaseSqlException.java:79) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchRewrite(AbstractQueryProtocol.java:1171) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchClient(AbstractQueryProtocol.java:656) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.JDBC4PreparedStatement.executeInternalBatch(JDBC4PreparedStatement.java:418) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.JDBC4PreparedStatement.executeBatch(JDBC4PreparedStatement.java:310) ~[oceanbase-client-2.4.3.jar!/:na] ... 23 common frames omitted Caused by: java.sql.SQLException: Table has no partition for value at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:2192) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:2057) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1951) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchRewrite(AbstractQueryProtocol.java:1163) ~[oceanbase-client-2.4.3.jar!/:na] ... 26 common frames omitted 2023-12-21 09:36:13.999 ERROR 228566 --- [pool-metric-archive-second-7,,] c.o.o.m.storage.RollupMetricDataDao : Archive node list to table metric_data_second error, e = PreparedStatementCallback; uncategorized SQLException for SQL [INSERT INTO `metric_data_second` (`series_id`, `timestamp`, `data`, `interval`) VALUES (?, ?, ?, ?)]; SQL state [HY000]; error code [1526]; (conn=3670022) Table has no partition for value; nested exception is java.sql.BatchUpdateException: (conn=3670022) Table has no partition for value 2023-12-21 09:36:14.002 ERROR 228566 --- [pool-metric-archive-second-7,,] c.o.o.m.service.OcpMetricArchiveService : Archive second nodes failed. org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [REPLACE INTO `metric_data_second` (`series_id`, `timestamp`, `data`, `interval`) VALUES (?, ?, ?, ?)]; SQL state [HY000]; error code [1526]; (conn=3670022) Table has no partition for value; nested exception is java.sql.BatchUpdateException: (conn=3670022) Table has no partition for value at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1542) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:667) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:691) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1034) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1088) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at com.oceanbase.ocp.monitor.storage.RollupMetricDataDao.write(RollupMetricDataDao.java:77) ~[ocp-express-monitor-service-4.2.0-20230731.jar!/:4.2.0-20230731] at com.oceanbase.ocp.monitor.service.OcpMetricArchiveService.lambda$archiveSecond$1(OcpMetricArchiveService.java:106) ~[ocp-express-monitor-service-4.2.0-20230731.jar!/:4.2.0-20230731] at com.oceanbase.ocp.monitor.meter.MeterUtils.time(MeterUtils.java:64) ~[ocp-express-monitor-service-4.2.0-20230731.jar!/:4.2.0-20230731] at com.oceanbase.ocp.monitor.meter.DistributionSummaryGroup.time(DistributionSummaryGroup.java:110) ~[ocp-express-monitor-service-4.2.0-20230731.jar!/:4.2.0-20230731] at com.oceanbase.ocp.monitor.service.OcpMetricArchiveService.archiveSecond(OcpMetricArchiveService.java:98) ~[ocp-express-monitor-service-4.2.0-20230731.jar!/:4.2.0-20230731] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[na:1.8.0_222] at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) ~[na:1.8.0_222] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) ~[na:1.8.0_222] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) ~[na:1.8.0_222] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_222] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_222] at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_222] Caused by: java.sql.BatchUpdateException: (conn=3670022) Table has no partition for value at com.oceanbase.jdbc.OceanBaseStatement.executeBatchExceptionEpilogue(OceanBaseStatement.java:445) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.OceanBaseStatement.executeBatchExceptionEpilogue(OceanBaseStatement.java:448) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.JDBC4PreparedStatement.executeBatch(JDBC4PreparedStatement.java:315) ~[oceanbase-client-2.4.3.jar!/:na] at com.alibaba.druid.filter.FilterChainImpl.statement_executeBatch(FilterChainImpl.java:3118) ~[druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.filter.FilterAdapter.statement_executeBatch(FilterAdapter.java:2507) ~[druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.filter.FilterEventAdapter.statement_executeBatch(FilterEventAdapter.java:279) ~[druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.filter.FilterChainImpl.statement_executeBatch(FilterChainImpl.java:3116) ~[druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.proxy.jdbc.StatementProxyImpl.executeBatch(StatementProxyImpl.java:202) ~[druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeBatch(DruidPooledPreparedStatement.java:565) ~[druid-1.2.8.jar!/:1.2.8] at org.springframework.jdbc.core.JdbcTemplate.lambda$batchUpdate$4(JdbcTemplate.java:1048) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:651) ~[spring-jdbc-5.3.27.jar!/:5.3.27] ... 15 common frames omitted Caused by: java.sql.SQLTransientConnectionException: (conn=3670022) Table has no partition for value at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:128) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:202) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.OceanBaseStatement.executeBatchExceptionEpilogue(OceanBaseStatement.java:441) ~[oceanbase-client-2.4.3.jar!/:na] ... 25 common frames omitted Caused by: com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException: Table has no partition for value at com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException.of(OceanBaseSqlException.java:79) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchRewrite(AbstractQueryProtocol.java:1171) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchClient(AbstractQueryProtocol.java:656) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.JDBC4PreparedStatement.executeInternalBatch(JDBC4PreparedStatement.java:418) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.JDBC4PreparedStatement.executeBatch(JDBC4PreparedStatement.java:310) ~[oceanbase-client-2.4.3.jar!/:na] ... 23 common frames omitted Caused by: java.sql.SQLException: Table has no partition for value at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:2192) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:2057) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1951) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchRewrite(AbstractQueryProtocol.java:1163) ~[oceanbase-client-2.4.3.jar!/:na] ... 26 common frames omitted 2023-12-21 09:36:27.251 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.o.c.obsdk.ConnectPropertiesBuilder : build connect address for sys tenant, obServerAddrList=[ObServerAddr(address=10.253.208.65, port=2881), ObServerAddr(address=10.253.208.67, port=2881), ObServerAddr(address=10.253.208.172, port=2881)] 2023-12-21 09:36:27.252 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:36:27.253 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:36:27.253 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:36:27.253 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select max(value) value from oceanbase.__all_virtual_sys_parameter_stat where name = 'min_observer_version' 2023-12-21 09:36:27.257 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:36:27.257 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:36:27.258 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select max(value) value from oceanbase.__all_virtual_sys_parameter_stat where name = 'min_observer_version' 2023-12-21 09:36:27.263 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:36:27.263 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:36:27.264 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT `zone`, `status`, `region`, `idc` FROM `DBA_OB_ZONES` 2023-12-21 09:36:27.266 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:36:27.267 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:36:27.267 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] 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, id FROM DBA_OB_SERVERS ORDER BY zone ASC, id ASC 2023-12-21 09:36:27.268 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:36:27.268 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:36:27.269 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT `svr_ip`, `svr_port`, `zone`, `role` FROM `CDB_OB_LS_LOCATIONS` WHERE `tenant_id` = 1 AND `ls_id` = 1 2023-12-21 09:36:27.270 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:36:27.270 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:36:27.270 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select version() REGEXP 'OceanBase[\s_]CE' 2023-12-21 09:36:27.270 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.o.o.i.c.ClusterInitServiceImpl : sync cluster info done 2023-12-21 09:36:27.274 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.o.c.obsdk.ConnectPropertiesBuilder : get credential from obsdk context, clusterName=obcluster, tenantName=sys, dbUser=root 2023-12-21 09:36:27.274 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.o.c.obsdk.ConnectPropertiesBuilder : build connect address for sys tenant, obServerAddrList=[ObServerAddr(address=10.253.208.65, port=2881), ObServerAddr(address=10.253.208.67, port=2881), ObServerAddr(address=10.253.208.172, port=2881)] 2023-12-21 09:36:27.274 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:36:27.275 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:36:27.275 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:36:27.275 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select max(value) value from oceanbase.__all_virtual_sys_parameter_stat where name = 'min_observer_version' 2023-12-21 09:36:27.281 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:36:27.281 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:36:27.281 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT TENANT_ID, TENANT_NAME, TENANT_TYPE, PRIMARY_ZONE, LOCALITY, COMPATIBILITY_MODE, STATUS, IN_RECYCLEBIN, (CASE WHEN LOCKED = 'YES' THEN 1 ELSE 0 END) AS LOCKED, TIMESTAMPDIFF(SECOND, CREATE_TIME, now()) AS exist_seconds FROM oceanbase.DBA_OB_TENANTS WHERE TENANT_TYPE IN ('SYS', 'USER') 2023-12-21 09:36:27.286 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:36:27.286 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:36:27.286 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT TENANT_ID, NAME, VALUE FROM oceanbase.CDB_OB_SYS_VARIABLES WHERE TENANT_ID = ?, args: [1] 2023-12-21 09:36:27.290 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:36:27.290 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:36:27.290 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT TENANT_ID, NAME, VALUE FROM oceanbase.CDB_OB_SYS_VARIABLES WHERE TENANT_ID = ?, args: [1] 2023-12-21 09:36:27.293 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:36:27.293 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:36:27.293 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT TENANT_ID, NAME, VALUE FROM oceanbase.CDB_OB_SYS_VARIABLES WHERE TENANT_ID = ?, args: [1002] 2023-12-21 09:36:27.296 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:36:27.296 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:36:27.297 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT TENANT_ID, NAME, VALUE FROM oceanbase.CDB_OB_SYS_VARIABLES WHERE TENANT_ID = ?, args: [1002] 2023-12-21 09:36:27.300 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.o.c.obsdk.ConnectPropertiesBuilder : get credential from obsdk context, clusterName=obcluster, tenantName=sys, dbUser=root 2023-12-21 09:36:27.300 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.o.c.obsdk.ConnectPropertiesBuilder : build connect address for sys tenant, obServerAddrList=[ObServerAddr(address=10.253.208.65, port=2881), ObServerAddr(address=10.253.208.67, port=2881), ObServerAddr(address=10.253.208.172, port=2881)] 2023-12-21 09:36:27.301 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:36:27.301 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:36:27.301 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:36:27.302 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select max(value) value from oceanbase.__all_virtual_sys_parameter_stat where name = 'min_observer_version' 2023-12-21 09:36:27.307 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:36:27.307 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:36:27.308 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT TENANT_ID, JOB_ID, JOB_TYPE, JOB_STATUS, PROGRESS FROM oceanbase.DBA_OB_TENANT_JOBS WHERE TENANT_ID = ? AND JOB_TYPE = ? ORDER BY JOB_ID DESC LIMIT 1, args: [1, ALTER_TENANT_LOCALITY] 2023-12-21 09:36:27.308 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.o.c.obsdk.ConnectPropertiesBuilder : get credential from obsdk context, clusterName=obcluster, tenantName=sys, dbUser=root 2023-12-21 09:36:27.308 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.o.c.obsdk.ConnectPropertiesBuilder : build connect address for sys tenant, obServerAddrList=[ObServerAddr(address=10.253.208.65, port=2881), ObServerAddr(address=10.253.208.67, port=2881), ObServerAddr(address=10.253.208.172, port=2881)] 2023-12-21 09:36:27.309 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:36:27.309 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:36:27.309 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:36:27.309 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select max(value) value from oceanbase.__all_virtual_sys_parameter_stat where name = 'min_observer_version' 2023-12-21 09:36:27.313 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:36:27.313 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:36:27.313 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT TENANT_ID, JOB_ID, JOB_TYPE, JOB_STATUS, PROGRESS FROM oceanbase.DBA_OB_TENANT_JOBS WHERE TENANT_ID = ? AND JOB_TYPE = ? ORDER BY JOB_ID DESC LIMIT 1, args: [1, SHRINK_RESOURCE_POOL_UNIT_NUM] 2023-12-21 09:36:27.314 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.o.c.obsdk.ConnectPropertiesBuilder : get credential from obsdk context, clusterName=obcluster, tenantName=sys, dbUser=root 2023-12-21 09:36:27.314 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.o.c.obsdk.ConnectPropertiesBuilder : build connect address for sys tenant, obServerAddrList=[ObServerAddr(address=10.253.208.65, port=2881), ObServerAddr(address=10.253.208.67, port=2881), ObServerAddr(address=10.253.208.172, port=2881)] 2023-12-21 09:36:27.315 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:36:27.315 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:36:27.315 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:36:27.315 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select max(value) value from oceanbase.__all_virtual_sys_parameter_stat where name = 'min_observer_version' 2023-12-21 09:36:27.319 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:36:27.319 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:36:27.320 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT TENANT_ID, JOB_ID, JOB_TYPE, JOB_STATUS, PROGRESS FROM oceanbase.DBA_OB_TENANT_JOBS WHERE TENANT_ID = ? AND JOB_TYPE = ? ORDER BY JOB_ID DESC LIMIT 1, args: [1002, ALTER_TENANT_LOCALITY] 2023-12-21 09:36:27.320 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.o.c.obsdk.ConnectPropertiesBuilder : get credential from obsdk context, clusterName=obcluster, tenantName=sys, dbUser=root 2023-12-21 09:36:27.320 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.o.c.obsdk.ConnectPropertiesBuilder : build connect address for sys tenant, obServerAddrList=[ObServerAddr(address=10.253.208.65, port=2881), ObServerAddr(address=10.253.208.67, port=2881), ObServerAddr(address=10.253.208.172, port=2881)] 2023-12-21 09:36:27.320 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:36:27.321 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:36:27.321 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:36:27.321 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select max(value) value from oceanbase.__all_virtual_sys_parameter_stat where name = 'min_observer_version' 2023-12-21 09:36:27.325 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:36:27.325 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:36:27.325 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT TENANT_ID, JOB_ID, JOB_TYPE, JOB_STATUS, PROGRESS FROM oceanbase.DBA_OB_TENANT_JOBS WHERE TENANT_ID = ? AND JOB_TYPE = ? ORDER BY JOB_ID DESC LIMIT 1, args: [1002, SHRINK_RESOURCE_POOL_UNIT_NUM] 2023-12-21 09:36:27.326 INFO 228566 --- [pool-ocp-schedules-7,,f694a72df6d7] c.o.o.o.i.tenant.TenantSyncServiceImpl : Sync all tenant info done 2023-12-21 09:36:44.858 INFO 228566 --- [pool-prometheus-cache-monitor1,,3ae77c2d0192] c.o.o.m.service.OcpCacheStatServiceImpl : OcpCacheMonitor, cacheInfo={"secondReadCacheSize":4036,"minuteWriteQueue":0,"minuteReadCacheSize":4036,"secondWriteCacheSize":1009,"seriesIdKeySize":1277,"secondWriteQueue":0,"minuteWriteCacheSize":1009} 2023-12-21 09:36:44.859 INFO 228566 --- [pool-prometheus-cache-monitor1,,3ae77c2d0192] c.o.o.m.service.OcpCacheStatServiceImpl : MetricSearchStats:{node_disk_read_time_seconds_total=21, ob_server_resource_memory_assigned_bytes=10, ob_active_session_num=14, ob_plan_cache_memory_bytes=16, ob_tenant_assigned_cpu_assigned=14, node_network_transmit_bytes_total=14, node_filesystem_size_bytes=45, ob_system_event_total_waits=20, node_disk_read_bytes_total=21, node_cpu_seconds_total=18, ob_tenant_resource_max_cpu=14, ob_plan_cache_hit_total=16, ob_server_resource_memory_assigned_percent=10, io_await=35, ob_server_resource_cpu=10, ob_server_num=12, ob_all_session_num=14, io_util=35, ob_tenant_resource_min_memory=14, ob_plan_cache_access_total=16, node_disk_reads_completed_total=21, ob_system_event_time_waited=20, ob_sysstat=92, node_disk_writes_completed_total=21, ob_tenant_resource_min_cpu=14, node_ntp_offset_seconds=11, ob_cache_size_bytes=29, node_net_bandwidth_bps=14, ob_tenant_assigned_cpu_total=14, node_load1=10, ob_tenant_disk_log_size=14, ob_server_resource_memory_bytes=10, ob_tenant_resource_max_memory=14, cpu_count=11, node_disk_io_time_weighted_seconds_total=21, node_disk_write_time_seconds_total=21, ob_disk_total_bytes=10, ob_tenant_assigned_mem_assigned=14, node_load15=10, ob_tenant_disk_data_size=14, ob_server_resource_cpu_assigned_percent=10, node_load5=10, node_disk_written_bytes_total=21, node_memory_memfree_bytes=10, process_exists=15, ob_server_resource_disk_bytes=10, node_memory_buffers_bytes=10, ob_tenant_assigned_mem_total=14, node_memory_memtotal_bytes=10, ob_server_resource_cpu_assigned=10, node_network_receive_bytes_total=14, ob_waitevent_wait_seconds_total=14, node_memory_cached_bytes=10, ob_table_num=14, ob_waitevent_wait_total=14, ob_disk_free_bytes=10, oceanbase_connectivity=1, node_filesystem_avail_bytes=45} 2023-12-21 09:36:45.086 INFO 228566 --- [pool-ocp-schedules-15,,e746886896ba] c.o.o.m.service.OcpCacheStatServiceImpl : OcpCacheMonitor, cacheInfo={"secondReadCacheSize":4036,"minuteWriteQueue":0,"minuteReadCacheSize":4036,"secondWriteCacheSize":1009,"seriesIdKeySize":1277,"secondWriteQueue":0,"minuteWriteCacheSize":1009} 2023-12-21 09:36:45.086 INFO 228566 --- [pool-ocp-schedules-15,,e746886896ba] c.o.o.m.service.OcpCacheStatServiceImpl : MetricSearchStats:{node_disk_read_time_seconds_total=21, ob_server_resource_memory_assigned_bytes=10, ob_active_session_num=14, ob_plan_cache_memory_bytes=16, ob_tenant_assigned_cpu_assigned=14, node_network_transmit_bytes_total=14, node_filesystem_size_bytes=45, ob_system_event_total_waits=20, node_disk_read_bytes_total=21, node_cpu_seconds_total=18, ob_tenant_resource_max_cpu=14, ob_plan_cache_hit_total=16, ob_server_resource_memory_assigned_percent=10, io_await=35, ob_server_resource_cpu=10, ob_server_num=12, ob_all_session_num=14, io_util=35, ob_tenant_resource_min_memory=14, ob_plan_cache_access_total=16, node_disk_reads_completed_total=21, ob_system_event_time_waited=20, ob_sysstat=92, node_disk_writes_completed_total=21, ob_tenant_resource_min_cpu=14, node_ntp_offset_seconds=11, ob_cache_size_bytes=29, node_net_bandwidth_bps=14, ob_tenant_assigned_cpu_total=14, node_load1=10, ob_tenant_disk_log_size=14, ob_server_resource_memory_bytes=10, ob_tenant_resource_max_memory=14, cpu_count=11, node_disk_io_time_weighted_seconds_total=21, node_disk_write_time_seconds_total=21, ob_disk_total_bytes=10, ob_tenant_assigned_mem_assigned=14, node_load15=10, ob_tenant_disk_data_size=14, ob_server_resource_cpu_assigned_percent=10, node_load5=10, node_disk_written_bytes_total=21, node_memory_memfree_bytes=10, process_exists=15, ob_server_resource_disk_bytes=10, node_memory_buffers_bytes=10, ob_tenant_assigned_mem_total=14, node_memory_memtotal_bytes=10, ob_server_resource_cpu_assigned=10, node_network_receive_bytes_total=14, ob_waitevent_wait_seconds_total=14, node_memory_cached_bytes=10, ob_table_num=14, ob_waitevent_wait_total=14, ob_disk_free_bytes=10, oceanbase_connectivity=1, node_filesystem_avail_bytes=45} 2023-12-21 09:36:45.859 INFO 228566 --- [pool-prometheus-second-schedule-1,,86d0cbfa3ae5] c.o.ocp.monitor.OcpMonitorManager : create pull exporter, exporterCount=9, collectTaskCount=9 2023-12-21 09:36:48.023 INFO 228566 --- [pool-ocp-schedules-13,,2d51d748fd74] c.o.o.m.service.SeriesIdKeyService : Sync series key and id, currentMaxSeriesId=594148003927941120 2023-12-21 09:37:14.015 ERROR 228566 --- [pool-metric-archive-second-4,,] c.o.o.m.storage.RollupMetricDataDao : Archive node list to table metric_data_second error, e = PreparedStatementCallback; uncategorized SQLException for SQL [INSERT INTO `metric_data_second` (`series_id`, `timestamp`, `data`, `interval`) VALUES (?, ?, ?, ?)]; SQL state [HY000]; error code [1526]; (conn=2622139) Table has no partition for value; nested exception is java.sql.BatchUpdateException: (conn=2622139) Table has no partition for value 2023-12-21 09:37:14.025 ERROR 228566 --- [pool-metric-archive-second-4,,] c.o.o.m.service.OcpMetricArchiveService : Archive second nodes failed. org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [REPLACE INTO `metric_data_second` (`series_id`, `timestamp`, `data`, `interval`) VALUES (?, ?, ?, ?)]; SQL state [HY000]; error code [1526]; (conn=2622139) Table has no partition for value; nested exception is java.sql.BatchUpdateException: (conn=2622139) Table has no partition for value at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1542) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:667) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:691) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1034) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1088) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at com.oceanbase.ocp.monitor.storage.RollupMetricDataDao.write(RollupMetricDataDao.java:77) ~[ocp-express-monitor-service-4.2.0-20230731.jar!/:4.2.0-20230731] at com.oceanbase.ocp.monitor.service.OcpMetricArchiveService.lambda$archiveSecond$1(OcpMetricArchiveService.java:106) ~[ocp-express-monitor-service-4.2.0-20230731.jar!/:4.2.0-20230731] at com.oceanbase.ocp.monitor.meter.MeterUtils.time(MeterUtils.java:64) ~[ocp-express-monitor-service-4.2.0-20230731.jar!/:4.2.0-20230731] at com.oceanbase.ocp.monitor.meter.DistributionSummaryGroup.time(DistributionSummaryGroup.java:110) ~[ocp-express-monitor-service-4.2.0-20230731.jar!/:4.2.0-20230731] at com.oceanbase.ocp.monitor.service.OcpMetricArchiveService.archiveSecond(OcpMetricArchiveService.java:98) ~[ocp-express-monitor-service-4.2.0-20230731.jar!/:4.2.0-20230731] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[na:1.8.0_222] at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) ~[na:1.8.0_222] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) ~[na:1.8.0_222] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) ~[na:1.8.0_222] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_222] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_222] at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_222] Caused by: java.sql.BatchUpdateException: (conn=2622139) Table has no partition for value at com.oceanbase.jdbc.OceanBaseStatement.executeBatchExceptionEpilogue(OceanBaseStatement.java:445) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.OceanBaseStatement.executeBatchExceptionEpilogue(OceanBaseStatement.java:448) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.JDBC4PreparedStatement.executeBatch(JDBC4PreparedStatement.java:315) ~[oceanbase-client-2.4.3.jar!/:na] at com.alibaba.druid.filter.FilterChainImpl.statement_executeBatch(FilterChainImpl.java:3118) ~[druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.filter.FilterAdapter.statement_executeBatch(FilterAdapter.java:2507) ~[druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.filter.FilterEventAdapter.statement_executeBatch(FilterEventAdapter.java:279) ~[druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.filter.FilterChainImpl.statement_executeBatch(FilterChainImpl.java:3116) ~[druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.proxy.jdbc.StatementProxyImpl.executeBatch(StatementProxyImpl.java:202) ~[druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeBatch(DruidPooledPreparedStatement.java:565) ~[druid-1.2.8.jar!/:1.2.8] at org.springframework.jdbc.core.JdbcTemplate.lambda$batchUpdate$4(JdbcTemplate.java:1048) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:651) ~[spring-jdbc-5.3.27.jar!/:5.3.27] ... 15 common frames omitted Caused by: java.sql.SQLTransientConnectionException: (conn=2622139) Table has no partition for value at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:128) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:202) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.OceanBaseStatement.executeBatchExceptionEpilogue(OceanBaseStatement.java:441) ~[oceanbase-client-2.4.3.jar!/:na] ... 25 common frames omitted Caused by: com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException: Table has no partition for value at com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException.of(OceanBaseSqlException.java:79) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchRewrite(AbstractQueryProtocol.java:1171) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchClient(AbstractQueryProtocol.java:656) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.JDBC4PreparedStatement.executeInternalBatch(JDBC4PreparedStatement.java:418) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.JDBC4PreparedStatement.executeBatch(JDBC4PreparedStatement.java:310) ~[oceanbase-client-2.4.3.jar!/:na] ... 23 common frames omitted Caused by: java.sql.SQLException: Table has no partition for value at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:2192) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:2057) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1951) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchRewrite(AbstractQueryProtocol.java:1163) ~[oceanbase-client-2.4.3.jar!/:na] ... 26 common frames omitted 2023-12-21 09:37:14.027 ERROR 228566 --- [pool-metric-archive-second-4,,] c.o.o.m.storage.RollupMetricDataDao : Archive node list to table metric_data_second error, e = PreparedStatementCallback; uncategorized SQLException for SQL [INSERT INTO `metric_data_second` (`series_id`, `timestamp`, `data`, `interval`) VALUES (?, ?, ?, ?)]; SQL state [HY000]; error code [1526]; (conn=2622139) Table has no partition for value; nested exception is java.sql.BatchUpdateException: (conn=2622139) Table has no partition for value 2023-12-21 09:37:14.028 ERROR 228566 --- [pool-metric-archive-second-4,,] c.o.o.m.service.OcpMetricArchiveService : Archive second nodes failed. org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [REPLACE INTO `metric_data_second` (`series_id`, `timestamp`, `data`, `interval`) VALUES (?, ?, ?, ?)]; SQL state [HY000]; error code [1526]; (conn=2622139) Table has no partition for value; nested exception is java.sql.BatchUpdateException: (conn=2622139) Table has no partition for value at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1542) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:667) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:691) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1034) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1088) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at com.oceanbase.ocp.monitor.storage.RollupMetricDataDao.write(RollupMetricDataDao.java:77) ~[ocp-express-monitor-service-4.2.0-20230731.jar!/:4.2.0-20230731] at com.oceanbase.ocp.monitor.service.OcpMetricArchiveService.lambda$archiveSecond$1(OcpMetricArchiveService.java:106) ~[ocp-express-monitor-service-4.2.0-20230731.jar!/:4.2.0-20230731] at com.oceanbase.ocp.monitor.meter.MeterUtils.time(MeterUtils.java:64) ~[ocp-express-monitor-service-4.2.0-20230731.jar!/:4.2.0-20230731] at com.oceanbase.ocp.monitor.meter.DistributionSummaryGroup.time(DistributionSummaryGroup.java:110) ~[ocp-express-monitor-service-4.2.0-20230731.jar!/:4.2.0-20230731] at com.oceanbase.ocp.monitor.service.OcpMetricArchiveService.archiveSecond(OcpMetricArchiveService.java:98) ~[ocp-express-monitor-service-4.2.0-20230731.jar!/:4.2.0-20230731] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[na:1.8.0_222] at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) ~[na:1.8.0_222] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) ~[na:1.8.0_222] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) ~[na:1.8.0_222] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_222] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_222] at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_222] Caused by: java.sql.BatchUpdateException: (conn=2622139) Table has no partition for value at com.oceanbase.jdbc.OceanBaseStatement.executeBatchExceptionEpilogue(OceanBaseStatement.java:445) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.OceanBaseStatement.executeBatchExceptionEpilogue(OceanBaseStatement.java:448) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.JDBC4PreparedStatement.executeBatch(JDBC4PreparedStatement.java:315) ~[oceanbase-client-2.4.3.jar!/:na] at com.alibaba.druid.filter.FilterChainImpl.statement_executeBatch(FilterChainImpl.java:3118) ~[druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.filter.FilterAdapter.statement_executeBatch(FilterAdapter.java:2507) ~[druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.filter.FilterEventAdapter.statement_executeBatch(FilterEventAdapter.java:279) ~[druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.filter.FilterChainImpl.statement_executeBatch(FilterChainImpl.java:3116) ~[druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.proxy.jdbc.StatementProxyImpl.executeBatch(StatementProxyImpl.java:202) ~[druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeBatch(DruidPooledPreparedStatement.java:565) ~[druid-1.2.8.jar!/:1.2.8] at org.springframework.jdbc.core.JdbcTemplate.lambda$batchUpdate$4(JdbcTemplate.java:1048) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:651) ~[spring-jdbc-5.3.27.jar!/:5.3.27] ... 15 common frames omitted Caused by: java.sql.SQLTransientConnectionException: (conn=2622139) Table has no partition for value at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:128) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:202) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.OceanBaseStatement.executeBatchExceptionEpilogue(OceanBaseStatement.java:441) ~[oceanbase-client-2.4.3.jar!/:na] ... 25 common frames omitted Caused by: com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException: Table has no partition for value at com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException.of(OceanBaseSqlException.java:79) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchRewrite(AbstractQueryProtocol.java:1171) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchClient(AbstractQueryProtocol.java:656) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.JDBC4PreparedStatement.executeInternalBatch(JDBC4PreparedStatement.java:418) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.JDBC4PreparedStatement.executeBatch(JDBC4PreparedStatement.java:310) ~[oceanbase-client-2.4.3.jar!/:na] ... 23 common frames omitted Caused by: java.sql.SQLException: Table has no partition for value at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:2192) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:2057) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1951) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchRewrite(AbstractQueryProtocol.java:1163) ~[oceanbase-client-2.4.3.jar!/:na] ... 26 common frames omitted 2023-12-21 09:37:27.326 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.o.c.obsdk.ConnectPropertiesBuilder : get credential from obsdk context, clusterName=obcluster, tenantName=sys, dbUser=root 2023-12-21 09:37:27.326 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.o.c.obsdk.ConnectPropertiesBuilder : build connect address for sys tenant, obServerAddrList=[ObServerAddr(address=10.253.208.65, port=2881), ObServerAddr(address=10.253.208.67, port=2881), ObServerAddr(address=10.253.208.172, port=2881)] 2023-12-21 09:37:27.327 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:37:27.328 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:37:27.328 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:37:27.328 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select max(value) value from oceanbase.__all_virtual_sys_parameter_stat where name = 'min_observer_version' 2023-12-21 09:37:27.332 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:37:27.332 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:37:27.333 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select max(value) value from oceanbase.__all_virtual_sys_parameter_stat where name = 'min_observer_version' 2023-12-21 09:37:27.337 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:37:27.337 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:37:27.337 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT `zone`, `status`, `region`, `idc` FROM `DBA_OB_ZONES` 2023-12-21 09:37:27.338 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:37:27.338 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:37:27.339 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] 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, id FROM DBA_OB_SERVERS ORDER BY zone ASC, id ASC 2023-12-21 09:37:27.341 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:37:27.341 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:37:27.341 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT `svr_ip`, `svr_port`, `zone`, `role` FROM `CDB_OB_LS_LOCATIONS` WHERE `tenant_id` = 1 AND `ls_id` = 1 2023-12-21 09:37:27.342 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:37:27.342 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:37:27.343 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select version() REGEXP 'OceanBase[\s_]CE' 2023-12-21 09:37:27.343 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.o.o.i.c.ClusterInitServiceImpl : sync cluster info done 2023-12-21 09:37:27.347 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.o.c.obsdk.ConnectPropertiesBuilder : get credential from obsdk context, clusterName=obcluster, tenantName=sys, dbUser=root 2023-12-21 09:37:27.347 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.o.c.obsdk.ConnectPropertiesBuilder : build connect address for sys tenant, obServerAddrList=[ObServerAddr(address=10.253.208.65, port=2881), ObServerAddr(address=10.253.208.67, port=2881), ObServerAddr(address=10.253.208.172, port=2881)] 2023-12-21 09:37:27.348 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:37:27.348 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:37:27.348 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:37:27.349 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select max(value) value from oceanbase.__all_virtual_sys_parameter_stat where name = 'min_observer_version' 2023-12-21 09:37:27.352 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:37:27.352 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:37:27.353 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT TENANT_ID, TENANT_NAME, TENANT_TYPE, PRIMARY_ZONE, LOCALITY, COMPATIBILITY_MODE, STATUS, IN_RECYCLEBIN, (CASE WHEN LOCKED = 'YES' THEN 1 ELSE 0 END) AS LOCKED, TIMESTAMPDIFF(SECOND, CREATE_TIME, now()) AS exist_seconds FROM oceanbase.DBA_OB_TENANTS WHERE TENANT_TYPE IN ('SYS', 'USER') 2023-12-21 09:37:27.355 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:37:27.355 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:37:27.356 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT TENANT_ID, NAME, VALUE FROM oceanbase.CDB_OB_SYS_VARIABLES WHERE TENANT_ID = ?, args: [1] 2023-12-21 09:37:27.359 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:37:27.359 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:37:27.359 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT TENANT_ID, NAME, VALUE FROM oceanbase.CDB_OB_SYS_VARIABLES WHERE TENANT_ID = ?, args: [1] 2023-12-21 09:37:27.363 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:37:27.363 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:37:27.364 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT TENANT_ID, NAME, VALUE FROM oceanbase.CDB_OB_SYS_VARIABLES WHERE TENANT_ID = ?, args: [1002] 2023-12-21 09:37:27.367 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:37:27.367 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:37:27.368 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT TENANT_ID, NAME, VALUE FROM oceanbase.CDB_OB_SYS_VARIABLES WHERE TENANT_ID = ?, args: [1002] 2023-12-21 09:37:27.372 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.o.c.obsdk.ConnectPropertiesBuilder : get credential from obsdk context, clusterName=obcluster, tenantName=sys, dbUser=root 2023-12-21 09:37:27.372 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.o.c.obsdk.ConnectPropertiesBuilder : build connect address for sys tenant, obServerAddrList=[ObServerAddr(address=10.253.208.65, port=2881), ObServerAddr(address=10.253.208.67, port=2881), ObServerAddr(address=10.253.208.172, port=2881)] 2023-12-21 09:37:27.372 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:37:27.373 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:37:27.373 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:37:27.373 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select max(value) value from oceanbase.__all_virtual_sys_parameter_stat where name = 'min_observer_version' 2023-12-21 09:37:27.377 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:37:27.377 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:37:27.378 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT TENANT_ID, JOB_ID, JOB_TYPE, JOB_STATUS, PROGRESS FROM oceanbase.DBA_OB_TENANT_JOBS WHERE TENANT_ID = ? AND JOB_TYPE = ? ORDER BY JOB_ID DESC LIMIT 1, args: [1, ALTER_TENANT_LOCALITY] 2023-12-21 09:37:27.378 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.o.c.obsdk.ConnectPropertiesBuilder : get credential from obsdk context, clusterName=obcluster, tenantName=sys, dbUser=root 2023-12-21 09:37:27.378 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.o.c.obsdk.ConnectPropertiesBuilder : build connect address for sys tenant, obServerAddrList=[ObServerAddr(address=10.253.208.65, port=2881), ObServerAddr(address=10.253.208.67, port=2881), ObServerAddr(address=10.253.208.172, port=2881)] 2023-12-21 09:37:27.378 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:37:27.379 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:37:27.379 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:37:27.379 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select max(value) value from oceanbase.__all_virtual_sys_parameter_stat where name = 'min_observer_version' 2023-12-21 09:37:27.382 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:37:27.382 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:37:27.383 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT TENANT_ID, JOB_ID, JOB_TYPE, JOB_STATUS, PROGRESS FROM oceanbase.DBA_OB_TENANT_JOBS WHERE TENANT_ID = ? AND JOB_TYPE = ? ORDER BY JOB_ID DESC LIMIT 1, args: [1, SHRINK_RESOURCE_POOL_UNIT_NUM] 2023-12-21 09:37:27.384 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.o.c.obsdk.ConnectPropertiesBuilder : get credential from obsdk context, clusterName=obcluster, tenantName=sys, dbUser=root 2023-12-21 09:37:27.384 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.o.c.obsdk.ConnectPropertiesBuilder : build connect address for sys tenant, obServerAddrList=[ObServerAddr(address=10.253.208.65, port=2881), ObServerAddr(address=10.253.208.67, port=2881), ObServerAddr(address=10.253.208.172, port=2881)] 2023-12-21 09:37:27.385 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:37:27.385 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:37:27.385 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:37:27.385 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select max(value) value from oceanbase.__all_virtual_sys_parameter_stat where name = 'min_observer_version' 2023-12-21 09:37:27.389 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:37:27.389 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:37:27.389 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT TENANT_ID, JOB_ID, JOB_TYPE, JOB_STATUS, PROGRESS FROM oceanbase.DBA_OB_TENANT_JOBS WHERE TENANT_ID = ? AND JOB_TYPE = ? ORDER BY JOB_ID DESC LIMIT 1, args: [1002, ALTER_TENANT_LOCALITY] 2023-12-21 09:37:27.389 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.o.c.obsdk.ConnectPropertiesBuilder : get credential from obsdk context, clusterName=obcluster, tenantName=sys, dbUser=root 2023-12-21 09:37:27.389 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.o.c.obsdk.ConnectPropertiesBuilder : build connect address for sys tenant, obServerAddrList=[ObServerAddr(address=10.253.208.65, port=2881), ObServerAddr(address=10.253.208.67, port=2881), ObServerAddr(address=10.253.208.172, port=2881)] 2023-12-21 09:37:27.390 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:37:27.390 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:37:27.390 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:37:27.390 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select max(value) value from oceanbase.__all_virtual_sys_parameter_stat where name = 'min_observer_version' 2023-12-21 09:37:27.393 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:37:27.393 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:37:27.394 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT TENANT_ID, JOB_ID, JOB_TYPE, JOB_STATUS, PROGRESS FROM oceanbase.DBA_OB_TENANT_JOBS WHERE TENANT_ID = ? AND JOB_TYPE = ? ORDER BY JOB_ID DESC LIMIT 1, args: [1002, SHRINK_RESOURCE_POOL_UNIT_NUM] 2023-12-21 09:37:27.394 INFO 228566 --- [pool-ocp-schedules-17,,a2019e7bc684] c.o.o.o.i.tenant.TenantSyncServiceImpl : Sync all tenant info done 2023-12-21 09:37:44.858 INFO 228566 --- [pool-prometheus-cache-monitor1,,f776ff443b18] c.o.o.m.service.OcpCacheStatServiceImpl : OcpCacheMonitor, cacheInfo={"secondReadCacheSize":4036,"minuteWriteQueue":0,"minuteReadCacheSize":4036,"secondWriteCacheSize":1009,"seriesIdKeySize":1277,"secondWriteQueue":0,"minuteWriteCacheSize":1009} 2023-12-21 09:37:44.859 INFO 228566 --- [pool-prometheus-cache-monitor1,,f776ff443b18] c.o.o.m.service.OcpCacheStatServiceImpl : MetricSearchStats:{node_disk_read_time_seconds_total=21, ob_server_resource_memory_assigned_bytes=10, ob_active_session_num=14, ob_plan_cache_memory_bytes=16, ob_tenant_assigned_cpu_assigned=14, node_network_transmit_bytes_total=14, node_filesystem_size_bytes=45, ob_system_event_total_waits=20, node_disk_read_bytes_total=21, node_cpu_seconds_total=18, ob_tenant_resource_max_cpu=14, ob_plan_cache_hit_total=16, ob_server_resource_memory_assigned_percent=10, io_await=35, ob_server_resource_cpu=10, ob_server_num=12, ob_all_session_num=14, io_util=35, ob_tenant_resource_min_memory=14, ob_plan_cache_access_total=16, node_disk_reads_completed_total=21, ob_system_event_time_waited=20, ob_sysstat=92, node_disk_writes_completed_total=21, ob_tenant_resource_min_cpu=14, node_ntp_offset_seconds=11, ob_cache_size_bytes=29, node_net_bandwidth_bps=14, ob_tenant_assigned_cpu_total=14, node_load1=10, ob_tenant_disk_log_size=14, ob_server_resource_memory_bytes=10, ob_tenant_resource_max_memory=14, cpu_count=11, node_disk_io_time_weighted_seconds_total=21, node_disk_write_time_seconds_total=21, ob_disk_total_bytes=10, ob_tenant_assigned_mem_assigned=14, node_load15=10, ob_tenant_disk_data_size=14, ob_server_resource_cpu_assigned_percent=10, node_load5=10, node_disk_written_bytes_total=21, node_memory_memfree_bytes=10, process_exists=15, ob_server_resource_disk_bytes=10, node_memory_buffers_bytes=10, ob_tenant_assigned_mem_total=14, node_memory_memtotal_bytes=10, ob_server_resource_cpu_assigned=10, node_network_receive_bytes_total=14, ob_waitevent_wait_seconds_total=14, node_memory_cached_bytes=10, ob_table_num=14, ob_waitevent_wait_total=14, ob_disk_free_bytes=10, oceanbase_connectivity=1, node_filesystem_avail_bytes=45} 2023-12-21 09:37:45.860 INFO 228566 --- [pool-prometheus-second-schedule-1,,06f42e813208] c.o.ocp.monitor.OcpMonitorManager : create pull exporter, exporterCount=9, collectTaskCount=9 2023-12-21 09:37:48.026 INFO 228566 --- [pool-ocp-schedules-16,,9a610ad0deef] c.o.o.m.service.SeriesIdKeyService : Sync series key and id, currentMaxSeriesId=594148003927941120 2023-12-21 09:38:00.635 INFO 228566 --- [pool-task-coordinator2,eb4d2d816a3143de,7947388686f6] c.o.o.task.engine.util.SpringScheduler : Schedule time arrived, lastRun=2023-12-21 09:36:00.0, nextRun=2023-12-21 09:38:00.0, currentDate=Thu Dec 21 09:38:00 CST 2023 2023-12-21 09:38:00.635 INFO 228566 --- [pool-task-coordinator2,eb4d2d816a3143de,7947388686f6] c.o.o.t.e.c.worker.ReadyTaskWorker : Schedule ready task, entity=TaskDefinitionEntity{id=1, name=Collect all tenants major compactions, templateName=CollectTenantCompactionSchedule, scheduleRule=0 0/2 * * * ?, lastRunTime=2023-12-21 09:36:00.0, nextRunTime=2023-12-21 09:38:00.0} 2023-12-21 09:38:00.636 INFO 228566 --- [pool-task-coordinator2,eb4d2d816a3143de,7947388686f6] c.o.ocp.task.entity.TaskInstanceEntity : generate tasks, templateName=Collect all tenants major compactions, nodeCount=1, taskCount=1 2023-12-21 09:38:00.636 INFO 228566 --- [pool-task-coordinator2,eb4d2d816a3143de,7947388686f6] c.o.o.task.entity.SubtaskInstanceEntity : Set state for subtask: null, current state: PENDING, new state: READY 2023-12-21 09:38:00.636 INFO 228566 --- [pool-task-coordinator2,eb4d2d816a3143de,7947388686f6] c.o.o.t.e.c.worker.ReadyTaskWorker : Save task instance, entity=TaskInstanceEntity{id=null, name=Collect all tenants major compactions, taskDefinitionId=1, state=RUNNING, operation=EXECUTE} 2023-12-21 09:38:00.977 INFO 228566 --- [pool-subtask-coordinator1,,] c.o.ocp.task.dao.SubtaskAccessor : Set state for subtask: 1000650, operation:EXECUTE, state: RUNNING 2023-12-21 09:38:00.982 INFO 228566 --- [pool-subtask-coordinator1,,] c.o.o.t.e.c.w.s.ReadySubtaskWorker : Submit ready task, entity=SubtaskInstanceOverview{id=1000650, name=Collect all tenants mini compactions, state=RUNNING, operation=EXECUTE, className=com.oceanbase.ocp.obops.internal.tenant.task.CollectAllTenantCompactionTask, seriesId=0, startTime=2023-12-21T09:38:00.974+08:00, endTime=null} 2023-12-21 09:38:00.992 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,b350bac99cbc] c.o.o.t.engine.runner.JavaSubtaskRunner : Run subtask, id=1000650, context=Context{parallelIdx=-1, stringMap={prohibit_rollback=false, task_instance_id=1000650, task_operation=execute, latest_execution_start_time=2023-12-21T09:38:00.974+08:00, sub_task_instance_id=1000650}, listMap={}}, executor=10.253.208.63 2023-12-21 09:38:00.992 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,b350bac99cbc] o.o.i.t.t.CollectAllTenantCompactionTask : Begin to collect all tenants major compaction info 2023-12-21 09:38:00.996 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,b350bac99cbc] o.i.t.TenantCompactionCollectServiceImpl : Begin to collect major compaction info for tenant:sys 2023-12-21 09:38:00.997 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,b350bac99cbc] c.o.o.c.obsdk.ConnectPropertiesBuilder : build connect address for sys tenant, obServerAddrList=[ObServerAddr(address=10.253.208.65, port=2881), ObServerAddr(address=10.253.208.67, port=2881), ObServerAddr(address=10.253.208.172, port=2881)] 2023-12-21 09:38:00.998 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,b350bac99cbc] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:38:00.998 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,b350bac99cbc] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:38:00.998 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,b350bac99cbc] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:38:00.999 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,b350bac99cbc] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select max(value) value from oceanbase.__all_virtual_sys_parameter_stat where name = 'min_observer_version' 2023-12-21 09:38:01.006 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,b350bac99cbc] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:38:01.006 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,b350bac99cbc] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:38:01.007 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,b350bac99cbc] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT tenant_id, global_broadcast_scn AS broadcast_scn, is_error AS error, status, frozen_scn, last_scn, is_suspended AS suspend, info, start_time, last_finish_time FROM CDB_OB_MAJOR_COMPACTION WHERE tenant_id = ?, args: [1] 2023-12-21 09:38:01.009 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,b350bac99cbc] o.i.t.TenantCompactionCollectServiceImpl : current compaction frozen scn:1703095202917758401, broadcast scn:1703095202917758401, saved frozen scn:1703095202917758401 2023-12-21 09:38:01.010 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,b350bac99cbc] o.i.t.TenantCompactionCollectServiceImpl : Finish to collect major compaction info for tenant:sys 2023-12-21 09:38:01.016 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,b350bac99cbc] o.i.t.TenantCompactionCollectServiceImpl : Begin to collect major compaction info for tenant:ocp_mate 2023-12-21 09:38:01.016 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,b350bac99cbc] c.o.o.c.obsdk.ConnectPropertiesBuilder : get credential from obsdk context, clusterName=obcluster, tenantName=sys, dbUser=root 2023-12-21 09:38:01.016 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,b350bac99cbc] c.o.o.c.obsdk.ConnectPropertiesBuilder : build connect address for sys tenant, obServerAddrList=[ObServerAddr(address=10.253.208.65, port=2881), ObServerAddr(address=10.253.208.67, port=2881), ObServerAddr(address=10.253.208.172, port=2881)] 2023-12-21 09:38:01.016 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,b350bac99cbc] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:38:01.017 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,b350bac99cbc] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:38:01.017 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,b350bac99cbc] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:38:01.017 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,b350bac99cbc] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select max(value) value from oceanbase.__all_virtual_sys_parameter_stat where name = 'min_observer_version' 2023-12-21 09:38:01.022 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,b350bac99cbc] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:38:01.022 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,b350bac99cbc] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:38:01.022 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,b350bac99cbc] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT tenant_id, global_broadcast_scn AS broadcast_scn, is_error AS error, status, frozen_scn, last_scn, is_suspended AS suspend, info, start_time, last_finish_time FROM CDB_OB_MAJOR_COMPACTION WHERE tenant_id = ?, args: [1002] 2023-12-21 09:38:01.025 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,b350bac99cbc] o.i.t.TenantCompactionCollectServiceImpl : current compaction frozen scn:1703095201688828412, broadcast scn:1703095201688828412, saved frozen scn:1703095201688828412 2023-12-21 09:38:01.025 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,b350bac99cbc] o.i.t.TenantCompactionCollectServiceImpl : Finish to collect major compaction info for tenant:ocp_mate 2023-12-21 09:38:01.030 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,b350bac99cbc] o.o.i.t.t.CollectAllTenantCompactionTask : Finish to collect all tenants major compaction info 2023-12-21 09:38:01.040 INFO 228566 --- [pool-subtask-executor32,eb4d2d816a3143de,b350bac99cbc] c.o.ocp.task.dao.SubtaskAccessor : Set state for subtask: 1000650, operation:EXECUTE, state: SUCCESSFUL 2023-12-21 09:38:07.198 INFO 228566 --- [http-nio-8180-exec-8,bb9bcde44ca74495,9147d23e22da] c.o.ocp.analyzer.RequestTracingAspect : API: [GET /api/v1/status?null, client=10.253.208.63, traceId=bb9bcde44ca74495, method=Map com.oceanbase.ocp.controller.InfoController.status(), args=] 2023-12-21 09:38:07.198 INFO 228566 --- [http-nio-8180-exec-8,bb9bcde44ca74495,9147d23e22da] c.o.ocp.analyzer.RequestTracingAspect : API OK: [GET /api/v1/status client=10.253.208.63, traceId=bb9bcde44ca74495, duration=0 ms] 2023-12-21 09:38:14.044 ERROR 228566 --- [pool-metric-archive-second-8,,] c.o.o.m.storage.RollupMetricDataDao : Archive node list to table metric_data_second error, e = PreparedStatementCallback; uncategorized SQLException for SQL [INSERT INTO `metric_data_second` (`series_id`, `timestamp`, `data`, `interval`) VALUES (?, ?, ?, ?)]; SQL state [HY000]; error code [1526]; (conn=2622139) Table has no partition for value; nested exception is java.sql.BatchUpdateException: (conn=2622139) Table has no partition for value 2023-12-21 09:38:14.057 ERROR 228566 --- [pool-metric-archive-second-8,,] c.o.o.m.service.OcpMetricArchiveService : Archive second nodes failed. org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [REPLACE INTO `metric_data_second` (`series_id`, `timestamp`, `data`, `interval`) VALUES (?, ?, ?, ?)]; SQL state [HY000]; error code [1526]; (conn=2622139) Table has no partition for value; nested exception is java.sql.BatchUpdateException: (conn=2622139) Table has no partition for value at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1542) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:667) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:691) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1034) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1088) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at com.oceanbase.ocp.monitor.storage.RollupMetricDataDao.write(RollupMetricDataDao.java:77) ~[ocp-express-monitor-service-4.2.0-20230731.jar!/:4.2.0-20230731] at com.oceanbase.ocp.monitor.service.OcpMetricArchiveService.lambda$archiveSecond$1(OcpMetricArchiveService.java:106) ~[ocp-express-monitor-service-4.2.0-20230731.jar!/:4.2.0-20230731] at com.oceanbase.ocp.monitor.meter.MeterUtils.time(MeterUtils.java:64) ~[ocp-express-monitor-service-4.2.0-20230731.jar!/:4.2.0-20230731] at com.oceanbase.ocp.monitor.meter.DistributionSummaryGroup.time(DistributionSummaryGroup.java:110) ~[ocp-express-monitor-service-4.2.0-20230731.jar!/:4.2.0-20230731] at com.oceanbase.ocp.monitor.service.OcpMetricArchiveService.archiveSecond(OcpMetricArchiveService.java:98) ~[ocp-express-monitor-service-4.2.0-20230731.jar!/:4.2.0-20230731] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[na:1.8.0_222] at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) ~[na:1.8.0_222] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) ~[na:1.8.0_222] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) ~[na:1.8.0_222] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_222] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_222] at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_222] Caused by: java.sql.BatchUpdateException: (conn=2622139) Table has no partition for value at com.oceanbase.jdbc.OceanBaseStatement.executeBatchExceptionEpilogue(OceanBaseStatement.java:445) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.OceanBaseStatement.executeBatchExceptionEpilogue(OceanBaseStatement.java:448) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.JDBC4PreparedStatement.executeBatch(JDBC4PreparedStatement.java:315) ~[oceanbase-client-2.4.3.jar!/:na] at com.alibaba.druid.filter.FilterChainImpl.statement_executeBatch(FilterChainImpl.java:3118) ~[druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.filter.FilterAdapter.statement_executeBatch(FilterAdapter.java:2507) ~[druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.filter.FilterEventAdapter.statement_executeBatch(FilterEventAdapter.java:279) ~[druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.filter.FilterChainImpl.statement_executeBatch(FilterChainImpl.java:3116) ~[druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.proxy.jdbc.StatementProxyImpl.executeBatch(StatementProxyImpl.java:202) ~[druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeBatch(DruidPooledPreparedStatement.java:565) ~[druid-1.2.8.jar!/:1.2.8] at org.springframework.jdbc.core.JdbcTemplate.lambda$batchUpdate$4(JdbcTemplate.java:1048) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:651) ~[spring-jdbc-5.3.27.jar!/:5.3.27] ... 15 common frames omitted Caused by: java.sql.SQLTransientConnectionException: (conn=2622139) Table has no partition for value at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:128) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:202) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.OceanBaseStatement.executeBatchExceptionEpilogue(OceanBaseStatement.java:441) ~[oceanbase-client-2.4.3.jar!/:na] ... 25 common frames omitted Caused by: com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException: Table has no partition for value at com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException.of(OceanBaseSqlException.java:79) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchRewrite(AbstractQueryProtocol.java:1171) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchClient(AbstractQueryProtocol.java:656) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.JDBC4PreparedStatement.executeInternalBatch(JDBC4PreparedStatement.java:418) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.JDBC4PreparedStatement.executeBatch(JDBC4PreparedStatement.java:310) ~[oceanbase-client-2.4.3.jar!/:na] ... 23 common frames omitted Caused by: java.sql.SQLException: Table has no partition for value at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:2192) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:2057) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1951) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchRewrite(AbstractQueryProtocol.java:1163) ~[oceanbase-client-2.4.3.jar!/:na] ... 26 common frames omitted 2023-12-21 09:38:14.059 ERROR 228566 --- [pool-metric-archive-second-8,,] c.o.o.m.storage.RollupMetricDataDao : Archive node list to table metric_data_second error, e = PreparedStatementCallback; uncategorized SQLException for SQL [INSERT INTO `metric_data_second` (`series_id`, `timestamp`, `data`, `interval`) VALUES (?, ?, ?, ?)]; SQL state [HY000]; error code [1526]; (conn=2622139) Table has no partition for value; nested exception is java.sql.BatchUpdateException: (conn=2622139) Table has no partition for value 2023-12-21 09:38:14.061 ERROR 228566 --- [pool-metric-archive-second-8,,] c.o.o.m.service.OcpMetricArchiveService : Archive second nodes failed. org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [REPLACE INTO `metric_data_second` (`series_id`, `timestamp`, `data`, `interval`) VALUES (?, ?, ?, ?)]; SQL state [HY000]; error code [1526]; (conn=2622139) Table has no partition for value; nested exception is java.sql.BatchUpdateException: (conn=2622139) Table has no partition for value at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1542) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:667) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:691) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1034) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1088) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at com.oceanbase.ocp.monitor.storage.RollupMetricDataDao.write(RollupMetricDataDao.java:77) ~[ocp-express-monitor-service-4.2.0-20230731.jar!/:4.2.0-20230731] at com.oceanbase.ocp.monitor.service.OcpMetricArchiveService.lambda$archiveSecond$1(OcpMetricArchiveService.java:106) ~[ocp-express-monitor-service-4.2.0-20230731.jar!/:4.2.0-20230731] at com.oceanbase.ocp.monitor.meter.MeterUtils.time(MeterUtils.java:64) ~[ocp-express-monitor-service-4.2.0-20230731.jar!/:4.2.0-20230731] at com.oceanbase.ocp.monitor.meter.DistributionSummaryGroup.time(DistributionSummaryGroup.java:110) ~[ocp-express-monitor-service-4.2.0-20230731.jar!/:4.2.0-20230731] at com.oceanbase.ocp.monitor.service.OcpMetricArchiveService.archiveSecond(OcpMetricArchiveService.java:98) ~[ocp-express-monitor-service-4.2.0-20230731.jar!/:4.2.0-20230731] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[na:1.8.0_222] at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) ~[na:1.8.0_222] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) ~[na:1.8.0_222] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) ~[na:1.8.0_222] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_222] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_222] at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_222] Caused by: java.sql.BatchUpdateException: (conn=2622139) Table has no partition for value at com.oceanbase.jdbc.OceanBaseStatement.executeBatchExceptionEpilogue(OceanBaseStatement.java:445) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.OceanBaseStatement.executeBatchExceptionEpilogue(OceanBaseStatement.java:448) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.JDBC4PreparedStatement.executeBatch(JDBC4PreparedStatement.java:315) ~[oceanbase-client-2.4.3.jar!/:na] at com.alibaba.druid.filter.FilterChainImpl.statement_executeBatch(FilterChainImpl.java:3118) ~[druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.filter.FilterAdapter.statement_executeBatch(FilterAdapter.java:2507) ~[druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.filter.FilterEventAdapter.statement_executeBatch(FilterEventAdapter.java:279) ~[druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.filter.FilterChainImpl.statement_executeBatch(FilterChainImpl.java:3116) ~[druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.proxy.jdbc.StatementProxyImpl.executeBatch(StatementProxyImpl.java:202) ~[druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeBatch(DruidPooledPreparedStatement.java:565) ~[druid-1.2.8.jar!/:1.2.8] at org.springframework.jdbc.core.JdbcTemplate.lambda$batchUpdate$4(JdbcTemplate.java:1048) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:651) ~[spring-jdbc-5.3.27.jar!/:5.3.27] ... 15 common frames omitted Caused by: java.sql.SQLTransientConnectionException: (conn=2622139) Table has no partition for value at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:128) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:202) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.OceanBaseStatement.executeBatchExceptionEpilogue(OceanBaseStatement.java:441) ~[oceanbase-client-2.4.3.jar!/:na] ... 25 common frames omitted Caused by: com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException: Table has no partition for value at com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException.of(OceanBaseSqlException.java:79) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchRewrite(AbstractQueryProtocol.java:1171) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchClient(AbstractQueryProtocol.java:656) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.JDBC4PreparedStatement.executeInternalBatch(JDBC4PreparedStatement.java:418) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.JDBC4PreparedStatement.executeBatch(JDBC4PreparedStatement.java:310) ~[oceanbase-client-2.4.3.jar!/:na] ... 23 common frames omitted Caused by: java.sql.SQLException: Table has no partition for value at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:2192) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:2057) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1951) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchRewrite(AbstractQueryProtocol.java:1163) ~[oceanbase-client-2.4.3.jar!/:na] ... 26 common frames omitted 2023-12-21 09:38:27.397 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.o.c.obsdk.ConnectPropertiesBuilder : build connect address for sys tenant, obServerAddrList=[ObServerAddr(address=10.253.208.65, port=2881), ObServerAddr(address=10.253.208.67, port=2881), ObServerAddr(address=10.253.208.172, port=2881)] 2023-12-21 09:38:27.398 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:38:27.398 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:38:27.398 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:38:27.399 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select max(value) value from oceanbase.__all_virtual_sys_parameter_stat where name = 'min_observer_version' 2023-12-21 09:38:27.408 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:38:27.408 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:38:27.409 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select max(value) value from oceanbase.__all_virtual_sys_parameter_stat where name = 'min_observer_version' 2023-12-21 09:38:27.413 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:38:27.413 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:38:27.414 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT `zone`, `status`, `region`, `idc` FROM `DBA_OB_ZONES` 2023-12-21 09:38:27.415 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:38:27.415 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:38:27.415 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] 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, id FROM DBA_OB_SERVERS ORDER BY zone ASC, id ASC 2023-12-21 09:38:27.417 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:38:27.417 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:38:27.417 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT `svr_ip`, `svr_port`, `zone`, `role` FROM `CDB_OB_LS_LOCATIONS` WHERE `tenant_id` = 1 AND `ls_id` = 1 2023-12-21 09:38:27.418 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:38:27.418 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:38:27.418 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select version() REGEXP 'OceanBase[\s_]CE' 2023-12-21 09:38:27.419 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.o.o.i.c.ClusterInitServiceImpl : sync cluster info done 2023-12-21 09:38:27.423 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.o.c.obsdk.ConnectPropertiesBuilder : get credential from obsdk context, clusterName=obcluster, tenantName=sys, dbUser=root 2023-12-21 09:38:27.423 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.o.c.obsdk.ConnectPropertiesBuilder : build connect address for sys tenant, obServerAddrList=[ObServerAddr(address=10.253.208.65, port=2881), ObServerAddr(address=10.253.208.67, port=2881), ObServerAddr(address=10.253.208.172, port=2881)] 2023-12-21 09:38:27.424 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:38:27.424 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:38:27.424 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:38:27.425 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select max(value) value from oceanbase.__all_virtual_sys_parameter_stat where name = 'min_observer_version' 2023-12-21 09:38:27.430 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:38:27.430 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:38:27.430 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT TENANT_ID, TENANT_NAME, TENANT_TYPE, PRIMARY_ZONE, LOCALITY, COMPATIBILITY_MODE, STATUS, IN_RECYCLEBIN, (CASE WHEN LOCKED = 'YES' THEN 1 ELSE 0 END) AS LOCKED, TIMESTAMPDIFF(SECOND, CREATE_TIME, now()) AS exist_seconds FROM oceanbase.DBA_OB_TENANTS WHERE TENANT_TYPE IN ('SYS', 'USER') 2023-12-21 09:38:27.433 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:38:27.433 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:38:27.434 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT TENANT_ID, NAME, VALUE FROM oceanbase.CDB_OB_SYS_VARIABLES WHERE TENANT_ID = ?, args: [1] 2023-12-21 09:38:27.437 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:38:27.437 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:38:27.437 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT TENANT_ID, NAME, VALUE FROM oceanbase.CDB_OB_SYS_VARIABLES WHERE TENANT_ID = ?, args: [1] 2023-12-21 09:38:27.441 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:38:27.441 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:38:27.441 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT TENANT_ID, NAME, VALUE FROM oceanbase.CDB_OB_SYS_VARIABLES WHERE TENANT_ID = ?, args: [1002] 2023-12-21 09:38:27.445 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:38:27.445 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:38:27.445 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT TENANT_ID, NAME, VALUE FROM oceanbase.CDB_OB_SYS_VARIABLES WHERE TENANT_ID = ?, args: [1002] 2023-12-21 09:38:27.450 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.o.c.obsdk.ConnectPropertiesBuilder : get credential from obsdk context, clusterName=obcluster, tenantName=sys, dbUser=root 2023-12-21 09:38:27.450 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.o.c.obsdk.ConnectPropertiesBuilder : build connect address for sys tenant, obServerAddrList=[ObServerAddr(address=10.253.208.65, port=2881), ObServerAddr(address=10.253.208.67, port=2881), ObServerAddr(address=10.253.208.172, port=2881)] 2023-12-21 09:38:27.450 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:38:27.450 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:38:27.450 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:38:27.451 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select max(value) value from oceanbase.__all_virtual_sys_parameter_stat where name = 'min_observer_version' 2023-12-21 09:38:27.457 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:38:27.457 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:38:27.458 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT TENANT_ID, JOB_ID, JOB_TYPE, JOB_STATUS, PROGRESS FROM oceanbase.DBA_OB_TENANT_JOBS WHERE TENANT_ID = ? AND JOB_TYPE = ? ORDER BY JOB_ID DESC LIMIT 1, args: [1, ALTER_TENANT_LOCALITY] 2023-12-21 09:38:27.458 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.o.c.obsdk.ConnectPropertiesBuilder : get credential from obsdk context, clusterName=obcluster, tenantName=sys, dbUser=root 2023-12-21 09:38:27.458 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.o.c.obsdk.ConnectPropertiesBuilder : build connect address for sys tenant, obServerAddrList=[ObServerAddr(address=10.253.208.65, port=2881), ObServerAddr(address=10.253.208.67, port=2881), ObServerAddr(address=10.253.208.172, port=2881)] 2023-12-21 09:38:27.458 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:38:27.459 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:38:27.459 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:38:27.460 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select max(value) value from oceanbase.__all_virtual_sys_parameter_stat where name = 'min_observer_version' 2023-12-21 09:38:27.464 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:38:27.464 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:38:27.465 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT TENANT_ID, JOB_ID, JOB_TYPE, JOB_STATUS, PROGRESS FROM oceanbase.DBA_OB_TENANT_JOBS WHERE TENANT_ID = ? AND JOB_TYPE = ? ORDER BY JOB_ID DESC LIMIT 1, args: [1, SHRINK_RESOURCE_POOL_UNIT_NUM] 2023-12-21 09:38:27.467 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.o.c.obsdk.ConnectPropertiesBuilder : get credential from obsdk context, clusterName=obcluster, tenantName=sys, dbUser=root 2023-12-21 09:38:27.467 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.o.c.obsdk.ConnectPropertiesBuilder : build connect address for sys tenant, obServerAddrList=[ObServerAddr(address=10.253.208.65, port=2881), ObServerAddr(address=10.253.208.67, port=2881), ObServerAddr(address=10.253.208.172, port=2881)] 2023-12-21 09:38:27.468 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:38:27.468 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:38:27.469 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:38:27.469 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select max(value) value from oceanbase.__all_virtual_sys_parameter_stat where name = 'min_observer_version' 2023-12-21 09:38:27.473 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:38:27.473 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:38:27.474 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT TENANT_ID, JOB_ID, JOB_TYPE, JOB_STATUS, PROGRESS FROM oceanbase.DBA_OB_TENANT_JOBS WHERE TENANT_ID = ? AND JOB_TYPE = ? ORDER BY JOB_ID DESC LIMIT 1, args: [1002, ALTER_TENANT_LOCALITY] 2023-12-21 09:38:27.474 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.o.c.obsdk.ConnectPropertiesBuilder : get credential from obsdk context, clusterName=obcluster, tenantName=sys, dbUser=root 2023-12-21 09:38:27.474 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.o.c.obsdk.ConnectPropertiesBuilder : build connect address for sys tenant, obServerAddrList=[ObServerAddr(address=10.253.208.65, port=2881), ObServerAddr(address=10.253.208.67, port=2881), ObServerAddr(address=10.253.208.172, port=2881)] 2023-12-21 09:38:27.475 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:38:27.475 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:38:27.475 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:38:27.475 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select max(value) value from oceanbase.__all_virtual_sys_parameter_stat where name = 'min_observer_version' 2023-12-21 09:38:27.479 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.253.208.65, sql port:2881 2023-12-21 09:38:27.479 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-12-21 09:38:27.480 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT TENANT_ID, JOB_ID, JOB_TYPE, JOB_STATUS, PROGRESS FROM oceanbase.DBA_OB_TENANT_JOBS WHERE TENANT_ID = ? AND JOB_TYPE = ? ORDER BY JOB_ID DESC LIMIT 1, args: [1002, SHRINK_RESOURCE_POOL_UNIT_NUM] 2023-12-21 09:38:27.480 INFO 228566 --- [pool-ocp-schedules-3,,4e15913bd69a] c.o.o.o.i.tenant.TenantSyncServiceImpl : Sync all tenant info done 2023-12-21 09:38:44.858 INFO 228566 --- [pool-prometheus-cache-monitor1,,ef5c7400cfdb] c.o.o.m.service.OcpCacheStatServiceImpl : OcpCacheMonitor, cacheInfo={"secondReadCacheSize":4036,"minuteWriteQueue":0,"minuteReadCacheSize":4036,"secondWriteCacheSize":1009,"seriesIdKeySize":1277,"secondWriteQueue":0,"minuteWriteCacheSize":1009} 2023-12-21 09:38:44.859 INFO 228566 --- [pool-prometheus-cache-monitor1,,ef5c7400cfdb] c.o.o.m.service.OcpCacheStatServiceImpl : MetricSearchStats:{node_disk_read_time_seconds_total=21, ob_server_resource_memory_assigned_bytes=10, ob_active_session_num=14, ob_plan_cache_memory_bytes=16, ob_tenant_assigned_cpu_assigned=14, node_network_transmit_bytes_total=14, node_filesystem_size_bytes=45, ob_system_event_total_waits=20, node_disk_read_bytes_total=21, node_cpu_seconds_total=18, ob_tenant_resource_max_cpu=14, ob_plan_cache_hit_total=16, ob_server_resource_memory_assigned_percent=10, io_await=35, ob_server_resource_cpu=10, ob_server_num=12, ob_all_session_num=14, io_util=35, ob_tenant_resource_min_memory=14, ob_plan_cache_access_total=16, node_disk_reads_completed_total=21, ob_system_event_time_waited=20, ob_sysstat=92, node_disk_writes_completed_total=21, ob_tenant_resource_min_cpu=14, node_ntp_offset_seconds=11, ob_cache_size_bytes=29, node_net_bandwidth_bps=14, ob_tenant_assigned_cpu_total=14, node_load1=10, ob_tenant_disk_log_size=14, ob_server_resource_memory_bytes=10, ob_tenant_resource_max_memory=14, cpu_count=11, node_disk_io_time_weighted_seconds_total=21, node_disk_write_time_seconds_total=21, ob_disk_total_bytes=10, ob_tenant_assigned_mem_assigned=14, node_load15=10, ob_tenant_disk_data_size=14, ob_server_resource_cpu_assigned_percent=10, node_load5=10, node_disk_written_bytes_total=21, node_memory_memfree_bytes=10, process_exists=15, ob_server_resource_disk_bytes=10, node_memory_buffers_bytes=10, ob_tenant_assigned_mem_total=14, node_memory_memtotal_bytes=10, ob_server_resource_cpu_assigned=10, node_network_receive_bytes_total=14, ob_waitevent_wait_seconds_total=14, node_memory_cached_bytes=10, ob_table_num=14, ob_waitevent_wait_total=14, ob_disk_free_bytes=10, oceanbase_connectivity=1, node_filesystem_avail_bytes=45} 2023-12-21 09:38:45.086 INFO 228566 --- [pool-ocp-schedules-4,,2835f9a31bf9] c.o.o.m.service.OcpCacheStatServiceImpl : OcpCacheMonitor, cacheInfo={"secondReadCacheSize":4036,"minuteWriteQueue":0,"minuteReadCacheSize":4036,"secondWriteCacheSize":1009,"seriesIdKeySize":1277,"secondWriteQueue":0,"minuteWriteCacheSize":1009} 2023-12-21 09:38:45.086 INFO 228566 --- [pool-ocp-schedules-4,,2835f9a31bf9] c.o.o.m.service.OcpCacheStatServiceImpl : MetricSearchStats:{node_disk_read_time_seconds_total=21, ob_server_resource_memory_assigned_bytes=10, ob_active_session_num=14, ob_plan_cache_memory_bytes=16, ob_tenant_assigned_cpu_assigned=14, node_network_transmit_bytes_total=14, node_filesystem_size_bytes=45, ob_system_event_total_waits=20, node_disk_read_bytes_total=21, node_cpu_seconds_total=18, ob_tenant_resource_max_cpu=14, ob_plan_cache_hit_total=16, ob_server_resource_memory_assigned_percent=10, io_await=35, ob_server_resource_cpu=10, ob_server_num=12, ob_all_session_num=14, io_util=35, ob_tenant_resource_min_memory=14, ob_plan_cache_access_total=16, node_disk_reads_completed_total=21, ob_system_event_time_waited=20, ob_sysstat=92, node_disk_writes_completed_total=21, ob_tenant_resource_min_cpu=14, node_ntp_offset_seconds=11, ob_cache_size_bytes=29, node_net_bandwidth_bps=14, ob_tenant_assigned_cpu_total=14, node_load1=10, ob_tenant_disk_log_size=14, ob_server_resource_memory_bytes=10, ob_tenant_resource_max_memory=14, cpu_count=11, node_disk_io_time_weighted_seconds_total=21, node_disk_write_time_seconds_total=21, ob_disk_total_bytes=10, ob_tenant_assigned_mem_assigned=14, node_load15=10, ob_tenant_disk_data_size=14, ob_server_resource_cpu_assigned_percent=10, node_load5=10, node_disk_written_bytes_total=21, node_memory_memfree_bytes=10, process_exists=15, ob_server_resource_disk_bytes=10, node_memory_buffers_bytes=10, ob_tenant_assigned_mem_total=14, node_memory_memtotal_bytes=10, ob_server_resource_cpu_assigned=10, node_network_receive_bytes_total=14, ob_waitevent_wait_seconds_total=14, node_memory_cached_bytes=10, ob_table_num=14, ob_waitevent_wait_total=14, ob_disk_free_bytes=10, oceanbase_connectivity=1, node_filesystem_avail_bytes=45} 2023-12-21 09:38:45.859 INFO 228566 --- [pool-prometheus-second-schedule-1,,e59ab71b4fc4] c.o.ocp.monitor.OcpMonitorManager : create pull exporter, exporterCount=9, collectTaskCount=9 2023-12-21 09:38:48.027 INFO 228566 --- [pool-ocp-schedules-1,,88ab95af8094] c.o.o.m.service.SeriesIdKeyService : Sync series key and id, currentMaxSeriesId=594148003927941120 2023-12-21 09:39:00.000 INFO 228566 --- [pool-ocp-schedules-5,,] c.o.ocp.core.property.PropertyService : Refresh OCP properties. 2023-12-21 09:39:00.000 INFO 228566 --- [pool-ocp-schedules-5,,] c.o.ocp.core.property.PropertyService : Refresh config properties 2023-12-21 09:39:00.003 INFO 228566 --- [pool-ocp-schedules-5,,] c.o.o.b.spring.BootstrapRunListener : new: [] 2023-12-21 09:39:00.003 INFO 228566 --- [pool-ocp-schedules-5,,] c.o.o.b.spring.BootstrapRunListener : starting 2023-12-21 09:39:00.007 INFO 228566 --- [pool-ocp-schedules-5,,] c.o.o.b.spring.BootstrapRunListener : new: [] 2023-12-21 09:39:00.007 INFO 228566 --- [pool-ocp-schedules-5,,] c.o.o.b.spring.BootstrapRunListener : starting 2023-12-21 09:39:00.032 INFO 228566 --- [pool-ocp-schedules-5,,] c.o.o.b.spring.BootstrapRunListener : environmentPrepared 2023-12-21 09:39:00.044 INFO 228566 --- [pool-ocp-schedules-5,,] c.o.o.b.spring.BootstrapRunListener : contextPrepared 2023-12-21 09:39:00.044 INFO 228566 --- [pool-ocp-schedules-5,,] c.o.o.b.spring.BootstrapRunListener : register bean ProgressHandler 2023-12-21 09:39:00.053 INFO 228566 --- [pool-ocp-schedules-5,,] c.o.o.b.spring.BootstrapRunListener : contextLoaded 2023-12-21 09:39:00.254 INFO 228566 --- [pool-ocp-schedules-5,,] c.o.o.b.spring.DataSourceInterceptor : dataSource dataSource already initialized. skipped 2023-12-21 09:39:00.274 INFO 228566 --- [pool-ocp-schedules-5,,] c.o.o.b.spring.BootstrapRunListener : started 2023-12-21 09:39:00.275 INFO 228566 --- [pool-ocp-schedules-5,,] c.o.o.b.spring.BootstrapRunListener : Ready, timeTaken=PT0.267965921S 2023-12-21 09:39:00.275 INFO 228566 --- [pool-ocp-schedules-5,,] c.o.o.b.spring.BootstrapRunListener : environmentPrepared 2023-12-21 09:39:00.353 INFO 228566 --- [pool-ocp-schedules-5,,] b.c.PropertySourceBootstrapConfiguration : Located property source: [BootstrapPropertySource {name='bootstrapProperties-ocp-default'}] 2023-12-21 09:39:00.382 INFO 228566 --- [pool-ocp-schedules-5,,] c.o.o.b.spring.BootstrapRunListener : contextPrepared 2023-12-21 09:39:00.382 INFO 228566 --- [pool-ocp-schedules-5,,] c.o.o.b.spring.BootstrapRunListener : register bean ProgressHandler 2023-12-21 09:39:00.382 INFO 228566 --- [pool-ocp-schedules-5,,] o.s.boot.SpringApplication : The following 2 profiles are active: "composite", "default" 2023-12-21 09:39:00.394 INFO 228566 --- [pool-ocp-schedules-5,,] c.o.o.b.spring.BootstrapRunListener : contextLoaded 2023-12-21 09:39:00.410 INFO 228566 --- [pool-ocp-schedules-5,,] o.s.boot.SpringApplication : Started application in 0.407 seconds (JVM running for 77918.742) 2023-12-21 09:39:00.410 INFO 228566 --- [pool-ocp-schedules-5,,] c.o.o.b.spring.BootstrapRunListener : started 2023-12-21 09:39:00.410 INFO 228566 --- [pool-ocp-schedules-5,,] c.o.o.b.spring.BootstrapRunListener : Ready, timeTaken=PT0.407344593S 2023-12-21 09:39:00.470 INFO 228566 --- [pool-ocp-schedules-5,,] c.o.o.b.spring.DataSourceInterceptor : dataSource dataSource already initialized. skipped 2023-12-21 09:39:00.518 INFO 228566 --- [pool-ocp-schedules-5,,] c.o.ocp.core.property.PropertyService : Refresh config properties done 2023-12-21 09:39:14.078 ERROR 228566 --- [pool-metric-archive-second-7,,] c.o.o.m.storage.RollupMetricDataDao : Archive node list to table metric_data_second error, e = PreparedStatementCallback; uncategorized SQLException for SQL [INSERT INTO `metric_data_second` (`series_id`, `timestamp`, `data`, `interval`) VALUES (?, ?, ?, ?)]; SQL state [HY000]; error code [1526]; (conn=3670022) Table has no partition for value; nested exception is java.sql.BatchUpdateException: (conn=3670022) Table has no partition for value 2023-12-21 09:39:14.093 ERROR 228566 --- [pool-metric-archive-second-7,,] c.o.o.m.service.OcpMetricArchiveService : Archive second nodes failed. org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [REPLACE INTO `metric_data_second` (`series_id`, `timestamp`, `data`, `interval`) VALUES (?, ?, ?, ?)]; SQL state [HY000]; error code [1526]; (conn=3670022) Table has no partition for value; nested exception is java.sql.BatchUpdateException: (conn=3670022) Table has no partition for value at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1542) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:667) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:691) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1034) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1088) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at com.oceanbase.ocp.monitor.storage.RollupMetricDataDao.write(RollupMetricDataDao.java:77) ~[ocp-express-monitor-service-4.2.0-20230731.jar!/:4.2.0-20230731] at com.oceanbase.ocp.monitor.service.OcpMetricArchiveService.lambda$archiveSecond$1(OcpMetricArchiveService.java:106) ~[ocp-express-monitor-service-4.2.0-20230731.jar!/:4.2.0-20230731] at com.oceanbase.ocp.monitor.meter.MeterUtils.time(MeterUtils.java:64) ~[ocp-express-monitor-service-4.2.0-20230731.jar!/:4.2.0-20230731] at com.oceanbase.ocp.monitor.meter.DistributionSummaryGroup.time(DistributionSummaryGroup.java:110) ~[ocp-express-monitor-service-4.2.0-20230731.jar!/:4.2.0-20230731] at com.oceanbase.ocp.monitor.service.OcpMetricArchiveService.archiveSecond(OcpMetricArchiveService.java:98) ~[ocp-express-monitor-service-4.2.0-20230731.jar!/:4.2.0-20230731] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[na:1.8.0_222] at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) ~[na:1.8.0_222] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) ~[na:1.8.0_222] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) ~[na:1.8.0_222] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_222] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_222] at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_222] Caused by: java.sql.BatchUpdateException: (conn=3670022) Table has no partition for value at com.oceanbase.jdbc.OceanBaseStatement.executeBatchExceptionEpilogue(OceanBaseStatement.java:445) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.OceanBaseStatement.executeBatchExceptionEpilogue(OceanBaseStatement.java:448) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.JDBC4PreparedStatement.executeBatch(JDBC4PreparedStatement.java:315) ~[oceanbase-client-2.4.3.jar!/:na] at com.alibaba.druid.filter.FilterChainImpl.statement_executeBatch(FilterChainImpl.java:3118) ~[druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.filter.FilterAdapter.statement_executeBatch(FilterAdapter.java:2507) ~[druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.filter.FilterEventAdapter.statement_executeBatch(FilterEventAdapter.java:279) ~[druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.filter.FilterChainImpl.statement_executeBatch(FilterChainImpl.java:3116) ~[druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.proxy.jdbc.StatementProxyImpl.executeBatch(StatementProxyImpl.java:202) ~[druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeBatch(DruidPooledPreparedStatement.java:565) ~[druid-1.2.8.jar!/:1.2.8] at org.springframework.jdbc.core.JdbcTemplate.lambda$batchUpdate$4(JdbcTemplate.java:1048) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:651) ~[spring-jdbc-5.3.27.jar!/:5.3.27] ... 15 common frames omitted Caused by: java.sql.SQLTransientConnectionException: (conn=3670022) Table has no partition for value at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:128) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:202) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.OceanBaseStatement.executeBatchExceptionEpilogue(OceanBaseStatement.java:441) ~[oceanbase-client-2.4.3.jar!/:na] ... 25 common frames omitted Caused by: com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException: Table has no partition for value at com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException.of(OceanBaseSqlException.java:79) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchRewrite(AbstractQueryProtocol.java:1171) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchClient(AbstractQueryProtocol.java:656) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.JDBC4PreparedStatement.executeInternalBatch(JDBC4PreparedStatement.java:418) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.JDBC4PreparedStatement.executeBatch(JDBC4PreparedStatement.java:310) ~[oceanbase-client-2.4.3.jar!/:na] ... 23 common frames omitted Caused by: java.sql.SQLException: Table has no partition for value at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:2192) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:2057) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1951) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchRewrite(AbstractQueryProtocol.java:1163) ~[oceanbase-client-2.4.3.jar!/:na] ... 26 common frames omitted 2023-12-21 09:39:14.095 ERROR 228566 --- [pool-metric-archive-second-7,,] c.o.o.m.storage.RollupMetricDataDao : Archive node list to table metric_data_second error, e = PreparedStatementCallback; uncategorized SQLException for SQL [INSERT INTO `metric_data_second` (`series_id`, `timestamp`, `data`, `interval`) VALUES (?, ?, ?, ?)]; SQL state [HY000]; error code [1526]; (conn=3670022) Table has no partition for value; nested exception is java.sql.BatchUpdateException: (conn=3670022) Table has no partition for value 2023-12-21 09:39:14.098 ERROR 228566 --- [pool-metric-archive-second-7,,] c.o.o.m.service.OcpMetricArchiveService : Archive second nodes failed. org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [REPLACE INTO `metric_data_second` (`series_id`, `timestamp`, `data`, `interval`) VALUES (?, ?, ?, ?)]; SQL state [HY000]; error code [1526]; (conn=3670022) Table has no partition for value; nested exception is java.sql.BatchUpdateException: (conn=3670022) Table has no partition for value at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1542) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:667) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:691) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1034) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1088) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at com.oceanbase.ocp.monitor.storage.RollupMetricDataDao.write(RollupMetricDataDao.java:77) ~[ocp-express-monitor-service-4.2.0-20230731.jar!/:4.2.0-20230731] at com.oceanbase.ocp.monitor.service.OcpMetricArchiveService.lambda$archiveSecond$1(OcpMetricArchiveService.java:106) ~[ocp-express-monitor-service-4.2.0-20230731.jar!/:4.2.0-20230731] at com.oceanbase.ocp.monitor.meter.MeterUtils.time(MeterUtils.java:64) ~[ocp-express-monitor-service-4.2.0-20230731.jar!/:4.2.0-20230731] at com.oceanbase.ocp.monitor.meter.DistributionSummaryGroup.time(DistributionSummaryGroup.java:110) ~[ocp-express-monitor-service-4.2.0-20230731.jar!/:4.2.0-20230731] at com.oceanbase.ocp.monitor.service.OcpMetricArchiveService.archiveSecond(OcpMetricArchiveService.java:98) ~[ocp-express-monitor-service-4.2.0-20230731.jar!/:4.2.0-20230731] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[na:1.8.0_222] at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) ~[na:1.8.0_222] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) ~[na:1.8.0_222] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) ~[na:1.8.0_222] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_222] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_222] at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_222] Caused by: java.sql.BatchUpdateException: (conn=3670022) Table has no partition for value at com.oceanbase.jdbc.OceanBaseStatement.executeBatchExceptionEpilogue(OceanBaseStatement.java:445) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.OceanBaseStatement.executeBatchExceptionEpilogue(OceanBaseStatement.java:448) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.JDBC4PreparedStatement.executeBatch(JDBC4PreparedStatement.java:315) ~[oceanbase-client-2.4.3.jar!/:na] at com.alibaba.druid.filter.FilterChainImpl.statement_executeBatch(FilterChainImpl.java:3118) ~[druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.filter.FilterAdapter.statement_executeBatch(FilterAdapter.java:2507) ~[druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.filter.FilterEventAdapter.statement_executeBatch(FilterEventAdapter.java:279) ~[druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.filter.FilterChainImpl.statement_executeBatch(FilterChainImpl.java:3116) ~[druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.proxy.jdbc.StatementProxyImpl.executeBatch(StatementProxyImpl.java:202) ~[druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeBatch(DruidPooledPreparedStatement.java:565) ~[druid-1.2.8.jar!/:1.2.8] at org.springframework.jdbc.core.JdbcTemplate.lambda$batchUpdate$4(JdbcTemplate.java:1048) ~[spring-jdbc-5.3.27.jar!/:5.3.27] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:651) ~[spring-jdbc-5.3.27.jar!/:5.3.27] ... 15 common frames omitted Caused by: java.sql.SQLTransientConnectionException: (conn=3670022) Table has no partition for value at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:128) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:202) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.OceanBaseStatement.executeBatchExceptionEpilogue(OceanBaseStatement.java:441) ~[oceanbase-client-2.4.3.jar!/:na] ... 25 common frames omitted Caused by: com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException: Table has no partition for value at com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException.of(OceanBaseSqlException.java:79) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchRewrite(AbstractQueryProtocol.java:1171) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchClient(AbstractQueryProtocol.java:656) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.JDBC4PreparedStatement.executeInternalBatch(JDBC4PreparedStatement.java:418) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.JDBC4PreparedStatement.executeBatch(JDBC4PreparedStatement.java:310) ~[oceanbase-client-2.4.3.jar!/:na] ... 23 common frames omitted Caused by: java.sql.SQLException: Table has no partition for value at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:2192) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:2057) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1951) ~[oceanbase-client-2.4.3.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchRewrite(AbstractQueryProtocol.java:1163) ~[oceanbase-client-2.4.3.jar!/:na] ... 26 common frames omitted