yahoo-eng-team team mailing list archive

Thread
Date

[Bug 1145216] Re: Race condition in db floating_ip_create and floating_ip_bulk_create

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: Thierry Carrez <thierry.carrez+lp@xxxxxxxxx>
Date: Wed, 29 May 2013 10:18:55 -0000
Reply-to: Bug 1145216 <1145216@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/1145216

Title:
  Race condition in db floating_ip_create and floating_ip_bulk_create

Status in OpenStack Compute (Nova):
  Fix Released

Bug description:
  floating_ip rows should have a unique value in address column.

  At this moment we are checking that it doesn't exists in DB and then
  if it doesn't then we save it in DB.

  Select then Insert and this will cause race conditions.

  We should add unique constraint on (address, deleted) columns and then
  just try to insert.

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