Migration failed: Syntax error or access violation: 1091 Can't DROP INDEX `PRIMARY`; check that it exists (Conne ction: mysql, SQL: alter table `bill_data` drop primary key)

Help
1

Hey guys,

Got this error at debian 11 and mariadb 10.x but it remained after update to debian 11 and mariadb 11.1.5

Any help is appreciated.

===========================================

Component Version
LibreNMS 24.5.0-11-gc7708922a (2024-05-23T05:03:51+02:00)
DB Schema 2024_01_09_211518_custom_map_node_maplink (286)
PHP 8.2.18
Python 3.11.2
Database MariaDB 11.1.5-MariaDB-deb12
RRDTool 1.7.2
SNMP 5.9.3
===========================================

[OK] Composer Version: 2.7.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 829:

SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP INDEX PRIMARY; check that it exists (Conne
ction: mysql, SQL: alter table bill_data drop primary key)

In Connection.php line 587:

SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP INDEX PRIMARY; check that it exists

2

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.