スキーマの作成に失敗したため、 SnapCenter サーバを 4.3 にアップグレードできません
環境
SnapCenter サーバ 4.3.X
問題
- SnapCenter サーバを 4.3.X にアップグレードするとエラーが発生して失敗します
ERROR: SnapCenter Schema Creation failed. Check the DotMigrate logs in the Windows Temp folder for more details.
-
%TEMP%\DotMigrate_MySQL_4.3.logエラーを表示します
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 のエラーログに警告が表示されます
[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.