Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1114285

Summary: [Scale] - updatevdsdynamic running too slow on scale setup
Product: Red Hat Enterprise Virtualization Manager Reporter: Eldad Marciano <emarcian>
Component: ovirt-engineAssignee: Liran Zelkha <lzelkha>
Status: CLOSED CURRENTRELEASE QA Contact: Eldad Marciano <emarcian>
Severity: high Docs Contact:
Priority: unspecified    
Version: 3.4.0CC: acathrow, bazulay, emarcian, gklein, iheim, lpeer, lzelkha, oourfali, pstehlik, Rhev-m-bugs, sherold, yeylon
Target Milestone: ---Keywords: Regression
Target Release: 3.5.0   
Hardware: x86_64   
OS: Linux   
Whiteboard: infra
Fixed In Version: org.ovirt.engine-root-3.5.0-14 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2015-02-17 17:10:11 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: Infra RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 1156162    

Description Eldad Marciano 2014-06-29 13:54:39 UTC 
Description of problem:
'updatevdsdynamic' store procedure running too slow on scale setup, 
the function ration depends on the object(hosts, vms) capacity, while object capacity(sizing) growing up, it will hit the performance 
 
Version-Release number of selected component (if applicable):
3.4

How reproducible:
100%

Steps to Reproduce:
1.scale setup (530 hosts, ~4300 vms)

Actual results:
duration: 10919.393 ms execute <unnamed>: 
select * from updatevdsdynamic($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47) as result

Expected results:
mo longer than 1 sec.

Additional info:
as required explain plan + analysis.

query for debug:

select * from updatevdsdynamic('4',
'4',
'Intel(Fake) CPU',
'1999.999',
NULL,
't',
'386',
'5831',
'3',
'1e8cd9a1-d6e3-4f08-b8b8-db13c1af5d00',
'1',
'1',
'1',
'0',
'321',
'65',
'vdsm-4.14.7-3.el6ev',
'4.14',
'Snow Man',
NULL,
'3',
'model_pentium3',
NULL,
'1',
'128',
'2',
'f',
'3.0,3.1,3.2,3.3,3.4',
'3.0,3.1,3.2,3.3,3.4',
'RHEL- 6Server- 6.5.0.0.el6',
'0.12.1.2-2.415.el6_5.9',
'libvirt-0.10.2-29.el6_5.7',
'0.12.4-6.el6',
NULL,
'2.6.32 - 431.20.3.el6.x86_64',
'iqn.1994-05.com.redhat:f086e0c266e',
'2',
'{before_vm_start={10_faqemu={md5=e3cb338	be6b9075a	04bed0e74	00ab7e2}},before_vdsm_start={fake_host.py={md5=72d9aae231d7b9f6eebb3387c31bbc99}},after_get_all_vm_stats={10_fakevmstats={md5=85aa50638834d47a9776997cbe69a760}}}',
'0',
'Red Hat',
'RHEV Hypervisor',
'6Server-6.5.0.1.el6',
'4C4C4544-0046-5710-8057-C8C04F365831',
'57c8cc45-ea8b-453c-9bd9-462f2	08b52d6',
'Red Hat Enterprise Linux',																																
NULL,
'rhel6.5.0') as result
Comment 1 Liran Zelkha 2014-07-15 12:32:05 UTC 
Guys - I want to close this bug. I understand that even for 10K hosts this still doesn't happen. Please confirm.
Comment 2 Eldad Marciano 2014-09-14 14:25:22 UTC 
Reproduced on 3.5
Comment 3 Eldad Marciano 2014-09-14 14:27:48 UTC 
8-10 sec for 'updatevdsdynamic'
distribution:
-500 hosts
-10K vms
Comment 5 Liran Zelkha 2014-09-15 18:40:36 UTC 
Eldad - can you please try using this patch - http://gerrit.ovirt.org/#/c/32282/ ?
Comment 6 Liran Zelkha 2014-09-30 07:18:15 UTC 
Eldad - news?
Comment 7 Eldad Marciano 2014-10-01 10:53:48 UTC 
we have some troubles with the current 3.5 scale setup.
i'll update ASAP.
Comment 8 Eldad Marciano 2014-10-01 15:07:50 UTC 
patch applied, patch +1
updatevdsdynamic were not found at the long duration query's log.
Comment 9 Liran Zelkha 2014-10-01 18:00:29 UTC 
*** Bug 1136345 has been marked as a duplicate of this bug. ***
Comment 10 Eyal Edri 2014-10-07 07:12:33 UTC 
this bug status was moved to MODIFIED before engine vt5 was built,
hence moving to on_qa, if this was mistake and the fix isn't in,
please contact rhev-integ
Comment 11 Eldad Marciano 2015-01-28 12:32:09 UTC 
verified on VT13.7
Comment 12 Eyal Edri 2015-02-17 17:10:11 UTC 
rhev 3.5.0 was released. closing.