SnapCenter does not discover disks when stale MySQL is left behind for old disks

Applies to

SnapCenter Server (SC)

SnapCenter Plug-In for Windows (SCW)

Issue

• Disks are not discovered when attempting to Refresh Disks in the SnapCenter GUI or running Get-SmResources in PowerShell
• The error below is reported in the SnapManagerWeb.log file

INFO  SnapManagerWeb_JOB_ID PID=[2412] TID=[80] Found StorageFileSystem with LUN serial number <serial number> and mount F:\
INFO  SnapManagerWeb_JOB_ID PID=[2412] TID=[80] StorageFileSystem count: 1
WARN  SnapManagerWeb_JOB_ID PID=[2412] TID=[80] StorageFootprint NOT found for the file system [F:\]. Stale entry [###] is present in nsm_StorageFileSystem.

DEBUG SnapManagerWeb_JOB_ID PID=[2412] TID=[80] Removing storage footprint with id (###) for the file system resource <server name>#F:\
DEBUG SnapManagerWeb_JOB_ID PID=[2412] TID=[80] Removing storage file system (F:\) with id (###) for the resource <server name>#F:\
DEBUG SnapManagerWeb_JOB_ID PID=[2412] TID=[80] Failed to remove file system resource. Details: Cannot delete or update a parent row: a foreign key constraint fails (`nsm`.`nsm_sce_databasefile`, CONSTRAINT `FK_nsm_sce_DatabaseFile_nsm_storagefilesystem` FOREIGN KEY (`nsm_storagefilesystem_id`) REFERENCES `nsm_StorageFileSystem` (`nsm_StorageFileSystem_Id`)