After the update last night, we have a alert/rule to monitor interface traffic (via octets) that looks like the following:
SELECT * FROM devices,ports WHERE (devices.device_id = ? AND devices.device_id = ports.device_id) AND (ports.ifOperStatus = “up” && ports.ifAdminStatus = “up” && (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = 1 AND ports.ifOutOctets_rate < 3125 AND ports.ifDescr NOT LIKE ‘%lo%’
After last night we have 2 devices this is monitoring flap, but they never seem to fall below the threshold.
This started after the monthly update to 1.64 ran last night. Prior to we didn’t have any issues with this query/alert. and the interface traffic/octets is running at the same amount as it was prior to the update, so nothing has changed there. I have run validate.php on our 2 pollers and web frontend and that seems all good:
[root@web librenms]# ./validate.php
| Component | Version |
|---|---|
| LibreNMS | 1.64 |
| DB Schema | 2020_04_06_001048_the_great_index_rename (167) |
| PHP | 7.2.16-1+0~20190307202415.17+stretch~1.gbpa7be82 |
| Python | 3.5.3 |
| MySQL | 10.1.26-MariaDB-0+deb9u1 |
| RRDTool | 1.6.0 |
| SNMP | NET-SNMP 5.7.3 |
====================================
[OK] Composer Version: 1.10.6
[OK] Dependencies up-to-date.
[OK] Database connection successful
[OK] Database schema correct
[root@poller librenms]# ./validate.php
| Component | Version |
|---|---|
| LibreNMS | 1.64 |
| DB Schema | 2020_04_06_001048_the_great_index_rename (167) |
| PHP | 7.2.14-1+0~20190205200805.15+stretch~1.gbpd83c69 |
| Python | 3.5.3 |
| MySQL | 10.1.26-MariaDB-0+deb9u1 |
| RRDTool | 1.6.0 |
| SNMP | NET-SNMP 5.7.3 |
====================================
[OK] Composer Version: 1.10.6
[OK] Dependencies up-to-date.
[OK] Database connection successful
[OK] Database schema correct
[root@poller2 librenms]# ./validate.php
| Component | Version |
|---|---|
| LibreNMS | 1.64 |
| DB Schema | 2020_04_06_001048_the_great_index_rename (167) |
| PHP | 7.2.14-1+0~20190113100742.14+stretch~1.gbpd83c69 |
| Python | 3.5.3 |
| MySQL | 10.1.26-MariaDB-0+deb9u1 |
| RRDTool | 1.6.0 |
| SNMP | NET-SNMP 5.7.3 |
====================================
[OK] Composer Version: 1.10.6
[OK] Dependencies up-to-date.
[OK] Database connection successful
[OK] Database schema correct