LibreNMS Poller SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 1.11ms] SQL[[1;33mselect count(*) as aggregate from `migrations` [0;33m[][0m 0.88ms] SQL[[1;33mselect version() [0;33m[][0m 2.16ms] =========================================== Component | Version --------- | ------- LibreNMS | 22.11.0-277-g756a8d1e5 (2022-12-01T18:00:11-06:00) DB Schema | 2022_08_15_084507_add_rrd_type_to_wireless_sensors_table (248) PHP | 8.1.11 Python | 3.6.8 Database | MariaDB 10.6.11-MariaDB RRDTool | 1.8.0 SNMP | 5.8 =========================================== DEBUG! Updating os_def.cache Starting polling run: SQL[[1;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '172.20.1.81' ORDER BY `device_id` ASC [0;33m[][0m 1.56ms] SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[239][0m 0.58ms] SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[239][0m 0.51ms] Attempting to initialize OS: geist-watchdog Attempting to initialize Group OS: geist OS initialized as Generic Hostname: 172.20.1.81 Device ID: 239 OS: geist-watchdog (geist) [FPING] '/usr/sbin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' '-O' '0' '172.20.1.81' response: xmt/rcv/%loss = 3/3/0%, min/avg/max = 0.67/1.01/1.36 SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/geist' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysObjectID.0'[0m] SNMPv2-MIB::sysObjectID.0 = SNMPv2-SMI::enterprises.21* SQL[[1;33minsert into `device_perf` (`min`, `max`, `avg`, `xmt`, `rcv`, `loss`, `device_id`, `timestamp`) values (?, ?, ?, ?, ?, ?, ?, ?) [0;33m[0.67,1.36,1.01,3,3,0,239,"2022-12-05 17:07:36"][0m 2.18ms] SQL[[1;33mupdate `devices` set `last_ping_timetaken` = ? where `device_id` = ? [0;33m[1.01,239][0m 2ms] 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[239][0m 0.64ms] Modules status: Global+ OS Device #### Load poller module core #### SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/geist' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-On' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysUpTime.0'[0m] .*.*.0 = 103914533 SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/geist' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMP-FRAMEWORK-MIB::snmpEngineTime.0' 'HOST-RESOURCES-MIB::hrSystemUptime.0'[0m] SNMP-FRAMEWORK-MIB::snmpEngineTime.0 = No Such Object available on this agent at this OID HOST-RESOURCES-MIB::hrSystemUptime.0 = No Such Object available on this agent at this OID Uptime seconds: 1039145 Uptime: 12 days 39 minutes 5 seconds SQL[[1;33mupdate `devices` set `uptime` = ? where `device_id` = ? [0;33m[1039145,239][0m 2.9ms] >> Runtime for poller module 'core': 0.0682 seconds with 144024 bytes >> [0;36mSNMP[0m: [2/0.06s] [1;33mMySQL[0m: [1/0.03s] #### Unload poller module core #### Modules status: Global- OS Device Module [ unix-agent ] disabled globally. Modules status: Global+ OS Device #### Load poller module os #### Generic :( SQL[[1;33mselect * from `locations` where `locations`.`id` = ? limit 1 [0;33m[115][0m 0.71ms] Location: 541 Young St Jesup IA Hardware: OS Version: OS Features: Serial: >> Runtime for poller module 'os': 0.0036 seconds with 120176 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] #### Unload poller module os #### Modules status: Global+ OS Device #### Load poller module availability #### SQL[[1;33mSELECT duration FROM availability WHERE device_id = ? [0;33m[239][0m 0.64ms] Availability: SQL[[1;33mSELECT * FROM availability WHERE device_id = ? [0;33m[239][0m 0.6ms] SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[239,1670195256][0m 1.02ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,937][0m 0.42ms] 1 day : 100% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[239,1669676856][0m 0.7ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,938][0m 0.38ms] 7 days : 100% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[239,1667689656][0m 0.65ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,939][0m 0.34ms] 30 days : 100% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[239,1638745656][0m 0.58ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,940][0m 0.39ms] 365 days : 100% >> Runtime for poller module 'availability': 0.0096 seconds with 18664 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [10/0.06s] #### Unload poller module availability #### Modules status: Global+ OS Device #### Load poller module ipmi #### SQL[[1;33mSELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [0;33m[239][0m 0.65ms] array ( ) >> Runtime for poller module 'ipmi': 0.0015 seconds with 1984 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] #### Unload poller module ipmi #### 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[239][0m 0.59ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? [0;33m["humidity",239][0m 0.6ms] SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQntea' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/geist' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.21239.5.1.2.1.6.1'[0m] .*.4.1.21*.1.6.1 = 23 Checking (snmp) humidity HTCO Environmentals... 23 % SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? [0;33m["temperature",239][0m 1.13ms] SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQntea' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/geist' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.21239.5.1.2.1.5.1'[0m] .*.4.1.21*.1.5.1 = 691 SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Oqv' '-m' 'GEIST-V4-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/geist' 'udp:HOSTNAME:161' 'temperatureUnits.0'[0m] 0 Checking (snmp) temperature HTCO Environmentals... 20.61 C SQL[[1;33mUPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [0;33m[20.61,20.83,"temperature",8159][0m 2.57ms] >> Runtime for poller module 'sensors': 0.0944 seconds with 3328 bytes >> [0;36mSNMP[0m: [3/0.09s] [1;33mMySQL[0m: [4/0.05s] #### Unload poller module sensors #### Modules status: Global+ OS Device #### Load poller module processors #### Attempting to initialize OS: geist-watchdog Attempting to initialize Group OS: geist OS initialized as Generic SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[239][0m 0.83ms] >> Runtime for poller module 'processors': 0.0031 seconds with 59312 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] #### Unload poller module processors #### Modules status: Global+ OS Device #### Load poller module mempools #### SQL[[1;33mselect * from `mempools` where `mempools`.`device_id` = ? and `mempools`.`device_id` is not null [0;33m[239][0m 0.8ms] >> Runtime for poller module 'mempools': 0.0029 seconds with 79824 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] #### Unload poller module mempools #### Modules status: Global+ OS Device #### Load poller module storage #### SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[239][0m 0.6ms] >> Runtime for poller module 'storage': 0.0010 seconds with 1328 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] #### Unload poller module storage #### Modules status: Global+ OS Device #### Load poller module netstats #### icmp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/geist' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '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' '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' '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::icmpInMsgs.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutMsgs.0 = No Such Object available on this agent at this OID IP-MIB::icmpInErrors.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutErrors.0 = No Such Object available on this agent at this OID IP-MIB::icmpInEchos.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutEchos.0 = No Such Object available on this agent at this OID IP-MIB::icmpInEchoReps.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutEchoReps.0 = No Such Object available on this agent at this OID IP-MIB::icmpInDestUnreachs.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutDestUnreachs.0 = No Such Object available on this agent at this OID IP-MIB::icmpInParmProbs.0 = No Such Object available on this agent at this OID IP-MIB::icmpInTimeExcds.0 = No Such Object available on this agent at this OID IP-MIB::icmpInSrcQuenchs.0 = No Such Object available on this agent at this OID IP-MIB::icmpInRedirects.0 = No Such Object available on this agent at this OID IP-MIB::icmpInTimestamps.0 = No Such Object available on this agent at this OID IP-MIB::icmpInTimestampReps.0 = No Such Object available on this agent at this OID IP-MIB::icmpInAddrMasks.0 = No Such Object available on this agent at this OID IP-MIB::icmpInAddrMaskReps.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutTimeExcds.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutParmProbs.0 = No Such Object available on this agent at this OID 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/geist' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '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-MIB::ipForwDatagrams.0 = No Such Object available on this agent at this OID IP-MIB::ipInDelivers.0 = No Such Object available on this agent at this OID IP-MIB::ipInReceives.0 = No Such Object available on this agent at this OID IP-MIB::ipOutRequests.0 = No Such Object available on this agent at this OID IP-MIB::ipInDiscards.0 = No Such Object available on this agent at this OID IP-MIB::ipOutDiscards.0 = No Such Object available on this agent at this OID IP-MIB::ipOutNoRoutes.0 = No Such Object available on this agent at this OID IP-MIB::ipReasmReqds.0 = No Such Object available on this agent at this OID IP-MIB::ipReasmOKs.0 = No Such Object available on this agent at this OID IP-MIB::ipReasmFails.0 = No Such Object available on this agent at this OID 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/geist' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '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/geist' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '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' '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' '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:172.20.1.81:161.\n"] Timeout: No Response from udp:172.20.1.81:161. udp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/geist' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '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/geist' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '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] TCP-MIB::tcpActiveOpens.0 = No Such Object available on this agent at this OID TCP-MIB::tcpPassiveOpens.0 = No Such Object available on this agent at this OID TCP-MIB::tcpAttemptFails.0 = No Such Object available on this agent at this OID TCP-MIB::tcpEstabResets.0 = No Such Object available on this agent at this OID TCP-MIB::tcpCurrEstab.0 = No Such Object available on this agent at this OID TCP-MIB::tcpInSegs.0 = No Such Object available on this agent at this OID TCP-MIB::tcpOutSegs.0 = No Such Object available on this agent at this OID TCP-MIB::tcpRetransSegs.0 = No Such Object available on this agent at this OID TCP-MIB::tcpInErrs.0 = No Such Object available on this agent at this OID TCP-MIB::tcpOutRsts.0 = No Such Object available on this agent at this OID >> Runtime for poller module 'netstats': 6.3021 seconds with 23600 bytes >> [0;36mSNMP[0m: [6/6.30s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module netstats #### Modules status: Global+ OS Device #### Load poller module hr-mib #### SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQs' '-m' 'HOST-RESOURCES-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/geist' 'udp:HOSTNAME:161' 'hrSystemMaxProcesses.0' 'hrSystemProcesses.0' 'hrSystemNumUsers.0'[0m] hrSystemMaxProcesses.0 = No Such Object available on this agent at this OID hrSystemProcesses.0 = No Such Object available on this agent at this OID hrSystemNumUsers.0 = No Such Object available on this agent at this OID >> Runtime for poller module 'hr-mib': 0.0215 seconds with 512 bytes >> [0;36mSNMP[0m: [1/0.02s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module hr-mib #### Modules status: Global+ OS Device #### Load poller module ucd-mib #### SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/geist' 'udp:HOSTNAME:161' 'systemStats'[0m] systemStats = No more variables left in this MIB View (It is past the end of the MIB tree) SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/geist' 'udp:HOSTNAME:161' 'laLoadInt.1' 'laLoadInt.2' 'laLoadInt.3'[0m] laLoadInt.1 = No Such Object available on this agent at this OID laLoadInt.2 = No Such Object available on this agent at this OID laLoadInt.3 = No Such Object available on this agent at this OID >> Runtime for poller module 'ucd-mib': 0.0495 seconds with 96 bytes >> [0;36mSNMP[0m: [2/0.05s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module ucd-mib #### Modules status: Global+ OS Device #### Load poller module ipSystemStats #### SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/geist' 'udp:HOSTNAME:161' 'ipSystemStats'[0m] ipSystemStatsTable = No Such Object available on this agent at this OID Invalid snmp_walk() data = ipSystemStatsTable = No Such Object available on this agent at this OID >> Runtime for poller module 'ipSystemStats': 0.2579 seconds with 808 bytes >> [0;36mSNMP[0m: [1/0.26s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module ipSystemStats #### 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[239][0m 1.17ms] Caching Oids: Full ports polling Reporting disabled by user setting SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/geist' 'udp:HOSTNAME:161' 'ifXEntry'[0m] ifXEntry = No Such Object available on this agent at this OID Invalid snmp_walk() data = ifXEntry = No Such Object available on this agent at this OID SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/geist' 'udp:HOSTNAME:161' 'ifEntry'[0m] ifIndex.1 = 1 ifDescr.1 = eth0 ifType.1 = ethernetCsmacd ifMtu.1 = 1500 ifSpeed.1 = 100000000 ifPhysAddress.1 = 4:91:62:eb:1c:d4 ifAdminStatus.1 = up ifOperStatus.1 = up ifLastChange.1 = 0 ifInOctets.1 = 0 ifInUcastPkts.1 = 0 ifInNUcastPkts.1 = 0 ifInDiscards.1 = 0 ifInErrors.1 = 0 ifInUnknownProtos.1 = 0 ifOutOctets.1 = 0 ifOutUcastPkts.1 = 0 ifOutNUcastPkts.1 = 0 ifOutDiscards.1 = 0 ifOutErrors.1 = 0 ifOutQLen.1 = 0 ifSpecific.1 = zeroDotZero dot3StatsDuplexStatusSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/geist' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus'[0m] dot3StatsDuplexStatus = No Such Object available on this agent at this OID Invalid snmp_walk() data = dot3StatsDuplexStatus = No Such Object available on this agent at this OID SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/geist' 'udp:HOSTNAME:161' 'dot1qPvid'[0m] dot1qPvid = No Such Object available on this agent at this OID Invalid snmp_walk() data = dot1qPvid = No Such Object available on this agent at this OID array ( 1 => array ( 'ifIndex' => '1', 'ifDescr' => 'eth0', 'ifType' => 'ethernetCsmacd', 'ifMtu' => '1500', 'ifSpeed' => '100000000', 'ifPhysAddress' => '4:91:62:eb:1c:d4', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '0', 'ifInOctets' => '0', 'ifInUcastPkts' => '0', 'ifInNUcastPkts' => '0', 'ifInDiscards' => '0', 'ifInErrors' => '0', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '0', 'ifOutUcastPkts' => '0', 'ifOutNUcastPkts' => '0', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), ) valid Port eth0: eth0 (1 / #15171) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed (100000000) VLAN = ? Using ifDescr as ifAlias Using ifDescr as ifName eth0 ifInOctets (0 B) 0 Bps 265 secs ifOutOctets (0 B) 0 Bps 265 secs ifInErrors (0 B) 0 Bps 265 secs ifOutErrors (0 B) 0 Bps 265 secs ifInUcastPkts (0 B) 0 Bps 265 secs ifOutUcastPkts (0 B) 0 Bps 265 secs ifInNUcastPkts (0 B) 0 Bps 265 secs ifOutNUcastPkts (0 B) 0 Bps 265 secs ifInDiscards (0 B) 0 Bps 265 secs ifOutDiscards (0 B) 0 Bps 265 secs ifInUnknownProtos (0 B) 0 Bps 265 secs ifInBroadcastPkts (0 B) 0 Bps 265 secs ifOutBroadcastPkts (0 B) 0 Bps 265 secs ifInMulticastPkts (0 B) 0 Bps 265 secs ifOutMulticastPkts (0 B) 0 Bps 265 secs bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)SQL[[1;33mUPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,1670281664,1670281399,265,15171][0m 2.63ms] SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? [0;33m["0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,15171][0m 0.54ms] 1 updated SQL[[1;33mupdate `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where 0 = 1 [0;33m[1670281664,1670281399,null][0m 0.45ms] 0 updated >> Runtime for poller module 'ports': 1.4534 seconds with 53992 bytes >> [0;36mSNMP[0m: [4/1.44s] [1;33mMySQL[0m: [4/0.05s] #### Unload poller module ports #### Modules status: Global- OS Device Module [ xdsl ] disabled globally. Modules status: Global+ OS Device #### Load poller module customoid #### SQL[[1;33mSELECT * FROM `customoids` WHERE `customoid_passed` = 1 AND `device_id` = ? [0;33m[239][0m 0.57ms] array ( 'customoid_id' => 2, 'device_id' => 239, 'customoid_descr' => 'tempSensorAvail', 'customoid_deleted' => 0, 'customoid_current' => 0.0, 'customoid_prev' => 0.0, 'customoid_oid' => '1.3.6.1.4.1.21239.5.1.4.1.4', 'customoid_datatype' => 'GAUGE', 'customoid_unit' => NULL, 'customoid_divisor' => 1, 'customoid_multiplier' => 1, 'customoid_limit' => NULL, 'customoid_limit_warn' => NULL, 'customoid_limit_low' => NULL, 'customoid_limit_low_warn' => NULL, 'customoid_alert' => 0, 'customoid_passed' => 1, 'lastupdate' => '2022-12-05 17:03:19', 'user_func' => NULL, ) SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Oqv' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/geist' 'udp:HOSTNAME:161' '1.3.6.1.4.1.21239.5.1.4.1.4'[0m] No Such Instance currently exists at this OID Custom OID tempSensorAvail: 0 SQL[[1;33mUPDATE `customoids` set `customoid_current`=?,`lastupdate`=NOW(),`customoid_prev`=? WHERE `customoid_id` = ? [0;33m[0,0,2][0m 3.26ms] array ( 'customoid_id' => 4, 'device_id' => 239, 'customoid_descr' => 'tempSensorTemp', 'customoid_deleted' => 0, 'customoid_current' => 0.0, 'customoid_prev' => 0.0, 'customoid_oid' => '1.3.6.1.4.1.21239.5.1.4.1.5', 'customoid_datatype' => 'COUNTER', 'customoid_unit' => NULL, 'customoid_divisor' => 1, 'customoid_multiplier' => 1, 'customoid_limit' => NULL, 'customoid_limit_warn' => NULL, 'customoid_limit_low' => NULL, 'customoid_limit_low_warn' => NULL, 'customoid_alert' => 0, 'customoid_passed' => 1, 'lastupdate' => '2022-12-05 17:03:19', 'user_func' => NULL, ) SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Oqv' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/geist' 'udp:HOSTNAME:161' '1.3.6.1.4.1.21239.5.1.4.1.5'[0m] No Such Instance currently exists at this OID Custom OID tempSensorTemp: 0 SQL[[1;33mUPDATE `customoids` set `customoid_current`=?,`lastupdate`=NOW(),`customoid_prev`=? WHERE `customoid_id` = ? [0;33m[0,0,4][0m 2.63ms] array ( 'customoid_id' => 5, 'device_id' => 239, 'customoid_descr' => 'TempSensorTemp1', 'customoid_deleted' => 0, 'customoid_current' => 636.0, 'customoid_prev' => 641.0, 'customoid_oid' => '1.3.6.1.4.1.21239.5.1.4.1.5.1', 'customoid_datatype' => '', 'customoid_unit' => NULL, 'customoid_divisor' => 1, 'customoid_multiplier' => 1, 'customoid_limit' => NULL, 'customoid_limit_warn' => NULL, 'customoid_limit_low' => NULL, 'customoid_limit_low_warn' => NULL, 'customoid_alert' => 0, 'customoid_passed' => 1, 'lastupdate' => '2022-12-05 17:03:19', 'user_func' => NULL, ) SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Oqv' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/geist' 'udp:HOSTNAME:161' '1.3.6.1.4.1.21239.5.1.4.1.5.1'[0m] 630 Custom OID TempSensorTemp1: 630 SQL[[1;33mUPDATE `customoids` set `customoid_current`=?,`lastupdate`=NOW(),`customoid_prev`=? WHERE `customoid_id` = ? [0;33m[630,636,5][0m 2.18ms] >> Runtime for poller module 'customoid': 0.1216 seconds with 3760 bytes >> [0;36mSNMP[0m: [3/0.11s] [1;33mMySQL[0m: [4/0.09s] #### Unload poller module customoid #### Modules status: Global+ OS Device #### Load poller module bgp-peers #### 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[239][0m 1.08ms] >> Runtime for poller module 'bgp-peers': 0.0034 seconds with 13400 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] #### Unload poller module bgp-peers #### Modules status: Global- OS Device Module [ junose-atm-vp ] disabled globally. Modules status: Global- OS Device Module [ printer-supplies ] disabled globally. Modules status: Global+ OS Device #### Load poller module ucd-diskio #### SQL[[1;33mSELECT * FROM `ucd_diskio` WHERE `device_id` = ? [0;33m[239][0m 0.64ms] >> Runtime for poller module 'ucd-diskio': 0.0011 seconds with 1208 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] #### Unload poller module ucd-diskio #### Modules status: Global- OS Device Module [ wifi ] disabled globally. Modules status: Global+ OS Device #### Load poller module wireless #### Attempting to initialize OS: geist-watchdog Attempting to initialize Group OS: geist OS initialized as Generic SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id` = ? [0;33m[239][0m 0.87ms] >> Runtime for poller module 'wireless': 0.0026 seconds with 103448 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] #### Unload poller module wireless #### Modules status: Global+ OS Device #### Load poller module ospf #### SQL[[1;33mselect * from `vrf_lite_cisco` where `vrf_lite_cisco`.`device_id` = ? and `vrf_lite_cisco`.`device_id` is not null [0;33m[239][0m 0.6ms] Processes: SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/geist' '-v2c' '-c' 'COMMUNITY' '-OQXUt' '-Os' 'udp:HOSTNAME:161' 'OSPF-MIB::ospfGeneralGroup'[0m] ospfGeneralGroup = No Such Object available on this agent at this OID SQL[[1;33mdelete from `ospf_instances` where `ospf_instances`.`device_id` = ? and `ospf_instances`.`device_id` is not null and `context_name` = ? and 1 = 1 [0;33m[239,""][0m 0.61ms] 0 >> Runtime for poller module 'ospf': 0.2823 seconds with 166672 bytes >> [0;36mSNMP[0m: [1/0.28s] [1;33mMySQL[0m: [2/0.01s] #### Unload poller module ospf #### Modules status: Global- OS Device Module [ isis ] disabled globally. 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 [ slas ] 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-qfp ] 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 #### >> Runtime for poller module 'entity-physical': 0.0002 seconds with 392 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module entity-physical #### 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 `applications`.`device_id` = ? and `applications`.`device_id` is not null [0;33m[239][0m 0.86ms] >> Runtime for poller module 'applications': 0.0020 seconds with 28360 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] #### Unload poller module applications #### Modules status: Global+ OS Device #### Load poller module stp #### Instances: SQL[[1;33mselect * from `stp` where `stp`.`device_id` = ? and `stp`.`device_id` is not null [0;33m[239][0m 0.56ms] Ports: SQL[[1;33mselect * from `ports_stp` where `ports_stp`.`device_id` = ? and `ports_stp`.`device_id` is not null [0;33m[239][0m 0.6ms] >> Runtime for poller module 'stp': 0.0030 seconds with 84616 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [2/0.01s] #### Unload poller module stp #### Modules status: Global+ OS Device #### Load poller module ntp #### >> Runtime for poller module 'ntp': 0.0001 seconds with 320 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module ntp #### Modules status: Global- OS Device Module [ loadbalancers ] disabled globally. Modules status: Global- OS Device Module [ mef ] disabled globally. Modules status: Global+ OS Device #### Load poller module mpls #### >> Runtime for poller module 'mpls': 0.0004 seconds with 36712 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module mpls #### Module mib does not exist, please remove it from your configurationEnabling graphs: SQL[[1;33mselect * from `device_graphs` where `device_graphs`.`device_id` = ? and `device_graphs`.`device_id` is not null [0;33m[239][0m 0.58ms] SQL[[1;33mUPDATE `devices` set `last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [0;33m[9.769,239][0m 2.89ms] Updating 172.20.1.81 Polled in 9.769 seconds ### Start Device Groups ### SQL[[1;33mselect * from `device_groups` [0;33m[][0m 0.6ms] 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 (5, 7, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18) [0;33m[][0m 2.04ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysDescr` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["[1;34m6%",239][0m 0.87ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysDescr` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%arista%",239][0m 0.67ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` LIKE ? OR `devices`.`icon` LIKE ? OR `devices`.`icon` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["[1;36myberpower%","%Emerson%","%APC%",239][0m 0.62ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysName` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["[1;32mXW%",239][0m 0.62ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysDescr` LIKE ? OR `devices`.`sysDescr` LIKE ? OR `devices`.`sysDescr` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["[47m11GE%","[47m16GE%","[47m17GE%",239][0m 0.52ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysDescr` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%ON2342-02%",239][0m 1.04ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%IronWare%",239][0m 0.97ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`override_sysLocation` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%Mike%",239][0m 0.48ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["[1;36miena%",239][0m 0.4ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysDescr` LIKE ? AND `devices`.`sysName` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%arista%","%HT%",239][0m 0.38ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`type` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["environment",239][0m 0.36ms] SQL[[1;33mselect * from `device_group_device` where `device_group_device`.`device_id` = ? [0;33m[239][0m 0.45ms] Groups Added: Groups Removed: ### End Device Groups, runtime: 0.0273s ### #### 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[239][0m 0.5ms] SQL[[1;33mselect exists(select * from `alert_schedule` where (`start` <= ? and `end` >= ? and (`recurring` = ? or (`recurring` = ? and ((time(`start`) < time xss=removed> ?) 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` = ?) or exists (select * from `device_groups` inner join `alert_schedulables` on `device_groups`.`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` in (18)) or exists (select * from `locations` inner join `alert_schedulables` on `locations`.`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["2022-12-05T23:07:44.933197Z","2022-12-05T23:07:44.933197Z",0,1,"23:07:44","23:07:44","23:07:44","23:07:44","[41m%","device",239,"device_group","location",115][0m 1.04ms] SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[239][0m 0.63ms] Disable alerting is set, Clearing active alerts and skipping alert rules check SQL[[1;33mUPDATE `alerts` set `state`=?,`alerted`=?,`open`=? WHERE `device_id` = ? [0;33m[0,0,0,239][0m 0.39ms] #### End Alerts #### ./poller.php 172.20.1.81 2022-12-05 17:07:44 - 1 devices polled in 10.10 secs [0;36mSNMP[0m [24/8.64s]: Snmpget[17/6.64s] Snmpwalk[7/2.01s] [1;33mSQL[0m [66/0.65s]: Select[49/0.38s] Insert[1/0.02s] Update[15/0.24s] Delete[1/0.01s]