Re: [Openstack] Grizzly -> Havana nova upgrade failure: Cannot drop index 'instance_uuid'

2013-10-29 Thread Blair Zajac
lia On 10/30/13 11:42 AM, Blair Zajac wrote: On 10/29/2013 05:16 PM, Joshua Hesketh wrote: Hi Blair, Thanks for the clarifications, that helps. At the moment I'm trying to determine how you ended up with both fkeys so I can ensure the problem is properly fixed. What version did you first

Re: [Openstack] Grizzly -> Havana nova upgrade failure: Cannot drop index 'instance_uuid'

2013-10-29 Thread Blair Zajac
On 10/29/2013 05:16 PM, Joshua Hesketh wrote: Hi Blair, Thanks for the clarifications, that helps. At the moment I'm trying to determine how you ended up with both fkeys so I can ensure the problem is properly fixed. What version did you first start deploying openstack from? Essex? and have you

Re: [Openstack] Grizzly -> Havana nova upgrade failure: Cannot drop index 'instance_uuid'

2013-10-29 Thread Blair Zajac
INE=InnoDB AUTO_INCREMENT=202 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `instance_info_caches` -- I didn't go looking to see what was going on until the patch 185 migration also failed. Regards, Blair Thanks, Josh Rac

Re: [Openstack] Grizzly -> Havana nova upgrade failure: Cannot drop index 'instance_uuid'

2013-10-28 Thread Blair Zajac
On 10/28/13 6:17 PM, Joshua Hesketh wrote: Hi guys, I have a patch in the works against this that will hopefully fix your problems: https://review.openstack.org/#/c/54212/ One of the gotchas though will be if you have already ran migration 185 you can't run it again (even if it failed because i

Re: [Openstack] Grizzly -> Havana nova upgrade failure: Cannot drop index 'instance_uuid'

2013-10-28 Thread Blair Zajac
On 10/27/13 4:39 PM, Michael Still wrote: These sound like bugs worth filing... I opened https://bugs.launchpad.net/nova/+bug/1245502 Blair ___ Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack Post to : openstack@lists

Re: [Openstack] Grizzly -> Havana nova upgrade failure: Cannot drop index 'instance_uuid'

2013-10-27 Thread Blair Zajac
ikalst...@gmail.com [mailto:mikalst...@gmail.com] On Behalf Of Michael Still Sent: October-27-13 7:39 PM To: David Hill Cc: Blair Zajac; openstack@lists.openstack.org Subject: Re: [Openstack] Grizzly -> Havana nova upgrade failure: Cannot drop index 'instance_uuid' These sound like bugs

Re: [Openstack] Grizzly -> Havana nova upgrade failure: Cannot drop index 'instance_uuid'

2013-10-27 Thread Blair Zajac
\G Thanks, Michael On Sun, Oct 27, 2013 at 7:58 PM, Blair Zajac wrote: Hello, I was running Ubuntu 13.04 and upgraded tonight to 13.10. I was running the Ubuntu Precise 1:2013.1.3-0ubuntu1.1 on 13.04 and am now on 13.10's provided 1:2013.2~rc2-0ubuntu1. After getting the box up, migrating

[Openstack] Grizzly -> Havana nova upgrade failure: Cannot drop index 'instance_uuid'

2013-10-27 Thread Blair Zajac
Hello, I was running Ubuntu 13.04 and upgraded tonight to 13.10. I was running the Ubuntu Precise 1:2013.1.3-0ubuntu1.1 on 13.04 and am now on 13.10's provided 1:2013.2~rc2-0ubuntu1. After getting the box up, migrating the nova database failed with the below error. I am using MySQL. Sugg