yahoo-eng-team team mailing list archive

Thread
Date
[Bug 1572341] [NEW] Failed migration 90 -> 91 Can't DROP 'ixu_user_name_domain_id'

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: Sam Morrison <1572341@xxxxxxxxxxxxxxxxxx>
Date: Tue, 19 Apr 2016 23:33:39 -0000
Reply-to: Bug 1572341 <1572341@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
Public bug reported:

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']

** Affects: keystone
     Importance: Undecided
         Status: New

-- 
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):
  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
Follow ups

[Bug 1572341] Re: Failed migration 90 -> 91 Can't DROP 'ixu_user_name_domain_id'
From: Steve Martinelli, 2016-07-07
[Bug 1572341] Re: Failed migration 90 -> 91 Can't DROP 'ixu_user_name_domain_id'
From: Dolph Mathews, 2016-06-23
[Bug 1572341] Re: Failed migration 90 -> 91 Can't DROP 'ixu_user_name_domain_id'
From: OpenStack Infra, 2016-06-21