louis
1
Hello,
we have removed port-channel474 interface from a cisco nexus device but it still in database after polling and discovery.
MariaDB [librenms]> select ifname from ports where device_id = 29 and ifname=“port-channel474”;
±----------------+
| ifname |
±----------------+
| port-channel474 |
±----------------+
1 row in set (0.00 sec)
====================================
| Component |
Version |
| LibreNMS |
1.56 |
| DB Schema |
2019_09_05_153524_create_notifications_attribs_index (141) |
| PHP |
7.2.20 |
| MySQL |
5.5.60-MariaDB |
| RRDTool |
1.7.1 |
| SNMP |
NET-SNMP 5.7.2 |
====================================
[OK] Composer Version: 1.8.5
[OK] Dependencies up-to-date.
[OK] Database connection successful
[OK] Database schema correct
louis
2
[root@librenms-prod-dc1 ~]$ snmpwalk -v3 -u XX -a MD5 -A XX -l authNoPriv swcup1-br13k ifname
IF-MIB::ifName.83886080 = STRING: mgmt0
IF-MIB::ifName.369098765 = STRING: port-channel14
IF-MIB::ifName.369099175 = STRING: port-channel424
IF-MIB::ifName.369099260 = STRING: port-channel509
IF-MIB::ifName.436207616 = STRING: Ethernet1/1
IF-MIB::ifName.436208128 = STRING: Ethernet1/2
IF-MIB::ifName.436208640 = STRING: Ethernet1/3
IF-MIB::ifName.436209152 = STRING: Ethernet1/4
IF-MIB::ifName.436209664 = STRING: Ethernet1/5
IF-MIB::ifName.436210176 = STRING: Ethernet1/6
IF-MIB::ifName.436210688 = STRING: Ethernet1/7
IF-MIB::ifName.436211200 = STRING: Ethernet1/8
IF-MIB::ifName.436211712 = STRING: Ethernet1/9
IF-MIB::ifName.436212224 = STRING: Ethernet1/10
IF-MIB::ifName.436212736 = STRING: Ethernet1/11
IF-MIB::ifName.436213248 = STRING: Ethernet1/12
IF-MIB::ifName.436213760 = STRING: Ethernet1/13
IF-MIB::ifName.436214272 = STRING: Ethernet1/14
IF-MIB::ifName.436214784 = STRING: Ethernet1/15
IF-MIB::ifName.436215296 = STRING: Ethernet1/16
IF-MIB::ifName.436215808 = STRING: Ethernet1/17
IF-MIB::ifName.436216320 = STRING: Ethernet1/18
IF-MIB::ifName.436216832 = STRING: Ethernet1/19
IF-MIB::ifName.436217344 = STRING: Ethernet1/20
IF-MIB::ifName.436217856 = STRING: Ethernet1/21
IF-MIB::ifName.436218368 = STRING: Ethernet1/22
IF-MIB::ifName.436218880 = STRING: Ethernet1/23
IF-MIB::ifName.436219392 = STRING: Ethernet1/24
IF-MIB::ifName.436219904 = STRING: Ethernet1/25
IF-MIB::ifName.436220416 = STRING: Ethernet1/26
IF-MIB::ifName.436220928 = STRING: Ethernet1/27
IF-MIB::ifName.436221440 = STRING: Ethernet1/28
IF-MIB::ifName.436221952 = STRING: Ethernet1/29
IF-MIB::ifName.436222464 = STRING: Ethernet1/30
IF-MIB::ifName.436222976 = STRING: Ethernet1/31
IF-MIB::ifName.436223488 = STRING: Ethernet1/32
IF-MIB::ifName.436224000 = STRING: Ethernet1/33
IF-MIB::ifName.436224512 = STRING: Ethernet1/34
IF-MIB::ifName.436225024 = STRING: Ethernet1/35
IF-MIB::ifName.436225536 = STRING: Ethernet1/36
IF-MIB::ifName.436226048 = STRING: Ethernet1/37
IF-MIB::ifName.436226560 = STRING: Ethernet1/38
IF-MIB::ifName.436227072 = STRING: Ethernet1/39
IF-MIB::ifName.436227584 = STRING: Ethernet1/40
IF-MIB::ifName.436228096 = STRING: Ethernet1/41
IF-MIB::ifName.436228608 = STRING: Ethernet1/42
IF-MIB::ifName.436229120 = STRING: Ethernet1/43
IF-MIB::ifName.436229632 = STRING: Ethernet1/44
IF-MIB::ifName.436230144 = STRING: Ethernet1/45
IF-MIB::ifName.436230656 = STRING: Ethernet1/46
IF-MIB::ifName.436231168 = STRING: Ethernet1/47
IF-MIB::ifName.436231680 = STRING: Ethernet1/48
IF-MIB::ifName.436232192 = STRING: Ethernet1/49
IF-MIB::ifName.436232704 = STRING: Ethernet1/50
IF-MIB::ifName.436233216 = STRING: Ethernet1/51
IF-MIB::ifName.436233728 = STRING: Ethernet1/52
IF-MIB::ifName.436234240 = STRING: Ethernet1/53
IF-MIB::ifName.436234752 = STRING: Ethernet1/54
IF-MIB::ifName.436235264 = STRING: Ethernet1/55
IF-MIB::ifName.436235776 = STRING: Ethernet1/56
IF-MIB::ifName.436236288 = STRING: Ethernet1/57
IF-MIB::ifName.436236800 = STRING: Ethernet1/58
IF-MIB::ifName.436237312 = STRING: Ethernet1/59
IF-MIB::ifName.436237824 = STRING: Ethernet1/60
IF-MIB::ifName.436238336 = STRING: Ethernet1/61
IF-MIB::ifName.436238848 = STRING: Ethernet1/62
IF-MIB::ifName.436239360 = STRING: Ethernet1/63
IF-MIB::ifName.436239872 = STRING: Ethernet1/64
IF-MIB::ifName.436240384 = STRING: Ethernet1/65
IF-MIB::ifName.436240896 = STRING: Ethernet1/66
IF-MIB::ifName.436241408 = STRING: Ethernet1/67
IF-MIB::ifName.436241920 = STRING: Ethernet1/68
IF-MIB::ifName.436242432 = STRING: Ethernet1/69
IF-MIB::ifName.436242944 = STRING: Ethernet1/70
IF-MIB::ifName.436243456 = STRING: Ethernet1/71
IF-MIB::ifName.436243968 = STRING: Ethernet1/72
IF-MIB::ifName.436244480 = STRING: Ethernet1/73
IF-MIB::ifName.436244992 = STRING: Ethernet1/74
IF-MIB::ifName.436245504 = STRING: Ethernet1/75
IF-MIB::ifName.436246016 = STRING: Ethernet1/76
IF-MIB::ifName.436246528 = STRING: Ethernet1/77
IF-MIB::ifName.436247040 = STRING: Ethernet1/78
IF-MIB::ifName.436247552 = STRING: Ethernet1/79
IF-MIB::ifName.436248064 = STRING: Ethernet1/80
IF-MIB::ifName.436248576 = STRING: Ethernet1/81
IF-MIB::ifName.436249088 = STRING: Ethernet1/82
IF-MIB::ifName.436249600 = STRING: Ethernet1/83
IF-MIB::ifName.436250112 = STRING: Ethernet1/84
IF-MIB::ifName.436250624 = STRING: Ethernet1/85
IF-MIB::ifName.436251136 = STRING: Ethernet1/86
IF-MIB::ifName.436251648 = STRING: Ethernet1/87
IF-MIB::ifName.436252160 = STRING: Ethernet1/88
IF-MIB::ifName.436252672 = STRING: Ethernet1/89
IF-MIB::ifName.436253184 = STRING: Ethernet1/90
IF-MIB::ifName.436253696 = STRING: Ethernet1/91
IF-MIB::ifName.436254208 = STRING: Ethernet1/92
IF-MIB::ifName.436254720 = STRING: Ethernet1/93
IF-MIB::ifName.436255232 = STRING: Ethernet1/94
IF-MIB::ifName.436255744 = STRING: Ethernet1/95
IF-MIB::ifName.436256256 = STRING: Ethernet1/96
IF-MIB::ifName.436256768 = STRING: Ethernet1/97
IF-MIB::ifName.436257280 = STRING: Ethernet1/98
IF-MIB::ifName.436257792 = STRING: Ethernet1/99
IF-MIB::ifName.436258304 = STRING: Ethernet1/100
IF-MIB::ifName.436258816 = STRING: Ethernet1/101
IF-MIB::ifName.436259328 = STRING: Ethernet1/102
louis
3
The reason for this is that the port is marked as deleted
select ifname, deleted from ports where device_id = 29;
±----------------±--------+
| ifname | deleted |
±----------------±--------+
| mgmt0 | 0 |
| port-channel14 | 0 |
| port-channel15 | 1 |
| port-channel424 | 0 |
| port-channel474 | 1 |
| port-channel509 | 0 |
| Ethernet1/1 | 0 |
| Ethernet1/2 | 0 |
| Ethernet1/3 | 0 |