Unable to start database service after upgrade

Products

• VMware Smart Assurance

Issue/Introduction

After upgrading, database service unable to start.

Observed the following error message for the master locks table (master.locks) when checking upgraded database:

error : Table upgrade required. Please do "REPAIR TABLE locks" or dump/reload to fix it!

Environment

7.7.x Watch4Net

Cause

Based on the error observed in the MySQL Default instance of M&R 7.7.0.3:

[ERROR] [MY-<value>] [Server] Table upgrade required. Please do "REPAIR TABLE `locks`" or dump/reload to fix it!
[ERROR] [MY-<value>] [Server] Failed to Populate DD tables.
[ERROR] [MY-<value>] [Server] Aborting.

.Running command:

./mysqlcheck -u root -p --all-databases --check-upgrade --socket=../data/mysql.sock

We can see the following error message:

master.locks
error    : Table upgrade required. Please do "REPAIR TABLE `locks`" or dump/reload to fix it!

It appears to be related to the master.locks table, hence the master.locks table in M&R 7.5 version needs to be dropped and then perform the upgrade of 7.7.0.3 without that.

Resolution

Customer to take the following action to drop the master.locks table:

1. Ensure a safe backup of the previously created dump file (master-locks-dump.sql) is kept.
2. Drop the master.lockstable by running:

   ./mysql -u root -p --socket=../data/mysql.sock -e "DROP TABLE master.locks;"

3. Perform the 7.7.0.3 upgrade from 7.5 version and check the MySQL Default instance service status.