Public bug reported: 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:[email protected]/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' () ** Affects: keystone Importance: Undecided Status: New -- 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): New 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:[email protected]/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 -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : [email protected] Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp
