Im using MySQL replication with binlog_format=mixed on both master and slave, but still Im getting error 1032.

[ERROR] Slave SQL: Could not execute Update_rows event on table mydb.mytable;
 Can't find record in 'tablename', Error_code: 1032; 
handler error HA_ERR_KEY_NOT_FOUND; 
the event's master log mysql-bin.000134, end_log_pos 739573, Error_code: 1032
  • Could it be that the Slave is out of sync with the Master? – Rick James Sep 8 '17 at 13:54
  • Actually its from AWS RDS, I have created the read replica there. its showing this error, after few skip replication errors I can able to sync, but after sometimes its throwing this error – Bhuvanesh Sep 8 '17 at 13:57
  • Skip is dangerous that way. You should rebuild the replica from scratch. AWS makes that "easy", correct? – Rick James Sep 8 '17 at 16:00
  • yes, you are correct – Bhuvanesh Sep 8 '17 at 16:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.