Public bug reported:
When trying to downgrade from version 61, it fails with an AttributeError. $ keystone-manage db_sync 60 2015-01-08 08:29:56.494 CRITICAL keystone [-] AttributeError: 'MetaData' object has no attribute 'c' 2015-01-08 08:29:56.494 TRACE keystone Traceback (most recent call last): 2015-01-08 08:29:56.494 TRACE keystone File "/usr/local/bin/keystone-manage", line 6, in <module> 2015-01-08 08:29:56.494 TRACE keystone exec(compile(open(__file__).read(), __file__, 'exec')) 2015-01-08 08:29:56.494 TRACE keystone File "/opt/stack/keystone/bin/keystone-manage", line 44, in <module> 2015-01-08 08:29:56.494 TRACE keystone cli.main(argv=sys.argv, config_files=config_files) 2015-01-08 08:29:56.494 TRACE keystone File "/opt/stack/keystone/keystone/cli.py", line 311, in main 2015-01-08 08:29:56.494 TRACE keystone CONF.command.cmd_class.main() 2015-01-08 08:29:56.494 TRACE keystone File "/opt/stack/keystone/keystone/cli.py", line 74, in main 2015-01-08 08:29:56.494 TRACE keystone migration_helpers.sync_database_to_version(extension, version) 2015-01-08 08:29:56.494 TRACE keystone File "/opt/stack/keystone/keystone/common/sql/migration_helpers.py", line 204, in sync_database_to_version 2015-01-08 08:29:56.494 TRACE keystone _sync_common_repo(version) 2015-01-08 08:29:56.494 TRACE keystone File "/opt/stack/keystone/keystone/common/sql/migration_helpers.py", line 160, in _sync_common_repo 2015-01-08 08:29:56.494 TRACE keystone init_version=init_version) 2015-01-08 08:29:56.494 TRACE keystone File "/opt/stack/oslo.db/oslo_db/sqlalchemy/migration.py", line 82, in db_sync 2015-01-08 08:29:56.494 TRACE keystone version) 2015-01-08 08:29:56.494 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/api.py", line 202, in downgrade 2015-01-08 08:29:56.494 TRACE keystone return _migrate(url, repository, version, upgrade=False, err=err, **opts) 2015-01-08 08:29:56.494 TRACE keystone File "<string>", line 2, in _migrate 2015-01-08 08:29:56.494 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/util/__init__.py", line 160, in with_engine 2015-01-08 08:29:56.494 TRACE keystone return f(*a, **kw) 2015-01-08 08:29:56.494 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/api.py", line 366, in _migrate 2015-01-08 08:29:56.494 TRACE keystone schema.runchange(ver, change, changeset.step) 2015-01-08 08:29:56.494 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/schema.py", line 93, in runchange 2015-01-08 08:29:56.494 TRACE keystone change.run(self.engine, step) 2015-01-08 08:29:56.494 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/script/py.py", line 148, in run 2015-01-08 08:29:56.494 TRACE keystone script_func(engine) 2015-01-08 08:29:56.494 TRACE keystone File "/opt/stack/keystone/keystone/common/sql/migrate_repo/versions/061_add_parent_project.py", line 50, in downgrade 2015-01-08 08:29:56.494 TRACE keystone migration_helpers.remove_constraints(list_constraints(meta)) 2015-01-08 08:29:56.494 TRACE keystone File "/opt/stack/keystone/keystone/common/sql/migrate_repo/versions/061_add_parent_project.py", line 24, in list_constraints 2015-01-08 08:29:56.494 TRACE keystone 'ref_column': project_table.c.id}] 2015-01-08 08:29:56.494 TRACE keystone AttributeError: 'MetaData' object has no attribute 'c' 2015-01-08 08:29:56.494 TRACE keystone ** Affects: keystone Importance: Undecided Assignee: Brant Knudson (blk-u) Status: In Progress ** Changed in: keystone Assignee: (unassigned) => Brant Knudson (blk-u) -- You received this bug notification because you are a member of Yahoo! Engineering Team, which is subscribed to Keystone. https://bugs.launchpad.net/bugs/1408658 Title: migration 61 downgrade fails using mysql Status in OpenStack Identity (Keystone): In Progress Bug description: When trying to downgrade from version 61, it fails with an AttributeError. $ keystone-manage db_sync 60 2015-01-08 08:29:56.494 CRITICAL keystone [-] AttributeError: 'MetaData' object has no attribute 'c' 2015-01-08 08:29:56.494 TRACE keystone Traceback (most recent call last): 2015-01-08 08:29:56.494 TRACE keystone File "/usr/local/bin/keystone-manage", line 6, in <module> 2015-01-08 08:29:56.494 TRACE keystone exec(compile(open(__file__).read(), __file__, 'exec')) 2015-01-08 08:29:56.494 TRACE keystone File "/opt/stack/keystone/bin/keystone-manage", line 44, in <module> 2015-01-08 08:29:56.494 TRACE keystone cli.main(argv=sys.argv, config_files=config_files) 2015-01-08 08:29:56.494 TRACE keystone File "/opt/stack/keystone/keystone/cli.py", line 311, in main 2015-01-08 08:29:56.494 TRACE keystone CONF.command.cmd_class.main() 2015-01-08 08:29:56.494 TRACE keystone File "/opt/stack/keystone/keystone/cli.py", line 74, in main 2015-01-08 08:29:56.494 TRACE keystone migration_helpers.sync_database_to_version(extension, version) 2015-01-08 08:29:56.494 TRACE keystone File "/opt/stack/keystone/keystone/common/sql/migration_helpers.py", line 204, in sync_database_to_version 2015-01-08 08:29:56.494 TRACE keystone _sync_common_repo(version) 2015-01-08 08:29:56.494 TRACE keystone File "/opt/stack/keystone/keystone/common/sql/migration_helpers.py", line 160, in _sync_common_repo 2015-01-08 08:29:56.494 TRACE keystone init_version=init_version) 2015-01-08 08:29:56.494 TRACE keystone File "/opt/stack/oslo.db/oslo_db/sqlalchemy/migration.py", line 82, in db_sync 2015-01-08 08:29:56.494 TRACE keystone version) 2015-01-08 08:29:56.494 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/api.py", line 202, in downgrade 2015-01-08 08:29:56.494 TRACE keystone return _migrate(url, repository, version, upgrade=False, err=err, **opts) 2015-01-08 08:29:56.494 TRACE keystone File "<string>", line 2, in _migrate 2015-01-08 08:29:56.494 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/util/__init__.py", line 160, in with_engine 2015-01-08 08:29:56.494 TRACE keystone return f(*a, **kw) 2015-01-08 08:29:56.494 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/api.py", line 366, in _migrate 2015-01-08 08:29:56.494 TRACE keystone schema.runchange(ver, change, changeset.step) 2015-01-08 08:29:56.494 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/schema.py", line 93, in runchange 2015-01-08 08:29:56.494 TRACE keystone change.run(self.engine, step) 2015-01-08 08:29:56.494 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/script/py.py", line 148, in run 2015-01-08 08:29:56.494 TRACE keystone script_func(engine) 2015-01-08 08:29:56.494 TRACE keystone File "/opt/stack/keystone/keystone/common/sql/migrate_repo/versions/061_add_parent_project.py", line 50, in downgrade 2015-01-08 08:29:56.494 TRACE keystone migration_helpers.remove_constraints(list_constraints(meta)) 2015-01-08 08:29:56.494 TRACE keystone File "/opt/stack/keystone/keystone/common/sql/migrate_repo/versions/061_add_parent_project.py", line 24, in list_constraints 2015-01-08 08:29:56.494 TRACE keystone 'ref_column': project_table.c.id}] 2015-01-08 08:29:56.494 TRACE keystone AttributeError: 'MetaData' object has no attribute 'c' 2015-01-08 08:29:56.494 TRACE keystone To manage notifications about this bug go to: https://bugs.launchpad.net/keystone/+bug/1408658/+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