NetOps Portal Upgrade Failure: Unsupported MySQL Detected

Products

• DX NetOps
• CA Performance Management - Usage and Administration

Issue/Introduction

The following message is seen:

The current MySQL installation contains the following schemas which are not managed by this product.

These unsupported schemas must be dropped or migrated to another MySQL instance in order to complete this upgrade.

Unsupported Schemas:

#mysql50#lost+found

lost+found

Environment

All supported releases of DX NetOps Performance Management upgrading from a release prior to 21.2.8

Cause

The MySQL data directory is mounted directly to the root of a mount point causing the lost+found OS directory to be added

Resolution

We need to stop MySQL from detecting/reading the files and thinking they are a valid schema before reattempting the upgrade:

ENSURE YOU HAVE A VALID mysqldump BACKUP OF THE em AND netqosportal DATABASES BEFORE PROCEEDING

1. cd /opt/CA/MySql/data
2. Stop the 4 caperfcenter_ services
   1. systemctl stop caperf*
3. Stop MySQL
   • systemctl stop mysql
4. Change the permissions of the two lost directories to: 0
   • chmod 0 lost@002bfound
   • chmod 0 lost+found
5. Start MySQL
   • systemctl start mysql
6. login to MySQL and check for schemas:
   1. ../bin/mysql -u root -p
   2. show databases;
      • Results should be:

        +--------------------+
        | Database           |
        +--------------------+
        | information_schema |
        | em                 |
        | mysql              |
        | netqosportal       |
        | performance_schema |
        | sys                |
        +--------------------+

7. Exit mysql:
   • exit
8. Start the remaining caperfcenter_ services
   • systemctl start caperfcenter_sso caperfcenter_eventmanager caperfcenter_devicemanager; sleep 25; caperfcenter_console
9. Complete the upgrade
10. After stopping services again, change the two lost files back to their original permissions:
    • chmod 700 lost+found
    • chmod 750 lost@002bfound
11. Log into the NetOps Portal and ensure functionality