Details

      Description

      If one of item keys contain {HOST.IP} (or similar macros), Zabbix tries to expand it and executes the next query on Monitoring->Latest data page:

      SQL (0.00014): SELECT hi.interfaceid,hi.ip,hi.dns,hi.useip FROM interface hi
      latest.php:202 ? CMacrosResolverHelper::resolveItemKeys() ? CMacrosResolver->resolveItemKeys() ? CAPIObject->get() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CItem->get() ? CItem->addRelatedObjects() ? CHostInterface->get() ? DBselect() in /var/www/zabbix/2.2.6/api/classes/CHostInterface.php:195
      

      a part of code from CItem class:

                      // adding interfaces
                      if ($options['selectInterfaces'] !== null && $options['selectInterfaces'] != API_OUTPUT_COUNT) {
                              $relationMap = $this->createRelationMap($result, 'itemid', 'interfaceid');
                              $interfaces = API::HostInterface()->get(array(
                                      'nodeids' => $options['nodeids'],
                                      'output' => $options['selectInterfaces'],
                                      'intefaceids' => $relationMap->getRelatedIds(),
                                      'nopermissions' => true,
                                      'preservekeys' => true
                              ));
                              $result = $relationMap->mapMany($result, $interfaces, 'interfaces');
                      }
      

      So it tries to retrieve all interfaces from database.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              dotneft Alexey Pustovalov
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: