Hi.
Does the error log of the master contain any error?
Does the new log position make sense?
It hangs always on the same offset. So it doesn't get forward at
all. That's why I assume some priciple error.
There is some file called master.info in the database directory of the
client. Could you redo the reload and delete that file after you stop
the slave in the process.
Bye,
Benjamin.
On Thu, Oct 04, 2001 at 10:27:16AM +0200, [EMAIL PROTECTED] wrote:
> Benjamin Pflugmann writes:
>
> >Hi. My first guess would be that somehow the slave got out of
> >sync. I would try to update the slave by hand and see what happens
> >after restart.
>
> >Sorry, I don't see what could be the cause.
>
> I tried the following:
>
> on master:
>
> reset master
>
> on all slaves:
>
> slave stop
>
> drop table xxx
> load table xxx from master
> ... repeat for every replicated table ...
>
> slave start
>
> Still the same problem.
>
> >Bye,
>
> > Benjamin.
>
>
> >On Tue, Oct 02, 2001 at 06:07:29PM +0200, [EMAIL PROTECTED] wrote:
> >[...]
> >> I have 28 linux boxes configured identically, 27 as slaves, one as
> >> master. On all 27 slaves, everything works fine, but only on one I
> >> have strange errors in the logs:
> >>
> >> 011002 17:49:49 Slave: received 0 length packet from server,
> >> apparent master shutdown: (0) 011002 17:50:49 Slave: Failed reading
> >> log event, reconnecting to retry, log 'cp4230-bin.005' position
> >> 664857 011002 17:50:49 Slave: reconnected to master
> >> 'repl@xxx:3306',replication resumed in log 'xxx-bin.005' at
> >> position 664857 011002 17:51:49 Slave: received 0 length packet
> >> from server, apparent master shutdown: (0)
> >>
> >> This repeats every minute.
> >[...]
>
>
> >-- [EMAIL PROTECTED]
>
>
> --
> Alex Ivanisevic, 2e systems
> Tel: +49 6192 978 497
> Handy: +49 0174 310 9333
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
