跳转到主内容

CSNAPC-8087:NSM数据库中陈旧条目堆积、导致主保留失败

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

问题描述

在RemoveBackupToSnapshotInfo函数期间、SCSQL保留经常会失败、从而导致后续出现MySQL连接断开问题以及后续约束错误(由运行查询一段时间后断开MySQL连接引起)。

此时将显示以下错误:
SnapManagerWeb_1234 PID=[123] TID=[28]删除备份ID 273132的BackupToSnapshot记录时出错。错误:从服务器
SnapManagerWeb_1234 PID=[123] TID=[28] Microsoft.Entity框架Core.DbUpdateException:保存实体更改时出错。有关详细信息、请参见内部异常。
--> MySqlConnector.MySqlException (0x80004005):无法删除或更新父行:外键约束失败(`NSM`.`Nsm_backuptoobProjects_map``约束`Enter_Nsm_BackupMetadata_map_Nsm_Backup`外部键(`Nsm_Backup_ID``````
``````````
)
 
错误:从服务器
SnapManagerWeb_1234 PID=[123] TID=[38] RemoveBackupToSnapshotInfo - Exit或:
SnapManagerWeb_425169
PID=[124] TID=[16] RemoveBackupToSnapshotInfo -输入
ManagerWeb_425169 PID=[124] TID=[16]删除备份ID 273138时出错。错误:远程主机已强制关闭现有连接。
SnapManagerWeb_425169 PID=[124] TID=[16] RemoveBackupToSnapshotInfo—退出

 

Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

NetApp provides no representations or warranties regarding the accuracy or reliability or serviceability of any information or recommendations provided in this publication or with respect to any results that may be obtained by the use of the information or observance of any recommendations provided herein. The information in this document is distributed AS IS and the use of this information or the implementation of any recommendations or techniques herein is a customer's responsibility and depends on the customer's ability to evaluate and integrate them into the customer's operational environment. This document and the information contained herein may be used solely in connection with the NetApp products discussed in this document.