List:Replication« Previous MessageNext Message »
From:Rick James Date:July 20 2011 9:23pm
Subject:Re: Slave receives end packet from master
View as plain text  
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

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