List:Replication« Previous MessageNext Message »
From:Wagner Bianchi Date:July 21 2011 2:09pm
Subject:Re: Slave receives end packet from master
View as plain text  
Are you able to test the ping transmission from slave to master?
Start pinging and observe if you get some interruption on this process.

Best wishes,
--
Wagner Bianchi - +55 (31) 8654 - 9510
*LinkedIn*: http://br.linkedin.com/in/wagnerbianchi
*Twitter*: @wagnerbianchijr
*Skype*: wbianchijr



2011/7/20 Database System <database100@stripped>

> 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:  FLUSH LOGS;
> > on Slave:  STOP SLAVE; START SLAVE;
> >
> > Now do SHOW SLAVE STATUS;
> >
> > 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  end_log_pos
> > 50000891     Rotate to binlog.000085
> > pos: 4
> > > DELIMITER ;
> > > # End of log file
> > > ROLLBACK /* added by mysqlbinlog */;
> > > /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
> > >
> > > Below is the beginning of binlog 000085
> > >
> > > /*!40019 SET
> > @@session.max_insert_delayed_threads=0*/;
> > > /*!50003 SET
> > @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
> > > DELIMITER /*!*/;
> > > # at 4
> > > #110720 12:52:40 server id 3  end_log_pos 106
> >     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>
> > 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.
> > >>
> > >>
> > >> --
> > >> Bier met grenadyn
> > >> Is als mosterd by den wyn
> > >> Sy die't drinkt, is eene kwezel
> > >> Hy die't drinkt, is ras een ezel
> > >>
> >
> > --
> > Rick James - MySQL Geek
> >
> >
>
> --
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe:
> http://lists.mysql.com/replication?unsub=1
>
>

Thread
Slave receives end packet from masterDatabase System20 Jul
  • Re: Slave receives end packet from masterJohan De Meersman20 Jul
    • Re: Slave receives end packet from masterRick James20 Jul
      • Re: Slave receives end packet from masterDatabase System20 Jul
      • Re: Slave receives end packet from masterJohan De Meersman21 Jul
        • Re: Slave receives end packet from masterRick James21 Jul
          • Re: Slave receives end packet from masterJohan De Meersman21 Jul
            • Re: Slave receives end packet from masterDatabase System21 Jul
              • Re: Slave receives end packet from masterPrabhat Kumar21 Jul
                • Re: Slave receives end packet from masterDatabase System22 Jul
                  • Re: Slave receives end packet from masterJohan De Meersman22 Jul
                    • Re: Slave receives end packet from masterDatabase System22 Jul
                  • Re: Slave receives end packet from masterEber Duarte22 Jul
                • Re: Slave receives end packet from masterDatabase System22 Jul
              • Re: Slave receives end packet from masterAlfie John21 Jul
    • Re: Slave receives end packet from masterDatabase System20 Jul
      • Re: Slave receives end packet from masterRick James20 Jul
        • Re: Slave receives end packet from masterDatabase System20 Jul
          • Re: Slave receives end packet from masterWagner Bianchi21 Jul
            • Re: Slave receives end packet from masterDatabase System21 Jul
      • Re: Slave receives end packet from masterJohan De Meersman21 Jul