Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-19248

Low level discovery page is very slow

XMLWordPrintable

    • 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)
      

            vmaksimovs Vladimirs Maksimovs
            dotneft Alexey Pustovalov
            Team C
            Votes:
            5 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated:
              Resolved: