[openstack-dev] [Nova] Grizzly -> Havanna db migration bug/1245502 still biting me?

Joshua Hesketh joshua.hesketh at RACKSPACE.COM
Wed Jan 1 12:40:21 UTC 2014

Hi Jon,

The issue here is that the backport into Havana hasn't been merged yet: https://review.openstack.org/#/c/56149/

I apologise for the delay, It has been in review for a long time.

If there are some stable maintainers that are able to take a look that would be really appreciated.

From: Jonathan Proulx [jon at jonproulx.com]
Sent: Tuesday, December 31, 2013 5:25 AM
To: OpenStack Development Mailing List
Subject: [openstack-dev] [Nova] Grizzly -> Havanna db migration bug/1245502     still biting me?

Hi All,

I'm mid upgrade between Grizzly and Havana and seem to still be having
issues with https://bugs.launchpad.net/nova/+bug/1245502

I grabbed the patched version of 185_rename_unique_constraints.py but
that migration still keeps failing with many issues trying to drop
nonexistant indexes and add preexisting indexes.

for example:
CRITICAL nova [-] (OperationalError) (1553, "Cannot drop index
'uniq_instance_type_id_x_project_id_x_deleted': needed in a foreign
key constraint") 'ALTER TABLE instance_type_projects DROP INDEX
uniq_instance_type_id_x_project_id_x_deleted' ()

I'm on Ubuntu 12.04 having originally installed Essex and
progressively upgraded using cloud archive packages since.

# nova-manage  db version

a dump of my nova database schema as it currently stands is at:

The bug is marked "fix released", but one of the last comments request
schemata from affected systems so not sure if replying to the bug is
appropriate or if this should be a new bug.


OpenStack-dev mailing list
OpenStack-dev at lists.openstack.org

More information about the OpenStack-dev mailing list