** Also affects: keystone/mitaka
Importance: Undecided
Status: New
** Changed in: keystone/mitaka
Importance: Undecided => High
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Identity (keystone).
https://bugs.launchpad.net/bugs/1572341
Title:
Failed migration 90 -> 91 Can't DROP 'ixu_user_name_domain_id'
Status in OpenStack Identity (keystone):
Fix Released
Status in OpenStack Identity (keystone) mitaka series:
New
Bug description:
Get the following error running DB migration when upgrading from kilo
-> mitaka
2016-04-20 09:31:37.560 10471 INFO migrate.versioning.api [-] 90 -> 91...
2016-04-20 09:31:37.822 10471 CRITICAL keystone [-] OperationalError:
(_mysql_exceptions.OperationalError) (1091, "Can't DROP
'ixu_user_name_domain_id'; check that column/key exists") [SQL: u'ALTER TABLE
user DROP INDEX ixu_user_name_domain_id']
2016-04-20 09:31:37.822 10471 ERROR keystone Traceback (most recent call
last):
2016-04-20 09:31:37.822 10471 ERROR keystone File
"/usr/bin/keystone-manage", line 10, in <module>
2016-04-20 09:31:37.822 10471 ERROR keystone sys.exit(main())
2016-04-20 09:31:37.822 10471 ERROR keystone File
"/opt/keystone/keystone/cmd/manage.py", line 47, in main
2016-04-20 09:31:37.822 10471 ERROR keystone cli.main(argv=sys.argv,
config_files=config_files)
2016-04-20 09:31:37.822 10471 ERROR keystone File
"/opt/keystone/keystone/cmd/cli.py", line 992, in main
2016-04-20 09:31:37.822 10471 ERROR keystone CONF.command.cmd_class.main()
2016-04-20 09:31:37.822 10471 ERROR keystone File
"/opt/keystone/keystone/cmd/cli.py", line 371, in main
2016-04-20 09:31:37.822 10471 ERROR keystone
migration_helpers.sync_database_to_version(extension, version)
2016-04-20 09:31:37.822 10471 ERROR keystone File
"/opt/keystone/keystone/common/sql/migration_helpers.py", line 210, in
sync_database_to_version
2016-04-20 09:31:37.822 10471 ERROR keystone _sync_common_repo(version)
2016-04-20 09:31:37.822 10471 ERROR keystone File
"/opt/keystone/keystone/common/sql/migration_helpers.py", line 136, in
_sync_common_repo
2016-04-20 09:31:37.822 10471 ERROR keystone init_version=init_version,
sanity_check=False)
2016-04-20 09:31:37.822 10471 ERROR keystone File
"/opt/mitaka/local/lib/python2.7/site-packages/oslo_db/sqlalchemy/migration.py",
line 79, in db_sync
2016-04-20 09:31:37.822 10471 ERROR keystone migration =
versioning_api.upgrade(engine, repository, version)
2016-04-20 09:31:37.822 10471 ERROR keystone File
"/opt/mitaka/local/lib/python2.7/site-packages/migrate/versioning/api.py", line
186, in upgrade
2016-04-20 09:31:37.822 10471 ERROR keystone return _migrate(url,
repository, version, upgrade=True, err=err, **opts)
2016-04-20 09:31:37.822 10471 ERROR keystone File "<decorator-gen-15>",
line 2, in _migrate
2016-04-20 09:31:37.822 10471 ERROR keystone File
"/opt/mitaka/local/lib/python2.7/site-packages/migrate/versioning/util/__init__.py",
line 160, in with_engine
2016-04-20 09:31:37.822 10471 ERROR keystone return f(*a, **kw)
2016-04-20 09:31:37.822 10471 ERROR keystone File
"/opt/mitaka/local/lib/python2.7/site-packages/migrate/versioning/api.py", line
366, in _migrate
2016-04-20 09:31:37.822 10471 ERROR keystone schema.runchange(ver,
change, changeset.step)
2016-04-20 09:31:37.822 10471 ERROR keystone File
"/opt/mitaka/local/lib/python2.7/site-packages/migrate/versioning/schema.py",
line 93, in runchange
2016-04-20 09:31:37.822 10471 ERROR keystone change.run(self.engine, step)
2016-04-20 09:31:37.822 10471 ERROR keystone File
"/opt/mitaka/local/lib/python2.7/site-packages/migrate/versioning/script/py.py",
line 148, in run
2016-04-20 09:31:37.822 10471 ERROR keystone script_func(engine)
2016-04-20 09:31:37.822 10471 ERROR keystone File
"/opt/keystone/keystone/common/sql/migrate_repo/versions/091_migrate_data_to_local_user_and_password_tables.py",
line 61, in upgrade
2016-04-20 09:31:37.822 10471 ERROR keystone
name='ixu_user_name_domain_id').drop()
2016-04-20 09:31:37.822 10471 ERROR keystone File
"/opt/mitaka/local/lib/python2.7/site-packages/migrate/changeset/constraint.py",
line 59, in drop
2016-04-20 09:31:37.822 10471 ERROR keystone
self.__do_imports('constraintdropper', *a, **kw)
2016-04-20 09:31:37.822 10471 ERROR keystone File
"/opt/mitaka/local/lib/python2.7/site-packages/migrate/changeset/constraint.py",
line 32, in __do_imports
2016-04-20 09:31:37.822 10471 ERROR keystone run_single_visitor(engine,
visitorcallable, self, *a, **kw)
2016-04-20 09:31:37.822 10471 ERROR keystone File
"/opt/mitaka/local/lib/python2.7/site-packages/migrate/changeset/databases/visitor.py",
line 85, in run_single_visitor
2016-04-20 09:31:37.822 10471 ERROR keystone fn(element, **kwargs)
2016-04-20 09:31:37.822 10471 ERROR keystone File
"/opt/mitaka/local/lib/python2.7/site-packages/migrate/changeset/ansisql.py",
line 294, in visit_migrate_unique_constraint
2016-04-20 09:31:37.822 10471 ERROR keystone self._visit_constraint(*p,
**k)
2016-04-20 09:31:37.822 10471 ERROR keystone File
"/opt/mitaka/local/lib/python2.7/site-packages/migrate/changeset/ansisql.py",
line 306, in _visit_constraint
2016-04-20 09:31:37.822 10471 ERROR keystone self.execute()
2016-04-20 09:31:37.822 10471 ERROR keystone File
"/opt/mitaka/local/lib/python2.7/site-packages/migrate/changeset/ansisql.py",
line 44, in execute
2016-04-20 09:31:37.822 10471 ERROR keystone return
self.connection.execute(self.buffer.getvalue())
2016-04-20 09:31:37.822 10471 ERROR keystone File
"/opt/mitaka/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line
906, in execute
2016-04-20 09:31:37.822 10471 ERROR keystone return
self._execute_text(object, multiparams, params)
2016-04-20 09:31:37.822 10471 ERROR keystone File
"/opt/mitaka/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line
1054, in _execute_text
2016-04-20 09:31:37.822 10471 ERROR keystone statement, parameters
2016-04-20 09:31:37.822 10471 ERROR keystone File
"/opt/mitaka/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line
1146, in _execute_context
2016-04-20 09:31:37.822 10471 ERROR keystone context)
2016-04-20 09:31:37.822 10471 ERROR keystone File
"/opt/mitaka/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line
1337, in _handle_dbapi_exception
2016-04-20 09:31:37.822 10471 ERROR keystone
util.raise_from_cause(newraise, exc_info)
2016-04-20 09:31:37.822 10471 ERROR keystone File
"/opt/mitaka/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line
200, in raise_from_cause
2016-04-20 09:31:37.822 10471 ERROR keystone reraise(type(exception),
exception, tb=exc_tb, cause=cause)
2016-04-20 09:31:37.822 10471 ERROR keystone File
"/opt/mitaka/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line
1139, in _execute_context
2016-04-20 09:31:37.822 10471 ERROR keystone context)
2016-04-20 09:31:37.822 10471 ERROR keystone File
"/opt/mitaka/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py",
line 450, in do_execute
2016-04-20 09:31:37.822 10471 ERROR keystone cursor.execute(statement,
parameters)
2016-04-20 09:31:37.822 10471 ERROR keystone File
"/opt/mitaka/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205,
in execute
2016-04-20 09:31:37.822 10471 ERROR keystone self.errorhandler(self, exc,
value)
2016-04-20 09:31:37.822 10471 ERROR keystone File
"/opt/mitaka/local/lib/python2.7/site-packages/MySQLdb/connections.py", line
36, in defaulterrorhandler
2016-04-20 09:31:37.822 10471 ERROR keystone raise errorclass, errorvalue
2016-04-20 09:31:37.822 10471 ERROR keystone OperationalError:
(_mysql_exceptions.OperationalError) (1091, "Can't DROP
'ixu_user_name_domain_id'; check that column/key exists") [SQL: u'ALTER TABLE
user DROP INDEX ixu_user_name_domain_id']
To manage notifications about this bug go to:
https://bugs.launchpad.net/keystone/+bug/1572341/+subscriptions
--
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : yahoo-eng-team@lists.launchpad.net
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
