Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [librenms@localhost ~]$ ./poller.php -h 192.168.0.40 -m ports -d
- LibreNMS Poller
- SQL[select `migration` from `migrations` order by `id` desc limit 1 [] 0.79ms]
- SQL[select count(*) as aggregate from `migrations` limit 1 [] 0.61ms]
- SQL[SELECT version() [] 0.34ms]
- ===================================
- Version info:
- Commit SHA: 411f36a9a1d6aaad47e8ae3ad3547715c58170ed
- Commit Date: 1551670633
- DB Schema: 2019_02_10_220000_add_dates_to_fdb (132)
- PHP: 7.2.12
- MySQL: 5.5.60-MariaDB
- RRDTool: 1.4.8
- SNMP: NET-SNMP 5.7.2
- ==================================DEBUG!
- Updating os_def.cache...
- Done
- Override poller modules: ports
- Starting polling run:
- SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '192.168.0.40' ORDER BY `device_id` ASC [] 1.19ms]
- SQL[SELECT * FROM devices_attribs WHERE `device_id` = ? [6] 4.34ms]
- Hostname: 192.168.0.40
- Device ID: 6
- OS: dlink
- Warning: inet_pton(): Unrecognized address in /opt/librenms/includes/polling/functions.inc.php on line 249
- [FPING] /usr/sbin/fping -e -q -c 3 -p 500 -t 500 192.168.0.40
- array (
- 'xmt' => '3',
- 'rcv' => '3',
- 'loss' => '0',
- 'min' => '0.95',
- 'max' => '1.71',
- 'avg' => '1.27',
- '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":"0.95","max":"1.71","avg":"1.27","device_id":6,"debug":"[]"} 4.24ms]
- 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/dlink' 'udp:HOSTNAME:161' 'sysUpTime.0' 'sysLocation.0' 'sysContact.0' 'sysName.0' 'sysObjectID.0' 'sysDescr.0']
- .*.*.0 = 50702325
- .*.*.0 =
- .*.*.0 =
- .*.*.0 = SWITCH
- .*.*.0 = .*.*.134.10
- .*.*.0 = DGS-1100-24P/ME Gigabit Ethernet Switch
- SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQnUst' '-m' 'HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/dlink' 'udp:HOSTNAME:161' 'snmpEngineTime.0' 'hrSystemUptime.0']
- snmpEngineTime.0 = No Such Object available on this agent at this OID
- hrSystemUptime.0 = No Such Object available on this agent at this OID
- Uptime seconds: 507023
- RRD[update 192.168.0.40/uptime.rrd N:507023 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- Uptime: 5 days, 20h 50m 23s
- SQL[select * from `locations` where `locations`.`id` is null limit 1 [] 0.62ms]
- >> Runtime for poller module 'core': 0.0611 seconds with 135712 bytes
- >> SNMP: [2/0.06s] MySQL: [0/0.00s] RRD: [1/0.00s]
- #### Unload poller module core ####
- RRD[update 192.168.0.40/poller-perf-core.rrd N:0.061100959777832 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- 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 [6] 2.2ms]
- Caching Oids: Full ports polling SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/dlink' 'udp:HOSTNAME:161' 'ifXEntry']
- ifInMulticastPkts.1 = 969
- ifInMulticastPkts.2 = 468371
- ifInMulticastPkts.3 = 2499223
- ifInMulticastPkts.4 = 15287
- ifInMulticastPkts.5 = 300891
- ifInMulticastPkts.6 = 513726
- ifInMulticastPkts.7 = 295725
- ifInMulticastPkts.8 = 294775
- ifInMulticastPkts.9 = 4828463
- ifInMulticastPkts.10 = 8092597
- ifInMulticastPkts.11 = 1603619
- ifInMulticastPkts.12 = 1944823
- ifInMulticastPkts.13 = 35132
- ifInMulticastPkts.14 = 2123420
- ifInMulticastPkts.15 = 0
- ifInMulticastPkts.16 = 25714
- ifInMulticastPkts.17 = 413525
- ifInMulticastPkts.18 = 197117
- ifInMulticastPkts.19 = 523156
- ifInMulticastPkts.20 = 321649
- ifInMulticastPkts.21 = 71
- ifInMulticastPkts.22 = 741446
- ifInMulticastPkts.23 = 677314953
- ifInMulticastPkts.24 = 25965
- ifInBroadcastPkts.1 = 9307130
- ifInBroadcastPkts.2 = 548496
- ifInBroadcastPkts.3 = 1528494
- ifInBroadcastPkts.4 = 287242
- ifInBroadcastPkts.5 = 11863
- ifInBroadcastPkts.6 = 810676
- ifInBroadcastPkts.7 = 7689
- ifInBroadcastPkts.8 = 9353
- ifInBroadcastPkts.9 = 18972
- ifInBroadcastPkts.10 = 15886337
- ifInBroadcastPkts.11 = 355749
- ifInBroadcastPkts.12 = 65912
- ifInBroadcastPkts.13 = 2186587
- ifInBroadcastPkts.14 = 1022232
- ifInBroadcastPkts.15 = 0
- ifInBroadcastPkts.16 = 5705
- ifInBroadcastPkts.17 = 336504
- ifInBroadcastPkts.18 = 1463983
- ifInBroadcastPkts.19 = 38619
- ifInBroadcastPkts.20 = 3692430
- ifInBroadcastPkts.21 = 8068
- ifInBroadcastPkts.22 = 139218
- ifInBroadcastPkts.23 = 2565472970
- ifInBroadcastPkts.24 = 486
- ifAlias.1 = blabla
- ifAlias.2 =
- ifAlias.3 =
- ifAlias.4 =
- ifAlias.5 =
- ifAlias.6 =
- ifAlias.7 =
- ifAlias.8 =
- ifAlias.9 =
- ifAlias.10 =
- ifAlias.11 =
- ifAlias.12 =
- ifAlias.13 =
- ifAlias.14 =
- ifAlias.15 =
- ifAlias.16 =
- ifAlias.17 =
- ifAlias.18 =
- ifAlias.19 =
- ifAlias.20 =
- ifAlias.21 =
- ifAlias.22 =
- ifAlias.23 =
- ifAlias.24 =
- SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/dlink' 'udp:HOSTNAME:161' 'ifEntry']
- ifIndex.1 = 1
- ifIndex.2 = 2
- ifIndex.3 = 3
- ifIndex.4 = 4
- ifIndex.5 = 5
- ifIndex.6 = 6
- ifIndex.7 = 7
- ifIndex.8 = 8
- ifIndex.9 = 9
- ifIndex.10 = 10
- ifIndex.11 = 11
- ifIndex.12 = 12
- ifIndex.13 = 13
- ifIndex.14 = 14
- ifIndex.15 = 15
- ifIndex.16 = 16
- ifIndex.17 = 17
- ifIndex.18 = 18
- ifIndex.19 = 19
- ifIndex.20 = 20
- ifIndex.21 = 21
- ifIndex.22 = 22
- ifIndex.23 = 23
- ifIndex.24 = 24
- ifDescr.1 = D-Link Corporation DGS-1100-24P/ME 1.00.B022 Port 1
- ifDescr.2 = D-Link Corporation DGS-1100-24P/ME 1.00.B022 Port 2
- ifDescr.3 = D-Link Corporation DGS-1100-24P/ME 1.00.B022 Port 3
- ifDescr.4 = D-Link Corporation DGS-1100-24P/ME 1.00.B022 Port 4
- ifDescr.5 = D-Link Corporation DGS-1100-24P/ME 1.00.B022 Port 5
- ifDescr.6 = D-Link Corporation DGS-1100-24P/ME 1.00.B022 Port 6
- Error in packet.
- Reason: (tooBig) Response message would have been too large.
- dot3StatsDuplexStatusSNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/dlink' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus']
- dot3StatsDuplexStatus.1 = fullDuplex
- dot3StatsDuplexStatus.2 = fullDuplex
- dot3StatsDuplexStatus.3 = fullDuplex
- dot3StatsDuplexStatus.4 = fullDuplex
- dot3StatsDuplexStatus.5 = fullDuplex
- dot3StatsDuplexStatus.6 = fullDuplex
- dot3StatsDuplexStatus.7 = fullDuplex
- dot3StatsDuplexStatus.8 = fullDuplex
- dot3StatsDuplexStatus.9 = fullDuplex
- dot3StatsDuplexStatus.10 = fullDuplex
- dot3StatsDuplexStatus.11 = unknown
- dot3StatsDuplexStatus.12 = fullDuplex
- dot3StatsDuplexStatus.13 = fullDuplex
- dot3StatsDuplexStatus.14 = fullDuplex
- dot3StatsDuplexStatus.15 = unknown
- dot3StatsDuplexStatus.16 = unknown
- dot3StatsDuplexStatus.17 = fullDuplex
- dot3StatsDuplexStatus.18 = fullDuplex
- dot3StatsDuplexStatus.19 = fullDuplex
- dot3StatsDuplexStatus.20 = fullDuplex
- dot3StatsDuplexStatus.21 = unknown
- dot3StatsDuplexStatus.22 = fullDuplex
- dot3StatsDuplexStatus.23 = fullDuplex
- dot3StatsDuplexStatus.24 = unknown
- SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/dlink' 'udp:HOSTNAME:161' 'dot1qPvid']
- dot1qPvid.1 = 1
- dot1qPvid.2 = 1
- dot1qPvid.3 = 1
- dot1qPvid.4 = 1
- dot1qPvid.5 = 1
- dot1qPvid.6 = 1
- dot1qPvid.7 = 1
- dot1qPvid.8 = 1
- dot1qPvid.9 = 1
- dot1qPvid.10 = 1
- dot1qPvid.11 = 1
- dot1qPvid.12 = 1
- dot1qPvid.13 = 1
- dot1qPvid.14 = 1
- dot1qPvid.15 = 1
- dot1qPvid.16 = 1
- dot1qPvid.17 = 1
- dot1qPvid.18 = 1
- dot1qPvid.19 = 1
- dot1qPvid.20 = 1
- dot1qPvid.21 = 1
- dot1qPvid.22 = 1
- dot1qPvid.23 = 1
- dot1qPvid.24 = 1
- SQL[SELECT COUNT(*) FROM `ports` WHERE `device_id` = ? AND `ifType` in ('adsl','vdsl') [6] 1.36ms]
- array (
- 1 =>
- array (
- 'ifInMulticastPkts' => '969',
- 'ifInBroadcastPkts' => '9307130',
- 'ifAlias' => 'blabla',
- 'ifIndex' => '1',
- 'ifDescr' => 'D-Link Corporation DGS-1100-24P/ME 1.00.B022 Port 1',
- 'dot3StatsDuplexStatus' => 'fullDuplex',
- 'dot1qPvid' => '1',
- ),
- 2 =>
- array (
- 'ifInMulticastPkts' => '468371',
- 'ifInBroadcastPkts' => '548496',
- 'ifAlias' => '',
- 'ifIndex' => '2',
- 'ifDescr' => 'D-Link Corporation DGS-1100-24P/ME 1.00.B022 Port 2',
- 'dot3StatsDuplexStatus' => 'fullDuplex',
- 'dot1qPvid' => '1',
- ),
- 3 =>
- array (
- 'ifInMulticastPkts' => '2499223',
- 'ifInBroadcastPkts' => '1528494',
- 'ifAlias' => '',
- 'ifIndex' => '3',
- 'ifDescr' => 'D-Link Corporation DGS-1100-24P/ME 1.00.B022 Port 3',
- 'dot3StatsDuplexStatus' => 'fullDuplex',
- 'dot1qPvid' => '1',
- ),
- 4 =>
- array (
- 'ifInMulticastPkts' => '15287',
- 'ifInBroadcastPkts' => '287242',
- 'ifAlias' => '',
- 'ifIndex' => '4',
- 'ifDescr' => 'D-Link Corporation DGS-1100-24P/ME 1.00.B022 Port 4',
- 'dot3StatsDuplexStatus' => 'fullDuplex',
- 'dot1qPvid' => '1',
- ),
- 5 =>
- array (
- 'ifInMulticastPkts' => '300891',
- 'ifInBroadcastPkts' => '11863',
- 'ifAlias' => '',
- 'ifIndex' => '5',
- 'ifDescr' => 'D-Link Corporation DGS-1100-24P/ME 1.00.B022 Port 5',
- 'dot3StatsDuplexStatus' => 'fullDuplex',
- 'dot1qPvid' => '1',
- ),
- 6 =>
- array (
- 'ifInMulticastPkts' => '513726',
- 'ifInBroadcastPkts' => '810676',
- 'ifAlias' => '',
- 'ifIndex' => '6',
- 'ifDescr' => 'D-Link Corporation DGS-1100-24P/ME 1.00.B022 Port 6',
- 'dot3StatsDuplexStatus' => 'fullDuplex',
- 'dot1qPvid' => '1',
- ),
- 7 =>
- array (
- 'ifInMulticastPkts' => '295725',
- 'ifInBroadcastPkts' => '7689',
- 'ifAlias' => '',
- 'ifIndex' => '7',
- 'dot3StatsDuplexStatus' => 'fullDuplex',
- 'dot1qPvid' => '1',
- ),
- 8 =>
- array (
- 'ifInMulticastPkts' => '294775',
- 'ifInBroadcastPkts' => '9353',
- 'ifAlias' => '',
- 'ifIndex' => '8',
- 'dot3StatsDuplexStatus' => 'fullDuplex',
- 'dot1qPvid' => '1',
- ),
- 9 =>
- array (
- 'ifInMulticastPkts' => '4828463',
- 'ifInBroadcastPkts' => '18972',
- 'ifAlias' => '',
- 'ifIndex' => '9',
- 'dot3StatsDuplexStatus' => 'fullDuplex',
- 'dot1qPvid' => '1',
- ),
- 10 =>
- array (
- 'ifInMulticastPkts' => '8092597',
- 'ifInBroadcastPkts' => '15886337',
- 'ifAlias' => '',
- 'ifIndex' => '10',
- 'dot3StatsDuplexStatus' => 'fullDuplex',
- 'dot1qPvid' => '1',
- ),
- 11 =>
- array (
- 'ifInMulticastPkts' => '1603619',
- 'ifInBroadcastPkts' => '355749',
- 'ifAlias' => '',
- 'ifIndex' => '11',
- 'dot3StatsDuplexStatus' => 'unknown',
- 'dot1qPvid' => '1',
- ),
- 12 =>
- array (
- 'ifInMulticastPkts' => '1944823',
- 'ifInBroadcastPkts' => '65912',
- 'ifAlias' => '',
- 'ifIndex' => '12',
- 'dot3StatsDuplexStatus' => 'fullDuplex',
- 'dot1qPvid' => '1',
- ),
- 13 =>
- array (
- 'ifInMulticastPkts' => '35132',
- 'ifInBroadcastPkts' => '2186587',
- 'ifAlias' => '',
- 'ifIndex' => '13',
- 'dot3StatsDuplexStatus' => 'fullDuplex',
- 'dot1qPvid' => '1',
- ),
- 14 =>
- array (
- 'ifInMulticastPkts' => '2123420',
- 'ifInBroadcastPkts' => '1022232',
- 'ifAlias' => '',
- 'ifIndex' => '14',
- 'dot3StatsDuplexStatus' => 'fullDuplex',
- 'dot1qPvid' => '1',
- ),
- 15 =>
- array (
- 'ifInMulticastPkts' => '0',
- 'ifInBroadcastPkts' => '0',
- 'ifAlias' => '',
- 'ifIndex' => '15',
- 'dot3StatsDuplexStatus' => 'unknown',
- 'dot1qPvid' => '1',
- ),
- 16 =>
- array (
- 'ifInMulticastPkts' => '25714',
- 'ifInBroadcastPkts' => '5705',
- 'ifAlias' => '',
- 'ifIndex' => '16',
- 'dot3StatsDuplexStatus' => 'unknown',
- 'dot1qPvid' => '1',
- ),
- 17 =>
- array (
- 'ifInMulticastPkts' => '413525',
- 'ifInBroadcastPkts' => '336504',
- 'ifAlias' => '',
- 'ifIndex' => '17',
- 'dot3StatsDuplexStatus' => 'fullDuplex',
- 'dot1qPvid' => '1',
- ),
- 18 =>
- array (
- 'ifInMulticastPkts' => '197117',
- 'ifInBroadcastPkts' => '1463983',
- 'ifAlias' => '',
- 'ifIndex' => '18',
- 'dot3StatsDuplexStatus' => 'fullDuplex',
- 'dot1qPvid' => '1',
- ),
- 19 =>
- array (
- 'ifInMulticastPkts' => '523156',
- 'ifInBroadcastPkts' => '38619',
- 'ifAlias' => '',
- 'ifIndex' => '19',
- 'dot3StatsDuplexStatus' => 'fullDuplex',
- 'dot1qPvid' => '1',
- ),
- 20 =>
- array (
- 'ifInMulticastPkts' => '321649',
- 'ifInBroadcastPkts' => '3692430',
- 'ifAlias' => '',
- 'ifIndex' => '20',
- 'dot3StatsDuplexStatus' => 'fullDuplex',
- 'dot1qPvid' => '1',
- ),
- 21 =>
- array (
- 'ifInMulticastPkts' => '71',
- 'ifInBroadcastPkts' => '8068',
- 'ifAlias' => '',
- 'ifIndex' => '21',
- 'dot3StatsDuplexStatus' => 'unknown',
- 'dot1qPvid' => '1',
- ),
- 22 =>
- array (
- 'ifInMulticastPkts' => '741446',
- 'ifInBroadcastPkts' => '139218',
- 'ifAlias' => '',
- 'ifIndex' => '22',
- 'dot3StatsDuplexStatus' => 'fullDuplex',
- 'dot1qPvid' => '1',
- ),
- 23 =>
- array (
- 'ifInMulticastPkts' => '677314953',
- 'ifInBroadcastPkts' => '2565472970',
- 'ifAlias' => '',
- 'ifIndex' => '23',
- 'dot3StatsDuplexStatus' => 'fullDuplex',
- 'dot1qPvid' => '1',
- ),
- 24 =>
- array (
- 'ifInMulticastPkts' => '25965',
- 'ifInBroadcastPkts' => '486',
- 'ifAlias' => '',
- 'ifIndex' => '24',
- 'dot3StatsDuplexStatus' => 'unknown',
- 'dot1qPvid' => '1',
- ),
- )
- valid
- valid
- valid
- valid
- valid
- valid
- ignored: empty ifDescr, ifAlias and ifName
- SQL[UPDATE `ports` set `deleted`=? WHERE `port_id` = ? ["1",null] 0.99ms]
- ignored: empty ifDescr, ifAlias and ifName
- ignored: empty ifDescr, ifAlias and ifName
- ignored: empty ifDescr, ifAlias and ifName
- ignored: empty ifDescr, ifAlias and ifName
- ignored: empty ifDescr, ifAlias and ifName
- ignored: empty ifDescr, ifAlias and ifName
- ignored: empty ifDescr, ifAlias and ifName
- ignored: empty ifDescr, ifAlias and ifName
- ignored: empty ifDescr, ifAlias and ifName
- ignored: empty ifDescr, ifAlias and ifName
- ignored: empty ifDescr, ifAlias and ifName
- ignored: empty ifDescr, ifAlias and ifName
- ignored: empty ifDescr, ifAlias and ifName
- ignored: empty ifDescr, ifAlias and ifName
- ignored: empty ifDescr, ifAlias and ifName
- ignored: empty ifDescr, ifAlias and ifName
- ignored: empty ifDescr, ifAlias and ifName
- Port D-Link Corporation DGS-1100-24P/ME 1.00.B022 Port 1: D-Link Corporation DGS-1100-24P/ME 1.00.B022 Port 1 (1 / #477) ifInOctets
- ifOutOctets
- ifInUcastPkts
- ifOutUcastPkts
- ifInBroadcastPkts
- ifOutBroadcastPkts
- ifInMulticastPkts
- ifOutMulticastPkts
- No ifSpeed
- dot3Duplex VLAN = 1 Using ifDescr as ifName
- blabla
- ifInOctets (0 B) 0 Bps 54 secs
- ifOutOctets (0 B) 0 Bps 54 secs
- ifInErrors (0 B) 0 Bps 54 secs
- ifOutErrors (0 B) 0 Bps 54 secs
- ifInUcastPkts (0 B) 0 Bps 54 secs
- ifOutUcastPkts (0 B) 0 Bps 54 secs
- ifInNUcastPkts (0 B) 0 Bps 54 secs
- ifOutNUcastPkts (0 B) 0 Bps 54 secs
- ifInDiscards (0 B) 0 Bps 54 secs
- ifOutDiscards (0 B) 0 Bps 54 secs
- ifInUnknownProtos (0 B) 0 Bps 54 secs
- ifInBroadcastPkts (42 B) 0.77777777777778 Bps 54 secs
- ifOutBroadcastPkts (0 B) 0 Bps 54 secs
- ifInMulticastPkts (0 B) 0 Bps 54 secs
- ifOutMulticastPkts (0 B) 0 Bps 54 secs
- bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)RRD[update 192.168.0.40/port-id477.rrd N:U:U:U:U:U:U:U:U:U:U:U:9307130:U:969:U --daemon unix:/var/run/rrdcached/rrdcached.sock]
- SQL[UPDATE `ports` set `poll_time`=?,`poll_prev`=?,`poll_period`=?,`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`=? WHERE `port_id` = ? [1554506935,1554506881,54,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,477] 1.34ms]
- SQL[UPDATE `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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"9307130",9307088,0.77777777777777779,42,0,0,0,0,"969",969,0,0,0,0,0,0,477] 1.15ms]
- 2 updated
- Port D-Link Corporation DGS-1100-24P/ME 1.00.B022 Port 2: D-Link Corporation DGS-1100-24P/ME 1.00.B022 Port 2 (2 / #478) ifInOctets
- ifOutOctets
- ifInUcastPkts
- ifOutUcastPkts
- ifInBroadcastPkts
- ifOutBroadcastPkts
- ifInMulticastPkts
- ifOutMulticastPkts
- No ifSpeed
- dot3Duplex VLAN = 1 Using ifDescr as ifAlias
- Using ifDescr as ifName
- D-Link Corporation DGS-1100-24P/ME 1.00.B022 Port 2
- ifInOctets (0 B) 0 Bps 54 secs
- ifOutOctets (0 B) 0 Bps 54 secs
- ifInErrors (0 B) 0 Bps 54 secs
- ifOutErrors (0 B) 0 Bps 54 secs
- ifInUcastPkts (0 B) 0 Bps 54 secs
- ifOutUcastPkts (0 B) 0 Bps 54 secs
- ifInNUcastPkts (0 B) 0 Bps 54 secs
- ifOutNUcastPkts (0 B) 0 Bps 54 secs
- ifInDiscards (0 B) 0 Bps 54 secs
- ifOutDiscards (0 B) 0 Bps 54 secs
- ifInUnknownProtos (0 B) 0 Bps 54 secs
- ifInBroadcastPkts (0 B) 0 Bps 54 secs
- ifOutBroadcastPkts (0 B) 0 Bps 54 secs
- ifInMulticastPkts (1 B) 0.018518518518519 Bps 54 secs
- ifOutMulticastPkts (0 B) 0 Bps 54 secs
- bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)RRD[update 192.168.0.40/port-id478.rrd N:U:U:U:U:U:U:U:U:U:U:U:548496:U:468371:U --daemon unix:/var/run/rrdcached/rrdcached.sock]
- SQL[UPDATE `ports` set `poll_time`=?,`poll_prev`=?,`poll_period`=?,`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`=? WHERE `port_id` = ? [1554506935,1554506881,54,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,478] 1.69ms]
- SQL[UPDATE `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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"548496",548496,0,0,0,0,0,0,"468371",468370,0.018518518518518517,1,0,0,0,0,478] 1.24ms]
- 2 updated
- Port D-Link Corporation DGS-1100-24P/ME 1.00.B022 Port 3: D-Link Corporation DGS-1100-24P/ME 1.00.B022 Port 3 (3 / #479) ifInOctets
- ifOutOctets
- ifInUcastPkts
- ifOutUcastPkts
- ifInBroadcastPkts
- ifOutBroadcastPkts
- ifInMulticastPkts
- ifOutMulticastPkts
- No ifSpeed
- dot3Duplex VLAN = 1 Using ifDescr as ifAlias
- Using ifDescr as ifName
- D-Link Corporation DGS-1100-24P/ME 1.00.B022 Port 3
- ifInOctets (0 B) 0 Bps 54 secs
- ifOutOctets (0 B) 0 Bps 54 secs
- ifInErrors (0 B) 0 Bps 54 secs
- ifOutErrors (0 B) 0 Bps 54 secs
- ifInUcastPkts (0 B) 0 Bps 54 secs
- ifOutUcastPkts (0 B) 0 Bps 54 secs
- ifInNUcastPkts (0 B) 0 Bps 54 secs
- ifOutNUcastPkts (0 B) 0 Bps 54 secs
- ifInDiscards (0 B) 0 Bps 54 secs
- ifOutDiscards (0 B) 0 Bps 54 secs
- ifInUnknownProtos (0 B) 0 Bps 54 secs
- ifInBroadcastPkts (0 B) 0 Bps 54 secs
- ifOutBroadcastPkts (0 B) 0 Bps 54 secs
- ifInMulticastPkts (7 B) 0.12962962962963 Bps 54 secs
- ifOutMulticastPkts (0 B) 0 Bps 54 secs
- bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)RRD[update 192.168.0.40/port-id479.rrd N:U:U:U:U:U:U:U:U:U:U:U:1528494:U:2499223:U --daemon unix:/var/run/rrdcached/rrdcached.sock]
- SQL[UPDATE `ports` set `poll_time`=?,`poll_prev`=?,`poll_period`=?,`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`=? WHERE `port_id` = ? [1554506935,1554506881,54,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,479] 1.02ms]
- SQL[UPDATE `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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"1528494",1528494,0,0,0,0,0,0,"2499223",2499216,0.12962962962962962,7,0,0,0,0,479] 1.02ms]
- 2 updated
- Port D-Link Corporation DGS-1100-24P/ME 1.00.B022 Port 4: D-Link Corporation DGS-1100-24P/ME 1.00.B022 Port 4 (4 / #480) ifInOctets
- ifOutOctets
- ifInUcastPkts
- ifOutUcastPkts
- ifInBroadcastPkts
- ifOutBroadcastPkts
- ifInMulticastPkts
- ifOutMulticastPkts
- No ifSpeed
- dot3Duplex VLAN = 1 Using ifDescr as ifAlias
- Using ifDescr as ifName
- D-Link Corporation DGS-1100-24P/ME 1.00.B022 Port 4
- ifInOctets (0 B) 0 Bps 54 secs
- ifOutOctets (0 B) 0 Bps 54 secs
- ifInErrors (0 B) 0 Bps 54 secs
- ifOutErrors (0 B) 0 Bps 54 secs
- ifInUcastPkts (0 B) 0 Bps 54 secs
- ifOutUcastPkts (0 B) 0 Bps 54 secs
- ifInNUcastPkts (0 B) 0 Bps 54 secs
- ifOutNUcastPkts (0 B) 0 Bps 54 secs
- ifInDiscards (0 B) 0 Bps 54 secs
- ifOutDiscards (0 B) 0 Bps 54 secs
- ifInUnknownProtos (0 B) 0 Bps 54 secs
- ifInBroadcastPkts (0 B) 0 Bps 54 secs
- ifOutBroadcastPkts (0 B) 0 Bps 54 secs
- ifInMulticastPkts (0 B) 0 Bps 54 secs
- ifOutMulticastPkts (0 B) 0 Bps 54 secs
- bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)RRD[update 192.168.0.40/port-id480.rrd N:U:U:U:U:U:U:U:U:U:U:U:287242:U:15287:U --daemon unix:/var/run/rrdcached/rrdcached.sock]
- SQL[UPDATE `ports` set `poll_time`=?,`poll_prev`=?,`poll_period`=?,`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`=? WHERE `port_id` = ? [1554506935,1554506881,54,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,480] 1.18ms]
- SQL[UPDATE `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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"287242",287242,0,0,0,0,0,0,"15287",15287,0,0,0,0,0,0,480] 1.13ms]
- 1 updated
- Port D-Link Corporation DGS-1100-24P/ME 1.00.B022 Port 5: D-Link Corporation DGS-1100-24P/ME 1.00.B022 Port 5 (5 / #481) ifInOctets
- ifOutOctets
- ifInUcastPkts
- ifOutUcastPkts
- ifInBroadcastPkts
- ifOutBroadcastPkts
- ifInMulticastPkts
- ifOutMulticastPkts
- No ifSpeed
- dot3Duplex VLAN = 1 Using ifDescr as ifAlias
- Using ifDescr as ifName
- D-Link Corporation DGS-1100-24P/ME 1.00.B022 Port 5
- ifInOctets (0 B) 0 Bps 54 secs
- ifOutOctets (0 B) 0 Bps 54 secs
- ifInErrors (0 B) 0 Bps 54 secs
- ifOutErrors (0 B) 0 Bps 54 secs
- ifInUcastPkts (0 B) 0 Bps 54 secs
- ifOutUcastPkts (0 B) 0 Bps 54 secs
- ifInNUcastPkts (0 B) 0 Bps 54 secs
- ifOutNUcastPkts (0 B) 0 Bps 54 secs
- ifInDiscards (0 B) 0 Bps 54 secs
- ifOutDiscards (0 B) 0 Bps 54 secs
- ifInUnknownProtos (0 B) 0 Bps 54 secs
- ifInBroadcastPkts (0 B) 0 Bps 54 secs
- ifOutBroadcastPkts (0 B) 0 Bps 54 secs
- ifInMulticastPkts (2 B) 0.037037037037037 Bps 54 secs
- ifOutMulticastPkts (0 B) 0 Bps 54 secs
- bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)RRD[update 192.168.0.40/port-id481.rrd N:U:U:U:U:U:U:U:U:U:U:U:11863:U:300891:U --daemon unix:/var/run/rrdcached/rrdcached.sock]
- SQL[UPDATE `ports` set `poll_time`=?,`poll_prev`=?,`poll_period`=?,`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`=? WHERE `port_id` = ? [1554506935,1554506881,54,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,481] 1.49ms]
- SQL[UPDATE `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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"11863",11863,0,0,0,0,0,0,"300891",300889,0.037037037037037035,2,0,0,0,0,481] 1.29ms]
- 2 updated
- Port D-Link Corporation DGS-1100-24P/ME 1.00.B022 Port 6: D-Link Corporation DGS-1100-24P/ME 1.00.B022 Port 6 (6 / #482) ifInOctets
- ifOutOctets
- ifInUcastPkts
- ifOutUcastPkts
- ifInBroadcastPkts
- ifOutBroadcastPkts
- ifInMulticastPkts
- ifOutMulticastPkts
- No ifSpeed
- dot3Duplex VLAN = 1 Using ifDescr as ifAlias
- Using ifDescr as ifName
- D-Link Corporation DGS-1100-24P/ME 1.00.B022 Port 6
- ifInOctets (0 B) 0 Bps 54 secs
- ifOutOctets (0 B) 0 Bps 54 secs
- ifInErrors (0 B) 0 Bps 54 secs
- ifOutErrors (0 B) 0 Bps 54 secs
- ifInUcastPkts (0 B) 0 Bps 54 secs
- ifOutUcastPkts (0 B) 0 Bps 54 secs
- ifInNUcastPkts (0 B) 0 Bps 54 secs
- ifOutNUcastPkts (0 B) 0 Bps 54 secs
- ifInDiscards (0 B) 0 Bps 54 secs
- ifOutDiscards (0 B) 0 Bps 54 secs
- ifInUnknownProtos (0 B) 0 Bps 54 secs
- ifInBroadcastPkts (1 B) 0.018518518518519 Bps 54 secs
- ifOutBroadcastPkts (0 B) 0 Bps 54 secs
- ifInMulticastPkts (0 B) 0 Bps 54 secs
- ifOutMulticastPkts (0 B) 0 Bps 54 secs
- bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)RRD[update 192.168.0.40/port-id482.rrd N:U:U:U:U:U:U:U:U:U:U:U:810676:U:513726:U --daemon unix:/var/run/rrdcached/rrdcached.sock]
- SQL[UPDATE `ports` set `poll_time`=?,`poll_prev`=?,`poll_period`=?,`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`=? WHERE `port_id` = ? [1554506935,1554506881,54,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,482] 3.86ms]
- SQL[UPDATE `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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"810676",810675,0.018518518518518517,1,0,0,0,0,"513726",513726,0,0,0,0,0,0,482] 1.45ms]
- 2 updated
- >> Runtime for poller module 'ports': 1.1110 seconds with 43464 bytes
- >> SNMP: [4/1.07s] MySQL: [14/0.03s] RRD: [7/0.00s]
- #### Unload poller module ports ####
- RRD[update 192.168.0.40/poller-perf-ports.rrd N:1.1109809875488 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- ### 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.ip REGEXP "192.168.2.") LIMIT 1 [6] 0.49ms]
- SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`=? [6] 0.43ms]
- Groups Added:
- Groups Removed:
- ### End Device Groups ###
- RRD[update 192.168.0.40/ping-perf.rrd N:1.27 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[update 192.168.0.40/poller-perf.rrd N:2.246 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- SQL[UPDATE `devices` set `uptime`=?,`last_ping`=NOW(),`last_ping_timetaken`=? WHERE `device_id` = ? [507023,"1.27",6] 1.49ms]
- Updating 192.168.0.40
- Polled in 2.246 seconds
- #### Start Alerts ####
- SQL[select * from `devices` where `devices`.`device_id` = ? limit 1 [6] 0.68ms]
- 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` = ? [6] 1.15ms]
- 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 0 = 1))) as `exists` [0,1,"0000-00-00","","","device",6,"device_group"] 1.68ms]
- 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=?) [6,6] 2.46ms]
- #### End Alerts ####
- SQL[INSERT IGNORE INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`) VALUES (:type,:doing,:start,:duration,:devices,:poller) {"type":"poll","doing":"192.168.0.40","start":1554506932.919277,"duration":"2.489","devices":1,"poller":"localhost.localdomain"} 1.25ms]
- ./poller.php 192.168.0.40 2019-04-06 02:28:55 - 1 devices polled in 2.489 secs
- SNMP [7/1.17s]: Get[3/0.11s] Getnext[0/0.00s] Walk[4/1.07s]
- MySQL [21/0.04s]: Cell[3/0.00s] Row[-3/-0.00s] Rows[4/0.01s] Column[1/0.00s] Update[14/0.02s] Insert[2/0.01s] Delete[0/0.00s]
- RRD [11/0.00s]: Update[11/0.00s] Create [0/0.00s] Other[0/0.00s]
- [librenms@localhost ~]$
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement