Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1278576

Summary:	cinder-api is consuming around 10GB RAM when running a "snapshot-list" command on the large set of data
Product:	Red Hat OpenStack	Reporter:	Sergey Gotliv <sgotliv>
Component:	openstack-cinder	Assignee:	Jon Bernard <jobernar>
Status:	CLOSED ERRATA	QA Contact:	nlevinki <nlevinki>
Severity:	high	Docs Contact:
Priority:	urgent
Version:	5.0 (RHEL 7)	CC:	bhamrick, dmaley, eharney, fpercoco, geguileo, jschluet, sclewis, scohen, yeylon
Target Milestone:	async	Keywords:	GSSTriaged, ZStream
Target Release:	5.0 (RHEL 7)
Hardware:	All
OS:	Linux
Whiteboard:
Fixed In Version:	openstack-cinder-2014.1.5-3.el7ost	Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:
Clones:	1279543 1279547 1279561 1279562 1283316 (view as bug list)		Environment:
Last Closed:	2015-12-22 14:25:36 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:
Bug Blocks:	1283316

Description Sergey Gotliv 2015-11-05 20:21:50 UTC

Description of problem:

Cinder is performing an inefficient query: when looking
for information about snapshots associated with a particular volume,
it loads all the rows from the database and then filters them in
memory.  


Version-Release number of selected component (if applicable):


How reproducible:
100%

Steps to Reproduce:
1. Create a lot of snapshots
2. Run cinder snapshot-list command, use volume_id to return only snapshots related to that specific volume

Actual results:

1. cinder-api is consuming a lot of memory after performing cinder snapshot-list
2. query returns a lot of unrelated records from the database (snapshots of a different volumes)


Expected results:

memory usage should be normal, 
query should return only relevant records


Additional info:

Comment 2 Flavio Percoco 2015-11-06 13:10:19 UTC

Added a reference to the patch. This is the link to the scratch build:

https://brewweb.devel.redhat.com/taskinfo?taskID=10073456

Comment 7 errata-xmlrpc 2015-12-22 14:25:36 UTC

Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://rhn.redhat.com/errata/RHBA-2015-2689.html