-
Problem report
-
Resolution: Fixed
-
Critical
-
5.0.10, 5.2.6
-
PHP 7.3.27
-
Sprint 75 (Apr 2021), Sprint 76 (May 2021)
-
1
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)
- duplicates
-
ZBX-19515 Cannot access template with Discovery Rule, Apply template with Discovery Rule
-
- Closed
-
