Bug 1321661 - Table quota_usages gets out of sync with reality
Summary: Table quota_usages gets out of sync with reality
Keywords:
Status: CLOSED WONTFIX
Alias: None
Product: Red Hat OpenStack
Classification: Red Hat
Component: openstack-nova
Version: 5.0 (RHEL 6)
Hardware: All
OS: Linux
unspecified
high
Target Milestone: ---
: 8.0 (Liberty)
Assignee: Eoghan Glynn
QA Contact: nlevinki
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2016-03-28 19:48 UTC by Jack Waterworth
Modified: 2019-10-10 11:41 UTC (History)
10 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2016-04-05 14:48:07 UTC
Target Upstream Version:


Attachments (Terms of Use)

Description Jack Waterworth 2016-03-28 19:48:42 UTC
Description of problem:
Tenant quotas don't accurately reflect the actual usage.  For instance, the Red Hat Mobile tenant is really using 27 floating IPs, but the nova.quota_usages table shows 254 (out of 254).

Version-Release number of selected component (if applicable):
OS1 Public, RHEL-OSP5

How reproducible:
Intermittent

This appears to be related (or identical to) bz 1269297.   After making the recommended changes, the quota usages still do not get updated.

output from the nova-quota-sync script referenced in the previous bz: http://pastebin.test.redhat.com/360241

Customer has set current usage to -1 manually to try to force an update, as well as updating the until_refresh value

db loaded up here: root.211.141. relevant output: http://pastebin.test.redhat.com/360251

[root@public-control1 tmp]# grep until_refresh /etc/nova/nova.conf
#until_refresh=0
until_refresh=5
[root@public-control1 tmp]# grep max_age /etc/nova/nova.conf
#max_age=0
max_age=21600

Comment 3 Vladik Romanovsky 2016-04-05 14:48:07 UTC
Hello,

Unfortunately, this is known bug. A fix for this issue has been proposed to OpenStack Newton, however, not yet implemented. [1]

Alternately, there is a tool [2] that has been written by a major openstack user, that addressed this problem.

Please note, that this tool is not supported by Red Hat.

[1] - https://review.openstack.org/#/c/286302/
[2] - http://openstack-in-production.blogspot.ca/2015/03/nova-quota-usage-synchronization.html


Note You need to log in before you can comment on or make changes to this bug.