0

I face this error many times with my replication

Last_SQL_Error: Could not execute Delete_rows event on table db_name.event; Can't find record in 'event', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.000131, end_log_pos 2869333

and I solved it by backup the database and restore it back to the another server then Restart the replication by CHANGE MASTER TO MASTER_LOG_FILE and MASTER_LOG_POS.

But I need to know the reason of that! why it happened?

Improve this question
3
  • This is one of the error for MySQL Replication when MASTER and SLAVE replica not in sync. The Reason for replication getting out of sync due to various reasons. But the common cause is particular table row or data not matched/missing on the slave while applying transaction received from MASTER. This transaction can be insert/update/delete type. Commented Jul 22, 2018 at 12:43
  • so i need to know why that happen as i configured it to be Master-Master replication so any data deleted,inserted or updated must be changed on both! Commented Jul 22, 2018 at 14:09
  • If you don't want to have this kind of problem, why don't use galera replication? Commented Jul 22, 2018 at 16:46

0

Reset to default

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.