Дерево страниц
Перейти к концу метаданных
Переход к началу метаданных

При получении подобной ошибки проверяем статус slave, из mysql:

mysql> show slave status\G;


Признаки проблемы:

Slave_IO_Running - Yes

Slave_SQL_Running - No

Last_Errno: 1594

Last_Error: Relay log read failure: Could not parse relay log event entry.

The possible reasons are: the master's binary log is corrupted

(you can check this by running 'mysqlbinlog' on the binary log),

the slave's relay log is corrupted (you can check this by running

'mysqlbinlog' on the relay log), a network problem, or a bug in the

master's or slave's MySQL code. If you want to check the master's

binary log or slave's relay log, you will be able to know their names


Запоминаем для решения:

Relay_Master_Log_File = mysql-bin.001078

Exec_Master_Log_Pos = 61783410


Перезагружаем репликацию:

STOP SLAVE;

RESET SLAVE;

CHANGE MASTER TO master_log_file='mysql-bin.001078', master_log_pos=61783410;

START SLAVE;



  • Нет меток