openstack
/
nova
Code Issues Proposed changes

allocations.consumer_id is not used in query. 

PostGreSQL required consumer_id in group by clause, but
consumer_id is not being used in the query and is superfluous.

Change-Id: I47b758b949b7fbed70906e9a95cbe7bb99da13c2
Closes-Bug: 1662012
This commit is contained in:
smccully 2017-02-05 21:43:31 +00:00 committed by Sean McCully
parent 5512484f06
commit 85c76a7f08
1 changed files with 0 additions and 1 deletions
Show Stats Download Patch File Download Diff File Expand all files Collapse all files

1
nova/objects/resource_provider.py
View File

@ -975,7 +975,6 @@ def _check_capacity_exceeded(conn, allocs):
provider_uuids = set([a.resource_provider.uuid for a in allocs])
usage = sa.select([_ALLOC_TBL.c.resource_provider_id,
_ALLOC_TBL.c.consumer_id,
_ALLOC_TBL.c.resource_class_id,
sql.func.sum(_ALLOC_TBL.c.used).label('used')])
usage = usage.where(_ALLOC_TBL.c.resource_class_id.in_(rc_ids))