Issues w/ ./lnms migrate

[Dave]

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.