Bug 1436972

Summary: [zstream clone - 4.1.2] Long time for operations when updating hosts data in RHEVM
Product: Red Hat Enterprise Virtualization Manager Reporter: rhev-integ
Component: ovirt-engineAssignee: Yevgeny Zaspitsky <yzaspits>
Status: CLOSED ERRATA QA Contact: Mor <mkalfon>
Severity: urgent Docs Contact:
Priority: high    
Version: 4.0.0CC: adumitru, danken, eedri, eheftman, gshereme, lsurette, mburman, mkalfon, nashok, rbalakri, rgolan, Rhev-m-bugs, sbonazzo, srevivo, ykaul, ylavi, yzaspits
Target Milestone: ovirt-4.1.2Keywords: Performance, ZStream
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
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.
 Story Points: ---
Clone Of: 1431228 Environment:
Last Closed: 2017-05-24 11:22:38 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: Network RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On: 1431228    
Bug Blocks:    

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