Bug 1421942 - Update dashboards DWH views version and dashboards queries
Summary: Update dashboards DWH views version and dashboards queries
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: ovirt-engine
Classification: oVirt
Component: Frontend.Core
Version: 4.1.1
Hardware: Unspecified
OS: Unspecified
unspecified
medium
Target Milestone: ovirt-4.1.1
: 4.1.1
Assignee: Shirly Radco
QA Contact: Lucie Leistnerova
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2017-02-14 06:53 UTC by Shirly Radco
Modified: 2017-04-21 09:43 UTC (History)
5 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2017-04-21 09:43:55 UTC
oVirt Team: Metrics
Embargoed:
rule-engine: ovirt-4.1+
rule-engine: ovirt-4.2+
rule-engine: planning_ack+
sradco: devel_ack+
lsvaty: testing_ack+

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
oVirt gerrit 72238 0 master MERGED dashboards: update dwh views version 2017-02-15 13:07:18 UTC
oVirt gerrit 72239 0 ovirt-engine-4.1 MERGED dashboards: update dwh views version 2017-02-15 22:26:35 UTC
oVirt gerrit 72244 0 ovirt-engine-4.1 MERGED dashboards: Fixed cluster.last24hours dashboard query 2017-02-15 22:21:21 UTC
oVirt gerrit 72245 0 ovirt-engine-4.1 MERGED dashboards: Fixed storage domain dashboard queries 2017-02-15 22:21:29 UTC
oVirt gerrit 72246 0 ovirt-engine-4.1 MERGED dashboards: Fixed vms utilization dashboard queries 2017-02-15 22:21:34 UTC
oVirt gerrit 72247 0 ovirt-engine-4.1 MERGED dashboards: Fixed host.total_cpu_memory_count dashboard query 2017-02-15 22:22:00 UTC
oVirt gerrit 72248 0 ovirt-engine-4.1 MERGED dashboards: Fixed last_5_min_cpu_mem_average dashboard query 2017-02-15 22:21:25 UTC
oVirt gerrit 72250 0 ovirt-engine-4.1 MERGED dashboards: Fixed host.hourly_cpu_mem_history dashboard query 2017-02-15 22:21:40 UTC

Description Shirly Radco 2017-02-14 06:53:35 UTC 
Description of problem:
Dasboards use incorrect DWH views for dashboards queries

Version-Release number of selected component (if applicable):
4.1

How reproducible:
100%
Comment 1 Shirly Radco 2017-02-15 07:44:59 UTC 
The patches also include updating the queries for better performance/
Comment 2 Lukas Svaty 2017-02-15 08:34:05 UTC 
CodeChange? Or can you propose verification steps?
Comment 3 Lucie Leistnerova 2017-02-22 14:35:34 UTC 
Can I have the verification steps please.
Comment 4 Shirly Radco 2017-02-23 13:56:37 UTC 
There were several fixes to the queries for information that was incorrectly calculated like average memory and cpu usage. Also changed the queries so the will be more efficient. Updated the views version for it to match the engine version.

I believe this requires full testing of the results of the dashboards, dwh related widgets, cpu, memory, disk.

Also should test if there was an improvement in the queries run time.
Comment 5 Lucie Leistnerova 2017-03-13 14:09:44 UTC 
On DWH database there are no 4_0 views called and dao related queries have similar or better time.
Calculation were tested in Bug 1401010.

verified in ovirt-engine-dashboard-1.1.0-6.el7ev.noarch
Note You need to log in before you can comment on or make changes to this bug.