migration 17: user_project_membership has no column 'project_id'

[Yaguang Tang]

yaguang@yaguang-ThinkPad-X230:~/working/openstack/keystone# keystone-manage db_sync
/usr/lib/python2.7/dist-packages/migrate/versioning/repository.py:9: UserWarning: Module keystone was already imported from /home/yaguang/working/openstack/keystone/keystone/__init__.pyc, but /usr/lib/python2.7/dist-packages is being added to sys.path
  from pkg_resources import resource_filename
Traceback (most recent call last):
  File "/usr/bin/keystone-manage", line 28, in <module>
    cli.main(argv=sys.argv, config_files=config_files)
  File "/home/yaguang/working/openstack/keystone/keystone/cli.py", line 172, in main
    CONF.command.cmd_class.main()
  File "/home/yaguang/working/openstack/keystone/keystone/cli.py", line 53, in main
    driver.db_sync()
  File "/home/yaguang/working/openstack/keystone/keystone/identity/backends/sql.py", line 171, in db_sync
    migration.db_sync()
  File "/home/yaguang/working/openstack/keystone/keystone/common/sql/migration.py", line 52, in db_sync
    return versioning_api.upgrade(CONF.sql.connection, repo_path, version)
  File "/usr/lib/python2.7/dist-packages/migrate/versioning/api.py", line 186, in upgrade
    return _migrate(url, repository, version, upgrade=True, err=err, **opts)
  File "<string>", line 2, in _migrate
  File "/usr/lib/python2.7/dist-packages/migrate/versioning/util/__init__.py", line 159, in with_engine
    return f(*a, **kw)
  File "/usr/lib/python2.7/dist-packages/migrate/versioning/api.py", line 366, in _migrate
    schema.runchange(ver, change, changeset.step)
  File "/usr/lib/python2.7/dist-packages/migrate/versioning/schema.py", line 91, in runchange
    change.run(self.engine, step)
  File "/usr/lib/python2.7/dist-packages/migrate/versioning/script/py.py", line 145, in run
    script_func(engine)
  File "/home/yaguang/working/openstack/keystone/keystone/common/sql/migrate_repo/versions/017_membership_role.py", line 51, in upgrade
    project_id=membership.project_id,
AttributeError: 'NamedTuple' object has no attribute 'project_id'

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/22665

[Sina Sadeghi (sina-sa)]

How come the patch for this fix was abandoned?

[Dolph Mathews (dolph)]

This looks like a valid issue. +1 for restoring the patch!

[Dolph Mathews (dolph)]

Targeting this to Havana RC1... this should be re-investigated & closed if it's no longer an issue (or fixed!)

[Dolph Mathews (dolph)]

Lowering priority as I'm unable to reproduce (the fix in the above review appears to have already been applied to master, I assume in another patch?), but I can't find a test for this particular condition.

[Dolph Mathews (dolph)]

Unassigning due to inactivity.

[Dolph Mathews (dolph)]

This migration is no longer supported.