MySQL Forums
Forum List  »  Replication

binlog not containing all the queries.
Posted by: Sunil Divyeshvar
Date: October 18, 2011 08:48AM

Hello,

i am getting " Last_SQL_Errno: 1062
Last_SQL_Error: Error 'Duplicate entry" issue on slave server.

i use mysqlbinlog utility and checked binlog files and i got that "SET INSERT_ID" was missing there for some entries.

Means if i hv 1 to 10 entry in my table i got

SET INSERT_ID = 1
"insert query...

and then directly

SET INSERT_ID = 3 ,
"insert query...

SET INSERT_ID = 5

Inshort some of the primary key entries were missing though they are available in database.

So i felt confuse that is binlog not contain all the changes ???

What is the reason for duplicate entry on slave server ?
why some of the primary keys are not the same as on master .

suppose on master i am having the primary key 12 with some data and on slave i hv same data on primary key 13 .

same on master i have primary key 13 with some data and those data are there on slave having primary key 12

Please Help

Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
binlog not containing all the queries.
2960
October 18, 2011 08:48AM


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.