# su -s /bin/sh -c "keystone-manage db_sync" keystone
时出错:
2017-01-06 19:13:58.086 9437 DEBUG migrate.versioning.repository [-] Repository /opt/stack/keystone/keystone/common/sql/migrate_repo loaded successfully __init__ /usr/local/lib/python2.7/dist-packages/migrate/versioning/repository.py:82
2017-01-06 19:13:58.086 9437 DEBUG migrate.versioning.repository [-] Config: OrderedDict([('db_settings', OrderedDict([('__name__', 'db_settings'), ('repository_id', 'keystone'), ('version_table', 'migrate_version'), ('required_dbs', '[]'), ('use_timestamp_numbering', 'False')]))]) __init__ /usr/local/lib/python2.7/dist-packages/migrate/versioning/repository.py:83
2017-01-06 19:13:58.091 9437 CRITICAL keystone [-] OperationalError: (_mysql_exceptions.OperationalError) (1071, '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']
2017-01-06 19:13:58.091 9437 TRACE keystone Traceback (most recent call last):
2017-01-06 19:13:58.091 9437 TRACE keystone File "/usr/local/bin/keystone-manage", line 10, in <module>
2017-01-06 19:13:58.091 9437 TRACE keystone sys.exit(main())
2017-01-06 19:13:58.091 9437 TRACE keystone File "/opt/stack/keystone/keystone/cmd/manage.py", line 45, in main
2017-01-06 19:13:58.091 9437 TRACE keystone cli.main(argv=sys.argv, config_files=config_files)
2017-01-06 19:13:58.091 9437 TRACE keystone File "/opt/stack/keystone/keystone/cmd/cli.py", line 1283, in main
2017-01-06 19:13:58.091 9437 TRACE keystone CONF.command.cmd_class.main()
2017-01-06 19:13:58.091 9437 TRACE keystone File "/opt/stack/keystone/keystone/cmd/cli.py", line 467, in main
2017-01-06 19:13:58.091 9437 TRACE keystone CONF.command.version)
2017-01-06 19:13:58.091 9437 TRACE keystone File "/opt/stack/keystone/keystone/common/sql/upgrades.py", line 251, in offline_sync_database_to_version
2017-01-06 19:13:58.091 9437 TRACE keystone expand_schema()
2017-01-06 19:13:58.091 9437 TRACE keystone File "/opt/stack/keystone/keystone/common/sql/upgrades.py", line 271, in expand_schema
2017-01-06 19:13:58.091 9437 TRACE keystone _sync_common_repo(version=None)
2017-01-06 19:13:58.091 9437 TRACE keystone File "/opt/stack/keystone/keystone/common/sql/upgrades.py", line 171, in _sync_common_repo
2017-01-06 19:13:58.091 9437 TRACE keystone init_version=init_version, sanity_check=False)
2017-01-06 19:13:58.091 9437 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/oslo_db/sqlalchemy/migration.py", line 73, in db_sync
2017-01-06 19:13:58.091 9437 TRACE keystone current_version = db_version(engine, abs_path, init_version)
2017-01-06 19:13:58.091 9437 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/oslo_db/sqlalchemy/migration.py", line 131, in db_version
2017-01-06 19:13:58.091 9437 TRACE keystone db_version_control(engine, abs_path, version=init_version)
2017-01-06 19:13:58.091 9437 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/oslo_db/sqlalchemy/migration.py", line 153, in db_version_control
2017-01-06 19:13:58.091 9437 TRACE keystone versioning_api.version_control(engine, repository, version)
2017-01-06 19:13:58.091 9437 TRACE keystone File "<decorator-gen-8>", line 2, in version_control
2017-01-06 19:13:58.091 9437 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/util/__init__.py", line 160, in with_engine
2017-01-06 19:13:58.091 9437 TRACE keystone return f(*a, **kw)
2017-01-06 19:13:58.091 9437 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/api.py", line 250, in version_control
2017-01-06 19:13:58.091 9437 TRACE keystone ControlledSchema.create(engine, repository, version)
2017-01-06 19:13:58.091 9437 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/schema.py", line 141, in create
2017-01-06 19:13:58.091 9437 TRACE keystone table = cls._create_table_version(engine, repository, version)
2017-01-06 19:13:58.091 9437 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/schema.py", line 183, in _create_table_version
2017-01-06 19:13:58.091 9437 TRACE keystone table.create()
2017-01-06 19:13:58.091 9437 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/schema.py", line 754, in create
2017-01-06 19:13:58.091 9437 TRACE keystone checkfirst=checkfirst)
2017-01-06 19:13:58.091 9437 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1856, in _run_visitor
2017-01-06 19:13:58.091 9437 TRACE keystone conn._run_visitor(visitorcallable, element, **kwargs)
2017-01-06 19:13:58.091 9437 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1481, in _run_visitor
2017-01-06 19:13:58.091 9437 TRACE keystone **kwargs).traverse_single(element)
2017-01-06 19:13:58.091 9437 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single
2017-01-06 19:13:58.091 9437 TRACE keystone return meth(obj, **kw)
2017-01-06 19:13:58.091 9437 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 764, in visit_table
2017-01-06 19:13:58.091 9437 TRACE keystone include_foreign_key_constraints=include_foreign_key_constraints
2017-01-06 19:13:58.091 9437 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 914, in execute
2017-01-06 19:13:58.091 9437 TRACE keystone return meth(self, multiparams, params)
2017-01-06 19:13:58.091 9437 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
2017-01-06 19:13:58.091 9437 TRACE keystone return connection._execute_ddl(self, multiparams, params)
2017-01-06 19:13:58.091 9437 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 968, in _execute_ddl
2017-01-06 19:13:58.091 9437 TRACE keystone compiled
2017-01-06 19:13:58.091 9437 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
2017-01-06 19:13:58.091 9437 TRACE keystone context)
2017-01-06 19:13:58.091 9437 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
2017-01-06 19:13:58.091 9437 TRACE keystone util.raise_from_cause(newraise, exc_info)
2017-01-06 19:13:58.091 9437 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 202, in raise_from_cause
2017-01-06 19:13:58.091 9437 TRACE keystone reraise(type(exception), exception, tb=exc_tb, cause=cause)
2017-01-06 19:13:58.091 9437 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
2017-01-06 19:13:58.091 9437 TRACE keystone context)
2017-01-06 19:13:58.091 9437 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
2017-01-06 19:13:58.091 9437 TRACE keystone cursor.execute(statement, parameters)
2017-01-06 19:13:58.091 9437 TRACE keystone File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 226, in execute
2017-01-06 19:13:58.091 9437 TRACE keystone self.errorhandler(self, exc, value)
2017-01-06 19:13:58.091 9437 TRACE keystone File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
2017-01-06 19:13:58.091 9437 TRACE keystone raise errorvalue
2017-01-06 19:13:58.091 9437 TRACE keystone OperationalError: (_mysql_exceptions.OperationalError) (1071, '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']
2017-01-06 19:13:58.091 9437 TRACE keystone
望楼主指教 |