Bug 1892247

Summary: Fix duplicates in time-based queries (that use the hourly + daily tables)
Product: [oVirt] ovirt-engine-dwh Reporter: Aviv Litman <alitman>
Component: GrafanaAssignee: Aviv Litman <alitman>
Status: CLOSED CURRENTRELEASE QA Contact: Pavel Novotny <pnovotny>
Severity: high Docs Contact:
Priority: high    
Version: 4.4.2CC: bugs, mperina, sradco
Target Milestone: ovirt-4.4.4Flags: pm-rhel: ovirt-4.4+
pm-rhel: planning_ack+
pm-rhel: devel_ack+
lleistne: testing_ack+
Target Release: 4.4.4   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: ovirt-engine-dwh-4.4.4 Doc Type: No Doc Update
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2021-01-12 16:24:03 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: Metrics RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
Example from dashboard: Cluster Quality of Service - Hosts Dashboard none

Description Aviv Litman 2020-10-28 09:56:00 UTC 
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:
Comment 1 RHEL Program Management 2020-10-28 09:56:08 UTC 
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.
Comment 2 RHEL Program Management 2020-10-28 09:57:06 UTC 
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.
Comment 3 Aviv Litman 2020-10-28 10:00:25 UTC 
Created attachment 1724755 [details]
Example from dashboard: Cluster Quality of Service - Hosts Dashboard
Comment 4 Pavel Novotny 2021-01-07 22:25:36 UTC 
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.
Comment 5 Sandro Bonazzola 2021-01-12 16:24:03 UTC 
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.