LibreNMS Poller SQL[select `migration` from `migrations` order by `id` desc limit 1 [] 0.46ms] SQL[select count(*) as aggregate from `migrations` limit 1 [] 0.24ms] SQL[SELECT version() [] 0.3ms] =================================== Version info: Commit SHA: 21192a9cf2a3226e1a06bf69e5688242c5903dfa Commit Date: 1549635449 DB Schema: 2019_01_16_195644_add_vrf_id_and_bgpLocalAs (131) PHP: 5.6.40-0+deb8u1 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 1639 Done Starting polling run: SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'caraaoltvolt.netcomet.com.br' ORDER BY `device_id` ASC [] 1.8ms] SQL[SELECT * FROM devices_attribs WHERE `device_id` = ? [364] 0.48ms] 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.19', 'max' => '12.6', 'avg' => '8.51', '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.19","max":"12.6","avg":"8.51","device_id":364,"debug":"[]"} 5.93ms] 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 = 2560010 .*.*.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: 25600 RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/uptime.rrd N:25600] [RRD Disabled]Uptime: 7h 6m 40s SQL[select * from `locations` where `locations`.`id` = ? limit 1 [72] 4.57ms] >> Runtime for poller module 'core': 6.1122 seconds with 84168 bytes >> SNMP: [2/6.10s] 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.1121559143066] [RRD Disabled] 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.0003 seconds with 280 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.00032901763916016] [RRD Disabled] Modules status: Global+ OS Device #### Load poller module ipmi #### SQL[SELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [364] 1.21ms] array ( ) >> Runtime for poller module 'ipmi': 0.0023 seconds with 1468 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.0022540092468262] [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] 3.24ms] >> Runtime for poller module 'sensors': 0.0038 seconds with 1144 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.0038440227508545] [RRD Disabled]Modules status: Global+ OS Device #### Load poller module processors #### Attempting to initialize OS: serverscheck OS initialized as Generic SQL[SELECT * FROM processors WHERE device_id=? [364] 1.2ms] >> Runtime for poller module 'processors': 0.0069 seconds with 102628 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.0068838596343994] [RRD Disabled] Modules status: Global+ OS Device #### Load poller module mempools #### SQL[SELECT * FROM mempools WHERE device_id = ? [364] 2.36ms] >> Runtime for poller module 'mempools': 0.0031 seconds with 1144 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.0031349658966064] [RRD Disabled]Modules status: Global+ OS Device #### Load poller module storage #### SQL[SELECT * FROM storage WHERE device_id = ? [364] 0.54ms] >> Runtime for poller module 'storage': 0.0013 seconds with 1144 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.0013298988342285] [RRD Disabled] Modules status: Global+ OS Device #### Load poller module netstats #### 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-FORWARDSNMP['/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 SNMP SNMP['/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 TCP SNMP['/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.3667 seconds with 3344 bytes >> SNMP: [6/0.36s] 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.36666679382324] [RRD Disabled] Modules status: Global+ OS Device #### Load poller module hr-mib #### 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': 0.0637 seconds with 736 bytes >> SNMP: [1/0.06s] 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:0.06371808052063] [RRD Disabled] Modules status: Global+ OS Device #### Load poller module ucd-mib #### 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.2449 seconds with 700 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.24485301971436] [RRD Disabled] Modules status: Global+ OS Device #### Load poller module ipSystemStats #### 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.1307 seconds with 760 bytes >> SNMP: [1/0.13s] 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.13070797920227] [RRD Disabled]Modules status: Global+ OS Device #### Load poller module ports #### 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] 3.83ms] 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 dot3StatsDuplexStatus SNMP['/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.63ms] array ( ) >> Runtime for poller module 'ports': 0.6501 seconds with 9556 bytes >> SNMP: [4/0.64s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module ports #### RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-ports.rrd N:0.65005588531494] [RRD Disabled] Modules status: Global+ OS Device #### Load 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.56ms] >> Runtime for poller module 'bgp-peers': 0.0049 seconds with 1788 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module bgp-peers #### RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-bgp-peers.rrd N:0.00494384765625] [RRD Disabled]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[SELECT * FROM `ucd_diskio` WHERE `device_id` = ? [364] 0.3ms] >> Runtime for poller module 'ucd-diskio': 0.0010 seconds with 1156 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module ucd-diskio #### RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-ucd-diskio.rrd N:0.0010039806365967] [RRD Disabled] Modules status: Global- OS Device Module [ wifi ] disabled globally. Modules status: Global+ OS Device #### Load poller module wireless #### Attempting to initialize OS: serverscheck OS initialized as Generic SQL[SELECT * FROM `wireless_sensors` WHERE `device_id` = ? [364] 0.74ms] >> Runtime for poller module 'wireless': 0.0040 seconds with 106292 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.0040290355682373] [RRD Disabled] Modules status: Global+ OS Device #### Load poller module ospf #### SQL[select * from `devices` where `devices`.`device_id` = ? limit 1 [364] 12.4ms] 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 ( ) SQL[delete from `ospf_instances` where (`device_id` = ? and `context_name` is null) and 1 = 1 [364] 2.75ms] 0 >> Runtime for poller module 'ospf': 0.1730 seconds with 274596 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.17296886444092] [RRD Disabled] 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 [ nac ] 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[SELECT * FROM `entPhysical_state` WHERE `device_id` = ? [364] 0.99ms] >> Runtime for poller module 'entity-physical': 0.0023 seconds with 1456 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module entity-physical #### RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-entity-physical.rrd N:0.0022618770599365] [RRD Disabled] Modules status: Global- OS Device Module [ entity-state ] disabled globally. Modules status: Global+ OS Device #### Load poller module applications #### SQL[SELECT * FROM `applications` WHERE `device_id` = ? [364] 7.87ms] >> Runtime for poller module 'applications': 0.0085 seconds with 1156 bytes >> SNMP: [0/0.00s] MySQL: [1/0.01s] RRD: [0/0.00s] #### Unload poller module applications #### RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-applications.rrd N:0.0084829330444336] [RRD Disabled]Modules status: Global- OS Device+ #### Load poller module mib #### SQL[SELECT attrib_value FROM devices_attribs WHERE `device_id` = ? AND `attrib_type` = ? [364,"poll_mib"] 1.62ms] MIB: polling SQL[SELECT `mib`, `module` FROM device_mibs WHERE device_id = ? [364] 4.81ms] >> Runtime for poller module 'mib': 0.0078 seconds with 1320 bytes >> SNMP: [0/0.00s] MySQL: [2/0.01s] RRD: [0/0.00s] #### Unload poller module mib #### RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-mib.rrd N:0.0077769756317139] [RRD Disabled] Modules status: Global+ OS Device #### Load poller module stp #### SQL[SELECT * FROM `stp` WHERE `device_id` = ? [364] 1.88ms] SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Oqv' '-m' 'RSTP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:1161' 'dot1dStpProtocolSpecification.0'] No Such Object available on this agent at this OID >> Runtime for poller module 'stp': 0.0877 seconds with 1632 bytes >> SNMP: [1/0.08s] 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.087736845016479] [RRD Disabled] Modules status: Global+ OS Device #### Load poller module ntp #### >> Runtime for poller module 'ntp': 0.0004 seconds with 228 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.00037503242492676] [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.65ms] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.hostname REGEXP "caraa") LIMIT 1 [364] 0.76ms] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.hostname REGEXP "energia" ) LIMIT 1 [364] 0.63ms] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.hostname REGEXP "rolante" ) LIMIT 1 [364] 0.36ms] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.hostname REGEXP "sap") LIMIT 1 [364] 0.38ms] SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`=? [364] 3.69ms] Groups Added: Groups Removed: ### End Device Groups ### Enabling graphs: SQL[SELECT `graph` FROM `device_graphs` WHERE `device_id` = ? [364] 3.99ms] uptime RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/ping-perf.rrd N:8.51] [RRD Disabled] RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf.rrd N:9.035] [RRD Disabled] SQL[UPDATE `devices` set `uptime`=?,`last_ping`=NOW(),`last_ping_timetaken`=?,`last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [25600,"8.51",9.035,364] 14.79ms] Updating caraaoltvolt.netcomet.com.br Polled in 9.035 seconds #### Start Alerts #### SQL[select * from `devices` where `devices`.`device_id` = ? limit 1 [364] 1.23ms] 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.81ms] 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] 1.76ms] 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] 7.51ms] 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.85ms] SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [1,364] 0.41ms] Status: NOCHG Rule #2 (Sensor Acima 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 && 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" )) /opt/librenms/includes/alerts.inc.php:184 /opt/librenms/poller.php:162 SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [2,364] 0.45ms] 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" )) /opt/librenms/includes/alerts.inc.php:184 /opt/librenms/poller.php:162 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":1550931041.9767,"duration":"10.67","devices":1,"poller":"nms"} 22.35ms] /opt/librenms/poller.php caraaoltvolt.netcomet.com.br 2019-02-23 11:10:52 - 1 devices polled in 10.67 secs SNMP [20/7.81s]: Get[11/6.51s] Getnext[0/0.00s] Walk[9/1.29s] MySQL [23/0.10s]: Cell[9/0.01s] Row[-7/-0.01s] Rows[17/0.05s] Column[1/0.00s] Update[1/0.02s] Insert[2/0.03s] Delete[0/0.00s] RRD [0/0.00s]: Update[0/0.00s] Create [0/0.00s] Other[0/0.00s]