BIGINT UNSIGNED value is out of range -- Top Devices Widget

I’ve previously posted about this in discord and @murrant offered lots of help but I’ve not yet found a resolution. The Top Devices Widget Traffic Query on my server is unusable due to frequent “Problem with backend” errors.
Other queries work fine.
Other widgets work fine.

Setting app_debug=true provides me the following:
QueryException: SQLSTATE[22003]: Numeric value out of range: 1690 BIGINT UNSIGNED value is out of range in ‘(librenms.ports.ifInOctets_rate + librenms.ports.ifOutOctets_rate)’ (SQL: select device_id from ports where poll_time > 1554854201 and exists (select * from devices where ports.device_id = devices.device_id) group by device_id order by SUM(ifInOctets_rate + ifOutOctets_rate) desc limit 15)

After frequently checking (FROM ports ORDER BY ifOutOctets_rate DESC & FROM ports ORDER BY ifInOctets_rate DESC) I’ve never seen it occur on one of our switches and it seems primarily to happen with our APCs and VMware host devices.

I will happily provide any additional information.

Oh, and…

$ ./validate.php

Component Version
LibreNMS 1.50
DB Schema 2019_02_10_220000_add_dates_to_fdb (132)
PHP 7.2.15-0ubuntu0.18.04.2
MySQL 10.1.38-MariaDB-0ubuntu0.18.04.1
RRDTool 1.7.0


[OK] Composer Version: 1.8.5
[OK] Dependencies up-to-date.
[OK] Database connection successful
[OK] Database schema correct


4 posts were merged into an existing topic: BIGINT UNSIGNED value is out of range