How do I fix Replication event checksum verification failed while reading from network. Error_code: 1743

Our server had disk space problems. As a result, replication's IO Threads fails to start.

Here are the errors in mysql error log:


[Note] Slave I/O thread: connected to master
'user@host:3307',replication started in log 'mysql-bin.000030' at
position 196820914


[ERROR] Slave I/O: Replication event checksum verification failed
while reading from network. Error_code: 1743


[ERROR] Slave I/O: Relay log write failure: could not queue event from
master, Error_code: 1595

How do I fix the problem?

Try resetting the relay logs as follows:

STOP SLAVE;
CHANGE MASTER TO master_log_file='mysql-bin.000030',master_log_pos=196820914;
START SLAVE;

This will erase all relay logs in the Slave, starting with a fresh one. It should start retrieving binlog events from the Master. If it fails again, then mysql-bin.000030 on the Master may be corrupt. In that event, you would have to set up replication from scratch by doing this:

• Stop the DB Application

• On the Master, RESET MASTER;

• mysqldump the data from the Master

• Load the mysqldump on the Slave

• On the Slave, run STOP SLAVE;

• On the Slave, run CHANGE MASTER TO master_log_file='mysql-bin.000001',master_log_pos=4;

• On the Slave, run START SLAVE;

CAVEAT

Make sure the network connection is clear (with no dropped packets) between Master and Slave.
Give it a Try !!!

StackExchange Database Administrators Q#62368, answer score: 9