[2023-03-28T17:24:34.589] BEGIN dataSource INSTALL - [2023-03-28T17:24:34.603] BEGIN dataSource CREATE_TABLES - 24 [2023-03-28T17:24:34.607] BEGIN dataSource CREATE_TABLES sqls:ob_agent 1 [2023-03-28T17:24:35.189] END dataSource CREATE_TABLES sqls:ob_agent [2023-03-28T17:24:35.189] BEGIN dataSource CREATE_TABLES sqls:credential 1 [2023-03-28T17:24:35.677] END dataSource CREATE_TABLES sqls:credential [2023-03-28T17:24:35.677] BEGIN dataSource CREATE_TABLES sqls:config_properties 1 [2023-03-28T17:24:36.102] END dataSource CREATE_TABLES sqls:config_properties [2023-03-28T17:24:36.102] BEGIN dataSource CREATE_TABLES sqls:metric_data_minute 1 [2023-03-28T17:24:37.082] END dataSource CREATE_TABLES sqls:metric_data_minute [2023-03-28T17:24:37.082] BEGIN dataSource CREATE_TABLES sqls:metric_data_second 1 [2023-03-28T17:24:37.897] END dataSource CREATE_TABLES sqls:metric_data_second [2023-03-28T17:24:37.897] BEGIN dataSource CREATE_TABLES sqls:ocp_metric_series_key_id 1 [2023-03-28T17:24:38.308] END dataSource CREATE_TABLES sqls:ocp_metric_series_key_id [2023-03-28T17:24:38.309] BEGIN dataSource CREATE_TABLES sqls:metric_class 1 [2023-03-28T17:24:38.733] END dataSource CREATE_TABLES sqls:metric_class [2023-03-28T17:24:38.733] BEGIN dataSource CREATE_TABLES sqls:metric_group 1 [2023-03-28T17:24:39.125] END dataSource CREATE_TABLES sqls:metric_group [2023-03-28T17:24:39.125] BEGIN dataSource CREATE_TABLES sqls:metric_meta 1 [2023-03-28T17:24:39.698] END dataSource CREATE_TABLES sqls:metric_meta [2023-03-28T17:24:39.698] BEGIN dataSource CREATE_TABLES sqls:ocp_metric_expr_config 1 [2023-03-28T17:24:40.021] END dataSource CREATE_TABLES sqls:ocp_metric_expr_config [2023-03-28T17:24:40.021] BEGIN dataSource CREATE_TABLES sqls:metric_exporter_address 1 [2023-03-28T17:24:40.450] END dataSource CREATE_TABLES sqls:metric_exporter_address [2023-03-28T17:24:40.450] BEGIN dataSource CREATE_TABLES sqls:iam_user 1 [2023-03-28T17:24:40.928] END dataSource CREATE_TABLES sqls:iam_user [2023-03-28T17:24:40.928] BEGIN dataSource CREATE_TABLES sqls:iam_user_login_record 1 [2023-03-28T17:24:41.370] END dataSource CREATE_TABLES sqls:iam_user_login_record [2023-03-28T17:24:41.371] BEGIN dataSource CREATE_TABLES sqls:profile_credential 1 [2023-03-28T17:24:41.785] END dataSource CREATE_TABLES sqls:profile_credential [2023-03-28T17:24:41.785] BEGIN dataSource CREATE_TABLES sqls:profile_credential_access 1 [2023-03-28T17:24:42.210] END dataSource CREATE_TABLES sqls:profile_credential_access [2023-03-28T17:24:42.211] BEGIN dataSource CREATE_TABLES sqls:ob_tenant 1 [2023-03-28T17:24:42.774] END dataSource CREATE_TABLES sqls:ob_tenant [2023-03-28T17:24:42.774] BEGIN dataSource CREATE_TABLES sqls:ob_tenant_compaction 1 [2023-03-28T17:24:43.175] END dataSource CREATE_TABLES sqls:ob_tenant_compaction [2023-03-28T17:24:43.176] BEGIN dataSource CREATE_TABLES sqls:task_definition 1 [2023-03-28T17:24:43.516] END dataSource CREATE_TABLES sqls:task_definition [2023-03-28T17:24:43.517] BEGIN dataSource CREATE_TABLES sqls:task_template 1 [2023-03-28T17:24:43.908] END dataSource CREATE_TABLES sqls:task_template [2023-03-28T17:24:43.909] BEGIN dataSource CREATE_TABLES sqls:subtask_instance 1 [2023-03-28T17:24:44.648] END dataSource CREATE_TABLES sqls:subtask_instance [2023-03-28T17:24:44.649] BEGIN dataSource CREATE_TABLES sqls:subtask_log 1 [2023-03-28T17:24:45.073] END dataSource CREATE_TABLES sqls:subtask_log [2023-03-28T17:24:45.073] BEGIN dataSource CREATE_TABLES sqls:subtask_dependencies 1 [2023-03-28T17:24:45.479] END dataSource CREATE_TABLES sqls:subtask_dependencies [2023-03-28T17:24:45.480] BEGIN dataSource CREATE_TABLES sqls:task_instance 1 [2023-03-28T17:24:46.186] END dataSource CREATE_TABLES sqls:task_instance [2023-03-28T17:24:46.186] BEGIN dataSource CREATE_TABLES sqls:ocp_instance 1 [2023-03-28T17:24:46.625] END dataSource CREATE_TABLES sqls:ocp_instance [2023-03-28T17:24:46.625] END dataSource CREATE_TABLES - [2023-03-28T17:24:46.814] BEGIN dataSource DEFAULT_DATA - 8 [2023-03-28T17:24:46.815] BEGIN dataSource DEFAULT_DATA sqls:task_template 1 [2023-03-28T17:24:46.984] END dataSource DEFAULT_DATA sqls:task_template [2023-03-28T17:24:46.984] BEGIN dataSource DEFAULT_DATA sqls:task_definition 1 [2023-03-28T17:24:47.125] END dataSource DEFAULT_DATA sqls:task_definition [2023-03-28T17:24:47.126] BEGIN dataSource DEFAULT_DATA sqls:iam_user 2 [2023-03-28T17:24:47.292] END dataSource DEFAULT_DATA sqls:iam_user [2023-03-28T17:24:47.292] BEGIN dataSource DEFAULT_DATA sqls:config_properties 82 [2023-03-28T17:24:49.668] END dataSource DEFAULT_DATA sqls:config_properties [2023-03-28T17:24:49.669] BEGIN dataSource DEFAULT_DATA sqls:ocp_metric_expr_config 246 [2023-03-28T17:24:59.614] END dataSource DEFAULT_DATA sqls:ocp_metric_expr_config java.sql.SQLException: execute sql task failed. task: ocp_metric_expr_config, sql:INSERT INTO `ocp_metric_expr_config`(`metric`,`expr`) VALUES ('opened_cursors_count','sum(delta(ob_sysstat{stat_id=\"40030\",@LABELS}[@INTERVAL])) by (@GBLABELS)') ON DUPLICATE KEY UPDATE `expr`='sum(delta(ob_sysstat{stat_id=\"40030\",@LABELS}[@INTERVAL])) by (@GBLABELS)' at com.oceanbase.ocp.bootstrap.db.DbInitializer.executeSqlTask(DbInitializer.java:216) at com.oceanbase.ocp.bootstrap.db.DbInitializer.writeDefaultData(DbInitializer.java:254) at com.oceanbase.ocp.bootstrap.db.DbInitializer.install(DbInitializer.java:122) at com.oceanbase.ocp.bootstrap.db.DbInitializer.initialize(DbInitializer.java:101) at com.oceanbase.ocp.bootstrap.spring.DBInitInterceptor.afterDataSourceCreation(DBInitInterceptor.java:70) at com.oceanbase.ocp.bootstrap.spring.DataSourceInterceptor.lambda$afterDataSourceCreationHook$0(DataSourceInterceptor.java:43) at java.util.ArrayList.forEach(ArrayList.java:1255) at com.oceanbase.ocp.bootstrap.spring.DataSourceInterceptor.afterDataSourceCreationHook(DataSourceInterceptor.java:41) at com.oceanbase.ocp.bootstrap.spring.DataSourceInterceptor.postProcessAfterInitialization(DataSourceInterceptor.java:34) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsAfterInitialization(AbstractAutowireCapableBeanFactory.java:455) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1808) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:955) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:918) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583) at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:745) at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:420) at org.springframework.boot.SpringApplication.run(SpringApplication.java:307) at org.springframework.boot.builder.SpringApplicationBuilder.run(SpringApplicationBuilder.java:164) at org.springframework.cloud.bootstrap.BootstrapApplicationListener.bootstrapServiceContext(BootstrapApplicationListener.java:195) at org.springframework.cloud.bootstrap.BootstrapApplicationListener.onApplicationEvent(BootstrapApplicationListener.java:114) at org.springframework.cloud.bootstrap.BootstrapApplicationListener.onApplicationEvent(BootstrapApplicationListener.java:77) at org.springframework.context.event.SimpleApplicationEventMulticaster.doInvokeListener(SimpleApplicationEventMulticaster.java:176) at org.springframework.context.event.SimpleApplicationEventMulticaster.invokeListener(SimpleApplicationEventMulticaster.java:169) at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:143) at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:131) at org.springframework.boot.context.event.EventPublishingRunListener.environmentPrepared(EventPublishingRunListener.java:85) at org.springframework.boot.SpringApplicationRunListeners.lambda$environmentPrepared$2(SpringApplicationRunListeners.java:66) at java.util.ArrayList.forEach(ArrayList.java:1255) at org.springframework.boot.SpringApplicationRunListeners.doWithListeners(SpringApplicationRunListeners.java:120) at org.springframework.boot.SpringApplicationRunListeners.doWithListeners(SpringApplicationRunListeners.java:114) at org.springframework.boot.SpringApplicationRunListeners.environmentPrepared(SpringApplicationRunListeners.java:65) at org.springframework.boot.SpringApplication.prepareEnvironment(SpringApplication.java:343) at org.springframework.boot.SpringApplication.run(SpringApplication.java:301) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1317) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1306) at com.oceanbase.ocp.OcpExpressApplication.main(OcpExpressApplication.java:18) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49) at org.springframework.boot.loader.Launcher.launch(Launcher.java:107) at org.springframework.boot.loader.Launcher.launch(Launcher.java:58) at org.springframework.boot.loader.PropertiesLauncher.main(PropertiesLauncher.java:467) Caused by: java.sql.SQLTransientConnectionException: (conn=262196) Timeout, query has reached the maximum query timeout: 10000000(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again. at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:126) at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:200) at com.oceanbase.jdbc.OceanBaseStatement.executeBatchExceptionEpilogue(OceanBaseStatement.java:370) at com.oceanbase.jdbc.OceanBaseStatement.executeBatch(OceanBaseStatement.java:1487) at com.oceanbase.ocp.bootstrap.util.SQLUtils.executeBatch(SQLUtils.java:99) at com.oceanbase.ocp.bootstrap.db.DbInitializer.lambda$new$0(DbInitializer.java:93) at com.oceanbase.ocp.bootstrap.db.DbInitializer.executeSqlTask(DbInitializer.java:203) ... 49 more Caused by: com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException: Timeout, query has reached the maximum query timeout: 10000000(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again. at com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException.of(OceanBaseSqlException.java:80) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:190) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchAggregateSemiColon(AbstractQueryProtocol.java:1084) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchStmt(AbstractQueryProtocol.java:943) at com.oceanbase.jdbc.OceanBaseStatement.internalBatchExecution(OceanBaseStatement.java:1544) at com.oceanbase.jdbc.OceanBaseStatement.executeBatch(OceanBaseStatement.java:1484) ... 52 more Caused by: java.sql.SQLException: Timeout, query has reached the maximum query timeout: 10000000(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again. at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1990) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1855) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1751) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchAggregateSemiColon(AbstractQueryProtocol.java:1080) ... 55 more [2023-03-28T17:24:59.618] END dataSource INSTALL - java.lang.IllegalStateException: java.sql.SQLException: execute sql task failed. task: ocp_metric_expr_config, sql:INSERT INTO `ocp_metric_expr_config`(`metric`,`expr`) VALUES ('opened_cursors_count','sum(delta(ob_sysstat{stat_id=\"40030\",@LABELS}[@INTERVAL])) by (@GBLABELS)') ON DUPLICATE KEY UPDATE `expr`='sum(delta(ob_sysstat{stat_id=\"40030\",@LABELS}[@INTERVAL])) by (@GBLABELS)' at com.oceanbase.ocp.bootstrap.db.DbInitializer.executeSqlTask(DbInitializer.java:218) at com.oceanbase.ocp.bootstrap.db.DbInitializer.writeDefaultData(DbInitializer.java:254) at com.oceanbase.ocp.bootstrap.db.DbInitializer.install(DbInitializer.java:122) at com.oceanbase.ocp.bootstrap.db.DbInitializer.initialize(DbInitializer.java:101) at com.oceanbase.ocp.bootstrap.spring.DBInitInterceptor.afterDataSourceCreation(DBInitInterceptor.java:70) at com.oceanbase.ocp.bootstrap.spring.DataSourceInterceptor.lambda$afterDataSourceCreationHook$0(DataSourceInterceptor.java:43) at java.util.ArrayList.forEach(ArrayList.java:1255) at com.oceanbase.ocp.bootstrap.spring.DataSourceInterceptor.afterDataSourceCreationHook(DataSourceInterceptor.java:41) at com.oceanbase.ocp.bootstrap.spring.DataSourceInterceptor.postProcessAfterInitialization(DataSourceInterceptor.java:34) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsAfterInitialization(AbstractAutowireCapableBeanFactory.java:455) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1808) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:955) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:918) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583) at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:745) at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:420) at org.springframework.boot.SpringApplication.run(SpringApplication.java:307) at org.springframework.boot.builder.SpringApplicationBuilder.run(SpringApplicationBuilder.java:164) at org.springframework.cloud.bootstrap.BootstrapApplicationListener.bootstrapServiceContext(BootstrapApplicationListener.java:195) at org.springframework.cloud.bootstrap.BootstrapApplicationListener.onApplicationEvent(BootstrapApplicationListener.java:114) at org.springframework.cloud.bootstrap.BootstrapApplicationListener.onApplicationEvent(BootstrapApplicationListener.java:77) at org.springframework.context.event.SimpleApplicationEventMulticaster.doInvokeListener(SimpleApplicationEventMulticaster.java:176) at org.springframework.context.event.SimpleApplicationEventMulticaster.invokeListener(SimpleApplicationEventMulticaster.java:169) at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:143) at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:131) at org.springframework.boot.context.event.EventPublishingRunListener.environmentPrepared(EventPublishingRunListener.java:85) at org.springframework.boot.SpringApplicationRunListeners.lambda$environmentPrepared$2(SpringApplicationRunListeners.java:66) at java.util.ArrayList.forEach(ArrayList.java:1255) at org.springframework.boot.SpringApplicationRunListeners.doWithListeners(SpringApplicationRunListeners.java:120) at org.springframework.boot.SpringApplicationRunListeners.doWithListeners(SpringApplicationRunListeners.java:114) at org.springframework.boot.SpringApplicationRunListeners.environmentPrepared(SpringApplicationRunListeners.java:65) at org.springframework.boot.SpringApplication.prepareEnvironment(SpringApplication.java:343) at org.springframework.boot.SpringApplication.run(SpringApplication.java:301) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1317) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1306) at com.oceanbase.ocp.OcpExpressApplication.main(OcpExpressApplication.java:18) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49) at org.springframework.boot.loader.Launcher.launch(Launcher.java:107) at org.springframework.boot.loader.Launcher.launch(Launcher.java:58) at org.springframework.boot.loader.PropertiesLauncher.main(PropertiesLauncher.java:467) Caused by: java.sql.SQLException: execute sql task failed. task: ocp_metric_expr_config, sql:INSERT INTO `ocp_metric_expr_config`(`metric`,`expr`) VALUES ('opened_cursors_count','sum(delta(ob_sysstat{stat_id=\"40030\",@LABELS}[@INTERVAL])) by (@GBLABELS)') ON DUPLICATE KEY UPDATE `expr`='sum(delta(ob_sysstat{stat_id=\"40030\",@LABELS}[@INTERVAL])) by (@GBLABELS)' at com.oceanbase.ocp.bootstrap.db.DbInitializer.executeSqlTask(DbInitializer.java:216) ... 49 more Caused by: java.sql.SQLTransientConnectionException: (conn=262196) Timeout, query has reached the maximum query timeout: 10000000(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again. at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:126) at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:200) at com.oceanbase.jdbc.OceanBaseStatement.executeBatchExceptionEpilogue(OceanBaseStatement.java:370) at com.oceanbase.jdbc.OceanBaseStatement.executeBatch(OceanBaseStatement.java:1487) at com.oceanbase.ocp.bootstrap.util.SQLUtils.executeBatch(SQLUtils.java:99) at com.oceanbase.ocp.bootstrap.db.DbInitializer.lambda$new$0(DbInitializer.java:93) at com.oceanbase.ocp.bootstrap.db.DbInitializer.executeSqlTask(DbInitializer.java:203) ... 49 more Caused by: com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException: Timeout, query has reached the maximum query timeout: 10000000(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again. at com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException.of(OceanBaseSqlException.java:80) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:190) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchAggregateSemiColon(AbstractQueryProtocol.java:1084) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchStmt(AbstractQueryProtocol.java:943) at com.oceanbase.jdbc.OceanBaseStatement.internalBatchExecution(OceanBaseStatement.java:1544) at com.oceanbase.jdbc.OceanBaseStatement.executeBatch(OceanBaseStatement.java:1484) ... 52 more Caused by: java.sql.SQLException: Timeout, query has reached the maximum query timeout: 10000000(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again. at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1990) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1855) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1751) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchAggregateSemiColon(AbstractQueryProtocol.java:1080) ... 55 more [2023-03-28T17:28:21.639] BEGIN dataSource INSTALL - [2023-03-28T17:28:21.652] BEGIN dataSource CREATE_TABLES - 24 [2023-03-28T17:28:21.656] BEGIN dataSource CREATE_TABLES sqls:credential 1 [2023-03-28T17:28:21.673] END dataSource CREATE_TABLES sqls:credential [2023-03-28T17:28:21.673] BEGIN dataSource CREATE_TABLES sqls:ob_agent 1 [2023-03-28T17:28:21.686] END dataSource CREATE_TABLES sqls:ob_agent [2023-03-28T17:28:21.687] BEGIN dataSource CREATE_TABLES sqls:config_properties 1 [2023-03-28T17:28:21.700] END dataSource CREATE_TABLES sqls:config_properties [2023-03-28T17:28:21.701] BEGIN dataSource CREATE_TABLES sqls:metric_data_minute 1 [2023-03-28T17:28:21.718] END dataSource CREATE_TABLES sqls:metric_data_minute [2023-03-28T17:28:21.719] BEGIN dataSource CREATE_TABLES sqls:metric_data_second 1 [2023-03-28T17:28:21.737] END dataSource CREATE_TABLES sqls:metric_data_second [2023-03-28T17:28:21.738] BEGIN dataSource CREATE_TABLES sqls:ocp_metric_series_key_id 1 [2023-03-28T17:28:21.752] END dataSource CREATE_TABLES sqls:ocp_metric_series_key_id [2023-03-28T17:28:21.753] BEGIN dataSource CREATE_TABLES sqls:ob_tenant 1 [2023-03-28T17:28:21.766] END dataSource CREATE_TABLES sqls:ob_tenant [2023-03-28T17:28:21.766] BEGIN dataSource CREATE_TABLES sqls:ob_tenant_compaction 1 [2023-03-28T17:28:21.777] END dataSource CREATE_TABLES sqls:ob_tenant_compaction [2023-03-28T17:28:21.777] BEGIN dataSource CREATE_TABLES sqls:metric_class 1 [2023-03-28T17:28:21.835] END dataSource CREATE_TABLES sqls:metric_class [2023-03-28T17:28:21.836] BEGIN dataSource CREATE_TABLES sqls:metric_group 1 [2023-03-28T17:28:21.847] END dataSource CREATE_TABLES sqls:metric_group [2023-03-28T17:28:21.847] BEGIN dataSource CREATE_TABLES sqls:metric_meta 1 [2023-03-28T17:28:21.859] END dataSource CREATE_TABLES sqls:metric_meta [2023-03-28T17:28:21.859] BEGIN dataSource CREATE_TABLES sqls:ocp_metric_expr_config 1 [2023-03-28T17:28:21.870] END dataSource CREATE_TABLES sqls:ocp_metric_expr_config [2023-03-28T17:28:21.870] BEGIN dataSource CREATE_TABLES sqls:metric_exporter_address 1 [2023-03-28T17:28:21.880] END dataSource CREATE_TABLES sqls:metric_exporter_address [2023-03-28T17:28:21.881] BEGIN dataSource CREATE_TABLES sqls:iam_user 1 [2023-03-28T17:28:21.894] END dataSource CREATE_TABLES sqls:iam_user [2023-03-28T17:28:21.894] BEGIN dataSource CREATE_TABLES sqls:iam_user_login_record 1 [2023-03-28T17:28:21.904] END dataSource CREATE_TABLES sqls:iam_user_login_record [2023-03-28T17:28:21.904] BEGIN dataSource CREATE_TABLES sqls:profile_credential 1 [2023-03-28T17:28:21.915] END dataSource CREATE_TABLES sqls:profile_credential [2023-03-28T17:28:21.915] BEGIN dataSource CREATE_TABLES sqls:profile_credential_access 1 [2023-03-28T17:28:21.926] END dataSource CREATE_TABLES sqls:profile_credential_access [2023-03-28T17:28:21.926] BEGIN dataSource CREATE_TABLES sqls:task_definition 1 [2023-03-28T17:28:21.937] END dataSource CREATE_TABLES sqls:task_definition [2023-03-28T17:28:21.937] BEGIN dataSource CREATE_TABLES sqls:task_template 1 [2023-03-28T17:28:21.948] END dataSource CREATE_TABLES sqls:task_template [2023-03-28T17:28:21.949] BEGIN dataSource CREATE_TABLES sqls:subtask_instance 1 [2023-03-28T17:28:21.960] END dataSource CREATE_TABLES sqls:subtask_instance [2023-03-28T17:28:21.961] BEGIN dataSource CREATE_TABLES sqls:subtask_log 1 [2023-03-28T17:28:21.971] END dataSource CREATE_TABLES sqls:subtask_log [2023-03-28T17:28:21.971] BEGIN dataSource CREATE_TABLES sqls:subtask_dependencies 1 [2023-03-28T17:28:21.981] END dataSource CREATE_TABLES sqls:subtask_dependencies [2023-03-28T17:28:21.981] BEGIN dataSource CREATE_TABLES sqls:task_instance 1 [2023-03-28T17:28:21.993] END dataSource CREATE_TABLES sqls:task_instance [2023-03-28T17:28:21.994] BEGIN dataSource CREATE_TABLES sqls:ocp_instance 1 [2023-03-28T17:28:22.004] END dataSource CREATE_TABLES sqls:ocp_instance [2023-03-28T17:28:22.005] END dataSource CREATE_TABLES - [2023-03-28T17:28:22.141] BEGIN dataSource DEFAULT_DATA - 8 [2023-03-28T17:28:22.141] BEGIN dataSource DEFAULT_DATA sqls:task_template 1 [2023-03-28T17:28:22.212] END dataSource DEFAULT_DATA sqls:task_template [2023-03-28T17:28:22.212] BEGIN dataSource DEFAULT_DATA sqls:task_definition 1 [2023-03-28T17:28:22.269] END dataSource DEFAULT_DATA sqls:task_definition [2023-03-28T17:28:22.269] BEGIN dataSource DEFAULT_DATA sqls:iam_user 2 [2023-03-28T17:28:22.349] END dataSource DEFAULT_DATA sqls:iam_user [2023-03-28T17:28:22.349] BEGIN dataSource DEFAULT_DATA sqls:config_properties 82 [2023-03-28T17:28:24.215] END dataSource DEFAULT_DATA sqls:config_properties [2023-03-28T17:28:24.216] BEGIN dataSource DEFAULT_DATA sqls:ocp_metric_expr_config 246 [2023-03-28T17:28:34.161] END dataSource DEFAULT_DATA sqls:ocp_metric_expr_config java.sql.SQLException: execute sql task failed. task: ocp_metric_expr_config, sql:INSERT INTO `ocp_metric_expr_config`(`metric`,`expr`) VALUES ('sync_delay_time','max(sync_delay_time{@LABELS}) by (@GBLABELS)') ON DUPLICATE KEY UPDATE `expr`='max(sync_delay_time{@LABELS}) by (@GBLABELS)' at com.oceanbase.ocp.bootstrap.db.DbInitializer.executeSqlTask(DbInitializer.java:216) at com.oceanbase.ocp.bootstrap.db.DbInitializer.writeDefaultData(DbInitializer.java:254) at com.oceanbase.ocp.bootstrap.db.DbInitializer.install(DbInitializer.java:122) at com.oceanbase.ocp.bootstrap.db.DbInitializer.initialize(DbInitializer.java:101) at com.oceanbase.ocp.bootstrap.spring.DBInitInterceptor.afterDataSourceCreation(DBInitInterceptor.java:70) at com.oceanbase.ocp.bootstrap.spring.DataSourceInterceptor.lambda$afterDataSourceCreationHook$0(DataSourceInterceptor.java:43) at java.util.ArrayList.forEach(ArrayList.java:1255) at com.oceanbase.ocp.bootstrap.spring.DataSourceInterceptor.afterDataSourceCreationHook(DataSourceInterceptor.java:41) at com.oceanbase.ocp.bootstrap.spring.DataSourceInterceptor.postProcessAfterInitialization(DataSourceInterceptor.java:34) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsAfterInitialization(AbstractAutowireCapableBeanFactory.java:455) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1808) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:955) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:918) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583) at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:745) at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:420) at org.springframework.boot.SpringApplication.run(SpringApplication.java:307) at org.springframework.boot.builder.SpringApplicationBuilder.run(SpringApplicationBuilder.java:164) at org.springframework.cloud.bootstrap.BootstrapApplicationListener.bootstrapServiceContext(BootstrapApplicationListener.java:195) at org.springframework.cloud.bootstrap.BootstrapApplicationListener.onApplicationEvent(BootstrapApplicationListener.java:114) at org.springframework.cloud.bootstrap.BootstrapApplicationListener.onApplicationEvent(BootstrapApplicationListener.java:77) at org.springframework.context.event.SimpleApplicationEventMulticaster.doInvokeListener(SimpleApplicationEventMulticaster.java:176) at org.springframework.context.event.SimpleApplicationEventMulticaster.invokeListener(SimpleApplicationEventMulticaster.java:169) at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:143) at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:131) at org.springframework.boot.context.event.EventPublishingRunListener.environmentPrepared(EventPublishingRunListener.java:85) at org.springframework.boot.SpringApplicationRunListeners.lambda$environmentPrepared$2(SpringApplicationRunListeners.java:66) at java.util.ArrayList.forEach(ArrayList.java:1255) at org.springframework.boot.SpringApplicationRunListeners.doWithListeners(SpringApplicationRunListeners.java:120) at org.springframework.boot.SpringApplicationRunListeners.doWithListeners(SpringApplicationRunListeners.java:114) at org.springframework.boot.SpringApplicationRunListeners.environmentPrepared(SpringApplicationRunListeners.java:65) at org.springframework.boot.SpringApplication.prepareEnvironment(SpringApplication.java:343) at org.springframework.boot.SpringApplication.run(SpringApplication.java:301) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1317) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1306) at com.oceanbase.ocp.OcpExpressApplication.main(OcpExpressApplication.java:18) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49) at org.springframework.boot.loader.Launcher.launch(Launcher.java:107) at org.springframework.boot.loader.Launcher.launch(Launcher.java:58) at org.springframework.boot.loader.PropertiesLauncher.main(PropertiesLauncher.java:467) Caused by: java.sql.SQLTransientConnectionException: (conn=262243) Timeout, query has reached the maximum query timeout: 10000000(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again. at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:126) at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:200) at com.oceanbase.jdbc.OceanBaseStatement.executeBatchExceptionEpilogue(OceanBaseStatement.java:370) at com.oceanbase.jdbc.OceanBaseStatement.executeBatch(OceanBaseStatement.java:1487) at com.oceanbase.ocp.bootstrap.util.SQLUtils.executeBatch(SQLUtils.java:99) at com.oceanbase.ocp.bootstrap.db.DbInitializer.lambda$new$0(DbInitializer.java:93) at com.oceanbase.ocp.bootstrap.db.DbInitializer.executeSqlTask(DbInitializer.java:203) ... 49 more Caused by: com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException: Timeout, query has reached the maximum query timeout: 10000000(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again. at com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException.of(OceanBaseSqlException.java:80) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:190) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchAggregateSemiColon(AbstractQueryProtocol.java:1084) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchStmt(AbstractQueryProtocol.java:943) at com.oceanbase.jdbc.OceanBaseStatement.internalBatchExecution(OceanBaseStatement.java:1544) at com.oceanbase.jdbc.OceanBaseStatement.executeBatch(OceanBaseStatement.java:1484) ... 52 more Caused by: java.sql.SQLException: Timeout, query has reached the maximum query timeout: 10000000(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again. at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1990) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1855) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1751) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchAggregateSemiColon(AbstractQueryProtocol.java:1080) ... 55 more [2023-03-28T17:28:34.165] END dataSource INSTALL - java.lang.IllegalStateException: java.sql.SQLException: execute sql task failed. task: ocp_metric_expr_config, sql:INSERT INTO `ocp_metric_expr_config`(`metric`,`expr`) VALUES ('sync_delay_time','max(sync_delay_time{@LABELS}) by (@GBLABELS)') ON DUPLICATE KEY UPDATE `expr`='max(sync_delay_time{@LABELS}) by (@GBLABELS)' at com.oceanbase.ocp.bootstrap.db.DbInitializer.executeSqlTask(DbInitializer.java:218) at com.oceanbase.ocp.bootstrap.db.DbInitializer.writeDefaultData(DbInitializer.java:254) at com.oceanbase.ocp.bootstrap.db.DbInitializer.install(DbInitializer.java:122) at com.oceanbase.ocp.bootstrap.db.DbInitializer.initialize(DbInitializer.java:101) at com.oceanbase.ocp.bootstrap.spring.DBInitInterceptor.afterDataSourceCreation(DBInitInterceptor.java:70) at com.oceanbase.ocp.bootstrap.spring.DataSourceInterceptor.lambda$afterDataSourceCreationHook$0(DataSourceInterceptor.java:43) at java.util.ArrayList.forEach(ArrayList.java:1255) at com.oceanbase.ocp.bootstrap.spring.DataSourceInterceptor.afterDataSourceCreationHook(DataSourceInterceptor.java:41) at com.oceanbase.ocp.bootstrap.spring.DataSourceInterceptor.postProcessAfterInitialization(DataSourceInterceptor.java:34) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsAfterInitialization(AbstractAutowireCapableBeanFactory.java:455) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1808) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:955) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:918) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583) at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:745) at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:420) at org.springframework.boot.SpringApplication.run(SpringApplication.java:307) at org.springframework.boot.builder.SpringApplicationBuilder.run(SpringApplicationBuilder.java:164) at org.springframework.cloud.bootstrap.BootstrapApplicationListener.bootstrapServiceContext(BootstrapApplicationListener.java:195) at org.springframework.cloud.bootstrap.BootstrapApplicationListener.onApplicationEvent(BootstrapApplicationListener.java:114) at org.springframework.cloud.bootstrap.BootstrapApplicationListener.onApplicationEvent(BootstrapApplicationListener.java:77) at org.springframework.context.event.SimpleApplicationEventMulticaster.doInvokeListener(SimpleApplicationEventMulticaster.java:176) at org.springframework.context.event.SimpleApplicationEventMulticaster.invokeListener(SimpleApplicationEventMulticaster.java:169) at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:143) at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:131) at org.springframework.boot.context.event.EventPublishingRunListener.environmentPrepared(EventPublishingRunListener.java:85) at org.springframework.boot.SpringApplicationRunListeners.lambda$environmentPrepared$2(SpringApplicationRunListeners.java:66) at java.util.ArrayList.forEach(ArrayList.java:1255) at org.springframework.boot.SpringApplicationRunListeners.doWithListeners(SpringApplicationRunListeners.java:120) at org.springframework.boot.SpringApplicationRunListeners.doWithListeners(SpringApplicationRunListeners.java:114) at org.springframework.boot.SpringApplicationRunListeners.environmentPrepared(SpringApplicationRunListeners.java:65) at org.springframework.boot.SpringApplication.prepareEnvironment(SpringApplication.java:343) at org.springframework.boot.SpringApplication.run(SpringApplication.java:301) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1317) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1306) at com.oceanbase.ocp.OcpExpressApplication.main(OcpExpressApplication.java:18) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49) at org.springframework.boot.loader.Launcher.launch(Launcher.java:107) at org.springframework.boot.loader.Launcher.launch(Launcher.java:58) at org.springframework.boot.loader.PropertiesLauncher.main(PropertiesLauncher.java:467) Caused by: java.sql.SQLException: execute sql task failed. task: ocp_metric_expr_config, sql:INSERT INTO `ocp_metric_expr_config`(`metric`,`expr`) VALUES ('sync_delay_time','max(sync_delay_time{@LABELS}) by (@GBLABELS)') ON DUPLICATE KEY UPDATE `expr`='max(sync_delay_time{@LABELS}) by (@GBLABELS)' at com.oceanbase.ocp.bootstrap.db.DbInitializer.executeSqlTask(DbInitializer.java:216) ... 49 more Caused by: java.sql.SQLTransientConnectionException: (conn=262243) Timeout, query has reached the maximum query timeout: 10000000(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again. at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:126) at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:200) at com.oceanbase.jdbc.OceanBaseStatement.executeBatchExceptionEpilogue(OceanBaseStatement.java:370) at com.oceanbase.jdbc.OceanBaseStatement.executeBatch(OceanBaseStatement.java:1487) at com.oceanbase.ocp.bootstrap.util.SQLUtils.executeBatch(SQLUtils.java:99) at com.oceanbase.ocp.bootstrap.db.DbInitializer.lambda$new$0(DbInitializer.java:93) at com.oceanbase.ocp.bootstrap.db.DbInitializer.executeSqlTask(DbInitializer.java:203) ... 49 more Caused by: com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException: Timeout, query has reached the maximum query timeout: 10000000(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again. at com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException.of(OceanBaseSqlException.java:80) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:190) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchAggregateSemiColon(AbstractQueryProtocol.java:1084) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchStmt(AbstractQueryProtocol.java:943) at com.oceanbase.jdbc.OceanBaseStatement.internalBatchExecution(OceanBaseStatement.java:1544) at com.oceanbase.jdbc.OceanBaseStatement.executeBatch(OceanBaseStatement.java:1484) ... 52 more Caused by: java.sql.SQLException: Timeout, query has reached the maximum query timeout: 10000000(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again. at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1990) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1855) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1751) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchAggregateSemiColon(AbstractQueryProtocol.java:1080) ... 55 more [2023-03-28T18:07:18.387] BEGIN dataSource INSTALL - [2023-03-28T18:07:18.400] BEGIN dataSource CREATE_TABLES - 24 [2023-03-28T18:07:18.404] BEGIN dataSource CREATE_TABLES sqls:ob_agent 1 [2023-03-28T18:07:18.420] END dataSource CREATE_TABLES sqls:ob_agent [2023-03-28T18:07:18.421] BEGIN dataSource CREATE_TABLES sqls:credential 1 [2023-03-28T18:07:18.435] END dataSource CREATE_TABLES sqls:credential [2023-03-28T18:07:18.435] BEGIN dataSource CREATE_TABLES sqls:metric_data_minute 1 [2023-03-28T18:07:18.462] END dataSource CREATE_TABLES sqls:metric_data_minute [2023-03-28T18:07:18.462] BEGIN dataSource CREATE_TABLES sqls:metric_data_second 1 [2023-03-28T18:07:18.488] END dataSource CREATE_TABLES sqls:metric_data_second [2023-03-28T18:07:18.488] BEGIN dataSource CREATE_TABLES sqls:ocp_metric_series_key_id 1 [2023-03-28T18:07:18.503] END dataSource CREATE_TABLES sqls:ocp_metric_series_key_id [2023-03-28T18:07:18.504] BEGIN dataSource CREATE_TABLES sqls:config_properties 1 [2023-03-28T18:07:18.518] END dataSource CREATE_TABLES sqls:config_properties [2023-03-28T18:07:18.518] BEGIN dataSource CREATE_TABLES sqls:ob_tenant 1 [2023-03-28T18:07:18.531] END dataSource CREATE_TABLES sqls:ob_tenant [2023-03-28T18:07:18.531] BEGIN dataSource CREATE_TABLES sqls:ob_tenant_compaction 1 [2023-03-28T18:07:18.543] END dataSource CREATE_TABLES sqls:ob_tenant_compaction [2023-03-28T18:07:18.543] BEGIN dataSource CREATE_TABLES sqls:metric_class 1 [2023-03-28T18:07:18.557] END dataSource CREATE_TABLES sqls:metric_class [2023-03-28T18:07:18.557] BEGIN dataSource CREATE_TABLES sqls:metric_group 1 [2023-03-28T18:07:18.569] END dataSource CREATE_TABLES sqls:metric_group [2023-03-28T18:07:18.570] BEGIN dataSource CREATE_TABLES sqls:metric_meta 1 [2023-03-28T18:07:18.581] END dataSource CREATE_TABLES sqls:metric_meta [2023-03-28T18:07:18.582] BEGIN dataSource CREATE_TABLES sqls:ocp_metric_expr_config 1 [2023-03-28T18:07:18.593] END dataSource CREATE_TABLES sqls:ocp_metric_expr_config [2023-03-28T18:07:18.593] BEGIN dataSource CREATE_TABLES sqls:metric_exporter_address 1 [2023-03-28T18:07:18.606] END dataSource CREATE_TABLES sqls:metric_exporter_address [2023-03-28T18:07:18.606] BEGIN dataSource CREATE_TABLES sqls:iam_user 1 [2023-03-28T18:07:18.621] END dataSource CREATE_TABLES sqls:iam_user [2023-03-28T18:07:18.621] BEGIN dataSource CREATE_TABLES sqls:iam_user_login_record 1 [2023-03-28T18:07:18.633] END dataSource CREATE_TABLES sqls:iam_user_login_record [2023-03-28T18:07:18.634] BEGIN dataSource CREATE_TABLES sqls:profile_credential 1 [2023-03-28T18:07:18.645] END dataSource CREATE_TABLES sqls:profile_credential [2023-03-28T18:07:18.646] BEGIN dataSource CREATE_TABLES sqls:profile_credential_access 1 [2023-03-28T18:07:18.658] END dataSource CREATE_TABLES sqls:profile_credential_access [2023-03-28T18:07:18.659] BEGIN dataSource CREATE_TABLES sqls:task_definition 1 [2023-03-28T18:07:18.672] END dataSource CREATE_TABLES sqls:task_definition [2023-03-28T18:07:18.672] BEGIN dataSource CREATE_TABLES sqls:task_template 1 [2023-03-28T18:07:18.685] END dataSource CREATE_TABLES sqls:task_template [2023-03-28T18:07:18.685] BEGIN dataSource CREATE_TABLES sqls:subtask_instance 1 [2023-03-28T18:07:18.698] END dataSource CREATE_TABLES sqls:subtask_instance [2023-03-28T18:07:18.698] BEGIN dataSource CREATE_TABLES sqls:subtask_log 1 [2023-03-28T18:07:18.710] END dataSource CREATE_TABLES sqls:subtask_log [2023-03-28T18:07:18.710] BEGIN dataSource CREATE_TABLES sqls:subtask_dependencies 1 [2023-03-28T18:07:18.722] END dataSource CREATE_TABLES sqls:subtask_dependencies [2023-03-28T18:07:18.722] BEGIN dataSource CREATE_TABLES sqls:task_instance 1 [2023-03-28T18:07:18.736] END dataSource CREATE_TABLES sqls:task_instance [2023-03-28T18:07:18.736] BEGIN dataSource CREATE_TABLES sqls:ocp_instance 1 [2023-03-28T18:07:18.748] END dataSource CREATE_TABLES sqls:ocp_instance [2023-03-28T18:07:18.748] END dataSource CREATE_TABLES - [2023-03-28T18:07:18.893] BEGIN dataSource DEFAULT_DATA - 8 [2023-03-28T18:07:18.893] BEGIN dataSource DEFAULT_DATA sqls:iam_user 2 [2023-03-28T18:07:18.950] END dataSource DEFAULT_DATA sqls:iam_user [2023-03-28T18:07:18.950] BEGIN dataSource DEFAULT_DATA sqls:task_template 1 [2023-03-28T18:07:18.977] END dataSource DEFAULT_DATA sqls:task_template [2023-03-28T18:07:18.977] BEGIN dataSource DEFAULT_DATA sqls:task_definition 1 [2023-03-28T18:07:19.001] END dataSource DEFAULT_DATA sqls:task_definition [2023-03-28T18:07:19.002] BEGIN dataSource DEFAULT_DATA sqls:config_properties 82 [2023-03-28T18:07:20.597] END dataSource DEFAULT_DATA sqls:config_properties [2023-03-28T18:07:20.598] BEGIN dataSource DEFAULT_DATA sqls:ocp_metric_expr_config 246 [2023-03-28T18:07:30.539] END dataSource DEFAULT_DATA sqls:ocp_metric_expr_config java.sql.SQLException: execute sql task failed. task: ocp_metric_expr_config, sql:INSERT INTO `ocp_metric_expr_config`(`metric`,`expr`) VALUES ('sql_update_count','sum(rate(ob_sysstat{stat_id=\"40006\",@LABELS}[@INTERVAL])) by (@GBLABELS)') ON DUPLICATE KEY UPDATE `expr`='sum(rate(ob_sysstat{stat_id=\"40006\",@LABELS}[@INTERVAL])) by (@GBLABELS)' at com.oceanbase.ocp.bootstrap.db.DbInitializer.executeSqlTask(DbInitializer.java:216) at com.oceanbase.ocp.bootstrap.db.DbInitializer.writeDefaultData(DbInitializer.java:254) at com.oceanbase.ocp.bootstrap.db.DbInitializer.install(DbInitializer.java:122) at com.oceanbase.ocp.bootstrap.db.DbInitializer.initialize(DbInitializer.java:101) at com.oceanbase.ocp.bootstrap.spring.DBInitInterceptor.afterDataSourceCreation(DBInitInterceptor.java:70) at com.oceanbase.ocp.bootstrap.spring.DataSourceInterceptor.lambda$afterDataSourceCreationHook$0(DataSourceInterceptor.java:43) at java.util.ArrayList.forEach(ArrayList.java:1255) at com.oceanbase.ocp.bootstrap.spring.DataSourceInterceptor.afterDataSourceCreationHook(DataSourceInterceptor.java:41) at com.oceanbase.ocp.bootstrap.spring.DataSourceInterceptor.postProcessAfterInitialization(DataSourceInterceptor.java:34) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsAfterInitialization(AbstractAutowireCapableBeanFactory.java:455) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1808) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:955) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:918) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583) at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:745) at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:420) at org.springframework.boot.SpringApplication.run(SpringApplication.java:307) at org.springframework.boot.builder.SpringApplicationBuilder.run(SpringApplicationBuilder.java:164) at org.springframework.cloud.bootstrap.BootstrapApplicationListener.bootstrapServiceContext(BootstrapApplicationListener.java:195) at org.springframework.cloud.bootstrap.BootstrapApplicationListener.onApplicationEvent(BootstrapApplicationListener.java:114) at org.springframework.cloud.bootstrap.BootstrapApplicationListener.onApplicationEvent(BootstrapApplicationListener.java:77) at org.springframework.context.event.SimpleApplicationEventMulticaster.doInvokeListener(SimpleApplicationEventMulticaster.java:176) at org.springframework.context.event.SimpleApplicationEventMulticaster.invokeListener(SimpleApplicationEventMulticaster.java:169) at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:143) at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:131) at org.springframework.boot.context.event.EventPublishingRunListener.environmentPrepared(EventPublishingRunListener.java:85) at org.springframework.boot.SpringApplicationRunListeners.lambda$environmentPrepared$2(SpringApplicationRunListeners.java:66) at java.util.ArrayList.forEach(ArrayList.java:1255) at org.springframework.boot.SpringApplicationRunListeners.doWithListeners(SpringApplicationRunListeners.java:120) at org.springframework.boot.SpringApplicationRunListeners.doWithListeners(SpringApplicationRunListeners.java:114) at org.springframework.boot.SpringApplicationRunListeners.environmentPrepared(SpringApplicationRunListeners.java:65) at org.springframework.boot.SpringApplication.prepareEnvironment(SpringApplication.java:343) at org.springframework.boot.SpringApplication.run(SpringApplication.java:301) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1317) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1306) at com.oceanbase.ocp.OcpExpressApplication.main(OcpExpressApplication.java:18) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49) at org.springframework.boot.loader.Launcher.launch(Launcher.java:107) at org.springframework.boot.loader.Launcher.launch(Launcher.java:58) at org.springframework.boot.loader.PropertiesLauncher.main(PropertiesLauncher.java:467) Caused by: java.sql.SQLTransientConnectionException: (conn=262291) Timeout, query has reached the maximum query timeout: 10000000(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again. at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:126) at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:200) at com.oceanbase.jdbc.OceanBaseStatement.executeBatchExceptionEpilogue(OceanBaseStatement.java:370) at com.oceanbase.jdbc.OceanBaseStatement.executeBatch(OceanBaseStatement.java:1487) at com.oceanbase.ocp.bootstrap.util.SQLUtils.executeBatch(SQLUtils.java:99) at com.oceanbase.ocp.bootstrap.db.DbInitializer.lambda$new$0(DbInitializer.java:93) at com.oceanbase.ocp.bootstrap.db.DbInitializer.executeSqlTask(DbInitializer.java:203) ... 49 more Caused by: com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException: Timeout, query has reached the maximum query timeout: 10000000(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again. at com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException.of(OceanBaseSqlException.java:80) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:190) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchAggregateSemiColon(AbstractQueryProtocol.java:1084) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchStmt(AbstractQueryProtocol.java:943) at com.oceanbase.jdbc.OceanBaseStatement.internalBatchExecution(OceanBaseStatement.java:1544) at com.oceanbase.jdbc.OceanBaseStatement.executeBatch(OceanBaseStatement.java:1484) ... 52 more Caused by: java.sql.SQLException: Timeout, query has reached the maximum query timeout: 10000000(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again. at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1990) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1855) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1751) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchAggregateSemiColon(AbstractQueryProtocol.java:1080) ... 55 more [2023-03-28T18:07:30.543] END dataSource INSTALL - java.lang.IllegalStateException: java.sql.SQLException: execute sql task failed. task: ocp_metric_expr_config, sql:INSERT INTO `ocp_metric_expr_config`(`metric`,`expr`) VALUES ('sql_update_count','sum(rate(ob_sysstat{stat_id=\"40006\",@LABELS}[@INTERVAL])) by (@GBLABELS)') ON DUPLICATE KEY UPDATE `expr`='sum(rate(ob_sysstat{stat_id=\"40006\",@LABELS}[@INTERVAL])) by (@GBLABELS)' at com.oceanbase.ocp.bootstrap.db.DbInitializer.executeSqlTask(DbInitializer.java:218) at com.oceanbase.ocp.bootstrap.db.DbInitializer.writeDefaultData(DbInitializer.java:254) at com.oceanbase.ocp.bootstrap.db.DbInitializer.install(DbInitializer.java:122) at com.oceanbase.ocp.bootstrap.db.DbInitializer.initialize(DbInitializer.java:101) at com.oceanbase.ocp.bootstrap.spring.DBInitInterceptor.afterDataSourceCreation(DBInitInterceptor.java:70) at com.oceanbase.ocp.bootstrap.spring.DataSourceInterceptor.lambda$afterDataSourceCreationHook$0(DataSourceInterceptor.java:43) at java.util.ArrayList.forEach(ArrayList.java:1255) at com.oceanbase.ocp.bootstrap.spring.DataSourceInterceptor.afterDataSourceCreationHook(DataSourceInterceptor.java:41) at com.oceanbase.ocp.bootstrap.spring.DataSourceInterceptor.postProcessAfterInitialization(DataSourceInterceptor.java:34) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsAfterInitialization(AbstractAutowireCapableBeanFactory.java:455) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1808) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:955) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:918) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583) at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:745) at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:420) at org.springframework.boot.SpringApplication.run(SpringApplication.java:307) at org.springframework.boot.builder.SpringApplicationBuilder.run(SpringApplicationBuilder.java:164) at org.springframework.cloud.bootstrap.BootstrapApplicationListener.bootstrapServiceContext(BootstrapApplicationListener.java:195) at org.springframework.cloud.bootstrap.BootstrapApplicationListener.onApplicationEvent(BootstrapApplicationListener.java:114) at org.springframework.cloud.bootstrap.BootstrapApplicationListener.onApplicationEvent(BootstrapApplicationListener.java:77) at org.springframework.context.event.SimpleApplicationEventMulticaster.doInvokeListener(SimpleApplicationEventMulticaster.java:176) at org.springframework.context.event.SimpleApplicationEventMulticaster.invokeListener(SimpleApplicationEventMulticaster.java:169) at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:143) at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:131) at org.springframework.boot.context.event.EventPublishingRunListener.environmentPrepared(EventPublishingRunListener.java:85) at org.springframework.boot.SpringApplicationRunListeners.lambda$environmentPrepared$2(SpringApplicationRunListeners.java:66) at java.util.ArrayList.forEach(ArrayList.java:1255) at org.springframework.boot.SpringApplicationRunListeners.doWithListeners(SpringApplicationRunListeners.java:120) at org.springframework.boot.SpringApplicationRunListeners.doWithListeners(SpringApplicationRunListeners.java:114) at org.springframework.boot.SpringApplicationRunListeners.environmentPrepared(SpringApplicationRunListeners.java:65) at org.springframework.boot.SpringApplication.prepareEnvironment(SpringApplication.java:343) at org.springframework.boot.SpringApplication.run(SpringApplication.java:301) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1317) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1306) at com.oceanbase.ocp.OcpExpressApplication.main(OcpExpressApplication.java:18) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49) at org.springframework.boot.loader.Launcher.launch(Launcher.java:107) at org.springframework.boot.loader.Launcher.launch(Launcher.java:58) at org.springframework.boot.loader.PropertiesLauncher.main(PropertiesLauncher.java:467) Caused by: java.sql.SQLException: execute sql task failed. task: ocp_metric_expr_config, sql:INSERT INTO `ocp_metric_expr_config`(`metric`,`expr`) VALUES ('sql_update_count','sum(rate(ob_sysstat{stat_id=\"40006\",@LABELS}[@INTERVAL])) by (@GBLABELS)') ON DUPLICATE KEY UPDATE `expr`='sum(rate(ob_sysstat{stat_id=\"40006\",@LABELS}[@INTERVAL])) by (@GBLABELS)' at com.oceanbase.ocp.bootstrap.db.DbInitializer.executeSqlTask(DbInitializer.java:216) ... 49 more Caused by: java.sql.SQLTransientConnectionException: (conn=262291) Timeout, query has reached the maximum query timeout: 10000000(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again. at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:126) at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:200) at com.oceanbase.jdbc.OceanBaseStatement.executeBatchExceptionEpilogue(OceanBaseStatement.java:370) at com.oceanbase.jdbc.OceanBaseStatement.executeBatch(OceanBaseStatement.java:1487) at com.oceanbase.ocp.bootstrap.util.SQLUtils.executeBatch(SQLUtils.java:99) at com.oceanbase.ocp.bootstrap.db.DbInitializer.lambda$new$0(DbInitializer.java:93) at com.oceanbase.ocp.bootstrap.db.DbInitializer.executeSqlTask(DbInitializer.java:203) ... 49 more Caused by: com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException: Timeout, query has reached the maximum query timeout: 10000000(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again. at com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException.of(OceanBaseSqlException.java:80) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:190) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchAggregateSemiColon(AbstractQueryProtocol.java:1084) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchStmt(AbstractQueryProtocol.java:943) at com.oceanbase.jdbc.OceanBaseStatement.internalBatchExecution(OceanBaseStatement.java:1544) at com.oceanbase.jdbc.OceanBaseStatement.executeBatch(OceanBaseStatement.java:1484) ... 52 more Caused by: java.sql.SQLException: Timeout, query has reached the maximum query timeout: 10000000(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again. at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1990) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1855) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1751) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchAggregateSemiColon(AbstractQueryProtocol.java:1080) ... 55 more [2023-03-28T18:11:28.496] BEGIN dataSource INSTALL - [2023-03-28T18:11:28.510] BEGIN dataSource CREATE_TABLES - 24 [2023-03-28T18:11:28.514] BEGIN dataSource CREATE_TABLES sqls:credential 1 [2023-03-28T18:11:28.533] END dataSource CREATE_TABLES sqls:credential [2023-03-28T18:11:28.533] BEGIN dataSource CREATE_TABLES sqls:metric_data_minute 1 [2023-03-28T18:11:28.557] END dataSource CREATE_TABLES sqls:metric_data_minute [2023-03-28T18:11:28.557] BEGIN dataSource CREATE_TABLES sqls:metric_data_second 1 [2023-03-28T18:11:28.576] END dataSource CREATE_TABLES sqls:metric_data_second [2023-03-28T18:11:28.576] BEGIN dataSource CREATE_TABLES sqls:ocp_metric_series_key_id 1 [2023-03-28T18:11:28.589] END dataSource CREATE_TABLES sqls:ocp_metric_series_key_id [2023-03-28T18:11:28.589] BEGIN dataSource CREATE_TABLES sqls:ob_agent 1 [2023-03-28T18:11:28.603] END dataSource CREATE_TABLES sqls:ob_agent [2023-03-28T18:11:28.603] BEGIN dataSource CREATE_TABLES sqls:config_properties 1 [2023-03-28T18:11:28.616] END dataSource CREATE_TABLES sqls:config_properties [2023-03-28T18:11:28.617] BEGIN dataSource CREATE_TABLES sqls:ob_tenant 1 [2023-03-28T18:11:28.630] END dataSource CREATE_TABLES sqls:ob_tenant [2023-03-28T18:11:28.631] BEGIN dataSource CREATE_TABLES sqls:ob_tenant_compaction 1 [2023-03-28T18:11:28.644] END dataSource CREATE_TABLES sqls:ob_tenant_compaction [2023-03-28T18:11:28.645] BEGIN dataSource CREATE_TABLES sqls:metric_class 1 [2023-03-28T18:11:28.658] END dataSource CREATE_TABLES sqls:metric_class [2023-03-28T18:11:28.658] BEGIN dataSource CREATE_TABLES sqls:metric_group 1 [2023-03-28T18:11:28.671] END dataSource CREATE_TABLES sqls:metric_group [2023-03-28T18:11:28.671] BEGIN dataSource CREATE_TABLES sqls:metric_meta 1 [2023-03-28T18:11:28.684] END dataSource CREATE_TABLES sqls:metric_meta [2023-03-28T18:11:28.684] BEGIN dataSource CREATE_TABLES sqls:ocp_metric_expr_config 1 [2023-03-28T18:11:28.697] END dataSource CREATE_TABLES sqls:ocp_metric_expr_config [2023-03-28T18:11:28.697] BEGIN dataSource CREATE_TABLES sqls:metric_exporter_address 1 [2023-03-28T18:11:28.710] END dataSource CREATE_TABLES sqls:metric_exporter_address [2023-03-28T18:11:28.711] BEGIN dataSource CREATE_TABLES sqls:iam_user 1 [2023-03-28T18:11:28.725] END dataSource CREATE_TABLES sqls:iam_user [2023-03-28T18:11:28.725] BEGIN dataSource CREATE_TABLES sqls:iam_user_login_record 1 [2023-03-28T18:11:28.737] END dataSource CREATE_TABLES sqls:iam_user_login_record [2023-03-28T18:11:28.737] BEGIN dataSource CREATE_TABLES sqls:profile_credential 1 [2023-03-28T18:11:28.750] END dataSource CREATE_TABLES sqls:profile_credential [2023-03-28T18:11:28.750] BEGIN dataSource CREATE_TABLES sqls:profile_credential_access 1 [2023-03-28T18:11:28.762] END dataSource CREATE_TABLES sqls:profile_credential_access [2023-03-28T18:11:28.763] BEGIN dataSource CREATE_TABLES sqls:task_definition 1 [2023-03-28T18:11:28.774] END dataSource CREATE_TABLES sqls:task_definition [2023-03-28T18:11:28.774] BEGIN dataSource CREATE_TABLES sqls:task_template 1 [2023-03-28T18:11:28.786] END dataSource CREATE_TABLES sqls:task_template [2023-03-28T18:11:28.786] BEGIN dataSource CREATE_TABLES sqls:subtask_instance 1 [2023-03-28T18:11:28.799] END dataSource CREATE_TABLES sqls:subtask_instance [2023-03-28T18:11:28.799] BEGIN dataSource CREATE_TABLES sqls:subtask_log 1 [2023-03-28T18:11:28.811] END dataSource CREATE_TABLES sqls:subtask_log [2023-03-28T18:11:28.811] BEGIN dataSource CREATE_TABLES sqls:subtask_dependencies 1 [2023-03-28T18:11:28.823] END dataSource CREATE_TABLES sqls:subtask_dependencies [2023-03-28T18:11:28.823] BEGIN dataSource CREATE_TABLES sqls:task_instance 1 [2023-03-28T18:11:28.835] END dataSource CREATE_TABLES sqls:task_instance [2023-03-28T18:11:28.835] BEGIN dataSource CREATE_TABLES sqls:ocp_instance 1 [2023-03-28T18:11:28.847] END dataSource CREATE_TABLES sqls:ocp_instance [2023-03-28T18:11:28.847] END dataSource CREATE_TABLES - [2023-03-28T18:11:28.989] BEGIN dataSource DEFAULT_DATA - 8 [2023-03-28T18:11:28.989] BEGIN dataSource DEFAULT_DATA sqls:iam_user 2 [2023-03-28T18:11:29.124] END dataSource DEFAULT_DATA sqls:iam_user [2023-03-28T18:11:29.124] BEGIN dataSource DEFAULT_DATA sqls:task_template 1 [2023-03-28T18:11:29.186] END dataSource DEFAULT_DATA sqls:task_template [2023-03-28T18:11:29.186] BEGIN dataSource DEFAULT_DATA sqls:task_definition 1 [2023-03-28T18:11:29.248] END dataSource DEFAULT_DATA sqls:task_definition [2023-03-28T18:11:29.248] BEGIN dataSource DEFAULT_DATA sqls:config_properties 82 [2023-03-28T18:11:31.174] END dataSource DEFAULT_DATA sqls:config_properties [2023-03-28T18:11:31.175] BEGIN dataSource DEFAULT_DATA sqls:ocp_metric_expr_config 246 [2023-03-28T18:11:41.116] END dataSource DEFAULT_DATA sqls:ocp_metric_expr_config java.sql.SQLException: execute sql task failed. task: ocp_metric_expr_config, sql:INSERT INTO `ocp_metric_expr_config`(`metric`,`expr`) VALUES ('tps','sum(rate(ob_sysstat{stat_id=\"30007\",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id=\"30009\",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id=\"30011\",@LABELS}[@INTERVAL])) by (@GBLABELS)') ON DUPLICATE KEY UPDATE `expr`='sum(rate(ob_sysstat{stat_id=\"30007\",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id=\"30009\",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id=\"30011\",@LABELS}[@INTERVAL])) by (@GBLABELS)' at com.oceanbase.ocp.bootstrap.db.DbInitializer.executeSqlTask(DbInitializer.java:216) at com.oceanbase.ocp.bootstrap.db.DbInitializer.writeDefaultData(DbInitializer.java:254) at com.oceanbase.ocp.bootstrap.db.DbInitializer.install(DbInitializer.java:122) at com.oceanbase.ocp.bootstrap.db.DbInitializer.initialize(DbInitializer.java:101) at com.oceanbase.ocp.bootstrap.spring.DBInitInterceptor.afterDataSourceCreation(DBInitInterceptor.java:70) at com.oceanbase.ocp.bootstrap.spring.DataSourceInterceptor.lambda$afterDataSourceCreationHook$0(DataSourceInterceptor.java:43) at java.util.ArrayList.forEach(ArrayList.java:1255) at com.oceanbase.ocp.bootstrap.spring.DataSourceInterceptor.afterDataSourceCreationHook(DataSourceInterceptor.java:41) at com.oceanbase.ocp.bootstrap.spring.DataSourceInterceptor.postProcessAfterInitialization(DataSourceInterceptor.java:34) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsAfterInitialization(AbstractAutowireCapableBeanFactory.java:455) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1808) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:955) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:918) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583) at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:745) at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:420) at org.springframework.boot.SpringApplication.run(SpringApplication.java:307) at org.springframework.boot.builder.SpringApplicationBuilder.run(SpringApplicationBuilder.java:164) at org.springframework.cloud.bootstrap.BootstrapApplicationListener.bootstrapServiceContext(BootstrapApplicationListener.java:195) at org.springframework.cloud.bootstrap.BootstrapApplicationListener.onApplicationEvent(BootstrapApplicationListener.java:114) at org.springframework.cloud.bootstrap.BootstrapApplicationListener.onApplicationEvent(BootstrapApplicationListener.java:77) at org.springframework.context.event.SimpleApplicationEventMulticaster.doInvokeListener(SimpleApplicationEventMulticaster.java:176) at org.springframework.context.event.SimpleApplicationEventMulticaster.invokeListener(SimpleApplicationEventMulticaster.java:169) at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:143) at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:131) at org.springframework.boot.context.event.EventPublishingRunListener.environmentPrepared(EventPublishingRunListener.java:85) at org.springframework.boot.SpringApplicationRunListeners.lambda$environmentPrepared$2(SpringApplicationRunListeners.java:66) at java.util.ArrayList.forEach(ArrayList.java:1255) at org.springframework.boot.SpringApplicationRunListeners.doWithListeners(SpringApplicationRunListeners.java:120) at org.springframework.boot.SpringApplicationRunListeners.doWithListeners(SpringApplicationRunListeners.java:114) at org.springframework.boot.SpringApplicationRunListeners.environmentPrepared(SpringApplicationRunListeners.java:65) at org.springframework.boot.SpringApplication.prepareEnvironment(SpringApplication.java:343) at org.springframework.boot.SpringApplication.run(SpringApplication.java:301) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1317) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1306) at com.oceanbase.ocp.OcpExpressApplication.main(OcpExpressApplication.java:18) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49) at org.springframework.boot.loader.Launcher.launch(Launcher.java:107) at org.springframework.boot.loader.Launcher.launch(Launcher.java:58) at org.springframework.boot.loader.PropertiesLauncher.main(PropertiesLauncher.java:467) Caused by: java.sql.SQLTransientConnectionException: (conn=42) Timeout, query has reached the maximum query timeout: 10000000(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again. at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:126) at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:200) at com.oceanbase.jdbc.OceanBaseStatement.executeBatchExceptionEpilogue(OceanBaseStatement.java:370) at com.oceanbase.jdbc.OceanBaseStatement.executeBatch(OceanBaseStatement.java:1487) at com.oceanbase.ocp.bootstrap.util.SQLUtils.executeBatch(SQLUtils.java:99) at com.oceanbase.ocp.bootstrap.db.DbInitializer.lambda$new$0(DbInitializer.java:93) at com.oceanbase.ocp.bootstrap.db.DbInitializer.executeSqlTask(DbInitializer.java:203) ... 49 more Caused by: com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException: Timeout, query has reached the maximum query timeout: 10000000(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again. at com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException.of(OceanBaseSqlException.java:80) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:190) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchAggregateSemiColon(AbstractQueryProtocol.java:1084) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchStmt(AbstractQueryProtocol.java:943) at com.oceanbase.jdbc.OceanBaseStatement.internalBatchExecution(OceanBaseStatement.java:1544) at com.oceanbase.jdbc.OceanBaseStatement.executeBatch(OceanBaseStatement.java:1484) ... 52 more Caused by: java.sql.SQLException: Timeout, query has reached the maximum query timeout: 10000000(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again. at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1990) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1855) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1751) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchAggregateSemiColon(AbstractQueryProtocol.java:1080) ... 55 more [2023-03-28T18:11:41.120] END dataSource INSTALL - java.lang.IllegalStateException: java.sql.SQLException: execute sql task failed. task: ocp_metric_expr_config, sql:INSERT INTO `ocp_metric_expr_config`(`metric`,`expr`) VALUES ('tps','sum(rate(ob_sysstat{stat_id=\"30007\",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id=\"30009\",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id=\"30011\",@LABELS}[@INTERVAL])) by (@GBLABELS)') ON DUPLICATE KEY UPDATE `expr`='sum(rate(ob_sysstat{stat_id=\"30007\",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id=\"30009\",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id=\"30011\",@LABELS}[@INTERVAL])) by (@GBLABELS)' at com.oceanbase.ocp.bootstrap.db.DbInitializer.executeSqlTask(DbInitializer.java:218) at com.oceanbase.ocp.bootstrap.db.DbInitializer.writeDefaultData(DbInitializer.java:254) at com.oceanbase.ocp.bootstrap.db.DbInitializer.install(DbInitializer.java:122) at com.oceanbase.ocp.bootstrap.db.DbInitializer.initialize(DbInitializer.java:101) at com.oceanbase.ocp.bootstrap.spring.DBInitInterceptor.afterDataSourceCreation(DBInitInterceptor.java:70) at com.oceanbase.ocp.bootstrap.spring.DataSourceInterceptor.lambda$afterDataSourceCreationHook$0(DataSourceInterceptor.java:43) at java.util.ArrayList.forEach(ArrayList.java:1255) at com.oceanbase.ocp.bootstrap.spring.DataSourceInterceptor.afterDataSourceCreationHook(DataSourceInterceptor.java:41) at com.oceanbase.ocp.bootstrap.spring.DataSourceInterceptor.postProcessAfterInitialization(DataSourceInterceptor.java:34) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsAfterInitialization(AbstractAutowireCapableBeanFactory.java:455) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1808) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:955) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:918) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583) at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:745) at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:420) at org.springframework.boot.SpringApplication.run(SpringApplication.java:307) at org.springframework.boot.builder.SpringApplicationBuilder.run(SpringApplicationBuilder.java:164) at org.springframework.cloud.bootstrap.BootstrapApplicationListener.bootstrapServiceContext(BootstrapApplicationListener.java:195) at org.springframework.cloud.bootstrap.BootstrapApplicationListener.onApplicationEvent(BootstrapApplicationListener.java:114) at org.springframework.cloud.bootstrap.BootstrapApplicationListener.onApplicationEvent(BootstrapApplicationListener.java:77) at org.springframework.context.event.SimpleApplicationEventMulticaster.doInvokeListener(SimpleApplicationEventMulticaster.java:176) at org.springframework.context.event.SimpleApplicationEventMulticaster.invokeListener(SimpleApplicationEventMulticaster.java:169) at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:143) at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:131) at org.springframework.boot.context.event.EventPublishingRunListener.environmentPrepared(EventPublishingRunListener.java:85) at org.springframework.boot.SpringApplicationRunListeners.lambda$environmentPrepared$2(SpringApplicationRunListeners.java:66) at java.util.ArrayList.forEach(ArrayList.java:1255) at org.springframework.boot.SpringApplicationRunListeners.doWithListeners(SpringApplicationRunListeners.java:120) at org.springframework.boot.SpringApplicationRunListeners.doWithListeners(SpringApplicationRunListeners.java:114) at org.springframework.boot.SpringApplicationRunListeners.environmentPrepared(SpringApplicationRunListeners.java:65) at org.springframework.boot.SpringApplication.prepareEnvironment(SpringApplication.java:343) at org.springframework.boot.SpringApplication.run(SpringApplication.java:301) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1317) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1306) at com.oceanbase.ocp.OcpExpressApplication.main(OcpExpressApplication.java:18) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49) at org.springframework.boot.loader.Launcher.launch(Launcher.java:107) at org.springframework.boot.loader.Launcher.launch(Launcher.java:58) at org.springframework.boot.loader.PropertiesLauncher.main(PropertiesLauncher.java:467) Caused by: java.sql.SQLException: execute sql task failed. task: ocp_metric_expr_config, sql:INSERT INTO `ocp_metric_expr_config`(`metric`,`expr`) VALUES ('tps','sum(rate(ob_sysstat{stat_id=\"30007\",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id=\"30009\",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id=\"30011\",@LABELS}[@INTERVAL])) by (@GBLABELS)') ON DUPLICATE KEY UPDATE `expr`='sum(rate(ob_sysstat{stat_id=\"30007\",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id=\"30009\",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id=\"30011\",@LABELS}[@INTERVAL])) by (@GBLABELS)' at com.oceanbase.ocp.bootstrap.db.DbInitializer.executeSqlTask(DbInitializer.java:216) ... 49 more Caused by: java.sql.SQLTransientConnectionException: (conn=42) Timeout, query has reached the maximum query timeout: 10000000(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again. at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:126) at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:200) at com.oceanbase.jdbc.OceanBaseStatement.executeBatchExceptionEpilogue(OceanBaseStatement.java:370) at com.oceanbase.jdbc.OceanBaseStatement.executeBatch(OceanBaseStatement.java:1487) at com.oceanbase.ocp.bootstrap.util.SQLUtils.executeBatch(SQLUtils.java:99) at com.oceanbase.ocp.bootstrap.db.DbInitializer.lambda$new$0(DbInitializer.java:93) at com.oceanbase.ocp.bootstrap.db.DbInitializer.executeSqlTask(DbInitializer.java:203) ... 49 more Caused by: com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException: Timeout, query has reached the maximum query timeout: 10000000(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again. at com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException.of(OceanBaseSqlException.java:80) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:190) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchAggregateSemiColon(AbstractQueryProtocol.java:1084) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchStmt(AbstractQueryProtocol.java:943) at com.oceanbase.jdbc.OceanBaseStatement.internalBatchExecution(OceanBaseStatement.java:1544) at com.oceanbase.jdbc.OceanBaseStatement.executeBatch(OceanBaseStatement.java:1484) ... 52 more Caused by: java.sql.SQLException: Timeout, query has reached the maximum query timeout: 10000000(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again. at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1990) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1855) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1751) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchAggregateSemiColon(AbstractQueryProtocol.java:1080) ... 55 more