折腾了两天的错误，BError: (pymysql.err.InternalError) (1071, u‘Specified key was too long; max key length is 767 bytes‘) [SQL: u‘\nCREATE TABLE migrate_ver

2018-01-02 10:32:40.924 76081 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']
2018-01-02 10:32:40.924 76081 ERROR oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):
2018-01-02 10:32:40.924 76081 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
2018-01-02 10:32:40.924 76081 ERROR oslo_db.sqlalchemy.exc_filters     context)
2018-01-02 10:32:40.924 76081 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
2018-01-02 10:32:40.924 76081 ERROR oslo_db.sqlalchemy.exc_filters     cursor.execute(statement, parameters)
2018-01-02 10:32:40.924 76081 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python2.7/dist-packages/pymysql/cursors.py", line 166, in execute
2018-01-02 10:32:40.924 76081 ERROR oslo_db.sqlalchemy.exc_filters     result = self._query(query)
2018-01-02 10:32:40.924 76081 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python2.7/dist-packages/pymysql/cursors.py", line 322, in _query
2018-01-02 10:32:40.924 76081 ERROR oslo_db.sqlalchemy.exc_filters     conn.query(q)
2018-01-02 10:32:40.924 76081 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 835, in query
2018-01-02 10:32:40.924 76081 ERROR oslo_db.sqlalchemy.exc_filters     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2018-01-02 10:32:40.924 76081 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1019, in _read_query_result
2018-01-02 10:32:40.924 76081 ERROR oslo_db.sqlalchemy.exc_filters     result.read()
2018-01-02 10:32:40.924 76081 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1302, in read
2018-01-02 10:32:40.924 76081 ERROR oslo_db.sqlalchemy.exc_filters     first_packet = self.connection._read_packet()
2018-01-02 10:32:40.924 76081 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 981, in _read_packet
2018-01-02 10:32:40.924 76081 ERROR oslo_db.sqlalchemy.exc_filters     packet.check_error()
2018-01-02 10:32:40.924 76081 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 393, in check_error
2018-01-02 10:32:40.924 76081 ERROR oslo_db.sqlalchemy.exc_filters     err.raise_mysql_exception(self._data)
2018-01-02 10:32:40.924 76081 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 107, in raise_mysql_exception
2018-01-02 10:32:40.924 76081 ERROR oslo_db.sqlalchemy.exc_filters     raise errorclass(errno, errval)
2018-01-02 10:32:40.924 76081 ERROR oslo_db.sqlalchemy.exc_filters InternalError: (1071, u'Specified key was too long; max key length is 767 bytes')
2018-01-02 10:32:40.924 76081 ERROR oslo_db.sqlalchemy.exc_filters
2018-01-02 10:32:40.927 76081 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']
2018-01-02 10:32:40.927 76081 ERROR keystone Traceback (most recent call last):
2018-01-02 10:32:40.927 76081 ERROR keystone   File "/usr/bin/keystone-manage", line 10, in <module>
2018-01-02 10:32:40.927 76081 ERROR keystone     sys.exit(main())
2018-01-02 10:32:40.927 76081 ERROR keystone   File "/usr/lib/python2.7/dist-packages/keystone/cmd/manage.py", line 45, in main
2018-01-02 10:32:40.927 76081 ERROR keystone     cli.main(argv=sys.argv, config_files=config_files)
2018-01-02 10:32:40.927 76081 ERROR keystone   File "/usr/lib/python2.7/dist-packages/keystone/cmd/cli.py", line 1312, in main
2018-01-02 10:32:40.927 76081 ERROR keystone     CONF.command.cmd_class.main()
2018-01-02 10:32:40.927 76081 ERROR keystone   File "/usr/lib/python2.7/dist-packages/keystone/cmd/cli.py", line 467, in main
2018-01-02 10:32:40.927 76081 ERROR keystone     CONF.command.version)
2018-01-02 10:32:40.927 76081 ERROR keystone   File "/usr/lib/python2.7/dist-packages/keystone/common/sql/upgrades.py", line 251, in offline_sync_database_to_version
2018-01-02 10:32:40.927 76081 ERROR keystone     expand_schema()
2018-01-02 10:32:40.927 76081 ERROR keystone   File "/usr/lib/python2.7/dist-packages/keystone/common/sql/upgrades.py", line 271, in expand_schema
2018-01-02 10:32:40.927 76081 ERROR keystone     _sync_common_repo(version=None)
2018-01-02 10:32:40.927 76081 ERROR keystone   File "/usr/lib/python2.7/dist-packages/keystone/common/sql/upgrades.py", line 171, in _sync_common_repo
2018-01-02 10:32:40.927 76081 ERROR keystone     init_version=init_version, sanity_check=False)
2018-01-02 10:32:40.927 76081 ERROR keystone   File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/migration.py", line 73, in db_sync
2018-01-02 10:32:40.927 76081 ERROR keystone     current_version = db_version(engine, abs_path, init_version)
2018-01-02 10:32:40.927 76081 ERROR keystone   File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/migration.py", line 131, in db_version
2018-01-02 10:32:40.927 76081 ERROR keystone     db_version_control(engine, abs_path, version=init_version)

在执行su -s /bin/sh -c "keystone-manage db_sync" keystone 时

这是因为字符集不一致一样引起的

在mysql的配置文件下，修改所有的文件中的字符集格式为utf8,utf8mbz修改为utf8

root@hett-virtual-machine:/etc/mysql/mariadb.conf.d 在此配置文件下面修改

然后进入mysql 把先前创建的keystone数据库删除，重新建，就完成了啊

折腾了好几天啊 终于解决了啊

最新文章

  1. 聊天IM的时间戳显示规则
  2. AngularJS 模态对话框
  3. linux的终端，网络虚拟终端，伪终端（转）
  4. C复习手记(Day3)
  5. Oracle EBS-SQL (CST-3):检查零成本交易.sql
  6. Customizing Zend Studio Using the Welcome Page
  7. [转]sqlldr 导入乱码，Oracle客户端字符集问题
  8. jenkins &#39;cordova&#39; command not recognised on Jenkins Windows slave
  9. LeetCode算法题-Intersection of Two Arrays II（Java实现）
  10. Luogu P2148 [SDOI2009]E&amp;D
  11. 简单配置jena在eclipse的开发环境
  12. Linux 内核 hlist 详解
  13. 2018-2019 2 20165203 《网络对抗技术》Exp6 信息搜集与漏洞扫描
  14. c#如何解析时区字符串
  15. 解决code::blocks 17.12不能debug的方法
  16. Python——os（一）进程参数
  17. c# list排序的三种实现方式 (转帖)
  18. R语言实战（七）图形进阶
  19. 目前主流的四大浏览器内核Trident、Gecko、WebKit以及Presto
  20. JavaScript程序员必备的5个debug技巧

热门文章

  1. Rusty String
  2. 改变bootstrapSwitch按钮状态
  3. java 随机颜色
  4. 爬虫代码实现四：采用Hbase存储爬虫数据(1)
  5. 妙味课堂史上最全的javascript视频教程，前端开发人员必备知识点，新手易学，拔高必备！！！
  6. -webkit-line-clamp 兼容性问题
  7. APP为什么会被打回来??
  8. java 程序从linux 上接收不可见字符
  9. extern用法详解(转)
  10. 黑马tomact学习二 tomcat的启动