[2023-10-23T17:16:58.007] BEGIN dataSource INSTALL - [2023-10-23T17:16:58.015] BEGIN dataSource CREATE_TABLES - 22 [2023-10-23T17:16:58.018] BEGIN dataSource CREATE_TABLES sqls:credential 1 [2023-10-23T17:16:58.400] END dataSource CREATE_TABLES sqls:credential [2023-10-23T17:16:58.400] BEGIN dataSource CREATE_TABLES sqls:ob_agent 1 [2023-10-23T17:16:58.684] END dataSource CREATE_TABLES sqls:ob_agent [2023-10-23T17:16:58.684] BEGIN dataSource CREATE_TABLES sqls:config_properties 1 [2023-10-23T17:16:59.037] END dataSource CREATE_TABLES sqls:config_properties [2023-10-23T17:16:59.037] BEGIN dataSource CREATE_TABLES sqls:metric_data_minute 1 [2023-10-23T17:16:59.398] END dataSource CREATE_TABLES sqls:metric_data_minute [2023-10-23T17:16:59.399] BEGIN dataSource CREATE_TABLES sqls:metric_data_second 1 [2023-10-23T17:16:59.760] END dataSource CREATE_TABLES sqls:metric_data_second [2023-10-23T17:16:59.760] BEGIN dataSource CREATE_TABLES sqls:ocp_metric_series_key_id 1 [2023-10-23T17:16:59.974] END dataSource CREATE_TABLES sqls:ocp_metric_series_key_id [2023-10-23T17:16:59.974] BEGIN dataSource CREATE_TABLES sqls:ob_tenant 1 [2023-10-23T17:17:00.351] END dataSource CREATE_TABLES sqls:ob_tenant [2023-10-23T17:17:00.352] BEGIN dataSource CREATE_TABLES sqls:ob_tenant_compaction 1 [2023-10-23T17:17:00.558] END dataSource CREATE_TABLES sqls:ob_tenant_compaction [2023-10-23T17:17:00.559] BEGIN dataSource CREATE_TABLES sqls:metric_class 1 [2023-10-23T17:17:00.979] END dataSource CREATE_TABLES sqls:metric_class [2023-10-23T17:17:00.979] BEGIN dataSource CREATE_TABLES sqls:metric_group 1 [2023-10-23T17:17:01.346] END dataSource CREATE_TABLES sqls:metric_group [2023-10-23T17:17:01.346] BEGIN dataSource CREATE_TABLES sqls:metric_meta 1 [2023-10-23T17:17:01.576] END dataSource CREATE_TABLES sqls:metric_meta [2023-10-23T17:17:01.576] BEGIN dataSource CREATE_TABLES sqls:ocp_metric_expr_config 1 [2023-10-23T17:17:01.891] END dataSource CREATE_TABLES sqls:ocp_metric_expr_config [2023-10-23T17:17:01.891] BEGIN dataSource CREATE_TABLES sqls:metric_exporter_address 1 [2023-10-23T17:17:02.102] END dataSource CREATE_TABLES sqls:metric_exporter_address [2023-10-23T17:17:02.102] BEGIN dataSource CREATE_TABLES sqls:iam_user 1 [2023-10-23T17:17:02.465] END dataSource CREATE_TABLES sqls:iam_user [2023-10-23T17:17:02.466] BEGIN dataSource CREATE_TABLES sqls:iam_user_login_record 1 [2023-10-23T17:17:02.823] END dataSource CREATE_TABLES sqls:iam_user_login_record [2023-10-23T17:17:02.824] BEGIN dataSource CREATE_TABLES sqls:task_definition 1 [2023-10-23T17:17:03.021] END dataSource CREATE_TABLES sqls:task_definition [2023-10-23T17:17:03.022] BEGIN dataSource CREATE_TABLES sqls:task_template 1 [2023-10-23T17:17:03.421] END dataSource CREATE_TABLES sqls:task_template [2023-10-23T17:17:03.422] BEGIN dataSource CREATE_TABLES sqls:subtask_instance 1 [2023-10-23T17:17:03.717] END dataSource CREATE_TABLES sqls:subtask_instance [2023-10-23T17:17:03.717] BEGIN dataSource CREATE_TABLES sqls:subtask_log 1 [2023-10-23T17:17:04.123] END dataSource CREATE_TABLES sqls:subtask_log [2023-10-23T17:17:04.123] BEGIN dataSource CREATE_TABLES sqls:subtask_dependencies 1 [2023-10-23T17:17:04.352] END dataSource CREATE_TABLES sqls:subtask_dependencies [2023-10-23T17:17:04.352] BEGIN dataSource CREATE_TABLES sqls:task_instance 1 [2023-10-23T17:17:04.789] END dataSource CREATE_TABLES sqls:task_instance [2023-10-23T17:17:04.790] BEGIN dataSource CREATE_TABLES sqls:ocp_instance 1 [2023-10-23T17:17:05.026] END dataSource CREATE_TABLES sqls:ocp_instance [2023-10-23T17:17:05.026] END dataSource CREATE_TABLES - [2023-10-23T17:17:05.159] BEGIN dataSource DEFAULT_DATA - 8 [2023-10-23T17:17:05.160] BEGIN dataSource DEFAULT_DATA sqls:task_template 1 [2023-10-23T17:17:05.206] END dataSource DEFAULT_DATA sqls:task_template [2023-10-23T17:17:05.207] BEGIN dataSource DEFAULT_DATA sqls:task_definition 1 [2023-10-23T17:17:05.329] END dataSource DEFAULT_DATA sqls:task_definition [2023-10-23T17:17:05.330] BEGIN dataSource DEFAULT_DATA sqls:iam_user 2 [2023-10-23T17:17:05.382] END dataSource DEFAULT_DATA sqls:iam_user [2023-10-23T17:17:05.382] BEGIN dataSource DEFAULT_DATA sqls:config_properties 83 [2023-10-23T17:17:05.735] END dataSource DEFAULT_DATA sqls:config_properties [2023-10-23T17:17:05.736] BEGIN dataSource DEFAULT_DATA sqls:ocp_metric_expr_config 246 [2023-10-23T17:17:06.875] END dataSource DEFAULT_DATA sqls:ocp_metric_expr_config [2023-10-23T17:17:06.875] BEGIN dataSource DEFAULT_DATA sqls:metric_group 51 [2023-10-23T17:17:07.335] END dataSource DEFAULT_DATA sqls:metric_group [2023-10-23T17:17:07.335] BEGIN dataSource DEFAULT_DATA sqls:metric_meta 141 [2023-10-23T17:17:07.874] END dataSource DEFAULT_DATA sqls:metric_meta [2023-10-23T17:17:07.874] BEGIN dataSource DEFAULT_DATA sqls:metric_class 5 [2023-10-23T17:17:08.042] END dataSource DEFAULT_DATA sqls:metric_class [2023-10-23T17:17:08.042] END dataSource DEFAULT_DATA - [2023-10-23T17:17:08.050] BEGIN dataSource CONFIG_PROPERTIES - 3 [2023-10-23T17:17:08.051] BEGIN dataSource CONFIG_PROPERTIES property:logging.file.name /data/oceanbase/ocpexpress/log/ocp-express.log [2023-10-23T17:17:08.073] END dataSource CONFIG_PROPERTIES property:logging.file.name [2023-10-23T17:17:08.073] BEGIN dataSource CONFIG_PROPERTIES property:logging.file.total-size-cap 1GB [2023-10-23T17:17:08.091] END dataSource CONFIG_PROPERTIES property:logging.file.total-size-cap [2023-10-23T17:17:08.092] BEGIN dataSource CONFIG_PROPERTIES property:logging.file.max-size 100MB [2023-10-23T17:17:08.104] END dataSource CONFIG_PROPERTIES property:logging.file.max-size [2023-10-23T17:17:08.127] END dataSource CONFIG_PROPERTIES - [2023-10-23T17:17:08.329] END dataSource INSTALL - [2024-08-13T10:54:23.358] BEGIN dataSource INSTALL - [2024-08-13T10:54:23.366] BEGIN dataSource CREATE_TABLES - 22 [2024-08-13T10:54:23.369] BEGIN dataSource CREATE_TABLES sqls:credential 1 [2024-08-13T10:54:23.382] END dataSource CREATE_TABLES sqls:credential [2024-08-13T10:54:23.382] BEGIN dataSource CREATE_TABLES sqls:config_properties 1 [2024-08-13T10:54:23.407] END dataSource CREATE_TABLES sqls:config_properties java.sql.SQLSyntaxErrorException: Could not connect to address=(host=192.168.11.170)(port=2883)(type=master) : (conn=262159) Null value at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:108) at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:235) at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1513) at com.oceanbase.jdbc.internal.util.Utils.retrieveProxy(Utils.java:1206) at com.oceanbase.jdbc.OceanBaseConnection.newConnection(OceanBaseConnection.java:294) at com.oceanbase.jdbc.Driver.connect(Driver.java:88) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:208) at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:155) at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:146) at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver(AbstractDriverBasedDataSource.java:205) at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnection(AbstractDriverBasedDataSource.java:169) at com.oceanbase.ocp.bootstrap.util.SQLUtils.executeBatch(SQLUtils.java:94) at com.oceanbase.ocp.bootstrap.db.DbInitializer.lambda$new$0(DbInitializer.java:93) at com.oceanbase.ocp.bootstrap.db.DbInitializer.executeSqlTask(DbInitializer.java:207) at com.oceanbase.ocp.bootstrap.db.DbInitializer.executeSqlTasks(DbInitializer.java:198) at com.oceanbase.ocp.bootstrap.db.DbInitializer.install(DbInitializer.java:113) 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:1249) 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:920) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583) at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:731) at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:408) 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:1249) 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:1303) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1292) 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.SQLSyntaxErrorException: (conn=262159) Null value at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:108) at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:230) at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.authenticationHandler(AbstractConnectProtocol.java:776) at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:584) at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1508) ... 61 more [2024-08-13T10:54:23.410] END dataSource INSTALL - java.lang.IllegalStateException: java.sql.SQLSyntaxErrorException: Could not connect to address=(host=192.168.11.170)(port=2883)(type=master) : (conn=262159) Null value at com.oceanbase.ocp.bootstrap.db.DbInitializer.executeSqlTask(DbInitializer.java:225) at com.oceanbase.ocp.bootstrap.db.DbInitializer.executeSqlTasks(DbInitializer.java:198) at com.oceanbase.ocp.bootstrap.db.DbInitializer.install(DbInitializer.java:113) 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:1249) 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:920) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583) at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:731) at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:408) 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:1249) 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:1303) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1292) 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.SQLSyntaxErrorException: Could not connect to address=(host=192.168.11.170)(port=2883)(type=master) : (conn=262159) Null value at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:108) at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:235) at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1513) at com.oceanbase.jdbc.internal.util.Utils.retrieveProxy(Utils.java:1206) at com.oceanbase.jdbc.OceanBaseConnection.newConnection(OceanBaseConnection.java:294) at com.oceanbase.jdbc.Driver.connect(Driver.java:88) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:208) at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:155) at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:146) at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver(AbstractDriverBasedDataSource.java:205) at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnection(AbstractDriverBasedDataSource.java:169) at com.oceanbase.ocp.bootstrap.util.SQLUtils.executeBatch(SQLUtils.java:94) at com.oceanbase.ocp.bootstrap.db.DbInitializer.lambda$new$0(DbInitializer.java:93) at com.oceanbase.ocp.bootstrap.db.DbInitializer.executeSqlTask(DbInitializer.java:207) ... 49 more Caused by: java.sql.SQLSyntaxErrorException: (conn=262159) Null value at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:108) at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:230) at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.authenticationHandler(AbstractConnectProtocol.java:776) at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:584) at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1508) ... 61 more