LibreNMS Poller =================================== Version info: Commit SHA: f7aed1e2036b20c12d8eaf58aaba2adb6aebc026 Commit Date: 1512569071 DB Schema: 221 PHP: 7.0.25 MySQL: 5.5.56-MariaDB RRDTool: 1.6.0 SNMP: NET-SNMP 5.7.2 ==================================DEBUG! Starting polling run: SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'crpkvm01' ORDER BY `device_id` ASC] SQL[SELECT * FROM devices_attribs WHERE `device_id` = '159'] Hostname: crpkvm01 Device ID: 159 OS: raritan SQL[INSERT INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`) VALUES ('0','0','0','0','0','0','159',NOW())] UnpingableSQL[UPDATE `devices` set `status` ='0',`status_reason` ='icmp' WHERE device_id='159'] SQL[INSERT INTO `eventlog` (`host`,`device_id`,`reference`,`type`,`datetime`,`severity`,`message`,`username`) VALUES ('159','159','NULL','down',NOW(),'2','Device status changed to Down from icmp check.','')] #### Start Alerts #### SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='159'] SQL[SELECT alert_schedule.schedule_id FROM alert_schedule LEFT JOIN alert_schedule_items ON alert_schedule.schedule_id=alert_schedule_items.schedule_id WHERE ( alert_schedule_items.target = '159' ) && ((alert_schedule.recurring = 0 AND (NOW() BETWEEN alert_schedule.start AND alert_schedule.end)) OR (alert_schedule.recurring = 1 AND (alert_schedule.start_recurring_dt <= date_format(NOW(), '--%d') AND (end_recurring_dt >= date_format(NOW(), '--%d') OR end_recurring_dt is NULL OR end_recurring_dt = '0000-00-00' OR end_recurring_dt = '')) AND (date_format(now(), '%H:%i:%s') BETWEEN `start_recurring_hr` AND end_recurring_hr) AND (recurring_day LIKE CONCAT('%',date_format(now(), ''),'%') OR recurring_day is null or recurring_day = ''))) LIMIT 1] SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='159'] SQL[SELECT alert_rules.* FROM alert_rules LEFT JOIN alert_map ON alert_rules.id=alert_map.rule WHERE alert_rules.disabled = 0 && ( (alert_rules.device_id = -1 || alert_rules.device_id = '159' ) || alert_map.target = '159' )] Rule #8 (Storage usage exceeded threshold): SQL[SELECT state FROM alerts WHERE rule_id = '8' && device_id = '159' ORDER BY id DESC LIMIT 1] SQL[SELECT * FROM storage WHERE (storage.device_id = '159') && (storage.storage_perc > storage.storage_perc_warn && storage.storage_descr NOT REGEXP "/boot" )] Status: NOCHG #### End Alerts #### SQL[INSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`) VALUES ('poll','crpkvm01','1512574821.9746','0.062','1','crplibrenms')] /opt/librenms/poller.php crpkvm01 2017-12-06 09:40:22 - 1 devices polled in 0.062 secs SNMP [0/0.00s]: Get[0/0.00s] Getnext[0/0.00s] Walk[0/0.00s] MySQL [16/0.00s]: Cell[3/0.00s] Row[1/0.00s] Rows[6/0.00s] Column[2/0.00s] Update[1/0.00s] Insert[3/0.00s] Delete[0/0.00s] RRD [0/0.00s]: Update[0/0.00s] Create [0/0.00s] Other[0/0.00s]