Description of problem: Related to 1378991, EMS refresh is slow causing automate methods to timeout when creating folders. Additional info: Providing a database dump
Looking at a typical full EmsRefresh using the broker cache, here are some notable durations for different steps: Total duration: 21min 11sec Getting cached inventory: 30sec Getting Host Storage Devices: 11min 31sec Storage devices for hosts are not stored in the broker cache so every refresh has to go out to the vCenter to get this information. Currently this is done once for each host which incurs a lot of overhead. Two possible solutions: 1. Keep host storage devices in broker cache 2. Retrieve storage devices for all hosts in one API call
Created attachment 1206036 [details] 5.6.1.2 hotfix to retrieve all host.config.storageDevice in one API call
PR https://github.com/ManageIQ/manageiq/pull/11629
Created attachment 1210091 [details] 5.6.1.2_hotfix_host_storage_devices.tar.gz cherry picked from commit 59f755fe421983761bc48d3162f79b109126c4a6 tar tfz 5.6.1.2_hotfix_host_storage_devices.tar.gz app/models/ems_refresh/vc_updates.rb app/models/manageiq/providers/vmware/infra_manager/refresher.rb gems/pending/VMwareWebService/MiqVimInventory.rb
https://github.com/ManageIQ/manageiq-gems-pending/pull/17
*** Bug 1341402 has been marked as a duplicate of this bug. ***
*** Bug 1353707 has been marked as a duplicate of this bug. ***
*** Bug 1382163 has been marked as a duplicate of this bug. ***