Skip to main content
We are redesigning the NetApp Knowledge Base site to make it easier to use and navigate. The new and improved site will be available the first week of October. Check out our video or read this KB article to know more about changes you’ll see on the site.
NetApp Knowledge Base

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

Views:
44
Visibility:
Public
Votes:
0
Category:
snapcenter
Specialty:
snapx
Last Updated:

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`)

 

CUSTOMER EXCLUSIVE CONTENT

Registered NetApp customers get unlimited access to our dynamic Knowledge Base.

New authoritative content is published and updated each day by our team of experts.

Current Customer or Partner?

Sign In for unlimited access

New to NetApp?

Learn more about our award-winning Support

 

******************************************************* *******************************************************