Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected] for any comments or concerns.

replication error

das-ichdas-ich EntrantInactive User Role Beginner
Hi all.

My replication stopped with error Last_SQL_Errno: 1032 or Last_SQL_Errno: 1062
example error:
Last_SQL_Error: Could not execute Delete_rows event on table cportal.b_search_content_stem; Can't find record in 'b_search_content_stem', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mk-db1-master-bin.000488, end_log_pos 74862564

I am found this issue http://www.percona.com/blog/2013/09/13/enabling-crash-safe-slaves-with-mysql-5-6/
but it not working for me.
my version is Percona-Server-server-56-5.6.21-rel69.0.el6.x86_64.

my slave cnf http://pastebin.com/wTdcbTwU
my master cnf http://pastebin.com/q2uJAynU

thanks for help

Comments

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.