DEBUG! CMD[/usr/bin/svn info /u1/observium]  CMD EXITCODE[0] CMD RUNTIME[0.0264s] STDOUT[ Path: . Working Copy Root Path: /u1/observium URL: http://svn.observium.org/svn/observium/trunk Repository Root: http://svn.observium.org/svn Repository UUID: 61d68cd4-352d-0410-923a-c4978735b2b8 Revision: 9750 Node Kind: directory Schedule: normal Last Changed Author: mike Last Changed Rev: 9750 Last Changed Date: 2019-03-08 09:59:52 -0500 (Fri, 08 Mar 2019) ] SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';] SQL RUNTIME[0.00042319s] SQL[SELECT @@SESSION.sql_mode;] SQL RUNTIME[0.00009012s] SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'current_rev';] SQL RUNTIME[0.00019407s] SQL[SELECT * FROM `config`] SQL RUNTIME[0.00023007s]  ___ _ _ / _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___ | | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \ | |_| || |_) |\__ \| __/| | \ V / | || |_| || | | | | | \___/ |_.__/ |___/ \___||_| \_/ |_| \__,_||_| |_| |_| Observium Professional 19.3.9750 http://www.observium.org  CMD[/u1/observium/scripts/distro]  CMD EXITCODE[0] CMD RUNTIME[0.0434s] STDOUT[ Linux|3.10.0-862.3.3.el7.x86_64|amd64|CentOS|7|| ] CMD[/usr/bin/env python --version 2>&1]  CMD EXITCODE[0] CMD RUNTIME[0.0051s] STDOUT[ Python 2.7.5 ] SQL[SELECT version();] SQL RUNTIME[0.00016499s] CMD[/usr/bin/snmpget --version 2>&1]  CMD EXITCODE[0] CMD RUNTIME[0.0088s] STDOUT[ NET-SNMP version: 5.7.2 ] CMD[/usr/bin/rrdtool --version | head -n1]  CMD EXITCODE[0] CMD RUNTIME[0.0103s] STDOUT[ RRDtool 1.6.0 Copyright by Tobias Oetiker ] CMD[/usr/sbin/fping -v 2>&1]  CMD EXITCODE[0] CMD RUNTIME[0.004s] STDOUT[ /usr/sbin/fping: Version 3.10 /usr/sbin/fping: comments to david@schweikert.ch ] CMD[/usr/bin/env apache2 -v | awk '/Server version:/ {print $3}']  CMD EXITCODE[0] CMD RUNTIME[0.0049s] STDOUT[ ] CMD[/usr/sbin/httpd -v | awk '/Server version:/ {print $3}']  CMD EXITCODE[0] CMD RUNTIME[0.0386s] STDOUT[ Apache/2.4.6 ] CMD[date "+%:z"]  CMD EXITCODE[0] CMD RUNTIME[0.0049s] STDOUT[ -05:00 ] SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);] SQL RUNTIME[0.00022507s] SQL[SELECT @@SESSION.sql_mode;] SQL RUNTIME[0.00012898s] SQL[SHOW VARIABLES LIKE 'character_set_connection'] SQL RUNTIME[0.00070596s] ##### Software versions #####   o OS  Linux 3.10.0-862.3.3.el7.x86_64 [amd64] (CentOS 7)  o Apache  2.4.6  o PHP  7.0.31 (OPcache: DISABLED)  o Python  2.7.5  o MySQL  5.5.56-MariaDB (extension: mysqli 5.5.56-MariaDB)  o SNMP  NET-SNMP 5.7.2  o RRDtool  1.6.0  o Fping  3.10 (IPv4 only) ##### Memory Limit #####   o PHP  1GB ##### MySQL mode #####   o MySQL  ##### Charset info #####   o PHP  UTF-8  o MySQL  utf8 ##### Timezones info #####   o Date  Friday, 08-Mar-19 11:09:31 EST  o PHP  -05:00  o MySQL  -05:00 SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'last_versioncheck';] SQL RUNTIME[0.00030208s] SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev';] SQL RUNTIME[0.00015211s] ##### Starting discovery run at 2019-03-08 11:09:31 #####  SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `device_id` = '204' AND `status` = '1' AND `poller_id` = '0' ORDER BY `last_discovered_timetaken` ASC] SQL RUNTIME[0.00056005s] CMD[/usr/bin/snmpget -v2c -c *** -Pu -OQUs -m SNMPv2-MIB -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp 'udp':'sfpdu04-01a':'161' sysObjectID.0 sysUpTime.0]  CMD EXITCODE[0] CMD RUNTIME[1.4428s] STDOUT[ sysObjectID.0 = enterprises.850.1 sysUpTime.0 = 379:17:52:27.69 ] SNMP STATUS[TRUE] SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '204'] SQL RUNTIME[0.00068402s] SQL[SELECT * FROM `observium_processes` WHERE `process_name` = 'discovery.php' AND `device_id` = '204'] SQL RUNTIME[0.00035286s] SQL[DELETE FROM `observium_processes` WHERE `process_id` = '18495117'] SQL RUNTIME[0.00041294s] SQL[INSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`) VALUES ('12129','discovery.php','12128','48','php ./discovery.php -h 204 -d','1552061371','204')] SQL RUNTIME[0.00046611s] ##### sfpdu04-01a [204] #####   o OS Type  poweralert  o SNMP Version  v2c  o Last discovery  2019-03-08 00:36:09  o Last duration  246.62 seconds ##### Module Start: os #####  CMD[/usr/bin/snmpget -v2c -c *** -Pu -OQUv -m SNMPv2-MIB -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp 'udp':'sfpdu04-01a':'161' sysDescr.0]  CMD EXITCODE[0] CMD RUNTIME[0.0405s] STDOUT[ POWERALERT 12 ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpget -v2c -c *** -Pu -OQUvn -m SNMPv2-MIB -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp 'udp':'sfpdu04-01a':'161' sysObjectID.0]  CMD EXITCODE[0] CMD RUNTIME[0.0477s] STDOUT[ .1.3.6.1.4.1.850.1 ] SNMP STATUS[TRUE] +-------------+--------------------+ | %WOID%n | | +-------------+--------------------+ | sysDescr | POWERALERT 12 | | sysObjectID | .1.3.6.1.4.1.850.1 | +-------------+--------------------+  o Detect OS matched (poweralert: Tripp Lite PowerAlert): +-------------+------------------------+--------------------+ | %WOID%n | %WMatched definition%n | | +-------------+------------------------+--------------------+ | sysObjectID | .1.3.6.1.4.1.850 | .1.3.6.1.4.1.850.1 | +-------------+------------------------+--------------------+  o sysORID table  CMD[/usr/bin/snmptranslate -On -m SNMPv2-MIB -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp 'SNMPv2-MIB::sysORID']  CMD EXITCODE[0] CMD RUNTIME[0.0285s] STDOUT[ .1.3.6.1.2.1.1.9.1.2 ] SNMP TRANSLATE (CMD): 'SNMPv2-MIB::sysORID' -> '.1.3.6.1.2.1.1.9.1.2' CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUsn -m SNMPv2-MIB -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp 'udp':'sfpdu04-01a':'161' .1.3.6.1.2.1.1.9.1.2]  CMD EXITCODE[0] CMD RUNTIME[0.0548s] STDOUT[ .1.3.6.1.2.1.1.9.1.2.1 = .1.3.6.1.6.3.1 .1.3.6.1.2.1.1.9.1.2.2 = .1.3.6.1.6.3.10.3.1.1 .1.3.6.1.2.1.1.9.1.2.3 = .1.3.6.1.6.3.11.3.1.1 .1.3.6.1.2.1.1.9.1.2.4 = .1.3.6.1.6.3.15.2.1.1 .1.3.6.1.2.1.1.9.1.2.5 = .1.3.6.1.6.3.16.2.1.1 ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m SNMPv2-MIB -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp 'udp':'sfpdu04-01a':'161' sysORDescr]  CMD EXITCODE[0] CMD RUNTIME[0.0476s] STDOUT[ sysORDescr.1 = The MIB Module from SNMPv2 entities sysORDescr.2 = SNMP Management Architecture MIB sysORDescr.3 = Message Processing and Dispatching MIB sysORDescr.4 = USM User MIB sysORDescr.5 = VACM MIB ] SNMP STATUS[TRUE] SNMPv2-MIB SNMP-FRAMEWORK-MIB SQL[DELETE FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '204' AND `attrib_type` = 'sysORID'] SQL RUNTIME[0.00034904s] %WOID%n %WMIB%n %WStatus%n .1.3.6.1.6.3.1 SNMPv2-MIB MIB already known through device mapping .1.3.6.1.6.3.10.3.1.1 SNMP-FRAMEWORK-MIB MIB already known through device mapping .1.3.6.1.6.3.11.3.1.1 MIB unused .1.3.6.1.6.3.15.2.1.1 MIB unused .1.3.6.1.6.3.16.2.1.1 MIB unused  o Duration  0.2864s ##### Module Start: ports #####   o Caching OIDs  ifDescr CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m IF-MIB -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp 'udp':'sfpdu04-01a':'161' ifDescr]  CMD EXITCODE[0] CMD RUNTIME[0.0576s] STDOUT[ ifDescr.1 = eth0 ifDescr.2 = LOOPBACK ] SNMP STATUS[TRUE] ifAlias CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m IF-MIB -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp 'udp':'sfpdu04-01a':'161' ifAlias]  CMD EXITCODE[0] CMD RUNTIME[9.7908s] STDOUT[ ] SNMP STATUS[TRUE] ifName CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m IF-MIB -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp 'udp':'sfpdu04-01a':'161' ifName]  CMD EXITCODE[1] CMD RUNTIME[6.044s] STDOUT[ ] STDERR[ Timeout: No Response from udp:sfpdu04-01a:161 ] SNMP STATUS[FALSE] SNMP ERROR[#1002 - Request timeout] ifType CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m IF-MIB -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp 'udp':'sfpdu04-01a':'161' ifType]  CMD EXITCODE[1] CMD RUNTIME[6.0442s] STDOUT[ ] STDERR[ Timeout: No Response from udp:sfpdu04-01a:161 ] SNMP STATUS[FALSE] SNMP ERROR[#1002 - Request timeout] ifOperStatus CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m IF-MIB -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp 'udp':'sfpdu04-01a':'161' ifOperStatus]  CMD EXITCODE[1] CMD RUNTIME[6.0435s] STDOUT[ ] STDERR[ Timeout: No Response from udp:sfpdu04-01a:161 ] SNMP STATUS[FALSE] SNMP ERROR[#1002 - Request timeout] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '204' AND `attrib_type` = 'sysORID'] SQL RUNTIME[0.00041199s] SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '204'] SQL RUNTIME[0.00024390s] SQL[SELECT * FROM `observium_attribs`] SQL RUNTIME[0.00013089s]   /u1/observium/includes/discovery/ports.inc.php:42  array( [1] => array( [ifDescr] => string(4) "eth0" ) [2] => array( [ifDescr] => string(8) "LOOPBACK" ) )  o Caching DB  SQL[SELECT * FROM `ports` WHERE `device_id` = '204'] SQL RUNTIME[0.00032496s] 2 ports  o Discovering ports  ignored (by empty ifType). SQL[UPDATE `ports` set `deleted` ='1',`ifLastChange` ='2019-03-08 11:10:01' WHERE `port_id` = '11061'] SQL RUNTIME[0.00036120s] SQL[INSERT INTO `eventlog` (`device_id`,`entity_id`,`entity_type`,`timestamp`,`severity`,`message`) VALUES ('204','11061','port',NOW(),'6','Interface was marked as DELETED')] SQL RUNTIME[0.00026608s] -Xignored (by empty ifType). SQL[UPDATE `ports` set `deleted` ='1',`ifLastChange` ='2019-03-08 11:10:01' WHERE `port_id` = '11062'] SQL RUNTIME[0.00023413s] SQL[INSERT INTO `eventlog` (`device_id`,`entity_id`,`entity_type`,`timestamp`,`severity`,`message`) VALUES ('204','11062','port',NOW(),'6','Interface was marked as DELETED')] SQL RUNTIME[0.00021791s] -X %WifIndex%n %WifDescr%n %WifName%n %WifAlias%n %WifType%n %WOper Status%n %WIgnored%n 1 eth0 ... %ryes%n 2 LOOPBACK ... %ryes%n  o Duration  27.9961s ##### Module Start: ports-stack #####  SQL[SELECT * FROM `ports_stack` WHERE `device_id` = '204'] SQL RUNTIME[0.00015211s] CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m IF-MIB -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp 'udp':'sfpdu04-01a':'161' ifStackStatus]  CMD EXITCODE[1] CMD RUNTIME[6.0333s] STDOUT[ ] STDERR[ Timeout: No Response from udp:sfpdu04-01a:161 ] SNMP STATUS[FALSE] SNMP ERROR[#1002 - Request timeout]  o Duration  6.0353s ##### Module Start: vlans #####  SQL[SELECT * FROM `vlans` WHERE `device_id` = '204';] SQL RUNTIME[0.00036502s] SQL[SELECT * FROM `ports_vlans` WHERE `device_id` = '204';] SQL RUNTIME[0.00013494s]  o Q-BRIDGE-MIB  CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m Q-BRIDGE-MIB -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp 'udp':'sfpdu04-01a':'161' dot1qVlanStaticName]  CMD EXITCODE[1] CMD RUNTIME[6.0346s] STDOUT[ ] STDERR[ Timeout: No Response from udp:sfpdu04-01a:161 ] SNMP STATUS[FALSE] SNMP ERROR[#1002 - Request timeout]  o Duration  6.0379s ##### Module Start: oids #####  SQL[SELECT * FROM `oids_entries` LEFT JOIN `oids` USING(`oid_id`) WHERE `device_id` = '204'] SQL RUNTIME[0.00038195s] SQL[SELECT * FROM `oids` WHERE `oid_autodiscover` = '1'] SQL RUNTIME[0.00011110s]  o Duration  0.001s ##### Module Start: ip-addresses #####   o IP-MIB  CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m IP-MIB -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp 'udp':'sfpdu04-01a':'161' ipAdEntIfIndex]  CMD EXITCODE[1] CMD RUNTIME[6.027s] STDOUT[ ] STDERR[ Timeout: No Response from udp:sfpdu04-01a:161 ] SNMP STATUS[FALSE] SNMP ERROR[#1002 - Request timeout] CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m IP-MIB -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp 'udp':'sfpdu04-01a':'161' ipAdEntNetMask]  CMD EXITCODE[1] CMD RUNTIME[6.0285s] STDOUT[ ] STDERR[ Timeout: No Response from udp:sfpdu04-01a:161 ] SNMP STATUS[FALSE] SNMP ERROR[#1002 - Request timeout] CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m IP-MIB -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp 'udp':'sfpdu04-01a':'161' ipAddressIfIndex]  CMD EXITCODE[1] CMD RUNTIME[6.0274s] STDOUT[ ] STDERR[ Timeout: No Response from udp:sfpdu04-01a:161 ] SNMP STATUS[FALSE] SNMP ERROR[#1002 - Request timeout]  o IPV6-MIB  CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUsb -m IPV6-MIB -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp 'udp':'sfpdu04-01a':'161' ipv6AddrEntry]  CMD EXITCODE[1] CMD RUNTIME[6.0243s] STDOUT[ ] STDERR[ Timeout: No Response from udp:sfpdu04-01a:161 ] SNMP STATUS[FALSE] SNMP ERROR[#1002 - Request timeout] SQL[SELECT * FROM `ipv4_addresses`  WHERE `device_id` = '204'] SQL RUNTIME[0.00033784s] SQL[SELECT * FROM `ipv6_addresses`  WHERE `device_id` = '204'] SQL RUNTIME[0.00013399s]  o Duration  24.1154s ##### Module Start: processors #####   o UCD-SNMP-MIB  SQL[SELECT EXISTS (SELECT 1 FROM `processors` WHERE `device_id` = '204' AND `processor_type` != 'ucd-old')] SQL RUNTIME[0.00022793s] CMD[/usr/bin/snmpget -v2c -c *** -Pu -OQUv -m UCD-SNMP-MIB -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp 'udp':'sfpdu04-01a':'161' ssCpuIdle.0]  CMD EXITCODE[1] CMD RUNTIME[6.0243s] STDOUT[ ] STDERR[ Timeout: No Response from udp:sfpdu04-01a:161. ] SNMP STATUS[FALSE] SNMP ERROR[#1002 - Request timeout]  o HOST-RESOURCES-MIB  CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp 'udp':'sfpdu04-01a':'161' hrDevice]  CMD EXITCODE[1] CMD RUNTIME[6.0263s] STDOUT[ ] STDERR[ Timeout: No Response from udp:sfpdu04-01a:161 ] SNMP STATUS[FALSE] SNMP ERROR[#1002 - Request timeout] CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp 'udp':'sfpdu04-01a':'161' hrProcessorLoad]  CMD EXITCODE[1] CMD RUNTIME[6.0264s] STDOUT[ ] STDERR[ Timeout: No Response from udp:sfpdu04-01a:161 ] SNMP STATUS[FALSE] SNMP ERROR[#1002 - Request timeout] SQL[SELECT * FROM `processors` WHERE `device_id` = '204'] SQL RUNTIME[0.00021291s]  o Duration  18.0835s ##### Module Start: mempools #####   o UCD-SNMP-MIB  CMD[/usr/bin/snmpget -v2c -c *** -Pu -OQUs -m UCD-SNMP-MIB -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp 'udp':'sfpdu04-01a':'161' memTotalReal.0 memAvailReal.0 memBuffer.0 memCached.0]  CMD EXITCODE[1] CMD RUNTIME[6.025s] STDOUT[ ] STDERR[ Timeout: No Response from udp:sfpdu04-01a:161. ] SNMP ERROR[#1002 - Request timeout] SNMP ERROR[#1002 - Request timeout] SNMP STATUS[FALSE]  o HOST-RESOURCES-MIB  CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp 'udp':'sfpdu04-01a':'161' hrStorageEntry]  CMD EXITCODE[1] CMD RUNTIME[6.0262s] STDOUT[ ] STDERR[ Timeout: No Response from udp:sfpdu04-01a:161 ] SNMP STATUS[FALSE] SNMP ERROR[#1002 - Request timeout] SQL[SELECT * FROM `mempools` WHERE `device_id` = '204'] SQL RUNTIME[0.00024700s]  o Duration  12.056s ##### Module Start: inventory #####   o ENTITY-MIB  ENTITY-MIB CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m ENTITY-MIB:CISCO-ENTITY-VENDORTYPE-OID-MIB -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp:/u1/observium/mibs/cisco 'udp':'sfpdu04-01a':'161' entPhysicalEntry]  CMD EXITCODE[1] CMD RUNTIME[6.1024s] STDOUT[ ] STDERR[ Timeout: No Response from udp:sfpdu04-01a:161 ] SNMP STATUS[FALSE] SNMP ERROR[#1002 - Request timeout]  o HOST-RESOURCES-MIB  CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp 'udp':'sfpdu04-01a':'161' hrDeviceEntry]  CMD EXITCODE[1] CMD RUNTIME[6.0256s] STDOUT[ ] STDERR[ Timeout: No Response from udp:sfpdu04-01a:161 ] SNMP STATUS[FALSE] SNMP ERROR[#1002 - Request timeout] CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp 'udp':'sfpdu04-01a':'161' hrProcessorEntry]  CMD EXITCODE[1] CMD RUNTIME[6.0282s] STDOUT[ ] STDERR[ Timeout: No Response from udp:sfpdu04-01a:161 ] SNMP STATUS[FALSE] SNMP ERROR[#1002 - Request timeout] SQL[SELECT * FROM `hrDevice` WHERE `device_id` = '204'] SQL RUNTIME[0.00045800s] SQL[SELECT * FROM `entPhysical` WHERE `device_id` = '204'] SQL RUNTIME[0.00041604s]  o Duration  18.1642s ##### Module Start: printersupplies #####  SQL[SELECT * FROM `printersupplies` WHERE `device_id` = '204'] SQL RUNTIME[0.00039506s]  o Duration  0.0016s ##### Module Start: sensors #####   o UPS-MIB  Caching OIDs: upsInput CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m UPS-MIB -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp 'udp':'sfpdu04-01a':'161' upsInput]  CMD EXITCODE[1] CMD RUNTIME[6.0412s] STDOUT[ ] STDERR[ Timeout: No Response from udp:sfpdu04-01a:161 ] SNMP STATUS[FALSE] SNMP ERROR[#1002 - Request timeout] upsOutput CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m UPS-MIB -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp 'udp':'sfpdu04-01a':'161' upsOutput]  CMD EXITCODE[1] CMD RUNTIME[6.0415s] STDOUT[ ] STDERR[ Timeout: No Response from udp:sfpdu04-01a:161 ] SNMP STATUS[FALSE] SNMP ERROR[#1002 - Request timeout] upsBypass CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m UPS-MIB -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp 'udp':'sfpdu04-01a':'161' upsBypass]  CMD EXITCODE[1] CMD RUNTIME[6.0433s] STDOUT[ ] STDERR[ Timeout: No Response from udp:sfpdu04-01a:161 ] SNMP STATUS[FALSE] SNMP ERROR[#1002 - Request timeout] CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m UPS-MIB -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp 'udp':'sfpdu04-01a':'161' upsBattery]  CMD EXITCODE[1] CMD RUNTIME[6.0356s] STDOUT[ ] STDERR[ Timeout: No Response from udp:sfpdu04-01a:161 ] SNMP STATUS[FALSE] SNMP ERROR[#1002 - Request timeout] CMD[/usr/bin/snmpget -v2c -c *** -Pu -OUqv -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp 'udp':'sfpdu04-01a':'161' .1.3.6.1.2.1.33.1.4.2.0]  CMD EXITCODE[1] CMD RUNTIME[6.0701s] STDOUT[ ] STDERR[ Timeout: No Response from udp:sfpdu04-01a:161. ] SNMP STATUS[FALSE] SNMP ERROR[#1002 - Request timeout] CMD[/usr/bin/snmpget -v2c -c *** -Pu -OUqv -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp 'udp':'sfpdu04-01a':'161' .1.3.6.1.2.1.33.1.5.1.0]  CMD EXITCODE[1] CMD RUNTIME[6.0693s] STDOUT[ ] STDERR[ Timeout: No Response from udp:sfpdu04-01a:161. ] SNMP STATUS[FALSE] SNMP ERROR[#1002 - Request timeout] CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m UPS-MIB -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp 'udp':'sfpdu04-01a':'161' upsTest]  CMD EXITCODE[1] CMD RUNTIME[6.0427s] STDOUT[ ] STDERR[ Timeout: No Response from udp:sfpdu04-01a:161 ] SNMP STATUS[FALSE] SNMP ERROR[#1002 - Request timeout]  o ENTITY-SENSOR-MIB  CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m ENTITY-MIB:ENTITY-SENSOR-MIB -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp 'udp':'sfpdu04-01a':'161' entPhySensorValue]  CMD EXITCODE[1] CMD RUNTIME[6.0439s] STDOUT[ ] STDERR[ Timeout: No Response from udp:sfpdu04-01a:161 ] SNMP STATUS[FALSE] SNMP ERROR[#1002 - Request timeout]  o TRIPPLITE-12X  tlEnvTemperatureF [ CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -Ih -OQUsb -m TRIPPLITE-12X -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp:/u1/observium/mibs/tripplite 'udp':'sfpdu04-01a':'161' tlEnvTemperatureF]  CMD EXITCODE[1] CMD RUNTIME[6.0484s] STDOUT[ ] STDERR[ Timeout: No Response from udp:sfpdu04-01a:161 ] SNMP STATUS[FALSE] SNMP ERROR[#1002 - Request timeout] CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -Ih -OQUsb -m TRIPPLITE-12X -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp:/u1/observium/mibs/tripplite 'udp':'sfpdu04-01a':'161' tlEnvTemperatureLowLimit]  CMD EXITCODE[1] CMD RUNTIME[6.0462s] STDOUT[ ] STDERR[ Timeout: No Response from udp:sfpdu04-01a:161 ] SNMP STATUS[FALSE] SNMP ERROR[#1002 - Request timeout] CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -Ih -OQUsb -m TRIPPLITE-12X -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp:/u1/observium/mibs/tripplite 'udp':'sfpdu04-01a':'161' tlEnvTemperatureHighLimit]  CMD EXITCODE[1] CMD RUNTIME[6.0456s] STDOUT[ ] STDERR[ Timeout: No Response from udp:sfpdu04-01a:161 ] SNMP STATUS[FALSE] SNMP ERROR[#1002 - Request timeout] ] tlEnvHumidity [ CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -Ih -OQUsb -m TRIPPLITE-12X -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp:/u1/observium/mibs/tripplite 'udp':'sfpdu04-01a':'161' tlEnvHumidity]  CMD EXITCODE[1] CMD RUNTIME[6.0452s] STDOUT[ ] STDERR[ Timeout: No Response from udp:sfpdu04-01a:161 ] SNMP STATUS[FALSE] SNMP ERROR[#1002 - Request timeout] CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -Ih -OQUsb -m TRIPPLITE-12X -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp:/u1/observium/mibs/tripplite 'udp':'sfpdu04-01a':'161' tlEnvHumidityLowLimit]  CMD EXITCODE[1] CMD RUNTIME[6.0486s] STDOUT[ ] STDERR[ Timeout: No Response from udp:sfpdu04-01a:161 ] SNMP STATUS[FALSE] SNMP ERROR[#1002 - Request timeout] CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -Ih -OQUsb -m TRIPPLITE-12X -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp:/u1/observium/mibs/tripplite 'udp':'sfpdu04-01a':'161' tlEnvHumidityHighLimit]  CMD EXITCODE[1] CMD RUNTIME[6.045s] STDOUT[ ] STDERR[ Timeout: No Response from udp:sfpdu04-01a:161 ] SNMP STATUS[FALSE] SNMP ERROR[#1002 - Request timeout] ] SQL[SELECT * FROM `sensors` WHERE `device_id` = '204' AND `sensor_class` = 'temperature' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00109100s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '204' AND `sensor_class` = 'humidity' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00039983s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '204' AND `sensor_class` = 'fanspeed' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00094008s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '204' AND `sensor_class` = 'dewpoint' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00039291s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '204' AND `sensor_class` = 'airflow' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00049210s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '204' AND `sensor_class` = 'voltage' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00043106s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '204' AND `sensor_class` = 'current' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00044489s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '204' AND `sensor_class` = 'charge' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00040507s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '204' AND `sensor_class` = 'power' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00039792s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '204' AND `sensor_class` = 'energy' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00041294s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '204' AND `sensor_class` = 'apower' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00041509s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '204' AND `sensor_class` = 'rpower' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00036407s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '204' AND `sensor_class` = 'crestfactor' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00035501s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '204' AND `sensor_class` = 'powerfactor' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00039315s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '204' AND `sensor_class` = 'impedance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00033808s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '204' AND `sensor_class` = 'resistance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00033712s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '204' AND `sensor_class` = 'frequency' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00036812s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '204' AND `sensor_class` = 'dbm' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00034404s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '204' AND `sensor_class` = 'snr' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00033689s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '204' AND `sensor_class` = 'dust' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00033188s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '204' AND `sensor_class` = 'sound' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00033712s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '204' AND `sensor_class` = 'capacity' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00046301s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '204' AND `sensor_class` = 'load' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00040507s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '204' AND `sensor_class` = 'runtime' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00040412s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '204' AND `sensor_class` = 'volume' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00034595s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '204' AND `sensor_class` = 'waterflow' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00033784s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '204' AND `sensor_class` = 'pressure' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00033712s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '204' AND `sensor_class` = 'velocity' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00031996s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '204' AND `sensor_class` = 'illuminance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00032115s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '204' AND `sensor_class` = 'wavelength' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00031304s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '204' AND `sensor_class` = 'counter' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00040507s] SQL[SELECT * FROM `status` WHERE `device_id` = '204' AND `poller_type` = 'snmp' AND `status_deleted` = '0'] SQL RUNTIME[0.00026584s]  o Duration  84.724s ##### Module Start: storage #####   o UCD-SNMP-MIB  CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m UCD-SNMP-MIB -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp 'udp':'sfpdu04-01a':'161' dskEntry]  CMD EXITCODE[1] CMD RUNTIME[6.0446s] STDOUT[ ] STDERR[ Timeout: No Response from udp:sfpdu04-01a:161 ] SNMP STATUS[FALSE] SNMP ERROR[#1002 - Request timeout]  o HOST-RESOURCES-MIB  SQL[SELECT * FROM `storage` WHERE `device_id` = '204'] SQL RUNTIME[0.00041604s]  o Duration  6.0506s ##### Module Start: neighbours #####   o LLDP-MIB  CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m LLDP-MIB -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp 'udp':'sfpdu04-01a':'161' lldpRemChassisIdSubtype]  CMD EXITCODE[1] CMD RUNTIME[6.056s] STDOUT[ ] STDERR[ Timeout: No Response from udp:sfpdu04-01a:161 ] SNMP STATUS[FALSE] SNMP ERROR[#1002 - Request timeout]  o CISCO-CDP-MIB  CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m CISCO-CDP-MIB -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp:/u1/observium/mibs/cisco 'udp':'sfpdu04-01a':'161' cdpCache]  CMD EXITCODE[1] CMD RUNTIME[6.1151s] STDOUT[ ] STDERR[ Timeout: No Response from udp:sfpdu04-01a:161 ] SNMP STATUS[FALSE] SNMP ERROR[#1002 - Request timeout]  o OSPF-MIB  SQL[SELECT * FROM `neighbours` WHERE `device_id` = '204'] SQL RUNTIME[0.00039005s]  o Duration  12.1806s ##### Module Start: arp-table #####  SQL[SELECT port_id, ifIndex FROM ports WHERE device_id = '204' GROUP BY port_id] SQL RUNTIME[0.00050902s] CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OXqs -m IP-MIB -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp 'udp':'sfpdu04-01a':'161' ipNetToPhysicalPhysAddress]  CMD EXITCODE[1] CMD RUNTIME[6.047s] STDOUT[ ] STDERR[ Timeout: No Response from udp:sfpdu04-01a:161 ] SNMP STATUS[FALSE] SNMP ERROR[#1002 - Request timeout] CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OXqs -m IPV6-MIB -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp 'udp':'sfpdu04-01a':'161' ipv6NetToMediaPhysAddress]  CMD EXITCODE[1] CMD RUNTIME[6.043s] STDOUT[ ] STDERR[ Timeout: No Response from udp:sfpdu04-01a:161 ] SNMP STATUS[FALSE] SNMP ERROR[#1002 - Request timeout] CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OXqs -m IP-MIB -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp 'udp':'sfpdu04-01a':'161' ipNetToMediaPhysAddress]  CMD EXITCODE[1] CMD RUNTIME[6.0472s] STDOUT[ ] STDERR[ Timeout: No Response from udp:sfpdu04-01a:161 ] SNMP STATUS[FALSE] SNMP ERROR[#1002 - Request timeout] SQL[SELECT mac_id, mac_address, ip_address, ip_version, ifIndex FROM ip_mac AS M  LEFT JOIN ports AS I ON M.port_id = I.port_id  WHERE I.device_id = '204'] SQL RUNTIME[0.00059080s]  o Duration  18.1463s ##### Module Start: junose-atm-vp #####   o Duration  0.0005s ##### Module Start: bgp-peers #####  CMD[/usr/bin/snmpget -v2c -c *** -Pu -OQUv -m BGP4-MIB -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp 'udp':'sfpdu04-01a':'161' bgpLocalAs.0]  CMD EXITCODE[1] CMD RUNTIME[6.0416s] STDOUT[ ] STDERR[ Timeout: No Response from udp:sfpdu04-01a:161. ] SNMP STATUS[FALSE] SNMP ERROR[#1002 - Request timeout] No BGP on host SQL[SELECT * FROM `bgpPeers` WHERE `device_id` = '204'] SQL RUNTIME[0.00051188s]  o Duration  6.0471s ##### Module Start: mac-accounting #####   o Duration  0.0005s ##### Module Start: cisco-vrf #####   o Duration  0.0007s ##### Module Start: sla #####   o DISMAN-PING-MIB  CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m DISMAN-PING-MIB -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp 'udp':'sfpdu04-01a':'161' pingCtlEntry]  CMD EXITCODE[1] CMD RUNTIME[6.0444s] STDOUT[ ] STDERR[ Timeout: No Response from udp:sfpdu04-01a:161 ] SNMP STATUS[FALSE] SNMP ERROR[#1002 - Request timeout] SQL[SELECT * FROM `slas` WHERE `device_id` = '204'] SQL RUNTIME[0.00048518s]  o Duration  6.0489s ##### Module Start: lsp #####   o Duration  0.0002s ##### Module Start: pseudowires #####  SQL[SELECT * FROM `pseudowires` WHERE `device_id` = '204'] SQL RUNTIME[0.00040793s]  o PW-STD-MIB  CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m PW-STD-MIB -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp 'udp':'sfpdu04-01a':'161' pwID]  CMD EXITCODE[1] CMD RUNTIME[6.0458s] STDOUT[ ] STDERR[ Timeout: No Response from udp:sfpdu04-01a:161 ] SNMP STATUS[FALSE] SNMP ERROR[#1002 - Request timeout]  o Duration  6.0505s ##### Module Start: virtual-machines #####   o Duration  0.0014s ##### Module Start: cisco-cbqos #####  SQL[SELECT * FROM `ports_cbqos` WHERE `device_id` = '204'] SQL RUNTIME[0.00041986s] CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m CISCO-CLASS-BASED-QOS-MIB -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp:/u1/observium/mibs/cisco 'udp':'sfpdu04-01a':'161' cbQosIfType]  CMD EXITCODE[1] CMD RUNTIME[6.1368s] STDOUT[ ] STDERR[ Timeout: No Response from udp:sfpdu04-01a:161 ] SNMP STATUS[FALSE] SNMP ERROR[#1002 - Request timeout] QoS not configured.  o Duration  6.1401s ##### Module Start: ucd-diskio #####  CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m UCD-DISKIO-MIB -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp 'udp':'sfpdu04-01a':'161' diskIOEntry]  CMD EXITCODE[1] CMD RUNTIME[6.0422s] STDOUT[ ] STDERR[ Timeout: No Response from udp:sfpdu04-01a:161 ] SNMP STATUS[FALSE] SNMP ERROR[#1002 - Request timeout] SQL[SELECT * FROM `ucd_diskio` WHERE `device_id` = '204'] SQL RUNTIME[0.00042701s]  o Duration  6.0455s ##### Module Start: wifi #####  SQL[SELECT * FROM `wifi_radios` WHERE `device_id` = '204'] SQL RUNTIME[0.00030303s] SQL[SELECT * FROM `wifi_wlans` WHERE `device_id` = '204'] SQL RUNTIME[0.00026321s] SQL[SELECT * FROM `wifi_aps` WHERE `device_id` = '204'] SQL RUNTIME[0.00028610s]  o Duration  0.0027s ##### Module Start: p2p-radios #####   o Duration  0.0002s ##### Module Start: graphs #####   o Duration  0.0009s Module [ services ] disabled globally. Module [ raid ] disabled globally. SQL[SELECT `device_state` FROM `devices` WHERE `device_id` = '204';] SQL RUNTIME[0.00039411s] SQL[UPDATE `devices` set `last_discovered` =NOW(),`type` ='power',`last_discovered_timetaken` ='264.2279',`force_discovery` ='0',`device_state` ='a:4:{s:15:\"poller_mod_perf\";a:27:{s:6:\"system\";d:0.25790000000000002;s:2:\"os\";d:1.4148000000000001;s:7:\"sensors\";d:0.00089999999999999998;s:6:\"status\";d:0.00029999999999999997;s:10:\"processors\";d:0.00059999999999999995;s:8:\"mempools\";d:0.00059999999999999995;s:7:\"storage\";d:0.00059999999999999995;s:8:\"netstats\";d:2.6496;s:6:\"hr-mib\";d:6.0288000000000004;s:7:\"ucd-mib\";d:2.9148000000000001;s:13:\"ipSystemStats\";d:0.1585;s:5:\"ports\";d:43.937199999999997;s:9:\"bgp-peers\";d:0.0654;s:15:\"printersupplies\";d:0.00040000000000000002;s:10:\"ucd-diskio\";d:0.00029999999999999997;s:4:\"wifi\";d:0.00020000000000000001;s:10:\"p2p-radios\";d:0.00069999999999999999;s:4:\"ospf\";d:5.1684000000000001;s:3:\"sla\";d:0.00069999999999999999;s:11:\"pseudowires\";d:0.00050000000000000001;s:14:\"mac-accounting\";d:0.00069999999999999999;s:12:\"loadbalancer\";d:0.00040000000000000002;s:15:\"entity-physical\";d:0.00020000000000000001;s:12:\"applications\";d:0.00050000000000000001;s:9:\"fdb-table\";d:16.508600000000001;s:6:\"graphs\";d:0.00050000000000000001;s:4:\"oids\";d:0.00040000000000000002;}s:17:\"poller_ports_perf\";a:1:{s:4:\"vlan\";d:26.994868040084839;}s:14:\"poller_history\";a:288:{i:1552061101;d:79.252200000000002;i:1552060801;d:75.931399999999996;i:1552060502;d:77.799599999999998;i:1552060201;d:78.433899999999994;i:1552059902;d:70.904200000000003;i:1552059602;d:79.632099999999994;i:1552059302;d:77.655000000000001;i:1552059002;d:73.319900000000004;i:1552058701;d:72.020200000000003;i:1552058401;d:101.1412;i:1552058102;d:76.991200000000006;i:1552057802;d:82.587400000000002;i:1552057502;d:87.441900000000004;i:1552057202;d:79.712500000000006;i:1552056901;d:96.487899999999996;i:1552056602;d:77.965400000000002;i:1552056302;d:75.1113;i:1552056001;d:82.268900000000002;i:1552055701;d:81.964799999999997;i:1552055402;d:89.814999999999998;i:1552055102;d:83.041200000000003;i:1552054802;d:67.842699999999994;i:1552054501;d:82.735900000000001;i:1552054201;d:74.523799999999994;i:1552053902;d:90.519099999999995;i:1552053602;d:81.806200000000004;i:1552053301;d:77.680700000000002;i:1552053002;d:74.0745;i:1552052701;d:88.876400000000004;i:1552052402;d:72.368300000000005;i:1552052101;d:88.614599999999996;i:1552051802;d:84.627300000000005;i:1552051502;d:75.032499999999999;i:1552051201;d:78.883600000000001;i:1552050901;d:69.1858;i:1552050602;d:73.674300000000002;i:1552050301;d:77.270200000000003;i:1552050002;d:71.568100000000001;i:1552049701;d:67.691599999999994;i:1552049402;d:88.430199999999999;i:1552049102;d:69.978200000000001;i:1552048802;d:85.2089;i:1552048502;d:71.790999999999997;i:1552048201;d:89.278599999999997;i:1552047902;d:69.996300000000005;i:1552047602;d:81.2928;i:1552047301;d:83.895099999999999;i:1552047002;d:64.480099999999993;i:1552046702;d:84.023300000000006;i:1552046402;d:77.864599999999996;i:1552046102;d:75.576499999999996;i:1552045801;d:88.499399999999994;i:1552045502;d:72.403700000000001;i:1552045202;d:83.660399999999996;i:1552044902;d:74.809200000000004;i:1552044602;d:81.834500000000006;i:1552044301;d:65.745000000000005;i:1552044002;d:74.619399999999999;i:1552043702;d:78.361199999999997;i:1552043401;d:75.7864;i:1552043102;d:56.023800000000001;i:1552042802;d:68.020399999999995;i:1552042501;d:72.104399999999998;i:1552042201;d:77.203299999999999;i:1552041902;d:79.618700000000004;i:1552041601;d:74.881399999999999;i:1552041302;d:83.416499999999999;i:1552041002;d:75.795100000000005;i:1552040701;d:90.372200000000007;i:1552040402;d:69.835300000000004;i:1552040102;d:75.850999999999999;i:1552039801;d:85.677899999999994;i:1552039502;d:77.907200000000003;i:1552039202;d:70.969200000000001;i:1552038902;d:79.042199999999994;i:1552038602;d:71.352800000000002;i:1552038302;d:84.876400000000004;i:1552038002;d:78.269599999999997;i:1552037702;d:86.809200000000004;i:1552037402;d:82.700100000000006;i:1552037101;d:68.966800000000006;i:1552036802;d:84.098600000000005;i:1552036501;d:72.491900000000001;i:1552036201;d:77.156899999999993;i:1552035902;d:82.740099999999998;i:1552035602;d:86.754400000000004;i:1552035301;d:80.962400000000002;i:1552035002;d:78.503600000000006;i:1552034702;d:86.186400000000006;i:1552034402;d:78.0501;i:1552034101;d:71.6922;i:1552033802;d:85.047399999999996;i:1552033501;d:93.264200000000002;i:1552033201;d:72.651799999999994;i:1552032902;d:74.984800000000007;i:1552032602;d:82.448400000000007;i:1552032301;d:86.1815;i:1552032002;d:78.204700000000003;i:1552031701;d:79.526799999999994;i:1552031402;d:74.912199999999999;i:1552031102;d:85.140100000000004;i:1552030802;d:77.9161;i:1552030502;d:80.329099999999997;i:1552030201;d:68.394900000000007;i:1552029902;d:71.559299999999993;i:1552029602;d:67.165300000000002;i:1552029301;d:78.622100000000003;i:1552029002;d:59.869399999999999;i:1552028702;d:81.196299999999994;i:1552028402;d:86.761899999999997;i:1552028101;d:89.533600000000007;i:1552027802;d:80.812700000000007;i:1552027502;d:77.269000000000005;i:1552027201;d:82.445300000000003;i:1552026901;d:74.942300000000003;i:1552026606;d:85.908500000000004;i:1552026301;d:92.9589;i:1552026002;d:72.641800000000003;i:1552025702;d:73.538600000000002;i:1552025401;d:69.427199999999999;i:1552025115;d:72.024199999999993;i:1552024802;d:67.779399999999995;i:1552024501;d:85.937399999999997;i:1552024202;d:77.969499999999996;i:1552023901;d:85.052000000000007;i:1552023602;d:73.215599999999995;i:1552023001;d:79.373800000000003;i:1552022702;d:76.890600000000006;i:1552022402;d:77.129400000000004;i:1552022102;d:80.4893;i:1552021802;d:75.891800000000003;i:1552021501;d:90.748500000000007;i:1552021202;d:83.971699999999998;i:1552020902;d:89.908900000000003;i:1552020602;d:75.291700000000006;i:1552020302;d:86.660499999999999;i:1552020002;d:63.585999999999999;i:1552019701;d:69.024100000000004;i:1552019402;d:75.121899999999997;i:1552019102;d:70.295000000000002;i:1552018801;d:78.572299999999998;i:1552018501;d:91.709100000000007;i:1552018202;d:83.889799999999994;i:1552017902;d:77.658199999999994;i:1552017601;d:66.638900000000007;i:1552017301;d:75.446100000000001;i:1552017001;d:65.316999999999993;i:1552016702;d:100.6622;i:1552016402;d:85.230999999999995;i:1552016102;d:95.829999999999998;i:1552015802;d:73.338899999999995;i:1552015502;d:100.09010000000001;i:1552015202;d:78.796400000000006;i:1552014901;d:79.260499999999993;i:1552014601;d:71.201899999999995;i:1552014302;d:77.026799999999994;i:1552014002;d:73.285499999999999;i:1552013702;d:82.287099999999995;i:1552013402;d:85.039500000000004;i:1552013102;d:78.654399999999995;i:1552012802;d:75.649900000000002;i:1552012502;d:69.733099999999993;i:1552012202;d:81.332999999999998;i:1552011902;d:70.233599999999996;i:1552011602;d:77.380300000000005;i:1552011302;d:73.740200000000002;i:1552011001;d:75.606399999999994;i:1552010702;d:89.626599999999996;i:1552010401;d:74.548199999999994;i:1552010101;d:61.8583;i:1552009802;d:80.060400000000001;i:1552009502;d:81.679100000000005;i:1552009201;d:64.960599999999999;i:1552008901;d:81.195999999999998;i:1552008601;d:78.603200000000001;i:1552008302;d:83.282300000000006;i:1552008001;d:71.588300000000004;i:1552007701;d:82.023700000000005;i:1552007402;d:88.8386;i:1552007102;d:73.262900000000002;i:1552006802;d:95.506299999999996;i:1552006502;d:83.137100000000004;i:1552006201;d:79.093599999999995;i:1552005901;d:75.247;i:1552005602;d:98.2059;i:1552005302;d:79.963200000000001;i:1552005001;d:84.8232;i:1552004702;d:76.899500000000003;i:1552004402;d:55.388199999999998;i:1552004102;d:76.771500000000003;i:1552003801;d:84.589100000000002;i:1552003501;d:65.391400000000004;i:1552003201;d:79.161600000000007;i:1552002901;d:84.986000000000004;i:1552002602;d:89.299899999999994;i:1552002301;d:81.516499999999994;i:1552002002;d:76.834000000000003;i:1552001401;d:75.692999999999998;i:1552001102;d:71.084599999999995;i:1552000801;d:75.221800000000002;i:1552000501;d:68.753200000000007;i:1552000202;d:74.486999999999995;i:1551999902;d:76.501999999999995;i:1551999601;d:81.776600000000002;i:1551999302;d:84.651399999999995;i:1551999001;d:76.566800000000001;i:1551998701;d:75.721800000000002;i:1551998401;d:85.042699999999996;i:1551998102;d:78.023200000000003;i:1551997802;d:77.093500000000006;i:1551997502;d:96.682199999999995;i:1551997201;d:88.473699999999994;i:1551996901;d:87.741699999999994;i:1551996601;d:78.985699999999994;i:1551996302;d:91.447500000000005;i:1551996001;d:89.299499999999995;i:1551995701;d:66.274699999999996;i:1551995402;d:88.365799999999993;i:1551995101;d:77.324200000000005;i:1551994801;d:88.903800000000004;i:1551994502;d:65.381;i:1551994202;d:81.7577;i:1551993901;d:85.083500000000001;i:1551993602;d:71.858099999999993;i:1551993302;d:77.005300000000005;i:1551993002;d:96.504999999999995;i:1551992702;d:91.289599999999993;i:1551992402;d:88.985600000000005;i:1551992101;d:76.205299999999994;i:1551991802;d:86.104799999999997;i:1551991502;d:83.607299999999995;i:1551991202;d:87.987499999999997;i:1551990901;d:69.346400000000003;i:1551990601;d:75.168099999999995;i:1551990302;d:77.484099999999998;i:1551990002;d:81.331599999999995;i:1551989701;d:79.903300000000002;i:1551989402;d:103.60169999999999;i:1551989102;d:82.826800000000006;i:1551988801;d:87.895600000000002;i:1551988502;d:76.690700000000007;i:1551988201;d:73.373400000000004;i:1551987902;d:72.038499999999999;i:1551987601;d:87.794799999999995;i:1551987302;d:74.905500000000004;i:1551987002;d:87.980400000000003;i:1551986702;d:71.736900000000006;i:1551986402;d:71.071799999999996;i:1551986101;d:71.255300000000005;i:1551985802;d:70.112799999999993;i:1551985502;d:68.801500000000004;i:1551985202;d:69.551400000000001;i:1551984901;d:75.787800000000004;i:1551984602;d:66.960999999999999;i:1551984302;d:82.325800000000001;i:1551984001;d:86.141599999999997;i:1551983701;d:93.513400000000004;i:1551983402;d:72.475899999999996;i:1551983102;d:82.489400000000003;i:1551982801;d:82.763099999999994;i:1551982502;d:70.128699999999995;i:1551982202;d:84.400800000000004;i:1551981902;d:77.539199999999994;i:1551981602;d:79.658900000000003;i:1551981302;d:88.825800000000001;i:1551981002;d:77.439499999999995;i:1551980702;d:79.441800000000001;i:1551980402;d:79.912400000000005;i:1551980102;d:71.7012;i:1551979802;d:81.629199999999997;i:1551979502;d:75.490799999999993;i:1551979202;d:83.661699999999996;i:1551978902;d:90.841200000000001;i:1551978602;d:73.2988;i:1551978302;d:69.797499999999999;i:1551978002;d:66.137;i:1551977702;d:66.2577;i:1551977401;d:70.150999999999996;i:1551977102;d:71.2821;i:1551976802;d:79.259500000000003;i:1551976502;d:68.873199999999997;i:1551976201;d:88.649600000000007;i:1551975902;d:79.994;i:1551975601;d:76.193700000000007;i:1551975301;d:83.294200000000004;i:1551975002;d:81.737799999999993;i:1551974702;d:82.821399999999997;i:1551974402;d:77.776300000000006;}s:17:\"discovery_history\";a:100:{i:1552061373;d:264.22789999999998;i:1552023122;d:246.6224;i:1552001522;d:264.99239999999998;i:1551936723;d:265.3193;i:1551915122;d:264.5403;i:1551893527;d:263.47120000000001;i:1551871923;d:259.8433;i:1551850323;d:264.60059999999999;i:1551828723;d:260.90170000000001;i:1551807122;d:263.5181;i:1551785523;d:263.31020000000001;i:1551763922;d:271.69159999999999;i:1551742322;d:263.53070000000002;i:1551720723;d:264.91910000000001;i:1551699123;d:293.81619999999998;i:1551677522;d:263.58949999999999;i:1551655922;d:263.18200000000002;i:1551634323;d:263.10120000000001;i:1551591123;d:271.19200000000001;i:1551569523;d:265.19959999999998;i:1551547922;d:263.77530000000002;i:1551483124;d:254.6377;i:1551439927;d:263.9796;i:1551396722;d:246.10210000000001;i:1551375122;d:261.7296;i:1551353522;d:244.26329999999999;i:1551331924;d:257.05059999999997;i:1551288722;d:263.55509999999998;i:1551267122;d:263.32420000000002;i:1551245522;d:242.0155;i:1551223922;d:270.18950000000001;i:1551180722;d:264.07639999999998;i:1551159126;d:291.56220000000002;i:1551137528;d:263.28870000000001;i:1551115923;d:280.8492;i:1551072726;d:264.51389999999998;i:1551051126;d:265.4597;i:1551029522;d:265.0967;i:1551007926;d:259.69209999999998;i:1550964722;d:264.48239999999998;i:1550899923;d:299.05779999999999;i:1550856722;d:265.49369999999999;i:1550835122;d:289.7998;i:1550770322;d:263.88630000000001;i:1550748723;d:264.30849999999998;i:1550727122;d:263.45639999999997;i:1550705522;d:263.53649999999999;i:1550683922;d:244.369;i:1550662322;d:280.5111;i:1550619122;d:261.84199999999998;i:1550597522;d:263.97829999999999;i:1550575922;d:290.0444;i:1550554326;d:265.00209999999998;i:1550532728;d:263.9409;i:1550489522;d:283.2593;i:1550467924;d:267.89499999999998;i:1550446322;d:264.3175;i:1550403122;d:262.7826;i:1550381523;d:263.77589999999998;i:1550359922;d:254.38980000000001;i:1550338322;d:243.999;i:1550316722;d:242.46510000000001;i:1550208722;d:279.50220000000002;i:1550165523;d:265.3159;i:1550143923;d:264.09379999999999;i:1550122322;d:263.88189999999997;i:1550100727;d:299.79079999999999;i:1550057522;d:265.02080000000001;i:1550014322;d:289.83999999999997;i:1549992723;d:264.67700000000002;i:1549971122;d:280.32159999999999;i:1549949524;d:265.37509999999997;i:1549927922;d:263.69450000000001;i:1549884723;d:263.33359999999999;i:1549863128;d:264.60430000000002;i:1549841523;d:293.02929999999998;i:1549819922;d:263.4667;i:1549798323;d:260.12509999999997;i:1549776722;d:263.36149999999998;i:1549755122;d:263.93000000000001;i:1549733528;d:265.42669999999998;i:1549711923;d:263.3931;i:1549690326;d:264.32100000000003;i:1549647122;d:265.34530000000001;i:1549603922;d:294.03930000000003;i:1549582322;d:263.32380000000001;i:1549560723;d:297.33069999999998;i:1549539124;d:262.35969999999998;i:1549517522;d:268.41050000000001;i:1549474322;d:263.85520000000002;i:1549452722;d:263.22489999999999;i:1549431123;d:270.12389999999999;i:1549409526;d:259.58569999999997;i:1549387922;d:258.62009999999998;i:1549366323;d:263.49349999999998;i:1549301527;d:268.92790000000002;i:1549279923;d:269.21600000000001;i:1549236727;d:229.46279999999999;i:1549215127;d:265.60629999999998;i:1549193523;d:250.99879999999999;}}' WHERE `device_id` = '204'] SQL RUNTIME[0.00132108s] ##### sfpdu04-01a [204] completed discovery modules at 2019-03-08 11:13:57 #####   o Discovery time  264.2279 seconds SQL[DELETE FROM `observium_processes` WHERE `process_pid` = '12129' AND `process_name` = 'discovery.php' AND `device_id` = '204'] SQL RUNTIME[0.00056911s] SQL[SELECT * FROM `groups` ORDER BY `entity_type`] SQL RUNTIME[0.00031805s] SQL[SELECT * FROM `groups_assoc`] SQL RUNTIME[0.00020719s] SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`hostname`, "") LIKE '%syf%')] SQL RUNTIME[0.00042987s] SQL[SELECT * FROM `group_table` WHERE `group_id` = '1'] SQL RUNTIME[0.00025296s] SQL[SELECT * FROM `alert_tests` WHERE 1] SQL RUNTIME[0.00032592s] Cached 22 alert rules. SQL[SELECT * FROM `alert_assoc`] SQL RUNTIME[0.00041604s] SQL[SELECT `processor_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `processors` LEFT JOIN `devices` ON (`processors`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1) AND ( 1)))] SQL RUNTIME[0.00131011s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '1'] SQL RUNTIME[0.00213909s] SQL[SELECT `device_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `devices` WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1) AND ( 1)))] SQL RUNTIME[0.00114393s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '2'] SQL RUNTIME[0.00195479s] SQL[SELECT `port_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1) AND ( 1 AND `ifType` = 'ethernetCsmacd'))) AND `deleted` != '1'] SQL RUNTIME[0.03278518s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '3'] SQL RUNTIME[0.02593112s] SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`) VALUES ('203','port','11060','3')] SQL RUNTIME[0.00046301s] SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`) VALUES ('271','port','11979','3')] SQL RUNTIME[0.00031519s] SQL[DELETE FROM `alert_table` WHERE alert_test_id = '3' AND entity_id = '11062'] SQL RUNTIME[0.02123308s] SQL[SELECT `port_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND IFNULL(`devices`.`hostname`, "") LIKE 'ore%') AND ( 1 AND `ifType` = 'ethernetCsmacd'))) AND `deleted` != '1'] SQL RUNTIME[0.00335789s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '5'] SQL RUNTIME[0.00189090s] SQL[SELECT `port_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND IFNULL(`devices`.`hostname`, "") LIKE 'sfrcore01') AND ( 1 AND `ifName` = 'Gi2/1')) OR (( 1 AND IFNULL(`devices`.`hostname`, "") LIKE 'aurcore01') AND ( 1 AND `ifName` = 'Gi3/8'))) AND `deleted` != '1'] SQL RUNTIME[0.00162387s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '6'] SQL RUNTIME[0.00017405s] SQL[SELECT `port_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND IFNULL(`devices`.`hostname`, "") LIKE 'sfrcore01') AND ( 1 AND `ifName` = 'Gi7/3')) OR (( 1 AND IFNULL(`devices`.`hostname`, "") LIKE 'aurcore01') AND ( 1 AND `ifName` = 'Gi3/3'))) AND `deleted` != '1'] SQL RUNTIME[0.00156689s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '8'] SQL RUNTIME[0.00017214s] SQL[SELECT `port_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND IFNULL(`devices`.`hostname`, "") LIKE 'syfsouthfield') AND ( 1 AND `ifName` = 'Gi0/0/0')) OR (( 1 AND IFNULL(`devices`.`hostname`, "") LIKE 'syfaurora') AND ( 1 AND `ifName` = 'Gi0/0/0')) OR (( 1 AND IFNULL(`devices`.`hostname`, "") LIKE 'aurcsc07') AND ( 1 AND `ifName` = 'Gi0/1')) OR (( 1 AND IFNULL(`devices`.`hostname`, "") LIKE 'sfrcsc07') AND ( 1 AND `ifName` = 'Gi0/1'))) AND `deleted` != '1'] SQL RUNTIME[0.00088692s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '10'] SQL RUNTIME[0.00016379s] SQL[SELECT `port_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1) AND ( 1 AND IFNULL(`port_descr_descr`, "") LIKE '%Level 3 Intersite%'))) AND `deleted` != '1'] SQL RUNTIME[0.01693320s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '13'] SQL RUNTIME[0.00016689s] SQL[SELECT `processor_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `processors` LEFT JOIN `devices` ON (`processors`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND IFNULL(`devices`.`hostname`, "") LIKE '%-fw1%') AND ( 1)) OR (( 1 AND IFNULL(`devices`.`hostname`, "") LIKE '%-fw2%') AND ( 1)))] SQL RUNTIME[0.00057817s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '16'] SQL RUNTIME[0.00015283s] SQL[SELECT `port_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1) AND ( 1 AND `ifType` = 'ethernetCsmacd'))) AND `deleted` != '1'] SQL RUNTIME[0.01474905s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '19'] SQL RUNTIME[0.01791787s] SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`) VALUES ('203','port','11060','19')] SQL RUNTIME[0.00040603s] SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`) VALUES ('271','port','11979','19')] SQL RUNTIME[0.00017500s] SQL[DELETE FROM `alert_table` WHERE alert_test_id = '19' AND entity_id = '11062'] SQL RUNTIME[0.01602578s] SQL[SELECT `port_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND IFNULL(`devices`.`hostname`, "") LIKE 'ore%') AND ( 1 AND `ifType` = 'ethernetCsmacd'))) AND `deleted` != '1'] SQL RUNTIME[0.00286388s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '20'] SQL RUNTIME[0.00161600s] SQL[SELECT `bgpPeer_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `bgpPeers` LEFT JOIN `devices` ON (`bgpPeers`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1) AND ( 1)))] SQL RUNTIME[0.00033879s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '22'] SQL RUNTIME[0.00057101s] SQL[SELECT `port_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND IFNULL(`devices`.`hostname`, "") LIKE 'sfredge01') AND ( 1 AND `ifName` = 'Gi0/1')) OR (( 1 AND IFNULL(`devices`.`hostname`, "") LIKE 'sfredge02') AND ( 1 AND `ifName` = 'Gi1/0/4')) OR (( 1 AND IFNULL(`devices`.`hostname`, "") LIKE 'aurcore01') AND ( 1 AND `ifName` = 'Gi5/2')) OR (( 1 AND IFNULL(`devices`.`hostname`, "") LIKE 'aurcore02') AND ( 1 AND `ifName` = 'Gi5/2')) OR (( 1 AND IFNULL(`devices`.`hostname`, "") LIKE 'cljsw0') AND ( 1 AND `ifName` = 'ge-1/0/45')) OR (( 1 AND IFNULL(`devices`.`hostname`, "") LIKE 'cljsw0') AND ( 1 AND `ifName` = 'ge-0/0/45'))) AND `deleted` != '1'] SQL RUNTIME[0.00274897s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '23'] SQL RUNTIME[0.00015616s] SQL[SELECT `port_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND IFNULL(`devices`.`hostname`, "") LIKE 'dfredge04a') AND ( 1 AND `ifName` = 'Gi1/0/23'))) AND `deleted` != '1'] SQL RUNTIME[0.00060701s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '24'] SQL RUNTIME[0.00012517s] SQL[SELECT `port_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1) AND ( 1 AND `ifType` = 'ethernetCsmacd'))) AND `deleted` != '1'] SQL RUNTIME[0.01809001s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '25'] SQL RUNTIME[0.01824713s] SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`) VALUES ('203','port','11060','25')] SQL RUNTIME[0.00036311s] SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`) VALUES ('271','port','11979','25')] SQL RUNTIME[0.00018406s] SQL[DELETE FROM `alert_table` WHERE alert_test_id = '25' AND entity_id = '11062'] SQL RUNTIME[0.01590085s] SQL[SELECT `port_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND IFNULL(`devices`.`hostname`, "") LIKE 'aurcsc30') AND ( 1 AND `ifName` = 'Gi0/1/1')) OR (( 1 AND IFNULL(`devices`.`hostname`, "") LIKE 'sfrcsc30') AND ( 1 AND `ifName` = 'Gi0/1/0'))) AND `deleted` != '1'] SQL RUNTIME[0.00096202s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '26'] SQL RUNTIME[0.00014305s] SQL[SELECT `port_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND IFNULL(`devices`.`hostname`, "") LIKE 'syfphoenix-backup') AND ( 1 AND `ifName` = 'Gi0/1/1')) OR (( 1 AND IFNULL(`devices`.`hostname`, "") LIKE 'syfdallas-backup') AND ( 1 AND `ifName` = 'Gi0/1/1')) OR (( 1 AND IFNULL(`devices`.`hostname`, "") LIKE 'syfsouthfield') AND ( 1 AND `ifName` = 'Gi0/1/1')) OR (( 1 AND IFNULL(`devices`.`hostname`, "") LIKE 'syfaurora') AND ( 1 AND `ifName` = 'Gi0/1/1'))) AND `deleted` != '1'] SQL RUNTIME[0.00083089s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '27'] SQL RUNTIME[0.00013995s] SQL[SELECT `port_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND IFNULL(`devices`.`hostname`, "") LIKE 'sfrccs') AND ( 1 AND `ifName` = 'xe-0/2/0')) OR (( 1 AND IFNULL(`devices`.`hostname`, "") LIKE 'sfrccs') AND ( 1 AND `ifName` = 'xe-0/2/1')) OR (( 1 AND IFNULL(`devices`.`hostname`, "") LIKE 'sfrccs') AND ( 1 AND `ifName` = 'xe-1/2/0')) OR (( 1 AND IFNULL(`devices`.`hostname`, "") LIKE 'aujsw2') AND ( 1 AND `ifName` = 'xe-0/2/0')) OR (( 1 AND IFNULL(`devices`.`hostname`, "") LIKE 'aujsw2') AND ( 1 AND `ifName` = 'xe-0/2/1')) OR (( 1 AND IFNULL(`devices`.`hostname`, "") LIKE 'aujsw2') AND ( 1 AND `ifName` = 'xe-1/2/1')) OR (( 1 AND IFNULL(`devices`.`hostname`, "") LIKE 'aujsw2') AND ( 1 AND `ifName` = 'xe-1/2/0'))) AND `deleted` != '1'] SQL RUNTIME[0.00279307s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '28'] SQL RUNTIME[0.00012112s] SQL[SELECT `processor_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `processors` LEFT JOIN `devices` ON (`processors`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND IFNULL(`devices`.`hostname`, "") LIKE '%jfw%') AND ( 1)))] SQL RUNTIME[0.00050116s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '30'] SQL RUNTIME[0.00015998s] SQL[SELECT `port_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1) AND ( 1 AND `port_descr_type` = 'transit'))) AND `deleted` != '1'] SQL RUNTIME[0.01432014s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '31'] SQL RUNTIME[0.00018001s] SQL[SELECT `port_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1) AND ( 1 AND `port_descr_type` = 'core'))) AND `deleted` != '1'] SQL RUNTIME[0.01029301s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '32'] SQL RUNTIME[0.00031209s] SQL[SELECT `port_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1) AND ( 1 AND `port_descr_type` = 'cust'))) AND `deleted` != '1'] SQL RUNTIME[0.01033092s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '33'] SQL RUNTIME[0.00053906s] ##### Finished discovery run at 2019-03-08 11:13:57 #####  ./discovery.php: sfpdu04-01a - 1 devices discovered in 266.1 secs SQL[SELECT * FROM `observium_processes` WHERE `process_start` < '1552046971'] SQL RUNTIME[0.00009894s] NOTE, $config['snmp']['hide_auth'] is set to TRUE, snmp community and snmp v3 auth hidden from debug output.  o Devices Discovered  1  o Discovery Time  266.1 secs  o Memory usage  34MB (peak: 34MB)  o MySQL Usage  Cell[6/0.002s] Row[5/0.003s] Rows[115/0.316s] Column[0/0s] Update[3/0.003s] Insert[9/0.004s] Delete[6/0.056s]  o RRDTool Usage