Hi, I got some mysql server connectet with the replica enabled and from time to time it appen that the replicated data are still be inserted in the slave, so the replication server stop working due the duplicate entry error. For my purpose there is no matter to ignore these errors so I try to use the parameters --slave_skip_error=1062 in configuration my.ini file . I restart the server but the slave replication continue to stop for error, what is changed is that now didn't report the cause of the error. There is something wrong in all that and I don't known if it is a some of my mistake in the way I'm using this command or some other problem. I didn't known how to solve the problem, if someone can help, I'm just waiting.... regards, Ezno
********************************** ** with slave-skip-errors = off ** ********************************** 051227 16:57:43 [ERROR] Slave: Error 'Duplicate entry '7325' for key 1' on query. Default database: 'pmv_manager'. Query: 'INSERT INTO log_st ( IDROW, ......... , DT_MOD) values ( 7325, ..., current_timestamp )', Error_code: 1062 *********************************** ** with slave-skip-errors = 1062 ** *********************************** 051227 17:07:36 [Note] Slave SQL thread initialized, starting replication in log 'pmv_manager_log_bin.000069' at position 743, relay log '.\enzo4-relay-bin.041541' position: 9336 051227 17:07:36 [Note] Slave SQL thread exiting, replication stopped in log 'pmv_manager_log_bin.000069' at position 743 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
