Description of problem: OSP10->11->12 undercloud upgrade fails with: ERROR keystone DbMigrationError: (pymysql.err.InternalError) (1061, u"Duplicate key name 'ix_default_project_id'") [SQL: u'CREATE INDEX ix_default_project_id ON user (default_project_id)'] Version-Release number of selected component (if applicable): openstack-keystone-12.0.0-4.el7ost.noarch How reproducible: 100% Steps to Reproduce: 1. Deploy OSP10 undercloud 2. Upgrade undercloud to 11 3. Upgrade undercloud to 12 Actual results: Upgrade fails during keystone-manage db_sync: ERROR keystone DbMigrationError: (pymysql.err.InternalError) (1061, u"Duplicate key name 'ix_default_project_id'") [SQL: u'CREATE INDEX ix_default_project_id ON user (default_project_id)'] Expected results: Upgrade doesn't fail Additional info: Attaching sosreport.
The issue here I think is basically that the migration script is not idempotent. We're running into an issue where the script is being re-run as 22 - as it should be - but failed because it is not idempotent. It should be fixed and then backported as fixed to newton/ocata.
There is a patch to fix the issue upstream. Once its merged, we'll backport to newton/ocata.
https://review.openstack.org/563266
Hello! Any progress on this BZ? Thanks.
Carlos, apologies for leaving this open. The patches backporting the migration from OSP12->11->10[1][2] were reverted after a second team review. This is no longer an issue for upgrades. [1] - https://code.engineering.redhat.com/gerrit/#/c/129662/ [2] - https://code.engineering.redhat.com/gerrit/#/c/129658/ Closing as NOTABUG.