SnapCenter无法删除已停用的主机

适用场景

• SnapCenter服务器(SC) 4.8或更早版本
• SnapCenter MySQL NSM数据库

问题描述

• 停用主机或集群后、无法在SC图形用户界面中或通过PowerShell (PS)删除此主机或集群
  • PowerShell

Remove-SmHost -HostNames <Host_FQDN> -Force
WARNING: HostName could not be resolved, continuing with host removal for the following hosts: <Host_FQDN>

• SnapManagerWeb.log，可能发生的错误列表：

ERROR SnapManagerWeb_<job id> PID=[xxxx] TID=[xxx] Unable to connect to the remote server. A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 1.2.3.4:8145
DEBUG SnapManagerWeb_<job id> PID=[xxxx] TID=[xxx] error calling smcore https://<hostname>:8145/SMProtectionGroupService/SchedulerTaskAction, for managing schedulers. Error: Failed to set host '<hostname>' in Production mode. The plug-in services might be down. Ensure that the plug-in services are up and running to proceed.

Failed to find host (host.domain.com). Verify if the host is up and running and check the DNS and firewall settings

Cannot remove the host related objects from the database. This issue might occur if you try to delete multiple hosts at the same time. You must delete one host at a time.

ERROR SnapManagerWeb_<job id> PID=[xxx] TID=[xxx] System.Data.Entity.Infrastructure.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.Data.Entity.Core.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---> Devart.Data.MySql.MySqlException: Cannot delete or update a parent row: a foreign key constraint fails (`nsm`.`nsm_smsql_databasefile`, CONSTRAINT `FK_nsm_smsql_DatabaseFile_nsm_StorageFootprint` FOREIGN KEY (`nsm_StorageFootPrint_id`) REFERENCES `nsm_storagefootprint` (`nsm_StorageFootprint_id`)