I've seen similar behaviour after replication issues, and they were
apparently caused by the slave having an old masterlog position. Check the
master's log file and -position, and check wether they are correct on the
slave. If not, manually resync and execute a change master statement.
On Wed, Jun 17, 2009 at 12:28 PM, Erwan Ben Souiden <erwan@stripped>wrote:
> On Wed, Jun 17, 2009 at 12:22 PM, Schackenberg<schackenberg@stripped>
> wrote:
> > Enable mysql error log , and then check what is iin there and Post it
>
> I just re-activate the error log. Hope the problem comes back soon ;)
> Then I will 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
> >>>>
> >>>
> >>
> >
>
> --
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe:
> http://lists.mysql.com/replication?unsub=1
>
>
--
Celsius is based on water temperature.
Fahrenheit is based on alcohol temperature.
Ergo, Fahrenheit is better than Celsius. QED.
