[ZBX-19248] Low level discovery page is very slow Created: 2021 Apr 14 Updated: 2024 Apr 10 Resolved: 2021 May 31 |
|
| Status: | Closed |
| Project: | ZABBIX BUGS AND ISSUES |
| Component/s: | Frontend (F) |
| Affects Version/s: | 5.0.10, 5.2.6 |
| Fix Version/s: | 4.0.32rc1, 5.0.13rc1, 5.2.7rc1, 5.4.1rc1, 6.0.0alpha1, 6.0 (plan) |
| Type: | Problem report | Priority: | Critical |
| Reporter: | Alexey Pustovalov | Assignee: | Vladimirs Maksimovs |
| Resolution: | Fixed | Votes: | 5 |
| Labels: | lld, overrides, performance | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: |
PHP 7.3.27 |
||
| Attachments: |
5.2to5.4 conflictng places.diff
|
||||||||
| Issue Links: |
|
||||||||
| Team: |  Team C |
||||||||
| Sprint: | Sprint 75 (Apr 2021), Sprint 76 (May 2021) | ||||||||
| Story Points: | 1 | ||||||||
| Description |
|
When open LLD rule discovery configuration Zabbix API ignores that the rule does not have overrides at all and retrieves and process all operations: SQL (0.000234): SELECT t.lld_overrideid,t.name,t.step,t.stop,t.itemid,t.formula,t.evaltype FROM lld_override t WHERE t.itemid=31367 host_discovery.php:254 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CDiscoveryRule->get() → CDiscoveryRule->addRelatedObjects() → CApiService->select() → DBselect() in include/classes/api/CApiService.php:357 SQL (0.000216): SELECT t.lld_override_conditionid,t.macro,t.value,t.lld_overrideid,t.operator FROM lld_override_condition t host_discovery.php:254 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CDiscoveryRule->get() → CDiscoveryRule->addRelatedObjects() → CApiService->select() → DBselect() in include/classes/api/CApiService.php:357 SQL (0.000218): SELECT t.lld_override_operationid,t.lld_overrideid,t.operationobject,t.operator,t.value FROM lld_override_operation t host_discovery.php:254 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CDiscoveryRule->get() → CDiscoveryRule->addRelatedObjects() → CApiService->select() → DBselect() in include/classes/api/CApiService.php:357 SQL (0.000277): SELECT lld_override_operationid,discover FROM lld_override_opdiscover WHERE lld_override_operationid IN (198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229) host_discovery.php:254 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CDiscoveryRule->get() → CDiscoveryRule->addRelatedObjects() → DB::select() → DBselect() in include/classes/db/DB.php:934 Result for: mysql> SELECT t.lld_overrideid,t.name,t.step,t.stop,t.itemid,t.formula,t.evaltype FROM lld_override t WHERE t.itemid=31367; Empty set (0.00 sec) |
| Comments |
| Comment by Vladimirs Maksimovs [ 2021 Apr 23 ] |
|
Fixed in development branches: |
| Comment by Vladimirs Maksimovs [ 2021 May 28 ] |
|
Fixed in:
|