Re: R: how use sql_slave_skip_counter to restore slave replication

2006-01-10 Thread Gleb Paharenko
Hello. > I already tried the option --slave-skip-errors, but i didn't work as > expected. > When this option is enabled, the slave didn't report the error message, but > the slave is stopped due the error. May be server dies due an error message which was not included in the slave-skip-e

R: how use sql_slave_skip_counter to restore slave replication

2006-01-10 Thread AESYS S.p.A. [Enzo Arlati]
I already tried the option --slave-skip-errors, but i didn't work as expected. When this option is enabled, the slave didn't report the error message, but the slave is stopped due the error. The target I need to reech is to get two server A e B, each of them have its own db server and a set of ap

Re: R: how use sql_slave_skip_counter to restore slave replication

2005-12-30 Thread Gleb Paharenko
Hello. > One think it is astonished: I can agree that there should bu some >conflict, but why i have remove the same row, with the same key value >several times about 5-6 times ).Do you have some knowledge of problem >like that ? It is difficult to say something, because the whole picture

R: how use sql_slave_skip_counter to restore slave replication

2005-12-30 Thread AESYS S.p.A. [Enzo Arlati]
So it should be possible to automate a skip of errors setting by code , at run-time, sql_slave_skip_counter = 1, each time I check the slave status and I found an error, and then I restart the slave Thanks, I should try this way. One think it is astonished: I can agree that there should bu some c