Should have tried that first I suppose, even after reverting (clean schema at https://gist.github.com/jon-proulx/abb6af1ab7f3133671d2) sync fails
# nova-manage db sync Command failed, please check log for more info 2013-12-30 14:45:28.633 29427 CRITICAL nova [-] (OperationalError) (1032, "Can't find record in 'task_log'") 'ALTER TABLE task_log DROP INDEX uniq_task_name_x_host_x_period_beginning_x_period_ending' () On Mon, Dec 30, 2013 at 2:28 PM, Jonathan Proulx <j...@jonproulx.com> wrote: > ah, because the patched version won't work if you've already run the > unpatched version, would be nice if that had been captured in the bug > but did dig it out of > http://lists.openstack.org/pipermail/openstack/2013-October/002481.html > > On Mon, Dec 30, 2013 at 1:25 PM, Jonathan Proulx <j...@jonproulx.com> wrote: >> 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 >> 184 >> >> a dump of my nova database schema as it currently stands is at: >> https://gist.github.com/jon-proulx/79a77e8b771f90847ae9 >> >> 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. >> >> -Jon _______________________________________________ OpenStack-dev mailing list OpenStack-dev@lists.openstack.org http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev