Description:
hi all:
i use the version 4.0.27 to do the replication.
the question is that the error-log in slave is like this:
ERROR: 1062 Duplicate entry 'sports_h-info-20101031132859-0' for key 1
ERROR: 1062 Duplicate entry 'sports_h-info-20101031140653-0' for key 1
ERROR: 1062 Duplicate entry 'sports_h-info-20101031143642-0' for key 1
ERROR: 1062 Duplicate entry 'sports_h-info-20101031143707-0' for key 1
ERROR: 1062 Duplicate entry 'sports_h-info-20101031143734-0' for key 1
and it increases everyday,while the slave not stop and seems like everything is ok.
*************************** 1. row ***************************
Master_Host: 172.27.31.45
Master_User: repl
Master_Port: 3306
Connect_retry: 60
Master_Log_File: master_bin.434
Read_Master_Log_Pos: 399183174
Relay_Log_File: relay_bin.436
Relay_Log_Pos: 688832434
Relay_Master_Log_File: master_bin.434
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_do_db:
Replicate_ignore_db:
Last_errno: 0
Last_error:
Skip_counter: 0
Exec_master_log_pos: 399183174
Relay_log_space: 688832434
1 row in set (0.00 sec)
now what i want is which command cause this error ,but i can't find it ,because there is no infomation in "show slave status" or in err-log...help!!!
just tell me how to find the problematical command so that i can fix it.
Does anyone meet the same situation?? and i don't know what to do now ,i need your help ,my friends,please.
addition:
1,i do not ingore this error number in my.cnf
How to repeat:
i am waiting for how to repeat..