yahoo-eng-team team mailing list archive

[Dan Yocum <dyocum@xxxxxxxxxx>]

Public bug reported:

In Icehouse, the nova.quota_usages table frequently gets out-of-sync
with the currently active/stopped instances in a tenant/project,
specifically, there are times when the instance will be set to
terminated/deleted in the instances table and the quota_usages table
will retain the data, counting against the tenant's total quota.  As far
as I can tell there is no way to correlate instances.uuid with the
records in nova.quota_usages.

I propose adding an instance uuid column to make future cleanup of this
table easier.

I also propose a housecleaning task that does this clean up
automatically.

Thanks,
Dan

** Affects: nova
     Importance: Undecided
         Status: New

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

Title:
  RFE: add instance uuid field to nova.quota_usages table

Status in OpenStack Compute (Nova):
  New

Bug description:
  In Icehouse, the nova.quota_usages table frequently gets out-of-sync
  with the currently active/stopped instances in a tenant/project,
  specifically, there are times when the instance will be set to
  terminated/deleted in the instances table and the quota_usages table
  will retain the data, counting against the tenant's total quota.  As
  far as I can tell there is no way to correlate instances.uuid with the
  records in nova.quota_usages.

  I propose adding an instance uuid column to make future cleanup of
  this table easier.

  I also propose a housecleaning task that does this clean up
  automatically.

  Thanks,
  Dan

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