SnapCenter is unable to remove decommissioned host
Applies to
- SnapCenter Server (SC) 4.8 or earlier
- SnapCenter MySQL NSM database
Issue
- Unable to remove a host or cluster in the SC GUI or via PowerShell (PS) when it has been decommissioned
- 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, list of error that can happen :
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`)