Hello.
> 'pmv_manager_log_bin.000069' at position 743 Find out with mysqlbinlog utility what statement causes the error. Then execute it manually on the slave to get an error code which it produces. What version of MySQL are you using? May be with the fresher one you will get more information from the error log. AESYS S.p.A. [Enzo Arlati] wrote: > 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 > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
