RFE: add instance uuid field to nova.quota_usages table

[Dan Yocum]

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

[Tony Breeds (o-tony)]

This is reported against Icehouse which is closed for development.

Please reproduce with with Kilo or liberty-1 and reopen

[Dan Yocum (yocum)]

Please reopen and add this extra column in Juno (or Liberty).

Thanks,
Dan

--
<email address hidden>
OpenShift PaaS

On Jun 30, 2015 8:55 PM, Tony Breeds <email address hidden> wrote:
>
> This is reported against Icehouse which is closed for development.
>
> Please reproduce with with Kilo or liberty-1 and reopen
>
> ** Changed in: nova
>        Status: New => Won't Fix
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/1467560
>
> Title:
>   RFE: add instance uuid field to nova.quota_usages table
>
> Status in OpenStack Compute (Nova):
>   Won't Fix
>
> 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

[Dan Yocum (yocum)]

Tony - I wasn't suggesting this extra column should be added in Icehouse. I *do* think it should be added in Liberty-1.

[Matt Riedemann (mriedem)]

See the spec that was approved for liberty and mitaka to provide a nova-manage command to force the refresh of quota usages:

https://blueprints.launchpad.net/nova/+spec/refresh-quotas-usage

Will that satisfy this RFE? The spec has more details than blueprint description:

http://specs.openstack.org/openstack/nova-specs/specs/mitaka/approved/refresh-quotas-usage.html

[Dan Yocum (yocum)]

Yes. this will satisfy my RFE. Thanks.

[Markus Zoeller (markus_z) (mzoeller)]

@Dan Yocum:

IIUC in comment #5, there is no need anymore for this bug as the effort for this will be driven by the blueprint mentioned in comment #4. => I'm setting this bug to "invalid", I don't see a status which fits better.