############{EXECUTE}{2024-01-11T15:40:36.756+08:00}############ 2024-01-11 15:40:36.768 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.m.t.model.SubtaskInstanceEntity : Run subtask, id=4092, context=Context{parallelIdx=-1, stringMap={prohibit_rollback=false, ob_log_disk_path=/data/log1, task_instance_id=3518, agent_async_task_token_map={"4115":"bb1b7b9e-4859-4210-a450-d5ba6edc1b87"}, task_operation=execute, cluster_type=PRIMARY, ob_install_path=/home/admin/oceanbase, link_obproxy=false, primary_zone=, cluster_id=8, sub_task_instance_id=4092, cluster_version=4.2.1.2, cluster_name=zwellinfo_cluster, target_server_status=RUNNING, startup_option_string=, ob_version=4.2.1.2, service_name=zwellinfo_cluster:1704872017, target_zone_status=RUNNING, ob_cluster_id=1704872017, zone1.idc=zwell, root_sys_password=******, service_type=OB_CLUSTER, rpm_name=oceanbase-ce-4.2.1.2-102000042023120514.el7.x86_64.rpm, connection_mode=direct, target_cluster_status=RUNNING, latest_execution_start_time=2024-01-11T15:40:36.748+08:00, ob_data_disk_path=/data/1}, listMap={root_servers=[2], ob_connect_address_list=[10.42.10.161:2881], server_ids=[20], dep_rpm_names=[oceanbase-ce-libs-4.2.1.2-102000042023120514.el7.x86_64.rpm, oceanbase-ce-utils-4.2.1.2-102000042023120514.el7.x86_64.rpm], host_ids=[2], zone1.host_ids=[2], zone_names=[zone1]}}, executor=172.17.0.1 2024-01-11 15:40:36.802 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.ob.cluster.ClusterSyncService : sync cluster start, clusterId=8, clusterName=zwellinfo_cluster, obClusterId=1704872017 2024-01-11 15:40:36.885 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-01-11 15:40:36.892 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: select /** QUERY_TIMEOUT(60000000) */ max(value) value from oceanbase.__all_virtual_sys_parameter_stat where name = 'min_observer_version' 2024-01-11 15:40:36.898 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-01-11 15:40:36.905 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT `zone`, MAX(CASE `name` WHEN 'region' THEN `info` ELSE '' END ) `region`, MAX(CASE `name` WHEN 'idc' THEN `info` ELSE '' END ) `idc`, MAX(CASE `name` WHEN 'status' THEN `info` ELSE '' END ) `status`, MAX(CASE `name` WHEN 'merge_status' THEN `info` ELSE '' END ) `merge_status`, MAX(CASE `name` WHEN 'broadcast_version' THEN `value` ELSE 0 END ) `broadcast_version`, MAX(CASE `name` WHEN 'all_merged_version' THEN `value` ELSE 0 END ) `all_merged_version`, MAX(CASE `name` WHEN 'last_merged_version' THEN `value` ELSE 0 END ) `last_merged_version`, MAX(CASE `name` WHEN 'merge_start_time' THEN `value` ELSE 0 END ) `merge_start_time`, MAX(CASE `name` WHEN 'last_merged_time' THEN `value` ELSE 0 END ) `last_merged_time`, MAX(CASE `name` WHEN 'is_merge_timeout' THEN `value` ELSE 0 END ) `merge_timeout` FROM oceanbase.__all_zone WHERE `zone` <> '' GROUP BY `zone` 2024-01-11 15:40:36.913 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-01-11 15:40:36.920 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT zone, gmt_create, gmt_modified, svr_ip, svr_port, inner_port, with_rootserver, UPPER(`status`) as `status`, build_version, stop_time, start_service_time, last_offline_time, block_migrate_in_time, id FROM oceanbase.__all_server ORDER BY zone ASC, id ASC 2024-01-11 15:40:36.930 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.alipay.ocp.core.obsdk.util.ObSdkUtils : check observer active, observer=10.42.10.161:2882, status=ACTIVE, startServiceTime=1704958832006639, active=true 2024-01-11 15:40:36.935 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.alipay.ocp.core.obsdk.util.ObSdkUtils : check observer stopped, observer=10.42.10.161:2882, stopTime=0, stopped=false 2024-01-11 15:40:36.940 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.ob.cluster.ClusterSyncService : get current info from ob cluster, clusterId=8 2024-01-11 15:40:36.945 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.ob.cluster.ClusterSyncService : detect zone changed, before=ObZoneEntity{id=20, name=zone1, idcId=null, status=CREATING, innerStatus=null, compactionStatus=null, startTime=null, stopTime=null}, current=ObZoneEntity{id=null, name=zone1, idcId=1, status=RUNNING, innerStatus=ACTIVE, compactionStatus=null, startTime=null, stopTime=null} 2024-01-11 15:40:36.967 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.ob.cluster.ClusterSyncService : zone updated, zoneName=zone1 2024-01-11 15:40:36.971 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.ob.cluster.ClusterSyncService : detect server changed, before=ObServerEntity{id=20, ip=10.42.10.161, port=2882, sqlPort=2881, version=null, withRootserver=true, hostId=2, status=CREATING, innerStatus=null, startTime=null, stopTime=null}, current=ObServerEntity{id=null, ip=10.42.10.161, port=2882, sqlPort=2881, version=4.2.1.2_102000042023120514-ccdde7d34de421336c5362483d64bf2b73348bd4(Dec 5 2023 14:34:01), withRootserver=true, hostId=2, status=RUNNING, innerStatus=ACTIVE, startTime=2024-01-11T07:40:32.006639Z, stopTime=1970-01-01T00:00Z} 2024-01-11 15:40:36.998 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.ob.cluster.ClusterSyncService : update zones and servers done, clusterId=8, clusterName=zwellinfo_cluster, obClusterId=1704872017 2024-01-11 15:40:37.002 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.ob.cluster.ClusterSyncService : sync cluster start, clusterId=8, clusterName=zwellinfo_cluster, obClusterId=1704872017 2024-01-11 15:40:37.028 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, userId=200, clusterName=zwellinfo_cluster, tenantName=sys, dbUser=ocp_monitor 2024-01-11 15:40:37.045 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-01-11 15:40:37.050 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: select /** QUERY_TIMEOUT(60000000) */ max(value) value from oceanbase.__all_virtual_sys_parameter_stat where name = 'min_observer_version' 2024-01-11 15:40:37.057 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-01-11 15:40:37.063 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: select /** QUERY_TIMEOUT(60000000) */ max(value) value from oceanbase.__all_virtual_sys_parameter_stat where name = 'min_observer_version' 2024-01-11 15:40:37.069 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-01-11 15:40:37.075 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT cluster_id, cluster_name, created, cluster_role, cluster_status, current_scn, standby_became_primary_scn, primary_cluster_id, (time_to_usec(now(6)) - current_scn)/1000000 as delay_time, protection_mode, redo_transport_options, protection_level FROM oceanbase.v$ob_cluster 2024-01-11 15:40:37.081 ERROR 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] queryForObject failed, sql:[SELECT cluster_id, cluster_name, created, cluster_role, cluster_status, current_scn, standby_became_primary_scn, primary_cluster_id, (time_to_usec(now(6)) - current_scn)/1000000 as delay_time, protection_mode, redo_transport_options, protection_level FROM oceanbase.v$ob_cluster], error message:[StatementCallback; bad SQL grammar [SELECT cluster_id, cluster_name, created, cluster_role, cluster_status, current_scn, standby_became_primary_scn, primary_cluster_id, (time_to_usec(now(6)) - current_scn)/1000000 as delay_time, protection_mode, redo_transport_options, protection_level FROM oceanbase.v$ob_cluster]; nested exception is java.sql.SQLSyntaxErrorException: (conn=3221487617) Table 'oceanbase.v$ob_cluster' doesn't exist] 2024-01-11 15:40:37.085 WARN 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] com.alipay.ocp.common.pattern.Retry : failed to execute target runnable, errMsg:(conn=3221487617) Table 'oceanbase.v$ob_cluster' doesn't exist 2024-01-11 15:40:37.091 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] com.alipay.ocp.common.pattern.Retry : wait for 5 seconds 2024-01-11 15:40:42.095 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.o.connector.ObConnectorHolder : [obsdk] invalidate ob connector, clusterName=zwellinfo_cluster 2024-01-11 15:40:42.100 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.o.connector.ObConnectorHolder : [obsdk] invalidate ob connector, key=ObConnectorKey(connectionMode=direct, clusterName=zwellinfo_cluster, obClusterId=null, tenantName=sys, username=root, address=10.42.10.161, port=2881, database=oceanbase) 2024-01-11 15:40:42.105 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.o.connector.ObConnectorHolder : [obsdk] ob connector is evicted from holder's cache. cause=EXPLICIT, key=ObConnectorKey(connectionMode=direct, clusterName=zwellinfo_cluster, obClusterId=null, tenantName=sys, username=root, address=10.42.10.161, port=2881, database=oceanbase) 2024-01-11 15:40:42.112 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] com.alibaba.druid.pool.DruidDataSource : {dataSource-128} closing ... 2024-01-11 15:40:42.124 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] com.alibaba.druid.pool.DruidDataSource : {dataSource-128} closed 2024-01-11 15:40:42.131 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.o.connector.ObConnectorHolder : [obsdk] invalidate ob connector, key=ObConnectorKey(connectionMode=direct, clusterName=zwellinfo_cluster, obClusterId=null, tenantName=sys, username=root, address=10.42.10.161, port=2881, database=oceanbase) 2024-01-11 15:40:42.135 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.o.connector.ObConnectorHolder : [obsdk] ob connector is evicted from holder's cache. cause=EXPLICIT, key=ObConnectorKey(connectionMode=direct, clusterName=zwellinfo_cluster, obClusterId=null, tenantName=sys, username=root, address=10.42.10.161, port=2881, database=oceanbase) 2024-01-11 15:40:42.139 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] com.alibaba.druid.pool.DruidDataSource : {dataSource-127} closing ... 2024-01-11 15:40:42.148 ERROR 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.d.stat.DruidDataSourceStatManager : unregister mbean error javax.management.InstanceNotFoundException: com.alibaba.druid:type=DruidDataSource,id=ob-connector-datasource_direct_sys_root_10.42.10.161_2881 at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.getMBean(DefaultMBeanServerInterceptor.java:1095) ~[na:1.8.0_312] at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.exclusiveUnregisterMBean(DefaultMBeanServerInterceptor.java:427) ~[na:1.8.0_312] at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.unregisterMBean(DefaultMBeanServerInterceptor.java:415) ~[na:1.8.0_312] at com.sun.jmx.mbeanserver.JmxMBeanServer.unregisterMBean(JmxMBeanServer.java:546) ~[na:1.8.0_312] at com.alibaba.druid.stat.DruidDataSourceStatManager.removeDataSource(DruidDataSourceStatManager.java:202) ~[druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.pool.DruidDataSource$2.run(DruidDataSource.java:2172) [druid-1.2.8.jar!/:1.2.8] at java.security.AccessController.doPrivileged(Native Method) [na:1.8.0_312] at com.alibaba.druid.pool.DruidDataSource.unregisterMbean(DruidDataSource.java:2168) [druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.pool.DruidDataSource.close(DruidDataSource.java:2124) [druid-1.2.8.jar!/:1.2.8] at com.alibaba.druid.util.JdbcUtils.close(JdbcUtils.java:131) [druid-1.2.8.jar!/:1.2.8] at com.alipay.ocp.core.obsdk.connector.impl.AbstractConnector.close(AbstractConnector.java:110) [ocp-core-3.3.4-20221201.jar!/:3.3.4-20221201] at com.alipay.ocp.core.obsdk.connector.impl.DefaultConnector.close(DefaultConnector.java:13) [ocp-core-3.3.4-20221201.jar!/:3.3.4-20221201] at com.alipay.ocp.core.obsdk.connector.ObConnectorHolder$1.delete(ObConnectorHolder.java:70) [ocp-core-3.3.4-20221201.jar!/:3.3.4-20221201] at com.alipay.ocp.core.obsdk.connector.ObConnectorHolder$1.delete(ObConnectorHolder.java:45) [ocp-core-3.3.4-20221201.jar!/:3.3.4-20221201] at com.github.benmanes.caffeine.cache.BoundedLocalCache.la mbda$removeWithWriter$9(BoundedLocalCache.java:2147) [caffeine-2.8.0.jar!/:na] at java.util.concurrent.ConcurrentHashMap.computeIfPresent(ConcurrentHashMap.java:1769) ~[na:1.8.0_312] at com.github.benmanes.caffeine.cache.BoundedLocalCache.removeWithWriter(BoundedLocalCache.java:2137) [caffeine-2.8.0.jar!/:na] at com.github.benmanes.caffeine.cache.BoundedLocalCache.remove(BoundedLocalCache.java:2080) [caffeine-2.8.0.jar!/:na] at com.github.benmanes.caffeine.cache.LocalManualCache.invalidate(LocalManualCache.java:140) ~[caffeine-2.8.0.jar!/:na] at com.alipay.ocp.core.obsdk.connector.ObConnectorHolder.lambda$invalidate$2(ObConnectorHolder.java:154) ~[ocp-core-3.3.4-20221201.jar!/:3.3.4-20221201] at java.lang.Iterable.forEach(Iterable.java:75) ~[na:1.8.0_312] at com.alipay.ocp.core.obsdk.connector.ObConnectorHolder.invalidate(ObConnectorHolder.java:151) ~[ocp-core-3.3.4-20221201.jar!/:3.3.4-20221201] at com.alipay.ocp.core.obsdk.connector.ObConnectorHolder.invalidate(ObConnectorHolder.java:137) ~[ocp-core-3.3.4-20221201.jar!/:3.3.4-20221201] at com.alipay.ocp.core.obsdk.connector.ObConnectors.invalidate(ObConnectors.java:113) ~[ocp-core-3.3.4-20221201.jar!/:3.3.4-20221201] at com.alipay.ocp.service.task.business.cluster.SyncClusterInfoTask.lambda$run$1(SyncClusterInfoTask.java:46) ~[ocp-service-3.3.4-20221201.jar!/:3.3.4-20221201] at com.alipay.ocp.common.pattern.Retry.executeUntilSuccessWithLimit(Retry.java:178) ~[ocp-common-3.3.4-20221201.jar!/:3.3.4-20221201] at com.alipay.ocp.common.pattern.Retry.executeUntilSuccessWithLimit(Retry.java:188) ~[ocp-common-3.3.4-20221201.jar!/:3.3.4-20221201] at com.alipay.ocp.service.task.business.cluster.SyncClusterInfoTask.run(SyncClusterInfoTask.java:44) ~[ocp-service-3.3.4-20221201.jar!/:3.3.4-20221201] at com.alipay.ocp.core.metadb.task.model.SubtaskInstanceEntity.run(SubtaskInstanceEntity.java:225) ~[ocp-core-3.3.4-20221201.jar!/:3.3.4-20221201] at com.alipay.ocp.core.task.engine.runner.JavaTaskRunner.doExecute(JavaTaskRunner.java:26) ~[ocp-core-3.3.4-20221201. jar!/:3.3.4-20221201] at com.alipay.ocp.core.task.engine.runner.JavaTaskRunner.run(JavaTaskRunner.java:20) ~[ocp-core-3.3.4-20221201.jar!/:3.3.4-20221201] at com.alipay.ocp.core.task.engine.runner.RunnerFactory.doRun(RunnerFactory.java:118) ~[ocp-core-3.3.4-20221201.jar!/:3.3.4-20221201] at com.alipay.ocp.core.task.engine.runner.RunnerFactory.redirectOutputIfNotSysSchedule(RunnerFactory.java:190) ~[ocp-core-3.3.4-20221201.jar!/:3.3.4-20221201] at com.alipay.ocp.core.task.engine.runner.RunnerFactory.run(RunnerFactory.java:107) ~[ocp-core-3.3.4-20221201.jar!/:3.3.4-20221201] at com.alipay.ocp.core.task.engine.coordinator.worker.subtask.ReadySubtaskWorker.lambda$submitTask$3(ReadySubtaskWorker.java:122) ~[ocp-core-3.3.4-20221201.jar!/:3.3.4-20221201] at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[na:1.8.0_312] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_312] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_312] at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_312] 2024-01-11 15:40:42.161 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] com.alibaba.druid.pool.DruidDataSource : {dataSource-127} closed 2024-01-11 15:40:42.168 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.o.connector.ObConnectorHolder : [obsdk] invalidate ob connector, key=ObConnectorKey(connectionMode=direct, clusterName=zwellinfo_cluster, obClusterId=1704872017, tenantName=sys, username=ocp_monitor, address=10.42.10.161, port=2881, database=oceanbase) 2024-01-11 15:40:42.173 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.o.connector.ObConnectorHolder : [obsdk] ob connector is evicted from holder's cache. cause=EXPLICIT, key=ObConnectorKey(connectionMode=direct, clusterName=zwellinfo_cluster, obClusterId=1704872017, tenantName=sys, username=ocp_monitor, address=10.42.10.161, port=2881, database=oceanbase) 2024-01-11 15:40:42.180 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] com.alibaba.druid.pool.DruidDataSource : {dataSource-130} closing ... 2024-01-11 15:40:42.190 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] com.alibaba.druid.pool.DruidDataSource : {dataSource-130} closed 2024-01-11 15:40:42.219 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.ob.cluster.ClusterSyncService : sync cluster start, clusterId=8, clusterName=zwellinfo_cluster, obClusterId=1704872017 2024-01-11 15:40:42.262 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, userId=200, clusterName=zwellinfo_cluster, tenantName=sys, dbUser=ocp_monitor 2024-01-11 15:40:42.268 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.o.connector.ObConnectorHolder : [obsdk] no ob connector found in holder, key=ObConnectorKey(connectionMode=direct, clusterName=zwellinfo_cluster, obClusterId=1704872017, tenantName=sys, username=ocp_monitor, address=10.42.10.161, port=2881, database=oceanbase) 2024-01-11 15:40:42.273 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.core.obsdk.connector.ObConnectors : [obsdk] create new ob connector, connectProperties=ConnectProperties(connectionMode=direct, address=null, port=null, obsAddrList=[ObServerAddr(address=10.42.10.161, port=2881)], username=ocp_monitor, tenantName=sys, clusterName=zwellinfo_cluster, obClusterId=1704872017, proxy=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase) 2024-01-11 15:40:42.285 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.core.obsdk.connector.ObConnectors : [obsdk] create new ob connector success 2024-01-11 15:40:42.291 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-01-11 15:40:42.296 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: select /** QUERY_TIMEOUT(60000000) */ max(value) value from oceanbase.__all_virtual_sys_parameter_stat where name = 'min_observer_version' 2024-01-11 15:40:42.301 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-01-11 15:40:42.306 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT `zone`, MAX(CASE `name` WHEN 'region' THEN `info` ELSE '' END ) `region`, MAX(CASE `name` WHEN 'idc' THEN `info` ELSE '' END ) `idc`, MAX(CASE `name` WHEN 'status' THEN `info` ELSE '' END ) `status`, MAX(CASE `name` WHEN 'merge_status' THEN `info` ELSE '' END ) `merge_status`, MAX(CASE `name` WHEN 'broadcast_version' THEN `value` ELSE 0 END ) `broadcast_version`, MAX(CASE `name` WHEN 'all_merged_version' THEN `value` ELSE 0 END ) `all_merged_version`, MAX(CASE `name` WHEN 'last_merged_version' THEN `value` ELSE 0 END ) `last_merged_version`, MAX(CASE `name` WHEN 'merge_start_time' THEN `value` ELSE 0 END ) `merge_start_time`, MAX(CASE `name` WHEN 'last_merged_time' THEN `value` ELSE 0 END ) `last_merged_time`, MAX(CASE `name` WHEN 'is_merge_timeout' THEN `value` ELSE 0 END ) `merge_timeout` FROM oceanbase.__all_zone WHERE `zone` <> '' GROUP BY `zone` 2024-01-11 15:40:42.311 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-01-11 15:40:42.315 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT zone, gmt_create, gmt_modified, svr_ip, svr_port, inner_port, with_rootserver, UPPER(`status`) as `status`, build_version, stop_time, start_service_time, last_offline_time, block_migrate_in_time, id FROM oceanbase.__all_server ORDER BY zone ASC, id ASC 2024-01-11 15:40:42.320 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.alipay.ocp.core.obsdk.util.ObSdkUtils : check observer active, observer=10.42.10.161:2882, status=ACTIVE, startServiceTime=1704958832006639, active=true 2024-01-11 15:40:42.324 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.alipay.ocp.core.obsdk.util.ObSdkUtils : check observer stopped, observer=10.42.10.161:2882, stopTime=0, stopped=false 2024-01-11 15:40:42.329 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.ob.cluster.ClusterSyncService : get current info from ob cluster, clusterId=8 2024-01-11 15:40:42.333 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.ob.cluster.ClusterSyncService : detect zone changed, before=ObZoneEntity{id=20, name=zone1, idcId=1, status=RUNNING, innerStatus=ACTIVE, compactionStatus=null, startTime=null, stopTime=null}, current=ObZoneEntity{id=null, name=zone1, idcId=1, status=RUNNING, innerStatus=ACTIVE, compactionStatus=null, startTime=null, stopTime=null} 2024-01-11 15:40:42.351 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.ob.cluster.ClusterSyncService : zone updated, zoneName=zone1 2024-01-11 15:40:42.356 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.ob.cluster.ClusterSyncService : detect server changed, before=ObServerEntity{id=20, ip=10.42.10.161, port=2882, sqlPort=2881, version=4.2.1.2_102000042023120514-ccdde7d34de421336c5362483d64bf2b73348bd4(Dec 5 2023 14:34:01), withRootserver=true, hostId=2, status=RUNNING, innerStatus=ACTIVE, startTime=2024-01-11T15:40:32+08:00, stopTime=1970-01-01T08:00+08:00}, current=ObServerEntity{id=null, ip=10.42.10.161, port=2882, sqlPort=2881, version=4.2.1.2_102000042023120514-ccdde7d34de421336c5362483d64bf2b73348bd4(Dec 5 2023 14:34:01), withRootserver=true, hostId=2, status=RUNNING, innerStatus=ACTIVE, startTime=2024-01-11T07:40:32.006639Z, stopTime=1970-01-01T00:00Z} 2024-01-11 15:40:42.382 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.ob.cluster.ClusterSyncService : update zones and servers done, clusterId=8, clusterName=zwellinfo_cluster, obClusterId=1704872017 2024-01-11 15:40:42.386 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.ob.cluster.ClusterSyncService : sync cluster start, clusterId=8, clusterName=zwellinfo_cluster, obClusterId=1704872017 2024-01-11 15:40:42.409 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, userId=200, clusterName=zwellinfo_cluster, tenantName=sys, dbUser=ocp_monitor 2024-01-11 15:40:42.415 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-01-11 15:40:42.420 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: select /** QUERY_TIMEOUT(60000000) */ max(value) value from oceanbase.__all_virtual_sys_parameter_stat where name = 'min_observer_version' 2024-01-11 15:40:42.425 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-01-11 15:40:42.429 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: select /** QUERY_TIMEOUT(60000000) */ max(value) value from oceanbase.__all_virtual_sys_parameter_stat where name = 'min_observer_version' 2024-01-11 15:40:42.435 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-01-11 15:40:42.439 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT cluster_id, cluster_name, created, cluster_role, cluster_status, current_scn, standby_became_primary_scn, primary_cluster_id, (time_to_usec(now(6)) - current_scn)/1000000 as delay_time, protection_mode, redo_transport_options, protection_level FROM oceanbase.v$ob_cluster 2024-01-11 15:40:42.444 ERROR 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] queryForObject failed, sql:[SELECT cluster_id, cluster_name, created, cluster_role, cluster_status, current_scn, standby_became_primary_scn, primary_cluster_id, (time_to_usec(now(6)) - current_scn)/1000000 as delay_time, protection_mode, redo_transport_options, protection_level FROM oceanbase.v$ob_cluster], error message:[StatementCallback; bad SQL grammar [SELECT cluster_id, cluster_name, created, cluster_role, cluster_status, current_scn, standby_became_primary_scn, primary_cluster_id, (time_to_usec(now(6)) - current_scn)/1000000 as delay_time, protection_mode, redo_transport_options, protection_level FROM oceanbase.v$ob_cluster]; nested exception is java.sql.SQLSyntaxErrorException: (conn=3221487618) Table 'oceanbase.v$ob_cluster' doesn't exist] 2024-01-11 15:40:42.448 WARN 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] com.alipay.ocp.common.pattern.Retry : failed to execute target runnable, errMsg:(conn=3221487618) Table 'oceanbase.v$ob_cluster' doesn't exist 2024-01-11 15:40:42.451 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] com.alipay.ocp.common.pattern.Retry : wait for 5 seconds 2024-01-11 15:40:47.455 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.o.connector.ObConnectorHolder : [obsdk] invalidate ob connector, clusterName=zwellinfo_cluster 2024-01-11 15:40:47.463 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.o.connector.ObConnectorHolder : [obsdk] invalidate ob connector, key=ObConnectorKey(connectionMode=direct, clusterName=zwellinfo_cluster, obClusterId=1704872017, tenantName=sys, username=ocp_monitor, address=10.42.10.161, port=2881, database=oceanbase) 2024-01-11 15:40:47.468 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.o.connector.ObConnectorHolder : [obsdk] ob connector is evicted from holder's cache. cause=EXPLICIT, key=ObConnectorKey(connectionMode=direct, clusterName=zwellinfo_cluster, obClusterId=1704872017, tenantName=sys, username=ocp_monitor, address=10.42.10.161, port=2881, database=oceanbase) 2024-01-11 15:40:47.474 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] com.alibaba.druid.pool.DruidDataSource : {dataSource-131} closing ... 2024-01-11 15:40:47.486 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] com.alibaba.druid.pool.DruidDataSource : {dataSource-131} closed 2024-01-11 15:40:47.511 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.ob.cluster.ClusterSyncService : sync cluster start, clusterId=8, clusterName=zwellinfo_cluster, obClusterId=1704872017 2024-01-11 15:40:47.608 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, userId=200, clusterName=zwellinfo_cluster, tenantName=sys, dbUser=ocp_monitor 2024-01-11 15:40:47.620 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.o.connector.ObConnectorHolder : [obsdk] no ob connector found in holder, key=ObConnectorKey(connectionMode=direct, clusterName=zwellinfo_cluster, obClusterId=1704872017, tenantName=sys, username=ocp_monitor, address=10.42.10.161, port=2881, database=oceanbase) 2024-01-11 15:40:47.627 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.core.obsdk.connector.ObConnectors : [obsdk] create new ob connector, connectProperties=ConnectProperties(connectionMode=direct, address=null, port=null, obsAddrList=[ObServerAddr(address=10.42.10.161, port=2881)], username=ocp_monitor, tenantName=sys, clusterName=zwellinfo_cluster, obClusterId=1704872017, proxy=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase) 2024-01-11 15:40:47.649 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.core.obsdk.connector.ObConnectors : [obsdk] create new ob connector success 2024-01-11 15:40:47.657 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-01-11 15:40:47.667 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: select /** QUERY_TIMEOUT(60000000) */ max(value) value from oceanbase.__all_virtual_sys_parameter_stat where name = 'min_observer_version' 2024-01-11 15:40:47.679 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-01-11 15:40:47.685 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT `zone`, MAX(CASE `name` WHEN 'region' THEN `info` ELSE '' END ) `region`, MAX(CASE `name` WHEN 'idc' THEN `info` ELSE '' END ) `idc`, MAX(CASE `name` WHEN 'status' THEN `info` ELSE '' END ) `status`, MAX(CASE `name` WHEN 'merge_status' THEN `info` ELSE '' END ) `merge_status`, MAX(CASE `name` WHEN 'broadcast_version' THEN `value` ELSE 0 END ) `broadcast_version`, MAX(CASE `name` WHEN 'all_merged_version' THEN `value` ELSE 0 END ) `all_merged_version`, MAX(CASE `name` WHEN 'last_merged_version' THEN `value` ELSE 0 END ) `last_merged_version`, MAX(CASE `name` WHEN 'merge_start_time' THEN `value` ELSE 0 END ) `merge_start_time`, MAX(CASE `name` WHEN 'last_merged_time' THEN `value` ELSE 0 END ) `last_merged_time`, MAX(CASE `name` WHEN 'is_merge_timeout' THEN `value` ELSE 0 END ) `merge_timeout` FROM oceanbase.__all_zone WHERE `zone` <> '' GROUP BY `zone` 2024-01-11 15:40:47.706 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-01-11 15:40:47.715 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT zone, gmt_create, gmt_modified, svr_ip, svr_port, inner_port, with_rootserver, UPPER(`status`) as `status`, build_version, stop_time, start_service_time, last_offline_time, block_migrate_in_time, id FROM oceanbase.__all_server ORDER BY zone ASC, id ASC 2024-01-11 15:40:47.724 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.alipay.ocp.core.obsdk.util.ObSdkUtils : check observer active, observer=10.42.10.161:2882, status=ACTIVE, startServiceTime=1704958832006639, active=true 2024-01-11 15:40:47.729 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.alipay.ocp.core.obsdk.util.ObSdkUtils : check observer stopped, observer=10.42.10.161:2882, stopTime=0, stopped=false 2024-01-11 15:40:47.742 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.ob.cluster.ClusterSyncService : get current info from ob cluster, clusterId=8 2024-01-11 15:40:47.747 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.ob.cluster.ClusterSyncService : detect zone changed, before=ObZoneEntity{id=20, name=zone1, idcId=1, status=RUNNING, innerStatus=ACTIVE, compactionStatus=null, startTime=null, stopTime=null}, current=ObZoneEntity{id=null, name=zone1, idcId=1, status=RUNNING, innerStatus=ACTIVE, compactionStatus=null, startTime=null, stopTime=null} 2024-01-11 15:40:47.768 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.ob.cluster.ClusterSyncService : zone updated, zoneName=zone1 2024-01-11 15:40:47.773 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.ob.cluster.ClusterSyncService : detect server changed, before=ObServerEntity{id=20, ip=10.42.10.161, port=2882, sqlPort=2881, version=4.2.1.2_102000042023120514-ccdde7d34de421336c5362483d64bf2b73348bd4(Dec 5 2023 14:34:01), withRootserver=true, hostId=2, status=RUNNING, innerStatus=ACTIVE, startTime=2024-01-11T15:40:32+08:00, stopTime=1970-01-01T08:00+08:00}, current=ObServerEntity{id=null, ip=10.42.10.161, port=2882, sqlPort=2881, version=4.2.1.2_102000042023120514-ccdde7d34de421336c5362483d64bf2b73348bd4(Dec 5 2023 14:34:01), withRootserver=true, hostId=2, status=RUNNING, innerStatus=ACTIVE, startTime=2024-01-11T07:40:32.006639Z, stopTime=1970-01-01T00:00Z} 2024-01-11 15:40:47.798 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.ob.cluster.ClusterSyncService : update zones and servers done, clusterId=8, clusterName=zwellinfo_cluster, obClusterId=1704872017 2024-01-11 15:40:47.803 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.ob.cluster.ClusterSyncService : sync cluster start, clusterId=8, clusterName=zwellinfo_cluster, obClusterId=1704872017 2024-01-11 15:40:47.828 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, userId=200, clusterName=zwellinfo_cluster, tenantName=sys, dbUser=ocp_monitor 2024-01-11 15:40:47.836 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-01-11 15:40:47.843 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: select /** QUERY_TIMEOUT(60000000) */ max(value) value from oceanbase.__all_virtual_sys_parameter_stat where name = 'min_observer_version' 2024-01-11 15:40:47.849 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-01-11 15:40:47.854 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: select /** QUERY_TIMEOUT(60000000) */ max(value) value from oceanbase.__all_virtual_sys_parameter_stat where name = 'min_observer_version' 2024-01-11 15:40:47.861 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-01-11 15:40:47.868 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT cluster_id, cluster_name, created, cluster_role, cluster_status, current_scn, standby_became_primary_scn, primary_cluster_id, (time_to_usec(now(6)) - current_scn)/1000000 as delay_time, protection_mode, redo_transport_options, protection_level FROM oceanbase.v$ob_cluster 2024-01-11 15:40:47.912 ERROR 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] queryForObject failed, sql:[SELECT cluster_id, cluster_name, created, cluster_role, cluster_status, current_scn, standby_became_primary_scn, primary_cluster_id, (time_to_usec(now(6)) - current_scn)/1000000 as delay_time, protection_mode, redo_transport_options, protection_level FROM oceanbase.v$ob_cluster], error message:[StatementCallback; bad SQL grammar [SELECT cluster_id, cluster_name, created, cluster_role, cluster_status, current_scn, standby_became_primary_scn, primary_cluster_id, (time_to_usec(now(6)) - current_scn)/1000000 as delay_time, protection_mode, redo_transport_options, protection_level FROM oceanbase.v$ob_cluster]; nested exception is java.sql.SQLSyntaxErrorException: (conn=3221487619) Table 'oceanbase.v$ob_cluster' doesn't exist] 2024-01-11 15:40:47.921 WARN 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] com.alipay.ocp.common.pattern.Retry : failed to execute target runnable, errMsg:(conn=3221487619) Table 'oceanbase.v$ob_cluster' doesn't exist 2024-01-11 15:40:47.929 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] com.alipay.ocp.common.pattern.Retry : wait for 5 seconds 2024-01-11 15:40:52.936 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.o.connector.ObConnectorHolder : [obsdk] invalidate ob connector, clusterName=zwellinfo_cluster 2024-01-11 15:40:52.959 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.o.connector.ObConnectorHolder : [obsdk] invalidate ob connector, key=ObConnectorKey(connectionMode=direct, clusterName=zwellinfo_cluster, obClusterId=1704872017, tenantName=sys, username=ocp_monitor, address=10.42.10.161, port=2881, database=oceanbase) 2024-01-11 15:40:52.973 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.o.connector.ObConnectorHolder : [obsdk] ob connector is evicted from holder's cache. cause=EXPLICIT, key=ObConnectorKey(connectionMode=direct, clusterName=zwellinfo_cluster, obClusterId=1704872017, tenantName=sys, username=ocp_monitor, address=10.42.10.161, port=2881, database=oceanbase) 2024-01-11 15:40:52.983 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] com.alibaba.druid.pool.DruidDataSource : {dataSource-132} closing ... 2024-01-11 15:40:52.994 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] com.alibaba.druid.pool.DruidDataSource : {dataSource-132} closed 2024-01-11 15:40:53.028 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.ob.cluster.ClusterSyncService : sync cluster start, clusterId=8, clusterName=zwellinfo_cluster, obClusterId=1704872017 2024-01-11 15:40:53.085 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, userId=200, clusterName=zwellinfo_cluster, tenantName=sys, dbUser=ocp_monitor 2024-01-11 15:40:53.096 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.o.connector.ObConnectorHolder : [obsdk] no ob connector found in holder, key=ObConnectorKey(connectionMode=direct, clusterName=zwellinfo_cluster, obClusterId=1704872017, tenantName=sys, username=ocp_monitor, address=10.42.10.161, port=2881, database=oceanbase) 2024-01-11 15:40:53.101 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.core.obsdk.connector.ObConnectors : [obsdk] create new ob connector, connectProperties=ConnectProperties(connectionMode=direct, address=null, port=null, obsAddrList=[ObServerAddr(address=10.42.10.161, port=2881)], username=ocp_monitor, tenantName=sys, clusterName=zwellinfo_cluster, obClusterId=1704872017, proxy=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase) 2024-01-11 15:40:53.133 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.core.obsdk.connector.ObConnectors : [obsdk] create new ob connector success 2024-01-11 15:40:53.147 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-01-11 15:40:53.155 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: select /** QUERY_TIMEOUT(60000000) */ max(value) value from oceanbase.__all_virtual_sys_parameter_stat where name = 'min_observer_version' 2024-01-11 15:40:53.163 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-01-11 15:40:53.168 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT `zone`, MAX(CASE `name` WHEN 'region' THEN `info` ELSE '' END ) `region`, MAX(CASE `name` WHEN 'idc' THEN `info` ELSE '' END ) `idc`, MAX(CASE `name` WHEN 'status' THEN `info` ELSE '' END ) `status`, MAX(CASE `name` WHEN 'merge_status' THEN `info` ELSE '' END ) `merge_status`, MAX(CASE `name` WHEN 'broadcast_version' THEN `value` ELSE 0 END ) `broadcast_version`, MAX(CASE `name` WHEN 'all_merged_version' THEN `value` ELSE 0 END ) `all_merged_version`, MAX(CASE `name` WHEN 'last_merged_version' THEN `value` ELSE 0 END ) `last_merged_version`, MAX(CASE `name` WHEN 'merge_start_time' THEN `value` ELSE 0 END ) `merge_start_time`, MAX(CASE `name` WHEN 'last_merged_time' THEN `value` ELSE 0 END ) `last_merged_time`, MAX(CASE `name` WHEN 'is_merge_timeout' THEN `value` ELSE 0 END ) `merge_timeout` FROM oceanbase.__all_zone WHERE `zone` <> '' GROUP BY `zone` 2024-01-11 15:40:53.175 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-01-11 15:40:53.181 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT zone, gmt_create, gmt_modified, svr_ip, svr_port, inner_port, with_rootserver, UPPER(`status`) as `status`, build_version, stop_time, start_service_time, last_offline_time, block_migrate_in_time, id FROM oceanbase.__all_server ORDER BY zone ASC, id ASC 2024-01-11 15:40:53.187 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.alipay.ocp.core.obsdk.util.ObSdkUtils : check observer active, observer=10.42.10.161:2882, status=ACTIVE, startServiceTime=1704958832006639, active=true 2024-01-11 15:40:53.192 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.alipay.ocp.core.obsdk.util.ObSdkUtils : check observer stopped, observer=10.42.10.161:2882, stopTime=0, stopped=false 2024-01-11 15:40:53.197 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.ob.cluster.ClusterSyncService : get current info from ob cluster, clusterId=8 2024-01-11 15:40:53.202 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.ob.cluster.ClusterSyncService : detect zone changed, before=ObZoneEntity{id=20, name=zone1, idcId=1, status=RUNNING, innerStatus=ACTIVE, compactionStatus=null, startTime=null, stopTime=null}, current=ObZoneEntity{id=null, name=zone1, idcId=1, status=RUNNING, innerStatus=ACTIVE, compactionStatus=null, startTime=null, stopTime=null} 2024-01-11 15:40:53.229 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.ob.cluster.ClusterSyncService : zone updated, zoneName=zone1 2024-01-11 15:40:53.235 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.ob.cluster.ClusterSyncService : detect server changed, before=ObServerEntity{id=20, ip=10.42.10.161, port=2882, sqlPort=2881, version=4.2.1.2_102000042023120514-ccdde7d34de421336c5362483d64bf2b73348bd4(Dec 5 2023 14:34:01), withRootserver=true, hostId=2, status=RUNNING, innerStatus=ACTIVE, startTime=2024-01-11T15:40:32+08:00, stopTime=1970-01-01T08:00+08:00}, current=ObServerEntity{id=null, ip=10.42.10.161, port=2882, sqlPort=2881, version=4.2.1.2_102000042023120514-ccdde7d34de421336c5362483d64bf2b73348bd4(Dec 5 2023 14:34:01), withRootserver=true, hostId=2, status=RUNNING, innerStatus=ACTIVE, startTime=2024-01-11T07:40:32.006639Z, stopTime=1970-01-01T00:00Z} 2024-01-11 15:40:53.260 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.ob.cluster.ClusterSyncService : update zones and servers done, clusterId=8, clusterName=zwellinfo_cluster, obClusterId=1704872017 2024-01-11 15:40:53.264 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.ob.cluster.ClusterSyncService : sync cluster start, clusterId=8, clusterName=zwellinfo_cluster, obClusterId=1704872017 2024-01-11 15:40:53.298 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, userId=200, clusterName=zwellinfo_cluster, tenantName=sys, dbUser=ocp_monitor 2024-01-11 15:40:53.306 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-01-11 15:40:53.311 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: select /** QUERY_TIMEOUT(60000000) */ max(value) value from oceanbase.__all_virtual_sys_parameter_stat where name = 'min_observer_version' 2024-01-11 15:40:53.317 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-01-11 15:40:53.322 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: select /** QUERY_TIMEOUT(60000000) */ max(value) value from oceanbase.__all_virtual_sys_parameter_stat where name = 'min_observer_version' 2024-01-11 15:40:53.329 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-01-11 15:40:53.334 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT cluster_id, cluster_name, created, cluster_role, cluster_status, current_scn, standby_became_primary_scn, primary_cluster_id, (time_to_usec(now(6)) - current_scn)/1000000 as delay_time, protection_mode, redo_transport_options, protection_level FROM oceanbase.v$ob_cluster 2024-01-11 15:40:53.340 ERROR 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] queryForObject failed, sql:[SELECT cluster_id, cluster_name, created, cluster_role, cluster_status, current_scn, standby_became_primary_scn, primary_cluster_id, (time_to_usec(now(6)) - current_scn)/1000000 as delay_time, protection_mode, redo_transport_options, protection_level FROM oceanbase.v$ob_cluster], error message:[StatementCallback; bad SQL grammar [SELECT cluster_id, cluster_name, created, cluster_role, cluster_status, current_scn, standby_became_primary_scn, primary_cluster_id, (time_to_usec(now(6)) - current_scn)/1000000 as delay_time, protection_mode, redo_transport_options, protection_level FROM oceanbase.v$ob_cluster]; nested exception is java.sql.SQLSyntaxErrorException: (conn=3221487620) Table 'oceanbase.v$ob_cluster' doesn't exist] 2024-01-11 15:40:53.352 WARN 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] com.alipay.ocp.common.pattern.Retry : failed to execute target runnable, errMsg:(conn=3221487620) Table 'oceanbase.v$ob_cluster' doesn't exist 2024-01-11 15:40:53.357 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] com.alipay.ocp.common.pattern.Retry : wait for 5 seconds 2024-01-11 15:40:58.362 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.o.connector.ObConnectorHolder : [obsdk] invalidate ob connector, clusterName=zwellinfo_cluster 2024-01-11 15:40:58.368 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.o.connector.ObConnectorHolder : [obsdk] invalidate ob connector, key=ObConnectorKey(connectionMode=direct, clusterName=zwellinfo_cluster, obClusterId=1704872017, tenantName=sys, username=ocp_monitor, address=10.42.10.161, port=2881, database=oceanbase) 2024-01-11 15:40:58.374 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.o.connector.ObConnectorHolder : [obsdk] ob connector is evicted from holder's cache. cause=EXPLICIT, key=ObConnectorKey(connectionMode=direct, clusterName=zwellinfo_cluster, obClusterId=1704872017, tenantName=sys, username=ocp_monitor, address=10.42.10.161, port=2881, database=oceanbase) 2024-01-11 15:40:58.378 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] com.alibaba.druid.pool.DruidDataSource : {dataSource-133} closing ... 2024-01-11 15:40:58.391 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] com.alibaba.druid.pool.DruidDataSource : {dataSource-133} closed 2024-01-11 15:40:58.418 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.ob.cluster.ClusterSyncService : sync cluster start, clusterId=8, clusterName=zwellinfo_cluster, obClusterId=1704872017 2024-01-11 15:40:58.468 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, userId=200, clusterName=zwellinfo_cluster, tenantName=sys, dbUser=ocp_monitor 2024-01-11 15:40:58.475 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.o.connector.ObConnectorHolder : [obsdk] no ob connector found in holder, key=ObConnectorKey(connectionMode=direct, clusterName=zwellinfo_cluster, obClusterId=1704872017, tenantName=sys, username=ocp_monitor, address=10.42.10.161, port=2881, database=oceanbase) 2024-01-11 15:40:58.479 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.core.obsdk.connector.ObConnectors : [obsdk] create new ob connector, connectProperties=ConnectProperties(connectionMode=direct, address=null, port=null, obsAddrList=[ObServerAddr(address=10.42.10.161, port=2881)], username=ocp_monitor, tenantName=sys, clusterName=zwellinfo_cluster, obClusterId=1704872017, proxy=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase) 2024-01-11 15:40:58.495 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.core.obsdk.connector.ObConnectors : [obsdk] create new ob connector success 2024-01-11 15:40:58.502 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-01-11 15:40:58.508 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: select /** QUERY_TIMEOUT(60000000) */ max(value) value from oceanbase.__all_virtual_sys_parameter_stat where name = 'min_observer_version' 2024-01-11 15:40:58.516 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-01-11 15:40:58.521 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT `zone`, MAX(CASE `name` WHEN 'region' THEN `info` ELSE '' END ) `region`, MAX(CASE `name` WHEN 'idc' THEN `info` ELSE '' END ) `idc`, MAX(CASE `name` WHEN 'status' THEN `info` ELSE '' END ) `status`, MAX(CASE `name` WHEN 'merge_status' THEN `info` ELSE '' END ) `merge_status`, MAX(CASE `name` WHEN 'broadcast_version' THEN `value` ELSE 0 END ) `broadcast_version`, MAX(CASE `name` WHEN 'all_merged_version' THEN `value` ELSE 0 END ) `all_merged_version`, MAX(CASE `name` WHEN 'last_merged_version' THEN `value` ELSE 0 END ) `last_merged_version`, MAX(CASE `name` WHEN 'merge_start_time' THEN `value` ELSE 0 END ) `merge_start_time`, MAX(CASE `name` WHEN 'last_merged_time' THEN `value` ELSE 0 END ) `last_merged_time`, MAX(CASE `name` WHEN 'is_merge_timeout' THEN `value` ELSE 0 END ) `merge_timeout` FROM oceanbase.__all_zone WHERE `zone` <> '' GROUP BY `zone` 2024-01-11 15:40:58.528 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-01-11 15:40:58.534 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT zone, gmt_create, gmt_modified, svr_ip, svr_port, inner_port, with_rootserver, UPPER(`status`) as `status`, build_version, stop_time, start_service_time, last_offline_time, block_migrate_in_time, id FROM oceanbase.__all_server ORDER BY zone ASC, id ASC 2024-01-11 15:40:58.540 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.alipay.ocp.core.obsdk.util.ObSdkUtils : check observer active, observer=10.42.10.161:2882, status=ACTIVE, startServiceTime=1704958832006639, active=true 2024-01-11 15:40:58.546 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.alipay.ocp.core.obsdk.util.ObSdkUtils : check observer stopped, observer=10.42.10.161:2882, stopTime=0, stopped=false 2024-01-11 15:40:58.553 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.ob.cluster.ClusterSyncService : get current info from ob cluster, clusterId=8 2024-01-11 15:40:58.559 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.ob.cluster.ClusterSyncService : detect zone changed, before=ObZoneEntity{id=20, name=zone1, idcId=1, status=RUNNING, innerStatus=ACTIVE, compactionStatus=null, startTime=null, stopTime=null}, current=ObZoneEntity{id=null, name=zone1, idcId=1, status=RUNNING, innerStatus=ACTIVE, compactionStatus=null, startTime=null, stopTime=null} 2024-01-11 15:40:58.586 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.ob.cluster.ClusterSyncService : zone updated, zoneName=zone1 2024-01-11 15:40:58.596 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.ob.cluster.ClusterSyncService : detect server changed, before=ObServerEntity{id=20, ip=10.42.10.161, port=2882, sqlPort=2881, version=4.2.1.2_102000042023120514-ccdde7d34de421336c5362483d64bf2b73348bd4(Dec 5 2023 14:34:01), withRootserver=true, hostId=2, status=RUNNING, innerStatus=ACTIVE, startTime=2024-01-11T15:40:32+08:00, stopTime=1970-01-01T08:00+08:00}, current=ObServerEntity{id=null, ip=10.42.10.161, port=2882, sqlPort=2881, version=4.2.1.2_102000042023120514-ccdde7d34de421336c5362483d64bf2b73348bd4(Dec 5 2023 14:34:01), withRootserver=true, hostId=2, status=RUNNING, innerStatus=ACTIVE, startTime=2024-01-11T07:40:32.006639Z, stopTime=1970-01-01T00:00Z} 2024-01-11 15:40:58.631 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.ob.cluster.ClusterSyncService : update zones and servers done, clusterId=8, clusterName=zwellinfo_cluster, obClusterId=1704872017 2024-01-11 15:40:58.636 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.ob.cluster.ClusterSyncService : sync cluster start, clusterId=8, clusterName=zwellinfo_cluster, obClusterId=1704872017 2024-01-11 15:40:58.675 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, userId=200, clusterName=zwellinfo_cluster, tenantName=sys, dbUser=ocp_monitor 2024-01-11 15:40:58.689 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-01-11 15:40:58.698 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: select /** QUERY_TIMEOUT(60000000) */ max(value) value from oceanbase.__all_virtual_sys_parameter_stat where name = 'min_observer_version' 2024-01-11 15:40:58.704 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-01-11 15:40:58.710 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: select /** QUERY_TIMEOUT(60000000) */ max(value) value from oceanbase.__all_virtual_sys_parameter_stat where name = 'min_observer_version' 2024-01-11 15:40:58.717 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-01-11 15:40:58.724 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT cluster_id, cluster_name, created, cluster_role, cluster_status, current_scn, standby_became_primary_scn, primary_cluster_id, (time_to_usec(now(6)) - current_scn)/1000000 as delay_time, protection_mode, redo_transport_options, protection_level FROM oceanbase.v$ob_cluster 2024-01-11 15:40:58.731 ERROR 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] queryForObject failed, sql:[SELECT cluster_id, cluster_name, created, cluster_role, cluster_status, current_scn, standby_became_primary_scn, primary_cluster_id, (time_to_usec(now(6)) - current_scn)/1000000 as delay_time, protection_mode, redo_transport_options, protection_level FROM oceanbase.v$ob_cluster], error message:[StatementCallback; bad SQL grammar [SELECT cluster_id, cluster_name, created, cluster_role, cluster_status, current_scn, standby_became_primary_scn, primary_cluster_id, (time_to_usec(now(6)) - current_scn)/1000000 as delay_time, protection_mode, redo_transport_options, protection_level FROM oceanbase.v$ob_cluster]; nested exception is java.sql.SQLSyntaxErrorException: (conn=3221487621) Table 'oceanbase.v$ob_cluster' doesn't exist] 2024-01-11 15:40:58.736 WARN 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] com.alipay.ocp.common.pattern.Retry : failed to execute target runnable, errMsg:(conn=3221487621) Table 'oceanbase.v$ob_cluster' doesn't exist 2024-01-11 15:40:58.741 INFO 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.m.t.model.SubtaskInstanceEntity : Set state for subtask: 4092, current state: RUNNING, new state: FAILED 2024-01-11 15:40:58.747 WARN 44 --- [pool-manual-subtask-executor14,a7c48b3ef2a64341,22f099306eab] c.a.o.c.t.engine.runner.RunnerFactory : Execute task failed, subtask=SubtaskInstanceEntity{id=4092, name=Sync cluster info, state=FAILED, operation=EXECUTE, className=com.alipay.ocp.service.task.business.cluster.SyncClusterInfoTask, seriesId=16, startTime=2024-01-11T15:40:36.748+08:00, endTime=2024-01-11T15:40:58.745+08:00} java.lang.RuntimeException: com.alipay.ocp.core.obsdk.exception.OceanBaseException: (conn=3221487621) Table 'oceanbase.v$ob_cluster' doesn't exist at com.alipay.ocp.common.pattern.Retry.executeUntilSuccessWithLimit(Retry.java:173) ~[ocp-common-3.3.4-20221201.jar!/:3.3.4-20221201] at com.alipay.ocp.common.pattern.Retry.executeUntilSuccessWithLimit(Retry.java:188) ~[ocp-common-3.3.4-20221201.jar!/:3.3.4-20221201] at com.alipay.ocp.service.task.business.cluster.SyncClusterInfoTask.run(SyncClusterInfoTask.java:44) ~[ocp-service-3.3.4-20221201.jar!/:3.3.4-20221201] at com.alipay.ocp.core.metadb.task.model.SubtaskInstanceEntity.run(SubtaskInstanceEntity.java:225) ~[ocp-core-3.3.4-20221201.jar!/:3.3.4-20221201] at com.alipay.ocp.core.task.engine.runner.JavaTaskRunner.doExecute(JavaTaskRunner.java:26) ~[ocp-core-3.3.4-20221201.jar!/:3.3.4-20221201] at com.alipay.ocp.core.task.engine.runner.JavaTaskRunner.run(JavaTaskRunner.java:20) ~[ocp-core-3.3.4-20221201.jar!/:3.3.4-20221201] at com.alipay.ocp.core.task.engine.runner.RunnerFactory.doRun(RunnerFactory.java:118) ~[ocp-core-3.3.4-20221201.jar!/:3.3.4-20221201] at com.alipay.ocp.core.task.engine.runner.RunnerFactory.redirectOutputIfNotSysSchedule(RunnerFactory.java:190) ~[ocp-core-3.3.4-20221201.jar!/:3.3.4-20221201] at com.alipay.ocp.core.task.engine.runner.RunnerFactory.run(RunnerFactory.java:107) ~[ocp-core-3.3.4-20221201.jar!/:3.3.4-20221201] at com.alipay.ocp.core.task.engine.coordinator.worker.subtask.ReadySubtaskWorker.lambda$submitTask$3(ReadySubtaskWorker.java:122) ~[ocp-core-3.3.4-20221201.jar!/:3.3.4-20221201] at java.util.concu rrent.FutureTask.run(FutureTask.java:266) ~[na:1.8.0_312] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_312] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_312] at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_312] Caused by: com.alipay.ocp.core.obsdk.exception.OceanBaseException: (conn=3221487621) Table 'oceanbase.v$ob_cluster' doesn't exist at com.alipay.ocp.core.obsdk.connector.ConnectTemplate.customizeException(ConnectTemplate.java:377) ~[ocp-core-3.3.4-20221201.jar!/:3.3.4-20221201] at com.alipay.ocp.core.obsdk.connector.ConnectTemplate.customizeException(ConnectTemplate.java:369) ~[ocp-core-3.3.4-20221201.jar!/:3.3.4-20221201] at com.alipay.ocp.core.obsdk.connector.ConnectTemplate.queryForObject(ConnectTemplate.java:124) ~[ocp-core-3.3.4-20221201.jar!/:3.3.4-20221201] at com.alipay.ocp.core.obsdk.operator.cluster.MysqlClusterOperator.getCluster(MysqlClusterOperator.java:324) ~[ocp-core-3.3.4-20221201.jar!/:3.3.4-20221201] at com.alipay.ocp.service.operation.ob.cluster.ClusterSyncService.updateCluster(ClusterSyncService.java:324) ~[ocp-service-3.3.4-20221201.jar!/:3.3.4-20221201] at com.alipay.ocp.service.operation.ob.cluster.ClusterSyncService.internalSyncCluster(ClusterSyncService.java:248) ~[ocp-service-3.3.4-20221201.jar!/:3.3.4-20221201] at com.alipay.ocp.service.operation.ob.cluster.ClusterSyncService.syncClusterInfo(ClusterSyncService.java:192) ~[ocp-service-3.3.4-20221201.jar!/:3.3.4-20221201] at com.alipay.ocp.service.task.business.cluster.SyncClusterInfoTask.lambda$run$0(SyncClusterInfoTask.java:45) ~[ocp-service-3.3.4-20221201.jar!/:3.3.4-20221201] at com.alipay.ocp.common.pattern.Retry.lambda$executeUntilSuccessWithLimit$0(Retry.java:189) ~[ocp-common-3.3.4-20221201.jar!/:3.3.4-20221201] at com.alipay.ocp.common.pattern.Retry.executeUntilSuccessWithLimit(Retry.java:169) ~[ocp-common-3.3.4-20221201.jar!/:3.3.4-20221201] ... 13 common frames omitted Caused by: java.sql.SQLSyntaxErrorExcep tion: (conn=3221487621) Table 'oceanbase.v$ob_cluster' doesn't exist at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:108) ~[oceanbase-client-2.2.7.jar!/:na] at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:200) ~[oceanbase-client-2.2.7.jar!/:na] at com.oceanbase.jdbc.OceanBaseStatement.executeExceptionEpilogue(OceanBaseStatement.java:304) ~[oceanbase-client-2.2.7.jar!/:na] at com.oceanbase.jdbc.OceanBaseStatement.executeInternal(OceanBaseStatement.java:393) ~[oceanbase-client-2.2.7.jar!/:na] at com.oceanbase.jdbc.OceanBaseStatement.executeQuery(OceanBaseStatement.java:650) ~[oceanbase-client-2.2.7.jar!/:na] at com.alibaba.druid.pool.DruidPooledStatement.executeQuery(DruidPooledStatement.java:308) ~[druid-1.2.8.jar!/:1.2.8] at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439) ~[spring-jdbc-5.2.4.RELEASE.jar!/:5.2.4.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376) ~[spring-jdbc-5.2.4.RELEASE.jar!/:5.2.4.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452) ~[spring-jdbc-5.2.4.RELEASE.jar!/:5.2.4.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:462) ~[spring-jdbc-5.2.4.RELEASE.jar!/:5.2.4.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:473) ~[spring-jdbc-5.2.4.RELEASE.jar!/:5.2.4.RELEASE] at com.alipay.ocp.core.obsdk.connector.ConnectTemplate.queryForObject(ConnectTemplate.java:121) ~[ocp-core-3.3.4-20221201.jar!/:3.3.4-20221201] ... 20 common frames omitted Caused by: com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException: Table 'oceanbase.v$ob_cluster' doesn't exist at com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException.of(OceanBaseSqlException.java:80) ~[oceanbase-client-2.2.7.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.ja va:196) ~[oceanbase-client-2.2.7.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:304) ~[oceanbase-client-2.2.7.jar!/:na] at com.oceanbase.jdbc.OceanBaseStatement.executeInternal(OceanBaseStatement.java:387) ~[oceanbase-client-2.2.7.jar!/:na] ... 28 common frames omitted Caused by: java.sql.SQLException: Table 'oceanbase.v$ob_cluster' doesn't exist at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1975) ~[oceanbase-client-2.2.7.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1840) ~[oceanbase-client-2.2.7.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1730) ~[oceanbase-client-2.2.7.jar!/:na] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:298) ~[oceanbase-client-2.2.7.jar!/:na] ... 29 common frames omitted