From: Database System
Date: July 20 2011 9:33pm
Subject: Re: Slave receives end packet from master
List-Archive: http://lists.mysql.com/replication/2129
Message-Id: <1311197581.19425.YahooMailClassic@web113803.mail.gq1.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Rick,

I did them all. I even restarted MySQL on master and slave one at a time.
from show slave status, the SQL_IO_Runing sometimes is NO and sometimes is =
Yes. It lasts around 2 to 4 secends for each state, back and forth.

Thanks,
Lisa



--- On Wed, 7/20/11, Rick James <rjames@stripped> wrote:

> From: Rick James <rjames@stripped>
> Subject: Re: Slave receives end packet from master
> To: "database100@stripped" <database100@stripped>
> Cc: "Replication" <replication@stripped>
> Date: Wednesday, July 20, 2011, 4:23 PM
> Things to try:
> on Master:=A0 FLUSH LOGS;
> on Slave:=A0 STOP SLAVE; START SLAVE;
>=20
> Now do SHOW SLAVE STATUS;
>=20
> On 7/20/11 12:39 PM, Database System wrote:
> > It doesn't seem communication problem. The master
> server never stopped. Here is a couple of binlog files from
> the master:
> >
> > Below is the end of binlog 000084
> > # at 50000851
> > #110720 12:52:40 server id 3=A0 end_log_pos
> 50000891 =A0=A0=A0 Rotate to binlog.000085=A0
> pos: 4
> > DELIMITER ;
> > # End of log file
> > ROLLBACK /* added by mysqlbinlog */;
> > /*!50003 SET COMPLETION_TYPE=3D@OLD_COMPLETION_TYPE*/;
> >
> > Below is the beginning of binlog 000085
> >
> > /*!40019 SET
> @@session.max_insert_delayed_threads=3D0*/;
> > /*!50003 SET
> @OLD_COMPLETION_TYPE=3D@@COMPLETION_TYPE,COMPLETION_TYPE=3D0*/;
> > DELIMITER /*!*/;
> > # at 4
> > #110720 12:52:40 server id 3=A0 end_log_pos 106
> =A0=A0=A0 Start: binlog v 4, server v
> 5.1.44-community-log created 110720 12:52:40
> > # Warning: this binlog was not closed properly. Most
> probably mysqld crashed writing it.
> >
> > Any ideas?
> >
> > Thanks,
> > Lisa
> >
> >
> > --- On Wed, 7/20/11, Johan De Meersman<vegivamp@stripped>=A0
> wrote:
> >
> >> From: Johan De Meersman<vegivamp@stripped>
> >> Subject: Re: Slave receives end packet from
> master
> >> To: database100@stripped
> >> Cc: "Replication"<replication@stripped>
> >> Date: Wednesday, July 20, 2011, 11:44 AM
> >> ----- Original Message -----
> >>> From: "Database System"<database100@stripped>
> >>>
> >>> The replication keeps on and off (Slave I/O
> thread
> >> value changes
> >>> between Yes and No automatically). It comes
> back on
> >> its own, but
> >>> since it being off so often, and doesn't have
> enough
> >> time to catch
> >>
> >> Wiggle the cable :-)
> >>
> >> More specifically, this sounds like the slave
> easily loses
> >> connection - set up network throughput graphs;
> have a look
> >> in your system logs if any down/ups appear there;
> see if
> >> there isn't a pattern in the disconnects; check
> for
> >> duplicate IPs (some host trying to steal the
> slave's IP);
> >> and do, indeed, check if the cables are securely
> in their
> >> socket.
> >>
> >>
> >> --=20
> >> Bier met grenadyn
> >> Is als mosterd by den wyn
> >> Sy die't drinkt, is eene kwezel
> >> Hy die't drinkt, is ras een ezel
> >>
>=20
> --=20
> Rick James - MySQL Geek
>=20
>