Comment 8 for bug 1368213

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to cinder (master)

Reviewed: https://review.openstack.org/122971
Committed: https://git.openstack.org/cgit/openstack/cinder/commit/?id=71e78407954d108879bd51664f97fb5aeb5729dc
Submitter: Jenkins
Branch: master

commit 71e78407954d108879bd51664f97fb5aeb5729dc
Author: Xing Yang <email address hidden>
Date: Sat Sep 20 18:23:11 2014 -0400

    DB migration 25->24 failed when dropping column

    "cinder-manage db sync 24" failed when dropping column cgsnapshot_id
    from the snapshots table.

    The reason that drop column failed was because of the foreign key
    constraint. MySQL cannot drop column until the foreign key constraint
    is removed. So the solution is to remove the foreign key first, and
    then drop the column. This affects the cgsnapshot_id column in the
    snapshots table and the consistencygroup_id column in the volumes table.

    Change-Id: I89d5016be450ec91c7a7b1c42803add3f62c88df
    Closes-Bug: #1368213