Bug 768755

Summary: ETL copies duplicate entries of all hosts every hour.
Product: Red Hat Enterprise Virtualization Manager Reporter: Eli Mesika <emesika>
Component: ovirt-engine-dwhAssignee: Yaniv Lavi <ylavi>
Status: CLOSED CURRENTRELEASE QA Contact: David Botzer <dbotzer>
Severity: urgent Docs Contact:
Priority: high    
Version: 3.0.0CC: acathrow, cpelland, dyasny, ecohen, iheim, lpeer, mkenneth, pstehlik, Rhev-m-bugs, yeylon, ykaul
Target Milestone: ---Keywords: ZStream
Target Release: ---   
Hardware: Unspecified   
OS: Linux   
Whiteboard: infra
Fixed In Version: SI7 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
: 771376 (view as bug list) Environment:
Last Closed: 2012-12-04 19:57:57 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: Infra RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Bug Depends On:    
Bug Blocks: 771376    

Description Eli Mesika 2011-12-18 17:00:45 UTC 
Description of problem:
RegisterVdsQuery is called periodically and updates vds_static, this changes the _update flug inside vds_static and makes ETL getting the information (which was not changed) again and again.

This problem was reported after ETL consumed 100% CPU
Analysis, done by Juan, showed that ETL is periodically changing host configuration, as a result a query based on the host_configuration view  
is executed frequently and loading the CPU.
Juan also found that the query is not optimized, a patch for that is already pushed to Gerrit (see : See Also)

It is worth to mention also that this occurred on a system with no RHEV-H , even though , the RegisterVdsQuery that is relevant only for RHEV-H was running.


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

How reproducible:
Large systems with history module installed and active ETL

Steps to Reproduce:
1.
2.
3.
  
Actual results:


Expected results:
RegisterVdsQuery should not be called without a reason
The _update flag should be updated only when vds is edited 

Additional info:
Comment 1 Itamar Heim 2011-12-19 05:00:59 UTC 
please note kaul said there are no rhev-h in this environment, so need to revisit the assumption of registerVdsQuery which is supposed to be called only by vdsm_reg (could be old data in the environment as well - easy to check since we have a host type, logs(?), etc.)
Comment 4 Yaniv Lavi 2011-12-27 16:53:28 UTC 
A patch for this issue is available in this link: 
http://gerrit.ovirt.org/773
of the ovirt-engine repository.


Yaniv
Comment 6 Yaniv Lavi 2012-01-03 07:54:19 UTC 
Moved to POST since there isn't a 3.1 rhevm branch yet.


Yaniv
Comment 10 David Botzer 2012-08-22 11:11:10 UTC 
Fixed, 3.1/si14
I checked in engine db vds_static for "_update_date" 
And got 4 lines over 6 days
Fixed, 3.1/si14