binlog not containing all the queries.
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
Subject
Views
Written By
Posted
binlog not containing all the queries.
2960
October 18, 2011 08:48AM
893
October 20, 2011 04:46AM
952
October 20, 2011 06:11AM
873
October 20, 2011 11:01PM
881
October 21, 2011 06:36AM
1051
October 22, 2011 02:54AM
926
October 24, 2011 01:39AM
797
October 23, 2011 10:43AM
1026
October 24, 2011 02:40AM
1137
October 24, 2011 04:11AM
894
October 25, 2011 06:34AM
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.