Extended insert syntax and replication

extended insert syntax, my replication breaks with: Duplicate entry '2835610' for key 1 on query. Default database: 'AppServerLog'. Query: 'INSERT DELAYED INTO AppServerLog.Details (SessionID, FunctionCallID, DetailLevel, Tag, DateTime, SourceFileName, SourceLineNumber, Data) VALUES

Re: Extended insert syntax and replication

servers doing replication for logs. When I do extended insert syntax on the master to combine multiple log entries, the slave complains about duplicate primary key numbers, even though my inserts don't set the primary key and the primary key is auto_increment. So any time I use extended insert

Re: Extended insert syntax and replication

Gowdy [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Thursday, June 23, 2005 2:51 PM Subject: Re: Extended insert syntax and replication Hi, this is a perl script converter for inserts to simple form. if you work from a mysqldump, you can try it to see if the converted inserts do not genrate

Re: Extended insert syntax and replication

is auto_increment. So any time I use extended insert syntax, my replication breaks with: Duplicate entry '2835610' for key 1 on query. Default database: 'AppServerLog'. Query: 'INSERT DELAYED INTO AppServerLog.Details (SessionID, FunctionCallID, DetailLevel, Tag, DateTime, SourceFileName