When I login today, I got an error
Database inconsistencies found during a database error, please fix to continue.
Your database is out of date!
./lnms migrate
This is the output
./validate.php
Component | Version |
---|---|
LibreNMS | 24.1.0-51-g30953c386 (2024-01-31T22:56:59+08:00) |
DB Schema | 2023_04_26_185850_change_vminfo_vmw_vm_guest_o_s_nullable (257) |
PHP | 8.2.7 |
Python | 3.10.12 |
Database | MariaDB 10.11.4-MariaDB-1~deb12u1 |
RRDTool | 1.7.2 |
SNMP | 5.9.1 |
=========================================== |
[OK] Composer Version: 2.6.6
[OK] Dependencies up-to-date.
[FAIL] APP_KEY does not match key used to encrypt data. APP_KEY must be the same on all nodes.
[FIX]:
If you rotated APP_KEY, run lnms key:rotate to resolve.
[OK] Database connection successful
[FAIL] Your database is out of date!
[FIX]:
./lnms migrate
Attempt to fix this issue (y or n)?:y
In Connection.php line 822:
SQLSTATE[HY000]: General error: 1025 Error on rename of ‘./librenms/vendor_ouis’ to ‘./librenms/#sql-backup-1-c73e9’ (errno: 168 “Unknown (gen
eric) error from engine”) (Connection: mysql, SQL: ALTER TABLE vendor_ouis CHANGE oui oui VARCHAR(12) NOT NULL)
In Connection.php line 580:
SQLSTATE[HY000]: General error: 1025 Error on rename of ‘./librenms/vendor_ouis’ to ‘./librenms/#sql-backup-1-c73e9’ (errno: 168 “Unknown (gen
eric) error from engine”)
How can I fix it, thanks ?