LibreNMS Poller SQL[select `migration` from `migrations` order by `id` desc limit 1 [] 0.42ms] SQL[select count(*) as aggregate from `migrations` limit 1 [] 0.32ms] SQL[SELECT version() [] 0.39ms] =================================== Version info: Commit SHA: 96797aa813c3d183db80aedde7e4b49277379e4c Commit Date: 1553095069 DB Schema: 2019_02_10_220000_add_dates_to_fdb (132) PHP: 7.3.3-1+0~20190307202445.32+jessie~1.gbp32ebb2 MySQL: 10.0.38-MariaDB-0+deb8u1 RRDTool: 1.4.8 SNMP: NET-SNMP 5.7.2.1 ==================================DEBUG! Updating os_def.cache... Warning: file_put_contents(/opt/librenms/cache/os_defs.cache): failed to open stream: Permission denied in /opt/librenms/includes/common.php on line 1640 Done Starting polling run: SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'caraaoltvolt.netcomet.com.br' ORDER BY `device_id` ASC [] 1.5ms] SQL[SELECT * FROM devices_attribs WHERE `device_id` = ? [364] 0.41ms] Hostname: caraaoltvolt.netcomet.com.br Device ID: 364 OS: serverscheck [FPING] /usr/bin/fping -e -q -c 3 -p 500 -t 500 caraaoltvolt.netcomet.com.br array ( 'xmt' => '3', 'rcv' => '3', 'loss' => '0', 'min' => '4.75', 'max' => '10.4', 'avg' => '7.37', 'exitcode' => 0, ) SQL[INSERT IGNORE INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`,`debug`) VALUES (:xmt,:rcv,:loss,:min,:max,:avg,:device_id,NOW(),:debug) {"xmt":"3","rcv":"3","loss":"0","min":"4.75","max":"10.4","avg":"7.37","device_id":364,"debug":"[]"} 9.37ms] SNMP Check response code: 0 Modules status: Global+ OS Device #### Load poller module core #### SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQnUt' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:1161' 'sysUpTime.0' 'sysLocation.0' 'sysContact.0' 'sysName.0' 'sysObjectID.0' 'sysDescr.0'] .*.*.0 = 9579072 .*.*.0 = Brazil .*.*.0 = Volt .*.*.0 = Pop Protect SNMP .*.*.0 = .*.4.1.17095.1 .*.*.0 = Alarme SNMP SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQnUst' '-m' 'HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:1161' 'snmpEngineTime.0' 'hrSystemUptime.0'] Timeout: No Response from udp:caraaoltvolt.netcomet.com.br:1161. Uptime seconds: 95791 RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/uptime.rrd N:95791] [RRD Disabled] Uptime: 1day 2 hours 36 minutes 31 seconds SQL[select * from `locations` where `locations`.`id` = ? limit 1 [72] 0.66ms] >> Runtime for poller module 'core': 6.1003 seconds with 49824 bytes >> SNMP: [2/6.09s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module core #### RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-core.rrd N:6.1003041267395] [RRD Disabled] Modules status: Global- OS Module [ unix-agent ] disabled globally. Device #### Load poller module os #### Modules status: Global+ OS Device Generic :( Hardware: Version: Features: Serial: >> Runtime for poller module 'os': 0.0019 seconds with 44128 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module os #### RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-os.rrd N:0.0018720626831055] [RRD Disabled] Modules status: Global+ OS Device #### Load poller module ipmi #### SQL[SELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [364] 0.76ms] array ( ) >> Runtime for poller module 'ipmi': 0.0015 seconds with 2288 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module ipmi #### RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-ipmi.rrd N:0.0014638900756836] [RRD Disabled] Modules status: Global+ OS Device #### Load poller module sensors #### SQL[SELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [364] 0.57ms] >> Runtime for poller module 'sensors': 0.0010 seconds with 1256 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module sensors #### RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-sensors.rrd N:0.00095915794372559] [RRD Disabled] Modules status: Global+ OS #### Load poller module processors #### Device Attempting to initialize OS: serverscheck OS initialized as Generic SQL[SELECT * FROM processors WHERE device_id=? [364] 0.67ms] >> Runtime for poller module 'processors': 0.0037 seconds with 143472 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module processors #### RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-processors.rrd N:0.0036590099334717] [RRD Disabled] Modules status: Global+ OS #### Load poller module mempools #### Device SQL[SELECT * FROM mempools WHERE device_id = ? [364] 0.47ms] >> Runtime for poller module 'mempools': 0.0009 seconds with 1568 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module mempools #### RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-mempools.rrd N:0.00087404251098633] [RRD Disabled] Modules status: Global+ OS Device #### Load poller module storage #### SQL[SELECT * FROM storage WHERE device_id = ? [364] 0.42ms] >> Runtime for poller module 'storage': 0.0008 seconds with 1528 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module storage #### RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-storage.rrd N:0.00076007843017578] [RRD Disabled] Modules status: Global+ OS #### Load poller module netstats #### Device ICMP SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:1161' 'icmp'] icmp.0 = No Such Object available on this agent at this OID IP SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:1161' "" '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'] : Unknown Object Identifier (Sub-id not found: (top) -> ) IP-FORWARD SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQv' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:1161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0'] No Such Object available on this agent at this OID SNMPSNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:1161' 'snmp'] snmp.0 = No Such Object available on this agent at this OID TCPSNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'TCP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:1161' "" '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'] : Unknown Object Identifier (Sub-id not found: (top) -> ) UDP SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UDP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:1161' "" 'UDP-MIB::udpInDatagrams.0' 'UDP-MIB::udpOutDatagrams.0' 'UDP-MIB::udpInErrors.0' 'UDP-MIB::udpNoPorts.0'] : Unknown Object Identifier (Sub-id not found: (top) -> ) >> Runtime for poller module 'netstats': 0.3988 seconds with 3456 bytes >> SNMP: [6/0.40s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module netstats #### RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-netstats.rrd N:0.39876198768616] [RRD Disabled] Modules status: Global+ OS #### Load poller module hr-mib #### Device SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQs' '-m' 'HOST-RESOURCES-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:1161' 'hrSystemProcesses.0' 'hrSystemNumUsers.0'] hrSystemProcesses.0.0 = No Such Object available on this agent at this OID hrSystemNumUsers.0.0 = No Such Object available on this agent at this OID >> Runtime for poller module 'hr-mib': 1.0382 seconds with 1224 bytes >> SNMP: [1/1.04s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module hr-mib #### RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-hr-mib.rrd N:1.038211107254] [RRD Disabled] Modules status: Global+ OS #### Load poller module ucd-mib #### Device SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:1161' 'systemStats'] systemStats.0 = No Such Object available on this agent at this OID SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:1161' 'memTotalSwap.0' 'memAvailSwap.0' 'memTotalReal.0' 'memAvailReal.0' 'memTotalFree.0' 'memShared.0' 'memBuffer.0' 'memCached.0'] memTotalSwap.0.0 = No Such Object available on this agent at this OID memAvailSwap.0.0 = No Such Object available on this agent at this OID memTotalReal.0.0 = No Such Object available on this agent at this OID memAvailReal.0.0 = No Such Object available on this agent at this OID memTotalFree.0.0 = No Such Object available on this agent at this OID memShared.0.0 = No Such Object available on this agent at this OID memBuffer.0.0 = No Such Object available on this agent at this OID memCached.0.0 = No Such Object available on this agent at this OID SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:1161' 'laLoadInt.1' 'laLoadInt.2' 'laLoadInt.3'] laLoadInt.1.0 = No Such Object available on this agent at this OID laLoadInt.2.0 = No Such Object available on this agent at this OID laLoadInt.3.0 = No Such Object available on this agent at this OID >> Runtime for poller module 'ucd-mib': 0.2410 seconds with 2000 bytes >> SNMP: [3/0.24s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module ucd-mib #### RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-ucd-mib.rrd N:0.241042137146] [RRD Disabled] Modules status: Global+ OS #### Load poller module ipSystemStats #### Device SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:1161' 'ipSystemStats'] ipSystemStatsTable.0 = No Such Object available on this agent at this OID >> Runtime for poller module 'ipSystemStats': 0.1254 seconds with 1576 bytes >> SNMP: [1/0.12s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module ipSystemStats #### RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-ipSystemStats.rrd N:0.12536001205444] [RRD Disabled] Modules status: Global+ OS #### Load poller module ports #### Device SQL[SELECT *, `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 [364] 1.53ms] Caching Oids: Full ports polling SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:1161' 'ifXEntry'] ifXEntry.0 = No Such Object available on this agent at this OID SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:1161' 'ifEntry'] ifEntry.0 = No Such Object available on this agent at this OID dot3StatsDuplexStatusSNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:1161' 'dot3StatsDuplexStatus'] dot3StatsDuplexStatus.0 = No Such Object available on this agent at this OID SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:1161' 'dot1qPvid'] dot1qPvid.0 = No Such Object available on this agent at this OID SQL[SELECT COUNT(*) FROM `ports` WHERE `device_id` = ? AND `ifType` in ('adsl','vdsl') [364] 1.12ms] >> Runtime for poller module 'ports': 0.5448 seconds with 21016 bytes >> SNMP: [4/0.54s] MySQL: [1/0.00s] RRD: [0/0.00s] array ( ) #### Unload poller module ports #### RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-ports.rrd N:0.54478311538696] [RRD Disabled] Modules status: Global+ OS #### Load poller module bgp-peers #### Device >> Runtime for poller module 'bgp-peers': 0.0021 seconds with 9616 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module bgp-peers #### SQL[SELECT * FROM `bgpPeers` AS B LEFT JOIN `vrfs` AS V ON `B`.`vrf_id` = `V`.`vrf_id` WHERE `B`.`device_id` = ? [364] 0.36ms] RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-bgp-peers.rrd N:0.0021300315856934] [RRD Disabled]Module [ junose-atm-vp ] disabled globally. Modules status: Global- OS Device Modules status: Global- OS Device Module [ toner ] disabled globally. #### Load poller module ucd-diskio #### Modules status: Global+ OS Device >> Runtime for poller module 'ucd-diskio': 0.0009 seconds with 1608 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module ucd-diskio #### SQL[SELECT * FROM `ucd_diskio` WHERE `device_id` = ? [364] 0.49ms] RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-ucd-diskio.rrd N:0.00086688995361328] [RRD Disabled]Module [ wifi ] disabled globally. Modules status: Global- OS Device #### Load poller module wireless #### Modules status: Global+ OS Device Attempting to initialize OS: serverscheck OS initialized as Generic SQL[SELECT * FROM `wireless_sensors` WHERE `device_id` = ? [364] 0.57ms] >> Runtime for poller module 'wireless': 0.0026 seconds with 83552 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module wireless #### RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-wireless.rrd N:0.0025980472564697] [RRD Disabled] Modules status: Global+ OS #### Load poller module ospf #### Device SQL[select * from `devices` where `devices`.`device_id` = ? limit 1 [364] 0.6ms] Processes: SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'OSPF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:1161' 'OSPF-MIB::ospfGeneralGroup'] ospfGeneralGroup.0 = No Such Object available on this agent at this OID array ( ) 0 >> Runtime for poller module 'ospf': 0.1498 seconds with 141312 bytes >> SNMP: [1/0.14s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module ospf #### RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-ospf.rrd N:0.14979100227356] [RRD Disabled] SQL[delete from `ospf_instances` where (`device_id` = ? and `context_name` is null) and 1 = 1 [364] 0.47ms] Modules status: Global- Module [ cisco-ipsec-flow-monitor ] disabled globally. OS Device Modules status: Global- OS Module [ cisco-remote-access-monitor ] disabled globally. Device Modules status: Global- OS Module [ cisco-cef ] disabled globally. Device Modules status: Global- OS Device Module [ cisco-sla ] disabled globally. Modules status: Global- OS Module [ cisco-mac-accounting ] disabled globally. Device Modules status: Global- OS Device Module [ cipsec-tunnels ] disabled globally. Modules status: Global- OS Module [ cisco-ace-loadbalancer ] disabled globally. Device Modules status: Global- OS Module [ cisco-ace-serverfarms ] disabled globally. Device Modules status: Global- OS Device Module [ cisco-asa-firewall ] disabled globally. Modules status: Global- OS Module [ cisco-voice ] disabled globally. Device Modules status: Global- OS Module [ cisco-cbqos ] disabled globally. Device Modules status: Global- OS Module [ cisco-otv ] disabled globally. Device Modules status: Global- OS Module [ cisco-vpdn ] disabled globally. Device Modules status: Global- OS Module [ nac ] disabled globally. Module [ netscaler-vsvr ] disabled globally. Module [ aruba-controller ] disabled globally. #### Load poller module entity-physical #### Device Modules status: Global- OS Device Modules status: Global- OS Device Modules status: Global+ OS Device >> Runtime for poller module 'entity-physical': 0.0011 seconds with 1760 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] SQL[SELECT * FROM `entPhysical_state` WHERE `device_id` = ? [364] 0.46ms] #### Unload poller module entity-physical #### RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-entity-physical.rrd N:0.0011429786682129] [RRD Disabled] Module [ entity-state ] disabled globally. #### Load poller module applications #### >> Runtime for poller module 'applications': 0.0006 seconds with 1368 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module applications #### RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-applications.rrd N:0.00062417984008789] [RRD Disabled] #### Load poller module mib #### MIB: polling >> Runtime for poller module 'mib': 0.0011 seconds with 1064 bytes >> SNMP: [0/0.00s] MySQL: [2/0.00s] RRD: [0/0.00s] #### Unload poller module mib #### RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-mib.rrd N:0.0010931491851807] [RRD Disabled] #### Load poller module stp #### SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Oqv' '-m' 'RSTP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:1161' 'dot1dStpProtocolSpecification.0'] Modules status: Global- OS Device Modules status: Global+ OS Device SQL[SELECT * FROM `applications` WHERE `device_id` = ? [364] 0.34ms] Modules status: Global- OS Device+ SQL[SELECT attrib_value FROM devices_attribs WHERE `device_id` = ? AND `attrib_type` = ? [364,"poll_mib"] 0.26ms] SQL[SELECT `mib`, `module` FROM device_mibs WHERE device_id = ? [364] 0.26ms] Modules status: Global+ OS Device SQL[SELECT * FROM `stp` WHERE `device_id` = ? [364] 0.3ms] No Such Object available on this agent at this OID >> Runtime for poller module 'stp': 0.0508 seconds with 4656 bytes >> SNMP: [1/0.05s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module stp #### RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-stp.rrd N:0.050826072692871] [RRD Disabled] Modules status: Global+ OS Device #### Load poller module ntp #### >> Runtime for poller module 'ntp': 0.0003 seconds with 328 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module ntp #### RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-ntp.rrd N:0.00027298927307129] [RRD Disabled] Modules status: Global- OS Device Module [ loadbalancers ] disabled globally. Modules status: Global- OS Device Module [ mef ] disabled globally. ### Start Device Groups ### SQL[SELECT * FROM device_groups ORDER BY name [] 0.38ms] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.hostname REGEXP "caraa") LIMIT 1 [364] 0.84ms] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.hostname REGEXP "energia" ) LIMIT 1 [364] 0.39ms] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.hostname REGEXP "rolante" ) LIMIT 1 [364] 0.46ms] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.hostname REGEXP "sap") LIMIT 1 [364] 0.42ms] SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`=? [364] 0.24ms] Groups Added: Groups Removed: ### End Device Groups ### Enabling graphs: SQL[SELECT `graph` FROM `device_graphs` WHERE `device_id` = ? [364] 0.35ms] uptime RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/ping-perf.rrd N:7.37] [RRD Disabled] RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf.rrd N:9.748] [RRD Disabled] SQL[UPDATE `devices` set `uptime`=?,`last_ping`=NOW(),`last_ping_timetaken`=?,`last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [95791,"7.37",9.748,364] 4.53ms] Updating caraaoltvolt.netcomet.com.br Polled in 9.748 seconds #### Start Alerts #### SQL[select * from `devices` where `devices`.`device_id` = ? limit 1 [364] 0.66ms] SQL[select `device_groups`.*, `device_group_device`.`device_id` as `pivot_device_id`, `device_group_device`.`device_group_id` as `pivot_device_group_id` from `device_groups` inner join `device_group_device` on `device_groups`.`id` = `device_group_device`.`device_group_id` where `device_group_device`.`device_id` = ? [364] 0.38ms] SQL[select exists(select * from `alert_schedule` inner join `alert_schedulables` on `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` where ((`recurring` = ? and `start` <= NOW() and `end` >= NOW()) or (`recurring` = ? and (`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` = ? or `end_recurring_dt` = ?)) and `start_recurring_hr` <= date_format(NOW(), '%H:%i:%s') and `end_recurring_hr` >= date_format(NOW(), '%H:%i:%s') and (`recurring_day` like CONCAT('%', date_format(NOW(), ''), '%') or `recurring_day` is null or `recurring_day` = ?))) and ((`alert_schedulable_type` = ? and `alert_schedulable_id` = ?) or (`alert_schedulable_type` = ? and `alert_schedulable_id` in (?)))) as `exists` [0,1,"0000-00-00","","","device",364,"device_group",1] 0.98ms] SQL[SELECT 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=?) [364,364] 0.46ms] Rule #1 (Falha no Equipamento): SQL[SELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [364] 0.57ms] Status: NOCHG Rule #2 (Sensor Acima do Limite): SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [1,364] 1.86ms] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Sensors.sensor_current' in 'where clause' (SQL: SELECT * FROM sensors,devices WHERE (( devices.device_id = sensors.device_id ) && sensors.device_id = 364) && (Sensors.sensor_current > sensors.sensor_limit && sensors.sensor_alert = "1" && ((devices.status = 1 && ((devices.disabled = 0 && devices.ignore = 0)))) = "1" )) (SQL: SELECT * FROM sensors,devices WHERE (( devices.device_id = sensors.device_id ) && sensors.device_id = 364) && (Sensors.sensor_current > sensors.sensor_limit && sensors.sensor_alert = "1" && ((devices.status = 1 && ((devices.disabled = 0 && devices.ignore = 0)))) = "1" ))#0 /opt/librenms/includes/alerts.inc.php(187): dbFetchRows('SELECT * FROM s...', Array) #1 /opt/librenms/poller.php(162): RunRules(364) #2 {main} SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [2,364] 0.25ms] Status: NOCHG Rule #3 (Corrente abaixo do limite): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Sensors.sensor_current' in 'where clause' (SQL: SELECT * FROM sensors,devices WHERE (( devices.device_id = sensors.device_id ) && sensors.device_id = 364) && (Sensors.sensor_current < sensors.sensor_limit_low = "" && sensors.sensor_alert = "1" && ((devices.status = 1 && ((devices.disabled = 0 && devices.ignore = 0)))) = "1" )) (SQL: SELECT * FROM sensors,devices WHERE (( devices.device_id = sensors.device_id ) && sensors.device_id = 364) && (Sensors.sensor_current < sensors.sensor_limit_low = "" && sensors.sensor_alert = "1" && ((devices.status = 1 && ((devices.disabled = 0 && devices.ignore = 0)))) = "1" ))#0 /opt/librenms/includes/alerts.inc.php(187): dbFetchRows('SELECT * FROM s...', Array) #1 /opt/librenms/poller.php(162): RunRules(364) #2 {main} SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [3,364] 0.31ms] Status: NOCHG #### End Alerts #### SQL[INSERT IGNORE INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`) VALUES (:type,:doing,:start,:duration,:devices,:poller) {"type":"poll","doing":"caraaoltvolt.netcomet.com.br","start":1553217912.413632,"duration":"10.08","devices":1,"poller":"nms"} 4.19ms] SNMP [20/8.64s]: Get[11/7.42s] Getnext[0/0.00s] Walk[9/1.22s] MySQL [23/0.04s]: Cell[9/0.01s] Row[-7/-0.01s] Rows[17/0.02s] Column[1/0.00s] Update[1/0.01s] Insert[2/0.01s] Delete[0/0.00s] RRD [0/0.00s]: Update[0/0.00s] Create [0/0.00s] Other[0/0.00s] /opt/librenms/poller.php caraaoltvolt.netcomet.com.br 2019-03-22 01:25:22 - 1 devices polled in 10.08 secs