I have 2 instances, both are exhibiting similar issues, albeit slightly different SQL errors, so let’s try and resolve this first one!
./validate.php
====================================
Component Version LibreNMS 21.9.0-68-g7883218cf DB Schema 2021_09_07_094310_create_push_subscriptions_table (218) PHP 7.4.24 Python 3.8.10 MySQL 10.3.31-MariaDB-0ubuntu0.20.04.1 RRDTool 1.7.2 SNMP NET-SNMP 5.8 ====================================
[OK] Composer Version: 2.1.8
[OK] Dependencies up-to-date.
[OK] Database connection successful
[FAIL] Your database is out of date!
[FIX]:
./lnms migrate
No worries, let’s run ./lnms migrate
Application In Production! *
Do you really wish to run this command? (yes/no) [no]:
yes
Migrating: 2021_25_01_0127_create_isis_adjacencies_table
In Connection.php line 703:
SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘isis_adjacencies’ already exists (SQL: create table
isis_adjacencies
(id
int unsigned not null auto_increment primary key,device_id
int not null,port_i d
int not null,ifIndex
int not null,isisISAdjState
varchar(13) not null,isisISAdjNeighSysType
varchar(128) not null,isisISAdjNeighSysID
varchar(128) not null,isisISAdjNeighPriority
varchar(128) not null,isi sISAdjLastUpTime
bigint unsigned not null,isisISAdjAreaAddress
varchar(128) not null,isisISAdjIPAddrType
varchar(128) not null,isisISAdjIPAddrAddress
varchar(128) not null) default character set utf8mb4 collate ‘ut
f8mb4_unicode_ci’)In Exception.php line 18:
SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘isis_adjacencies’ already exists
In PDOStatement.php line 117:
SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘isis_adjacencies’ already exists
I had some previous SQL errors. I managed to find solutions to those on other forum posts. This one I cannot find a solution to. I don’t imagine dropping the table to get past the error is a smart idea.