MySQL replication problem in an NLB SnapCenter configuration
- Last Updated:
- SnapCenter Server 4.0 and above
- NLB configuration
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.