nixsap icon indicating copy to clipboard operation
nixsap copied to clipboard

mariadb: handle error 1594

Open ip1981 opened this issue 8 years ago • 0 comments

Error 1594 ("Relay log read failure: Could not parse relay log event entry. The possible reasons are: the master's binary log is corrupted") can be recovered automatically:

  1. Get Relay_Master_Log_File and Exec_Master_Log_Pos from mysql -e 'show slave status\G'.
  2. Stop slave.
  3. Change master log file and position: CHANGE MASTER TO MASTER_LOG_FILE=Relay_Master_Log_File, MASTER_LOG_POS=Exec_Master_Log_Pos;.
  4. Start slave.

ip1981 avatar May 18 '17 19:05 ip1981