slow loading of the package deploy tab #381
Comments
|
Do you think this a resource problem? we have about: |
|
Hello, your infrastructure could also be the cause, for example :
we've never had the opportunity to test the plugin on such a large volume. If you use the plugin more than professionally, Best regards |
|
We are not this big. I'm going to ask sysadmin to check the db when glpi hangs to understand if it's a lack of resources' issue. |
|
Virtual machine All the other pages loads instantaneously. With Analize in Firefox I can see this:
Anyone can reproduce it? |
|
How many package are available per Computer ? |
|
for pc with about 90 packages (os 64bit) it takes from 20 to 25 seconds it seams there's no correlation beetween the number of packages available and the load time :-( How about cache the list and reload it only if there's a change in one or more package? Here: and here: |
|
p.s. Tasks/Groups tabs loads instantly |
|
Can you create a deployment task for a single computer and see if it loads faster? |
|
I found a pc that doesn't belong to any dynamic group and it take the same amount of time about 20/25 seconds to fully load Deploy Package tab and then it display:
|
wait I'm not talking about tasks but packages deploy |
|
With or without deploy task, tab is load like a charm
It may be linked to something else, but it's going to be complicated to find without having a hand Perhaps you could enable the slow-query log in mysql to see if that's where the problem lies Or perhaps consider taking out a subscription as you seem to have a very professional and sophisticated use of the plugin This would enable us to resolve your problem more quickly and easily. |
|
we are in the same page? in my case is
|
|
bad past, but same behavior |
|
I activated debug and got this screens. Can they help in some way? |
|
Database queries seems huge (1659 against 230 for me) ! can you disable all the other plugins (except glpiinventory) Can you retry with GLPI latest version (some optimization are added) |
|
With only glpiinventory activated:
|
|
I confess I don't understand |
|
can you list the queries you have so I can take a look to the differences with ours? |
|
@stonebuzz ping 😄 |
|
hI @kintaro1981 Here are the only two requests concerning package deployment (when opening the SELECT `job`.*
FROM `glpi_plugin_glpiinventory_taskjobs` AS `job` LEFT JOIN `glpi_plugin_glpiinventory_tasks` AS `task` ON (`job`.`plugin_glpiinventory_tasks_id` = `task`.`id`)
WHERE `task`.`is_deploy_on_demand` = '1' AND `task`.`is_active` = '1' AND `task`.`entities_id` IN ('0', '1')SELECT DISTINCT `glpi_plugin_glpiinventory_deploypackages`.*
FROM `glpi_plugin_glpiinventory_deploypackages` LEFT JOIN `glpi_plugin_glpiinventory_deploypackages_groups` ON (`glpi_plugin_glpiinventory_deploypackages`.`id` = `glpi_plugin_glpiinventory_deploypackages_groups`.`plugin_glpiinventory_deploypackages_id`) LEFT JOIN `glpi_plugin_glpiinventory_deploypackages_entities` ON (`glpi_plugin_glpiinventory_deploypackages`.`id` = `glpi_plugin_glpiinventory_deploypackages_entities`.`plugin_glpiinventory_deploypackages_id`) LEFT JOIN `glpi_plugin_glpiinventory_deploypackages_users` ON (`glpi_plugin_glpiinventory_deploypackages`.`id` = `glpi_plugin_glpiinventory_deploypackages_users`.`plugin_glpiinventory_deploypackages_id`) LEFT JOIN `glpi_plugin_glpiinventory_deploypackages_profiles` ON (`glpi_plugin_glpiinventory_deploypackages`.`id` = `glpi_plugin_glpiinventory_deploypackages_profiles`.`plugin_glpiinventory_deploypackages_id`)
WHERE `glpi_plugin_glpiinventory_deploypackages`.`plugin_glpiinventory_deploygroups_id` > '0' AND (((`glpi_plugin_glpiinventory_deploypackages_entities`.`entities_id` = '0')) OR (`glpi_plugin_glpiinventory_deploypackages_users`.`users_id` = '2') OR (`glpi_plugin_glpiinventory_deploypackages_profiles`.`profiles_id` = '4')) |
|
I delete some dynamic groups and now the page loads a little bit faster (10 seconds instead of 25), but the query number is still high (about 1100). I noticed with debug enabled that deploy tab run many query but the strange thing is that it run multiple time the same queries, is it normal? see attached ods file. Maybe the problem is in this redundant number of querys? The queries are done relatively fast (2 seconds) but maybe php scripts have to elaborate and/or wait data from them? |
|
@stonebuzz about the query number: can you try to click con the package deploy tab and then reload the page? Another thing: |
|
Hi @kintaro1981 as requested there is a list of SQL query SELECT `job`.*
FROM `glpi_plugin_glpiinventory_taskjobs` AS `job` LEFT JOIN `glpi_plugin_glpiinventory_tasks` AS `task` ON (`job`.`plugin_glpiinventory_tasks_id` = `task`.`id`)
WHERE `task`.`is_deploy_on_demand` = '1' AND `task`.`is_active` = '1' AND `task`.`entities_id` IN ('0', '1', '2', '3')
0 ms 1
SELECT DISTINCT `glpi_plugin_glpiinventory_deploypackages`.*
FROM `glpi_plugin_glpiinventory_deploypackages` LEFT JOIN `glpi_plugin_glpiinventory_deploypackages_groups` ON (`glpi_plugin_glpiinventory_deploypackages`.`id` = `glpi_plugin_glpiinventory_deploypackages_groups`.`plugin_glpiinventory_deploypackages_id`) LEFT JOIN `glpi_plugin_glpiinventory_deploypackages_entities` ON (`glpi_plugin_glpiinventory_deploypackages`.`id` = `glpi_plugin_glpiinventory_deploypackages_entities`.`plugin_glpiinventory_deploypackages_id`) LEFT JOIN `glpi_plugin_glpiinventory_deploypackages_users` ON (`glpi_plugin_glpiinventory_deploypackages`.`id` = `glpi_plugin_glpiinventory_deploypackages_users`.`plugin_glpiinventory_deploypackages_id`) LEFT JOIN `glpi_plugin_glpiinventory_deploypackages_profiles` ON (`glpi_plugin_glpiinventory_deploypackages`.`id` = `glpi_plugin_glpiinventory_deploypackages_profiles`.`plugin_glpiinventory_deploypackages_id`)
WHERE `glpi_plugin_glpiinventory_deploypackages`.`plugin_glpiinventory_deploygroups_id` > '0' AND (((`glpi_plugin_glpiinventory_deploypackages_entities`.`entities_id` = '0')) OR (`glpi_plugin_glpiinventory_deploypackages_users`.`users_id` = '2') OR (`glpi_plugin_glpiinventory_deploypackages_profiles`.`profiles_id` = '4'))
1 ms 1
SELECT *
FROM `glpi_plugin_glpiinventory_deploygroups`
WHERE `glpi_plugin_glpiinventory_deploygroups`.`id` = '4' LIMIT 1
0 ms 1
SELECT *
FROM `glpi_plugin_glpiinventory_deploygroups_staticdatas`
WHERE `plugin_glpiinventory_deploygroups_id` = '4' AND `itemtype` = 'Computer'
0 ms 1For can you try this -> #441 |
|
hi @kintaro1981 for "slow loading" I'm not sure how to help you, since I don't reproduce on my side. Perhaps you should consider taking out a subscription to benefit from professional support. Best regards |
|
We tried to update to 10.0.12. The problem is still there. |
|
Since we cannot reproduce; and existing data is certainly faulty; I close. Feel free to reopen if you can provide a use case reproducing issue on a fresh install. |
Describe the bug
Clicking in the package deploy tab takes several seconds to loade the page.
All the other pages and tabs load istantly.
Loading http://glpi/plugins/glpiinventory/front/deploypackage.php don't produce this issue, the problem is only clicking on the package deploy tab.
To reproduce
Expected behavior
The page loads like the other ones.
Operating system
Other (See additional context below)
GLPI Agent version
Other (See additional context below)
GLPI version
10.0.9
GLPIInventory plugin
1.2.3
Additional context
operating system and agent version are not involved in this issue
The text was updated successfully, but these errors were encountered: