Bug 1308478
Summary: | [SCALE] Create new VM in webadmin portal shows only spinning ring. | ||||||
---|---|---|---|---|---|---|---|
Product: | Red Hat Enterprise Virtualization Manager | Reporter: | Roman Hodain <rhodain> | ||||
Component: | ovirt-engine | Assignee: | Shmuel Melamud <smelamud> | ||||
Status: | CLOSED CURRENTRELEASE | QA Contact: | Eldad Marciano <emarcian> | ||||
Severity: | high | Docs Contact: | |||||
Priority: | high | ||||||
Version: | 3.5.7 | CC: | emarcian, gklein, lsurette, mgoldboi, michal.skrivanek, rbalakri, Rhev-m-bugs, rhodain, sbonazzo, srevivo, tjelinek, ykaul | ||||
Target Milestone: | ovirt-4.0.0-beta | Keywords: | Reopened | ||||
Target Release: | --- | ||||||
Hardware: | Unspecified | ||||||
OS: | Unspecified | ||||||
Whiteboard: | virt | ||||||
Fixed In Version: | Doc Type: | Bug Fix | |||||
Doc Text: | Story Points: | --- | |||||
Clone Of: | Environment: | ||||||
Last Closed: | 2016-05-10 11:57:29 UTC | Type: | Bug | ||||
Regression: | --- | Mount Type: | --- | ||||
Documentation: | --- | CRM: | |||||
Verified Versions: | Category: | --- | |||||
oVirt Team: | Virt | RHEL 7.3 requirements from Atomic Host: | |||||
Cloudforms Team: | --- | Target Upstream Version: | |||||
Embargoed: | |||||||
Attachments: |
|
Description
Roman Hodain
2016-02-15 10:34:04 UTC
Created attachment 1127228 [details]
explain of the SQL command
we don't need disks before you choose a particular template, right? No, we don't need it in advance - it is enough to have it only for the selected one. Product Management has reviewed and declined this request. You may appeal this decision by reopening this request. this bug still reproduced in 3.6.5.1, the spining ring at least not running forever. the dialog box became available after ~20-30 sec. and seems like getdisksvmguid has been called several time serially while the dialog loading. any chance to execute them in parallel? moreover each one of the execution takes around 5 sec. is getstorage_domains_by_storagepoolid executed by this flow as well? further profiler session required. here we have the pg log while we hit the diablog box for new templates. LOG: duration: 5995.970 ms execute <unnamed>: select * from getdisksvmguid($1, $2, $3, $4) LOG: duration: 5857.623 ms execute <unnamed>: select * from getstorage_domains_by_storagepoolid($1, $2, $3) LOG: duration: 5905.632 ms execute <unnamed>: select * from getdisksvmguid($1, $2, $3, $4) LOG: duration: 5607.681 ms execute <unnamed>: select * from getdisksvmguid($1, $2, $3, $4) LOG: duration: 5619.016 ms execute <unnamed>: select * from getdisksvmguid($1, $2, $3, $4) LOG: duration: 5926.344 ms execute <unnamed>: select * from getdisksvmguid($1, $2, $3, $4) LOG: duration: 5957.711 ms execute <unnamed>: select * from getdisksvmguid($1, $2, $3, $4) LOG: duration: 5897.029 ms execute <unnamed>: select * from getstorage_domains_by_storagepoolid($1, $2, $3) LOG: duration: 5942.826 ms execute <unnamed>: select * from getdisksvmguid($1, $2, $3, $4) LOG: duration: 5644.935 ms execute <unnamed>: select * from getdisksvmguid($1, $2, $3, $4) LOG: duration: 5976.697 ms execute <unnamed>: select * from getdisksvmguid($1, $2, $3, $4) LOG: duration: 5897.564 ms execute <unnamed>: select * from getdisksvmguid($1, $2, $3, $4) LOG: duration: 5877.607 ms execute S_31: select * from getstorage_domains_by_storagepoolid($1, $2, $3) LOG: duration: 6021.145 ms execute <unnamed>: select * from getdisksvmguid($1, $2, $3, $4) LOG: duration: 6105.581 ms execute <unnamed>: select * from getstorage_domains_by_storage_pool_id_with_permitted_action($1, $2, $3) LOG: duration: 6477.493 ms execute S_29: select * from getstorage_domains_by_storagepoolid($1, $2, $3) LOG: duration: 5572.327 ms execute S_32: select * from getstorage_domains_by_storagepoolid($1, $2, $3) (In reply to Eldad Marciano from comment #6) > this bug still reproduced in 3.6.5.1, the spining ring at least not running > forever. > the dialog box became available after ~20-30 sec. How many VMs, disks, templates, storage domains, ... ? > and seems like > getdisksvmguid has been called several time serially while the dialog > loading. > > any chance to execute them in parallel? Why? If it is a high scale env., I'm OK with 20-30 seconds. What is the storage of the DB? Just a plain disk? Move it to something better. (In reply to Yaniv Kaul from comment #7) > (In reply to Eldad Marciano from comment #6) > > this bug still reproduced in 3.6.5.1, the spining ring at least not running > > forever. > > the dialog box became available after ~20-30 sec. > > How many VMs, disks, templates, storage domains, ... ? overall: vms 10K disks 29.8K templates 400 storage domains 13 for this particular data center (real): vms 3K disks 1 disk per vm 3K templates 400 storage domains 12 > > > and seems like > > getdisksvmguid has been called several time serially while the dialog > > loading. > > > > any chance to execute them in parallel? > > Why? If it is a high scale env., I'm OK with 20-30 seconds. What is the > storage of the DB? Just a plain disk? Move it to something better. Seems like it's inefficent query, we probably can make it faster, by optimize it, without any hardware changes. I need to check with Allon. seems like we already optimize this query. let's keep it for further investigation for a while. But technically I think it improved enough (no "minutes" anymore) so Roman, I guess you can report that back. What do you think? (In reply to Michal Skrivanek from comment #9) > let's keep it for further investigation for a while. But technically I think > it improved enough (no "minutes" anymore) so Roman, I guess you can report > that back. What do you think? It was communicated and we are waiting for response. oVirt 4.0 Alpha has been released, moving to oVirt 4.0 Beta target. Seems good enough in 3.6.5 |