Bug 1993688 - neutron port list slow when trunk service plugin is enabled
Summary: neutron port list slow when trunk service plugin is enabled
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat OpenStack
Classification: Red Hat
Component: openstack-neutron
Version: 16.1 (Train)
Hardware: Unspecified
OS: Unspecified
high
medium
Target Milestone: ---
: ---
Assignee: Slawek Kaplonski
QA Contact: Candido Campos
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2021-08-15 15:24 UTC by vivek koul
Modified: 2022-03-30 00:22 UTC (History)
5 users (show)

Fixed In Version: openstack-neutron-15.2.1-1.20210728183312.el8ost
Doc Type: No Doc Update
Doc Text:
Clone Of:
Environment:
Last Closed: 2022-03-24 10:56:13 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker OSP-7097 0 None None None 2021-11-15 12:57:16 UTC
Red Hat Product Errata RHSA-2022:0990 0 None None None 2022-03-24 10:56:43 UTC

Internal Links: 2082324

Description vivek koul 2021-08-15 15:24:13 UTC
Description of problem:

openstack port list is terribly slow (it takes more than 1 minute) when we have a large number of ports (~3500) and the trunk service_plugins is enabled

We notice that there are thousands of SQL queries sent to the database that looks like this.

How reproducible:
Reproducible using latest registry.redhat.io/rhosp-rhel8/openstack-neutron-server-ovn:16.1.6 images

Comment 12 errata-xmlrpc 2022-03-24 10:56:13 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 (Moderate: Red Hat OpenStack Platform 16.1 (openstack-neutron) security update), 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://access.redhat.com/errata/RHSA-2022:0990


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