NDB 无法删除策略,因为 " 更新条目时出错。有关详细信息,请参见内部异常。 "
状态信息
适用场景
- NetApp 数据代理( NDB ) 1.x
- 适用于 VMware vSphere 的 Snap Center 插件( SCV ) 4.3 及更高版本
问题描述
- 由于以下错误, NDB/SCV 无法删除策略。
Unable to delete policy with name <Policy Name> from SnapCenter Server : An error occurred while updating the entries. See the inner exception for details.
ProtectionService-<YYYYMMDD>.log
显示以下错误:
[ERR] [ServiceName:Policy] [RequestId:XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX] [CorrId:] [JobId:]
Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details.
---> MySql.Data.MySqlClient.MySqlException: Cannot delete or update a parent row: a foreign key constraint fails (`nsm`.`nsm_ProtectionNode`, CONSTRAINT `FK_nsm_ProtectionNode_nsm_Policy` FOREIGN KEY (`nsm_PolicyId`) REFERENCES `nsm_Policy` (`nsm_Policy_Id`))
---> MySql.Data.MySqlClient.MySqlException: Cannot delete or update a parent row: a foreign key constraint fails (`nsm`.`nsm_ProtectionNode`, CONSTRAINT `FK_nsm_ProtectionNode_nsm_Policy` FOREIGN KEY (`nsm_PolicyId`) REFERENCES `nsm_Policy` (`nsm_Policy_Id`))
at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in C:\projects\mysqlconnector\src\MySqlConnector\Core\ResultSet.cs:line 42
--- End of inner exception stack trace ---