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

commit 35df99cf1dca5d9b0ca1cb09039845aa8bd3a49b
Author: Chuck Short <chuck.sh...@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.gandle...@canonical.com>
    Signed-off-by: Chuck Short <chuck.sh...@canonical.com>


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

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to 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

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to