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