Skip to main content
NetApp Knowledge Base

MySQL replication problem in an NLB SnapCenter configuration

  1. Last updated
    May 12, 2020
  2. Save as PDF
Views:
422
Visibility:
Public
Votes:
0
Category:
snapcenter
Specialty:
SNAPX
Last Updated:
5/12/2020, 8:17:58 AM

Applies to

  • SnapCenter Server 4.0 and above
  • NLB configuration 


Issue

Customers get errors and (if configured) an email every minute reporting an issue with the MySQL replication. 

Following error appears:
Replication of the repository failed on the database server 

The reason and result of the failure is seen as following:

Got fatal error 1236 from master when reading data from binary log: 'Client requested master to start replication from position > file size'

The replica is requesting data at a certain point in the log (its current position), but the master's log file does not reach that point (so there are missing entries). Replication stops because this is a logic error.

 

 

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.