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

Reply via email to