跳转到主内容

SnapCenter 升级后 SnapCenter HA 复制失败

  1. 最后更新
  2. 另存为PDF
Views:
6
Visibility:
Public
Votes:
0
Category:
snapcenter
Specialty:
snapx
Last Updated:

适用于

  • SnapCenter 服务器 [SC]
  • F5 高可用性 [HA]
  • MySQL [NSM]

问题描述

  • SnapCenter 升级后 SnapCenter MySQL 复制失败：
    • Error: SnapCenter repository database restore failed with error : MySQL query execution failed with error : ERROR 3734 (HY000) at line 1178: Failed to add the foreign key constraint. Missing column 'NetAppAccountId' for constraint 'FK_nsm_AzureNetAppFiles_StorageFootprint_nsm_AzureNetAppAccount' in the referenced table 'nsm_AzureNetAppAccount'
  • 运行 Get-SmRepositoryConfig 时看到复制问题消息：
    • Replication of the repository failed with error: Worker 1 failed executing transaction 'ANONYMOUS' at source log mysql-bin.xxxx, end_log_pos xxxx; Error executing row event: 'Table 'nsm.<Table_Name>' doesn't exist'.
      You can manually correct the error or rebuild the repository on <SC_Node_IP> by running the'Set-SmRepositoryConfig' cmdlet with the '-ServerToRebuild' option.

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.