yahoo-eng-team team mailing list archive

Thread
Date
[Bug 1292712] Re: migrate to 36 fails

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: Launchpad Bug Tracker <1292712@xxxxxxxxxxxxxxxxxx>
Date: Tue, 22 Jul 2014 04:17:24 -0000
Reply-to: Bug 1292712 <1292712@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
[Expired for Keystone because there has been no activity for 60 days.]

** Changed in: keystone
       Status: Incomplete => Expired

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to Keystone.
https://bugs.launchpad.net/bugs/1292712

Title:
  migrate to 36 fails

Status in OpenStack Identity (Keystone):
  Expired

Bug description:
  On rdo havana I tried a db_sync and it fails:

  2014-03-14 13:49:14.890 10938 INFO migrate.versioning.api [-] 35 -> 36... 
  2014-03-14 13:49:14.891 10938 DEBUG migrate.versioning.util [-] Disposing SQLAlchemy engine Engine(mysql://keystone_admin:096cde2717d44d87@130.20.232.220/keystone) with_engine /usr/lib/python2.6/site-packages/migrate/versioning/util/__init__.py:162
  2014-03-14 13:49:14.892 10938 CRITICAL keystone [-] (OperationalError) (1091, "Can't DROP 'ix_token_valid'; check that column/key exists") '\nDROP INDEX ix_token_valid ON token' ()
  2014-03-14 13:49:14.892 10938 TRACE keystone Traceback (most recent call last):
  2014-03-14 13:49:14.892 10938 TRACE keystone   File "/usr/bin/keystone-manage", line 51, in <module>
  2014-03-14 13:49:14.892 10938 TRACE keystone     cli.main(argv=sys.argv, config_files=config_files)
  2014-03-14 13:49:14.892 10938 TRACE keystone   File "/usr/lib/python2.6/site-packages/keystone/cli.py", line 218, in main
  2014-03-14 13:49:14.892 10938 TRACE keystone     CONF.command.cmd_class.main()
  2014-03-14 13:49:14.892 10938 TRACE keystone   File "/usr/lib/python2.6/site-packages/keystone/cli.py", line 72, in main
  2014-03-14 13:49:14.892 10938 TRACE keystone     migration.db_sync(version=version)
  2014-03-14 13:49:14.892 10938 TRACE keystone   File "/usr/lib/python2.6/site-packages/keystone/common/sql/migration.py", line 61, in db_sync
  2014-03-14 13:49:14.892 10938 TRACE keystone     return migrate_repository(version, current_version, repo_path)
  2014-03-14 13:49:14.892 10938 TRACE keystone   File "/usr/lib/python2.6/site-packages/keystone/common/sql/migration.py", line 45, in migrate_repository
  2014-03-14 13:49:14.892 10938 TRACE keystone     repo_path, version)
  2014-03-14 13:49:14.892 10938 TRACE keystone   File "/usr/lib/python2.6/site-packages/migrate/versioning/api.py", line 186, in upgrade
  2014-03-14 13:49:14.892 10938 TRACE keystone     return _migrate(url, repository, version, upgrade=True, err=err, **opts)
  2014-03-14 13:49:14.892 10938 TRACE keystone   File "<string>", line 2, in _migrate
  2014-03-14 13:49:14.892 10938 TRACE keystone   File "/usr/lib/python2.6/site-packages/migrate/versioning/util/__init__.py", line 159, in with_engine
  2014-03-14 13:49:14.892 10938 TRACE keystone     return f(*a, **kw)
  2014-03-14 13:49:14.892 10938 TRACE keystone   File "/usr/lib/python2.6/site-packages/migrate/versioning/api.py", line 366, in _migrate
  2014-03-14 13:49:14.892 10938 TRACE keystone     schema.runchange(ver, change, changeset.step)
  2014-03-14 13:49:14.892 10938 TRACE keystone   File "/usr/lib/python2.6/site-packages/migrate/versioning/schema.py", line 91, in runchange
  2014-03-14 13:49:14.892 10938 TRACE keystone     change.run(self.engine, step)
  2014-03-14 13:49:14.892 10938 TRACE keystone   File "/usr/lib/python2.6/site-packages/migrate/versioning/script/py.py", line 145, in run
  2014-03-14 13:49:14.892 10938 TRACE keystone     script_func(engine)
  2014-03-14 13:49:14.892 10938 TRACE keystone   File "/usr/lib/python2.6/site-packages/keystone/common/sql/migrate_repo/versions/036_token_drop_valid_index.py", line 25, in upgrade
  2014-03-14 13:49:14.892 10938 TRACE keystone     idx.drop(migrate_engine)
  2014-03-14 13:49:14.892 10938 TRACE keystone   File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/schema.py", line 2277, in drop
  2014-03-14 13:49:14.892 10938 TRACE keystone     bind._run_visitor(ddl.SchemaDropper, self)
  2014-03-14 13:49:14.892 10938 TRACE keystone   File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 2303, in _run_visitor
  2014-03-14 13:49:14.892 10938 TRACE keystone     conn._run_visitor(visitorcallable, element, **kwargs)
  2014-03-14 13:49:14.892 10938 TRACE keystone   File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1973, in _run_visitor
  2014-03-14 13:49:14.892 10938 TRACE keystone     **kwargs).traverse_single(element)
  2014-03-14 13:49:14.892 10938 TRACE keystone   File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/sql/visitors.py", line 106, in traverse_single
  2014-03-14 13:49:14.892 10938 TRACE keystone     return meth(obj, **kw)
  2014-03-14 13:49:14.892 10938 TRACE keystone   File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/engine/ddl.py", line 159, in visit_index
  2014-03-14 13:49:14.892 10938 TRACE keystone     self.connection.execute(schema.DropIndex(index))
  2014-03-14 13:49:14.892 10938 TRACE keystone   File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1449, in execute
  2014-03-14 13:49:14.892 10938 TRACE keystone     params)
  2014-03-14 13:49:14.892 10938 TRACE keystone   File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1542, in _execute_ddl
  2014-03-14 13:49:14.892 10938 TRACE keystone     compiled
  2014-03-14 13:49:14.892 10938 TRACE keystone   File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1698, in _execute_context
  2014-03-14 13:49:14.892 10938 TRACE keystone     context)
  2014-03-14 13:49:14.892 10938 TRACE keystone   File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1691, in _execute_context
  2014-03-14 13:49:14.892 10938 TRACE keystone     context)
  2014-03-14 13:49:14.892 10938 TRACE keystone   File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/engine/default.py", line 331, in do_execute
  2014-03-14 13:49:14.892 10938 TRACE keystone     cursor.execute(statement, parameters)
  2014-03-14 13:49:14.892 10938 TRACE keystone   File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 173, in execute
  2014-03-14 13:49:14.892 10938 TRACE keystone     self.errorhandler(self, exc, value)
  2014-03-14 13:49:14.892 10938 TRACE keystone   File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
  2014-03-14 13:49:14.892 10938 TRACE keystone     raise errorclass, errorvalue
  2014-03-14 13:49:14.892 10938 TRACE keystone OperationalError: (OperationalError) (1091, "Can't DROP 'ix_token_valid'; check that column/key exists") '\nDROP INDEX ix_token_valid ON token' ()

To manage notifications about this bug go to:
https://bugs.launchpad.net/keystone/+bug/1292712/+subscriptions
References

[Bug 1292712] [NEW] migrate to 36 fails
From: Kevin Fox, 2014-03-14