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 |
| SNMP | NET-SNMP 5.7.3 |
====================================
[OK] Composer Version: 1.8.5
[OK] Dependencies up-to-date.
[OK] Database connection successful
[OK] Database schema correct
$
Thanks!
Allie