LibreNMS Poller SQL[[1;33mselect `version` from `dbSchema` order by `version` desc limit 1 [0;33m[][0m 0.36ms] SQL[[1;33mSELECT version() [0;33m[][0m 0.23ms] =================================== Version info: Commit SHA: 01e8a6e0896ce1916a8492e1a1219c09da10c700 Commit Date: 1535060429 DB Schema: 260 PHP: 7.0.30-0ubuntu0.16.04.1 MySQL: 10.0.34-MariaDB-0ubuntu0.16.04.1 RRDTool: 1.5.5 SNMP: NET-SNMP 5.7.3 ==================================DEBUG! Updating os_def.cache... Done Starting polling run: SQL[[1;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '10.1.1.16' ORDER BY `device_id` ASC [0;33m[][0m 1.05ms] SQL[[1;33mSELECT * FROM devices_attribs WHERE `device_id` = ? [0;33m[150][0m 0.26ms] Hostname: 10.1.1.16 Device ID: 150 OS: generic Warning: inet_pton(): Unrecognized address in /opt/librenms/includes/polling/functions.inc.php on line 248 [FPING] /usr/bin/fping -e -q -c 3 -p 500 -t 500 10.1.1.16 Array ( [xmt] => 3 [rcv] => 3 [loss] => 0 [min] => 5.91 [max] => 6.14 [avg] => 6.05 [exitcode] => 0 ) SQL[[1;33mINSERT IGNORE INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`) VALUES (:xmt,:rcv,:loss,:min,:max,:avg,:device_id,NOW()) [0;33m{"xmt":"3","rcv":"3","loss":"0","min":"5.91","max":"6.14","avg":"6.05","device_id":150}[0m 25.25ms] SNMP Check response code: 0 Modules status: Global+ OS Device #### Load poller module core #### SNMP[[0;36m/usr/bin/snmpget -v1 -c COMMUNITY -OQnUt -m SNMPv2-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 sysUpTime.0 sysLocation.0 sysContact.0 sysName.0 sysObjectID.0 sysDescr.0[0m] SNMP[[0;36m/usr/bin/snmpget -v1 -c COMMUNITY -OQnUst -m HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 snmpEngineTime.0 hrSystemUptime.0[0m] Uptime seconds: 0 SQL[[1;33mINSERT IGNORE INTO `eventlog` (`host`,`device_id`,`reference`,`type`,`datetime`,`severity`,`message`,`username`) VALUES (:host,:device_id,:reference,:type,NOW(),:severity,:message,:username) [0;33m{"host":150,"device_id":150,"reference":"NULL","type":"system","severity":3,"message":"sysObjectID -> ","username":""}[0m 796.03ms] SQL[[1;33mINSERT IGNORE INTO `eventlog` (`host`,`device_id`,`reference`,`type`,`datetime`,`severity`,`message`,`username`) VALUES (:host,:device_id,:reference,:type,NOW(),:severity,:message,:username) [0;33m{"host":150,"device_id":150,"reference":"NULL","type":"system","severity":3,"message":"sysName -> ","username":""}[0m 664.49ms] SQL[[1;33mINSERT IGNORE INTO `eventlog` (`host`,`device_id`,`reference`,`type`,`datetime`,`severity`,`message`,`username`) VALUES (:host,:device_id,:reference,:type,NOW(),:severity,:message,:username) [0;33m{"host":150,"device_id":150,"reference":"NULL","type":"system","severity":3,"message":"sysDescr -> ","username":""}[0m 97.98ms] >> Runtime for poller module 'core': 7.6333 seconds with 8752 bytes >> SNMP: [2/6.07s] MySQL: [3/1.56s] RRD: [0/0.00s] #### Unload poller module core #### RRD[[0;32mupdate /opt/librenms/rrd/10.1.1.16/poller-perf-core.rrd N:7.6333470344543[0m] [[0;31mRRD Disabled[0m]Modules status: Global- OS Device Module [ unix-agent ] disabled globally. Modules status: Global+ OS Device #### Load poller module os #### Generic :( Hardware: Version: Features: Serial: >> Runtime for poller module 'os': 0.0002 seconds with 512 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module os #### RRD[[0;32mupdate /opt/librenms/rrd/10.1.1.16/poller-perf-os.rrd N:0.00022006034851074[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module ipmi #### SQL[[1;33mSELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [0;33m[150][0m 0.6ms] Array ( ) >> Runtime for poller module 'ipmi': 0.0011 seconds with 2512 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module ipmi #### RRD[[0;32mupdate /opt/librenms/rrd/10.1.1.16/poller-perf-ipmi.rrd N:0.0010678768157959[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module sensors #### SQL[[1;33mSELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [0;33m[150][0m 0.54ms] >> Runtime for poller module 'sensors': 0.0008 seconds with 1464 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module sensors #### RRD[[0;32mupdate /opt/librenms/rrd/10.1.1.16/poller-perf-sensors.rrd N:0.00083780288696289[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module processors #### Attempting to initialize OS: generic OS initialized: LibreNMS\OS\Generic SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[150][0m 0.44ms] >> Runtime for poller module 'processors': 0.0029 seconds with 97440 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module processors #### RRD[[0;32mupdate /opt/librenms/rrd/10.1.1.16/poller-perf-processors.rrd N:0.0028698444366455[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module mempools #### SQL[[1;33mSELECT * FROM mempools WHERE device_id = ? [0;33m[150][0m 0.45ms] >> Runtime for poller module 'mempools': 0.0008 seconds with 1760 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module mempools #### RRD[[0;32mupdate /opt/librenms/rrd/10.1.1.16/poller-perf-mempools.rrd N:0.00082278251647949[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module storage #### SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[150][0m 0.43ms] >> Runtime for poller module 'storage': 0.0008 seconds with 1824 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module storage #### RRD[[0;32mupdate /opt/librenms/rrd/10.1.1.16/poller-perf-storage.rrd N:0.00077986717224121[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module netstats #### ICMPSNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m IP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 icmp[0m] End of MIB IPSNMP[[0;36m/usr/bin/snmpget -v1 -c COMMUNITY -OQUs -m IP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 IP-MIB::ipForwDatagrams.0 IP-MIB::ipInDelivers.0 IP-MIB::ipInReceives.0 IP-MIB::ipOutRequests.0 IP-MIB::ipInDiscards.0 IP-MIB::ipOutDiscards.0 IP-MIB::ipOutNoRoutes.0 IP-MIB::ipReasmReqds.0 IP-MIB::ipReasmOKs.0 IP-MIB::ipReasmFails.0 IP-MIB::ipFragOKs.0 IP-MIB::ipFragFails.0 IP-MIB::ipFragCreates.0 IP-MIB::ipInUnknownProtos.0 IP-MIB::ipInHdrErrors.0 IP-MIB::ipInAddrErrors.0[0m] IP-FORWARDSNMP[[0;36m/usr/bin/snmpget -v1 -c COMMUNITY -OQv -M /opt/librenms/mibs udp:HOSTNAME:161 IP-FORWARD-MIB::ipCidrRouteNumber.0[0m] SNMPSNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m SNMPv2-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 snmp[0m] End of MIB TCPSNMP[[0;36m/usr/bin/snmpget -v1 -c COMMUNITY -OQUs -m TCP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 TCP-MIB::tcpActiveOpens.0 TCP-MIB::tcpPassiveOpens.0 TCP-MIB::tcpAttemptFails.0 TCP-MIB::tcpEstabResets.0 TCP-MIB::tcpCurrEstab.0 TCP-MIB::tcpInSegs.0 TCP-MIB::tcpOutSegs.0 TCP-MIB::tcpRetransSegs.0 TCP-MIB::tcpInErrs.0 TCP-MIB::tcpOutRsts.0 tcpHCInSegs.0 tcpHCOutSegs.0[0m] UDPSNMP[[0;36m/usr/bin/snmpget -v1 -c COMMUNITY -OQUs -m UDP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 UDP-MIB::udpInDatagrams.0 UDP-MIB::udpOutDatagrams.0 UDP-MIB::udpInErrors.0 UDP-MIB::udpNoPorts.0[0m] >> Runtime for poller module 'netstats': 0.6971 seconds with 3600 bytes >> SNMP: [6/0.70s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module netstats #### RRD[[0;32mupdate /opt/librenms/rrd/10.1.1.16/poller-perf-netstats.rrd N:0.69708395004272[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module hr-mib #### SNMP[[0;36m/usr/bin/snmpget -v1 -c COMMUNITY -OUQs -m HOST-RESOURCES-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 hrSystemProcesses.0 hrSystemNumUsers.0[0m] >> Runtime for poller module 'hr-mib': 0.0397 seconds with 1584 bytes >> SNMP: [1/0.04s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module hr-mib #### RRD[[0;32mupdate /opt/librenms/rrd/10.1.1.16/poller-perf-hr-mib.rrd N:0.03972601890564[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module ucd-mib #### SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m UCD-SNMP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 systemStats[0m] End of MIB SNMP[[0;36m/usr/bin/snmpget -v1 -c COMMUNITY -OQUs -m UCD-SNMP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 memTotalSwap.0 memAvailSwap.0 memTotalReal.0 memAvailReal.0 memTotalFree.0 memShared.0 memBuffer.0 memCached.0[0m] SNMP[[0;36m/usr/bin/snmpget -v1 -c COMMUNITY -OQUs -m UCD-SNMP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 laLoadInt.1 laLoadInt.2 laLoadInt.3[0m] >> Runtime for poller module 'ucd-mib': 0.2351 seconds with 2760 bytes >> SNMP: [3/0.23s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module ucd-mib #### RRD[[0;32mupdate /opt/librenms/rrd/10.1.1.16/poller-perf-ucd-mib.rrd N:0.23511910438538[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module ipSystemStats #### SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m IP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ipSystemStats[0m] End of MIB >> Runtime for poller module 'ipSystemStats': 0.0390 seconds with 1920 bytes >> SNMP: [1/0.04s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module ipSystemStats #### RRD[[0;32mupdate /opt/librenms/rrd/10.1.1.16/poller-perf-ipSystemStats.rrd N:0.03902792930603[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module ports #### SQL[[1;33mSELECT *, `ports_statistics`.`port_id` AS `ports_statistics_port_id`, `ports`.`port_id` AS `port_id` FROM `ports` LEFT OUTER JOIN `ports_statistics` ON `ports`.`port_id` = `ports_statistics`.`port_id` WHERE `ports`.`device_id` = ? ORDER BY ports.port_id [0;33m[150][0m 1.21ms] Caching Oids: Full ports polling SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m IF-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ifXEntry[0m] End of MIB SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ifEntry[0m] End of MIB dot3StatsDuplexStatusSNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m EtherLike-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 dot3StatsDuplexStatus[0m] End of MIB SQL[[1;33mSELECT COUNT(*) FROM `ports` WHERE `device_id` = ? AND `ifType` in ('adsl','vdsl') [0;33m[150][0m 0.68ms] SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m Q-BRIDGE-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 dot1qPvid[0m] End of MIB Array ( ) >> Runtime for poller module 'ports': 0.1496 seconds with 26440 bytes >> SNMP: [4/0.14s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module ports #### RRD[[0;32mupdate /opt/librenms/rrd/10.1.1.16/poller-perf-ports.rrd N:0.14960908889771[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module bgp-peers #### SQL[[1;33mSELECT * FROM bgpPeers WHERE device_id = ? [0;33m[150][0m 0.4ms] >> Runtime for poller module 'bgp-peers': 0.0019 seconds with 10384 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module bgp-peers #### RRD[[0;32mupdate /opt/librenms/rrd/10.1.1.16/poller-perf-bgp-peers.rrd N:0.0019299983978271[0m] [[0;31mRRD Disabled[0m]Modules status: Global- OS Device Module [ junose-atm-vp ] disabled globally. Modules status: Global- OS Device Module [ toner ] disabled globally. Modules status: Global+ OS Device #### Load poller module ucd-diskio #### SQL[[1;33mSELECT * FROM `ucd_diskio` WHERE `device_id` = ? [0;33m[150][0m 0.25ms] >> Runtime for poller module 'ucd-diskio': 0.0006 seconds with 1824 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module ucd-diskio #### RRD[[0;32mupdate /opt/librenms/rrd/10.1.1.16/poller-perf-ucd-diskio.rrd N:0.00055098533630371[0m] [[0;31mRRD Disabled[0m]Modules status: Global- OS Device Module [ wifi ] disabled globally. Modules status: Global+ OS Device #### Load poller module wireless #### Attempting to initialize OS: generic OS initialized: LibreNMS\OS\Generic SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id` = ? [0;33m[150][0m 0.58ms] >> Runtime for poller module 'wireless': 0.0025 seconds with 101280 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module wireless #### RRD[[0;32mupdate /opt/librenms/rrd/10.1.1.16/poller-perf-wireless.rrd N:0.0025310516357422[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module ospf #### SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[150][0m 0.76ms] Processes: SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m OSPF-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 OSPF-MIB::ospfGeneralGroup[0m] End of MIB Array ( ) SQL[[1;33mdelete from `ospf_instances` where (`device_id` = ? and `context_name` is null) and 1 = 1 [0;33m[150][0m 0.48ms] 0 Areas: SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m OSPF-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 OSPF-MIB::ospfAreaEntry[0m] End of MIB Array ( ) SQL[[1;33mdelete from `ospf_areas` where (`device_id` = ? and `context_name` is null) and 1 = 1 [0;33m[150][0m 0.45ms] 0 Ports: SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m OSPF-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 OSPF-MIB::ospfIfEntry[0m] End of MIB Array ( ) SQL[[1;33mdelete from `ospf_ports` where (`device_id` = ? and `context_name` is null) and 1 = 1 [0;33m[150][0m 0.58ms] 0 Neighbours: SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m OSPF-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 OSPF-MIB::ospfNbrEntry[0m] End of MIB Array ( ) SQL[[1;33mdelete from `ospf_nbrs` where (`device_id` = ? and `context_name` is null) and 1 = 1 [0;33m[150][0m 0.31ms] 0RRD[[0;32mupdate /opt/librenms/rrd/10.1.1.16/ospf-statistics.rrd N:0:0:0:0[0m] [[0;31mRRD Disabled[0m] >> Runtime for poller module 'ospf': 0.1556 seconds with 242632 bytes >> SNMP: [4/0.15s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module ospf #### RRD[[0;32mupdate /opt/librenms/rrd/10.1.1.16/poller-perf-ospf.rrd N:0.15564894676208[0m] [[0;31mRRD Disabled[0m]Modules status: Global- OS Device Module [ cisco-ipsec-flow-monitor ] disabled globally. Modules status: Global- OS Device Module [ cisco-remote-access-monitor ] disabled globally. Modules status: Global- OS Device Module [ cisco-cef ] disabled globally. Modules status: Global- OS Device Module [ cisco-sla ] disabled globally. Modules status: Global- OS Device Module [ cisco-mac-accounting ] disabled globally. Modules status: Global- OS Device Module [ cipsec-tunnels ] disabled globally. Modules status: Global- OS Device Module [ cisco-ace-loadbalancer ] disabled globally. Modules status: Global- OS Device Module [ cisco-ace-serverfarms ] disabled globally. Modules status: Global- OS Device Module [ cisco-asa-firewall ] disabled globally. Modules status: Global- OS Device Module [ cisco-voice ] disabled globally. Modules status: Global- OS Device Module [ cisco-cbqos ] disabled globally. Modules status: Global- OS Device Module [ cisco-otv ] disabled globally. Modules status: Global- OS Device Module [ cisco-vpdn ] disabled globally. Modules status: Global- OS Device Module [ netscaler-vsvr ] disabled globally. Modules status: Global- OS Device Module [ aruba-controller ] disabled globally. Modules status: Global+ OS Device #### Load poller module entity-physical #### SQL[[1;33mSELECT * FROM `entPhysical_state` WHERE `device_id` = ? [0;33m[150][0m 0.22ms] >> Runtime for poller module 'entity-physical': 0.0005 seconds with 1960 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module entity-physical #### RRD[[0;32mupdate /opt/librenms/rrd/10.1.1.16/poller-perf-entity-physical.rrd N:0.00053191184997559[0m] [[0;31mRRD Disabled[0m]Modules status: Global- OS Device Module [ entity-state ] disabled globally. Modules status: Global+ OS Device #### Load poller module applications #### SQL[[1;33mSELECT * FROM `applications` WHERE `device_id` = ? [0;33m[150][0m 0.2ms] >> Runtime for poller module 'applications': 0.0004 seconds with 1512 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module applications #### RRD[[0;32mupdate /opt/librenms/rrd/10.1.1.16/poller-perf-applications.rrd N:0.00039410591125488[0m] [[0;31mRRD Disabled[0m]Modules status: Global- OS Device Module [ mib ] disabled globally. Modules status: Global+ OS Device #### Load poller module stp #### SQL[[1;33mSELECT * FROM `stp` WHERE `device_id` = ? [0;33m[150][0m 0.22ms] SNMP[[0;36m/usr/bin/snmpget -v1 -c COMMUNITY -Oqv -m RSTP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 dot1dStpProtocolSpecification.0[0m] >> Runtime for poller module 'stp': 0.0204 seconds with 5704 bytes >> SNMP: [1/0.02s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module stp #### RRD[[0;32mupdate /opt/librenms/rrd/10.1.1.16/poller-perf-stp.rrd N:0.020350933074951[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module ntp #### >> Runtime for poller module 'ntp': 0.0001 seconds with 320 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module ntp #### RRD[[0;32mupdate /opt/librenms/rrd/10.1.1.16/poller-perf-ntp.rrd N:0.00013303756713867[0m] [[0;31mRRD Disabled[0m]Modules status: Global- OS Device Module [ loadbalancers ] disabled globally. Modules status: Global- OS Device Module [ mef ] disabled globally. ### Start Device Groups ### SQL[[1;33mSELECT * FROM device_groups ORDER BY name [0;33m[][0m 0.47ms] SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.os = "ServersCheck") LIMIT 1 [0;33m[150][0m 0.49ms] SQL[[1;33mSELECT `device_group_id` FROM `device_group_device` WHERE `device_id`=? [0;33m[150][0m 0.19ms] Groups Added: Groups Removed: ### End Device Groups ### RRD[[0;32mupdate /opt/librenms/rrd/10.1.1.16/ping-perf.rrd N:6.05[0m] [[0;31mRRD Disabled[0m]RRD[[0;32mupdate /opt/librenms/rrd/10.1.1.16/poller-perf.rrd N:10.047[0m] [[0;31mRRD Disabled[0m]SQL[[1;33mUPDATE `devices` set `sysObjectID`=?,`sysName`=?,`sysDescr`=?,`last_ping`=NOW(),`last_ping_timetaken`=?,`last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [0;33m[null,"",null,"6.05",10.047,150][0m 59.46ms] Updating 10.1.1.16 Polled in 10.047 seconds #### Start Alerts #### SQL[[1;33mSELECT `device_group_id` FROM `device_group_device` WHERE `device_id`=? [0;33m[150][0m 0.31ms] SQL[[1;33mSELECT 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 = ? ) && ((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(), '[1;33m-[0;35m-%d') AND (end_recurring_dt >= date_format(NOW(), '[1;33m-[0;35m-%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(), '[0;37m'),'%') OR recurring_day is null or recurring_day = ''))) LIMIT 1 [0;33m[150][0m 0.68ms] SQL[[1;33mSELECT DISTINCT a.* FROM alert_rules a LEFT JOIN alert_device_map d ON a.id=d.rule_id LEFT JOIN alert_group_map g ON a.id=g.rule_id LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id WHERE a.disabled = 0 AND ((d.device_id IS NULL AND g.group_id IS NULL) OR d.device_id=? OR dg.device_id=?) [0;33m[150,150][0m 0.3ms] #### End Alerts #### SQL[[1;33mINSERT IGNORE INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`) VALUES (:type,:doing,:start,:duration,:devices,:poller) [0;33m{"type":"poll","doing":"10.1.1.16","start":1535131489.0987,"duration":"10.44","devices":1,"poller":"librenms"}[0m 82.29ms] ./poller.php 10.1.1.16 2018-08-24 10:24:59 - 1 devices polled in 10.44 secs SNMP [23/7.41s]: Get[11/6.99s] Getnext[0/0.00s] Walk[12/0.42s] MySQL [22/1.74s]: Cell[4/0.00s] Row[-3/-0.00s] Rows[13/0.01s] Column[2/0.00s] Update[1/0.06s] Insert[5/1.67s] Delete[0/0.00s] RRD [0/0.00s]: Update[0/0.00s] Create [0/0.00s] Other[0/0.00s]