SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.95ms] SQL[[1;33mselect count(*) as aggregate from `migrations` [0;33m[][0m 0.77ms] SQL[[1;33mselect version() [0;33m[][0m 0.39ms] =========================================== Component | Version --------- | ------- LibreNMS | 24.5.0-96-ge5d00a2d22 (2024-06-11T00:19:04-03:00) DB Schema | 2024_08_27_182000_ports_statistics_table_rev_length (299) PHP | 8.2.26 Python | 3.11.2 Database | MariaDB 10.11.6-MariaDB-0+deb12u1 RRDTool | 1.7.2 SNMP | 5.9.3 =========================================== Updating os_def.cache Starting polling run: SQL[[1;33mselect `device_id` from `devices` where `hostname` = ? [0;33m["10.40.11.15"][0m 0.45ms] SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[337][0m 0.42ms] Hostname: 10.40.11.15 (deepsea) ID: 337 OS: deepsea-gensets IP: 10.40.11.15 Attempting to initialize OS: deepsea-gensets Attempting to initialize Group OS: deepsea OS initialized as Generic (deepsea-gensets) SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[337][0m 0.34ms] [FPING] '/usr/bin/fping' '-e' '-q' '-c' '5' '-p' '300' '-t' '300' '-O' '0' '10.40.11.15' response: 10.40.11.15 : xmt/rcv/%loss = 5/5/0%, min/avg/max = 0.459/0.5/0.589 SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/deepsea-gensets' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-Pu' '-t' '3' '-r' '2' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysObjectID.0'[0m] SNMPv2-MIB::sysObjectID.0 = SNMPv2-SMI::enterprises.41385.1.4 SQL[[1;33mupdate `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? [0;33m["2024-12-26 13:44:11",0.5,337][0m 1.32ms] RRD[[0;32mlast 10.40.11.15/icmp-perf.rrd --daemon unix:/run/rrdcached.sock[0m] RRD[[0;32mupdate 10.40.11.15/icmp-perf.rrd N:0.5:5:5:0.459:0.589 --daemon unix:/run/rrdcached.sock[0m] SQL[[1;33mselect * from `device_outages` where `device_outages`.`device_id` = ? and `device_outages`.`device_id` is not null and `up_again` is null order by `going_down` desc limit 1 [0;33m[337][0m 1.01ms] #### Load poller module core #### Module enabled: Global + | OS | Device | Manual SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/deepsea-gensets' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-Pu' '-On' '-t' '3' '-r' '2' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysUpTime.0'[0m] .*.*.0 = 267682781 SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/deepsea-gensets' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-Pu' '-t' '3' '-r' '2' 'udp:HOSTNAME:161' 'SNMP-FRAMEWORK-MIB::snmpEngineTime.0' 'HOST-RESOURCES-MIB::hrSystemUptime.0'[0m] Exitcode: 2 ["Error in packet Reason: (genError) A general failure occured "] Error in packet Reason: (genError) A general failure occured Uptime seconds: 2676828 RRD[[0;32mlast 10.40.11.15/uptime.rrd --daemon unix:/run/rrdcached.sock[0m] RRD[[0;32mupdate 10.40.11.15/uptime.rrd N:2676828 --daemon unix:/run/rrdcached.sock[0m] Uptime: 1 month 2 days 23 hours 33 minutes 48 seconds SQL[[1;33mupdate `devices` set `uptime` = ? where `device_id` = ? [0;33m[2676828,337][0m 1.31ms] >> [0;36mSNMP[0m: [3/0.08s] [1;33mMySQL[0m: [4/0.04s] [0;32mRRD[0m: [4/0.00s] >> Runtime for poller module 'core': 0.0523 seconds with 120896 bytes RRD[[0;32mlast 10.40.11.15/poller-perf-core.rrd --daemon unix:/run/rrdcached.sock[0m] RRD[[0;32mupdate 10.40.11.15/poller-perf-core.rrd N:0.052280902862549 --daemon unix:/run/rrdcached.sock[0m] #### Unload poller module core #### #### Load poller module os #### Module enabled: Global + | OS | Device | Manual Location: Hardware: OS Version: OS Features: Serial: >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [2/0.00s] >> Runtime for poller module 'os': 0.0069 seconds with 118160 bytes RRD[[0;32mlast 10.40.11.15/poller-perf-os.rrd --daemon unix:/run/rrdcached.sock[0m] RRD[[0;32mupdate 10.40.11.15/poller-perf-os.rrd N:0.0068850517272949 --daemon unix:/run/rrdcached.sock[0m] #### Unload poller module os #### #### Load poller module ipmi #### Module enabled: Global + | OS | Device | Manual SQL[[1;33mSELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [0;33m[337][0m 0.87ms] array ( ) >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] [0;32mRRD[0m: [2/0.00s] >> Runtime for poller module 'ipmi': 0.0034 seconds with 160816 bytes RRD[[0;32mlast 10.40.11.15/poller-perf-ipmi.rrd --daemon unix:/run/rrdcached.sock[0m] RRD[[0;32mupdate 10.40.11.15/poller-perf-ipmi.rrd N:0.0033900737762451 --daemon unix:/run/rrdcached.sock[0m] #### Unload poller module ipmi #### #### Load poller module sensors #### Module enabled: Global + | OS | Device | Manual SQL[[1;33mSELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [0;33m[337][0m 0.76ms] >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] [0;32mRRD[0m: [2/0.00s] >> Runtime for poller module 'sensors': 0.0015 seconds with 8640 bytes RRD[[0;32mlast 10.40.11.15/poller-perf-sensors.rrd --daemon unix:/run/rrdcached.sock[0m] RRD[[0;32mupdate 10.40.11.15/poller-perf-sensors.rrd N:0.00154709815979 --daemon unix:/run/rrdcached.sock[0m] #### Unload poller module sensors #### #### Load poller module processors #### Module enabled: Global + | OS | Device | Manual Attempting to initialize OS: deepsea-gensets Attempting to initialize Group OS: deepsea OS initialized as Generic (deepsea-gensets) SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[337][0m 0.58ms] >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] [0;32mRRD[0m: [2/0.00s] >> Runtime for poller module 'processors': 0.0021 seconds with 62328 bytes RRD[[0;32mlast 10.40.11.15/poller-perf-processors.rrd --daemon unix:/run/rrdcached.sock[0m] RRD[[0;32mupdate 10.40.11.15/poller-perf-processors.rrd N:0.0021088123321533 --daemon unix:/run/rrdcached.sock[0m] #### Unload poller module processors #### #### Load poller module mempools #### Module enabled: Global + | OS | Device | Manual SQL[[1;33mselect * from `mempools` where `mempools`.`device_id` = ? and `mempools`.`device_id` is not null [0;33m[337][0m 0.59ms] >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] [0;32mRRD[0m: [2/0.00s] >> Runtime for poller module 'mempools': 0.0020 seconds with 83808 bytes RRD[[0;32mlast 10.40.11.15/poller-perf-mempools.rrd --daemon unix:/run/rrdcached.sock[0m] RRD[[0;32mupdate 10.40.11.15/poller-perf-mempools.rrd N:0.0020499229431152 --daemon unix:/run/rrdcached.sock[0m] #### Unload poller module mempools #### #### Load poller module storage #### Module enabled: Global + | OS | Device | Manual SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[337][0m 0.62ms] >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] [0;32mRRD[0m: [2/0.00s] >> Runtime for poller module 'storage': 0.0012 seconds with 3352 bytes RRD[[0;32mlast 10.40.11.15/poller-perf-storage.rrd --daemon unix:/run/rrdcached.sock[0m] RRD[[0;32mupdate 10.40.11.15/poller-perf-storage.rrd N:0.0011742115020752 --daemon unix:/run/rrdcached.sock[0m] #### Unload poller module storage #### #### Load poller module netstats #### Module enabled: Global + | OS | Device | Manual icmp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/deepsea-gensets' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-Pu' '-t' '3' '-r' '2' 'udp:HOSTNAME:161' 'IP-MIB::icmpInMsgs.0' 'IP-MIB::icmpOutMsgs.0' 'IP-MIB::icmpInErrors.0' 'IP-MIB::icmpOutErrors.0' 'IP-MIB::icmpInEchos.0' 'IP-MIB::icmpOutEchos.0' 'IP-MIB::icmpInEchoReps.0' 'IP-MIB::icmpOutEchoReps.0' 'IP-MIB::icmpInDestUnreachs.0' 'IP-MIB::icmpOutDestUnreachs.0'[0m] Exitcode: 1 ["Timeout: No Response from udp:10.40.11.15:161. "] Timeout: No Response from udp:10.40.11.15:161. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/deepsea-gensets' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-Pu' '-t' '3' '-r' '2' 'udp:HOSTNAME:161' 'IP-MIB::icmpInParmProbs.0' 'IP-MIB::icmpInTimeExcds.0' 'IP-MIB::icmpInSrcQuenchs.0' 'IP-MIB::icmpInRedirects.0' 'IP-MIB::icmpInTimestamps.0' 'IP-MIB::icmpInTimestampReps.0' 'IP-MIB::icmpInAddrMasks.0' 'IP-MIB::icmpInAddrMaskReps.0' 'IP-MIB::icmpOutTimeExcds.0' 'IP-MIB::icmpOutParmProbs.0'[0m] Exitcode: 1 ["Timeout: No Response from udp:10.40.11.15:161. "] Timeout: No Response from udp:10.40.11.15:161. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/deepsea-gensets' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-Pu' '-t' '3' '-r' '2' 'udp:HOSTNAME:161' 'IP-MIB::icmpOutSrcQuenchs.0' 'IP-MIB::icmpOutRedirects.0' 'IP-MIB::icmpOutTimestamps.0' 'IP-MIB::icmpOutTimestampReps.0' 'IP-MIB::icmpOutAddrMasks.0' 'IP-MIB::icmpOutAddrMaskReps.0'[0m] IP-MIB::icmpOutSrcQuenchs.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutRedirects.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutTimestamps.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutTimestampReps.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutAddrMasks.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutAddrMaskReps.0 = No Such Object available on this agent at this OID ip SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/deepsea-gensets' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-Pu' '-t' '3' '-r' '2' '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'[0m] Exitcode: 1 ["Timeout: No Response from udp:10.40.11.15:161. "] Timeout: No Response from udp:10.40.11.15:161. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/deepsea-gensets' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-Pu' '-t' '3' '-r' '2' 'udp:HOSTNAME:161' '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-MIB::ipFragOKs.0 = No Such Object available on this agent at this OID IP-MIB::ipFragFails.0 = No Such Object available on this agent at this OID IP-MIB::ipFragCreates.0 = No Such Object available on this agent at this OID IP-MIB::ipInUnknownProtos.0 = No Such Object available on this agent at this OID IP-MIB::ipInHdrErrors.0 = No Such Object available on this agent at this OID IP-MIB::ipInAddrErrors.0 = No Such Object available on this agent at this OID ip_forward SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/deepsea-gensets' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-Pu' '-t' '3' '-r' '2' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0'[0m] IP-FORWARD-MIB::ipCidrRouteNumber.0 = No Such Object available on this agent at this OID snmp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/deepsea-gensets' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-Pu' '-t' '3' '-r' '2' 'udp:HOSTNAME:161' 'SNMPv2-MIB::snmpInPkts.0' 'SNMPv2-MIB::snmpOutPkts.0' 'SNMPv2-MIB::snmpInBadVersions.0' 'SNMPv2-MIB::snmpInBadCommunityNames.0' 'SNMPv2-MIB::snmpInBadCommunityUses.0' 'SNMPv2-MIB::snmpInASNParseErrs.0' 'SNMPv2-MIB::snmpInTooBigs.0' 'SNMPv2-MIB::snmpInNoSuchNames.0' 'SNMPv2-MIB::snmpInBadValues.0' 'SNMPv2-MIB::snmpInReadOnlys.0'[0m] Exitcode: 1 ["Timeout: No Response from udp:10.40.11.15:161. "] Timeout: No Response from udp:10.40.11.15:161. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/deepsea-gensets' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-Pu' '-t' '3' '-r' '2' 'udp:HOSTNAME:161' 'SNMPv2-MIB::snmpInGenErrs.0' 'SNMPv2-MIB::snmpInTotalReqVars.0' 'SNMPv2-MIB::snmpInTotalSetVars.0' 'SNMPv2-MIB::snmpInGetRequests.0' 'SNMPv2-MIB::snmpInGetNexts.0' 'SNMPv2-MIB::snmpInSetRequests.0' 'SNMPv2-MIB::snmpInGetResponses.0' 'SNMPv2-MIB::snmpInTraps.0' 'SNMPv2-MIB::snmpOutTooBigs.0' 'SNMPv2-MIB::snmpOutNoSuchNames.0'[0m] Exitcode: 1 ["Timeout: No Response from udp:10.40.11.15:161. "] Timeout: No Response from udp:10.40.11.15:161. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/deepsea-gensets' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-Pu' '-t' '3' '-r' '2' 'udp:HOSTNAME:161' 'SNMPv2-MIB::snmpOutBadValues.0' 'SNMPv2-MIB::snmpOutGenErrs.0' 'SNMPv2-MIB::snmpOutGetRequests.0' 'SNMPv2-MIB::snmpOutGetNexts.0' 'SNMPv2-MIB::snmpOutSetRequests.0' 'SNMPv2-MIB::snmpOutGetResponses.0' 'SNMPv2-MIB::snmpOutTraps.0' 'SNMPv2-MIB::snmpSilentDrops.0' 'SNMPv2-MIB::snmpProxyDrops.0'[0m] Exitcode: 1 ["Timeout: No Response from udp:10.40.11.15:161. "] Timeout: No Response from udp:10.40.11.15:161. udp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/deepsea-gensets' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-Pu' '-t' '3' '-r' '2' 'udp:HOSTNAME:161' 'UDP-MIB::udpInDatagrams.0' 'UDP-MIB::udpOutDatagrams.0' 'UDP-MIB::udpInErrors.0' 'UDP-MIB::udpNoPorts.0'[0m] UDP-MIB::udpInDatagrams.0 = No Such Object available on this agent at this OID UDP-MIB::udpOutDatagrams.0 = No Such Object available on this agent at this OID UDP-MIB::udpInErrors.0 = No Such Object available on this agent at this OID UDP-MIB::udpNoPorts.0 = No Such Object available on this agent at this OID tcp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/deepsea-gensets' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-Pu' '-t' '3' '-r' '2' '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'[0m] Exitcode: 1 ["Timeout: No Response from udp:10.40.11.15:161. "] Timeout: No Response from udp:10.40.11.15:161. >> [0;36mSNMP[0m: [11/63.35s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [2/0.00s] >> Runtime for poller module 'netstats': 63.3512 seconds with 47152 bytes RRD[[0;32mlast 10.40.11.15/poller-perf-netstats.rrd --daemon unix:/run/rrdcached.sock[0m] RRD[[0;32mupdate 10.40.11.15/poller-perf-netstats.rrd N:63.351197004318 --daemon unix:/run/rrdcached.sock[0m] #### Unload poller module netstats #### #### Load poller module ipSystemStats #### Module enabled: Global + | OS | Device | Manual SNMP['/usr/bin/snmpbulkwalk' '-Cr2' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/deepsea-gensets' '-t' '3' '-r' '2' 'udp:HOSTNAME:161' 'ipSystemStats'[0m] ipSystemStatsTable = No more variables left in this MIB View (It is past the end of the MIB tree) >> [0;36mSNMP[0m: [1/0.03s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [2/0.00s] >> Runtime for poller module 'ipSystemStats': 0.0342 seconds with 3560 bytes RRD[[0;32mlast 10.40.11.15/poller-perf-ipSystemStats.rrd --daemon unix:/run/rrdcached.sock[0m] RRD[[0;32mupdate 10.40.11.15/poller-perf-ipSystemStats.rrd N:0.034205913543701 --daemon unix:/run/rrdcached.sock[0m] #### Unload poller module ipSystemStats #### #### Load poller module ports #### Module enabled: Global + | OS | Device | Manual 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[337][0m 1.67ms] Caching Oids: Full ports polling SNMP['/usr/bin/snmpbulkwalk' '-Cr2' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/deepsea-gensets' '-t' '3' '-r' '2' 'udp:HOSTNAME:161' 'ifXEntry'[0m] ifXEntry = No more variables left in this MIB View (It is past the end of the MIB tree) SNMP['/usr/bin/snmpbulkwalk' '-Cr2' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/deepsea-gensets' '-t' '3' '-r' '2' 'udp:HOSTNAME:161' 'ifEntry'[0m] ifEntry = No more variables left in this MIB View (It is past the end of the MIB tree) dot3StatsDuplexStatusSNMP['/usr/bin/snmpbulkwalk' '-Cr2' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/deepsea-gensets' '-t' '3' '-r' '2' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus'[0m] dot3StatsDuplexStatus = No more variables left in this MIB View (It is past the end of the MIB tree) SNMP['/usr/bin/snmpbulkwalk' '-Cr2' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/deepsea-gensets' '-t' '3' '-r' '2' 'udp:HOSTNAME:161' 'dot1qPvid'[0m] dot1qPvid.0 = No more variables left in this MIB View (It is past the end of the MIB tree) array ( ) SQL[[1;33mupdate `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where 0 = 1 [0;33m[1735231515,null,1735231515][0m 0.41ms] 0 updated >> [0;36mSNMP[0m: [4/0.08s] [1;33mMySQL[0m: [2/0.02s] [0;32mRRD[0m: [2/0.00s] >> Runtime for poller module 'ports': 0.0940 seconds with 26728 bytes RRD[[0;32mlast 10.40.11.15/poller-perf-ports.rrd --daemon unix:/run/rrdcached.sock[0m] RRD[[0;32mupdate 10.40.11.15/poller-perf-ports.rrd N:0.093957901000977 --daemon unix:/run/rrdcached.sock[0m] #### Unload poller module ports #### #### Load poller module customoid #### Module enabled: Global + | OS | Device | Manual SQL[[1;33mSELECT * FROM `customoids` WHERE `customoid_passed` = 1 AND `device_id` = ? [0;33m[337][0m 0.48ms] >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] [0;32mRRD[0m: [2/0.00s] >> Runtime for poller module 'customoid': 0.0019 seconds with 3768 bytes RRD[[0;32mlast 10.40.11.15/poller-perf-customoid.rrd --daemon unix:/run/rrdcached.sock[0m] RRD[[0;32mupdate 10.40.11.15/poller-perf-customoid.rrd N:0.0018880367279053 --daemon unix:/run/rrdcached.sock[0m] #### Unload poller module customoid #### #### Load poller module bgp-peers #### Module enabled: Global + | OS | Device | Manual SQL[[1;33mSELECT * FROM `bgpPeers` AS B LEFT JOIN `vrfs` AS V ON `B`.`vrf_id` = `V`.`vrf_id` WHERE `B`.`device_id` = ? [0;33m[337][0m 0.62ms] >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] [0;32mRRD[0m: [2/0.00s] >> Runtime for poller module 'bgp-peers': 0.0042 seconds with 15632 bytes RRD[[0;32mlast 10.40.11.15/poller-perf-bgp-peers.rrd --daemon unix:/run/rrdcached.sock[0m] RRD[[0;32mupdate 10.40.11.15/poller-perf-bgp-peers.rrd N:0.0042269229888916 --daemon unix:/run/rrdcached.sock[0m] #### Unload poller module bgp-peers #### #### Load poller module isis #### Module enabled: Global + | OS | Device | Manual SQL[[1;33mselect * from `isis_adjacencies` where `isis_adjacencies`.`device_id` = ? and `isis_adjacencies`.`device_id` is not null [0;33m[337][0m 0.46ms] SNMP['/usr/bin/snmpbulkwalk' '-Cr2' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'ISIS-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/deepsea-gensets' '-t' '3' '-r' '2' 'udp:HOSTNAME:161' 'isisISAdjState'[0m] isisISAdjState = No more variables left in this MIB View (It is past the end of the MIB tree) SNMP['/usr/bin/snmpbulkwalk' '-Cr2' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'ISIS-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/deepsea-gensets' '-t' '3' '-r' '2' 'udp:HOSTNAME:161' 'isisISAdjLastUpTime'[0m] isisISAdjLastUpTime = No more variables left in this MIB View (It is past the end of the MIB tree) >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] [0;32mRRD[0m: [2/0.00s] >> Runtime for poller module 'isis': 0.0568 seconds with 85504 bytes RRD[[0;32mlast 10.40.11.15/poller-perf-isis.rrd --daemon unix:/run/rrdcached.sock[0m] RRD[[0;32mupdate 10.40.11.15/poller-perf-isis.rrd N:0.056826114654541 --daemon unix:/run/rrdcached.sock[0m] #### Unload poller module isis #### #### Load poller module entity-physical #### Module enabled: Global + | OS | Device | Manual >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [2/0.00s] >> Runtime for poller module 'entity-physical': 0.0011 seconds with 7320 bytes RRD[[0;32mlast 10.40.11.15/poller-perf-entity-physical.rrd --daemon unix:/run/rrdcached.sock[0m] RRD[[0;32mupdate 10.40.11.15/poller-perf-entity-physical.rrd N:0.0011439323425293 --daemon unix:/run/rrdcached.sock[0m] #### Unload poller module entity-physical #### RRD[[0;32mlast 10.40.11.15/poller-perf.rrd --daemon unix:/run/rrdcached.sock[0m] RRD[[0;32mupdate 10.40.11.15/poller-perf.rrd N:64.911758899689 --daemon unix:/run/rrdcached.sock[0m] SQL[[1;33mselect * from `device_graphs` where `device_graphs`.`device_id` = ? and `device_graphs`.`device_id` is not null [0;33m[337][0m 0.79ms] Enabled graphs (4): poller_modules_perf poller_perf ping_perf uptime SQL[[1;33mupdate `devices` set `last_polled` = ?, `last_polled_timetaken` = ? where `device_id` = ? [0;33m["2024-12-26 13:45:15",64.91175889968872,337][0m 0.77ms] >>> Polled gem01.env.aep01 (337) in 64.912 seconds <<< #### Start Alerts #### SQL[[1;33mselect `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` = ? [0;33m[337][0m 0.47ms] SQL[[1;33mselect exists(select * from `alert_schedule` where (`start` <= ? and `end` >= ? and (`recurring` = ? or (`recurring` = ? and ((time(`start`) < time(`end`) and time(`start`) <= ? and time(`end`) > ?) or (time(`start`) > time(`end`) and (time(`start`) <= ? or time(`end`) > ?))) and (`recurring_day` like ? or `recurring_day` is null)))) and (exists (select * from `devices` inner join `alert_schedulables` on `devices`.`device_id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?))) as `exists` [0;33m["2024-12-26T16:45:15.529104Z","2024-12-26T16:45:15.529104Z",0,1,"16:45:15","16:45:15","16:45:15","16:45:15","[44m%","device",337][0m 0.74ms] SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[337][0m 0.74ms] SQL[[1;33mSELECT DISTINCT a.* FROM alert_rules a LEFT JOIN alert_device_map d ON a.id=d.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND d.device_id = ?) LEFT JOIN alert_group_map g ON a.id=g.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND g.group_id IN (SELECT DISTINCT device_group_id FROM device_group_device WHERE device_id = ?)) LEFT JOIN alert_location_map l ON a.id=l.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND l.location_id IN (SELECT DISTINCT location_id FROM devices WHERE device_id = ?)) LEFT JOIN devices ld ON l.location_id=ld.location_id AND ld.device_id = ? LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id AND dg.device_id = ? WHERE a.disabled = 0 AND ( (d.device_id IS NULL AND g.group_id IS NULL AND l.location_id IS NULL) OR (a.invert_map = 0 AND (d.device_id=? OR dg.device_id=? OR ld.device_id=?)) OR (a.invert_map = 1 AND (d.device_id != ? OR d.device_id IS NULL) AND (dg.device_id != ? OR dg.device_id IS NULL) AND (ld.device_id != ? OR ld.device_id IS NULL)) ) [0;33m[337,337,337,337,337,337,337,337,337,337,337][0m 2ms] Rule [0;35m#1 (Device down):[0m SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 AND devices.status_reason = "icmp" [0;33m[337][0m 0.62ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[1,337][0m 0.34ms] Status: [0;34mNOCHG[0m Rule [0;35m#2 (SNMP not responding):[0m SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 AND devices.status_reason = "snmp" [0;33m[337][0m 0.47ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[2,337][0m 0.26ms] Status: [0;34mNOCHG[0m Rule [0;35m#3 (Device rebooted):[0m SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND devices.uptime < 300 AND (devices.disabled = 0 && devices.ignore = 0) = 1 [0;33m[337][0m 0.49ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[3,337][0m 0.26ms] Status: [0;34mNOCHG[0m Rule [0;35m#4 (INTERFACE IS DOWN - BACKBONE):[0m SQL[[1;33mSELECT * FROM devices,ports WHERE (devices.device_id = ? AND devices.device_id = ports.device_id) AND (ports.ifOperStatus = "down" && ports.ifAdminStatus != "down" && (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = 1 AND ports.ifAlias LIKE '[0mN%' AND ports.ifAdminStatus = "up" AND ports.ifLastChange != 0 [0;33m[337][0m 0.86ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[4,337][0m 0.21ms] Status: [0;34mNOCHG[0m Rule [0;35m#6 (SATURACION - PNI):[0m SQL[[1;33mSELECT * FROM devices,ports WHERE (devices.device_id = ? AND devices.device_id = ports.device_id) AND (((ports.ifOutOctets_rate*8) / ports.ifSpeed)*100) >= 85 AND (ports.ifOperStatus = "up" && ports.ifAdminStatus = "up" && (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = 1 AND ports.ifDescr LIKE '[1;35mN%' AND ports.ifDescr NOT LIKE '%l2vpn%' AND ports.ifDescr NOT LIKE '[0;31mpn%' [0;33m[337][0m 0.63ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[6,337][0m 0.21ms] Status: [0;34mNOCHG[0m Rule [0;35m#26 (INTERFACE ERRORS - BACKBONE):[0m SQL[[1;33mSELECT * FROM devices,ports WHERE (devices.device_id = ? AND devices.device_id = ports.device_id) AND ports.ifInErrors_rate > 100 AND ports.ifDescr LIKE '[0mN%' [0;33m[337][0m 0.53ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[26,337][0m 0.2ms] Status: [0;34mNOCHG[0m Rule [0;35m#28 (SATURACION - BACKBONE):[0m SQL[[1;33mSELECT * FROM devices,ports WHERE (devices.device_id = ? AND devices.device_id = ports.device_id) AND ports.ifDescr LIKE '%sw%' AND ports.ifDescr LIKE '[0;31mtr%' AND (((ports.ifOutOctets_rate*8) / ports.ifSpeed)*100) >= 90 [0;33m[337][0m 0.55ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[28,337][0m 0.2ms] Status: [0;34mNOCHG[0m Rule [0;35m#29 (INTERFACE IS DOWN - CLIENTES):[0m SQL[[1;33mSELECT * FROM devices,ports WHERE (devices.device_id = ? AND devices.device_id = ports.device_id) AND ports.ifAlias NOT LIKE '[0mN%' AND (ports.ifOperStatus = "down" && ports.ifAdminStatus != "down" && (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = 1 AND ports.ifLastChange != 0 [0;33m[337][0m 0.54ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[29,337][0m 0.19ms] Status: [0;34mNOCHG[0m Rule [0;35m#30 (INTERFACE IS DOWN - PNI):[0m SQL[[1;33mSELECT * FROM devices,ports WHERE (devices.device_id = ? AND devices.device_id = ports.device_id) AND (ports.ifOperStatus = "down" && ports.ifAdminStatus != "down" && (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = 1 AND ports.ifAlias LIKE '[1;35mNI%' AND ports.ifAdminStatus = "up" AND ports.ifLastChange != 0 [0;33m[337][0m 0.56ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[30,337][0m 0.2ms] Status: [0;34mNOCHG[0m Rule [0;35m#31 (HIGH CPU USAGE):[0m SQL[[1;33mSELECT * FROM devices,processors WHERE (devices.device_id = ? AND devices.device_id = processors.device_id) AND processors.processor_usage > 85 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[337][0m 0.42ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[31,337][0m 0.19ms] Status: [0;34mNOCHG[0m Rule [0;35m#32 (ALTA TEMPERATURA):[0m SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_type = "tempSensorStatusState" AND sensors.sensor_current = 2 [0;33m[337][0m 0.49ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[32,337][0m 0.2ms] Status: [0;34mNOCHG[0m Rule [0;35m#33 (ISIS Adjacency down):[0m SQL[[1;33mSELECT * FROM devices,isis_adjacencies,component WHERE (devices.device_id = ? AND devices.device_id = isis_adjacencies.device_id AND devices.device_id = component.device_id) AND isis_adjacencies.isisISAdjState = "down" AND (component.type = "ISIS" AND (component.ignore = 0 AND component.disabled = 0)) AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[337][0m 0.5ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[33,337][0m 0.21ms] Status: [0;34mNOCHG[0m #### End Alerts (0.0266s) #### ### Start Device Groups ### SQL[[1;33mselect * from `device_groups` [0;33m[][0m 0.19ms] SQL[[1;33mselect `devices`.`device_id`, `device_group_device`.`device_group_id` as `pivot_device_group_id`, `device_group_device`.`device_id` as `pivot_device_id` from `devices` inner join `device_group_device` on `devices`.`device_id` = `device_group_device`.`device_id` where `device_group_device`.`device_group_id` in (1, 2, 3) [0;33m[][0m 0.37ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysName` LIKE ? AND `devices`.`sysName` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["[0;31mtr0%","[0;36mpe%",337][0m 0.24ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["comap",337][0m 0.19ms] SQL[[1;33mselect * from `device_group_device` where `device_group_device`.`device_id` = ? [0;33m[337][0m 0.21ms] Groups Added: Removed: ### End Device Groups (0.006s) ### [0;36mSNMP[0m [19/63.54s]: Snmpget[14/63.42s] Snmpwalk[5/0.12s] [1;33mSQL[0m [55/0.31s]: Select[51/0.27s] Update[4/0.04s] [0;32mRRD[0m [34/0.01s]: Other[17/0.01s] Update[17/0.00s]