Comment 1 for bug 1240325

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

Reviewed: https://review.openstack.org/52000
Committed: http://github.com/openstack/nova/commit/6eda819ca12f7f58e41fe9496f1ec1f2f471f6b5
Submitter: Jenkins
Branch: master

commit 6eda819ca12f7f58e41fe9496f1ec1f2f471f6b5
Author: Joshua Hesketh <email address hidden>
Date: Wed Oct 16 15:03:13 2013 +1100

    Ensure migration 209 works with NULL fkey values

    Modify the sub-query on migration 209's backup to not select NULL
    items which cause the NOT IN to always be false and consequently
    the backup not to run resulting in a violation of the foreign keys.

    To test, add an instance with NULL uuid to check the backups still
    work correctly and avoid violating the foreign key constraint.
    If there are NULL values in a NOT IN () set the result is always
    false. Therefore having this instance inserted causes migration 209
    to fail unless the IN set sub-query is modified appropriately.

    Change-Id: Id0f8c8cb082df8861e85f925b979ddd934a95bfc
    Closes-Bug: 1240325