I keep getting this error on a device using the ag...
# general
b
I keep getting this error on a device using the agent:
Error polling unix-agent module. Check log file for more details.
File is the full log, the applications are still polling and graphing data. Validate is good.
Copy code
Component | Version
--------- | -------
LibreNMS  | 26.5.1 (2026-05-20T05:00:19-05:00)
DB Schema | 2026_05_06_145721_regenerate_devices_table_display_field (386)
PHP       | 8.3.31
Python    | 3.12.13
Database  | MariaDB 12.3.2-MariaDB-log
RRDTool   | 1.8.0
SNMP      | 5.9.4.pre2
===========================================

[OK]    Composer Version: 2.10.1
[OK]    Dependencies up-to-date.
[OK]    Database Connected
[OK]    Database Schema is current
[OK]    SQL Server meets minimum requirements
[OK]    lower_case_table_names is enabled
[OK]    MySQL engine is optimal
[OK]    Database and column collations are correct
[OK]    Database schema correct
[OK]    MySQL and PHP time match
[OK]    Distributed Polling setting is enabled globally
[OK]    Connected to rrdcached
[OK]    Active pollers found
[OK]    Dispatcher Service is enabled
[OK]    Locks are functional
[OK]    No python wrapper pollers found
[OK]    Redis is functional
[OK]    rrdtool version ok
[OK]    Connected to rrdcached
While reviewing the log, the actual failure appears to be: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'vsz' The failing process is: /usr/sbin/mariadbd vsz = 8592480816 The current processes table schema on my installation is: CREATE TABLE processes ( id bigint unsigned, device_id int unsigned, pid int, vsz int(11) NOT NULL, rss int(11) NOT NULL, ... ) Since vsz is an INT, the maximum signed value is 2147483647, but the unix-agent is attempting to insert a VSZ value of 8592480816 for the MariaDB process. https://cdn.discordapp.com/attachments/327529583601647617/1513973852927951038/message.txt?ex=6a29ad86&is=6a285c06&hm=5a4aa867b71373fd4c5ef72cd3979a7c20a6ab770425160063f8ffe3360ea929& https://cdn.discordapp.com/attachments/327529583601647617/1513973853250916422/image.png?ex=6a29ad86&is=6a285c06&hm=9074f67474c231ed7c1d592256b24402c089333e1a6711dd01f8dd4b9dfe0eea&
2 Views