Description of problem: In time-based queries when selecting a time period greater than 24 hours the queries turn to the hourly + daily tables and display incorrect data at 00:00 or incorrect overall result, due to data duplication at 00:00 each day. Version-Release number of selected component (if applicable): 4.4.4 How reproducible: 100% Steps to Reproduce: 1.go to Grafana 2.choose 1 time-based dashboard 3.choose time period greater than 24 hours (like 'this day last week') 4.notice that the overall time is greater than the selected time or there are double rows in the table (like 2 days instead of 1 day) Actual results: When choosing a time period greater than the last 24 hours, there are duplication's in the data and therefore the calculation is erroneous and is done according to a time period greater than the chosen period. Expected results: When selecting any time period, the calculation will be made according to the correct time and the correct time range will be displayed. Additional info:
Target release should be placed once a package build is known to fix a issue. Since this bug is not modified, the target version has been reset. Please use target milestone to plan a fix for a oVirt release.
Created attachment 1724755 [details] Example from dashboard: Cluster Quality of Service - Hosts Dashboard
Verified in ovirt-engine-4.4.4.6-0.1.el8ev.noarch ovirt-engine-dwh-4.4.4.2-1.el8ev.noarch The time-based queries (for example in the Trend or Service Level dashboards) don't show any duplicate values at 00:00 or overall results when showing or selecting data during time period greater than 24 hours.
This bugzilla is included in oVirt 4.4.4 release, published on December 21st 2020. Since the problem described in this bug report should be resolved in oVirt 4.4.4 release, it has been closed with a resolution of CURRENT RELEASE. If the solution does not work for you, please open a new bug report.