Update failed 1.58 to 1.64.1 SQL-SCHEMA crashed

Help
1

Dear All,

First of all I am a noob/beginner to LibreNMS and basic Linux user.

Urgent help required. I was upgrading Librenms from 1.58 to 1.64.1 through ./daily.sh script. It showed that Python 2 support dropped, hence I updated the CentOS 7 box with Python 3. After updating Python 3, ./daily.sh script, however it look like it is taking too much time at “Updating SQL-Schema” and to my bad the server rebooted.

This crashed the whole LibreNMS, Not able to pull the page. It seems like something with the DB. I ran the ./validate.php and it shows the error [FAIL] Your database is out of date!
[FIX]:
./lnms migrate

However, when I run ./lnms migrate it give me 3 error at the moment. The details are as below.
indent preformatted text by 4 spaces
[root@adl-sp-nmsus librenms]# ./daily.sh
Re-running /opt/librenms/daily.sh as librenms user
Supported PHP and Python version, switched back to master branch. OK
Updating to latest release OK
Updating Composer packages OK
Updated from 1.58 to 1.64.1 OK
Updating SQL-Schema

bash-4.2$
bash-4.2$ ./validate.php

Component Version
LibreNMS 1.64.1
DB Schema 2020_04_19_010532_eventlog_sensor_reference_cleanup (164)
PHP 7.2.27
Python 3.6.8
MySQL 5.5.65-MariaDB
RRDTool 1.4.8
SNMP NET-SNMP 5.7.2
====================================

[OK] Composer Version: 1.10.7
[OK] Dependencies up-to-date.
[OK] Database connection successful
[FAIL] Your database is out of date!
[FIX]:
./lnms migrate
bash-4.2$ ./lnms migrate

  • Application In Production!     *

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

yes

Migrating: 2020_04_06_001048_the_great_index_rename

In Connection.php line 669:

SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP ‘deleted’; check that column/key exists (SQL: ALTER TABLE access_points DROP INDEX deleted, ADD
INDEX access_points_deleted_index(deleted):wink:

In PDOStatement.php line 129:

SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP ‘deleted’; check that column/key exists

In PDOStatement.php line 127:

SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP ‘deleted’; check that column/key exists

bash-4.2$

indent preformatted text by 4 spaces

Please DB expert and LibreNMS expert help me. The NMS is monitoring some production systems.

Thanks in advance for your valuable inputs.

Bhaggu

2

Got is solved by running script one by one manually.

Ref:

Thanks
Bhaggu