Open Stack

Hi Blair,

No trouble, glad I could help. I'll be working backporting this as is 
appropriate.

Cheers,
Josh

Rackspace Australia

On 10/30/13 5:06 PM, Blair Zajac wrote:
> Hi Joshua,
>
> Thanks for the quick fix, I appreciate it.
>
> I took your fixed 185_rename_unique_constraints.py, copied it into 
> /usr/share/pyshared/nova/db/sqlalchemy/migrate_repo/versions/185_rename_unique_constraints.py, 
> restored MySQL back to 1 week ago and reran all the migrations and 
> everything worked fine.
>
> I've launched my instances, so I'm a happy openstacker ;)
>
> Thanks!
> Blair
>
> On 10/29/2013 09:05 PM, Joshua Hesketh wrote:
>> Hi Blair,
>>
>> I have proposed a new fix which I believe should work for you. However
>> I've been unable to determine where exactly the duplicate keys were
>> introduced. Looking up what versions were available in Ubuntu from 12.10
>> you have been running since Folsom. This means you did not have the
>> 133_folsom.py migration and should have skipped it when upgrading to
>> Grizzly. I can't see anywhere else that would have changed the fkeys.
>>
>> So what I have proposed is to do a check for which keys exist in both of
>> the problematic tables (as virtual_interfaces is also affected) and
>> remove them bringing the databases inline with 133_folsom users.
>>
>> I'll propose this for backporting into Havana after it is merged.
>>
>> Cheers,
>> Josh
>>
>> Rackspace Australia
>>
>> 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 start deploying openstack from? Essex? and have you been just
>>>> upgrading with releases or RC's or upstream etc.
>>>
>>> I don't remember exactly, but here's a best shot.  I keep my systems
>>> up to date on Ubuntu, so:
>>>
>>> 1) Somewhere during 12.10 I installed OpenStack, I don't have notes on
>>> which one.
>>>
>>> 2) By the time I upgraded to 13.04 I had 2012.2.1-0ubuntu1.3 installed
>>> as I have the 'dpkg -l' output saved just before the upgrade. I was
>>> using the packages from ubuntu-cloud.archive.canonical.com for 12.04
>>> even though I was on 12.10.  Upgrading to 13.04 upgraded OpenStack to
>>> 1:2013.1-0ubuntu1.
>>>
>>> 3) When I upgraded to 13.10 I switched from
>>> ubuntu-cloud.archive.canonical.com back to 13.10's native OpenStack
>>> packages.  This brought me to 1:2013.2~rc4-0ubuntu1 and which have
>>> been since updated to 1:2013.2-0ubuntu1.
>>>
>>> Hope that helps.
>>>
>>> Blair
>>>
>>
>