【 使用环境 】测试环境
【 OB or 其他组件 】 OCP4.0 ， OB4.0
【 使用版本 】4.0
【问题描述】
安装过程中，表结构初始化报错。
测试了一下，是 cpu float(5,2) 语法在OB4.0不支持。OCP的脚本没有适配OB4.0。
日志如下：
start to load sqls
replace table_group in sql file: ocp_metadb_ddl.sql
sed ‘s/$VAR_TABLEGROUP_NAME/ocp/g’ …/…/sqls/ocp_metadb_ddl.sql > …/…/sqls/real/ocp_metadb_ddl.sql
executing real sql script: real/ocp_metadb_ddl.sql
[2022-11-03 16:26:39] run sql: CREATE TABLE ocp_instance_class (
instance_class varchar(64) NOT NULL DEFAULT ‘’,
dtu int(11) DEFAULT ‘5’,
cpu float(5,2) DEFAULT NULL,
mem bigint(20) DEFAULT NULL,
disk_size bigint(20) DEFAULT NULL,
iops int(11) DEFAULT NULL,
session_num int(11) DEFAULT NULL,
PRIMARY KEY (instance_class)
) DEFAULT CHARSET = utf8mb4 COMPRESSION = ‘lz4_1.0’ REPLICA_NUM = 2 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 10; failed, got exception Traceback (most recent call last):
File “/home/admin/ocp-init/src/ocp-init/common.py”, line 207, in source_sql_file
run_sql_no_result(sql, config)
File “/home/admin/ocp-init/src/ocp-init/common.py”, line 77, in run_sql_no_result
run_sql(sql, db_config, True)
File “/home/admin/ocp-init/src/ocp-init/common.py”, line 61, in run_sql
cursor.execute(sql)
File “/usr/lib64/python2.7/site-packages/mysql/connector/cursor.py”, line 569, in execute
self._handle_result(self._connection.cmd_query(stmt))
File “/usr/lib64/python2.7/site-packages/mysql/connector/connection.py”, line 590, in cmd_query
result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query))
File “/usr/lib64/python2.7/site-packages/mysql/connector/connection.py”, line 478, in _handle_result
raise errors.get_exception(packet)
DatabaseError: 4381 (HY000): Not supported, deprecated MySQL feature