Hi Wagner, You have to start the server with the option as below for skipping the error.
--slave-skip-errorr= 1062 or all 1062 - will skip the your error as the error number is 1062 and all will skip all the errors. You have to mention specific error numbers to skip the same. -- Thanks Suresh Kuna MySQL DBA On Mon, Jan 25, 2010 at 6:06 PM, Wagner Bianchi <wagnerbianch...@gmail.com>wrote: > Hi friends, > > Last weekend I made an environment that use a MySQL Server version 4.1 that > was defined to be the MASTER and other one version 5.1 defined as SLAVE. > > Because the application that was concept working over exception, often the > SLAVE server got new error and replication stops. > > Well, I configured the my.cnf file of the SLAVE to slave_skip_errors as you > may see specified after this massage, but, the replication continue stops, > even after this configurations. > > mysql> show variables like 'slave_skip_errors'; > +-------------------+-------+ > | Variable_name | Value | > +-------------------+-------+ > | slave_skip_errors | 1 | > +-------------------+-------+ > 1 row in set (0.00 sec) > mysql> show slave status\G > *************************** 1. row *************************** > Slave_IO_State: Queueing master event to the relay log > Master_Host: 172.28.8.70 > Master_User: slave > Master_Port: 3306 > Connect_Retry: 60 > Master_Log_File: bmg58-bin.000265 > Read_Master_Log_Pos: 251871 > Relay_Log_File: pid-file-relay-bin.000007 > Relay_Log_Pos: 961348 > Relay_Master_Log_File: bmg58-bin.000003 > Slave_IO_Running: Yes > Slave_SQL_Running: No > Replicate_Do_DB: > Replicate_Ignore_DB: > Replicate_Do_Table: > Replicate_Ignore_Table: > Replicate_Wild_Do_Table: > Replicate_Wild_Ignore_Table: > Last_Errno: 1062 > Last_Error: Error 'Duplicate entry '731493' for key > 'PRIMARY'' on query. Default database: 'database'. Query: 'INSERT > INTO tb_usuario (ocu_codigo, ocu_tipo, usu_codigo, > ocu_data, ocu_obs, login_responsavel, ocu_ip) > VALUES( null, 67, > 'C986CC89AC1C071835E341D18011D25Z', now(), > 'x.', 'x.sp', null )' > Skip_Counter: 0 > Exec_Master_Log_Pos: 952913 > Relay_Log_Space: 264590369 > Until_Condition: None > Until_Log_File: > Until_Log_Pos: 0 > Master_SSL_Allowed: No > Master_SSL_CA_File: > Master_SSL_CA_Path: > Master_SSL_Cert: > Master_SSL_Cipher: > Master_SSL_Key: > Seconds_Behind_Master: NULL > Master_SSL_Verify_Server_Cert: No > Last_IO_Errno: 0 > Last_IO_Error: > Last_SQL_Errno: 1062 > Last_SQL_Error: Error 'Duplicate entry '731493' for key > 'PRIMARY'' on query. Default database: 'database'. Query: 'INSERT > INTO tb_usuario (ocu_codigo, ocu_tipo, usu_codigo, > ocu_data, ocu_obs, login_responsavel, ocu_ip) > VALUES( null, 67, > 'C986CC89AC1C071835E341D18011D25Z', now(), > 'x', 'x.sp', null )' > 1 row in set (0.00 sec) > > Have other thing to do, or this problem is made by the mix of versions? > > Best regards! > -- > Wagner Bianchi - Web System Developer and Database Administrator > Phone: (31) 8654-9510 / 3272-0226 > E-mail: wagnerbianch...@gmail.com > Lattes: http://lattes.cnpq.br/2041067758113940 > Twitter: http://twitter.com/wagnerbianchi > Skype: infodbacet >
