Issue with Custom SQL Query Alert Rules after update last night

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:

[[email protected] 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

[[email protected] 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

[[email protected] 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

Any thoughts on this? The issues continue and we haven’t been able to find any reason why.