yahoo-eng-team team mailing list archive

[Thierry Carrez <thierry.carrez+lp@xxxxxxxxx>]

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

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

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

Title:
  missing index on reservations.uuid

Status in OpenStack Compute (Nova):
  Fix Released

Bug description:
  In a large deployment we're getting entries in our slow query log for
  querying the reservations table on the uuid column.  An example is

  # Time: 130722 19:01:43
  # User@Host: nova_20130124[nova_20130124] @  [10.23.244.148]
  # Query_time: 5.253471  Lock_time: 0.000084 Rows_sent: 3  Rows_examined: 1110157
  SET timestamp=1374519703;
  SELECT reservations.created_at AS reservations_created_at, reservations.updated_at AS reservations_updated_at, reservations.deleted_at AS reservations_deleted_at, reservations.deleted AS reservations_deleted, reservations.id AS reservations_id, reservations.uuid AS reservations_uuid, reservations.usage_id AS reservations_usage_id, reservations.project_id AS reservations_project_id, reservations.resource AS reservations_resource, reservations.delta AS reservations_delta, reservations.expire AS reservations_expire
  FROM reservations
  WHERE reservations.deleted = 0 AND reservations.uuid IN ('33c6c791-72f8-48f2-b0ee-47c6084d2956', 'ad642dc9-1faf-4906-859c-b9563491fdd2', '29f8f769-a6bc-4a23-8bdb-29900f872d3a') FOR UPDATE;

  This comes from the _quota_reservations_query method used by
  reservation_commit and reservation_rollback.

  There should be an index on reservations.uuid.

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