From: Hubert de Donnea Date: October 12 2012 5:58pm Subject: RE: innodb_lock_wait_timeout and replication List-Archive: http://lists.mysql.com/mysql/228383 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="_0406aa67-ce5c-4eff-9c47-c5728085ba9d_" --_0406aa67-ce5c-4eff-9c47-c5728085ba9d_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I get all your mails for years....could you not help me and suppress my nam= e from your contact thanks > To: mysql@stripped > From: markus.falb@stripped > Subject: innodb_lock_wait_timeout and replication > Date: Fri=2C 12 Oct 2012 16:08:42 +0200 >=20 > I encountered an error > MySQL Error: Lock wait timeout exceeded=3B try restarting transaction > MySQL Error No: 1205 >=20 > For this very statement an entry in the binlog was filed >=20 > ... > # Query_time: 52 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 > ... >=20 > Why is there an entry in the binlog if the statement failed? > If it is in the binlog it will be replicated to a slave and on the slave > it will succeed (maybe). >=20 > Does this mean that a Lock wait timeout exceeded potentially drive the > slave out of sync? > --=20 > Kind Regards=2C Markus Falb >=20 = --_0406aa67-ce5c-4eff-9c47-c5728085ba9d_--