List:Replication« Previous MessageNext Message »
From:Schackenberg Date:June 17 2009 10:22am
Subject:Re: [MySQL - replication] Freeze
View as plain text  
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
>>>
>>
>
Thread
[MySQL - replication] FreezeErwan Ben Souiden17 Jun
  • Re: [MySQL - replication] FreezeSchackenberg17 Jun
    • Re: [MySQL - replication] FreezeErwan Ben Souiden17 Jun
      • Re: [MySQL - replication] FreezeSchackenberg17 Jun
Re: [MySQL - replication] FreezeErwan Ben Souiden17 Jun
  • Re: [MySQL - replication] FreezeJohan De Meersman17 Jun
    • Re: [MySQL - replication] FreezeErwan Ben Souiden17 Jun
      • Re: [MySQL - replication] FreezeJohan De Meersman17 Jun