Description of problem:
Several lbaas commands are taking longer than expected to complete, this time increases as more loadbalancers or pools are added.
In the production environment, 'neutron lbaas-loadbalancer-list' is taking 1.5 minutes to complete. Running 'neutron lbaas-loadbalancer-show <lb>' on a loadbalancer with 1 pool takes about 1.5 seconds. Running the same command on a loadbalancer with 7 pools takes about 5.5 seconds.
In the neutron debug logs, a large number of mysql queries being run for these operations can be seen.
Version-Release number of selected component (if applicable):
openstack-neutron-lbaas-9.2.1-6.el7ost.noarch
How reproducible:
Consistently, but becomes more apparent with more loadbalancers/pools
Steps to Reproduce:
1. create multiple loadbalancers and pools
2. run lbaas cli commands
Actual results:
Commands take unacceptably long with more loadbalancers present
Expected results:
Commands should complete more quickly even as scale increases
Additional info:
The F5 plugin is being used, but that does not seem to be the culprit at this point.
This looks very similar to https://bugs.launchpad.net/octavia/+bug/1706466, if this is the issue, can this fix be backported?
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://access.redhat.com/errata/RHBA-2018:1603