[Bug 916992] Re: Database migration v064 fails against MySQL 5.5 + InnoDB

[OpenStack Hudson]

Reviewed:  https://review.openstack.org/3110
Committed: http://github.com/openstack/nova/commit/35df99cf1dca5d9b0ca1cb09039845aa8bd3a49b
Submitter: Jenkins
Branch:    master

commit 35df99cf1dca5d9b0ca1cb09039845aa8bd3a49b
Author: Chuck Short <chuck.short at canonical.com>
Date:   Tue Jan 17 14:24:09 2012 -0500

    Drop FK constraint if it exists in migration 064
    
    Fixes LP bug 916992
    
    A workaround was originally applied to fix a FK constraint problem in migration
    064.  The original bug only affected MySQL+InnoDB databases and was masked by
    using MySQL+MyISAM.  Commit d503d6b1079f9eafe0430754214fc5b6d4e32c09 attempted
    to improve the workaround, though it caused issues on databases not using
    InnoDB, so it was reverted enitrely and we are back with the original bug.
    
    This change will attempt to drop the FK constraint only if it exists.  This
    should now support MySQL installations that are configured both
    default_storage_engine=MyISAM (oneiric) and default_storage_engine=InnoDB
    (precise)
    
    Change-Id: Ie2cfa32d8f52b163f513679649da52a73fc501df
    Signed-off-by: Adam Gandleman <adam.gandleman at canonical.com>
    Signed-off-by: Chuck Short <chuck.short at canonical.com>


** Changed in: nova
       Status: In Progress => Fix Committed

-- 
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to nova in Ubuntu.
https://bugs.launchpad.net/bugs/916992

Title:
  Database migration v064 fails against MySQL 5.5 + InnoDB

To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/916992/+subscriptions