API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 18th, 2016
200
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.46 KB | None | 0 0
raw download clone embed print report
  1. root@controller:/etc/mysql# su -s /bin/sh -c "keystone-manage db_sync" keystone
  2. 2016-10-18 19:06:41.619 9297 ERROR oslo_db.sqlalchemy.exc_filters [-] DBAPIError exception w rapped 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 NU LL, \n\trepository_path TEXT, \n\tversion INTEGER, \n\tPRIMARY KEY (repository_id)\n)\n\n']
  3. 2016-10-18 19:06:41.619 9297 ERROR oslo_db.sqlalchemy.exc_filters Traceback (most recent cal l last):
  4. 2016-10-18 19:06:41.619 9297 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7 /dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
  5. 2016-10-18 19:06:41.619 9297 ERROR oslo_db.sqlalchemy.exc_filters context)
  6. 2016-10-18 19:06:41.619 9297 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7 /dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
  7. 2016-10-18 19:06:41.619 9297 ERROR oslo_db.sqlalchemy.exc_filters cursor.execute(stateme nt, parameters)
  8. 2016-10-18 19:06:41.619 9297 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7 /dist-packages/pymysql/cursors.py", line 158, in execute
  9. 2016-10-18 19:06:41.619 9297 ERROR oslo_db.sqlalchemy.exc_filters result = self._query(q uery)
  10. 2016-10-18 19:06:41.619 9297 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7 /dist-packages/pymysql/cursors.py", line 308, in _query
  11. 2016-10-18 19:06:41.619 9297 ERROR oslo_db.sqlalchemy.exc_filters conn.query(q)
  12. 2016-10-18 19:06:41.619 9297 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7 /dist-packages/pymysql/connections.py", line 820, in query
  13. 2016-10-18 19:06:41.619 9297 ERROR oslo_db.sqlalchemy.exc_filters self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  14. 2016-10-18 19:06:41.619 9297 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7 /dist-packages/pymysql/connections.py", line 1002, in _read_query_result
  15. 2016-10-18 19:06:41.619 9297 ERROR oslo_db.sqlalchemy.exc_filters result.read()
  16. 2016-10-18 19:06:41.619 9297 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7 /dist-packages/pymysql/connections.py", line 1285, in read
  17. 2016-10-18 19:06:41.619 9297 ERROR oslo_db.sqlalchemy.exc_filters first_packet = self.co nnection._read_packet()
  18. 2016-10-18 19:06:41.619 9297 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7 /dist-packages/pymysql/connections.py", line 966, in _read_packet
  19. 2016-10-18 19:06:41.619 9297 ERROR oslo_db.sqlalchemy.exc_filters packet.check_error()
  20. 2016-10-18 19:06:41.619 9297 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7 /dist-packages/pymysql/connections.py", line 394, in check_error
  21. 2016-10-18 19:06:41.619 9297 ERROR oslo_db.sqlalchemy.exc_filters err.raise_mysql_except ion(self._data)
  22. 2016-10-18 19:06:41.619 9297 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7 /dist-packages/pymysql/err.py", line 120, in raise_mysql_exception
  23. 2016-10-18 19:06:41.619 9297 ERROR oslo_db.sqlalchemy.exc_filters _check_mysql_exception (errinfo)
  24. 2016-10-18 19:06:41.619 9297 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7 /dist-packages/pymysql/err.py", line 115, in _check_mysql_exception
  25. 2016-10-18 19:06:41.619 9297 ERROR oslo_db.sqlalchemy.exc_filters raise InternalError(er rno, errorvalue)
  26. 2016-10-18 19:06:41.619 9297 ERROR oslo_db.sqlalchemy.exc_filters InternalError: (1071, u'Sp ecified key was too long; max key length is 767 bytes')
  27. 2016-10-18 19:06:41.619 9297 ERROR oslo_db.sqlalchemy.exc_filters
  28. 2016-10-18 19:06:41.621 9297 CRITICAL keystone [-] DBError: (pymysql.err.InternalError) (107 1, u'Specified key was too long; max key length is 767 bytes') [SQL: u'\nCREATE TABLE migrat e_version (\n\trepository_id VARCHAR(250) NOT NULL, \n\trepository_path TEXT, \n\tversion IN TEGER, \n\tPRIMARY KEY (repository_id)\n)\n\n']
  29. 2016-10-18 19:06:41.621 9297 ERROR keystone Traceback (most recent call last):
  30. 2016-10-18 19:06:41.621 9297 ERROR keystone File "/usr/bin/keystone-manage", line 10, in < module>
  31. 2016-10-18 19:06:41.621 9297 ERROR keystone sys.exit(main())
  32. 2016-10-18 19:06:41.621 9297 ERROR keystone File "/usr/lib/python2.7/dist-packages/keyston e/cmd/manage.py", line 47, in main
  33. 2016-10-18 19:06:41.621 9297 ERROR keystone cli.main(argv=sys.argv, config_files=config_ files)
  34. 2016-10-18 19:06:41.621 9297 ERROR keystone File "/usr/lib/python2.7/dist-packages/keyston e/cmd/cli.py", line 1010, in main
  35. 2016-10-18 19:06:41.621 9297 ERROR keystone CONF.command.cmd_class.main()
  36. 2016-10-18 19:06:41.621 9297 ERROR keystone File "/usr/lib/python2.7/dist-packages/keyston e/cmd/cli.py", line 389, in main
  37. 2016-10-18 19:06:41.621 9297 ERROR keystone migration_helpers.sync_database_to_version(e xtension, version)
  38. 2016-10-18 19:06:41.621 9297 ERROR keystone File "/usr/lib/python2.7/dist-packages/keyston e/common/sql/migration_helpers.py", line 210, in sync_database_to_version
  39. 2016-10-18 19:06:41.621 9297 ERROR keystone _sync_common_repo(version)
  40. 2016-10-18 19:06:41.621 9297 ERROR keystone File "/usr/lib/python2.7/dist-packages/keyston e/common/sql/migration_helpers.py", line 136, in _sync_common_repo
  41. 2016-10-18 19:06:41.621 9297 ERROR keystone init_version=init_version, sanity_check=Fals e)
  42. 2016-10-18 19:06:41.621 9297 ERROR keystone File "/usr/lib/python2.7/dist-packages/oslo_db /sqlalchemy/migration.py", line 74, in db_sync
  43. 2016-10-18 19:06:41.621 9297 ERROR keystone current_version = db_version(engine, abs_pat h, init_version)
  44. 2016-10-18 19:06:41.621 9297 ERROR keystone File "/usr/lib/python2.7/dist-packages/oslo_db /sqlalchemy/migration.py", line 132, in db_version
  45. 2016-10-18 19:06:41.621 9297 ERROR keystone db_version_control(engine, abs_path, version =init_version)
  46. 2016-10-18 19:06:41.621 9297 ERROR keystone File "/usr/lib/python2.7/dist-packages/oslo_db /sqlalchemy/migration.py", line 153, in db_version_control
  47. 2016-10-18 19:06:41.621 9297 ERROR keystone versioning_api.version_control(engine, repos itory, version)
  48. 2016-10-18 19:06:41.621 9297 ERROR keystone File "<decorator-gen-8>", line 2, in version_c ontrol
  49. 2016-10-18 19:06:41.621 9297 ERROR keystone File "/usr/lib/python2.7/dist-packages/migrate /versioning/util/__init__.py", line 160, in with_engine
  50. 2016-10-18 19:06:41.621 9297 ERROR keystone return f(*a, **kw)
  51. 2016-10-18 19:06:41.621 9297 ERROR keystone File "/usr/lib/python2.7/dist-packages/migrate /versioning/api.py", line 250, in version_control
  52. 2016-10-18 19:06:41.621 9297 ERROR keystone ControlledSchema.create(engine, repository, version)
  53. 2016-10-18 19:06:41.621 9297 ERROR keystone File "/usr/lib/python2.7/dist-packages/migrate /versioning/schema.py", line 141, in create
  54. 2016-10-18 19:06:41.621 9297 ERROR keystone table = cls._create_table_version(engine, re pository, version)
  55. 2016-10-18 19:06:41.621 9297 ERROR keystone File "/usr/lib/python2.7/dist-packages/migrate /versioning/schema.py", line 183, in _create_table_version
  56. 2016-10-18 19:06:41.621 9297 ERROR keystone table.create()
  57. 2016-10-18 19:06:41.621 9297 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalch emy/sql/schema.py", line 725, in create
  58. 2016-10-18 19:06:41.621 9297 ERROR keystone checkfirst=checkfirst)
  59. 2016-10-18 19:06:41.621 9297 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalch emy/engine/base.py", line 1856, in _run_visitor
  60. 2016-10-18 19:06:41.621 9297 ERROR keystone conn._run_visitor(visitorcallable, element, **kwargs)
  61. 2016-10-18 19:06:41.621 9297 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalch emy/engine/base.py", line 1481, in _run_visitor
  62. 2016-10-18 19:06:41.621 9297 ERROR keystone **kwargs).traverse_single(element)
  63. 2016-10-18 19:06:41.621 9297 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalch emy/sql/visitors.py", line 121, in traverse_single
  64. 2016-10-18 19:06:41.621 9297 ERROR keystone return meth(obj, **kw)
  65. 2016-10-18 19:06:41.621 9297 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalch emy/sql/ddl.py", line 764, in visit_table
  66. 2016-10-18 19:06:41.621 9297 ERROR keystone include_foreign_key_constraints=include_fore ign_key_constraints
  67. 2016-10-18 19:06:41.621 9297 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalch emy/engine/base.py", line 914, in execute
  68. 2016-10-18 19:06:41.621 9297 ERROR keystone return meth(self, multiparams, params)
  69. 2016-10-18 19:06:41.621 9297 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalch emy/sql/ddl.py", line 68, in _execute_on_connection
  70. 2016-10-18 19:06:41.621 9297 ERROR keystone return connection._execute_ddl(self, multipa rams, params)
  71. 2016-10-18 19:06:41.621 9297 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalch emy/engine/base.py", line 968, in _execute_ddl
  72. 2016-10-18 19:06:41.621 9297 ERROR keystone compiled
  73. 2016-10-18 19:06:41.621 9297 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalch emy/engine/base.py", line 1146, in _execute_context
  74. 2016-10-18 19:06:41.621 9297 ERROR keystone context)
  75. 2016-10-18 19:06:41.621 9297 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalch emy/engine/base.py", line 1337, in _handle_dbapi_exception
  76. 2016-10-18 19:06:41.621 9297 ERROR keystone util.raise_from_cause(newraise, exc_info)
  77. 2016-10-18 19:06:41.621 9297 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalch emy/util/compat.py", line 200, in raise_from_cause
  78. 2016-10-18 19:06:41.621 9297 ERROR keystone reraise(type(exception), exception, tb=exc_t b)
  79. 2016-10-18 19:06:41.621 9297 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalch emy/engine/base.py", line 1139, in _execute_context
  80. 2016-10-18 19:06:41.621 9297 ERROR keystone context)
  81. 2016-10-18 19:06:41.621 9297 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalch emy/engine/default.py", line 450, in do_execute
  82. 2016-10-18 19:06:41.621 9297 ERROR keystone cursor.execute(statement, parameters)
  83. 2016-10-18 19:06:41.621 9297 ERROR keystone File "/usr/lib/python2.7/dist-packages/pymysql /cursors.py", line 158, in execute
  84. 2016-10-18 19:06:41.621 9297 ERROR keystone result = self._query(query)
  85. 2016-10-18 19:06:41.621 9297 ERROR keystone File "/usr/lib/python2.7/dist-packages/pymysql /cursors.py", line 308, in _query
  86. 2016-10-18 19:06:41.621 9297 ERROR keystone conn.query(q)
  87. 2016-10-18 19:06:41.621 9297 ERROR keystone File "/usr/lib/python2.7/dist-packages/pymysql /connections.py", line 820, in query
  88. 2016-10-18 19:06:41.621 9297 ERROR keystone self._affected_rows = self._read_query_resul t(unbuffered=unbuffered)
  89. 2016-10-18 19:06:41.621 9297 ERROR keystone File "/usr/lib/python2.7/dist-packages/pymysql /connections.py", line 1002, in _read_query_result
  90. 2016-10-18 19:06:41.621 9297 ERROR keystone result.read()
  91. 2016-10-18 19:06:41.621 9297 ERROR keystone File "/usr/lib/python2.7/dist-packages/pymysql /connections.py", line 1285, in read
  92. 2016-10-18 19:06:41.621 9297 ERROR keystone first_packet = self.connection._read_packet( )
  93. 2016-10-18 19:06:41.621 9297 ERROR keystone File "/usr/lib/python2.7/dist-packages/pymysql /connections.py", line 966, in _read_packet
  94. 2016-10-18 19:06:41.621 9297 ERROR keystone packet.check_error()
  95. 2016-10-18 19:06:41.621 9297 ERROR keystone File "/usr/lib/python2.7/dist-packages/pymysql /connections.py", line 394, in check_error
  96. 2016-10-18 19:06:41.621 9297 ERROR keystone err.raise_mysql_exception(self._data)
  97. 2016-10-18 19:06:41.621 9297 ERROR keystone File "/usr/lib/python2.7/dist-packages/pymysql /err.py", line 120, in raise_mysql_exception
  98. 2016-10-18 19:06:41.621 9297 ERROR keystone _check_mysql_exception(errinfo)
  99. 2016-10-18 19:06:41.621 9297 ERROR keystone File "/usr/lib/python2.7/dist-packages/pymysql /err.py", line 115, in _check_mysql_exception
  100. 2016-10-18 19:06:41.621 9297 ERROR keystone raise InternalError(errno, errorvalue)
  101. 2016-10-18 19:06:41.621 9297 ERROR keystone DBError: (pymysql.err.InternalError) (1071, u'Sp ecified key was too long; max key length is 767 bytes') [SQL: u'\nCREATE TABLE migrate_versi on (\n\trepository_id VARCHAR(250) NOT NULL, \n\trepository_path TEXT, \n\tversion INTEGER, \n\tPRIMARY KEY (repository_id)\n)\n\n']
  102. 2016-10-18 19:06:41.621 9297 ERROR keystone
  103. root@controller:/etc/mysql#
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!