MySQL Forums
Forum List  »  Replication

Re: Mysql replication
Posted by: Aftab Khan
Date: August 24, 2012 02:27AM

>Last_SQL_Errno: 1032

Error 1032 means "No such row", so this can be application logic when one of rows somehow doesn't exists on another server. With master-master replication this is possible.

Please compare if both slaves contain same data. Also you can temporarily switch binary log format to STATEMENT to get more human-readable error, when check if such a row exists in the server where replication is stopped.

Please provide output of SHOW CREATE TABLE ssg.cluster_master\G on both servers.

Options: ReplyQuote


Subject
Views
Written By
Posted
5147
August 21, 2012 04:07AM
2200
August 22, 2012 09:51PM
5287
August 24, 2012 12:14AM
Re: Mysql replication
3064
August 24, 2012 02:27AM
2717
August 26, 2012 06:20PM
2774
August 27, 2012 08:32AM
2400
August 27, 2012 05:55PM
2063
August 24, 2012 04:49AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.