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..
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..