求助:keystone同步数据库的时候提示error1071
2016-09-07 22:50:23.449 23462 ERROR oslo_db.sqlalchemy.exc_filters [-] DBAPIError exception wrapped from (pymysql.err.InternalError) (1071, u'Specified key was too long; max key length is 767 bytes') [SQL: u'\nCREATE TABLE migrate_version (\n\trepository_id VARCHAR(250) NOT NULL, \n\trepository_path TEXT, \n\tversion INTEGER, \n\tPRIMARY KEY (repository_id)\n)\n\n']
2016-09-07 22:50:23.449 23462 ERROR oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):
2016-09-07 22:50:23.449 23462 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
2016-09-07 22:50:23.449 23462 ERROR oslo_db.sqlalchemy.exc_filters context)
2016-09-07 22:50:23.449 23462 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
2016-09-07 22:50:23.449 23462 ERROR oslo_db.sqlalchemy.exc_filters cursor.execute(statement, parameters)
2016-09-07 22:50:23.449 23462 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/pymysql/cursors.py", line 158, in execute
2016-09-07 22:50:23.449 23462 ERROR oslo_db.sqlalchemy.exc_filters result = self._query(query)
2016-09-07 22:50:23.449 23462 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/pymysql/cursors.py", line 308, in _query
2016-09-07 22:50:23.449 23462 ERROR oslo_db.sqlalchemy.exc_filters conn.query(q)
2016-09-07 22:50:23.449 23462 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 820, in query
2016-09-07 22:50:23.449 23462 ERROR oslo_db.sqlalchemy.exc_filters self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2016-09-07 22:50:23.449 23462 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1002, in _read_query_result
2016-09-07 22:50:23.449 23462 ERROR oslo_db.sqlalchemy.exc_filters result.read()
2016-09-07 22:50:23.449 23462 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1285, in read
2016-09-07 22:50:23.449 23462 ERROR oslo_db.sqlalchemy.exc_filters first_packet = self.connection._read_packet()
2016-09-07 22:50:23.449 23462 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 966, in _read_packet
2016-09-07 22:50:23.449 23462 ERROR oslo_db.sqlalchemy.exc_filters packet.check_error()
2016-09-07 22:50:23.449 23462 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 394, in check_error
2016-09-07 22:50:23.449 23462 ERROR oslo_db.sqlalchemy.exc_filters err.raise_mysql_exception(self._data)
2016-09-07 22:50:23.449 23462 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 120, in raise_mysql_exception
2016-09-07 22:50:23.449 23462 ERROR oslo_db.sqlalchemy.exc_filters _check_mysql_exception(errinfo)
2016-09-07 22:50:23.449 23462 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 115, in _check_mysql_exception
2016-09-07 22:50:23.449 23462 ERROR oslo_db.sqlalchemy.exc_filters raise InternalError(errno, errorvalue)
2016-09-07 22:50:23.449 23462 ERROR oslo_db.sqlalchemy.exc_filters InternalError: (1071, u'Specified key was too long; max key length is 767 bytes')
2016-09-07 22:50:23.449 23462 ERROR oslo_db.sqlalchemy.exc_filters
2016-09-07 22:50:23.456 23462 CRITICAL keystone [-] DBError: (pymysql.err.InternalError) (1071, u'Specified key was too long; max key length is 767 bytes') [SQL: u'\nCREATE TABLE migrate_version (\n\trepository_id VARCHAR(250) NOT NULL, \n\trepository_path TEXT, \n\tversion INTEGER, \n\tPRIMARY KEY (repository_id)\n)\n\n']
......以下部分省略,报错信息都是这个
查询了相关资料得知问题出自索引长度
于是做了如下修改:
#cd /etc/mysql/mariadb.conf.d
修改下面每个文件中的字符集为utf8mb4 -> utf8,然后重启mysql,登陆mysql查询数据库默认字符集:
MariaDB [(none)]> show variables like "%char%";
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)
然后同步keystone,报错依旧,不知道为什么。。求大神指点
相关推荐
城市生命线AI大模型赋能解决方案.pptx
城市生命线AI大模型赋能解决方案.pptx
双机并联逆变器自适应虚拟阻抗下垂控制(Droop)策略Simulink仿真模型
双机并联逆变器自适应虚拟阻抗下垂控制(Droop)策略Simulink仿真模型内容概要:本文系统研究了常见的十大ADC滤波算法,旨在为模拟数字转换过程中采集到的信号提供有效的数据滤波与处理方法。文中详细介绍了多种滤波算法的原理、实现方式及其适用场景,包括限幅滤波、中位值滤波、算术平均滤波、滑动平均滤波、低通滤波等,重点分析了各类算法在抑制噪声、提高信号稳定性方面的性能表现,并结合实际应用需求对比其优缺点。通过算法仿真与实例分析,展示了不同滤波方法在动态响应速度、计算复杂度和滤波效果之间的权衡,帮助开发者根据具体工程场景选择合适的滤波策略。 适合人群:具备一定嵌入式系统或信号处理基础知识,从事传感器数据采集、工业控制、自动化设备研发等相关工作的工程师和技术人员。 使用场景及目标:①在ADC采样系统中去除高频噪声、脉冲干扰和抖动,提升数据精度;②针对不同类型的传感器信号(如温度、压力、加速度等)设计合理的软件滤波方案;③优化嵌入式系统的实时性与稳定性,减少硬件滤波成本。 阅读建议:建议结合Matlab或单片机平台动手实现文中的滤波算法,通过实际信号输入对比各算法的滤波效果,重点关注算法参数的调节对系统性能的影响,以加深理解并应用于实际项目中。
适合科研院所使用的成果全生命周期管理SaaS系统有哪些?.docx
适合科研院所使用的成果全生命周期管理SaaS系统有哪些?
企业级大模型的部署 详细指南
为什么要部署? 企业部署大模型,不是为了解决“能不能用”,而是必须把`敏感数据`和`服务的控制权`牢牢掌握在自己手里。要想数据安全,就需要实现`私有化的部署`。这里包括大语言模型、嵌入模型、重排序模型以及多模态模型等。
仓储物流管理信息化解决方案.pptx
仓储物流管理信息化解决方案.pptx


OpenStack
