From: Anupam Karmarkar
Date: June 23 2011 10:36am
Subject: Replication Sync Error
List-Archive: http://lists.mysql.com/mysql/225323
Message-Id: <276922.28533.qm@web94701.mail.in2.yahoo.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1200941328-1308825360=:28533"

--0-1200941328-1308825360=:28533
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

Hi All,

We are running semi-sync replication on production server, last week found =
out that replication suck at some event schedule created at master, as that=
 was not important i skipped that started replication again, found out that=
 slave is days behind at master, i invested gate more and found that it is =
read 200 MB of binary file and few more need to be read by salve get in syn=
c, still i think 200 MB file should not take hours to read, any ways but in=
 error logs i am keep on getting following error=20

110623 15:50:56 [Note] Semi-sync replication switched OFF.
110623 15:50:56 [Note] Semi-sync replication switched ON with slave (server=
_id: 2) at (master-bin.000031, 15494716)
110623 15:51:02 [Warning] Timeout waiting for reply of binlog (file: master=
-bin.000031, pos: 15505733), semi-sync up to file master-bin.000031, positi=
on 15505129.

can any one help on this.=20

--Anupam

--0-1200941328-1308825360=:28533--