【 使用环境 】测试环境
【 OB or 其他组件 】 OCP
【 使用版本 】3.1.1
【问题描述】 初始化ocp database的时候报错
【复现路径】 ./ocp_installer.sh install -c ocp.yaml
【问题现象及影响】
admin@pdmphb11 ocp-ce-3.1.1-bp1]$ ./ocp_installer.sh install -c ocp.yaml
run sql CREATE TABLE IF NOT EXISTS spring_jdbc_session (
PRIMARY_ID CHAR(36) NOT NULL,
SESSION_ID CHAR(36) NOT NULL,
CREATION_TIME BIGINT NOT NULL,
LAST_ACCESS_TIME BIGINT NOT NULL,
MAX_INACTIVE_INTERVAL INT NOT NULL,
EXPIRY_TIME BIGINT NOT NULL,
PRINCIPAL_NAME VARCHAR(100),
PRIMARY KEY (PRIMARY_ID),
KEY SPRING_SESSION_IX1 (SESSION_ID),
KEY SPRING_SESSION_IX2 (EXPIRY_TIME),
KEY SPRING_SESSION_IX3 (PRINCIPAL_NAME)
); got exception Traceback (most recent call last):
File “create_metadb.py”, line 493, in execute_sql_file
run_sql_no_result(sql, config)
File “create_metadb.py”, line 62, in run_sql_no_result
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)
ProgrammingError: 1280 (42000): Incorrect index name 'SPRING_SESSION_IX1 ’
Traceback (most recent call last):
File “create_metadb.py”, line 714, in
init_ocp(filename)
File “create_metadb.py”, line 538, in init_ocp
init_meta_db(meta_db_connect_info)
File “create_metadb.py”, line 602, in init_meta_db
source_sqls(db_connect_info, sqls)
File “create_metadb.py”, line 480, in source_sqls
execute_sql_file(config, “…/…/sqls/{}”.format(real_file))
File “create_metadb.py”, line 499, in execute_sql_file
raise e
mysql.connector.errors.ProgrammingError: 1280 (42000): Incorrect index name 'SPRING_SESSION_IX1 ’
init ocp databse failed on 10.249.240.11
[admin@pdmphb11 ocp-ce-3.1.1-bp1]$
初始化ocp 库中的建表语句里 index 后面都会有个 空格 ， 去掉空格后即可执行成功。 已重复多次初始化（已先删除OCP库），结果都是一样报错。
KEY `SPRING_SESSION_IX1 `(SESSION_ID),
KEY `SPRING_SESSION_IX2 `(EXPIRY_TIME),
KEY `SPRING_SESSION_IX3 `(PRINCIPAL_NAME)