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
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