Bug 1292167

Summary:	Backport: get_networks performance hindered by segment lookups
Product:	Red Hat OpenStack	Reporter:	Haim Daniel <hdaniel>
Component:	openstack-neutron	Assignee:	Haim Daniel <hdaniel>
Status:	CLOSED ERRATA	QA Contact:	Eran Kuris <ekuris>
Severity:	unspecified	Docs Contact:
Priority:	medium
Version:	8.0 (Liberty)	CC:	amuller, chrisw, dcadzow, lpeer, nyechiel, tfreger, yeylon
Target Milestone:	ga	Keywords:	FeatureBackport, Triaged
Target Release:	8.0 (Liberty)
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:	openstack-neutron-7.0.1-4	Doc Type:	Bug Fix
Doc Text:	Cause: Large number of existing (Networks X Subnets) Consequence: Time it takes to list the networks (net-list) increases greatly with number of existing networks and subnets as a result of multiple database queries. Result: Reduced time for net-list, the operation does an aggregated query for all subnets per network	Story Points:	---
Clone Of:		Environment:
Last Closed:	2016-04-07 21:19:01 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:	1290562

Description Haim Daniel 2015-12-16 15:52:38 UTC

During the get_networks method of ML2, we iterate over each network and do a database call to lookup the segments for that network. This scales the number of database calls linearly with the number of retrieved networks.

Comment 2 Assaf Muller 2015-12-16 23:31:05 UTC

*** Bug 1292166 has been marked as a duplicate of this bug. ***

Comment 5 Eran Kuris 2016-01-21 15:56:43 UTC

Verified 
(Tempest_run)[stack@instack neutron]$ rpm -qa |grep neutron 
openstack-neutron-common-7.0.1-6.el7ost.noarch
openstack-neutron-7.0.1-6.el7ost.noarch
python-neutron-7.0.1-6.el7ost.noarch
openstack-neutron-ml2-7.0.1-6.el7ost.noarch
openstack-neutron-openvswitch-7.0.1-6.el7ost.noarch
python-neutronclient-3.1.0-1.el7ost.noarch

https://rhos-jenkins.rhev-ci-vms.eng.rdu2.redhat.com/job/rhos-unittest-gerrit-neutron-rhel-7.2/719/testReport/

Comment 6 Assaf Muller 2016-02-04 11:09:32 UTC

@Haim, since this bug did not affect OSP 7 or earlier versions, it did not affect any existing customers. Since we're fixing it before the first release of OSP 8, it means that no one was affected by the regression, so we don't need doctext (Because there's no one to tell that the issue was fixed).

Comment 7 errata-xmlrpc 2016-04-07 21:19:01 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/RHEA-2016-0603.html