Hi,
Recently, I login to Librenms, I go the error
Database inconsistencies found during a database error, please fix to continue.
Your database is out of date!
./lnms migrate
So I run ./lnms migrate and got the following errors:
2023_06_18_201914_migrate_level_to_roles … 116ms FAIL
In Connection.php line 795:
SQLSTATE[HY000]: General error: 1025 Error on rename of ‘./librenms/users’ to ‘./librenms/#sql-backup-1-97185’ (errno: 168 “Unknown (gene
ric) error from engine”) (Connection: mysql, SQL: alter table users drop level)
In Connection.php line 580:
SQLSTATE[HY000]: General error: 1025 Error on rename of ‘./librenms/users’ to ‘./librenms/#sql-backup-1-97185’ (errno: 168 “Unknown (gene
ric) error from engine”)
This is my validate.php
librenms@pi4b-librenms:~$ ./validate.php
| Component | Version |
|---|---|
| LibreNMS | 23.8.2-31-gb51ae39e7 (2023-09-08T00:28:35+08:00) |
| DB Schema | 2023_06_18_195618_create_bouncer_tables (255) |
| PHP | 8.2.7 |
| Python | 3.10.12 |
| Database | MariaDB 10.11.3-MariaDB-1 |
| RRDTool | 1.7.2 |
| SNMP | 5.9.1 |
| =========================================== |
[OK] Composer Version: 2.6.2
[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 795:
SQLSTATE[HY000]: General error: 1025 Error on rename of ‘./librenms/users’ to ‘./librenms/#sql-backup-1-97139’ (errno: 168 “Unknown (gene
ric) error from engine”) (Connection: mysql, SQL: alter table users drop level)
In Connection.php line 580:
SQLSTATE[HY000]: General error: 1025 Error on rename of ‘./librenms/users’ to ‘./librenms/#sql-backup-1-97139’ (errno: 168 “Unknown (gene
ric) error from engine”)