Trying to manually run lnms migrate, need help

I just upgraded to Ubuntu 20.04 in place and rebooted. I’m now running a supported version of Mariadb.

librenms@librenms:~$ git pull origin master
From https://github.com/librenms/librenms
 * branch                master     -> FETCH_HEAD
Already up to date.
librenms@librenms:~$ git remote
composer
origin
librenms@librenms:~$ ./daily.sh
Fetching new release information                   OK
Between releases, waiting for newer release
Updating Composer packages                         OK
Updated from unset to                              OK
Updating SQL-Schema                                OK
Updating submodules                                OK
Cleaning up DB                                     OK
Fetching notifications                             OK
Caching PeeringDB data                             OK
librenms@librenms:~$ ./validate.php
====================================
Component | Version
--------- | -------
LibreNMS  | 21.4.0-55-g4821c2b37
DB Schema | 2020_12_14_091314_create_port_group_port_table (202)
PHP       | 7.3.27-9+ubuntu18.04.1+deb.sury.org+1
Python    | 3.8.5
MySQL     | 10.3.25-MariaDB-0ubuntu0.20.04.1
RRDTool   | 1.7.2
SNMP      | NET-SNMP 5.8
====================================

[OK]    Composer Version: 2.0.12
[OK]    Dependencies up-to-date.
[OK]    Database connection successful
[FAIL]  Your database is out of date!
        [FIX]:
        ./lnms migrate
librenms@librenms:~$ ./lnms migrate
**************************************
*     Application In Production!     *
**************************************

 Do you really wish to run this command? (yes/no) [no]:
 > yes

Migrating: 2020_12_14_091314_create_port_groups_table

In Connection.php line 678:

  SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'port_groups' already exists (SQL: create table `port_groups` (`id` int unsigned not null
  auto_increment primary key, `name` varchar(255) not null, `desc` varchar(255) null) default character set utf8mb4 collate 'utf8mb4_unicode_ci')


In Exception.php line 18:

  SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'port_groups' already exists


In PDOStatement.php line 112:

  SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'port_groups' already exists


librenms@librenms:~$

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