yahoo-eng-team team mailing list archive

Thread
Date

[Bug 1193199] Re: quota reservations can raise DBDeadlock

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: Thierry Carrez <thierry.carrez+lp@xxxxxxxxx>
Date: Wed, 17 Jul 2013 12:27:47 -0000
Reply-to: Bug 1193199 <1193199@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx

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

** Changed in: nova
    Milestone: None => havana-2

-- 
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/1193199

Title:
  quota reservations can raise DBDeadlock

Status in OpenStack Compute (Nova):
  Fix Released

Bug description:
  Due to how innodb works and that we do a select+insert...  a couple of
  parallel select+inserts can raise DBDeadlock when using thread
  pooling:

  2013-06-21 03:37:36.763 4585 TRACE nova DBDeadlock: (OperationalError)
  (1213, 'Deadlock found when trying to get lock; try restarting
  transaction') 'INSERT INTO quota_usages (created_at, updated_at,
  deleted_at, deleted, project_id, resource, in_use, reserved,
  until_refresh) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s)'
  (datetime.datetime(2013, 6, 21, 3, 37, 36, 758605), None, None, 0,
  'fake', 'cores', 0, 0, None)

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