Description:
My replication slave has stopped with the following error:
==========
Last_Errno: 1064
Last_Error: Error 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';
update LayoutGraphics set Name = 'content-lower-top-left' where ID = 1013;
upd' at line 1' on query. Default database: 'ws1001'. Query: 'update LayoutGraphics set Name = 'content-lower-top-center' where ID = 1015;
update LayoutGraphics set Name = 'content-lower-top-left' where ID = 1013;
update LayoutGraphics set Name = 'content-lower-top-right' where ID = 1014;
update LayoutGraphics set Name = 'content-lower-middle-center' where ID = 1018;
update LayoutGraphics set Name = 'content-lower-middle-left' where ID = 1016;
update LayoutGraphics set Name = 'content-lower-middle-right' where ID = 1017;
update LayoutGraphics set Name = 'content-lower-bottom-center' where ID = 1021;
update LayoutGraphics set Name = 'content-lower-bottom-left' where ID = 1019;
update LayoutGraphics set Name = 'content-lower-bottom-right' where ID = 1020;
update LayoutGraphics set Name = 'conten
==========
The query in question did execute successfully on the master, however it seems that the slave is not replicating multi-line statements correctly. Is there anything I can do to fix this?
How to repeat:
Issue a multi-line statement on a master server and the slave seems not to be able to process the statement.
