Bug 1292167 - Backport: get_networks performance hindered by segment lookups
Summary: Backport: get_networks performance hindered by segment lookups
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat OpenStack
Classification: Red Hat
Component: openstack-neutron
Version: 8.0 (Liberty)
Hardware: Unspecified
OS: Unspecified
medium
unspecified
Target Milestone: ga
: 8.0 (Liberty)
Assignee: Haim Daniel
QA Contact: Eran Kuris
URL:
Whiteboard:
: 1292166 (view as bug list)
Depends On:
Blocks: 1290562
TreeView+ depends on / blocked
 
Reported: 2015-12-16 15:52 UTC by Haim Daniel
Modified: 2023-02-22 23:02 UTC (History)
7 users (show)

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
Clone Of:
Environment:
Last Closed: 2016-04-07 21:19:01 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Launchpad 1525423 0 None None None 2015-12-16 15:52:37 UTC
Red Hat Product Errata RHEA-2016:0603 0 normal SHIPPED_LIVE Red Hat OpenStack Platform 8 Enhancement Advisory 2016-04-08 00:53:53 UTC

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


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