Red Hat Bugzilla – Bug 1057561
[SCALE] Templates are being pulled from template view in a very inefficient way
Last modified: 2016-02-10 14:03:04 EST
Same as the above from audit log was observed with templates: [pid 3767 127.0.0.1(39427)]DEBUG: 00000: parse <unnamed>: SELECT * FROM (SELECT * FROM vm_templates_view WHERE ( vmt_guid IN (SELECT vm_templates_storage_domain.vmt_guid FROM vm_templates_storage_domain )) ORDER BY name ASC ) as T1 OFFSET (1 -1) LIMIT 100 [pid 3766 127.0.0.1(39426)]DEBUG: 00000: parse <unnamed>: SELECT * FROM (SELECT * FROM vm_templates_view WHERE ( vmt_guid IN (SELECT vm_templates_storage_domain.vmt_guid FROM vm_templates_storage_domain )) ORDER BY name ASC ) as T1 OFFSET (1 -1) LIMIT 100 [pid 3722 127.0.0.1(39425)]DEBUG: 00000: parse <unnamed>: SELECT * FROM (SELECT * FROM vm_templates_view WHERE ( vmt_guid IN (SELECT vm_templates_storage_domain.vmt_guid FROM vm_templates_storage_domain )) ORDER BY name ASC ) as T1 OFFSET (1 -1) LIMIT 100 [pid 3500 127.0.0.1(39413)]DEBUG: 00000: parse <unnamed>: SELECT * FROM (SELECT * FROM vm_templates_view WHERE ( vmt_guid IN (SELECT vm_templates_storage_domain.vmt_guid FROM vm_templates_storage_domain )) ORDER BY name ASC ) as T1 OFFSET (1 -1) LIMIT 100 [pid 3500 127.0.0.1(39413)]DEBUG: 00000: parse <unnamed>: SELECT * FROM (SELECT * FROM vm_templates_view WHERE ( vmt_guid IN (SELECT vm_templates_storage_domain.vmt_guid FROM vm_templates_storage_domain )) ORDER BY name ASC ) as T1 OFFSET (1 -1) LIMIT 100 [pid 3618 127.0.0.1(39415)]DEBUG: 00000: parse <unnamed>: SELECT * FROM (SELECT * FROM vm_templates_view WHERE ( vmt_guid IN (SELECT vm_templates_storage_domain.vmt_guid FROM vm_templates_storage_domain )) ORDER BY name ASC ) as T1 OFFSET (1 -1) LIMIT 100 [pid 3766 127.0.0.1(39426)]DEBUG: 00000: parse <unnamed>: SELECT * FROM (SELECT * FROM vm_templates_view WHERE ( vmt_guid IN (SELECT vm_templates_storage_domain.vmt_guid FROM vm_templates_storage_domain )) ORDER BY name ASC ) as T1 OFFSET (1 -1) LIMIT 100 [pid 3767 127.0.0.1(39427)]DEBUG: 00000: parse <unnamed>: SELECT * FROM (SELECT * FROM vm_templates_view WHERE ( vmt_guid IN (SELECT vm_templates_storage_domain.vmt_guid FROM vm_templates_storage_domain )) ORDER BY name ASC ) as T1 OFFSET (1 -1) LIMIT 100 [pid 3767 127.0.0.1(39427)]DEBUG: 00000: parse <unnamed>: SELECT * FROM (SELECT * FROM vm_templates_view WHERE ( vmt_guid IN (SELECT vm_templates_storage_domain.vmt_guid FROM vm_templates_storage_domain )) ORDER BY name ASC ) as T1 OFFSET (1 -1) LIMIT 100 [pid 3767 127.0.0.1(39427)]DEBUG: 00000: parse <unnamed>: SELECT * FROM (SELECT * FROM vm_templates_view WHERE ( vmt_guid IN (SELECT vm_templates_storage_domain.vmt_guid FROM vm_templates_storage_domain )) ORDER BY name ASC ) as T1 OFFSET (1 -1) LIMIT 100 [pid 3500 127.0.0.1(39413)]DEBUG: 00000: parse <unnamed>: SELECT * FROM (SELECT * FROM vm_templates_view WHERE ( vmt_guid IN (SELECT vm_templates_storage_domain.vmt_guid FROM vm_templates_storage_domain )) ORDER BY name ASC ) as T1 OFFSET (1 -1) LIMIT 100 [pid 3722 127.0.0.1(39425)]DEBUG: 00000: parse <unnamed>: SELECT * FROM (SELECT * FROM vm_templates_view WHERE ( vmt_guid IN (SELECT vm_templates_storage_domain.vmt_guid FROM vm_templates_storage_domain )) ORDER BY name ASC ) as T1 OFFSET (1 -1) LIMIT 100 [pid 3767 127.0.0.1(39427)]DEBUG: 00000: parse <unnamed>: SELECT * FROM (SELECT * FROM vm_templates_view WHERE ( vmt_guid IN (SELECT vm_templates_storage_domain.vmt_guid FROM vm_templates_storage_domain )) ORDER BY name ASC ) as T1 OFFSET (1 -1) LIMIT 100 [pid 3618 127.0.0.1(39415)]DEBUG: 00000: parse <unnamed>: SELECT * FROM (SELECT * FROM vm_templates_view WHERE ( vmt_guid IN (SELECT vm_templates_storage_domain.vmt_guid FROM vm_templates_storage_domain )) ORDER BY name ASC ) as T1 OFFSET (1 -1) LIMIT 100 [pid 3722 127.0.0.1(39425)]DEBUG: 00000: parse <unnamed>: SELECT * FROM (SELECT * FROM vm_templates_view WHERE ( vmt_guid IN (SELECT vm_templates_storage_domain.vmt_guid FROM vm_templates_storage_domain )) ORDER BY name ASC ) as T1 OFFSET (1 -1) LIMIT 100 [pid 3618 127.0.0.1(39415)]DEBUG: 00000: parse <unnamed>: SELECT * FROM (SELECT * FROM vm_templates_view WHERE ( vmt_guid IN (SELECT vm_templates_storage_domain.vmt_guid FROM vm_templates_storage_domain )) ORDER BY name ASC ) as T1 OFFSET (1 -1) LIMIT 100 [pid 3766 127.0.0.1(39426)]DEBUG: 00000: parse <unnamed>: SELECT * FROM (SELECT * FROM vm_templates_view WHERE ( vmt_guid IN (SELECT vm_templates_storage_domain.vmt_guid FROM vm_templates_storage_domain )) ORDER BY name ASC ) as T1 OFFSET (1 -1) LIMIT 100 [pid 3722 127.0.0.1(39425)]DEBUG: 00000: parse <unnamed>: SELECT * FROM (SELECT * FROM vm_templates_view WHERE ( vmt_guid IN (SELECT vm_templates_storage_domain.vmt_guid FROM vm_templates_storage_domain )) ORDER BY name ASC ) as T1 OFFSET (1 -1) LIMIT 100 [pid 3722 127.0.0.1(39425)]DEBUG: 00000: parse <unnamed>: SELECT * FROM (SELECT * FROM vm_templates_view WHERE ( vmt_guid IN (SELECT vm_templates_storage_domain.vmt_guid FROM vm_templates_storage_domain )) ORDER BY name ASC ) as T1 OFFSET (1 -1) LIMIT 100
Hi Tomas, This should be exactly the same as - https://bugzilla.redhat.com/show_bug.cgi?id=1029106. Can you confirm this is the same, and that the solution works?
Hi Liran, Unfortunately not. This has been found on environment that was upgraded to 3.3 GA (which afaik included the patch already).
Hi Tomas, Just to make sure - the fix was entered in 3.3.2, and was merged on December 10th. Are you sure your version is newer?
what is considered to be OK time ? now it takes ~2seconds is it ok? tested on ovirt-engine-3.4.0-0.7.beta2.el6.noarch
functional testing point of view: i see that the audit_log and event_log are viewed ok. Gil, do u see apropriate to do scale testing here by Yuri's team? Or shall i move it to verify?
Eldad, would you be able to verify this on the scale lab?
Not reproduced
Closing as part of 3.4.0