- 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]