MySQL Forums
Forum List  »  Archive Storage Engine

replication bug?
Posted by: Rob LastName
Date: September 09, 2007 12:32PM

Hey ! 1st post ever, not sure if its enough related to this forum or replication, but imho it is :)

my table:

CREATE TABLE `clog` ( `cID` int(20) NOT NULL auto_increment, `lID` int(10) default NULL, `ip` int(10) default NULL, `timestamp` int(11) NOT NULL, PRIMARY KEY (`cID`) ) ENGINE=MYISAM; or i use ARCHIVE

I have a bit of a problem that occurs only when i change my really simple log table to the archive engine. The replication breaks. Any thoughts? The row number of the error is variable. When the table is set to myisam, the replication does not break on duplicate key, and runs as expected.

Can't write; duplicate key in table 'clog'' on query.

Is it possible that due to the stress of the benchmark, my slave cannot compute the next cID or creates a duplicate (cId is the only variable that changes, on bench query)?



Edited 2 time(s). Last edit at 09/12/2007 05:52AM by Rob LastName.

Options: ReplyQuote


Subject
Views
Written By
Posted
replication bug?
8725
September 09, 2007 12:32PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.