Hi, Disregard my previous post. It seems the developer is doing stuff that creates duplicate key errors, which seem to propagate to the slave, in stead of being ignored.
-- Martijn > -----Original Message----- > From: Martijn van den Burg [mailto:[EMAIL PROTECTED] > Sent: dinsdag 20 december 2005 11:38 > To: mysql@lists.mysql.com > Subject: Replication: why does this query fail on the slave? > > 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=0*/; > # at 30963303 > #051220 10:51:00 server id 30 log_pos 30963303 Query > thread_id=17311 exec_time=0 error_code=0 > use sip; > SET TIMESTAMP=1135072260; > 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=InnoDB DEFAULT CHARSET=latin1 COMMENT='Orginisational Units'; > > # > # 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=InnoDB DEFAULT CHARSET=latin1 COMMENT='Orginisational Units'; > > > 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 > > > -- > > The information contained in this communication and any > attachments is confidential and may be privileged, and is for > the sole use of the intended recipient(s). Any unauthorized > review, use, disclosure or distribution is prohibited. If you > are not the intended recipient, please notify the sender > immediately by replying to this message and destroy all > copies of this 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. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- The information contained in this communication and any attachments is confidential and may be privileged, and is for the sole use of the intended recipient(s). Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please notify the sender immediately by replying to this message and destroy all copies of this 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
