liberty -> mitaka db migrate fails on postgresql 091 migration

Bug #1562965 reported by Matthew Thode
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenStack Identity (keystone)
Invalid
Undecided
Adam Young

Bug Description

looks like this row doesn't exist

https://github.com/openstack/keystone/blob/9.0.0.0rc1/keystone/common/sql/migrate_repo/versions/091_migrate_data_to_local_user_and_password_tables.py#L51

NoSuchColumnError: "Could not locate column in row for column 'user_password'"

Revision history for this message
Matthew Thode (prometheanfire) wrote :

it might just need to change to this, but I don't see how it'd ever be true

    if row.has_key('user_password'):

tags: added: rc-potential
tags: added: mitaka-rc-potential
removed: rc-potential
Revision history for this message
Adam Young (ayoung) wrote :

No, the column user_password should be generated based on the use_labels=True flag. The password column is dropped at the end of the migration.

Need to run this by hand to see what it is actually failing on.

Adam Young (ayoung)
Changed in keystone:
assignee: nobody → Adam Young (ayoung)
Revision history for this message
Adam Young (ayoung) wrote :

According to conversation in #openstack-keystone, reporter was running this by hand using ipython. The migrations are not designed to run multiple tiumes, and this error was not somthing we would see using the proper migrate mechanism.

Changed in keystone:
status: New → Invalid
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.