The maximum value for the declared type in the DB table device_perf has been reached

[Negatifff]

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

===========================================
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))