Hello.
That seems like a bug for me. Please, check if the problem still exists if you're using 4.1.16 master and slave. Martijn van den Burg wrote: > Dear list, > > Replication (between two 4.1.10 servers, Solaris) fails on the following > query with a 1064 error (parse error), but there are no reserved words > in it, and when I run the query from the command line on the master no > errors occur and the table is created. > > (binlog) > > /*!40019 SET @@session.max_insert_delayed_threads=3D0*/; > # at 30963303 > #051220 10:51:00 server id 30 log_pos 30963303 Query > thread_id=3D17311 exec_time=3D0 error_code=3D0 > use sip; > SET TIMESTAMP=3D1135072260; > DROP TABLE IF EXISTS `tbl_ou`; > CREATE TABLE `tbl_ou` ( > `intId` int(11) NOT NULL auto_increment, > `vchName` varchar(100) NOT NULL default '', > `vchDescription` varchar(255) default NULL, > `intParent` int(11) default NULL, > `intType` int(11) NOT NULL default '0', > `tinStatus` tinyint(3) NOT NULL default '1', > PRIMARY KEY (`intId`) > ) ENGINE=3DInnoDB DEFAULT CHARSET=3Dlatin1 COMMENT=3D'Orginisational Unit= > s'; > > # > # Dumping data for table tbl_ou > # > [snip] > > > > > Output from SHOW SLAVE STATUS: > > [...] > 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 '; > CREATE TABLE `tbl_ou` ( > `intId` int(11) NOT NULL auto_increment, > `vchNa' at line 1' on query. Default database: 'sip'. Query: 'DROP > TABLE IF EXISTS `tbl_ou`; > CREATE TABLE `tbl_ou` ( > `intId` int(11) NOT NULL auto_increment, > `vchName` varchar(100) NOT NULL default '', > `vchDescription` varchar(255) default NULL, > `intParent` int(11) default NULL, > `intType` int(11) NOT NULL default '0', > `tinStatus` tinyint(3) NOT NULL default '1', > PRIMARY KEY (`intId`) > ) ENGINE=3DInnoDB DEFAULT CHARSET=3Dlatin1 COMMENT=3D'Orginisational Unit= > s'; > > > Where to look, how to fix? It looks like a bug to me, if so I'll add it > to the buglist. > > > Kind regards, > > Martijn > > > -- =0D > The information contained in this communication and any attachments is co= > nfidential and may be privileged, and is for the sole use of the intended= > recipient(s). Any unauthorized review, use, disclosure or distribution i= > s prohibited. If you are not the intended recipient, please notify the se= > nder immediately by replying to this message and destroy all copies of th= > is message and any attachments. ASML is neither liable for the proper and= > complete transmission of the information contained in this communication= > , nor for any delay in its receipt. > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
