[2024-01-12T09:18:33.388] dataSource BEGIN INSTALL - [2024-01-12T09:18:33.398] dataSource BEGIN CREATE_TABLES - 10 [2024-01-12T09:18:33.402] dataSource BEGIN CREATE_TABLES sqls:cmdb_config 1 [2024-01-12T09:18:33.402] dataSource LOG CREATE_TABLES sqls SqlTask{ name=cmdb_config, sqls=[ sql 0: CREATE TABLE IF NOT EXISTS `cmdb_config`( `id` bigint(20) NOT NULL AUTO_INCREMENT, `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` datetime DEFAULT CURRENT_TIMESTAMP, `name` varchar(256) NOT NULL COMMENT '配置参数的key，以<一级.二级.三级>的格式命名', `value` varchar(1024) COMMENT '配置参数的value，可以为null', `description` varchar(1024), `description_en` varchar(1024), PRIMARY KEY (`id`), UNIQUE KEY `uk_name` (`name`) GLOBAL ) DEFAULT CHARSET = utf8mb4 COMMENT = 'CMDB主机双向同步配置表' ]} [2024-01-12T09:18:48.987] dataSource END CREATE_TABLES sqls:cmdb_config [2024-01-12T09:18:48.987] dataSource BEGIN CREATE_TABLES sqls:mc_ocp_cluster_config 1 [2024-01-12T09:18:48.987] dataSource LOG CREATE_TABLES sqls SqlTask{ name=mc_ocp_cluster_config, sqls=[ sql 0: CREATE TABLE IF NOT EXISTS `mc_ocp_cluster_config`( `id` bigint(20) NOT NULL AUTO_INCREMENT, `name` varchar(64) NOT NULL COMMENT '参数名', `description` varchar(4096) COMMENT '描述', `default_value` varchar(4096) COMMENT '默认参数值', `current_value` varchar(4096) COMMENT '当前参数值', `config_type` varchar(32) COMMENT 'RUNTIME, REBOOT, BOOTSTRAP', `create_time` datetime DEFAULT CURRENT_TIMESTAMP, `update_time` datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) GLOBAL ) AUTO_INCREMENT = 2000001 DEFAULT CHARSET = utf8mb4 COMMENT = 'OCP 集群配置表' ]} [2024-01-12T09:18:58.146] dataSource END CREATE_TABLES sqls:mc_ocp_cluster_config [2024-01-12T09:18:58.146] dataSource BEGIN CREATE_TABLES sqls:maz_azone 1 [2024-01-12T09:18:58.146] dataSource LOG CREATE_TABLES sqls SqlTask{ name=maz_azone, sqls=[ sql 0: CREATE TABLE IF NOT EXISTS `maz_azone`( `id` bigint(20) NOT NULL AUTO_INCREMENT, `create_time` datetime DEFAULT CURRENT_TIMESTAMP, `update_time` datetime DEFAULT CURRENT_TIMESTAMP, `name` varchar(128) NOT NULL COMMENT '名称', `description` varchar(256) COMMENT '描述', PRIMARY KEY (`id`), UNIQUE KEY `uk_maz_azone_name` (`name`) GLOBAL ) AUTO_INCREMENT = 1001 DEFAULT CHARSET = utf8mb4 COMMENT = '可用区' ]} [2024-01-12T09:19:15.065] dataSource END CREATE_TABLES sqls:maz_azone [2024-01-12T09:19:15.065] dataSource BEGIN CREATE_TABLES sqls:maz_azone_config 1 [2024-01-12T09:19:15.065] dataSource LOG CREATE_TABLES sqls SqlTask{ name=maz_azone_config, sqls=[ sql 0: CREATE TABLE IF NOT EXISTS `maz_azone_config`( `id` bigint(20) NOT NULL AUTO_INCREMENT, `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `azone_id` bigint(20) NOT NULL COMMENT 'Azone的Id', `key` varchar(256) NOT NULL COMMENT '参数名称', `description` varchar(256) COMMENT '参数描述信息', `value` varchar(1024) COMMENT '参数当前值', PRIMARY KEY (`id`), UNIQUE KEY `uk_maz_azone_config_key` (`azone_id`, `key`) GLOBAL ) DEFAULT CHARSET = utf8mb4 COMMENT = '可用区的参数配置' ]} [2024-01-12T09:19:50.297] dataSource END CREATE_TABLES sqls:maz_azone_config [2024-01-12T09:19:50.297] dataSource BEGIN CREATE_TABLES sqls:config_properties 1 [2024-01-12T09:19:50.297] dataSource LOG CREATE_TABLES sqls SqlTask{ name=config_properties, sqls=[ sql 0: CREATE TABLE IF NOT EXISTS `config_properties`( `id` bigint(20) NOT NULL AUTO_INCREMENT, `key` varchar(256) NOT NULL COMMENT '配置参数的key，以<一级.二级.三级>的格式命名', `default_value` varchar(1024) COMMENT '配置参数的value 的默认值，可以为null，当未设置value时，取default_value作为值', `value` varchar(1024) COMMENT '配置参数的value，可以为null', `need_restart` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否重启生效', `application` varchar(128) NOT NULL DEFAULT 'ocp' COMMENT 'spring.application.name', `profile` varchar(128) NOT NULL DEFAULT 'default' COMMENT 'spring.cloud.config.profile', `label` varchar(128) NOT NULL DEFAULT 'master' COMMENT 'spring.cloud.config.label', `fatal` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否是“致命性”的参数，只有“非致命性”的参数才支持运行时修改', `visible_level` varchar(64) NOT NULL DEFAULT 'PUBLIC' COMMENT '可见级别', `description` varchar(1024), `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `description_en` varchar(1024), `is_az_level` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否同时作为为Azone级别的参数', PRIMARY KEY (`id`), UNIQUE KEY `uk_config_properties_key_application_profile_label` (`key`, `application`, `profile`, `label`) GLOBAL ) DEFAULT CHARSET = utf8mb4 COMMENT = 'OCP应用参数配置表' ]} [2024-01-12T09:20:24.978] dataSource END CREATE_TABLES sqls:config_properties java.sql.SQLException: execute sql task failed. task: config_properties, sql + -1: at com.oceanbase.ocp.bootstrap.core.db.DbInitializer.executeSqlTask(DbInitializer.java:341) at com.oceanbase.ocp.bootstrap.core.db.DbInitializer.executeSqlTasks(DbInitializer.java:308) at com.oceanbase.ocp.bootstrap.core.db.DbInitializer.install(DbInitializer.java:208) at com.oceanbase.ocp.bootstrap.core.db.DbInitializer.initialize(DbInitializer.java:180) at com.oceanbase.ocp.bootstrap.hooks.OCPInitializer.initDataSource(OCPInitializer.java:153) at com.oceanbase.ocp.bootstrap.hooks.OCPInitializer.initialize(OCPInitializer.java:73) at com.oceanbase.ocp.bootstrap.hooks.OCPInitializer.initialize(OCPInitializer.java:113) at com.oceanbase.ocp.bootstrap.spring.BootstrapRunListener.(BootstrapRunListener.java:59) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:211) at org.springframework.boot.SpringApplication.createSpringFactoriesInstances(SpringApplication.java:445) at org.springframework.boot.SpringApplication.getSpringFactoriesInstances(SpringApplication.java:431) at org.springframework.boot.SpringApplication.getRunListeners(SpringApplication.java:419) at org.springframework.boot.SpringApplication.run(SpringApplication.java:297) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1303) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1292) at com.oceanbase.ocp.OcpServerApplication.main(OcpServerApplication.java:20) 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:108) 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=1048578) Timeout at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:128) at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:202) at com.oceanbase.jdbc.OceanBaseStatement.executeBatchExceptionEpilogue(OceanBaseStatement.java:441) at com.oceanbase.jdbc.OceanBaseStatement.executeBatchExceptionEpilogue(OceanBaseStatement.java:448) at com.oceanbase.jdbc.OceanBaseStatement.executeBatch(OceanBaseStatement.java:1610) at com.alibaba.druid.pool.DruidPooledStatement.executeBatch(DruidPooledStatement.java:803) at com.oceanbase.ocp.bootstrap.util.SQLUtils.executeBatch(SQLUtils.java:141) at com.oceanbase.ocp.bootstrap.core.db.DbInitializer.lambda$new$1(DbInitializer.java:172) at com.oceanbase.ocp.bootstrap.core.db.DbInitializer.executeSqlTask(DbInitializer.java:324) ... 27 more Caused by: com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException: Timeout at com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException.of(OceanBaseSqlException.java:79) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:199) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchAggregateSemiColon(AbstractQueryProtocol.java:1115) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchStmt(AbstractQueryProtocol.java:973) at com.oceanbase.jdbc.OceanBaseStatement.internalBatchExecution(OceanBaseStatement.java:1672) at com.oceanbase.jdbc.OceanBaseStatement.executeBatch(OceanBaseStatement.java:1607) ... 31 more Caused by: java.sql.SQLException: Timeout at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:2192) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:2057) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1951) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchAggregateSemiColon(AbstractQueryProtocol.java:1112) ... 34 more [2024-01-12T09:20:24.979] dataSource END INSTALL - java.lang.IllegalStateException: java.sql.SQLException: execute sql task failed. task: config_properties, sql + -1: at com.oceanbase.ocp.bootstrap.core.db.DbInitializer.executeSqlTask(DbInitializer.java:343) at com.oceanbase.ocp.bootstrap.core.db.DbInitializer.executeSqlTasks(DbInitializer.java:308) at com.oceanbase.ocp.bootstrap.core.db.DbInitializer.install(DbInitializer.java:208) at com.oceanbase.ocp.bootstrap.core.db.DbInitializer.initialize(DbInitializer.java:180) at com.oceanbase.ocp.bootstrap.hooks.OCPInitializer.initDataSource(OCPInitializer.java:153) at com.oceanbase.ocp.bootstrap.hooks.OCPInitializer.initialize(OCPInitializer.java:73) at com.oceanbase.ocp.bootstrap.hooks.OCPInitializer.initialize(OCPInitializer.java:113) at com.oceanbase.ocp.bootstrap.spring.BootstrapRunListener.(BootstrapRunListener.java:59) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:211) at org.springframework.boot.SpringApplication.createSpringFactoriesInstances(SpringApplication.java:445) at org.springframework.boot.SpringApplication.getSpringFactoriesInstances(SpringApplication.java:431) at org.springframework.boot.SpringApplication.getRunListeners(SpringApplication.java:419) at org.springframework.boot.SpringApplication.run(SpringApplication.java:297) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1303) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1292) at com.oceanbase.ocp.OcpServerApplication.main(OcpServerApplication.java:20) 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:108) 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 + -1: at com.oceanbase.ocp.bootstrap.core.db.DbInitializer.executeSqlTask(DbInitializer.java:341) ... 27 more Caused by: java.sql.SQLTransientConnectionException: (conn=1048578) Timeout at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:128) at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:202) at com.oceanbase.jdbc.OceanBaseStatement.executeBatchExceptionEpilogue(OceanBaseStatement.java:441) at com.oceanbase.jdbc.OceanBaseStatement.executeBatchExceptionEpilogue(OceanBaseStatement.java:448) at com.oceanbase.jdbc.OceanBaseStatement.executeBatch(OceanBaseStatement.java:1610) at com.alibaba.druid.pool.DruidPooledStatement.executeBatch(DruidPooledStatement.java:803) at com.oceanbase.ocp.bootstrap.util.SQLUtils.executeBatch(SQLUtils.java:141) at com.oceanbase.ocp.bootstrap.core.db.DbInitializer.lambda$new$1(DbInitializer.java:172) at com.oceanbase.ocp.bootstrap.core.db.DbInitializer.executeSqlTask(DbInitializer.java:324) ... 27 more Caused by: com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException: Timeout at com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException.of(OceanBaseSqlException.java:79) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:199) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchAggregateSemiColon(AbstractQueryProtocol.java:1115) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchStmt(AbstractQueryProtocol.java:973) at com.oceanbase.jdbc.OceanBaseStatement.internalBatchExecution(OceanBaseStatement.java:1672) at com.oceanbase.jdbc.OceanBaseStatement.executeBatch(OceanBaseStatement.java:1607) ... 31 more Caused by: java.sql.SQLException: Timeout at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:2192) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:2057) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1951) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchAggregateSemiColon(AbstractQueryProtocol.java:1112) ... 34 more