-
Incident report
-
Resolution: Fixed
-
Blocker
-
2.2.6
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.