[2023-04-13T12:19:32.754] BEGIN dataSource INSTALL - [2023-04-13T12:19:32.759] BEGIN dataSource CREATE_TABLES - 24 [2023-04-13T12:19:32.760] BEGIN dataSource CREATE_TABLES sqls:config_properties 1 [2023-04-13T12:19:36.249] END dataSource CREATE_TABLES sqls:config_properties [2023-04-13T12:19:36.249] BEGIN dataSource CREATE_TABLES sqls:credential 1 [2023-04-13T12:19:39.700] END dataSource CREATE_TABLES sqls:credential [2023-04-13T12:19:39.700] BEGIN dataSource CREATE_TABLES sqls:ob_agent 1 [2023-04-13T12:19:44.653] END dataSource CREATE_TABLES sqls:ob_agent [2023-04-13T12:19:44.653] BEGIN dataSource CREATE_TABLES sqls:metric_class 1 [2023-04-13T12:19:48.242] END dataSource CREATE_TABLES sqls:metric_class [2023-04-13T12:19:48.242] BEGIN dataSource CREATE_TABLES sqls:metric_group 1 [2023-04-13T12:19:50.934] END dataSource CREATE_TABLES sqls:metric_group [2023-04-13T12:19:50.934] BEGIN dataSource CREATE_TABLES sqls:metric_meta 1 [2023-04-13T12:19:54.440] END dataSource CREATE_TABLES sqls:metric_meta [2023-04-13T12:19:54.440] BEGIN dataSource CREATE_TABLES sqls:ocp_metric_expr_config 1 [2023-04-13T12:19:56.498] END dataSource CREATE_TABLES sqls:ocp_metric_expr_config [2023-04-13T12:19:56.498] BEGIN dataSource CREATE_TABLES sqls:metric_exporter_address 1 [2023-04-13T12:19:59.434] END dataSource CREATE_TABLES sqls:metric_exporter_address [2023-04-13T12:19:59.434] BEGIN dataSource CREATE_TABLES sqls:ob_tenant 1 [2023-04-13T12:20:02.897] END dataSource CREATE_TABLES sqls:ob_tenant [2023-04-13T12:20:02.897] BEGIN dataSource CREATE_TABLES sqls:ob_tenant_compaction 1 [2023-04-13T12:20:05.126] END dataSource CREATE_TABLES sqls:ob_tenant_compaction [2023-04-13T12:20:05.127] BEGIN dataSource CREATE_TABLES sqls:task_definition 1 [2023-04-13T12:20:07.245] END dataSource CREATE_TABLES sqls:task_definition [2023-04-13T12:20:07.245] BEGIN dataSource CREATE_TABLES sqls:task_template 1 [2023-04-13T12:20:10.535] END dataSource CREATE_TABLES sqls:task_template [2023-04-13T12:20:10.535] BEGIN dataSource CREATE_TABLES sqls:subtask_instance 1 [2023-04-13T12:20:16.405] END dataSource CREATE_TABLES sqls:subtask_instance [2023-04-13T12:20:16.405] BEGIN dataSource CREATE_TABLES sqls:subtask_log 1 [2023-04-13T12:20:19.402] END dataSource CREATE_TABLES sqls:subtask_log [2023-04-13T12:20:19.402] BEGIN dataSource CREATE_TABLES sqls:subtask_dependencies 1 [2023-04-13T12:20:22.208] END dataSource CREATE_TABLES sqls:subtask_dependencies [2023-04-13T12:20:22.208] BEGIN dataSource CREATE_TABLES sqls:task_instance 1 [2023-04-13T12:20:27.414] END dataSource CREATE_TABLES sqls:task_instance [2023-04-13T12:20:27.414] BEGIN dataSource CREATE_TABLES sqls:ocp_instance 1 [2023-04-13T12:20:29.552] END dataSource CREATE_TABLES sqls:ocp_instance [2023-04-13T12:20:29.553] BEGIN dataSource CREATE_TABLES sqls:metric_data_minute 1 [2023-04-13T12:20:35.498] END dataSource CREATE_TABLES sqls:metric_data_minute [2023-04-13T12:20:35.499] BEGIN dataSource CREATE_TABLES sqls:metric_data_second 1 [2023-04-13T12:20:37.691] END dataSource CREATE_TABLES sqls:metric_data_second [2023-04-13T12:20:37.691] BEGIN dataSource CREATE_TABLES sqls:ocp_metric_series_key_id 1 [2023-04-13T12:20:39.619] END dataSource CREATE_TABLES sqls:ocp_metric_series_key_id [2023-04-13T12:20:39.619] BEGIN dataSource CREATE_TABLES sqls:iam_user 1 [2023-04-13T12:20:42.931] END dataSource CREATE_TABLES sqls:iam_user [2023-04-13T12:20:42.931] BEGIN dataSource CREATE_TABLES sqls:iam_user_login_record 1 [2023-04-13T12:20:46.108] END dataSource CREATE_TABLES sqls:iam_user_login_record [2023-04-13T12:20:46.108] BEGIN dataSource CREATE_TABLES sqls:profile_credential 1 [2023-04-13T12:20:48.961] END dataSource CREATE_TABLES sqls:profile_credential [2023-04-13T12:20:48.961] BEGIN dataSource CREATE_TABLES sqls:profile_credential_access 1 [2023-04-13T12:20:51.474] END dataSource CREATE_TABLES sqls:profile_credential_access [2023-04-13T12:20:51.474] END dataSource CREATE_TABLES - [2023-04-13T12:20:51.590] BEGIN dataSource DEFAULT_DATA - 8 [2023-04-13T12:20:51.590] BEGIN dataSource DEFAULT_DATA sqls:task_template 1 [2023-04-13T12:20:52.386] END dataSource DEFAULT_DATA sqls:task_template [2023-04-13T12:20:52.386] BEGIN dataSource DEFAULT_DATA sqls:task_definition 1 [2023-04-13T12:20:52.862] END dataSource DEFAULT_DATA sqls:task_definition [2023-04-13T12:20:52.862] BEGIN dataSource DEFAULT_DATA sqls:iam_user 2 [2023-04-13T12:20:55.445] END dataSource DEFAULT_DATA sqls:iam_user [2023-04-13T12:20:55.445] BEGIN dataSource DEFAULT_DATA sqls:config_properties 82 [2023-04-13T12:21:05.424] END dataSource DEFAULT_DATA sqls:config_properties java.sql.SQLException: execute sql task failed. task: config_properties, sql:INSERT INTO `config_properties`(`key`,`default_value`,`need_restart`,`fatal`,`visible_level`,`description`,`description_en`) VALUES ('spring.datasource.druid.initial-size','10',true,true,'PRIVATE','初始化时建立物理连接的个数。重启生效','The number of physical connections established during initialization. Restart to take effect') ON DUPLICATE KEY UPDATE `description`='初始化时建立物理连接的个数。重启生效',`description_en`='The number of physical connections established during initialization. Restart to take effect',`fatal`=true,`need_restart`=true,`visible_level`='PRIVATE',`default_value`='10' 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:1259) 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:1259) 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.SQLInvalidAuthorizationSpecException: (conn=127) Statement timeout occurred, please set the variable ob_query_timeout to a larger value an then restart the statement at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:112) 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: Statement timeout occurred, please set the variable ob_query_timeout to a larger value an then restart the statement 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: Statement timeout occurred, please set the variable ob_query_timeout to a larger value an then restart the statement 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-04-13T12:21:05.425] END dataSource INSTALL - java.lang.IllegalStateException: java.sql.SQLException: execute sql task failed. task: config_properties, sql:INSERT INTO `config_properties`(`key`,`default_value`,`need_restart`,`fatal`,`visible_level`,`description`,`description_en`) VALUES ('spring.datasource.druid.initial-size','10',true,true,'PRIVATE','初始化时建立物理连接的个数。重启生效','The number of physical connections established during initialization. Restart to take effect') ON DUPLICATE KEY UPDATE `description`='初始化时建立物理连接的个数。重启生效',`description_en`='The number of physical connections established during initialization. Restart to take effect',`fatal`=true,`need_restart`=true,`visible_level`='PRIVATE',`default_value`='10' 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:1259) 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:1259) 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: config_properties, sql:INSERT INTO `config_properties`(`key`,`default_value`,`need_restart`,`fatal`,`visible_level`,`description`,`description_en`) VALUES ('spring.datasource.druid.initial-size','10',true,true,'PRIVATE','初始化时建立物理连接的个数。重启生效','The number of physical connections established during initialization. Restart to take effect') ON DUPLICATE KEY UPDATE `description`='初始化时建立物理连接的个数。重启生效',`description_en`='The number of physical connections established during initialization. Restart to take effect',`fatal`=true,`need_restart`=true,`visible_level`='PRIVATE',`default_value`='10' at com.oceanbase.ocp.bootstrap.db.DbInitializer.executeSqlTask(DbInitializer.java:216) ... 49 more Caused by: java.sql.SQLInvalidAuthorizationSpecException: (conn=127) Statement timeout occurred, please set the variable ob_query_timeout to a larger value an then restart the statement at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:112) 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: Statement timeout occurred, please set the variable ob_query_timeout to a larger value an then restart the statement 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: Statement timeout occurred, please set the variable ob_query_timeout to a larger value an then restart the statement 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-04-13T12:23:00.463] BEGIN dataSource INSTALL - [2023-04-13T12:23:00.468] BEGIN dataSource CREATE_TABLES - 24 [2023-04-13T12:23:00.469] BEGIN dataSource CREATE_TABLES sqls:config_properties 1 [2023-04-13T12:23:00.478] END dataSource CREATE_TABLES sqls:config_properties [2023-04-13T12:23:00.478] BEGIN dataSource CREATE_TABLES sqls:credential 1 [2023-04-13T12:23:00.485] END dataSource CREATE_TABLES sqls:credential [2023-04-13T12:23:00.485] BEGIN dataSource CREATE_TABLES sqls:ob_agent 1 [2023-04-13T12:23:00.492] END dataSource CREATE_TABLES sqls:ob_agent [2023-04-13T12:23:00.492] BEGIN dataSource CREATE_TABLES sqls:metric_class 1 [2023-04-13T12:23:00.499] END dataSource CREATE_TABLES sqls:metric_class [2023-04-13T12:23:00.499] BEGIN dataSource CREATE_TABLES sqls:metric_group 1 [2023-04-13T12:23:00.505] END dataSource CREATE_TABLES sqls:metric_group [2023-04-13T12:23:00.505] BEGIN dataSource CREATE_TABLES sqls:metric_meta 1 [2023-04-13T12:23:00.512] END dataSource CREATE_TABLES sqls:metric_meta [2023-04-13T12:23:00.512] BEGIN dataSource CREATE_TABLES sqls:ocp_metric_expr_config 1 [2023-04-13T12:23:00.518] END dataSource CREATE_TABLES sqls:ocp_metric_expr_config [2023-04-13T12:23:00.519] BEGIN dataSource CREATE_TABLES sqls:metric_exporter_address 1 [2023-04-13T12:23:00.525] END dataSource CREATE_TABLES sqls:metric_exporter_address [2023-04-13T12:23:00.525] BEGIN dataSource CREATE_TABLES sqls:ob_tenant 1 [2023-04-13T12:23:00.532] END dataSource CREATE_TABLES sqls:ob_tenant [2023-04-13T12:23:00.532] BEGIN dataSource CREATE_TABLES sqls:ob_tenant_compaction 1 [2023-04-13T12:23:00.538] END dataSource CREATE_TABLES sqls:ob_tenant_compaction [2023-04-13T12:23:00.538] BEGIN dataSource CREATE_TABLES sqls:task_definition 1 [2023-04-13T12:23:00.545] END dataSource CREATE_TABLES sqls:task_definition [2023-04-13T12:23:00.545] BEGIN dataSource CREATE_TABLES sqls:task_template 1 [2023-04-13T12:23:00.552] END dataSource CREATE_TABLES sqls:task_template [2023-04-13T12:23:00.552] BEGIN dataSource CREATE_TABLES sqls:subtask_instance 1 [2023-04-13T12:23:00.559] END dataSource CREATE_TABLES sqls:subtask_instance [2023-04-13T12:23:00.559] BEGIN dataSource CREATE_TABLES sqls:subtask_log 1 [2023-04-13T12:23:00.567] END dataSource CREATE_TABLES sqls:subtask_log [2023-04-13T12:23:00.568] BEGIN dataSource CREATE_TABLES sqls:subtask_dependencies 1 [2023-04-13T12:23:00.574] END dataSource CREATE_TABLES sqls:subtask_dependencies [2023-04-13T12:23:00.574] BEGIN dataSource CREATE_TABLES sqls:task_instance 1 [2023-04-13T12:23:00.582] END dataSource CREATE_TABLES sqls:task_instance [2023-04-13T12:23:00.582] BEGIN dataSource CREATE_TABLES sqls:ocp_instance 1 [2023-04-13T12:23:00.588] END dataSource CREATE_TABLES sqls:ocp_instance [2023-04-13T12:23:00.588] BEGIN dataSource CREATE_TABLES sqls:metric_data_minute 1 [2023-04-13T12:23:00.597] END dataSource CREATE_TABLES sqls:metric_data_minute [2023-04-13T12:23:00.597] BEGIN dataSource CREATE_TABLES sqls:metric_data_second 1 [2023-04-13T12:23:00.605] END dataSource CREATE_TABLES sqls:metric_data_second [2023-04-13T12:23:00.605] BEGIN dataSource CREATE_TABLES sqls:ocp_metric_series_key_id 1 [2023-04-13T12:23:00.611] END dataSource CREATE_TABLES sqls:ocp_metric_series_key_id [2023-04-13T12:23:00.611] BEGIN dataSource CREATE_TABLES sqls:iam_user 1 [2023-04-13T12:23:00.617] END dataSource CREATE_TABLES sqls:iam_user [2023-04-13T12:23:00.617] BEGIN dataSource CREATE_TABLES sqls:iam_user_login_record 1 [2023-04-13T12:23:00.623] END dataSource CREATE_TABLES sqls:iam_user_login_record [2023-04-13T12:23:00.623] BEGIN dataSource CREATE_TABLES sqls:profile_credential 1 [2023-04-13T12:23:00.629] END dataSource CREATE_TABLES sqls:profile_credential [2023-04-13T12:23:00.629] BEGIN dataSource CREATE_TABLES sqls:profile_credential_access 1 [2023-04-13T12:23:00.636] END dataSource CREATE_TABLES sqls:profile_credential_access [2023-04-13T12:23:00.636] END dataSource CREATE_TABLES - [2023-04-13T12:23:00.751] BEGIN dataSource DEFAULT_DATA - 8 [2023-04-13T12:23:00.751] BEGIN dataSource DEFAULT_DATA sqls:task_template 1 [2023-04-13T12:23:01.037] END dataSource DEFAULT_DATA sqls:task_template [2023-04-13T12:23:01.037] BEGIN dataSource DEFAULT_DATA sqls:task_definition 1 [2023-04-13T12:23:01.232] END dataSource DEFAULT_DATA sqls:task_definition [2023-04-13T12:23:01.232] BEGIN dataSource DEFAULT_DATA sqls:iam_user 2 [2023-04-13T12:23:02.838] END dataSource DEFAULT_DATA sqls:iam_user [2023-04-13T12:23:02.838] BEGIN dataSource DEFAULT_DATA sqls:config_properties 82 [2023-04-13T12:23:13.017] END dataSource DEFAULT_DATA sqls:config_properties java.sql.SQLException: execute sql task failed. task: config_properties, sql:INSERT INTO `config_properties`(`key`,`default_value`,`need_restart`,`visible_level`,`description`,`description_en`) VALUES ('ocp.iam.csrf.url.excluded','/api/v2/iam/login.*,.*Action=(ObRootServiceInfo|ObRootServiceRegister|ObIDCRegionInfo|GetObProxyConfig|AllocateClusterIdByNameAndIdx|DeleteObRootServiceInfoByClusterName).*,/api/v2/monitor/metric/scan.*',true,'PRIVATE','可指定跳过CSRF保护的URL列表，支持正则表达式匹配，默认为：/api/v2/iam/login.*。如果启用CSRF跨站点请求伪造安全保护，该选项才生效；URL是包含path和query param的完整字符串','You can specify a URL list to skip CSRF protection, support regular expression matching, the default is: /api/v2/iam/login.*. This option will only take effect if CSRF cross-site request forgery security protection is enabled; URL is a complete string containing path and query param') ON DUPLICATE KEY UPDATE `description`='可指定跳过CSRF保护的URL列表，支持正则表达式匹配，默认为：/api/v2/iam/login.*。如果启用CSRF跨站点请求伪造安全保护，该选项才生效；URL是包含path和query param的完整字符串',`description_en`='You can specify a URL list to skip CSRF protection, support regular expression matching, the default is: /api/v2/iam/login.*. This option will only take effect if CSRF cross-site request forgery security protection is enabled; URL is a complete string containing path and query param',`need_restart`=true,`visible_level`='PRIVATE',`default_value`='/api/v2/iam/login.*,.*Action=(ObRootServiceInfo|ObRootServiceRegister|ObIDCRegionInfo|GetObProxyConfig|AllocateClusterIdByNameAndIdx|DeleteObRootServiceInfoByClusterName).*,/api/v2/monitor/metric/scan.*' 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:1259) 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:1259) 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=1048609) 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-04-13T12:23:13.018] END dataSource INSTALL - java.lang.IllegalStateException: java.sql.SQLException: execute sql task failed. task: config_properties, sql:INSERT INTO `config_properties`(`key`,`default_value`,`need_restart`,`visible_level`,`description`,`description_en`) VALUES ('ocp.iam.csrf.url.excluded','/api/v2/iam/login.*,.*Action=(ObRootServiceInfo|ObRootServiceRegister|ObIDCRegionInfo|GetObProxyConfig|AllocateClusterIdByNameAndIdx|DeleteObRootServiceInfoByClusterName).*,/api/v2/monitor/metric/scan.*',true,'PRIVATE','可指定跳过CSRF保护的URL列表，支持正则表达式匹配，默认为：/api/v2/iam/login.*。如果启用CSRF跨站点请求伪造安全保护，该选项才生效；URL是包含path和query param的完整字符串','You can specify a URL list to skip CSRF protection, support regular expression matching, the default is: /api/v2/iam/login.*. This option will only take effect if CSRF cross-site request forgery security protection is enabled; URL is a complete string containing path and query param') ON DUPLICATE KEY UPDATE `description`='可指定跳过CSRF保护的URL列表，支持正则表达式匹配，默认为：/api/v2/iam/login.*。如果启用CSRF跨站点请求伪造安全保护，该选项才生效；URL是包含path和query param的完整字符串',`description_en`='You can specify a URL list to skip CSRF protection, support regular expression matching, the default is: /api/v2/iam/login.*. This option will only take effect if CSRF cross-site request forgery security protection is enabled; URL is a complete string containing path and query param',`need_restart`=true,`visible_level`='PRIVATE',`default_value`='/api/v2/iam/login.*,.*Action=(ObRootServiceInfo|ObRootServiceRegister|ObIDCRegionInfo|GetObProxyConfig|AllocateClusterIdByNameAndIdx|DeleteObRootServiceInfoByClusterName).*,/api/v2/monitor/metric/scan.*' 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:1259) 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:1259) 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: config_properties, sql:INSERT INTO `config_properties`(`key`,`default_value`,`need_restart`,`visible_level`,`description`,`description_en`) VALUES ('ocp.iam.csrf.url.excluded','/api/v2/iam/login.*,.*Action=(ObRootServiceInfo|ObRootServiceRegister|ObIDCRegionInfo|GetObProxyConfig|AllocateClusterIdByNameAndIdx|DeleteObRootServiceInfoByClusterName).*,/api/v2/monitor/metric/scan.*',true,'PRIVATE','可指定跳过CSRF保护的URL列表，支持正则表达式匹配，默认为：/api/v2/iam/login.*。如果启用CSRF跨站点请求伪造安全保护，该选项才生效；URL是包含path和query param的完整字符串','You can specify a URL list to skip CSRF protection, support regular expression matching, the default is: /api/v2/iam/login.*. This option will only take effect if CSRF cross-site request forgery security protection is enabled; URL is a complete string containing path and query param') ON DUPLICATE KEY UPDATE `description`='可指定跳过CSRF保护的URL列表，支持正则表达式匹配，默认为：/api/v2/iam/login.*。如果启用CSRF跨站点请求伪造安全保护，该选项才生效；URL是包含path和query param的完整字符串',`description_en`='You can specify a URL list to skip CSRF protection, support regular expression matching, the default is: /api/v2/iam/login.*. This option will only take effect if CSRF cross-site request forgery security protection is enabled; URL is a complete string containing path and query param',`need_restart`=true,`visible_level`='PRIVATE',`default_value`='/api/v2/iam/login.*,.*Action=(ObRootServiceInfo|ObRootServiceRegister|ObIDCRegionInfo|GetObProxyConfig|AllocateClusterIdByNameAndIdx|DeleteObRootServiceInfoByClusterName).*,/api/v2/monitor/metric/scan.*' at com.oceanbase.ocp.bootstrap.db.DbInitializer.executeSqlTask(DbInitializer.java:216) ... 49 more Caused by: java.sql.SQLTransientConnectionException: (conn=1048609) 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-04-13T12:26:07.345] BEGIN dataSource INSTALL - [2023-04-13T12:26:07.350] BEGIN dataSource CREATE_TABLES - 24 [2023-04-13T12:26:07.351] BEGIN dataSource CREATE_TABLES sqls:config_properties 1 [2023-04-13T12:26:07.359] END dataSource CREATE_TABLES sqls:config_properties [2023-04-13T12:26:07.359] BEGIN dataSource CREATE_TABLES sqls:credential 1 [2023-04-13T12:26:07.365] END dataSource CREATE_TABLES sqls:credential [2023-04-13T12:26:07.365] BEGIN dataSource CREATE_TABLES sqls:metric_class 1 [2023-04-13T12:26:07.373] END dataSource CREATE_TABLES sqls:metric_class [2023-04-13T12:26:07.373] BEGIN dataSource CREATE_TABLES sqls:metric_group 1 [2023-04-13T12:26:07.379] END dataSource CREATE_TABLES sqls:metric_group [2023-04-13T12:26:07.379] BEGIN dataSource CREATE_TABLES sqls:metric_meta 1 [2023-04-13T12:26:07.385] END dataSource CREATE_TABLES sqls:metric_meta [2023-04-13T12:26:07.385] BEGIN dataSource CREATE_TABLES sqls:ocp_metric_expr_config 1 [2023-04-13T12:26:07.391] END dataSource CREATE_TABLES sqls:ocp_metric_expr_config [2023-04-13T12:26:07.391] BEGIN dataSource CREATE_TABLES sqls:metric_exporter_address 1 [2023-04-13T12:26:07.397] END dataSource CREATE_TABLES sqls:metric_exporter_address [2023-04-13T12:26:07.397] BEGIN dataSource CREATE_TABLES sqls:ob_agent 1 [2023-04-13T12:26:07.403] END dataSource CREATE_TABLES sqls:ob_agent [2023-04-13T12:26:07.403] BEGIN dataSource CREATE_TABLES sqls:ob_tenant 1 [2023-04-13T12:26:07.409] END dataSource CREATE_TABLES sqls:ob_tenant [2023-04-13T12:26:07.409] BEGIN dataSource CREATE_TABLES sqls:ob_tenant_compaction 1 [2023-04-13T12:26:07.416] END dataSource CREATE_TABLES sqls:ob_tenant_compaction [2023-04-13T12:26:07.416] BEGIN dataSource CREATE_TABLES sqls:task_definition 1 [2023-04-13T12:26:07.421] END dataSource CREATE_TABLES sqls:task_definition [2023-04-13T12:26:07.422] BEGIN dataSource CREATE_TABLES sqls:task_template 1 [2023-04-13T12:26:07.427] END dataSource CREATE_TABLES sqls:task_template [2023-04-13T12:26:07.428] BEGIN dataSource CREATE_TABLES sqls:subtask_instance 1 [2023-04-13T12:26:07.434] END dataSource CREATE_TABLES sqls:subtask_instance [2023-04-13T12:26:07.434] BEGIN dataSource CREATE_TABLES sqls:subtask_log 1 [2023-04-13T12:26:07.439] END dataSource CREATE_TABLES sqls:subtask_log [2023-04-13T12:26:07.440] BEGIN dataSource CREATE_TABLES sqls:subtask_dependencies 1 [2023-04-13T12:26:07.446] END dataSource CREATE_TABLES sqls:subtask_dependencies [2023-04-13T12:26:07.446] BEGIN dataSource CREATE_TABLES sqls:task_instance 1 [2023-04-13T12:26:07.454] END dataSource CREATE_TABLES sqls:task_instance [2023-04-13T12:26:07.454] BEGIN dataSource CREATE_TABLES sqls:ocp_instance 1 [2023-04-13T12:26:07.460] END dataSource CREATE_TABLES sqls:ocp_instance [2023-04-13T12:26:07.460] BEGIN dataSource CREATE_TABLES sqls:metric_data_minute 1 [2023-04-13T12:26:07.468] END dataSource CREATE_TABLES sqls:metric_data_minute [2023-04-13T12:26:07.468] BEGIN dataSource CREATE_TABLES sqls:metric_data_second 1 [2023-04-13T12:26:07.475] END dataSource CREATE_TABLES sqls:metric_data_second [2023-04-13T12:26:07.475] BEGIN dataSource CREATE_TABLES sqls:ocp_metric_series_key_id 1 [2023-04-13T12:26:07.481] END dataSource CREATE_TABLES sqls:ocp_metric_series_key_id [2023-04-13T12:26:07.481] BEGIN dataSource CREATE_TABLES sqls:iam_user 1 [2023-04-13T12:26:07.487] END dataSource CREATE_TABLES sqls:iam_user [2023-04-13T12:26:07.487] BEGIN dataSource CREATE_TABLES sqls:iam_user_login_record 1 [2023-04-13T12:26:07.494] END dataSource CREATE_TABLES sqls:iam_user_login_record [2023-04-13T12:26:07.494] BEGIN dataSource CREATE_TABLES sqls:profile_credential 1 [2023-04-13T12:26:07.500] END dataSource CREATE_TABLES sqls:profile_credential [2023-04-13T12:26:07.500] BEGIN dataSource CREATE_TABLES sqls:profile_credential_access 1 [2023-04-13T12:26:07.506] END dataSource CREATE_TABLES sqls:profile_credential_access [2023-04-13T12:26:07.506] END dataSource CREATE_TABLES - [2023-04-13T12:26:07.621] BEGIN dataSource DEFAULT_DATA - 8 [2023-04-13T12:26:07.621] BEGIN dataSource DEFAULT_DATA sqls:iam_user 2 [2023-04-13T12:26:08.753] END dataSource DEFAULT_DATA sqls:iam_user [2023-04-13T12:26:08.753] BEGIN dataSource DEFAULT_DATA sqls:task_template 1 [2023-04-13T12:26:08.878] END dataSource DEFAULT_DATA sqls:task_template [2023-04-13T12:26:08.878] BEGIN dataSource DEFAULT_DATA sqls:task_definition 1 [2023-04-13T12:26:09.154] END dataSource DEFAULT_DATA sqls:task_definition [2023-04-13T12:26:09.155] BEGIN dataSource DEFAULT_DATA sqls:ocp_metric_expr_config 246 [2023-04-13T12:26:39.193] 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 ('active_memstore_percent','100 * sum(ob_sysstat{stat_id=\"130000\",@LABELS}) by (@GBLABELS) / sum(ob_sysstat{stat_id=\"130002\",@LABELS}) by (@GBLABELS)') ON DUPLICATE KEY UPDATE `expr`='100 * sum(ob_sysstat{stat_id=\"130000\",@LABELS}) by (@GBLABELS) / sum(ob_sysstat{stat_id=\"130002\",@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:1259) 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:1259) 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.SQLNonTransientConnectionException: (conn=191) Connection timed out at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:120) 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: Connection timed out at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:188) 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.SQLNonTransientConnectionException: Read timed out at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.handleIoException(AbstractQueryProtocol.java:2361) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1839) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1748) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchAggregateSemiColon(AbstractQueryProtocol.java:1080) ... 55 more Caused by: java.net.SocketTimeoutException: Read timed out at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.socketRead(SocketInputStream.java:116) at java.net.SocketInputStream.read(SocketInputStream.java:171) at java.net.SocketInputStream.read(SocketInputStream.java:141) at java.io.FilterInputStream.read(FilterInputStream.java:133) at com.oceanbase.jdbc.internal.io.input.ReadAheadBufferedStream.fillBuffer(ReadAheadBufferedStream.java:148) at com.oceanbase.jdbc.internal.io.input.ReadAheadBufferedStream.read(ReadAheadBufferedStream.java:121) at com.oceanbase.jdbc.internal.io.input.StandardPacketInputStream.getPacketArray(StandardPacketInputStream.java:247) at com.oceanbase.jdbc.internal.io.input.StandardPacketInputStream.getPacket(StandardPacketInputStream.java:217) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1837) ... 57 more [2023-04-13T12:26:39.194] 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 ('active_memstore_percent','100 * sum(ob_sysstat{stat_id=\"130000\",@LABELS}) by (@GBLABELS) / sum(ob_sysstat{stat_id=\"130002\",@LABELS}) by (@GBLABELS)') ON DUPLICATE KEY UPDATE `expr`='100 * sum(ob_sysstat{stat_id=\"130000\",@LABELS}) by (@GBLABELS) / sum(ob_sysstat{stat_id=\"130002\",@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:1259) 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:1259) 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 ('active_memstore_percent','100 * sum(ob_sysstat{stat_id=\"130000\",@LABELS}) by (@GBLABELS) / sum(ob_sysstat{stat_id=\"130002\",@LABELS}) by (@GBLABELS)') ON DUPLICATE KEY UPDATE `expr`='100 * sum(ob_sysstat{stat_id=\"130000\",@LABELS}) by (@GBLABELS) / sum(ob_sysstat{stat_id=\"130002\",@LABELS}) by (@GBLABELS)' at com.oceanbase.ocp.bootstrap.db.DbInitializer.executeSqlTask(DbInitializer.java:216) ... 49 more Caused by: java.sql.SQLNonTransientConnectionException: (conn=191) Connection timed out at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:120) 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: Connection timed out at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:188) 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.SQLNonTransientConnectionException: Read timed out at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.handleIoException(AbstractQueryProtocol.java:2361) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1839) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1748) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchAggregateSemiColon(AbstractQueryProtocol.java:1080) ... 55 more Caused by: java.net.SocketTimeoutException: Read timed out at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.socketRead(SocketInputStream.java:116) at java.net.SocketInputStream.read(SocketInputStream.java:171) at java.net.SocketInputStream.read(SocketInputStream.java:141) at java.io.FilterInputStream.read(FilterInputStream.java:133) at com.oceanbase.jdbc.internal.io.input.ReadAheadBufferedStream.fillBuffer(ReadAheadBufferedStream.java:148) at com.oceanbase.jdbc.internal.io.input.ReadAheadBufferedStream.read(ReadAheadBufferedStream.java:121) at com.oceanbase.jdbc.internal.io.input.StandardPacketInputStream.getPacketArray(StandardPacketInputStream.java:247) at com.oceanbase.jdbc.internal.io.input.StandardPacketInputStream.getPacket(StandardPacketInputStream.java:217) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1837) ... 57 more [2023-04-13T12:34:18.858] BEGIN dataSource INSTALL - [2023-04-13T12:34:18.863] BEGIN dataSource CREATE_TABLES - 24 [2023-04-13T12:34:18.865] BEGIN dataSource CREATE_TABLES sqls:config_properties 1 [2023-04-13T12:34:18.873] END dataSource CREATE_TABLES sqls:config_properties [2023-04-13T12:34:18.874] BEGIN dataSource CREATE_TABLES sqls:credential 1 [2023-04-13T12:34:18.880] END dataSource CREATE_TABLES sqls:credential [2023-04-13T12:34:18.880] BEGIN dataSource CREATE_TABLES sqls:metric_class 1 [2023-04-13T12:34:18.887] END dataSource CREATE_TABLES sqls:metric_class [2023-04-13T12:34:18.887] BEGIN dataSource CREATE_TABLES sqls:metric_group 1 [2023-04-13T12:34:18.893] END dataSource CREATE_TABLES sqls:metric_group [2023-04-13T12:34:18.893] BEGIN dataSource CREATE_TABLES sqls:metric_meta 1 [2023-04-13T12:34:18.901] END dataSource CREATE_TABLES sqls:metric_meta [2023-04-13T12:34:18.901] BEGIN dataSource CREATE_TABLES sqls:ocp_metric_expr_config 1 [2023-04-13T12:34:18.907] END dataSource CREATE_TABLES sqls:ocp_metric_expr_config [2023-04-13T12:34:18.908] BEGIN dataSource CREATE_TABLES sqls:metric_exporter_address 1 [2023-04-13T12:34:18.914] END dataSource CREATE_TABLES sqls:metric_exporter_address [2023-04-13T12:34:18.915] BEGIN dataSource CREATE_TABLES sqls:ob_agent 1 [2023-04-13T12:34:18.921] END dataSource CREATE_TABLES sqls:ob_agent [2023-04-13T12:34:18.921] BEGIN dataSource CREATE_TABLES sqls:ob_tenant 1 [2023-04-13T12:34:18.929] END dataSource CREATE_TABLES sqls:ob_tenant [2023-04-13T12:34:18.929] BEGIN dataSource CREATE_TABLES sqls:ob_tenant_compaction 1 [2023-04-13T12:34:18.935] END dataSource CREATE_TABLES sqls:ob_tenant_compaction [2023-04-13T12:34:18.936] BEGIN dataSource CREATE_TABLES sqls:task_definition 1 [2023-04-13T12:34:18.942] END dataSource CREATE_TABLES sqls:task_definition [2023-04-13T12:34:18.942] BEGIN dataSource CREATE_TABLES sqls:task_template 1 [2023-04-13T12:34:18.949] END dataSource CREATE_TABLES sqls:task_template [2023-04-13T12:34:18.950] BEGIN dataSource CREATE_TABLES sqls:subtask_instance 1 [2023-04-13T12:34:18.957] END dataSource CREATE_TABLES sqls:subtask_instance [2023-04-13T12:34:18.957] BEGIN dataSource CREATE_TABLES sqls:subtask_log 1 [2023-04-13T12:34:18.963] END dataSource CREATE_TABLES sqls:subtask_log [2023-04-13T12:34:18.963] BEGIN dataSource CREATE_TABLES sqls:subtask_dependencies 1 [2023-04-13T12:34:18.971] END dataSource CREATE_TABLES sqls:subtask_dependencies [2023-04-13T12:34:18.972] BEGIN dataSource CREATE_TABLES sqls:task_instance 1 [2023-04-13T12:34:18.979] END dataSource CREATE_TABLES sqls:task_instance [2023-04-13T12:34:18.979] BEGIN dataSource CREATE_TABLES sqls:ocp_instance 1 [2023-04-13T12:34:18.985] END dataSource CREATE_TABLES sqls:ocp_instance [2023-04-13T12:34:18.986] BEGIN dataSource CREATE_TABLES sqls:metric_data_minute 1 [2023-04-13T12:34:18.994] END dataSource CREATE_TABLES sqls:metric_data_minute [2023-04-13T12:34:18.994] BEGIN dataSource CREATE_TABLES sqls:metric_data_second 1 [2023-04-13T12:34:19.003] END dataSource CREATE_TABLES sqls:metric_data_second [2023-04-13T12:34:19.003] BEGIN dataSource CREATE_TABLES sqls:ocp_metric_series_key_id 1 [2023-04-13T12:34:19.009] END dataSource CREATE_TABLES sqls:ocp_metric_series_key_id [2023-04-13T12:34:19.009] BEGIN dataSource CREATE_TABLES sqls:iam_user 1 [2023-04-13T12:34:19.015] END dataSource CREATE_TABLES sqls:iam_user [2023-04-13T12:34:19.015] BEGIN dataSource CREATE_TABLES sqls:iam_user_login_record 1 [2023-04-13T12:34:19.021] END dataSource CREATE_TABLES sqls:iam_user_login_record [2023-04-13T12:34:19.021] BEGIN dataSource CREATE_TABLES sqls:profile_credential 1 [2023-04-13T12:34:19.027] END dataSource CREATE_TABLES sqls:profile_credential [2023-04-13T12:34:19.027] BEGIN dataSource CREATE_TABLES sqls:profile_credential_access 1 [2023-04-13T12:34:19.033] END dataSource CREATE_TABLES sqls:profile_credential_access [2023-04-13T12:34:19.033] END dataSource CREATE_TABLES - [2023-04-13T12:34:19.149] BEGIN dataSource DEFAULT_DATA - 8 [2023-04-13T12:34:19.150] BEGIN dataSource DEFAULT_DATA sqls:iam_user 2 [2023-04-13T12:34:20.100] END dataSource DEFAULT_DATA sqls:iam_user [2023-04-13T12:34:20.100] BEGIN dataSource DEFAULT_DATA sqls:task_template 1 [2023-04-13T12:34:20.425] END dataSource DEFAULT_DATA sqls:task_template [2023-04-13T12:34:20.425] BEGIN dataSource DEFAULT_DATA sqls:task_definition 1 [2023-04-13T12:34:20.500] END dataSource DEFAULT_DATA sqls:task_definition [2023-04-13T12:34:20.500] BEGIN dataSource DEFAULT_DATA sqls:config_properties 82 [2023-04-13T12:34:50.532] END dataSource DEFAULT_DATA sqls:config_properties java.sql.SQLException: execute sql task failed. task: config_properties, sql:INSERT INTO `config_properties`(`key`,`default_value`,`need_restart`,`description`,`description_en`) VALUES ('server.servlet.session.timeout','30m',true,'登陆会话/Session超时的时间，默认是30m，最少60s。如果不加后缀单位，则默认是秒。重启生效。','Session timeout interval, default is 30m, at least 60s. If the suffix unit is not added, the default is seconds. Restart OCP to take effect.') ON DUPLICATE KEY UPDATE `description`='登陆会话/Session超时的时间，默认是30m，最少60s。如果不加后缀单位，则默认是秒。重启生效。',`description_en`='Session timeout interval, default is 30m, at least 60s. If the suffix unit is not added, the default is seconds. Restart OCP to take effect.',`need_restart`=true,`default_value`='30m' 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:1259) 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:1259) 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.SQLNonTransientConnectionException: (conn=257) Connection timed out at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:120) 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: Connection timed out at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:188) 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.SQLNonTransientConnectionException: Read timed out at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.handleIoException(AbstractQueryProtocol.java:2361) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1839) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1748) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchAggregateSemiColon(AbstractQueryProtocol.java:1080) ... 55 more Caused by: java.net.SocketTimeoutException: Read timed out at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.socketRead(SocketInputStream.java:116) at java.net.SocketInputStream.read(SocketInputStream.java:171) at java.net.SocketInputStream.read(SocketInputStream.java:141) at java.io.FilterInputStream.read(FilterInputStream.java:133) at com.oceanbase.jdbc.internal.io.input.ReadAheadBufferedStream.fillBuffer(ReadAheadBufferedStream.java:148) at com.oceanbase.jdbc.internal.io.input.ReadAheadBufferedStream.read(ReadAheadBufferedStream.java:121) at com.oceanbase.jdbc.internal.io.input.StandardPacketInputStream.getPacketArray(StandardPacketInputStream.java:247) at com.oceanbase.jdbc.internal.io.input.StandardPacketInputStream.getPacket(StandardPacketInputStream.java:217) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1837) ... 57 more [2023-04-13T12:34:50.533] END dataSource INSTALL - java.lang.IllegalStateException: java.sql.SQLException: execute sql task failed. task: config_properties, sql:INSERT INTO `config_properties`(`key`,`default_value`,`need_restart`,`description`,`description_en`) VALUES ('server.servlet.session.timeout','30m',true,'登陆会话/Session超时的时间，默认是30m，最少60s。如果不加后缀单位，则默认是秒。重启生效。','Session timeout interval, default is 30m, at least 60s. If the suffix unit is not added, the default is seconds. Restart OCP to take effect.') ON DUPLICATE KEY UPDATE `description`='登陆会话/Session超时的时间，默认是30m，最少60s。如果不加后缀单位，则默认是秒。重启生效。',`description_en`='Session timeout interval, default is 30m, at least 60s. If the suffix unit is not added, the default is seconds. Restart OCP to take effect.',`need_restart`=true,`default_value`='30m' 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:1259) 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:1259) 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: config_properties, sql:INSERT INTO `config_properties`(`key`,`default_value`,`need_restart`,`description`,`description_en`) VALUES ('server.servlet.session.timeout','30m',true,'登陆会话/Session超时的时间，默认是30m，最少60s。如果不加后缀单位，则默认是秒。重启生效。','Session timeout interval, default is 30m, at least 60s. If the suffix unit is not added, the default is seconds. Restart OCP to take effect.') ON DUPLICATE KEY UPDATE `description`='登陆会话/Session超时的时间，默认是30m，最少60s。如果不加后缀单位，则默认是秒。重启生效。',`description_en`='Session timeout interval, default is 30m, at least 60s. If the suffix unit is not added, the default is seconds. Restart OCP to take effect.',`need_restart`=true,`default_value`='30m' at com.oceanbase.ocp.bootstrap.db.DbInitializer.executeSqlTask(DbInitializer.java:216) ... 49 more Caused by: java.sql.SQLNonTransientConnectionException: (conn=257) Connection timed out at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:120) 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: Connection timed out at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:188) 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.SQLNonTransientConnectionException: Read timed out at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.handleIoException(AbstractQueryProtocol.java:2361) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1839) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1748) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchAggregateSemiColon(AbstractQueryProtocol.java:1080) ... 55 more Caused by: java.net.SocketTimeoutException: Read timed out at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.socketRead(SocketInputStream.java:116) at java.net.SocketInputStream.read(SocketInputStream.java:171) at java.net.SocketInputStream.read(SocketInputStream.java:141) at java.io.FilterInputStream.read(FilterInputStream.java:133) at com.oceanbase.jdbc.internal.io.input.ReadAheadBufferedStream.fillBuffer(ReadAheadBufferedStream.java:148) at com.oceanbase.jdbc.internal.io.input.ReadAheadBufferedStream.read(ReadAheadBufferedStream.java:121) at com.oceanbase.jdbc.internal.io.input.StandardPacketInputStream.getPacketArray(StandardPacketInputStream.java:247) at com.oceanbase.jdbc.internal.io.input.StandardPacketInputStream.getPacket(StandardPacketInputStream.java:217) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1837) ... 57 more [2023-04-13T12:49:20.075] BEGIN dataSource INSTALL - [2023-04-13T12:49:20.080] BEGIN dataSource CREATE_TABLES - 24 [2023-04-13T12:49:20.081] BEGIN dataSource CREATE_TABLES sqls:config_properties 1 [2023-04-13T12:49:20.089] END dataSource CREATE_TABLES sqls:config_properties [2023-04-13T12:49:20.090] BEGIN dataSource CREATE_TABLES sqls:credential 1 [2023-04-13T12:49:20.096] END dataSource CREATE_TABLES sqls:credential [2023-04-13T12:49:20.096] BEGIN dataSource CREATE_TABLES sqls:metric_class 1 [2023-04-13T12:49:20.103] END dataSource CREATE_TABLES sqls:metric_class [2023-04-13T12:49:20.103] BEGIN dataSource CREATE_TABLES sqls:metric_group 1 [2023-04-13T12:49:20.110] END dataSource CREATE_TABLES sqls:metric_group [2023-04-13T12:49:20.110] BEGIN dataSource CREATE_TABLES sqls:metric_meta 1 [2023-04-13T12:49:20.120] END dataSource CREATE_TABLES sqls:metric_meta [2023-04-13T12:49:20.120] BEGIN dataSource CREATE_TABLES sqls:ocp_metric_expr_config 1 [2023-04-13T12:49:20.126] END dataSource CREATE_TABLES sqls:ocp_metric_expr_config [2023-04-13T12:49:20.126] BEGIN dataSource CREATE_TABLES sqls:metric_exporter_address 1 [2023-04-13T12:49:20.133] END dataSource CREATE_TABLES sqls:metric_exporter_address [2023-04-13T12:49:20.133] BEGIN dataSource CREATE_TABLES sqls:ob_agent 1 [2023-04-13T12:49:20.140] END dataSource CREATE_TABLES sqls:ob_agent [2023-04-13T12:49:20.140] BEGIN dataSource CREATE_TABLES sqls:ob_tenant 1 [2023-04-13T12:49:20.147] END dataSource CREATE_TABLES sqls:ob_tenant [2023-04-13T12:49:20.147] BEGIN dataSource CREATE_TABLES sqls:ob_tenant_compaction 1 [2023-04-13T12:49:20.155] END dataSource CREATE_TABLES sqls:ob_tenant_compaction [2023-04-13T12:49:20.155] BEGIN dataSource CREATE_TABLES sqls:task_definition 1 [2023-04-13T12:49:20.163] END dataSource CREATE_TABLES sqls:task_definition [2023-04-13T12:49:20.163] BEGIN dataSource CREATE_TABLES sqls:task_template 1 [2023-04-13T12:49:20.169] END dataSource CREATE_TABLES sqls:task_template [2023-04-13T12:49:20.170] BEGIN dataSource CREATE_TABLES sqls:subtask_instance 1 [2023-04-13T12:49:20.176] END dataSource CREATE_TABLES sqls:subtask_instance [2023-04-13T12:49:20.176] BEGIN dataSource CREATE_TABLES sqls:subtask_log 1 [2023-04-13T12:49:20.182] END dataSource CREATE_TABLES sqls:subtask_log [2023-04-13T12:49:20.183] BEGIN dataSource CREATE_TABLES sqls:subtask_dependencies 1 [2023-04-13T12:49:20.189] END dataSource CREATE_TABLES sqls:subtask_dependencies [2023-04-13T12:49:20.189] BEGIN dataSource CREATE_TABLES sqls:task_instance 1 [2023-04-13T12:49:20.196] END dataSource CREATE_TABLES sqls:task_instance [2023-04-13T12:49:20.196] BEGIN dataSource CREATE_TABLES sqls:ocp_instance 1 [2023-04-13T12:49:20.202] END dataSource CREATE_TABLES sqls:ocp_instance [2023-04-13T12:49:20.202] BEGIN dataSource CREATE_TABLES sqls:metric_data_minute 1 [2023-04-13T12:49:20.210] END dataSource CREATE_TABLES sqls:metric_data_minute [2023-04-13T12:49:20.210] BEGIN dataSource CREATE_TABLES sqls:metric_data_second 1 [2023-04-13T12:49:20.218] END dataSource CREATE_TABLES sqls:metric_data_second [2023-04-13T12:49:20.218] BEGIN dataSource CREATE_TABLES sqls:ocp_metric_series_key_id 1 [2023-04-13T12:49:20.224] END dataSource CREATE_TABLES sqls:ocp_metric_series_key_id [2023-04-13T12:49:20.224] BEGIN dataSource CREATE_TABLES sqls:iam_user 1 [2023-04-13T12:49:20.230] END dataSource CREATE_TABLES sqls:iam_user [2023-04-13T12:49:20.230] BEGIN dataSource CREATE_TABLES sqls:iam_user_login_record 1 [2023-04-13T12:49:20.237] END dataSource CREATE_TABLES sqls:iam_user_login_record [2023-04-13T12:49:20.237] BEGIN dataSource CREATE_TABLES sqls:profile_credential 1 [2023-04-13T12:49:20.243] END dataSource CREATE_TABLES sqls:profile_credential [2023-04-13T12:49:20.243] BEGIN dataSource CREATE_TABLES sqls:profile_credential_access 1 [2023-04-13T12:49:20.249] END dataSource CREATE_TABLES sqls:profile_credential_access [2023-04-13T12:49:20.249] END dataSource CREATE_TABLES - [2023-04-13T12:49:20.363] BEGIN dataSource DEFAULT_DATA - 8 [2023-04-13T12:49:20.364] BEGIN dataSource DEFAULT_DATA sqls:task_template 1 [2023-04-13T12:49:20.562] END dataSource DEFAULT_DATA sqls:task_template [2023-04-13T12:49:20.562] BEGIN dataSource DEFAULT_DATA sqls:task_definition 1 [2023-04-13T12:49:20.731] END dataSource DEFAULT_DATA sqls:task_definition [2023-04-13T12:49:20.731] BEGIN dataSource DEFAULT_DATA sqls:iam_user 2 [2023-04-13T12:49:21.868] END dataSource DEFAULT_DATA sqls:iam_user [2023-04-13T12:49:21.869] BEGIN dataSource DEFAULT_DATA sqls:ocp_metric_expr_config 246 [2023-04-13T12:49:51.901] 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 ('active_memstore_percent','100 * sum(ob_sysstat{stat_id=\"130000\",@LABELS}) by (@GBLABELS) / sum(ob_sysstat{stat_id=\"130002\",@LABELS}) by (@GBLABELS)') ON DUPLICATE KEY UPDATE `expr`='100 * sum(ob_sysstat{stat_id=\"130000\",@LABELS}) by (@GBLABELS) / sum(ob_sysstat{stat_id=\"130002\",@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:1259) 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:1259) 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.SQLNonTransientConnectionException: (conn=324) Connection timed out at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:120) 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: Connection timed out at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:188) 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.SQLNonTransientConnectionException: Read timed out at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.handleIoException(AbstractQueryProtocol.java:2361) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1839) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1748) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchAggregateSemiColon(AbstractQueryProtocol.java:1080) ... 55 more Caused by: java.net.SocketTimeoutException: Read timed out at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.socketRead(SocketInputStream.java:116) at java.net.SocketInputStream.read(SocketInputStream.java:171) at java.net.SocketInputStream.read(SocketInputStream.java:141) at java.io.FilterInputStream.read(FilterInputStream.java:133) at com.oceanbase.jdbc.internal.io.input.ReadAheadBufferedStream.fillBuffer(ReadAheadBufferedStream.java:148) at com.oceanbase.jdbc.internal.io.input.ReadAheadBufferedStream.read(ReadAheadBufferedStream.java:121) at com.oceanbase.jdbc.internal.io.input.StandardPacketInputStream.getPacketArray(StandardPacketInputStream.java:247) at com.oceanbase.jdbc.internal.io.input.StandardPacketInputStream.getPacket(StandardPacketInputStream.java:217) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1837) ... 57 more [2023-04-13T12:49:51.903] 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 ('active_memstore_percent','100 * sum(ob_sysstat{stat_id=\"130000\",@LABELS}) by (@GBLABELS) / sum(ob_sysstat{stat_id=\"130002\",@LABELS}) by (@GBLABELS)') ON DUPLICATE KEY UPDATE `expr`='100 * sum(ob_sysstat{stat_id=\"130000\",@LABELS}) by (@GBLABELS) / sum(ob_sysstat{stat_id=\"130002\",@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:1259) 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:1259) 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 ('active_memstore_percent','100 * sum(ob_sysstat{stat_id=\"130000\",@LABELS}) by (@GBLABELS) / sum(ob_sysstat{stat_id=\"130002\",@LABELS}) by (@GBLABELS)') ON DUPLICATE KEY UPDATE `expr`='100 * sum(ob_sysstat{stat_id=\"130000\",@LABELS}) by (@GBLABELS) / sum(ob_sysstat{stat_id=\"130002\",@LABELS}) by (@GBLABELS)' at com.oceanbase.ocp.bootstrap.db.DbInitializer.executeSqlTask(DbInitializer.java:216) ... 49 more Caused by: java.sql.SQLNonTransientConnectionException: (conn=324) Connection timed out at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:120) 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: Connection timed out at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:188) 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.SQLNonTransientConnectionException: Read timed out at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.handleIoException(AbstractQueryProtocol.java:2361) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1839) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1748) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchAggregateSemiColon(AbstractQueryProtocol.java:1080) ... 55 more Caused by: java.net.SocketTimeoutException: Read timed out at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.socketRead(SocketInputStream.java:116) at java.net.SocketInputStream.read(SocketInputStream.java:171) at java.net.SocketInputStream.read(SocketInputStream.java:141) at java.io.FilterInputStream.read(FilterInputStream.java:133) at com.oceanbase.jdbc.internal.io.input.ReadAheadBufferedStream.fillBuffer(ReadAheadBufferedStream.java:148) at com.oceanbase.jdbc.internal.io.input.ReadAheadBufferedStream.read(ReadAheadBufferedStream.java:121) at com.oceanbase.jdbc.internal.io.input.StandardPacketInputStream.getPacketArray(StandardPacketInputStream.java:247) at com.oceanbase.jdbc.internal.io.input.StandardPacketInputStream.getPacket(StandardPacketInputStream.java:217) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1837) ... 57 more [2023-04-13T12:51:32.989] BEGIN dataSource INSTALL - [2023-04-13T12:51:32.995] BEGIN dataSource CREATE_TABLES - 24 [2023-04-13T12:51:32.996] BEGIN dataSource CREATE_TABLES sqls:metric_class 1 [2023-04-13T12:51:33.005] END dataSource CREATE_TABLES sqls:metric_class [2023-04-13T12:51:33.005] BEGIN dataSource CREATE_TABLES sqls:metric_group 1 [2023-04-13T12:51:33.011] END dataSource CREATE_TABLES sqls:metric_group [2023-04-13T12:51:33.011] BEGIN dataSource CREATE_TABLES sqls:metric_meta 1 [2023-04-13T12:51:33.018] END dataSource CREATE_TABLES sqls:metric_meta [2023-04-13T12:51:33.018] BEGIN dataSource CREATE_TABLES sqls:ocp_metric_expr_config 1 [2023-04-13T12:51:33.024] END dataSource CREATE_TABLES sqls:ocp_metric_expr_config [2023-04-13T12:51:33.025] BEGIN dataSource CREATE_TABLES sqls:metric_exporter_address 1 [2023-04-13T12:51:33.031] END dataSource CREATE_TABLES sqls:metric_exporter_address [2023-04-13T12:51:33.031] BEGIN dataSource CREATE_TABLES sqls:config_properties 1 [2023-04-13T12:51:33.038] END dataSource CREATE_TABLES sqls:config_properties [2023-04-13T12:51:33.038] BEGIN dataSource CREATE_TABLES sqls:credential 1 [2023-04-13T12:51:33.045] END dataSource CREATE_TABLES sqls:credential [2023-04-13T12:51:33.045] BEGIN dataSource CREATE_TABLES sqls:ob_agent 1 [2023-04-13T12:51:33.051] END dataSource CREATE_TABLES sqls:ob_agent [2023-04-13T12:51:33.051] BEGIN dataSource CREATE_TABLES sqls:ob_tenant 1 [2023-04-13T12:51:33.058] END dataSource CREATE_TABLES sqls:ob_tenant [2023-04-13T12:51:33.058] BEGIN dataSource CREATE_TABLES sqls:ob_tenant_compaction 1 [2023-04-13T12:51:33.065] END dataSource CREATE_TABLES sqls:ob_tenant_compaction [2023-04-13T12:51:33.065] BEGIN dataSource CREATE_TABLES sqls:task_definition 1 [2023-04-13T12:51:33.071] END dataSource CREATE_TABLES sqls:task_definition [2023-04-13T12:51:33.072] BEGIN dataSource CREATE_TABLES sqls:task_template 1 [2023-04-13T12:51:33.078] END dataSource CREATE_TABLES sqls:task_template [2023-04-13T12:51:33.078] BEGIN dataSource CREATE_TABLES sqls:subtask_instance 1 [2023-04-13T12:51:33.086] END dataSource CREATE_TABLES sqls:subtask_instance [2023-04-13T12:51:33.086] BEGIN dataSource CREATE_TABLES sqls:subtask_log 1 [2023-04-13T12:51:33.093] END dataSource CREATE_TABLES sqls:subtask_log [2023-04-13T12:51:33.093] BEGIN dataSource CREATE_TABLES sqls:subtask_dependencies 1 [2023-04-13T12:51:33.100] END dataSource CREATE_TABLES sqls:subtask_dependencies [2023-04-13T12:51:33.101] BEGIN dataSource CREATE_TABLES sqls:task_instance 1 [2023-04-13T12:51:33.108] END dataSource CREATE_TABLES sqls:task_instance [2023-04-13T12:51:33.108] BEGIN dataSource CREATE_TABLES sqls:ocp_instance 1 [2023-04-13T12:51:33.115] END dataSource CREATE_TABLES sqls:ocp_instance [2023-04-13T12:51:33.115] BEGIN dataSource CREATE_TABLES sqls:metric_data_minute 1 [2023-04-13T12:51:33.122] END dataSource CREATE_TABLES sqls:metric_data_minute [2023-04-13T12:51:33.122] BEGIN dataSource CREATE_TABLES sqls:metric_data_second 1 [2023-04-13T12:51:33.130] END dataSource CREATE_TABLES sqls:metric_data_second [2023-04-13T12:51:33.130] BEGIN dataSource CREATE_TABLES sqls:ocp_metric_series_key_id 1 [2023-04-13T12:51:33.136] END dataSource CREATE_TABLES sqls:ocp_metric_series_key_id [2023-04-13T12:51:33.136] BEGIN dataSource CREATE_TABLES sqls:iam_user 1 [2023-04-13T12:51:33.143] END dataSource CREATE_TABLES sqls:iam_user [2023-04-13T12:51:33.143] BEGIN dataSource CREATE_TABLES sqls:iam_user_login_record 1 [2023-04-13T12:51:33.149] END dataSource CREATE_TABLES sqls:iam_user_login_record [2023-04-13T12:51:33.149] BEGIN dataSource CREATE_TABLES sqls:profile_credential 1 [2023-04-13T12:51:33.155] END dataSource CREATE_TABLES sqls:profile_credential [2023-04-13T12:51:33.155] BEGIN dataSource CREATE_TABLES sqls:profile_credential_access 1 [2023-04-13T12:51:33.161] END dataSource CREATE_TABLES sqls:profile_credential_access [2023-04-13T12:51:33.161] END dataSource CREATE_TABLES - [2023-04-13T12:51:33.279] BEGIN dataSource DEFAULT_DATA - 8 [2023-04-13T12:51:33.279] BEGIN dataSource DEFAULT_DATA sqls:iam_user 2 [2023-04-13T12:51:33.968] END dataSource DEFAULT_DATA sqls:iam_user [2023-04-13T12:51:33.968] BEGIN dataSource DEFAULT_DATA sqls:task_template 1 [2023-04-13T12:51:34.418] END dataSource DEFAULT_DATA sqls:task_template [2023-04-13T12:51:34.418] BEGIN dataSource DEFAULT_DATA sqls:task_definition 1 [2023-04-13T12:51:34.673] END dataSource DEFAULT_DATA sqls:task_definition [2023-04-13T12:51:34.673] BEGIN dataSource DEFAULT_DATA sqls:config_properties 82 [2023-04-13T12:52:04.710] END dataSource DEFAULT_DATA sqls:config_properties java.sql.SQLException: execute sql task failed. task: config_properties, sql:INSERT INTO `config_properties`(`key`,`default_value`,`need_restart`,`description`,`description_en`) VALUES ('server.servlet.session.timeout','30m',true,'登陆会话/Session超时的时间，默认是30m，最少60s。如果不加后缀单位，则默认是秒。重启生效。','Session timeout interval, default is 30m, at least 60s. If the suffix unit is not added, the default is seconds. Restart OCP to take effect.') ON DUPLICATE KEY UPDATE `description`='登陆会话/Session超时的时间，默认是30m，最少60s。如果不加后缀单位，则默认是秒。重启生效。',`description_en`='Session timeout interval, default is 30m, at least 60s. If the suffix unit is not added, the default is seconds. Restart OCP to take effect.',`need_restart`=true,`default_value`='30m' 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:1259) 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:1259) 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.SQLNonTransientConnectionException: (conn=1048643) Connection timed out at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:120) 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: Connection timed out at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:188) 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.SQLNonTransientConnectionException: Read timed out at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.handleIoException(AbstractQueryProtocol.java:2361) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1839) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1748) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchAggregateSemiColon(AbstractQueryProtocol.java:1080) ... 55 more Caused by: java.net.SocketTimeoutException: Read timed out at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.socketRead(SocketInputStream.java:116) at java.net.SocketInputStream.read(SocketInputStream.java:171) at java.net.SocketInputStream.read(SocketInputStream.java:141) at java.io.FilterInputStream.read(FilterInputStream.java:133) at com.oceanbase.jdbc.internal.io.input.ReadAheadBufferedStream.fillBuffer(ReadAheadBufferedStream.java:148) at com.oceanbase.jdbc.internal.io.input.ReadAheadBufferedStream.read(ReadAheadBufferedStream.java:121) at com.oceanbase.jdbc.internal.io.input.StandardPacketInputStream.getPacketArray(StandardPacketInputStream.java:247) at com.oceanbase.jdbc.internal.io.input.StandardPacketInputStream.getPacket(StandardPacketInputStream.java:217) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1837) ... 57 more [2023-04-13T12:52:04.712] END dataSource INSTALL - java.lang.IllegalStateException: java.sql.SQLException: execute sql task failed. task: config_properties, sql:INSERT INTO `config_properties`(`key`,`default_value`,`need_restart`,`description`,`description_en`) VALUES ('server.servlet.session.timeout','30m',true,'登陆会话/Session超时的时间，默认是30m，最少60s。如果不加后缀单位，则默认是秒。重启生效。','Session timeout interval, default is 30m, at least 60s. If the suffix unit is not added, the default is seconds. Restart OCP to take effect.') ON DUPLICATE KEY UPDATE `description`='登陆会话/Session超时的时间，默认是30m，最少60s。如果不加后缀单位，则默认是秒。重启生效。',`description_en`='Session timeout interval, default is 30m, at least 60s. If the suffix unit is not added, the default is seconds. Restart OCP to take effect.',`need_restart`=true,`default_value`='30m' 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:1259) 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:1259) 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: config_properties, sql:INSERT INTO `config_properties`(`key`,`default_value`,`need_restart`,`description`,`description_en`) VALUES ('server.servlet.session.timeout','30m',true,'登陆会话/Session超时的时间，默认是30m，最少60s。如果不加后缀单位，则默认是秒。重启生效。','Session timeout interval, default is 30m, at least 60s. If the suffix unit is not added, the default is seconds. Restart OCP to take effect.') ON DUPLICATE KEY UPDATE `description`='登陆会话/Session超时的时间，默认是30m，最少60s。如果不加后缀单位，则默认是秒。重启生效。',`description_en`='Session timeout interval, default is 30m, at least 60s. If the suffix unit is not added, the default is seconds. Restart OCP to take effect.',`need_restart`=true,`default_value`='30m' at com.oceanbase.ocp.bootstrap.db.DbInitializer.executeSqlTask(DbInitializer.java:216) ... 49 more Caused by: java.sql.SQLNonTransientConnectionException: (conn=1048643) Connection timed out at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:120) 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: Connection timed out at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:188) 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.SQLNonTransientConnectionException: Read timed out at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.handleIoException(AbstractQueryProtocol.java:2361) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1839) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1748) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchAggregateSemiColon(AbstractQueryProtocol.java:1080) ... 55 more Caused by: java.net.SocketTimeoutException: Read timed out at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.socketRead(SocketInputStream.java:116) at java.net.SocketInputStream.read(SocketInputStream.java:171) at java.net.SocketInputStream.read(SocketInputStream.java:141) at java.io.FilterInputStream.read(FilterInputStream.java:133) at com.oceanbase.jdbc.internal.io.input.ReadAheadBufferedStream.fillBuffer(ReadAheadBufferedStream.java:148) at com.oceanbase.jdbc.internal.io.input.ReadAheadBufferedStream.read(ReadAheadBufferedStream.java:121) at com.oceanbase.jdbc.internal.io.input.StandardPacketInputStream.getPacketArray(StandardPacketInputStream.java:247) at com.oceanbase.jdbc.internal.io.input.StandardPacketInputStream.getPacket(StandardPacketInputStream.java:217) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1837) ... 57 more