SC Server - 无法删除主机 - 外部密钥限制错误
适用场景
SnapCenter (所有版本)
问题描述
由于以下列出的 toe 错误,无法删除主机。
2021-07-19T15:04:20.0648348+00:00 DEBUG SnapManagerWeb_9241 PID=[3756] TID=[28] Failed to remove file system resource. Details: 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`)
2021-07-19T15:04:20.0648348+00:00 DEBUG SnapManagerWeb_9241 PID=[3756] TID=[28] RemoveSCWResource - exit
2021-07-19T15:04:20.0648348+00:00 DEBUG SnapManagerWeb_9241 PID=[3756] TID=[28] Catch an exception in RemoveSCWResource: 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`)