You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
My installation started giving an error about the maximum id in the device_perf table being overflowed.
CREATE TABLE device_perf ( id int(10) unsigned NOT NULL AUTO_INCREMENT,
...
) ENGINE=InnoDB AUTO_INCREMENT=4294967296 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
Output of ./validate.php
===========================================
Component | Version
--------- | -------
LibreNMS | 24.3.0-6-gf1070108e (2024-04-04T15:33:27+03:00)
DB Schema | 2024_02_07_151845_custom_map_additions (296)
PHP | 8.1.17
Python | 3.6.8
Database | MariaDB 10.5.18-MariaDB
RRDTool | 1.7.1
SNMP | 5.7.2
===========================================
[OK] Composer Version: 2.7.2
[OK] Dependencies up-to-date.
[OK] Database connection successful
[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 not detected
[OK] Locks are functional
[FAIL] Some poller nodes have not checked in recently
Inactive Nodes:
poller20_0
[OK] Redis is unavailable
[WARN] IPv6 is disabled on your server, you will not be able to add IPv6 devices.
[OK] rrdtool version ok
[OK] Connected to rrdcached
[FAIL] Scheduler is not running
[FIX]:
sudo cp /opt/librenms/dist/librenms-scheduler.service /opt/librenms/dist/librenms-scheduler.timer /etc/systemd/system/
sudo systemctl enable librenms-scheduler.timer
sudo systemctl start librenms-scheduler.timer
[WARN] Your install is over 24 hours out of date, last update: Thu, 04 Apr 2024 12:33:27 +0000
[FIX]:
Make sure your daily.sh cron is running and run ./daily.sh by hand to see if there are any errors.
What was the last working version of LibreNMS?
24.3.0-6
Anything in the logs that might be useful for us?
SQLSTATE[22003]: Numeric value out of range: 167 Out of range value for column 'id' at row 1 (Connection: mysql, SQL: insert into `device_perf` (`min`, `max`, `avg`, `xmt`, `rcv`, `loss`, `debug`, `device_id`, `timestamp`) values (1.38, 1.7, 1.5, 3, 3, 0, {"poller_name":"poller12_0"}, 16666, 2024-04-10 12:16:44))
The text was updated successfully, but these errors were encountered:
Negatifff
changed the title
The maximum value for the declared type in the database has been reached
The maximum value for the declared type in the DB table device_perf has been reached
Apr 10, 2024
The problem
My installation started giving an error about the maximum id in the device_perf table being overflowed.
CREATE TABLE
device_perf
(id
int(10) unsigned NOT NULL AUTO_INCREMENT,...
) ENGINE=InnoDB AUTO_INCREMENT=4294967296 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
Output of ./validate.php
What was the last working version of LibreNMS?
24.3.0-6
Anything in the logs that might be useful for us?
The text was updated successfully, but these errors were encountered: