hi everybody,

Just a note of a problem I found - to see whether worth reporting this as a bug, or suggest that someone mention it in the manual.

In short: *when replication fails because 'max_packet_size' is too small, that failure can corrupt the relay logs*. So even when you fix the max_packet_size, you get another replication error.

I got into this problem, and I've found a couple of mentions of other people having this problem on Google.

The fix is this: (1) stop slave (make a note of Exec_master_log); (2) set max_packet_size to be larger; (3) do a CHANGE MASTER to re-read logs from the Exec_master_log position; (4) start slave.

Tom.

Reply via email to