Upgraded master and slave to 5.0.26. No difference, the slave still hangs
when shutting down until logs are flushed at the master end.
On Wed, 11 Oct 2006, Juan Eduardo Moreno wrote:
> Upgrade to 5.0.26 please.
> Regards
>
>
> On 10/11/06, Liam Gretton <lgretton@stripped> wrote:
> >
> > Hi,
> >
> > I'm evaluating a master-slave arrangement between two 5.0.24a
> > installations.
> >
> > Replication is working, except the slave cannot be shut down or slaving
> > stopped until the master's logs are flushed. Attempting to stop the slave
> > creates the following in the logs:
> >
> > 061011 16:38:46 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown
> >
> > 061011 16:38:46 [Note] Slave I/O thread killed while reading event
> > 061011 16:38:46 [Note] Slave I/O thread exiting, read up to log '
> > binlog.000004', position 632
> >
> > ...and here it stays indefinitely until I issue 'flush logs' on the
> > master. After that it closes down and reports the following to the logs:
> >
> > 061011 16:38:55 [Note] Error reading relay log event: slave SQL thread was
> > killed
> > 061011 16:38:55 InnoDB: Starting shutdown...
> > 061011 16:38:57 InnoDB: Shutdown completed; log sequence number 0 43655
> > 061011 16:38:57 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete
> >
> > 061011 16:38:57 mysqld ended
> >
> > I notice that Andrew Tulloch posted a similar problem here a couple of
> > months ago (before I subscribed), but there don't seem to have been any
> > replies to him.
> >
> > Does anyone have any idea what the problem might be here?
> >
> > For what it's worth, the master is Solaris 10_x86, the slave behaves the
> > same whether it's Sol 10_x86 or RH ES EL 4.
> >
> > --
> > Liam Gretton lgretton@stripped
> > ESA/ESTEC http://www.rssd.esa.int/
> > Keplerlaan 1 Tel: +31 (0)71 565 8231
> > 2201 AZ Noordwijk ZH Fax: +31 (0)71 565 4690
> > Netherlands
> >
> > --
> > MySQL Replication Mailing List
> > For list archives: http://lists.mysql.com/replication
> > To unsubscribe:
> > http://lists.mysql.com/replication?unsub=1
> >
> >
>
--
Liam Gretton lgretton@stripped
ESA/ESTEC http://www.rssd.esa.int/
Keplerlaan 1 Tel: +31 (0)71 565 8231
2201 AZ Noordwijk ZH Fax: +31 (0)71 565 4690
Netherlands
