LibreNMS Poller SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.19ms] SQL[[1;33mselect count(*) as aggregate from `migrations` limit 1 [0;33m[][0m 2.52ms] SQL[[1;33mSELECT version() [0;33m[][0m 0.22ms] =================================== Version info: Commit SHA: db73b8fadecfdfee8ad27dcbc3cac01f995dddc6 Commit Date: 1610320954 DB Schema: 2020_11_02_164331_add_powerstate_enum_to_vminfo (191) PHP: 7.4.13 MySQL: 10.3.27-MariaDB-0+deb10u1 RRDTool: 1.7.1 SNMP: NET-SNMP 5.7.3 ==================================DEBUG! Updating os_def.cache Starting polling run: SQL[[1;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'proxmox-node-2.home.lan' ORDER BY `device_id` ASC [0;33m[][0m 0.59ms] SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[36][0m 0.38ms] SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[36][0m 0.18ms] Attempting to initialize OS: proxmox Attempting to initialize OS: unix OS initialized: LibreNMS\OS\Shared\Unix Hostname: proxmox-node-2.home.lan Device ID: 36 OS: proxmox Resolved IP: 192.168.30.3 (unix) SQL[[1;33mselect `hostname`, `overwrite_ip` from `devices` where `hostname` = ? limit 1 [0;33m["proxmox-node-2.home.lan"][0m 0.56ms] [FPING] '/usr/bin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' 'proxmox-node-2.home.lan' response: {"xmt":3,"rcv":3,"loss":0,"min":0.5,"max":0.62,"avg":0.57,"dup":0,"exitcode":0} 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[36][0m 0.27ms] SQL[[1;33mselect * from `locations` where `locations`.`id` = ? limit 1 [0;33m[4][0m 0.14ms] 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(`end`) <= ? or time(`start`) > ?))) 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 0 = 1) 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["2021-01-11T10:55:05.445798Z","2021-01-11T10:55:05.445798Z",0,1,"10:55:05","10:55:05","10:55:05","10:55:05","[41m%","device",36,"device_group","location",4][0m 0.61ms] SQL[[1;33mINSERT 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) [0;33m{"xmt":3,"rcv":3,"loss":0,"min":0.5,"max":0.62,"avg":0.57,"device_id":36,"debug":"[]"}[0m 0.93ms] SQL[[1;33mUPDATE `devices` set `last_ping`=?,`last_ping_timetaken`=? WHERE device_id=? [0;33m["2021-01-11 12:55:05",0.57,36][0m 0.79ms] SNMP Check response code: 0 Modules status: Global+ OS Device #### Load poller module core #### SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQnUt' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'sysUpTime.0' 'sysContact.0' 'sysName.0' 'sysObjectID.0' 'sysDescr.0'[0m] .*.*.0 = 32710223 .*.*.0 = Kristian Kirilov .*.*.0 = proxmox-node-2.home.lan .*.*.0 = .*.4.1.8* .*.*.0 = Linux proxmox-node-2.home.lan 5.4.78-2-pve #1 SMP PVE 5.4.78-2 (Thu, 03 Dec 2020 14:26:17 +0100) x86_64 SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQnUst' '-m' 'HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'snmpEngineTime.0' 'hrSystemUptime.0'[0m] snmpEngineTime.0 = No Such Object available on this agent at this OID hrSystemUptime.0 = 32711102 Uptime seconds: 327111 Uptime: 3 days 18 hours 51 minutes 51 seconds >> Runtime for poller module 'core': 0.0251 seconds with 25608 bytes >> SNMP: [2/0.02s] MySQL: [0/0.00s] #### Unload poller module core #### Modules status: Global+ OS Device #### Load poller module availability #### SQL[[1;33mSELECT duration FROM availability WHERE device_id = ? [0;33m[36][0m 0.33ms] Availability: SQL[[1;33mSELECT * FROM availability WHERE device_id = ? [0;33m[36][0m 0.15ms] SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[36,1610276105][0m 0.32ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,41][0m 0.2ms] 1 day : 100% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[36,1609757705][0m 0.25ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,42][0m 0.25ms] 7 days : 100% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[36,1607770505][0m 0.21ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,43][0m 0.14ms] 30 days : 100% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[36,1578826505][0m 0.18ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,44][0m 0.16ms] 365 days : 100% >> Runtime for poller module 'availability': 0.0045 seconds with 38432 bytes >> SNMP: [0/0.00s] MySQL: [5/0.00s] #### Unload poller module availability #### Modules status: Global- OS Device Module [ unix-agent ] disabled globally. Modules status: Global+ OS Device #### Load poller module os #### Generic :( Location: (PVE) Sofia Hardware: Generic x86 64-bit OS Version: 5.4.78-2-pve OS Features: Serial: >> Runtime for poller module 'os': 0.0013 seconds with 91472 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] #### Unload poller module os #### Modules status: Global+ OS Device #### Load poller module ipmi #### SQL[[1;33mSELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [0;33m[36][0m 0.25ms] array ( ) >> Runtime for poller module 'ipmi': 0.0005 seconds with 2872 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] #### 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[36][0m 0.21ms] >> Runtime for poller module 'sensors': 0.0004 seconds with 1584 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] #### Unload poller module sensors #### Modules status: Global+ OS Device #### Load poller module processors #### Attempting to initialize OS: proxmox Attempting to initialize OS: unix OS initialized: LibreNMS\OS\Shared\Unix SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[36][0m 0.31ms] >> Runtime for poller module 'processors': 0.0012 seconds with 125976 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] #### 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[36][0m 0.31ms] >> Runtime for poller module 'mempools': 0.0011 seconds with 75864 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] #### Unload poller module mempools #### Modules status: Global+ OS Device #### Load poller module storage #### SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[36][0m 0.21ms] >> Runtime for poller module 'storage': 0.0004 seconds with 2032 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] #### Unload poller module storage #### Modules status: Global+ OS Device #### Load poller module netstats #### ICMPSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'icmp'[0m] icmp = No Such Object available on this agent at this OID Invalid snmp_walk() data = icmp = No Such Object available on this agent at this OID IPSNMP[[0;36m'/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ipForwDatagrams' 'ipInDelivers' 'ipInReceives' 'ipOutRequests' 'ipInDiscards' 'ipOutDiscards' 'ipOutNoRoutes' 'ipReasmReqds' 'ipReasmOKs' 'ipReasmFails' 'ipFragOKs' 'ipFragFails' 'ipFragCreates' 'ipInUnknownProtos' 'ipInHdrErrors' 'ipInAddrErrors'[0m] mib-*.0 = 3:18:51:51.06 mib-*.0 = 3:18:51:51.06 mib-*.0 = 3:18:51:51.06 mib-*.0 = 3:18:51:51.06 mib-*.0 = 3:18:51:51.06 mib-*.0 = 3:18:51:51.06 mib-*.0 = 3:18:51:51.06 mib-*.0 = 3:18:51:51.06 mib-*.0 = 3:18:51:51.06 mib-*.0 = 3:18:51:51.06 mib-*.0 = 3:18:51:51.06 mib-*.0 = 3:18:51:51.06 mib-*.0 = 3:18:51:51.06 mib-*.0 = 3:18:51:51.06 mib-*.0 = 3:18:51:51.06 mib-*.0 = 3:18:51:51.06 IP-FORWARDSNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQv' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0'[0m] No Such Object available on this agent at this OID SNMPSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'snmp'[0m] snmp = No Such Object available on this agent at this OID Invalid snmp_walk() data = snmp = No Such Object available on this agent at this OID TCPSNMP[[0;36m'/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'TCP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'tcpActiveOpens' 'tcpPassiveOpens' 'tcpAttemptFails' 'tcpEstabResets' 'tcpCurrEstab' 'tcpInSegs' 'tcpOutSegs' 'tcpRetransSegs' 'tcpInErrs' 'tcpOutRsts'[0m] mib-*.0 = 3:18:51:51.10 mib-*.0 = 3:18:51:51.10 mib-*.0 = 3:18:51:51.10 mib-*.0 = 3:18:51:51.10 mib-*.0 = 3:18:51:51.10 mib-*.0 = 3:18:51:51.10 mib-*.0 = 3:18:51:51.10 mib-*.0 = 3:18:51:51.10 mib-*.0 = 3:18:51:51.10 mib-*.0 = 3:18:51:51.10 TCPHCSNMP[[0;36m'/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'TCP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'tcpHCInSegs.0' 'tcpHCOutSegs.0'[0m] mib-*.0 = 3:18:51:51.11 mib-*.0 = 3:18:51:51.11 UDPSNMP[[0;36m'/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UDP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'udpInDatagrams' 'udpOutDatagrams' 'udpInErrors' 'udpNoPorts'[0m] mib-*.0 = 3:18:51:51.13 mib-*.0 = 3:18:51:51.13 mib-*.0 = 3:18:51:51.13 mib-*.0 = 3:18:51:51.13 >> Runtime for poller module 'netstats': 0.0946 seconds with 3824 bytes >> SNMP: [7/0.09s] MySQL: [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' 'udp:HOSTNAME:161' 'hrSystemProcesses.0' 'hrSystemNumUsers.0'[0m] 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.0123 seconds with 1640 bytes >> SNMP: [1/0.01s] MySQL: [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' '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' '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.0250 seconds with 2000 bytes >> SNMP: [2/0.02s] MySQL: [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' '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.0162 seconds with 1976 bytes >> SNMP: [1/0.02s] MySQL: [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[36][0m 0.62ms] Caching Oids: Full ports polling SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifXEntry'[0m] ifXEntry = No more variables left in this MIB View (It is past the end of the MIB tree) SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifEntry'[0m] ifEntry = No Such Object available on this agent at this OID Invalid snmp_walk() data = ifEntry = No Such Object available on this agent at this OID dot3StatsDuplexStatusSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs' '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' '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 SQL[[1;33mSELECT COUNT(*) FROM `ports` WHERE `device_id` = ? AND `ifType` in ('adsl','vdsl') [0;33m[36][0m 0.42ms] array ( ) Warning: max(): Array must contain at least one element in /opt/librenms/includes/polling/ports.inc.php on line 521 SQL[[1;33mupdate `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where 0 = 1 [0;33m[1610362505,false,1610362505][0m 0.23ms] 0 updated >> Runtime for poller module 'ports': 0.0610 seconds with 34480 bytes >> SNMP: [4/0.06s] MySQL: [1/0.00s] #### Unload poller module ports #### Modules status: Global+ OS Device #### Load poller module customoid #### SQL[[1;33mSELECT * FROM `customoids` WHERE `customoid_passed` = 1 AND `device_id` = ? [0;33m[36][0m 0.23ms] >> Runtime for poller module 'customoid': 0.0005 seconds with 2488 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] #### Unload poller module customoid #### Modules status: Global+ OS- Device Module [ bgp-peers ] disabled on os. Modules status: Global- OS Device Module [ junose-atm-vp ] disabled globally. Modules status: Global- OS Device Module [ toner ] disabled globally. Modules status: Global+ OS Device #### Load poller module ucd-diskio #### SQL[[1;33mSELECT * FROM `ucd_diskio` WHERE `device_id` = ? [0;33m[36][0m 0.14ms] >> Runtime for poller module 'ucd-diskio': 0.0003 seconds with 1944 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] #### 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: proxmox Attempting to initialize OS: unix OS initialized: LibreNMS\OS\Shared\Unix SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id` = ? [0;33m[36][0m 0.23ms] >> Runtime for poller module 'wireless': 0.0013 seconds with 103008 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] #### Unload poller module wireless #### Modules status: Global+ OS- Device Module [ ospf ] disabled on os. 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-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 #### SQL[[1;33mSELECT * FROM `entPhysical_state` WHERE `device_id` = ? [0;33m[36][0m 0.12ms] >> Runtime for poller module 'entity-physical': 0.0004 seconds with 2152 bytes >> SNMP: [0/0.00s] MySQL: [1/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 `device_id` = ? [0;33m[36][0m 0.11ms] >> Runtime for poller module 'applications': 0.0002 seconds with 1592 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] #### Unload poller module applications #### Modules status: Global- OS Device Module [ mib ] disabled globally. Modules status: Global+ OS- Device Module [ stp ] disabled on os. Modules status: Global+ OS Device #### Load poller module ntp #### >> Runtime for poller module 'ntp': 0.0001 seconds with 400 bytes >> SNMP: [0/0.00s] MySQL: [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.0002 seconds with 24080 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] #### Unload poller module mpls #### Enabling graphs: SQL[[1;33mselect * from `device_graphs` where `device_graphs`.`device_id` = ? and `device_graphs`.`device_id` is not null [0;33m[36][0m 0.18ms] SQL[[1;33mUPDATE `devices` set `uptime`=?,`last_ping`=NOW(),`last_ping_timetaken`=?,`last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [0;33m[327111,0.57,1.305,36][0m 1.71ms] Updating proxmox-node-2.home.lan Polled in 1.305 seconds ### Start Device Groups ### SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[36][0m 0.38ms] SQL[[1;33mselect * from `device_groups` [0;33m[][0m 0.19ms] SQL[[1;33mselect * from `device_group_device` where `device_id` = ? [0;33m[36][0m 0.19ms] Groups Added: Groups Removed: ### End Device Groups, runtime: 0.0014s ### #### Start Alerts #### 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(`end`) <= ? or time(`start`) > ?))) 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 0 = 1) 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["2021-01-11T10:55:05.721537Z","2021-01-11T10:55:05.721537Z",0,1,"10:55:05","10:55:05","10:55:05","10:55:05","[41m%","device",36,"device_group","location",4][0m 0.5ms] SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[36][0m 0.21ms] 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 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) OR (a.invert_map = 0 AND (d.device_id=? OR dg.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)) ) [0;33m[36,36,36,36,36,36,36,36][0m 1.03ms] Rule [0;35m#1 (Devices up/down):[0m SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[36][0m 0.32ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[1,36][0m 0.13ms] Status: [0;34mNOCHG[0m #### End Alerts #### SQL[[1;33mINSERT IGNORE INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`) VALUES (:type,:doing,:start,:duration,:devices,:poller) [0;33m{"type":"poll","doing":"proxmox-node-2.home.lan","start":1610362504.0339,"duration":"1.691","devices":1,"poller":"\/"}[0m 0.82ms] ./poller.php proxmox-node-2.home.lan 2021-01-11 12:55:05 - 1 devices polled in 1.691 secs SNMP [18/0.24s]: Get[6/0.07s] Getnext[4/0.05s] Walk[8/0.11s] MySQL [22/0.01s]: Cell[3/0.00s] Row[-3/-0.00s] Rows[13/0.01s] Column[1/0.00s] Update[6/0.00s] Insert[2/0.00s] Delete[0/0.00s]