yahoo-eng-team team mailing list archive

Thread
Date

[Bug 1240325] Re: Migration 209 fails to remove missing foreign keys when null values exist

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: Thierry Carrez <thierry.carrez+lp@xxxxxxxxx>
Date: Wed, 04 Dec 2013 10:30:37 -0000
Reply-to: Bug 1240325 <1240325@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx

** Changed in: nova
       Status: Fix Committed => Fix Released

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Compute (nova).
https://bugs.launchpad.net/bugs/1240325

Title:
  Migration 209 fails to remove missing foreign keys when null values
  exist

Status in OpenStack Compute (Nova):
  Fix Released

Bug description:
  Migration 209 failed to re-apply with MySQL/Postgres due to existing
  data violating foreign keys. The migration takes a backup of these
  rows and removes them before applying the new fkeys but the backup
  fails when there are NULL instance UUID's (due to the behavior of "NOT
  IN").

  When snake-walking down the migrations a migration version test
  inserts instances with NULL UUID's which exposes this error.

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