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: [email protected]
Lattes: http://lattes.cnpq.br/2041067758113940
Twitter: http://twitter.com/wagnerbianchi
Skype: infodbacet
