Enable mysql error log , and then check what is iin there and Post it
..
Am 17.06.2009 um 12:13 schrieb Erwan Ben Souiden <erwan@stripped>:
> Hi,
>
> And thank you for the answer.
>
> On Wed, Jun 17, 2009 at 12:05 PM, Schackenberg<schackenberg@stripped
> > wrote:
>> What is in your mysql error log?
>>
>
> Sorry I forgot to mention that, I got nothing in my mysql error log :(
> Actually it's like the Slave_IO_Running works but "don't want" to
> update the master.info file
> And when I stop/start the slave all is ok
>
>> ..
>>
>>
>> Am 17.06.2009 um 11:09 schrieb Erwan Ben Souiden
>> <erwan@stripped>:
>>
>>> Hi there,
>>>
>>> I got a really strange situation.
>>> Basically I set a mysql replication without any problem (I'm really
>>> confident with this). All seems to be good until I see that no
>>> update
>>> has been replicated to one of my slave !
>>> The Slave_IO_Running and the Slave_SQL_Running are "Yes" but the
>>> Read_Master_Log_Pos seems to be "freezed". I check with the "show
>>> processlist;" command but all seems ok.
>>> I try to create a new database on the master to be sure there is an
>>> update but the Read_Master_Log_Pos doesn't change !
>>>
>>> So I just run a "stop slave;" then a "start slave;" and my slave is
>>> now synchronized ! But I don't understand what's happened... There
>>> are
>>> several slaves for this master and only one (the same) has this kind
>>> of problem (3 times in one month).
>>>
>>> I'm totally lost so any help/clue will be greatly appreciated :)
>>> Please forgive my poor english level :)
>>>
>>> Cheers,
>>> Erwan
>>>
>>>
>>>
>>> Some informations about my config :
>>>
>>> mysql version : 5.0.51a-24+lenny1 (Debian)
>>>
>>> mysql slave config :
>>> ...
>>> server-id = 42
>>> master-host = 10.0.0.2
>>> master-user = replicateur
>>> master-password = password
>>> master-port = 3306
>>> ...
>>>
>>> --
>>> MySQL Replication Mailing List
>>> For list archives: http://lists.mysql.com/replication
>>> To unsubscribe:
>>> http://lists.mysql.com/replication?unsub=1
>>>
>>
>
