MySQL Forums
Forum List  »  Replication

5.7.23 IO_THREAD stops with Heartbeat error
Posted by: Van Stokes
Date: November 26, 2018 12:50PM

MySQL Version: 5.7.23-community (from MySQL ppa)
OS: Ubuntu 16.04.3
Replication Type: Circular Multi-Master

This morning our replication was running fine. Then one of our master/slave servers' IO_THREAD just stopped working with the following error:

2018-11-26T16:45:31.993523Z 179530 [ERROR] Slave I/O for channel '': Unexpected master's heartbeat data: heartbeat is not compatible with local info; the event's data: log_file_name master-bin.0059625��� log_pos 651598942, Error_code: 1623
2018-11-26T16:45:31.993567Z 179530 [ERROR] Slave I/O for channel '': Relay log write failure: could not queue event from master, Error_code: 1595
2018-11-26T16:45:31.993577Z 179530 [Note] Slave I/O thread exiting for channel '', read up to log 'master-bin.005962', position 2281364567

I tried pointing the failing master/slave to other masters but keep getting the same error but with different logs name and position. Except for the number of processors and RAM, all the master servers are configured the same in the mysql.cnf file. I have tried restarting a master and the failing master/slave but it didn't help. I have also searched the internet for similar issues but I can't seem to find any relative info.

Any help regarding this error would be appreciative.

Options: ReplyQuote

Written By
5.7.23 IO_THREAD stops with Heartbeat error
November 26, 2018 12:50PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.