Upgrading SnapCenter Server to 4.3 fails due to schema creation failure
Applies to
SnapCenter Server 4.3.X
Issue
- Upgrading SnapCenter Server to 4.3.X fails with error:
ERROR: SnapCenter Schema Creation failed. Check the DotMigrate logs in the Windows Temp folder for more details.
-
%TEMP%\DotMigrate_MySQL_4.3.logshows error:
2021-06-30 15:23:27.621 Executing SQL script C:\Users\Administrator\AppData\Local\Temp\t4buzudv.tve\4.3\4.3.0.0004_Add_ObjectName_Errors_Data_nsm_QueuedOperations.sql
2021-06-30 15:23:27.637 Error: executing SQL script C:\Users\Administrator\AppData\Local\Temp\t4buzudv.tve\4.3\4.3.0.0004_Add_ObjectName_Errors_Data_nsm_QueuedOperations.sql
2021-06-30 15:23:27.637 Error: Table 'nsm.nsm_queued_operations' doesn't exist
2021-06-30 15:23:27.672 at Devart.Data.MySql.bi.a()
at Devart.Data.MySql.bi.i()
:
at PetaPoco.Database.Execute(String sql, Object[] args)
at NetApp.Migrate.DotMigrate.MigrateDatabaseSchema(SchemaVersionList scripts)
- MySQL error log shows warning:
[Note] InnoDB: Table `nsm`.`nsm_queued_operations` is corrupted. Please drop the table and recreate it
[Warning] InnoDB: Cannot open table nsm/nsm_queued_operations from the internal data dictionary of InnoDB though the .frm file for the table exists. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html for how to resolve the issue.