Skip to main content
NetApp Knowledge Base

SnapCenter HA replication failing after SnapCenter upgrade

  1. Last updated
  2. Save as PDF
Views:
69
Visibility:
Public
Votes:
0
Category:
snapcenter
Specialty:
SNAPX
Last Updated:

Applies to

  • SnapCenter Server [SC]
  • F5 High Availability [HA]
  • MySQL [NSM]

Issue

  • SnapCenter MySQL replication failure post SnapCenter upgrades:
    • 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'
  • Replication issues message seen when running 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.