CMD[[0;33m/usr/bin/snmpget -t '3' -v2c -c *** -Pud -OQUs -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'pop19-asr':'161' sysObjectID.0 sysUpTime.0[0m] [0m [0mCMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.0406s[0m][0m [0mSTDOUT[ sysObjectID.0 = enterprises.9.1.1639 sysUpTime.0 = 67:6:02:39.24 ] SNMP STATUS[[0;32mTRUE[0m][0m [0m SQL[[0;33mSELECT * FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '39'[0m][0m [0mSQL RUNTIME[[0;32m0.00438905s[0m][0m [0m SQL[[0;33mSELECT * FROM `observium_processes` WHERE `process_name` = 'discovery.php' AND `device_id` = '39' AND `poller_id` = '0'[0m][0m [0mSQL RUNTIME[[0;32m0.00033307s[0m][0m [0m SQL[[0;33mINSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`) VALUES ('7765','discovery.php','7753','0','php /opt/observium/discovery.php -h all -m vrf -d','1611219602','39')[0m][0m [0mSQL RUNTIME[[0;32m0.01003098s[0m][0m [0m[0;32m##### [1;37mpop19-asr [39][0;32m #####[0m [0m [0m[0;32m o [1;37mOS Type [0m [0miosxr [0;32m o [1;37mOS Group [0m [0mcisco [0;32m o [1;37mSNMP Version [0m [0mv2c [0;32m o [1;37mLast discovery [0m [0m2021-01-21 09:58:11 [0;32m o [1;37mLast duration [0m [0m35.92 seconds [0;36m##### [1;37mModule Start: [1;31mvrf[0;36m #####[0m [0m [0m SQL[[0;33mSELECT `mib` FROM `devices_mibs` WHERE `device_id` = '39' AND `use` = 'mib' AND `disabled` = '1'[0m][0m [0mSQL RUNTIME[[0;32m0.00054002s[0m][0m [0m[0;36m o [1;37mMPLS-L3VPN-STD-MIB [0m [0m CMD[[0;33m/usr/bin/snmpget -t '3' -v2c -c *** -Pud -OQUv -m MPLS-L3VPN-STD-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'pop19-asr':'161' mplsL3VpnConfiguredVrfs.0[0m] [0m [0mCMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.0551s[0m][0m [0mSTDOUT[ 6 ] SNMP STATUS[[0;32mTRUE[0m][0m [0m CMD[[0;33m/usr/bin/snmpbulkwalk -t '3' -v2c -c *** -Pud -OQUs -m MPLS-L3VPN-STD-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'pop19-asr':'161' mplsL3VpnVrfEntry[0m] [0m [0mCMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.2979s[0m][0m [0mSTDOUT[ mplsL3VpnVrfVpnId."VR_MGMT" = "" mplsL3VpnVrfVpnId."default" = "" mplsL3VpnVrfVpnId."VRF_IPSUBS" = "" mplsL3VpnVrfVpnId."VR_INT_MGMT" = "" mplsL3VpnVrfVpnId."VR_MFH_MGMT" = "" mplsL3VpnVrfVpnId."VRF_INFRA_INT" = "" mplsL3VpnVrfVpnId."VR_SMART-METER" = "" mplsL3VpnVrfDescription."VR_MGMT" = mplsL3VpnVrfDescription."default" = mplsL3VpnVrfDescription."VRF_IPSUBS" = mplsL3VpnVrfDescription."VR_INT_MGMT" = mplsL3VpnVrfDescription."VR_MFH_MGMT" = mplsL3VpnVrfDescription."VRF_INFRA_INT" = mplsL3VpnVrfDescription."VR_SMART-METER" = mplsL3VpnVrfRD."VR_MGMT" = "" mplsL3VpnVrfRD."default" = "" mplsL3VpnVrfRD."VRF_IPSUBS" = "15943:1007" mplsL3VpnVrfRD."VR_INT_MGMT" = "" mplsL3VpnVrfRD."VR_MFH_MGMT" = "15943:1009" mplsL3VpnVrfRD."VRF_INFRA_INT" = "15943:1015" mplsL3VpnVrfRD."VR_SMART-METER" = "15943:999" mplsL3VpnVrfCreationTime."VR_MGMT" = 0:0:00:16.72 mplsL3VpnVrfCreationTime."default" = 0:0:00:00.00 mplsL3VpnVrfCreationTime."VRF_IPSUBS" = 0:0:00:16.72 mplsL3VpnVrfCreationTime."VR_INT_MGMT" = 0:0:00:16.72 mplsL3VpnVrfCreationTime."VR_MFH_MGMT" = 0:0:00:16.72 mplsL3VpnVrfCreationTime."VRF_INFRA_INT" = 0:0:00:16.72 mplsL3VpnVrfCreationTime."VR_SMART-METER" = 0:0:00:16.72 mplsL3VpnVrfOperStatus."VR_MGMT" = up mplsL3VpnVrfOperStatus."default" = down mplsL3VpnVrfOperStatus."VRF_IPSUBS" = up mplsL3VpnVrfOperStatus."VR_INT_MGMT" = down mplsL3VpnVrfOperStatus."VR_MFH_MGMT" = up mplsL3VpnVrfOperStatus."VRF_INFRA_INT" = up mplsL3VpnVrfOperStatus."VR_SMART-METER" = up mplsL3VpnVrfActiveInterfaces."VR_MGMT" = 1 mplsL3VpnVrfActiveInterfaces."default" = 0 mplsL3VpnVrfActiveInterfaces."VRF_IPSUBS" = 1 mplsL3VpnVrfActiveInterfaces."VR_INT_MGMT" = 0 mplsL3VpnVrfActiveInterfaces."VR_MFH_MGMT" = 2 mplsL3VpnVrfActiveInterfaces."VRF_INFRA_INT" = 2 mplsL3VpnVrfActiveInterfaces."VR_SMART-METER" = 1 mplsL3VpnVrfAssociatedInterfaces."VR_MGMT" = 2 mplsL3VpnVrfAssociatedInterfaces."default" = 0 mplsL3VpnVrfAssociatedInterfaces."VRF_IPSUBS" = 1 mplsL3VpnVrfAssociatedInterfaces."VR_INT_MGMT" = 0 mplsL3VpnVrfAssociatedInterfaces."VR_MFH_MGMT" = 2 mplsL3VpnVrfAssociatedInterfaces."VRF_INFRA_INT" = 2 mplsL3VpnVrfAssociatedInterfaces."VR_SMART-METER" = 1 mplsL3VpnVrfConfMidRteThresh."VR_MGMT" = 0 mplsL3VpnVrfConfMidRteThresh."default" = 0 mplsL3VpnVrfConfMidRteThresh."VRF_IPSUBS" = 0 mplsL3VpnVrfConfMidRteThresh."VR_INT_MGMT" = 0 mplsL3VpnVrfConfMidRteThresh."VR_MFH_MGMT" = 0 mplsL3VpnVrfConfMidRteThresh."VRF_INFRA_INT" = 0 mplsL3VpnVrfConfMidRteThresh."VR_SMART-METER" = 0 mplsL3VpnVrfConfHighRteThresh."VR_MGMT" = 0 mplsL3VpnVrfConfHighRteThresh."default" = 0 mplsL3VpnVrfConfHighRteThresh."VRF_IPSUBS" = 0 mplsL3VpnVrfConfHighRteThresh."VR_INT_MGMT" = 0 mplsL3VpnVrfConfHighRteThresh."VR_MFH_MGMT" = 0 mplsL3VpnVrfConfHighRteThresh."VRF_INFRA_INT" = 0 mplsL3VpnVrfConfHighRteThresh."VR_SMART-METER" = 0 mplsL3VpnVrfConfMaxRoutes."VR_MGMT" = 0 mplsL3VpnVrfConfMaxRoutes."default" = 0 mplsL3VpnVrfConfMaxRoutes."VRF_IPSUBS" = 0 mplsL3VpnVrfConfMaxRoutes."VR_INT_MGMT" = 0 mplsL3VpnVrfConfMaxRoutes."VR_MFH_MGMT" = 0 mplsL3VpnVrfConfMaxRoutes."VRF_INFRA_INT" = 0 mplsL3VpnVrfConfMaxRoutes."VR_SMART-METER" = 0 mplsL3VpnVrfConfLastChanged."VR_MGMT" = 0:0:00:29.72 mplsL3VpnVrfConfLastChanged."default" = 0:0:00:00.00 mplsL3VpnVrfConfLastChanged."VRF_IPSUBS" = 0:0:05:11.72 mplsL3VpnVrfConfLastChanged."VR_INT_MGMT" = 0:0:00:00.00 mplsL3VpnVrfConfLastChanged."VR_MFH_MGMT" = 0:0:05:11.72 mplsL3VpnVrfConfLastChanged."VRF_INFRA_INT" = 0:0:05:11.72 mplsL3VpnVrfConfLastChanged."VR_SMART-METER" = 0:0:05:11.72 mplsL3VpnVrfConfRowStatus."VR_MGMT" = active mplsL3VpnVrfConfRowStatus."default" = active mplsL3VpnVrfConfRowStatus."VRF_IPSUBS" = active mplsL3VpnVrfConfRowStatus."VR_INT_MGMT" = active mplsL3VpnVrfConfRowStatus."VR_MFH_MGMT" = active mplsL3VpnVrfConfRowStatus."VRF_INFRA_INT" = active mplsL3VpnVrfConfRowStatus."VR_SMART-METER" = active mplsL3VpnVrfConfAdminStatus."VR_MGMT" = up mplsL3VpnVrfConfAdminStatus."default" = down mplsL3VpnVrfConfAdminStatus."VRF_IPSUBS" = up mplsL3VpnVrfConfAdminStatus."VR_INT_MGMT" = down mplsL3VpnVrfConfAdminStatus."VR_MFH_MGMT" = up mplsL3VpnVrfConfAdminStatus."VRF_INFRA_INT" = up mplsL3VpnVrfConfAdminStatus."VR_SMART-METER" = up mplsL3VpnVrfConfStorageType."VR_MGMT" = readOnly mplsL3VpnVrfConfStorageType."default" = readOnly mplsL3VpnVrfConfStorageType."VRF_IPSUBS" = readOnly mplsL3VpnVrfConfStorageType."VR_INT_MGMT" = readOnly mplsL3VpnVrfConfStorageType."VR_MFH_MGMT" = readOnly mplsL3VpnVrfConfStorageType."VRF_INFRA_INT" = readOnly mplsL3VpnVrfConfStorageType."VR_SMART-METER" = readOnly ] SNMP STATUS[[0;32mTRUE[0m][0m [0m CMD[[0;33m/usr/bin/snmpbulkwalk -t '3' -v2c -c *** -Pud -OQUs -m MPLS-L3VPN-STD-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'pop19-asr':'161' mplsL3VpnVrfPerfEntry[0m] [0m [0mCMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.0826s[0m][0m [0mSTDOUT[ mplsL3VpnVrfPerfRoutesAdded."VR_MGMT" = 0 mplsL3VpnVrfPerfRoutesAdded."default" = 0 mplsL3VpnVrfPerfRoutesAdded."VRF_IPSUBS" = 0 mplsL3VpnVrfPerfRoutesAdded."VR_INT_MGMT" = 0 mplsL3VpnVrfPerfRoutesAdded."VR_MFH_MGMT" = 0 mplsL3VpnVrfPerfRoutesAdded."VRF_INFRA_INT" = 0 mplsL3VpnVrfPerfRoutesAdded."VR_SMART-METER" = 0 mplsL3VpnVrfPerfRoutesDeleted."VR_MGMT" = 0 mplsL3VpnVrfPerfRoutesDeleted."default" = 0 mplsL3VpnVrfPerfRoutesDeleted."VRF_IPSUBS" = 0 mplsL3VpnVrfPerfRoutesDeleted."VR_INT_MGMT" = 0 mplsL3VpnVrfPerfRoutesDeleted."VR_MFH_MGMT" = 0 mplsL3VpnVrfPerfRoutesDeleted."VRF_INFRA_INT" = 0 mplsL3VpnVrfPerfRoutesDeleted."VR_SMART-METER" = 0 mplsL3VpnVrfPerfCurrNumRoutes."VR_MGMT" = 3 mplsL3VpnVrfPerfCurrNumRoutes."default" = 1085949 mplsL3VpnVrfPerfCurrNumRoutes."VRF_IPSUBS" = 55 mplsL3VpnVrfPerfCurrNumRoutes."VR_INT_MGMT" = 0 mplsL3VpnVrfPerfCurrNumRoutes."VR_MFH_MGMT" = 5 mplsL3VpnVrfPerfCurrNumRoutes."VRF_INFRA_INT" = 111 mplsL3VpnVrfPerfCurrNumRoutes."VR_SMART-METER" = 14 mplsL3VpnVrfPerfRoutesDropped."VR_MGMT" = 0 mplsL3VpnVrfPerfRoutesDropped."default" = 0 mplsL3VpnVrfPerfRoutesDropped."VRF_IPSUBS" = 0 mplsL3VpnVrfPerfRoutesDropped."VR_INT_MGMT" = 0 mplsL3VpnVrfPerfRoutesDropped."VR_MFH_MGMT" = 0 mplsL3VpnVrfPerfRoutesDropped."VRF_INFRA_INT" = 0 mplsL3VpnVrfPerfRoutesDropped."VR_SMART-METER" = 0 mplsL3VpnVrfPerfDiscTime."VR_MGMT" = 0:0:00:00.00 mplsL3VpnVrfPerfDiscTime."default" = 0:0:00:00.00 mplsL3VpnVrfPerfDiscTime."VRF_IPSUBS" = 0:0:00:00.00 mplsL3VpnVrfPerfDiscTime."VR_INT_MGMT" = 0:0:00:00.00 mplsL3VpnVrfPerfDiscTime."VR_MFH_MGMT" = 0:0:00:00.00 mplsL3VpnVrfPerfDiscTime."VRF_INFRA_INT" = 0:0:00:00.00 mplsL3VpnVrfPerfDiscTime."VR_SMART-METER" = 0:0:00:00.00 ] SNMP STATUS[[0;32mTRUE[0m][0m [0mTimeticks converted 0:0:00:16.72 -> 16 Timeticks converted 0:0:00:29.72 -> 29 Timeticks converted 0:0:00:00.00 -> 0 Timeticks converted 0:0:00:00.00 -> 0 Timeticks converted 0:0:00:16.72 -> 16 Timeticks converted 0:0:05:11.72 -> 311 Timeticks converted 0:0:00:16.72 -> 16 Timeticks converted 0:0:00:00.00 -> 0 Timeticks converted 0:0:00:16.72 -> 16 Timeticks converted 0:0:05:11.72 -> 311 Timeticks converted 0:0:00:16.72 -> 16 Timeticks converted 0:0:05:11.72 -> 311 Timeticks converted 0:0:00:16.72 -> 16 Timeticks converted 0:0:05:11.72 -> 311 CMD[[0;33m/usr/bin/snmpbulkwalk -t '3' -v2c -c *** -Pud -OQUs -m MPLS-L3VPN-STD-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'pop19-asr':'161' mplsL3VpnIfConfRowStatus[0m] [0m [0mCMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.0683s[0m][0m [0mSTDOUT[ mplsL3VpnIfConfRowStatus."VR_MGMT".4 = active mplsL3VpnIfConfRowStatus."VR_MGMT".5 = active mplsL3VpnIfConfRowStatus."VRF_IPSUBS".55 = active mplsL3VpnIfConfRowStatus."VR_MFH_MGMT".12 = active mplsL3VpnIfConfRowStatus."VR_MFH_MGMT".61 = active mplsL3VpnIfConfRowStatus."VRF_INFRA_INT".57 = active mplsL3VpnIfConfRowStatus."VRF_INFRA_INT".58 = active mplsL3VpnIfConfRowStatus."VR_SMART-METER".17 = active ] SNMP STATUS[[0;32mTRUE[0m][0m [0m [0;36m o [1;37mMPLS-VPN-MIB [0m [0m CMD[[0;33m/usr/bin/snmpget -t '3' -v2c -c *** -Pud -OQUv -m MPLS-VPN-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'pop19-asr':'161' mplsVpnConfiguredVrfs.0[0m] [0m [0mCMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.0301s[0m][0m [0mCMD EXITDELAY[[0;31m10ms[0m][0m [0mSTDOUT[ No Such Object available on this agent at this OID ] SNMP STATUS[[0;31mFALSE[0m][0m [0mSNMP ERROR[[0;31m#1000 - Failed response[0m][0m [0mNot found VRFs by MPLS-VPN-MIB. vrf_last_change: 1605409139 - 1586321400 = 19087739 SQL[[0;33mUPDATE `vrfs` set `vrf_last_change` ='1605409139' WHERE `vrf_id` = '161'[0m][0m [0mSQL RUNTIME[[0;32m0.01025605s[0m][0m [0m SQL[[0;33mSELECT `port_id` FROM `ports` WHERE `device_id` = '39' AND `ifIndex` = '4' AND `deleted` = '0' LIMIT 1[0m][0m [0mSQL RUNTIME[[0;32m0.00055790s[0m][0m [0m SQL[[0;33mSELECT * FROM `ports` WHERE `ports`.`port_id` = '5441'[0m][0m [0mSQL RUNTIME[[0;32m0.00045586s[0m][0m [0m SQL[[0;33mSELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '5441'[0m][0m [0mSQL RUNTIME[[0;32m0.00029707s[0m][0m [0m SQL[[0;33mSELECT * FROM `devices` WHERE `device_id` = '39'[0m][0m [0mSQL RUNTIME[[0;32m0.00039101s[0m][0m [0m SQL[[0;33mSELECT * FROM `device_graphs` WHERE `device_id` = '39'[0m][0m [0mSQL RUNTIME[[0;32m0.00258398s[0m][0m [0m SQL[[0;33mSELECT `port_id` FROM `ports` WHERE `device_id` = '39' AND `ifIndex` = '5' AND `deleted` = '0' LIMIT 1[0m][0m [0mSQL RUNTIME[[0;32m0.00037217s[0m][0m [0m SQL[[0;33mSELECT * FROM `ports` WHERE `ports`.`port_id` = '5442'[0m][0m [0mSQL RUNTIME[[0;32m0.00038314s[0m][0m [0m SQL[[0;33mSELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '5442'[0m][0m [0mSQL RUNTIME[[0;32m0.00030589s[0m][0m [0m SQL[[0;33mINSERT INTO `ports` (`port_id`,`ifIndex`,`device_id`,`ifVrf`) VALUES ('5441','4','39','161'),('5442','5','39','161') ON DUPLICATE KEY UPDATE `ifVrf`=VALUES(`ifVrf`)[0m][0m [0mSQL RUNTIME[[0;32m0.01888585s[0m][0m [0m SQL[[0;33mINSERT INTO `vrfs` (`device_id`,`vrf_mib`,`vrf_name`,`vrf_descr`,`vrf_rd`,`vrf_added`,`vrf_last_change`,`vrf_admin_status`,`vrf_oper_status`,`vrf_active_ports`,`vrf_total_ports`,`vrf_added_routes`,`vrf_deleted_routes`,`vrf_total_routes`) VALUES ('39','MPLS-L3VPN-STD-MIB','default','','','1605409110','1605409110','down','down','0','0','0','0','1085949')[0m][0m [0mSQL RUNTIME[[0;32m0.01215720s[0m][0m [0m SQL[[0;33mINSERT INTO `vrfs` (`device_id`,`vrf_mib`,`vrf_name`,`vrf_descr`,`vrf_rd`,`vrf_added`,`vrf_last_change`,`vrf_admin_status`,`vrf_oper_status`,`vrf_active_ports`,`vrf_total_ports`,`vrf_added_routes`,`vrf_deleted_routes`,`vrf_total_routes`) VALUES ('39','MPLS-L3VPN-STD-MIB','VRF_IPSUBS','','15943:1007','1605409126','1605409421','up','up','1','1','0','0','55')[0m][0m [0mSQL RUNTIME[[0;32m0.01187396s[0m][0m [0m SQL[[0;33mSELECT `port_id` FROM `ports` WHERE `device_id` = '39' AND `ifIndex` = '55' AND `deleted` = '0' LIMIT 1[0m][0m [0mSQL RUNTIME[[0;32m0.00023818s[0m][0m [0m SQL[[0;33mSELECT * FROM `ports` WHERE `ports`.`port_id` = '72055'[0m][0m [0mSQL RUNTIME[[0;32m0.00045586s[0m][0m [0m SQL[[0;33mSELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '72055'[0m][0m [0mSQL RUNTIME[[0;32m0.00034308s[0m][0m [0m SQL[[0;33mINSERT INTO `ports` (`port_id`,`ifIndex`,`device_id`,`ifVrf`) VALUES ('72055','55','39','86157') ON DUPLICATE KEY UPDATE `ifVrf`=VALUES(`ifVrf`)[0m][0m [0mSQL RUNTIME[[0;32m0.01377988s[0m][0m [0m SQL[[0;33mINSERT INTO `vrfs` (`device_id`,`vrf_mib`,`vrf_name`,`vrf_descr`,`vrf_rd`,`vrf_added`,`vrf_last_change`,`vrf_admin_status`,`vrf_oper_status`,`vrf_active_ports`,`vrf_total_ports`,`vrf_added_routes`,`vrf_deleted_routes`,`vrf_total_routes`) VALUES ('39','MPLS-L3VPN-STD-MIB','VR_INT_MGMT','','','1605409126','1605409110','down','down','0','0','0','0','0')[0m][0m [0mSQL RUNTIME[[0;32m0.01192307s[0m][0m [0m SQL[[0;33mINSERT INTO `vrfs` (`device_id`,`vrf_mib`,`vrf_name`,`vrf_descr`,`vrf_rd`,`vrf_added`,`vrf_last_change`,`vrf_admin_status`,`vrf_oper_status`,`vrf_active_ports`,`vrf_total_ports`,`vrf_added_routes`,`vrf_deleted_routes`,`vrf_total_routes`) VALUES ('39','MPLS-L3VPN-STD-MIB','VR_MFH_MGMT','','15943:1009','1605409126','1605409421','up','up','2','2','0','0','5')[0m][0m [0mSQL RUNTIME[[0;32m0.01041913s[0m][0m [0m SQL[[0;33mSELECT `port_id` FROM `ports` WHERE `device_id` = '39' AND `ifIndex` = '12' AND `deleted` = '0' LIMIT 1[0m][0m [0mSQL RUNTIME[[0;32m0.00031281s[0m][0m [0m SQL[[0;33mSELECT * FROM `ports` WHERE `ports`.`port_id` = '5447'[0m][0m [0mSQL RUNTIME[[0;32m0.00033593s[0m][0m [0m SQL[[0;33mSELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '5447'[0m][0m [0mSQL RUNTIME[[0;32m0.00101399s[0m][0m [0m SQL[[0;33mSELECT `port_id` FROM `ports` WHERE `device_id` = '39' AND `ifIndex` = '61' AND `deleted` = '0' LIMIT 1[0m][0m [0mSQL RUNTIME[[0;32m0.00045300s[0m][0m [0m SQL[[0;33mSELECT * FROM `ports` WHERE `ports`.`port_id` = '92761'[0m][0m [0mSQL RUNTIME[[0;32m0.00047088s[0m][0m [0m SQL[[0;33mSELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '92761'[0m][0m [0mSQL RUNTIME[[0;32m0.00039411s[0m][0m [0m SQL[[0;33mINSERT INTO `ports` (`port_id`,`ifIndex`,`device_id`,`ifVrf`) VALUES ('5447','12','39','86159'),('92761','61','39','86159') ON DUPLICATE KEY UPDATE `ifVrf`=VALUES(`ifVrf`)[0m][0m [0mSQL RUNTIME[[0;32m0.00989103s[0m][0m [0m SQL[[0;33mINSERT INTO `vrfs` (`device_id`,`vrf_mib`,`vrf_name`,`vrf_descr`,`vrf_rd`,`vrf_added`,`vrf_last_change`,`vrf_admin_status`,`vrf_oper_status`,`vrf_active_ports`,`vrf_total_ports`,`vrf_added_routes`,`vrf_deleted_routes`,`vrf_total_routes`) VALUES ('39','MPLS-L3VPN-STD-MIB','VRF_INFRA_INT','','15943:1015','1605409126','1605409421','up','up','2','2','0','0','111')[0m][0m [0mSQL RUNTIME[[0;32m0.00799513s[0m][0m [0m SQL[[0;33mSELECT `port_id` FROM `ports` WHERE `device_id` = '39' AND `ifIndex` = '57' AND `deleted` = '0' LIMIT 1[0m][0m [0mSQL RUNTIME[[0;32m0.00133300s[0m][0m [0m SQL[[0;33mSELECT * FROM `ports` WHERE `ports`.`port_id` = '76702'[0m][0m [0mSQL RUNTIME[[0;32m0.00407314s[0m][0m [0m SQL[[0;33mSELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '76702'[0m][0m [0mSQL RUNTIME[[0;32m0.00056887s[0m][0m [0m SQL[[0;33mSELECT `port_id` FROM `ports` WHERE `device_id` = '39' AND `ifIndex` = '58' AND `deleted` = '0' LIMIT 1[0m][0m [0mSQL RUNTIME[[0;32m0.00030112s[0m][0m [0m SQL[[0;33mSELECT * FROM `ports` WHERE `ports`.`port_id` = '76703'[0m][0m [0mSQL RUNTIME[[0;32m0.00037813s[0m][0m [0m SQL[[0;33mSELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '76703'[0m][0m [0mSQL RUNTIME[[0;32m0.00052309s[0m][0m [0m SQL[[0;33mINSERT INTO `ports` (`port_id`,`ifIndex`,`device_id`,`ifVrf`) VALUES ('76702','57','39','86160'),('76703','58','39','86160') ON DUPLICATE KEY UPDATE `ifVrf`=VALUES(`ifVrf`)[0m][0m [0mSQL RUNTIME[[0;32m0.00596404s[0m][0m [0m SQL[[0;33mINSERT INTO `vrfs` (`device_id`,`vrf_mib`,`vrf_name`,`vrf_descr`,`vrf_rd`,`vrf_added`,`vrf_last_change`,`vrf_admin_status`,`vrf_oper_status`,`vrf_active_ports`,`vrf_total_ports`,`vrf_added_routes`,`vrf_deleted_routes`,`vrf_total_routes`) VALUES ('39','MPLS-L3VPN-STD-MIB','VR_SMART-METER','','15943:999','1605409126','1605409421','up','up','1','1','0','0','14')[0m][0m [0mSQL RUNTIME[[0;32m0.00991583s[0m][0m [0m SQL[[0;33mSELECT `port_id` FROM `ports` WHERE `device_id` = '39' AND `ifIndex` = '17' AND `deleted` = '0' LIMIT 1[0m][0m [0mSQL RUNTIME[[0;32m0.00030994s[0m][0m [0m SQL[[0;33mSELECT * FROM `ports` WHERE `ports`.`port_id` = '5452'[0m][0m [0mSQL RUNTIME[[0;32m0.00038695s[0m][0m [0m SQL[[0;33mSELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '5452'[0m][0m [0mSQL RUNTIME[[0;32m0.00034785s[0m][0m [0m SQL[[0;33mINSERT INTO `ports` (`port_id`,`ifIndex`,`device_id`,`ifVrf`) VALUES ('5452','17','39','86161') ON DUPLICATE KEY UPDATE `ifVrf`=VALUES(`ifVrf`)[0m][0m [0mSQL RUNTIME[[0;32m0.01074219s[0m][0m [0m SQL[[0;33mSELECT COUNT(*) FROM `vrfs` WHERE `device_id` = '39' AND `vrf_name` NOT IN ('VR_MGMT','default','VRF_IPSUBS','VR_INT_MGMT','VR_MFH_MGMT','VRF_INFRA_INT','VR_SMART-METER')[0m][0m [0mSQL RUNTIME[[0;32m0.00127411s[0m][0m [0m SQL[[0;33mSELECT COUNT(*) FROM `ports` WHERE `device_id` = '39' AND `ifVrf` IS NOT NULL AND `port_id` NOT IN ('5441','5442','72055','5447','92761','76702','76703','5452')[0m][0m [0mSQL RUNTIME[[0;32m0.00387096s[0m][0m [0m [0;36m o [1;37mChanges [0m [0m6 added, 1 updated [0;36m o [1;37mDuration [0m [0m0.7338s SQL[[0;33mINSERT INTO `eventlog` (`device_id`,`entity_id`,`entity_type`,`timestamp`,`severity`,`message`) VALUES ('39','39','device',NOW(),'6','VRF: 6 added, 1 updated.')[0m][0m [0mSQL RUNTIME[[0;32m0.01280785s[0m][0m [0m SQL[[0;33mUPDATE `devices` set `last_discovered` =NOW(),`type` ='network',`last_discovered_timetaken` ='0.7588',`force_discovery` ='0' WHERE `device_id` = '39'[0m][0m [0mSQL RUNTIME[[0;32m0.01183295s[0m][0m [0m[0;32m##### [1;37mpop19-asr [39] completed discovery modules at 2021-01-21 10:01:09[0;32m #####[0m [0m [0m[0;32m o [1;37mDiscovery time [0m [0m0.7588 seconds SQL[[0;33mDELETE FROM `observium_processes` WHERE `process_pid` = '7765' AND `process_name` = 'discovery.php' AND `device_id` = '39' AND `poller_id` = '0'[0m][0m