Bug 1912887

Summary:	Update variables on dashboards that do not display deleted entities
Product:	[oVirt] ovirt-engine-dwh	Reporter:	Aviv Litman <alitman>
Component:	Grafana	Assignee:	Aviv Litman <alitman>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Pavel Novotny <pnovotny>
Severity:	medium	Docs Contact:
Priority:	unspecified
Version:	4.4.4	CC:	gdeolive, mperina, sradco
Target Milestone:	ovirt-4.4.5	Flags:	alitman: needinfo- pm-rhel: ovirt-4.4+ pm-rhel: planning_ack+ mperina: devel_ack+ gdeolive: testing_ack+
Target Release:	4.4.5
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:	ovirt-engine-dwh-4.4.5	Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2021-03-18 15:13:43 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:

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.