Bug 1912887 - Update variables on dashboards that do not display deleted entities
Summary: Update variables on dashboards that do not display deleted entities
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: ovirt-engine-dwh
Classification: oVirt
Component: Grafana
Version: 4.4.4
Hardware: Unspecified
OS: Unspecified
unspecified
medium
Target Milestone: ovirt-4.4.5
: 4.4.5
Assignee: Aviv Litman
QA Contact: Pavel Novotny
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2021-01-05 14:06 UTC by Aviv Litman
Modified: 2021-03-22 12:55 UTC (History)
3 users (show)

Fixed In Version: ovirt-engine-dwh-4.4.5
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2021-03-18 15:13:43 UTC
oVirt Team: Metrics
Embargoed:
alitman: needinfo-
pm-rhel: ovirt-4.4+
pm-rhel: planning_ack+
mperina: devel_ack+
gdeolive: testing_ack+


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
oVirt gerrit 112866 0 master MERGED Update variables in hosts/vms uptime dashboards 2021-02-12 15:04:35 UTC

Description Aviv Litman 2021-01-05 14:06:37 UTC
Description of problem:
Variables in dashboards that do not display deleted entities should query the latest tables and not the history tables, In order not to confuse the user that these entities are active.


Steps to Reproduce:
1.go to oVirt Service Level Dashboards 
2.go to Hosts/vms Uptime Dashboard
3.look at the Host variable setting (dashboard settings -> variables -> $host_id),
and see in the query that table v4_3__configuration_history_hosts/vms is in use,
instead of table v4_3_latest_configuration_hosts/vms. 

Actual results:
Some variables in dashboards that do not display deleted entities query the history tables

Expected results:
All variables in dashboards that do not display deleted entities query the latest tables

Notes for QA:
Dashboard that need to be checked (dashboards that do not display deleted entities):

oVirt Executive Dashboards:
Cluster Dashboard 
Data Center Dashboard

oVirt Inventory Dashboards:
Inventory Dashboard

oVirt Service Level Dashboards:
Hosts Uptime Dashboard
Virtual Machines Uptime Dashboard 

Need to check that all the variables from type 'Query' using the v4_4_latest_configuration_... tables.

Comment 1 Pavel Novotny 2021-03-01 19:20:25 UTC
Verified in
ovirt-engine-4.4.5.7-0.1.el8ev.noarch
ovirt-engine-dwh-4.4.5.4-1.el8ev.noarch

In the  oVirt Service Level Dashboards for Hosts ($host_id) / VMs ($vm_id) Uptime, the v4_4_latest_configuration_hosts and v4_4_latest_configuration_vms tables are used.

Comment 2 Sandro Bonazzola 2021-03-18 15:13:43 UTC
This bugzilla is included in oVirt 4.4.5 release, published on March 18th 2021.

Since the problem described in this bug report should be resolved in oVirt 4.4.5 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.

Comment 3 Sandro Bonazzola 2021-03-22 12:55:37 UTC
This bugzilla is included in oVirt 4.4.5 release, published on March 18th 2021.

Since the problem described in this bug report should be resolved in oVirt 4.4.5 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.


Note You need to log in before you can comment on or make changes to this bug.