Bug 1436972 - [zstream clone - 4.1.2] Long time for operations when updating hosts data in RHEVM
Summary: [zstream clone - 4.1.2] Long time for operations when updating hosts data in ...
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Enterprise Virtualization Manager
Classification: Red Hat
Component: ovirt-engine
Version: 4.0.0
Hardware: Unspecified
OS: Unspecified
high
urgent
Target Milestone: ovirt-4.1.2
: ---
Assignee: Yevgeny Zaspitsky
QA Contact: Mor
URL:
Whiteboard:
Depends On: 1431228
Blocks:
TreeView+ depends on / blocked
 
Reported: 2017-03-29 07:00 UTC by rhev-integ
Modified: 2020-05-14 15:51 UTC (History)
17 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Previously, there was high latency when updating the data from a host’s Comment field to the Manager. This has now been fixed by improving the logic used when querying the database and by accessing a lighter VDS view in the database.
Clone Of: 1431228
Environment:
Last Closed: 2017-05-24 11:22:38 UTC
oVirt Team: Network
Target Upstream Version:
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Knowledge Base (Solution) 2967901 0 None None None 2017-03-29 07:01:45 UTC
Red Hat Product Errata RHEA-2017:1280 0 normal SHIPPED_LIVE Red Hat Virtualization Manager (ovirt-engine) 4.1.2 2017-05-24 15:18:48 UTC
oVirt gerrit 73990 0 'None' 'MERGED' 'engine: add active hosts caching in NetworkClusterHelper' 2019-11-26 19:19:26 UTC
oVirt gerrit 73991 0 'None' 'MERGED' 'engine: reuse preliminarily loaded host object in HostNicsUtil' 2019-11-26 19:19:26 UTC
oVirt gerrit 73992 0 'None' 'MERGED' 'engine: update commands to use the new networkClusterHelper.setStatus' 2019-11-26 19:19:26 UTC
oVirt gerrit 74081 0 'None' 'MERGED' 'engine: remove redundant load of NetworkCluster''s in UpdateVdsCommand' 2019-11-26 19:19:26 UTC
oVirt gerrit 74082 0 'None' 'MERGED' 'engine: add active hosts caching in NetworkClusterHelper' 2019-11-26 19:19:26 UTC
oVirt gerrit 74083 0 'None' 'MERGED' 'engine: reuse preliminarily loaded host object in HostNicsUtil' 2019-11-26 19:19:26 UTC
oVirt gerrit 74084 0 'None' 'MERGED' 'engine: update commands to use the new networkClusterHelper.setStatus' 2019-11-26 19:19:26 UTC
oVirt gerrit 74149 0 'None' 'ABANDONED' 'engine: remove NetworkCluster status update from UpdateVdsCommand' 2019-11-26 19:19:26 UTC
oVirt gerrit 74334 0 'None' 'MERGED' 'engine: use vdsDynamicDao instead of vdsDao' 2019-11-26 19:19:26 UTC
oVirt gerrit 74335 0 'None' 'ABANDONED' 'engine: introduce VdsStaticDao.getHostIdsForClusterAndStatus' 2019-11-26 19:19:26 UTC
oVirt gerrit 74336 0 'None' 'ABANDONED' 'engine: avoid using VdsDao in NetworkClusterHelper' 2019-11-26 19:19:27 UTC
oVirt gerrit 74337 0 'None' 'MERGED' 'engine: add shortcut in DefaultReadDao.get' 2019-11-26 19:19:27 UTC
oVirt gerrit 74350 0 'None' 'ABANDONED' 'engine: introduce ClusterDao.getClusterByHostId' 2019-11-26 19:19:27 UTC
oVirt gerrit 74351 0 'None' 'ABANDONED' 'engine: avoid using VdsDao in NetworkImplementationDetailsUtils' 2019-11-26 19:19:27 UTC
oVirt gerrit 74454 0 'None' 'MERGED' 'engine: add shortcut in DefaultReadDao.get' 2019-11-26 19:19:27 UTC
oVirt gerrit 74455 0 'None' 'MERGED' 'engine: use vdsDynamicDao instead of vdsDao' 2019-11-26 19:19:27 UTC
oVirt gerrit 74456 0 'None' 'ABANDONED' 'engine: introduce VdsStaticDao.getHostIdsForClusterAndStatus' 2019-11-26 19:19:27 UTC
oVirt gerrit 74457 0 'None' 'ABANDONED' 'engine: avoid using VdsDao in NetworkClusterHelper' 2019-11-26 19:19:27 UTC
oVirt gerrit 74458 0 'None' 'ABANDONED' 'engine: introduce ClusterDao.getClusterByHostId' 2019-11-26 19:19:27 UTC
oVirt gerrit 74459 0 'None' 'ABANDONED' 'engine: avoid using VdsDao in NetworkImplementationDetailsUtils' 2019-11-26 19:19:27 UTC
oVirt gerrit 74684 0 'None' 'ABANDONED' 'engine: add namedParameterJdbcTemplate bean' 2019-11-26 19:19:28 UTC

Description rhev-integ 2017-03-29 07:00:45 UTC 
+++ This bug is a downstream clone. The original bug is: +++
+++   bug 1431228 +++
======================================================================

Description of problem:

Operations (hosts only):

  - Edit host  (Comment field, Name field)
  - Hosts -> Network Interface -> Setup Network (Edit any field)

Operations can take from 10m to 40m


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

RHEVM 4.0.6.3-0.1.el7

(Originally by dougsland)
Comment 8 rhev-integ 2017-03-29 07:01:31 UTC 
attempting to clone this first to 4.1.z

(Originally by danken)
Comment 9 Dan Kenigsberg 2017-03-29 07:04:52 UTC 
ydary requested this as a hotfix for 4.0.7. I don't like the idea (due to the RCM and testing effort, combined with the nearing release of 4.1), but I am recording it here.
Comment 12 Mor 2017-04-30 08:38:31 UTC 
Verified on:
Red Hat Virtualization Manager Version: 4.1.2-0.1.el7
Comment 13 Mor 2017-04-30 10:45:32 UTC 
With Power Management set ON, I see slow performance again.
Comment 14 Mor 2017-04-30 12:12:08 UTC 
Verified on:
Red Hat Virtualization Manager Version: 4.1.2-0.1.el7

In order to verify it, I done the following steps:
1. Adding additional core (2 in total) on the engine VM to improve engine CPU time.
2. Setting up environment with 30 hosts and 50 hosts networks with VLAN attached to each of the hosts.
3. Setting up Power Management agent on each of the 50 hosts.
4. Changing host comment.
5. Editing existing host network and changing IP address settings.
6. Removing and adding host networks from specific host.
Comment 15 Emma Heftman 2017-05-17 06:58:15 UTC 
Yvegny,
In the doc text you mention only the comment field as causing the problematic behavior, but in the description you discuss other fields such as Name and Setup Network.

Please update the doc text to reflect the true causes, if indeed it is not only the comment field.
Comment 16 Emma Heftman 2017-05-17 08:17:01 UTC 
(In reply to Emma Heftman from comment #15)
> Yvegny,
> In the doc text you mention only the comment field as causing the
> problematic behavior, but in the description you discuss other fields such
> as Name and Setup Network.
> 
> Please update the doc text to reflect the true causes, if indeed it is not
> only the comment field.

I discussed the issue with Mor and updated the text.
Comment 18 errata-xmlrpc 2017-05-24 11:22:38 UTC 
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHEA-2017:1280
Note You need to log in before you can comment on or make changes to this bug.