So, I’ve had some issues recently that caused me to wipe my Observium install. I drop’d the DB, rm’d the RRDs and followed the install instructions for creating a new DB and getting things going again.
I add a device, run a discovery.php -h new, and everything seems ok… but once I let Observium poll it, or do so manually using poller.php it starts deleting all my interfaces…
I’ve included the output below, with a debug turned on for the poller process.
Thanks for your help.
-Tony
root@netmon:/opt/observium# ./add_device.php ea-core XXXXXXXXX Observium v0.14.4.5229 Add Device(s)
Try to add ea-core: Trying v2c community XXXXXXXXX ... Now discovering ea-core (id = 8) ea-core 8 generic Ports : Vl1(1)[730] Vl2(2)[731] Vl3(3)[732] Vl4(4)[733] Vl5(5)[734] Vl6(6)[735] Vl7(7)[736] Vl8(8)[737] Vl9(9)[738] Vl10(10)[739] Vl11(11)[740] Vl13(13)[741] Vl14(14)[742] Vl18(18)[743] Vl19(19)[744] Vl20(20)[745] Vl21(21)[746] Vl22(22)[747] Vl23(23)[748] Vl24(24)[749] Vl32(32)[750] Vl47(47)[751] Vl62(62)[752] Vl63(63)[753] Vl88(88)[754] Vl93(93)[755] Vl94(94)[756] Vl111(111)[757] Vl191(191)[758] Vl193(193)[759] Vl199(199)[760] Vl200(200)[761] Vl248(248)[762] Vl901(901)[763] Vl902(902)[764] Po1(5001)[765] Po2(5002)[766] Po5(5005)[767] Po10(5010)[768] Po11(5011)[769] Po16(5016)[770] Po21(5021)[771] Po22(5022)[772] StackPort1(5179)[773] StackSub-St1-1(5180)[774] StackSub-St1-2(5181)[775] StackPort2(5182)[776] StackSub-St2-1(5183)[777] StackSub-St2-2(5184)[778] StackPort3(5185)[779] StackSub-St3-1(5186)[780] StackSub-St3-2(5187)[781] StackPort4(5188)[782] StackSub-St4-1(5189)[783] StackSub-St4-2(5190)[784] Gi1/0/1(10101)[785] Gi1/0/2(10102)[786] Gi1/0/3(10103)[787] Gi1/0/4(10104)[788] Gi1/0/5(10105)[789] Gi1/0/6(10106)[790] Gi1/0/7(10107)[791] Gi1/0/8(10108)[792] Gi1/0/9(10109)[793] Gi1/0/10(10110)[794] Gi1/0/11(10111)[795] Gi1/0/12(10112)[796] Gi1/0/13(10113)[797] Gi1/0/14(10114)[798] Gi1/0/15(10115)[799] Gi1/0/16(10116)[800] Gi1/0/17(10117)[801] Gi1/0/18(10118)[802] Gi1/0/19(10119)[803] Gi1/0/20(10120)[804] Gi1/0/21(10121)[805] Gi1/0/22(10122)[806] Gi1/0/23(10123)[807] Gi1/0/24(10124)[808] Gi1/0/25(10125)[809] Gi1/0/26(10126)[810] Gi1/0/27(10127)[811] Gi1/0/28(10128)[812] Gi2/0/1(10601)[813] Gi2/0/2(10602)[814] Gi2/0/3(10603)[815] Gi2/0/4(10604)[816] Gi2/0/5(10605)[817] Gi2/0/6(10606)[818] Gi2/0/7(10607)[819] Gi2/0/8(10608)[820] Gi2/0/9(10609)[821] Gi2/0/10(10610)[822] Gi2/0/11(10611)[823] Gi2/0/12(10612)[824] Gi2/0/13(10613)[825] Gi2/0/14(10614)[826] Gi2/0/15(10615)[827] Gi2/0/16(10616)[828] Gi2/0/17(10617)[829] Gi2/0/18(10618)[830] Gi2/0/19(10619)[831] Gi2/0/20(10620)[832] Gi2/0/21(10621)[833] Gi2/0/22(10622)[834] Gi2/0/23(10623)[835] Gi2/0/24(10624)[836] Gi2/0/25(10625)[837] Gi2/0/26(10626)[838] Gi2/0/27(10627)[839] Gi2/0/28(10628)[840] Gi3/0/1(11101)[841] Gi3/0/2(11102)[842] Gi3/0/3(11103)[843] Gi3/0/4(11104)[844] Gi3/0/5(11105)[845] Gi3/0/6(11106)[846] Gi3/0/7(11107)[847] Gi3/0/8(11108)[848] Gi3/0/9(11109)[849] Gi3/0/10(11110)[850] Gi3/0/11(11111)[851] Gi3/0/12(11112)[852] Gi4/0/1(11601)[853] Gi4/0/2(11602)[854] Gi4/0/3(11603)[855] Gi4/0/4(11604)[856] Gi4/0/5(11605)[857] Gi4/0/6(11606)[858] Gi4/0/7(11607)[859] Gi4/0/8(11608)[860] Gi4/0/9(11609)[861] Gi4/0/10(11610)[862] Gi4/0/11(11611)[863] Gi4/0/12(11612)[864] Gi4/0/13(11613)[865] Gi4/0/14(11614)[866] Gi4/0/15(11615)[867] Gi4/0/16(11616)[868] Gi4/0/17(11617)[869] Gi4/0/18(11618)[870] Gi4/0/19(11619)[871] Gi4/0/20(11620)[872] Gi4/0/21(11621)[873] Gi4/0/22(11622)[874] Gi4/0/23(11623)[875] Gi4/0/24(11624)[876] Nu0(14501)[877] Lo0(24567)[878] Discovered in 4.095 seconds
ea-core 8 generic IPv4 Addresses : Discovered in 0.239 seconds
ea-core 8 generic IPv6 Addresses : Discovered in 0.236 seconds
Added device ea-core (8).
Devices added: 1.
##############################################
root@netmon:/opt/observium# ./poller.php -h all -d DEBUG! Observium v0.14.4.5229 Poller
Starting polling run:
SQL[SELECT `device_id` FROM `devices` WHERE `disabled` = 0 ORDER BY `device_id` ASC]
SQL[SELECT * FROM `devices` WHERE `device_id` = '9']
SQL[SELECT * FROM devices_attribs WHERE `device_id` = '9'] ea-core 9 generic Created directory : /opt/observium/rrd/ea-core DEBUG: SNMP Auth options = -v2c -c 'XXXXXX' /usr/bin/snmpget -v2c -c 'XXXXXX' -Oqtn -m DISMAN-EVENT-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ea-core':'161' .1.3.6.1.2.1.1.3.0 .1.3.6.1.2.1.1.3.0 1260931659
RRD[/usr/bin/rrdtool create /opt/observium/rrd/ea-core/status.rrd DS:status:GAUGE:600:0:1 --step 300 RRA:AVERAGE:0.5:1:2016 RRA:AVERAGE:0.5:6:2976 RRA:AVERAGE:0.5:24:1440 RRA:AVERAGE:0.5:288:1440 RRA:MIN:0.5:6:1440 RRA:MIN:0.5:96:360 RRA:MIN:0.5:288:1440 RRA:MAX:0.5:6:1440 RRA:MAX:0.5:96:360 RRA:MAX:0.5:288:1440 ] RRD[cmd[update /opt/observium/rrd/ea-core/status.rrd N:1] stdout[OK u:0.01 s:0.00 r:0.03] stderr[]] RRD[/usr/bin/rrdtool create /opt/observium/rrd/ea-core/ping.rrd DS:ping:GAUGE:600:0:65535 --step 300 RRA:AVERAGE:0.5:1:2016 RRA:AVERAGE:0.5:6:2976 RRA:AVERAGE:0.5:24:1440 RRA:AVERAGE:0.5:288:1440 RRA:MIN:0.5:6:1440 RRA:MIN:0.5:96:360 RRA:MIN:0.5:288:1440 RRA:MAX:0.5:6:1440 RRA:MAX:0.5:96:360 RRA:MAX:0.5:288:1440 ] RRD[cmd[update /opt/observium/rrd/ea-core/ping.rrd N:2.12] stdout[OK u:0.01 s:0.00 r:0.04] stderr[]] RRD[/usr/bin/rrdtool create /opt/observium/rrd/ea-core/ping_snmp.rrd DS:ping_snmp:GAUGE:600:0:65535 --step 300 RRA:AVERAGE:0.5:1:2016 RRA:AVERAGE:0.5:6:2976 RRA:AVERAGE:0.5:24:1440 RRA:AVERAGE:0.5:288:1440 RRA:MIN:0.5:6:1440 RRA:MIN:0.5:96:360 RRA:MIN:0.5:288:1440 RRA:MAX:0.5:6:1440 RRA:MAX:0.5:96:360 RRA:MAX:0.5:288:1440 ] RRD[cmd[update /opt/observium/rrd/ea-core/ping_snmp.rrd N:13.89] stdout[OK u:0.01 s:0.00 r:0.05] stderr[]] Module [ unix-agent ] disabled globally. Module [ junose-atm-vp ] excluded for device. Module [ cisco-ipsec-flow-monitor ] excluded for device. Module [ cisco-remote-access-monitor ] excluded for device. Module [ cisco-cef ] excluded for device. Module [ cisco-sla ] excluded for device. Module [ arista-software-ip-forwarding ] excluded for device. Module [ cipsec-tunnels ] excluded for device. Module [ cisco-ace-loadbalancer ] excluded for device. Module [ cisco-ace-serverfarms ] excluded for device. Module [ cisco-cbqos ] excluded for device. Module [ cisco-eigrp ] excluded for device. Module [ netscaler-vsvr ] excluded for device. Module [ aruba-controller ] excluded for device. Module [ cisco-vpdn ] disabled globally. Module [ wmi ] disabled globally.
including: includes/polling/system.inc.php DEBUG: SNMP Auth options = -v2c -c 'XXXXXX' /usr/bin/snmpget -v2c -c 'XXXXXX' -OQUs -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ea-core':'161' sysUpTime.0 sysLocation.0 sysContact.0 sysName.0
DEBUG: SNMP Auth options = -v2c -c 'XXXXXX' /usr/bin/snmpget -v2c -c 'XXXXXX' -Oqv -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ea-core':'161' sysDescr.0
DEBUG: SNMP Auth options = -v2c -c 'XXXXXX' /usr/bin/snmpget -v2c -c 'XXXXXX' -Oqvn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ea-core':'161' sysObjectID.0
DEBUG: SNMP Auth options = -v2c -c 'XXXXXX' /usr/bin/snmpget -v2c -c 'XXXXXX' -Ovqn -m SNMP-FRAMEWORK-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ea-core':'161' snmpEngineID.0
DEBUG: SNMP Auth options = -v2c -c 'XXXXXX' /usr/bin/snmpget -v2c -c 'XXXXXX' -Oqv -m HOST-RESOURCES-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ea-core':'161' hrSystemUptime.0
DEBUG: SNMP Auth options = -v2c -c 'XXXXXX' /usr/bin/snmpget -v2c -c 'XXXXXX' -OUqv -m SNMP-FRAMEWORK-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ea-core':'161' snmpEngineTime.0
Using SNMP Agent sysUpTime (0 seconds) RRD[/usr/bin/rrdtool create /opt/observium/rrd/ea-core/uptime.rrd DS:uptime:GAUGE:600:0:U --step 300 RRA:AVERAGE:0.5:1:2016 RRA:AVERAGE:0.5:6:2976 RRA:AVERAGE:0.5:24:1440 RRA:AVERAGE:0.5:288:1440 RRA:MIN:0.5:6:1440 RRA:MIN:0.5:96:360 RRA:MIN:0.5:288:1440 RRA:MAX:0.5:6:1440 RRA:MAX:0.5:96:360 RRA:MAX:0.5:288:1440 ] RRD[cmd[update /opt/observium/rrd/ea-core/uptime.rrd N:0] stdout[OK u:0.01 s:0.00 r:0.12] stderr[]] Uptime: 0s GEO-API REQUEST: http://maps.googleapis.com/maps/api/geocode/json?sensor=false&address= http://maps.googleapis.com/maps/api/geocode/json?sensor=false&address= Module time: 0.2669s
including: includes/polling/os.inc.php I'm Generic :'(
Hardware: Version: Features: Serial: Asset: Module time: 0.0007s
including: includes/polling/ipmi.inc.php IPMI: SQL[SELECT attrib_value FROM devices_attribs WHERE `device_id` = '9' AND `attrib_type` = 'ipmi_hostname']
$vars
========= null
SQL[SELECT * FROM `sensors` AS S, `devices` AS D WHERE S.`sensor_class` = 'voltage' AND S.`device_id` = D.`device_id` AND D.`device_id` = '9' AND S.`poller_type` = 'ipmi']
SQL[SELECT * FROM `sensors` AS S, `devices` AS D WHERE S.`sensor_class` = 'temperature' AND S.`device_id` = D.`device_id` AND D.`device_id` = '9' AND S.`poller_type` = 'ipmi']
SQL[SELECT * FROM `sensors` AS S, `devices` AS D WHERE S.`sensor_class` = 'fanspeed' AND S.`device_id` = D.`device_id` AND D.`device_id` = '9' AND S.`poller_type` = 'ipmi']
SQL[SELECT * FROM `sensors` AS S, `devices` AS D WHERE S.`sensor_class` = 'power' AND S.`device_id` = D.`device_id` AND D.`device_id` = '9' AND S.`poller_type` = 'ipmi']
SQL[SELECT * FROM `sensors` AS S, `devices` AS D WHERE S.`sensor_class` = 'airflow' AND S.`device_id` = D.`device_id` AND D.`device_id` = '9' AND S.`poller_type` = 'ipmi']
SQL[SELECT * FROM `sensors` AS S, `devices` AS D WHERE S.`sensor_class` = '' AND S.`device_id` = D.`device_id` AND D.`device_id` = '9' AND S.`poller_type` = 'ipmi']
Module time: 0.0117s
including: includes/polling/sensors.inc.php
SQL[SELECT COUNT(*) FROM `sensors` WHERE `device_id` = '9' AND `sensor_deleted` = '0';] Module time: 0.0009s
including: includes/polling/processors.inc.php
SQL[SELECT `processors`.*, `processors-state`.processor_usage, `processors-state`.processor_polled FROM `processors` LEFT JOIN `processors-state` ON `processors`.processor_id = `processors-state`.processor_id WHERE `device_id` = '9'] Module time: 0.001s
including: includes/polling/mempools.inc.php
SQL[SELECT `version` FROM `dbSchema`]
SQL[SELECT *, `mempools`.mempool_id as mempool_id FROM `mempools` LEFT JOIN `mempools-state` ON `mempools`.mempool_id = `mempools-state`.mempool_id WHERE `device_id` = '9'] Module time: 0.0016s
including: includes/polling/storage.inc.php
SQL[SELECT `version` FROM `dbSchema`]
SQL[SELECT `storage`.*, `storage-state`.storage_polled FROM `storage` LEFT JOIN `storage-state` ON `storage`.storage_id = `storage-state`.storage_id WHERE `device_id` = '9'] Module time: 0.0015s
including: includes/polling/netstats.inc.php Netstats: DEBUG: SNMP Auth options = -v2c -c 'XXXXXX' /usr/bin/snmpget -v2c -c 'XXXXXX' -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ea-core':'161' ipInReceives.0 ipOutRequests.0
DEBUG: SNMP Auth options = -v2c -c 'XXXXXX' /usr/bin/snmpbulkwalk -v2c -c 'XXXXXX' -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ea-core':'161' icmp
DEBUG: SNMP Auth options = -v2c -c 'XXXXXX' /usr/bin/snmpget -v2c -c 'XXXXXX' -OQUs -m TCP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ea-core':'161' tcpInSegs.0 tcpOutSegs.0
DEBUG: SNMP Auth options = -v2c -c 'XXXXXX' /usr/bin/snmpget -v2c -c 'XXXXXX' -OQUs -m UDP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ea-core':'161' udpInDatagrams.0 udpOutDatagrams.0
DEBUG: SNMP Auth options = -v2c -c 'XXXXXX' /usr/bin/snmpbulkwalk -v2c -c 'XXXXXX' -OQUs -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ea-core':'161' snmp
Module time: 0.0419s
including: includes/polling/hr-mib.inc.php DEBUG: SNMP Auth options = -v2c -c 'XXXXXX' /usr/bin/snmpget -v2c -c 'XXXXXX' -OUQs -m HOST-RESOURCES-MIB -M /opt/observium/mibs 'udp':'ea-core':'161' hrSystemProcesses.0 hrSystemNumUsers.0 hrSystemProcesses.0 = No Such Object available on this agent at this OID hrSystemNumUsers.0 = No Such Object available on this agent at this OID
HR Stats: Module time: 0.0189s
including: includes/polling/ucd-mib.inc.php DEBUG: SNMP Auth options = -v2c -c 'XXXXXX' /usr/bin/snmpbulkwalk -v2c -c 'XXXXXX' -OQUs -m UCD-SNMP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ea-core':'161' systemStats
DEBUG: SNMP Auth options = -v2c -c 'XXXXXX' /usr/bin/snmpbulkwalk -v2c -c 'XXXXXX' -OQUs -m UCD-SNMP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ea-core':'161' mem
DEBUG: SNMP Auth options = -v2c -c 'XXXXXX' /usr/bin/snmpbulkwalk -v2c -c 'XXXXXX' -OQUs -m UCD-SNMP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ea-core':'161' laLoadInt
Module time: 0.0274s
including: includes/polling/ipSystemStats.inc.php Polling IP-MIB ipSystemStats DEBUG: SNMP Auth options = -v2c -c 'XXXXXX' /usr/bin/snmpbulkwalk -v2c -c 'XXXXXX' -OQUs -m IP-MIB -M /opt/observium/mibs 'udp':'ea-core':'161' ipSystemStats ipSystemStatsInReceives.ipv6 = 0 ipSystemStatsHCInReceives.ipv6 = 0 ipSystemStatsInOctets.ipv6 = 0 ipSystemStatsHCInOctets.ipv6 = 0 ipSystemStatsInHdrErrors.ipv6 = 0 ipSystemStatsInNoRoutes.ipv6 = 0 ipSystemStatsInAddrErrors.ipv6 = 0 ipSystemStatsInUnknownProtos.ipv6 = 0 ipSystemStatsInTruncatedPkts.ipv6 = 0 ipSystemStatsInForwDatagrams.ipv6 = 0 ipSystemStatsHCInForwDatagrams.ipv6 = 0 ipSystemStatsReasmReqds.ipv6 = 0 ipSystemStatsReasmOKs.ipv6 = 0 ipSystemStatsReasmFails.ipv6 = 0 ipSystemStatsInDiscards.ipv6 = 0 ipSystemStatsInDelivers.ipv6 = 0 ipSystemStatsHCInDelivers.ipv6 = 0 ipSystemStatsOutRequests.ipv6 = 0 ipSystemStatsHCOutRequests.ipv6 = 0 ipSystemStatsOutNoRoutes.ipv6 = 0 ipSystemStatsOutForwDatagrams.ipv6 = 0 ipSystemStatsHCOutForwDatagrams.ipv6 = 0 ipSystemStatsOutDiscards.ipv6 = 0 ipSystemStatsOutFragReqds.ipv6 = 0 ipSystemStatsOutFragOKs.ipv6 = 0 ipSystemStatsOutFragFails.ipv6 = 0 ipSystemStatsOutFragCreates.ipv6 = 0 ipSystemStatsOutTransmits.ipv6 = 0 ipSystemStatsHCOutTransmits.ipv6 = 0 ipSystemStatsOutOctets.ipv6 = 0 ipSystemStatsHCOutOctets.ipv6 = 0 ipSystemStatsInMcastPkts.ipv6 = 0 ipSystemStatsHCInMcastPkts.ipv6 = 0 ipSystemStatsInMcastOctets.ipv6 = 0 ipSystemStatsHCInMcastOctets.ipv6 = 0 ipSystemStatsOutMcastPkts.ipv6 = 0 ipSystemStatsHCOutMcastPkts.ipv6 = 0 ipSystemStatsOutMcastOctets.ipv6 = 0 ipSystemStatsHCOutMcastOctets.ipv6 = 0 ipSystemStatsInBcastPkts.ipv6 = 0 ipSystemStatsHCInBcastPkts.ipv6 = 0 ipSystemStatsOutBcastPkts.ipv6 = 0 ipSystemStatsHCOutBcastPkts.ipv6 = 0 ipSystemStatsDiscontinuityTime.ipv6 = 0:0:00:00.00
ipv6 RRD[/usr/bin/rrdtool create /opt/observium/rrd/ea-core/ipSystemStats-ipv6.rrd DS:InReceives:COUNTER:600:U:100000000000 DS:InHdrErrors:COUNTER:600:U:100000000000 DS:InAddrErrors:COUNTER:600:U:100000000000 DS:InUnknownProtos:COUNTER:600:U:100000000000 DS:InForwDatagrams:COUNTER:600:U:100000000000 DS:ReasmReqds:COUNTER:600:U:100000000000 DS:ReasmOKs:COUNTER:600:U:100000000000 DS:ReasmFails:COUNTER:600:U:100000000000 DS:InDiscards:COUNTER:600:U:100000000000 DS:InDelivers:COUNTER:600:U:100000000000 DS:OutRequests:COUNTER:600:U:100000000000 DS:OutNoRoutes:COUNTER:600:U:100000000000 DS:OutDiscards:COUNTER:600:U:100000000000 DS:OutFragFails:COUNTER:600:U:100000000000 DS:OutFragCreates:COUNTER:600:U:100000000000 DS:OutForwDatagrams:COUNTER:600:U:100000000000 --step 300 RRA:AVERAGE:0.5:1:2016 RRA:AVERAGE:0.5:6:2976 RRA:AVERAGE:0.5:24:1440 RRA:AVERAGE:0.5:288:1440 RRA:MIN:0.5:6:1440 RRA:MIN:0.5:96:360 RRA:MIN:0.5:288:1440 RRA:MAX:0.5:6:1440 RRA:MAX:0.5:96:360 RRA:MAX:0.5:288:1440 ] RRD[cmd[update /opt/observium/rrd/ea-core/ipSystemStats-ipv6.rrd N:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0] stdout[OK u:0.01 s:0.00 r:0.56] stderr[]]
Module time: 0.1316s
including: includes/polling/ports.inc.php Caching Oids: ifEntry DEBUG: SNMP Auth options = -v2c -c 'XXXXXX' /usr/bin/snmpbulkwalk -v2c -c 'XXXXXX' -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ea-core':'161' ifEntry
ifXEntry DEBUG: SNMP Auth options = -v2c -c 'XXXXXX' /usr/bin/snmpbulkwalk -v2c -c 'XXXXXX' -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ea-core':'161' ifXEntry
SQL[SELECT *, I.`port_id` AS `port_id` FROM `ports` AS I LEFT JOIN `ports-state` AS S ON I.`port_id` = S.`port_id` WHERE `device_id` = '9']
Port Vlan1(1) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '1']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','879','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan2(2) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '2']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','880','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan3(3) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '3']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','881','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan4(4) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '4']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','882','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan5(5) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '5']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','883','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan6(6) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '6']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','884','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan7(7) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '7']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','885','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan8(8) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '8']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','886','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan9(9) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '9']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','887','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan10(10) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','888','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan11(11) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','889','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan13(13) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '13']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','890','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan14(14) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '14']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','891','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan18(18) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '18']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','892','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan19(19) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '19']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','893','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan20(20) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '20']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','894','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan21(21) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '21']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','895','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan22(22) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '22']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','896','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan23(23) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '23']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','897','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan24(24) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '24']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','898','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan32(32) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '32']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','899','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan47(47) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '47']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','900','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan62(62) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '62']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','901','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan63(63) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '63']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','902','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan88(88) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '88']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','903','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan93(93) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '93']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','904','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan94(94) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '94']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','905','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan111(111) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '111']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','906','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan191(191) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '191']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','907','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan193(193) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '193']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','908','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan199(199) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '199']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','909','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan200(200) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '200']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','910','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan248(248) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '248']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','911','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan901(901) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '901']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','912','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan902(902) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '902']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','913','interface',NOW(),'Interface was marked as DELETED')]
Port Port-channel1(5001) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '5001']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','914','interface',NOW(),'Interface was marked as DELETED')]
Port Port-channel2(5002) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '5002']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','915','interface',NOW(),'Interface was marked as DELETED')]
Port Port-channel5(5005) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '5005']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','916','interface',NOW(),'Interface was marked as DELETED')]
Port Port-channel10(5010) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '5010']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','917','interface',NOW(),'Interface was marked as DELETED')]
Port Port-channel11(5011) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '5011']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','918','interface',NOW(),'Interface was marked as DELETED')]
Port Port-channel16(5016) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '5016']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','919','interface',NOW(),'Interface was marked as DELETED')]
Port Port-channel21(5021) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '5021']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','920','interface',NOW(),'Interface was marked as DELETED')]
Port Port-channel22(5022) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '5022']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','921','interface',NOW(),'Interface was marked as DELETED')]
Port StackPort1(5179) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '5179']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','922','interface',NOW(),'Interface was marked as DELETED')]
Port StackSub-St1-1(5180) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '5180']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','923','interface',NOW(),'Interface was marked as DELETED')]
Port StackSub-St1-2(5181) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '5181']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','924','interface',NOW(),'Interface was marked as DELETED')]
Port StackPort2(5182) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '5182']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','925','interface',NOW(),'Interface was marked as DELETED')]
Port StackSub-St2-1(5183) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '5183']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','926','interface',NOW(),'Interface was marked as DELETED')]
Port StackSub-St2-2(5184) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '5184']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','927','interface',NOW(),'Interface was marked as DELETED')]
Port StackPort3(5185) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '5185']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','928','interface',NOW(),'Interface was marked as DELETED')]
Port StackSub-St3-1(5186) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '5186']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','929','interface',NOW(),'Interface was marked as DELETED')]
Port StackSub-St3-2(5187) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '5187']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','930','interface',NOW(),'Interface was marked as DELETED')]
Port StackPort4(5188) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '5188']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','931','interface',NOW(),'Interface was marked as DELETED')]
Port StackSub-St4-1(5189) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '5189']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','932','interface',NOW(),'Interface was marked as DELETED')]
Port StackSub-St4-2(5190) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '5190']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','933','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/1(10101) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10101']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','934','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/2(10102) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10102']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','935','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/3(10103) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10103']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','936','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/4(10104) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10104']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','937','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/5(10105) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10105']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','938','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/6(10106) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10106']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','939','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/7(10107) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10107']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','940','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/8(10108) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10108']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','941','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/9(10109) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10109']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','942','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/10(10110) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10110']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','943','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/11(10111) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10111']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','944','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/12(10112) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10112']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','945','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/13(10113) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10113']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','946','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/14(10114) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10114']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','947','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/15(10115) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10115']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','948','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/16(10116) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10116']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','949','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/17(10117) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10117']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','950','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/18(10118) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10118']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','951','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/19(10119) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10119']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','952','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/20(10120) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10120']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','953','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/21(10121) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10121']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','954','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/22(10122) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10122']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','955','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/23(10123) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10123']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','956','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/24(10124) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10124']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','957','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/25(10125) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10125']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','958','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/26(10126) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10126']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','959','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/27(10127) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10127']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','960','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/28(10128) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10128']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','961','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/1(10601) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10601']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','962','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/2(10602) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10602']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','963','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/3(10603) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10603']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','964','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/4(10604) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10604']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','965','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/5(10605) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10605']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','966','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/6(10606) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10606']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','967','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/7(10607) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10607']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','968','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/8(10608) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10608']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','969','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/9(10609) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10609']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','970','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/10(10610) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10610']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','971','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/11(10611) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10611']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','972','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/12(10612) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10612']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','973','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/13(10613) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10613']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','974','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/14(10614) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10614']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','975','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/15(10615) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10615']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','976','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/16(10616) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10616']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','977','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/17(10617) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10617']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','978','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/18(10618) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10618']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','979','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/19(10619) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10619']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','980','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/20(10620) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10620']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','981','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/21(10621) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10621']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','982','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/22(10622) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10622']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','983','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/23(10623) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10623']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','984','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/24(10624) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10624']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','985','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/25(10625) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10625']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','986','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/26(10626) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10626']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','987','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/27(10627) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10627']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','988','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/28(10628) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10628']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','989','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet3/0/1(11101) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11101']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','990','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet3/0/2(11102) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11102']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','991','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet3/0/3(11103) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11103']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','992','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet3/0/4(11104) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11104']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','993','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet3/0/5(11105) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11105']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','994','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet3/0/6(11106) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11106']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','995','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet3/0/7(11107) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11107']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','996','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet3/0/8(11108) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11108']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','997','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet3/0/9(11109) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11109']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','998','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet3/0/10(11110) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11110']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','999','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet3/0/11(11111) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11111']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1000','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet3/0/12(11112) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11112']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1001','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/1(11601) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11601']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1002','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/2(11602) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11602']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1003','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/3(11603) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11603']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1004','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/4(11604) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11604']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1005','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/5(11605) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11605']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1006','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/6(11606) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11606']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1007','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/7(11607) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11607']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1008','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/8(11608) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11608']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1009','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/9(11609) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11609']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1010','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/10(11610) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11610']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1011','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/11(11611) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11611']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1012','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/12(11612) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11612']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1013','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/13(11613) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11613']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1014','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/14(11614) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11614']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1015','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/15(11615) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11615']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1016','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/16(11616) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11616']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1017','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/17(11617) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11617']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1018','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/18(11618) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11618']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1019','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/19(11619) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11619']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1020','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/20(11620) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11620']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1021','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/21(11621) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11621']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1022','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/22(11622) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11622']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1023','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/23(11623) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11623']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1024','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/24(11624) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11624']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1025','interface',NOW(),'Interface was marked as DELETED')]
Port Null0(14501) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '14501']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1026','interface',NOW(),'Interface was marked as DELETED')]
Port Loopback0(24567) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '24567']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1027','interface',NOW(),'Interface was marked as DELETED')]
Module time: 5.2942s
including: includes/polling/bgp-peers.inc.php BGP Peers: DEBUG: SNMP Auth options = -v2c -c 'XXXXXX' /usr/bin/snmpget -v2c -c 'XXXXXX' -Oqvn -m BGP4-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ea-core':'161' bgpLocalAs.0
SQL[SELECT *, `bgpPeers`.bgpPeer_id as bgpPeer_id FROM `bgpPeers` LEFT JOIN `bgpPeers-state` ON `bgpPeers`.bgpPeer_id = `bgpPeers-state`.bgpPeer_id WHERE `device_id` = '9'] Module time: 0.0068s
including: includes/polling/toner.inc.php
SQL[SELECT * FROM toner WHERE device_id = '9'] Module time: 0.0007s
including: includes/polling/ucd-diskio.inc.php
SQL[SELECT * FROM `ucd_diskio` WHERE `device_id` = '9'] Module time: 0.0006s
including: includes/polling/wifi.inc.php
Module time: 0.0002s
including: includes/polling/ospf.inc.php OSPF: Processes: SQL[SELECT * FROM `ospf_instances` WHERE `device_id` = '9'] DEBUG: SNMP Auth options = -v2c -c 'XXXXXX' /usr/bin/snmpbulkwalk -v2c -c 'XXXXXX' -OQUs -m OSPF-MIB -M /opt/observium/mibs 'udp':'ea-core':'161' OSPF-MIB::ospfGeneralGroup ospfRouterId.0 = 10.10.1.1 ospfAdminStat.0 = enabled ospfVersionNumber.0 = version2 ospfAreaBdrRtrStatus.0 = false ospfASBdrRtrStatus.0 = false ospfExternLsaCount.0 = 29 ospfExternLsaCksumSum.0 = 956914 ospfTOSSupport.0 = false ospfOriginateNewLsas.0 = 22 ospfRxNewLsas.0 = 87 ospfExtLsdbLimit.0 = -1 ospfMulticastExtensions.0 = 0 ospfExitOverflowInterval.0 = 0 ospfDemandExtensions.0 = true
DEBUG: SNMP Auth options = -v2c -c 'XXXXXX' /usr/bin/snmpbulkwalk -v2c -c 'XXXXXX' -OQUs -m OSPF-MIB -M /opt/observium/mibs 'udp':'ea-core':'161' OSPF-MIB::ospfAreaEntry ospfAreaId.0.0.0.0 = 0.0.0.0 ospfAuthType.0.0.0.0 = md5 ospfImportAsExtern.0.0.0.0 = importExternal ospfSpfRuns.0.0.0.0 = 16 ospfAreaBdrRtrCount.0.0.0.0 = 0 ospfAsBdrRtrCount.0.0.0.0 = 2 ospfAreaLsaCount.0.0.0.0 = 5 ospfAreaLsaCksumSum.0.0.0.0 = 204337 ospfAreaSummary.0.0.0.0 = sendAreaSummary ospfAreaStatus.0.0.0.0 = active
DEBUG: SNMP Auth options = -v2c -c 'XXXXXX' /usr/bin/snmpbulkwalk -v2c -c 'XXXXXX' -OQUs -m OSPF-MIB -M /opt/observium/mibs 'udp':'ea-core':'161' OSPF-MIB::ospfIfEntry ospfIfIpAddress.10.6.96.1.0 = 10.6.96.1 ospfIfIpAddress.10.6.96.5.0 = 10.6.96.5 ospfAddressLessIf.10.6.96.1.0 = 0 ospfAddressLessIf.10.6.96.5.0 = 0 ospfIfAreaId.10.6.96.1.0 = 0.0.0.0 ospfIfAreaId.10.6.96.5.0 = 0.0.0.0 ospfIfType.10.6.96.1.0 = broadcast ospfIfType.10.6.96.5.0 = broadcast ospfIfAdminStat.10.6.96.1.0 = enabled ospfIfAdminStat.10.6.96.5.0 = enabled ospfIfRtrPriority.10.6.96.1.0 = 1 ospfIfRtrPriority.10.6.96.5.0 = 1 ospfIfTransitDelay.10.6.96.1.0 = 1 ospfIfTransitDelay.10.6.96.5.0 = 1 ospfIfRetransInterval.10.6.96.1.0 = 5 ospfIfRetransInterval.10.6.96.5.0 = 5 ospfIfHelloInterval.10.6.96.1.0 = 10 ospfIfHelloInterval.10.6.96.5.0 = 10 ospfIfRtrDeadInterval.10.6.96.1.0 = 40 ospfIfRtrDeadInterval.10.6.96.5.0 = 40 ospfIfPollInterval.10.6.96.1.0 = 120 ospfIfPollInterval.10.6.96.5.0 = 120 ospfIfState.10.6.96.1.0 = designatedRouter ospfIfState.10.6.96.5.0 = designatedRouter ospfIfDesignatedRouter.10.6.96.1.0 = 10.6.96.1 ospfIfDesignatedRouter.10.6.96.5.0 = 10.6.96.5 ospfIfBackupDesignatedRouter.10.6.96.1.0 = 10.6.96.2 ospfIfBackupDesignatedRouter.10.6.96.5.0 = 10.6.96.6 ospfIfEvents.10.6.96.1.0 = 6 ospfIfEvents.10.6.96.5.0 = 8 ospfIfAuthKey.10.6.96.1.0 = "" ospfIfAuthKey.10.6.96.5.0 = "" ospfIfStatus.10.6.96.1.0 = active ospfIfStatus.10.6.96.5.0 = active ospfIfMulticastForwarding.10.6.96.1.0 = blocked ospfIfMulticastForwarding.10.6.96.5.0 = blocked ospfIfDemand.10.6.96.1.0 = false ospfIfDemand.10.6.96.5.0 = false ospfIfAuthType.10.6.96.1.0 = md5 ospfIfAuthType.10.6.96.5.0 = md5
DEBUG: SNMP Auth options = -v2c -c 'XXXXXX' /usr/bin/snmpbulkwalk -v2c -c 'XXXXXX' -OQUs -m OSPF-MIB -M /opt/observium/mibs 'udp':'ea-core':'161' OSPF-MIB::ospfNbrEntry ospfNbrIpAddr.10.6.96.2.0 = 10.6.96.2 ospfNbrIpAddr.10.6.96.6.0 = 10.6.96.6 ospfNbrAddressLessIndex.10.6.96.2.0 = 0 ospfNbrAddressLessIndex.10.6.96.6.0 = 0 ospfNbrRtrId.10.6.96.2.0 = 10.8.95.0 ospfNbrRtrId.10.6.96.6.0 = 10.3.95.0 ospfNbrOptions.10.6.96.2.0 = 2 ospfNbrOptions.10.6.96.6.0 = 2 ospfNbrPriority.10.6.96.2.0 = 1 ospfNbrPriority.10.6.96.6.0 = 1 ospfNbrState.10.6.96.2.0 = full ospfNbrState.10.6.96.6.0 = full ospfNbrEvents.10.6.96.2.0 = 6 ospfNbrEvents.10.6.96.6.0 = 6 ospfNbrLsRetransQLen.10.6.96.2.0 = 0 ospfNbrLsRetransQLen.10.6.96.6.0 = 0 ospfNbmaNbrStatus.10.6.96.2.0 = active ospfNbmaNbrStatus.10.6.96.6.0 = active ospfNbmaNbrPermanence.10.6.96.2.0 = dynamic ospfNbmaNbrPermanence.10.6.96.6.0 = dynamic ospfNbrHelloSuppressed.10.6.96.2.0 = false ospfNbrHelloSuppressed.10.6.96.6.0 = false
SQL[INSERT INTO `ospf_instances` (`device_id`,`ospf_instance_id`) VALUES ('9','0')] + SQL[SELECT * FROM `ospf_instances` WHERE `device_id` = '9' AND `ospf_instance_id` = '0']
Polled: Array ( [0] => Array ( [ospfRouterId] => 10.10.1.1 [ospfAdminStat] => enabled [ospfVersionNumber] => version2 [ospfAreaBdrRtrStatus] => false [ospfASBdrRtrStatus] => false [ospfExternLsaCount] => 29 [ospfExternLsaCksumSum] => 956914 [ospfTOSSupport] => false [ospfOriginateNewLsas] => 22 [ospfRxNewLsas] => 87 [ospfExtLsdbLimit] => -1 [ospfMulticastExtensions] => 0 [ospfExitOverflowInterval] => 0 [ospfDemandExtensions] => true )
)
== array( [0] => array( [ospfRouterId] => string(9) "10.10.1.1" ┗ date ~ -8hr America/New_York (UTC-5) [ospfAdminStat] => string(7) "enabled" [ospfVersionNumber] => string(8) "version2" [ospfAreaBdrRtrStatus] => string(5) "false" [ospfASBdrRtrStatus] => string(5) "false" [ospfExternLsaCount] => string(2) "29" [ospfExternLsaCksumSum] => string(6) "956914" [ospfTOSSupport] => string(5) "false" [ospfOriginateNewLsas] => string(2) "22" [ospfRxNewLsas] => string(2) "87" [ospfExtLsdbLimit] => string(2) "-1" [ospfMulticastExtensions] => string(1) "0" [ospfExitOverflowInterval] => string(1) "0" [ospfDemandExtensions] => string(4) "true" ) ) Database: Array ( [] => )
== array( [] => null )
. Areas: SQL[SELECT * FROM `ospf_areas` WHERE `device_id` = '9']
SQL[INSERT INTO `ospf_areas` (`device_id`,`ospfAreaId`) VALUES ('9','0.0.0.0')] + SQL[SELECT * FROM `ospf_areas` WHERE `device_id` = '9' AND `ospfAreaId` = '0.0.0.0']
Polled: Array ( [0.0.0.0] => Array ( [ospfAreaId] => 0.0.0.0 [ospfAuthType] => md5 [ospfImportAsExtern] => importExternal [ospfSpfRuns] => 16 [ospfAreaBdrRtrCount] => 0 [ospfAsBdrRtrCount] => 2 [ospfAreaLsaCount] => 5 [ospfAreaLsaCksumSum] => 204337 [ospfAreaSummary] => sendAreaSummary [ospfAreaStatus] => active )
)
== array( [0.0.0.0] => array( [ospfAreaId] => string(7) "0.0.0.0" ┗ date ~ -19hr America/New_York (UTC-5) [ospfAuthType] => string(3) "md5" ┗ function ~ md5 [ospfImportAsExtern] => string(14) "importExternal" [ospfSpfRuns] => string(2) "16" [ospfAreaBdrRtrCount] => string(1) "0" [ospfAsBdrRtrCount] => string(1) "2" [ospfAreaLsaCount] => string(1) "5" [ospfAreaLsaCksumSum] => string(6) "204337" [ospfAreaSummary] => string(15) "sendAreaSummary" [ospfAreaStatus] => string(6) "active" ) ) Database: Array ( [] => Array ( [0] => Array ( [device_id] => 9 [ospfAreaId] => 0.0.0.0 [ospfAuthType] => [ospfImportAsExtern] => [ospfSpfRuns] => 0 [ospfAreaBdrRtrCount] => 0 [ospfAsBdrRtrCount] => 0 [ospfAreaLsaCount] => 0 [ospfAreaLsaCksumSum] => 0 [ospfAreaSummary] => [ospfAreaStatus] => )
)
)
== array( [] => array( [0] => array( [device_id] => string(1) "9" [ospfAreaId] => string(7) "0.0.0.0" ┗ date ~ -19hr America/New_York (UTC-5) [ospfAuthType] => string(0) "" [ospfImportAsExtern] => string(0) "" [ospfSpfRuns] => string(1) "0" [ospfAreaBdrRtrCount] => string(1) "0" [ospfAsBdrRtrCount] => string(1) "0" [ospfAreaLsaCount] => string(1) "0" [ospfAreaLsaCksumSum] => string(1) "0" [ospfAreaSummary] => string(0) "" [ospfAreaStatus] => string(0) "" ) ) )
SQL[DELETE FROM `ospf_ports` WHERE `device_id` = '9' AND `ospfAreaId` = ''] Ports: SQL[SELECT * FROM `ospf_ports` WHERE `device_id` = '9']
SQL[INSERT INTO `ospf_ports` (`device_id`,`ospf_port_id`) VALUES ('9','10.6.96.1.0')] + SQL[SELECT * FROM `ospf_ports` WHERE `device_id` = '9' AND `ospf_port_id` = '10.6.96.1.0']
SQL[INSERT INTO `ospf_ports` (`device_id`,`ospf_port_id`) VALUES ('9','10.6.96.5.0')] + SQL[SELECT * FROM `ospf_ports` WHERE `device_id` = '9' AND `ospf_port_id` = '10.6.96.5.0']
Polled: Array ( [10.6.96.1.0] => Array ( [ospfIfIpAddress] => 10.6.96.1 [ospfAddressLessIf] => 0 [ospfIfAreaId] => 0.0.0.0 [ospfIfType] => broadcast [ospfIfAdminStat] => enabled [ospfIfRtrPriority] => 1 [ospfIfTransitDelay] => 1 [ospfIfRetransInterval] => 5 [ospfIfHelloInterval] => 10 [ospfIfRtrDeadInterval] => 40 [ospfIfPollInterval] => 120 [ospfIfState] => designatedRouter [ospfIfDesignatedRouter] => 10.6.96.1 [ospfIfBackupDesignatedRouter] => 10.6.96.2 [ospfIfEvents] => 6 [ospfIfAuthKey] => [ospfIfStatus] => active [ospfIfMulticastForwarding] => blocked [ospfIfDemand] => false [ospfIfAuthType] => md5 )
[10.6.96.5.0] => Array ( [ospfIfIpAddress] => 10.6.96.5 [ospfAddressLessIf] => 0 [ospfIfAreaId] => 0.0.0.0 [ospfIfType] => broadcast [ospfIfAdminStat] => enabled [ospfIfRtrPriority] => 1 [ospfIfTransitDelay] => 1 [ospfIfRetransInterval] => 5 [ospfIfHelloInterval] => 10 [ospfIfRtrDeadInterval] => 40 [ospfIfPollInterval] => 120 [ospfIfState] => designatedRouter [ospfIfDesignatedRouter] => 10.6.96.5 [ospfIfBackupDesignatedRouter] => 10.6.96.6 [ospfIfEvents] => 8 [ospfIfAuthKey] => [ospfIfStatus] => active [ospfIfMulticastForwarding] => blocked [ospfIfDemand] => false [ospfIfAuthType] => md5 )
)
== array( [10.6.96.1.0] => array( [ospfIfIpAddress] => string(9) "10.6.96.1" [ospfAddressLessIf] => string(1) "0" [ospfIfAreaId] => string(7) "0.0.0.0" ┗ date ~ -19hr America/New_York (UTC-5) [ospfIfType] => string(9) "broadcast" [ospfIfAdminStat] => string(7) "enabled" [ospfIfRtrPriority] => string(1) "1" [ospfIfTransitDelay] => string(1) "1" [ospfIfRetransInterval] => string(1) "5" [ospfIfHelloInterval] => string(2) "10" [ospfIfRtrDeadInterval] => string(2) "40" [ospfIfPollInterval] => string(3) "120" [ospfIfState] => string(16) "designatedRouter" [ospfIfDesignatedRouter] => string(9) "10.6.96.1" [ospfIfBackupDesignatedRouter] => string(9) "10.6.96.2" [ospfIfEvents] => string(1) "6" [ospfIfAuthKey] => string(0) "" [ospfIfStatus] => string(6) "active" [ospfIfMulticastForwarding] => string(7) "blocked" [ospfIfDemand] => string(5) "false" [ospfIfAuthType] => string(3) "md5" ┗ function ~ md5 ) [10.6.96.5.0] => array( [ospfIfIpAddress] => string(9) "10.6.96.5" [ospfAddressLessIf] => string(1) "0" [ospfIfAreaId] => string(7) "0.0.0.0" ┗ date ~ -19hr America/New_York (UTC-5) [ospfIfType] => string(9) "broadcast" [ospfIfAdminStat] => string(7) "enabled" [ospfIfRtrPriority] => string(1) "1" [ospfIfTransitDelay] => string(1) "1" [ospfIfRetransInterval] => string(1) "5" [ospfIfHelloInterval] => string(2) "10" [ospfIfRtrDeadInterval] => string(2) "40" [ospfIfPollInterval] => string(3) "120" [ospfIfState] => string(16) "designatedRouter" [ospfIfDesignatedRouter] => string(9) "10.6.96.5" [ospfIfBackupDesignatedRouter] => string(9) "10.6.96.6" [ospfIfEvents] => string(1) "8" [ospfIfAuthKey] => string(0) "" [ospfIfStatus] => string(6) "active" [ospfIfMulticastForwarding] => string(7) "blocked" [ospfIfDemand] => string(5) "false" [ospfIfAuthType] => string(3) "md5" ┗ function ~ md5 ) ) Database: Array ( [] => Array ( [device_id] => 9 [port_id] => 0 [ospf_port_id] => 10.6.96.5.0 [ospfIfIpAddress] => [ospfAddressLessIf] => 0 [ospfIfAreaId] => [ospfIfType] => [ospfIfAdminStat] => [ospfIfRtrPriority] => [ospfIfTransitDelay] => [ospfIfRetransInterval] => [ospfIfHelloInterval] => [ospfIfRtrDeadInterval] => [ospfIfPollInterval] => [ospfIfState] => [ospfIfDesignatedRouter] => [ospfIfBackupDesignatedRouter] => [ospfIfEvents] => [ospfIfAuthKey] => [ospfIfStatus] => [ospfIfMulticastForwarding] => [ospfIfDemand] => [ospfIfAuthType] => )
)
== array( [] => array( [device_id] => string(1) "9" [port_id] => string(1) "0" [ospf_port_id] => string(11) "10.6.96.5.0" ┗ date ~ -18yr America/New_York (UTC-5) [ospfIfIpAddress] => string(0) "" [ospfAddressLessIf] => string(1) "0" [ospfIfAreaId] => string(0) "" [ospfIfType] => null [ospfIfAdminStat] => null [ospfIfRtrPriority] => null [ospfIfTransitDelay] => null [ospfIfRetransInterval] => null [ospfIfHelloInterval] => null [ospfIfRtrDeadInterval] => null [ospfIfPollInterval] => null [ospfIfState] => null [ospfIfDesignatedRouter] => null [ospfIfBackupDesignatedRouter] => null [ospfIfEvents] => null [ospfIfAuthKey] => null [ospfIfStatus] => null [ospfIfMulticastForwarding] => null [ospfIfDemand] => null [ospfIfAuthType] => null ) )
SQL[SELECT A.`port_id` FROM ipv4_addresses AS A, ports AS I WHERE A.ipv4_address = '10.6.96.5' AND I.port_id = A.port_id AND I.device_id = '9']
SQL[UPDATE `ospf_ports` set `ospfIfIpAddress` ='10.6.96.5',`port_id` ='',`ospfIfAreaId` ='0.0.0.0',`ospfIfType` ='broadcast',`ospfIfAdminStat` ='enabled',`ospfIfRtrPriority` ='1',`ospfIfTransitDelay` ='1',`ospfIfRetransInterval` ='5',`ospfIfHelloInterval` ='10',`ospfIfRtrDeadInterval` ='40',`ospfIfPollInterval` ='120',`ospfIfState` ='designatedRouter',`ospfIfDesignatedRouter` ='10.6.96.5',`ospfIfBackupDesignatedRouter` ='10.6.96.6',`ospfIfEvents` ='8',`ospfIfStatus` ='active',`ospfIfMulticastForwarding` ='blocked',`ospfIfDemand` ='false',`ospfIfAuthType` ='md5' WHERE `device_id` = '9' AND `ospf_port_id` = ''] U Neighbours: SQL[SELECT * FROM `ospf_nbrs` WHERE `device_id` = '9']
SQL[INSERT INTO `ospf_nbrs` (`device_id`,`ospf_nbr_id`) VALUES ('9','10.6.96.2.0')] + SQL[SELECT * FROM `ospf_nbrs` WHERE `device_id` = '9' AND `ospf_nbr_id` = '10.6.96.2.0']
SQL[INSERT INTO `ospf_nbrs` (`device_id`,`ospf_nbr_id`) VALUES ('9','10.6.96.6.0')] + SQL[SELECT * FROM `ospf_nbrs` WHERE `device_id` = '9' AND `ospf_nbr_id` = '10.6.96.6.0']
Polled: Array ( [10.6.96.2.0] => Array ( [ospfNbrIpAddr] => 10.6.96.2 [ospfNbrAddressLessIndex] => 0 [ospfNbrRtrId] => 10.8.95.0 [ospfNbrOptions] => 2 [ospfNbrPriority] => 1 [ospfNbrState] => full [ospfNbrEvents] => 6 [ospfNbrLsRetransQLen] => 0 [ospfNbmaNbrStatus] => active [ospfNbmaNbrPermanence] => dynamic [ospfNbrHelloSuppressed] => false )
[10.6.96.6.0] => Array ( [ospfNbrIpAddr] => 10.6.96.6 [ospfNbrAddressLessIndex] => 0 [ospfNbrRtrId] => 10.3.95.0 [ospfNbrOptions] => 2 [ospfNbrPriority] => 1 [ospfNbrState] => full [ospfNbrEvents] => 6 [ospfNbrLsRetransQLen] => 0 [ospfNbmaNbrStatus] => active [ospfNbmaNbrPermanence] => dynamic [ospfNbrHelloSuppressed] => false )
)
== array( [10.6.96.2.0] => array( [ospfNbrIpAddr] => string(9) "10.6.96.2" [ospfNbrAddressLessIndex] => string(1) "0" [ospfNbrRtrId] => string(9) "10.8.95.0" [ospfNbrOptions] => string(1) "2" [ospfNbrPriority] => string(1) "1" [ospfNbrState] => string(4) "full" [ospfNbrEvents] => string(1) "6" [ospfNbrLsRetransQLen] => string(1) "0" [ospfNbmaNbrStatus] => string(6) "active" [ospfNbmaNbrPermanence] => string(7) "dynamic" [ospfNbrHelloSuppressed] => string(5) "false" ) [10.6.96.6.0] => array( [ospfNbrIpAddr] => string(9) "10.6.96.6" [ospfNbrAddressLessIndex] => string(1) "0" [ospfNbrRtrId] => string(9) "10.3.95.0" [ospfNbrOptions] => string(1) "2" [ospfNbrPriority] => string(1) "1" [ospfNbrState] => string(4) "full" [ospfNbrEvents] => string(1) "6" [ospfNbrLsRetransQLen] => string(1) "0" [ospfNbmaNbrStatus] => string(6) "active" [ospfNbmaNbrPermanence] => string(7) "dynamic" [ospfNbrHelloSuppressed] => string(5) "false" ) ) Database: Array ( [10.6.96.2.0] => Array ( [device_id] => 9 [port_id] => 0 [ospf_nbr_id] => 10.6.96.2.0 [ospfNbrIpAddr] => [ospfNbrAddressLessIndex] => 0 [ospfNbrRtrId] => [ospfNbrOptions] => 0 [ospfNbrPriority] => 0 [ospfNbrState] => [ospfNbrEvents] => 0 [ospfNbrLsRetransQLen] => 0 [ospfNbmaNbrStatus] => [ospfNbmaNbrPermanence] => [ospfNbrHelloSuppressed] => )
[10.6.96.6.0] => Array ( [device_id] => 9 [port_id] => 0 [ospf_nbr_id] => 10.6.96.6.0 [ospfNbrIpAddr] => [ospfNbrAddressLessIndex] => 0 [ospfNbrRtrId] => [ospfNbrOptions] => 0 [ospfNbrPriority] => 0 [ospfNbrState] => [ospfNbrEvents] => 0 [ospfNbrLsRetransQLen] => 0 [ospfNbmaNbrStatus] => [ospfNbmaNbrPermanence] => [ospfNbrHelloSuppressed] => )
)
== array( [10.6.96.2.0] => array( [device_id] => string(1) "9" [port_id] => string(1) "0" [ospf_nbr_id] => string(11) "10.6.96.2.0" ┗ date ~ -18yr America/New_York (UTC-5) [ospfNbrIpAddr] => string(0) "" [ospfNbrAddressLessIndex] => string(1) "0" [ospfNbrRtrId] => string(0) "" [ospfNbrOptions] => string(1) "0" [ospfNbrPriority] => string(1) "0" [ospfNbrState] => string(0) "" [ospfNbrEvents] => string(1) "0" [ospfNbrLsRetransQLen] => string(1) "0" [ospfNbmaNbrStatus] => string(0) "" [ospfNbmaNbrPermanence] => string(0) "" [ospfNbrHelloSuppressed] => string(0) "" ) [10.6.96.6.0] => array( [device_id] => string(1) "9" [port_id] => string(1) "0" [ospf_nbr_id] => string(11) "10.6.96.6.0" ┗ date ~ -18yr America/New_York (UTC-5) [ospfNbrIpAddr] => string(0) "" [ospfNbrAddressLessIndex] => string(1) "0" [ospfNbrRtrId] => string(0) "" [ospfNbrOptions] => string(1) "0" [ospfNbrPriority] => string(1) "0" [ospfNbrState] => string(0) "" [ospfNbrEvents] => string(1) "0" [ospfNbrLsRetransQLen] => string(1) "0" [ospfNbmaNbrStatus] => string(0) "" [ospfNbmaNbrPermanence] => string(0) "" [ospfNbrHelloSuppressed] => string(0) "" ) )
SQL[SELECT A.`port_id` FROM ipv4_addresses AS A, nbrs AS I WHERE A.ipv4_address = '10.6.96.2' AND I.port_id = A.port_id AND I.device_id = '9'] |10.6.96.2 0|0 |10.8.95.0 0|2 0|1 |full 0|6 0|0 |active |dynamic |false
SQL[UPDATE `ospf_nbrs` set `port_id` =NULL,`ospfNbrIpAddr` ='10.6.96.2',`ospfNbrRtrId` ='10.8.95.0',`ospfNbrOptions` ='2',`ospfNbrPriority` ='1',`ospfNbrState` ='full',`ospfNbrEvents` ='6',`ospfNbmaNbrStatus` ='active',`ospfNbmaNbrPermanence` ='dynamic',`ospfNbrHelloSuppressed` ='false' WHERE `device_id` = '9' AND `ospf_nbr_id` = '10.6.96.2.0'] U SQL[SELECT A.`port_id` FROM ipv4_addresses AS A, nbrs AS I WHERE A.ipv4_address = '10.6.96.6' AND I.port_id = A.port_id AND I.device_id = '9'] |10.6.96.6 0|0 |10.3.95.0 0|2 0|1 |full 0|6 0|0 |active |dynamic |false
SQL[UPDATE `ospf_nbrs` set `port_id` =NULL,`ospfNbrIpAddr` ='10.6.96.6',`ospfNbrRtrId` ='10.3.95.0',`ospfNbrOptions` ='2',`ospfNbrPriority` ='1',`ospfNbrState` ='full',`ospfNbrEvents` ='6',`ospfNbmaNbrStatus` ='active',`ospfNbmaNbrPermanence` ='dynamic',`ospfNbrHelloSuppressed` ='false' WHERE `device_id` = '9' AND `ospf_nbr_id` = '10.6.96.6.0'] URRD[/usr/bin/rrdtool create /opt/observium/rrd/ea-core/ospf-statistics.rrd \ DS:instances:GAUGE:600:0:1000000 \ DS:areas:GAUGE:600:0:1000000 \ DS:ports:GAUGE:600:0:1000000 \ DS:neighbours:GAUGE:600:0:1000000 --step 300 RRA:AVERAGE:0.5:1:2016 RRA:AVERAGE:0.5:6:2976 RRA:AVERAGE:0.5:24:1440 RRA:AVERAGE:0.5:288:1440 RRA:MIN:0.5:6:1440 RRA:MIN:0.5:96:360 RRA:MIN:0.5:288:1440 RRA:MAX:0.5:6:1440 RRA:MAX:0.5:96:360 RRA:MAX:0.5:288:1440 ] RRD[cmd[update /opt/observium/rrd/ea-core/ospf-statistics.rrd N:1:0:1:0] stdout[OK u:0.01 s:0.00 r:7.41] stderr[]]
Module time: 1.5389s
including: includes/polling/mac-accounting.inc.php Mac Accounting: Caching DB... SQL[SELECT *, `mac_accounting`.`ma_id` as `ma_id` FROM `mac_accounting` LEFT JOIN `mac_accounting-state` ON `mac_accounting`.ma_id = `mac_accounting-state`.ma_id WHERE `device_id` = '9']
== null 0 entries. Module time: 0.0017s
including: includes/polling/entity-physical.inc.php Entity Physical: SQL[SELECT * FROM `entPhysical-state` WHERE `device_id` = '9']
Module time: 0.0006s
including: includes/polling/applications.inc.php SELECT * FROM `applications` WHERE `device_id` = '9'
SQL[SELECT * FROM `applications` WHERE `device_id` = '9'] Module time: 0.0004s
including: includes/polling/fdb-table.inc.php FDB Tables
SQL[SELECT `ifIndex`,`port_id`,`ifDescr` FROM `ports` WHERE `device_id` = '9']
SQL[SELECT * FROM `vlans_fdb` WHERE `device_id` = '9'] DEBUG: SNMP Auth options = -v2c -c 'XXXXXX' /usr/bin/snmpbulkwalk -v2c -c 'XXXXXX' -OqsX -m Q-BRIDGE-MIB -M /opt/observium/mibs 'udp':'ea-core':'161' dot1qTpFdbEntry dot1qTpFdbEntry No Such Object available on this agent at this OID
RRD[/usr/bin/rrdtool create /opt/observium/rrd/ea-core/fdb_count.rrd DS:value:GAUGE:600:0:U --step 300 RRA:AVERAGE:0.5:1:2016 RRA:AVERAGE:0.5:6:2976 RRA:AVERAGE:0.5:24:1440 RRA:AVERAGE:0.5:288:1440 RRA:MIN:0.5:6:1440 RRA:MIN:0.5:96:360 RRA:MIN:0.5:288:1440 RRA:MAX:0.5:6:1440 RRA:MAX:0.5:96:360 RRA:MAX:0.5:288:1440 ] RRD[cmd[update /opt/observium/rrd/ea-core/fdb_count.rrd N:0] stdout[OK u:0.01 s:0.00 r:7.44] stderr[]] Module time: 0.0369s
SQL[SELECT `graph` FROM `device_graphs` WHERE `device_id` = '9'] + SQL[INSERT INTO `device_graphs` (`device_id`,`graph`) VALUES ('9','ping')] ping + SQL[INSERT INTO `device_graphs` (`device_id`,`graph`) VALUES ('9','ping_snmp')] ping_snmp + SQL[INSERT INTO `device_graphs` (`device_id`,`graph`) VALUES ('9','uptime')] uptime + SQL[INSERT INTO `device_graphs` (`device_id`,`graph`) VALUES ('9','ipsystemstats_ipv6')] ipsystemstats_ipv6 + SQL[INSERT INTO `device_graphs` (`device_id`,`graph`) VALUES ('9','ipsystemstats_ipv6_frag')] ipsystemstats_ipv6_frag + SQL[INSERT INTO `device_graphs` (`device_id`,`graph`) VALUES ('9','fdb_count')] fdb_count + SQL[INSERT INTO `device_graphs` (`device_id`,`graph`) VALUES ('9','poller_perf')] poller_perf Polled in 7.5217 seconds
SQL[INSERT INTO `devices_perftimes` (`device_id`,`operation`,`start`,`duration`) VALUES ('9','poll','1424131616.8384','7.521665096283')] RRD[/usr/bin/rrdtool create /opt/observium/rrd/ea-core/perf-poller.rrd DS:val:GAUGE:600:0:38400 --step 300 RRA:AVERAGE:0.5:1:2016 RRA:AVERAGE:0.5:6:2976 RRA:AVERAGE:0.5:24:1440 RRA:AVERAGE:0.5:288:1440 RRA:MIN:0.5:6:1440 RRA:MIN:0.5:96:360 RRA:MIN:0.5:288:1440 RRA:MAX:0.5:6:1440 RRA:MAX:0.5:96:360 RRA:MAX:0.5:288:1440 ] RRD[cmd[update /opt/observium/rrd/ea-core/perf-poller.rrd N:7.5217] stdout[OK u:0.01 s:0.00 r:7.53] stderr[]] Updating ea-core - Array ( [uptime] => 0 [location_geoapi] => google [location_lat] => 41.6855886 [location_lon] => -85.9093094 [location_city] => Unknown [location_county] => Unknown [location_state] => Unknown [location_country] => Unknown [last_polled] => Array ( [0] => NOW() )
[last_polled_timetaken] => 7.5217 [device_state] => a:1:{s:15:"poller_mod_perf";a:21:{s:6:"system";s:6:"0.2669";s:2:"os";s:6:"0.0007";s:4:"ipmi";s:6:"0.0117";s:7:"sensors";s:6:"0.0009";s:10:"processors";s:6:"0.0010";s:8:"mempools";s:6:"0.0016";s:7:"storage";s:6:"0.0015";s:8:"netstats";s:6:"0.0419";s:6:"hr-mib";s:6:"0.0189";s:7:"ucd-mib";s:6:"0.0274";s:13:"ipSystemStats";s:6:"0.1316";s:5:"ports";s:6:"5.2942";s:9:"bgp-peers";s:6:"0.0068";s:5:"toner";s:6:"0.0007";s:10:"ucd-diskio";s:6:"0.0006";s:4:"wifi";s:6:"0.0002";s:4:"ospf";s:6:"1.5389";s:14:"mac-accounting";s:6:"0.0017";s:15:"entity-physical";s:6:"0.0006";s:12:"applications";s:6:"0.0004";s:9:"fdb-table";s:6:"0.0369";}} )
== array( [uptime] => int(0) [location_geoapi] => string(6) "google" [location_lat] => string(10) "41.6855886" [location_lon] => string(11) "-85.9093094" [location_city] => string(7) "Unknown" [location_county] => string(7) "Unknown" [location_state] => string(7) "Unknown" [location_country] => string(7) "Unknown" [last_polled] => array( [0] => string(5) "NOW()" ) [last_polled_timetaken] => double(7.5217) [device_state] => string(627) "a:1:{s:15:"poller_mod_perf";a:21:{s:6:"system";s:6:"0.2669";s:2:"os";s:6:"0.0007";s:4:"ipmi";s:6:"0.0117";s:7:"sensors";s:6:"0.0009";s:10:"processors";s:6:"0.0010";s:8:"mempools";s:6:"0.0016";s:7:"storage";s:6:"0.0015";s:8:"netstats";s:6:"0.0419";s:6:"hr-mib";s:6:"0.0189";s:7:"ucd-mib";s:6:"0.0274";s:13:"ipSystemStats";s:6:"0.1316";s:5:"ports";s:6:"5.2942";s:9:"bgp-peers";s:6:"0.0068";s:5:"toner";s:6:"0.0007";s:10:"ucd-diskio";s:6:"0.0006";s:4:"wifi";s:6:"0.0002";s:4:"ospf";s:6:"1.5389";s:14:"mac-accounting";s:6:"0.0017";s:15:"entity-physical";s:6:"0.0006";s:12:"applications";s:6:"0.0004";s:9:"fdb-table";s:6:"0.0369";}}" ┗ serialized ~ array( [poller_mod_perf] => array( [system] => string(6) "0.2669" [os] => string(6) "0.0007" [ipmi] => string(6) "0.0117" [sensors] => string(6) "0.0009" [processors] => string(6) "0.0010" [mempools] => string(6) "0.0016" [storage] => string(6) "0.0015" [netstats] => string(6) "0.0419" [hr-mib] => string(6) "0.0189" [ucd-mib] => string(6) "0.0274" [ipSystemStats] => string(6) "0.1316" [ports] => string(6) "5.2942" [bgp-peers] => string(6) "0.0068" [toner] => string(6) "0.0007" [ucd-diskio] => string(6) "0.0006" [wifi] => string(6) "0.0002" [ospf] => string(6) "1.5389" [mac-accounting] => string(6) "0.0017" [entity-physical] => string(6) "0.0006" [applications] => string(6) "0.0004" [fdb-table] => string(6) "0.0369" ) ) )
SQL[UPDATE `devices` set `uptime` ='0',`location_geoapi` ='google',`location_lat` ='41.6855886',`location_lon` ='-85.9093094',`location_city` ='Unknown',`location_county` ='Unknown',`location_state` ='Unknown',`location_country` ='Unknown',`last_polled` =NOW(),`last_polled_timetaken` ='7.5217',`device_state` ='a:1:{s:15:"poller_mod_perf";a:21:{s:6:"system";s:6:"0.2669";s:2:"os";s:6:"0.0007";s:4:"ipmi";s:6:"0.0117";s:7:"sensors";s:6:"0.0009";s:10:"processors";s:6:"0.0010";s:8:"mempools";s:6:"0.0016";s:7:"storage";s:6:"0.0015";s:8:"netstats";s:6:"0.0419";s:6:"hr-mib";s:6:"0.0189";s:7:"ucd-mib";s:6:"0.0274";s:13:"ipSystemStats";s:6:"0.1316";s:5:"ports";s:6:"5.2942";s:9:"bgp-peers";s:6:"0.0068";s:5:"toner";s:6:"0.0007";s:10:"ucd-diskio";s:6:"0.0006";s:4:"wifi";s:6:"0.0002";s:4:"ospf";s:6:"1.5389";s:14:"mac-accounting";s:6:"0.0017";s:15:"entity-physical";s:6:"0.0006";s:12:"applications";s:6:"0.0004";s:9:"fdb-table";s:6:"0.0369";}}' WHERE `device_id` = '9'] UPDATED!
SQL[INSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`) VALUES ('poll','all','1424131616.8346','7.570','1')] ./poller.php all February 16, 2015, 19:07 - 1 devices polled in 7.570 secs MySQL: Cell[3/0s] Row[11/0.01s] Rows[22/0.01s] Column[0/0s] Update[153/2.54s] Insert[164/2.83s] Delete[0/0s]