W00ps forgot to update subject of my email,
WiNK / Rob wrote:
Hi ,
I think i might have hit a bug, posted on forums.mysql.com but
apparently nobody really reads that i think.
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 (`clickID`) ) 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)?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
