Description of problem:
Host monitoring generates too many 'getqosbyqosid' queries.
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1. create 95 host environment with 300 vlans on one host interface (non mgmt)
- Webadmin is closed
- No REST calls
- Host in UP status
3. let engine run idle for 15 minutes after startup
4. count 'getqosbyqosid' queries to db with db pg_stat_statements in 10 minutes
~1.6 million 'getqosbyqosid' queries over the 10 minute period
~57 thousand 'getqosbyqosid' queries over the 10 minute period
Created attachment 1687655 [details]
Idle 10 mins post reboot capture query counts
#Env: 150 Hosts with 100 networks
HE environment with 200 nested hosts of which 150 hosts have 100 networks per host.
DWH separated and JVM set to 4G with engine set with with 200 pool connections / 250 db connections.
# /usr/share/ovirt-engine/dbscripts/engine-psql.sh -c ""SELECT count(*) from vds_interface_view""
getqosbyqosid executed 60,320
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 (Important: RHV Manager (ovirt-engine) 4.4 security, bug fix, and enhancement 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.