# 2010-09-20T13:05:50 Running Query--> SET AUTOCOMMIT=ON ############################### INSERT in log # 2010-09-20T13:05:50 Running Query--> INSERT INTO `aa` ( `col_char_10` , `col_char_10_key` , `col_char_10_not_null` , `col_char_10_not_null_key` , `col_char_1024` , `col_char_1024_key` , `col_char_1024_not_null` , `col_char_1024_not_null_key` , `col_int` , `col_int_key` , `col_int_not_null` , `col_int_not_null_key` , `col_bigint` , `col_bigint_key` , `col_bigint_not_null` , `col_bigint_not_null_key` , `col_enum` , `col_enum_key` , `col_enum_not_null` , `col_enum_not_null_key` , `col_text` , `col_text_key` , `col_text_not_null` , `col_text_not_null_key` ) SELECT `col_char_10` , `col_char_10_key` , `col_char_10_not_null` , `col_char_10_not_null_key` , `col_char_1024` , `col_char_1024_key` , `col_char_1024_not_null` , `col_char_1024_not_null_key` , `col_int` , `col_int_key` , `col_int_not_null` , `col_int_not_null_key` , `col_bigint` , `col_bigint_key` , `col_bigint_not_null` , `col_bigint_not_null_key` , `col_enum` , `col_enum_key` , `col_enum_not_null` , `col_enum_not_null_key` , `col_text` , `col_text_key` , `col_text_not_null` , `col_text_not_null_key` FROM `dd` WHERE `col_char_1024` != 'FTLMI' ORDER BY `col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk` LIMIT 10 # 2010-09-20T13:05:50 Started periodic reporting process... # 2010-09-20T13:05:50 Running Query--> UPDATE `d` SET `col_bigint_key` = 5 WHERE `col_int_key` BETWEEN 10 AND 53 ORDER BY `col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk` LIMIT 7 ###################################### UPDATE in log # starting line 348 # 2010-09-20T13:05:50 Running Query--> UPDATE `cc` SET `col_int_not_null_key` = 0 ORDER BY `col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk` LIMIT 5 # 2010-09-20T13:05:52 Running Query--> ROLLBACK # 2010-09-20T13:05:52 Running Query--> SET TRANSACTION ISOLATION LEVEL REPEATABLE READ # Here is where we set AUTOCOMMIT=OFF for the longish set of queries that end with a fresh START TRANSACTION # 2010-09-20T13:05:52 Running Query--> SET AUTOCOMMIT=OFF ########## SHOULD HAVE BEEN IN LOG # 2010-09-20T13:05:52 Running Query--> INSERT INTO `d` ( `col_char_10` , `col_char_10_key` , `col_char_10_not_null` , `col_char_10_not_null_key` , `col_char_1024` , `col_char_1024_key` , `col_char_1024_not_null` , `col_char_1024_not_null_key` , `col_int` , `col_int_key` , `col_int_not_null` , `col_int_not_null_key` , `col_bigint` , `col_bigint_key` , `col_bigint_not_null` , `col_bigint_not_null_key` , `col_enum` , `col_enum_key` , `col_enum_not_null` , `col_enum_not_null_key` , `col_text` , `col_text_key` , `col_text_not_null` , `col_text_not_null_key` ) SELECT `col_char_10` , `col_char_10_key` , `col_char_10_not_null` , `col_char_10_not_null_key` , `col_char_1024` , `col_char_1024_key` , `col_char_1024_not_null` , `col_char_1024_not_null_key` , `col_int` , `col_int_key` , `col_int_not_null` , `col_int_not_null_key` , `col_bigint` , `col_bigint_key` , `col_bigint_not_null` , `col_bigint_not_null_key` , `col_enum` , `col_enum_key` , `col_enum_not_null` , `col_enum_not_null_key` , `col_text` , `col_text_key` , `col_text_not_null` , `col_text_not_null_key` FROM `aa` WHERE `pk` IN (7) ORDER BY `col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk` LIMIT 25 # 2010-09-20T13:05:52 Running Query--> SET AUTOCOMMIT=OFF ########## Maybe should be in log.... # 2010-09-20T13:05:52 Running Query--> DELETE FROM `dd` WHERE `col_char_1024_not_null` < 'WTDPP' ORDER BY `col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk` LIMIT 1 # 2010-09-20T13:05:52 Running Query--> ROLLBACK # 2010-09-20T13:05:52 Running Query--> SET TRANSACTION ISOLATION LEVEL READ COMMITTED #### Should have been in log # 2010-09-20T13:05:52 Running Query--> UPDATE `c` SET `col_bigint` = 4 ORDER BY `col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk` LIMIT 7 # Maybe should have been logged? # 2010-09-20T13:05:52 Running Query--> DELETE FROM `d` WHERE `col_int_not_null` > 3 ORDER BY `col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk` LIMIT 2 # Probably should have been logged # 2010-09-20T13:05:52 Running Query--> UPDATE `cc` SET `col_int` = 202 WHERE `col_char_10_not_null_key` != 'ZIBAV' ORDER BY `col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk` LIMIT 8 # Maybe should have been logged # 2010-09-20T13:05:52 Running Query--> DELETE FROM `dd` WHERE `col_char_10_key` IN ('c') ORDER BY `col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk` LIMIT 3 # 2010-09-20T13:05:52 Running Query--> SET AUTOCOMMIT=OFF # 2010-09-20T13:05:52 Running Query--> SET AUTOCOMMIT=OFF ####################################### INSERT IN LOG # Starting line 354 in sql output # 2010-09-20T13:05:58 Running Query--> INSERT INTO `cc` ( `col_char_10` , `col_char_10_key` , `col_char_10_not_null` , `col_char_10_not_null_key` , `col_char_1024` , `col_char_1024_key` , `col_char_1024_not_null` , `col_char_1024_not_null_key` , `col_int` , `col_int_key` , `col_int_not_null` , `col_int_not_null_key` , `col_bigint` , `col_bigint_key` , `col_bigint_not_null` , `col_bigint_not_null_key` , `col_enum` , `col_enum_key` , `col_enum_not_null` , `col_enum_not_null_key` , `col_text` , `col_text_key` , `col_text_not_null` , `col_text_not_null_key` ) SELECT `col_char_10` , `col_char_10_key` , `col_char_10_not_null` , `col_char_10_not_null_key` , `col_char_1024` , `col_char_1024_key` , `col_char_1024_not_null` , `col_char_1024_not_null_key` , `col_int` , `col_int_key` , `col_int_not_null` , `col_int_not_null_key` , `col_bigint` , `col_bigint_key` , `col_bigint_not_null` , `col_bigint_not_null_key` , `col_enum` , `col_enum_key` , `col_enum_not_null` , `col_enum_not_null_key` , `col_text` , `col_text_key` , `col_text_not_null` , `col_text_not_null_key` FROM `aa` ORDER BY `col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk` LIMIT 50 ### Maybe should have been logged? # 2010-09-20T13:05:58 Running Query--> DELETE FROM `bb` WHERE `col_char_10` < 'b' ORDER BY `col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk` LIMIT 4 ######################### DELETE query in log # DELETE FROM `test`.`cc` WHERE `pk`=63; line 374 sql output # 2010-09-20T13:06:01 Running Query--> DELETE FROM `cc` ORDER BY `col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk` LIMIT 1 # 2010-09-20T13:06:01 Running Query--> SELECT X . `col_enum_key` FROM `dd` AS X LEFT JOIN `b` AS Y USING ( `col_enum_not_null_key` ) WHERE X . `col_enum_key` IN ( 787808256 , 'c' , 3212443648 , 242 , 2991063040 ) LIMIT 7 ########################### INSERT query in log # 2010-09-20T13:06:01 Running Query--> INSERT INTO `bb` ( `col_char_10` , `col_char_10_key` , `col_char_10_not_null` , `col_char_10_not_null_key` , `col_char_1024` , `col_char_1024_key` , `col_char_1024_not_null` , `col_char_1024_not_null_key` , `col_int` , `col_int_key` , `col_int_not_null` , `col_int_not_null_key` , `col_bigint` , `col_bigint_key` , `col_bigint_not_null` , `col_bigint_not_null_key` , `col_enum` , `col_enum_key` , `col_enum_not_null` , `col_enum_not_null_key` , `col_text` , `col_text_key` , `col_text_not_null` , `col_text_not_null_key` ) SELECT `col_char_10` , `col_char_10_key` , `col_char_10_not_null` , `col_char_10_not_null_key` , `col_char_1024` , `col_char_1024_key` , `col_char_1024_not_null` , `col_char_1024_not_null_key` , `col_int` , `col_int_key` , `col_int_not_null` , `col_int_not_null_key` , `col_bigint` , `col_bigint_key` , `col_bigint_not_null` , `col_bigint_not_null_key` , `col_enum` , `col_enum_key` , `col_enum_not_null` , `col_enum_not_null_key` , `col_text` , `col_text_key` , `col_text_not_null` , `col_text_not_null_key` FROM `cc` WHERE `col_bigint_key` > 3 ORDER BY `col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk` LIMIT 50 # 2010-09-20T13:06:01 Running Query--> SET AUTOCOMMIT=OFF ################## Here is where we implicitly commit the stuff before us # 2010-09-20T13:06:04 Running Query--> START TRANSACTION # 2010-09-20T13:06:04 Running Query--> ROLLBACK # 2010-09-20T13:06:04 Running Query--> SET TRANSACTION ISOLATION LEVEL REPEATABLE READ # 2010-09-20T13:06:04 Running Query--> INSERT INTO `aa` ( `col_char_10` , `col_char_10_key` , `col_char_10_not_null` , `col_char_10_not_null_key` , `col_char_1024` , `col_char_1024_key` , `col_char_1024_not_null` , `col_char_1024_not_null_key` , `col_int` , `col_int_key` , `col_int_not_null` , `col_int_not_null_key` , `col_bigint` , `col_bigint_key` , `col_bigint_not_null` , `col_bigint_not_null_key` , `col_enum` , `col_enum_key` , `col_enum_not_null` , `col_enum_not_null_key` , `col_text` , `col_text_key` , `col_text_not_null` , `col_text_not_null_key` ) SELECT `col_char_10` , `col_char_10_key` , `col_char_10_not_null` , `col_char_10_not_null_key` , `col_char_1024` , `col_char_1024_key` , `col_char_1024_not_null` , `col_char_1024_not_null_key` , `col_int` , `col_int_key` , `col_int_not_null` , `col_int_not_null_key` , `col_bigint` , `col_bigint_key` , `col_bigint_not_null` , `col_bigint_not_null_key` , `col_enum` , `col_enum_key` , `col_enum_not_null` , `col_enum_not_null_key` , `col_text` , `col_text_key` , `col_text_not_null` , `col_text_not_null_key` FROM `bb` WHERE 0 BETWEEN 238 AND 1273626624 ORDER BY `col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk` LIMIT 50 # 2010-09-20T13:06:04 Running Query--> UPDATE `cc` SET `col_int_not_null` = 25 WHERE `col_bigint_key` = 2 ORDER BY `col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk` LIMIT 6 # 2010-09-20T13:06:04 Running Query--> INSERT INTO `b` ( `col_char_10` , `col_char_10_key` , `col_char_10_not_null` , `col_char_10_not_null_key` , `col_char_1024` , `col_char_1024_key` , `col_char_1024_not_null` , `col_char_1024_not_null_key` , `col_int` , `col_int_key` , `col_int_not_null` , `col_int_not_null_key` , `col_bigint` , `col_bigint_key` , `col_bigint_not_null` , `col_bigint_not_null_key` , `col_enum` , `col_enum_key` , `col_enum_not_null` , `col_enum_not_null_key` , `col_text` , `col_text_key` , `col_text_not_null` , `col_text_not_null_key` ) SELECT `col_char_10` , `col_char_10_key` , `col_char_10_not_null` , `col_char_10_not_null_key` , `col_char_1024` , `col_char_1024_key` , `col_char_1024_not_null` , `col_char_1024_not_null_key` , `col_int` , `col_int_key` , `col_int_not_null` , `col_int_not_null_key` , `col_bigint` , `col_bigint_key` , `col_bigint_not_null` , `col_bigint_not_null_key` , `col_enum` , `col_enum_key` , `col_enum_not_null` , `col_enum_not_null_key` , `col_text` , `col_text_key` , `col_text_not_null` , `col_text_not_null_key` FROM `bb` WHERE 0 BETWEEN 138 AND 357105664 ORDER BY `col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk` LIMIT 25 # 2010-09-20T13:06:04 Running Query--> UPDATE `d` SET `col_int_not_null_key` = 127 WHERE `col_text` != 'MXRNJ' ORDER BY `col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk` LIMIT 8 # 2010-09-20T13:06:06 Executing diff --unified /tmp//translog_rpl_dump_14883_9306.sql /tmp//translog_rpl_dump_14883_9307.sql --- /tmp//translog_rpl_dump_14883_9306.sql 2010-09-20 13:06:06.641540272 -0400 +++ /tmp//translog_rpl_dump_14883_9307.sql 2010-09-20 13:06:06.731542932 -0400 @@ -278,7 +278,7 @@ KEY `col_char_10_key` (`col_char_10_key`), KEY `col_char_1024_key` (`col_char_1024_key`(255)) ) ENGINE=InnoDB COLLATE = utf8_general_ci; -INSERT INTO `c` VALUES (1,NULL,'',2,'TJNCD',NULL,'h','h','','v',0,'q',747700224,'e',NULL,NULL,'h','o',8,7,'z','k','BKJRK','q',4); +INSERT INTO `c` VALUES (1,NULL,'',2,'TJNCD',NULL,'h','h','','v',0,'q',747700224,'e',NULL,NULL,'h','o',8,7,'z','k','BKJRK','q',NULL); ****************************************************************************************************************************************************** CREATE TABLE `cc` ( `col_bigint` BIGINT DEFAULT NULL, `col_text_key` TEXT COLLATE utf8_general_ci, @@ -347,19 +347,19 @@ INSERT INTO `cc` VALUES (3,NULL,'',5785436671310823424,7,'JAMAL',8811574145927086080,'c',4,'t','FVDDV','PTLSC','','y','DGXSU','HJDTV',0,26,'h',NULL,NULL,'a','WVNFW','t',4); INSERT INTO `cc` VALUES (-8539950793401303040,NULL,'',0,1600192512,'XXLFZ',6,'c',-1270153216,'ORNDE','NAAXQ','KKCIJ','','FXTYQ','ARQQR','r',1554448384,27,'d',NULL,NULL,'z','PGQFP','l',3); INSERT INTO `cc` VALUES (3,NULL,'',4523865825693663232,1320419328,'t',2,'q',1984561152,'LKMEC','w','YYAXY','','i','UIXDY','u',975896576,28,'a',NULL,NULL,'i','DBHZW','n',NULL); -INSERT INTO `cc` VALUES (NULL,NULL,'',2,NULL,'GSGLP',5,'w',2,'DGIUB','y','DHCPU','','VBJEY','XXVCG','TBOFN',0,29,'c',NULL,NULL,'t','VMXMC','a',202); -INSERT INTO `cc` VALUES (NULL,NULL,'',5,9,'AEWIO',9031969052691529728,'j',6,'XQOZM','FHXPD','CRMEL','','NXTLD','r','GEGHH',0,30,'w',NULL,NULL,'u','p','v',202); +INSERT INTO `cc` VALUES (NULL,NULL,'',2,NULL,'GSGLP',5,'w',2,'DGIUB','y','DHCPU','','VBJEY','XXVCG','TBOFN',0,29,'c',NULL,NULL,'t','VMXMC','a',1962344448); +INSERT INTO `cc` VALUES (NULL,NULL,'',5,9,'AEWIO',9031969052691529728,'j',6,'XQOZM','FHXPD','CRMEL','','NXTLD','r','GEGHH',0,30,'w',NULL,NULL,'u','p','v',NULL); INSERT INTO `cc` VALUES (6,NULL,'',-6704452470271115264,7,'l',1008806316530991104,'m',-829816832,'s','JEAKE','v','','b','b','NBDZR',-1212547072,31,'u',-4845310249097232384,NULL,'b','e','h',8); INSERT INTO `cc` VALUES (9,NULL,'',7,393019392,'v',0,'e',1488977920,'TYXCT','h','OKDFH','','d','GVFIH','f',0,32,'s',6,NULL,'t','UWYLC','c',4); INSERT INTO `cc` VALUES (2280228786333024256,NULL,'',-1036953814202056704,-1386217472,'WLADQ',2,'w',1,'JXFOP','ICTPQ','a','','x','e','MVZIR',8,33,'y',NULL,NULL,'t','GMAQE','p',0); -INSERT INTO `cc` VALUES (NULL,NULL,'',0,294780928,'RVZVI',0,'m',1805975552,'KCNLL','b','AVPDG','','XRBNL','k','WHNYS',0,34,'z',NULL,NULL,'s','t','l',202); +INSERT INTO `cc` VALUES (NULL,NULL,'',0,294780928,'RVZVI',0,'m',1805975552,'KCNLL','b','AVPDG','','XRBNL','k','WHNYS',0,34,'z',NULL,NULL,'s','t','l',2); INSERT INTO `cc` VALUES (NULL,NULL,'',7812056503627546624,NULL,'TOLRL',7,'z',3,'AJBUZ','OYQBO','p','','JNERQ','HVMBW','ASQVK',4,35,'n',2,NULL,'v','KVGTY','m',197001216); INSERT INTO `cc` VALUES (7,NULL,'',5850175915954274304,-1807351808,'n',1974828436601962496,'y',1,'WHWEO','c','WPHJA','','OOOET','NIVIM','m',6,36,'r',8012185212068823040,NULL,'x','ZIXNL','y',NULL); INSERT INTO `cc` VALUES (4752423506782715904,NULL,'',-982066193743478784,NULL,'t',-7416021211395653632,'f',0,'t','PWKPB','GQNTD','','HRZPW','PAVYS','IHNYB',7,37,'x',7825567302509658112,NULL,'h','h','s',NULL); INSERT INTO `cc` VALUES (4820540451146694656,NULL,'',6,4,'GCSLX',2,'b',-1370816512,'MCOPS','z','EUBJM','','PICIT','y','y',-810483712,38,'w',7,NULL,'e','HAJZA','z',1671757824); INSERT INTO `cc` VALUES (NULL,NULL,'',1507861450238984192,0,'GZQYE',1,'p',2,'m','AOQRI','ZHZSN','','BATKQ','JWASO','z',1982660608,39,'y',-5531264767341101056,NULL,'d','NZMUD','y',NULL); INSERT INTO `cc` VALUES (-6624232101908578304,NULL,'',0,4,'u',0,'z',1591148544,'o','d','OJSQM','','SEDZG','d','h',8,40,'n',9178054565604360192,NULL,'a','CGHUF','e',1420165120); -INSERT INTO `cc` VALUES (NULL,NULL,'',2629257757454237696,NULL,'i',1,'j',-1743585280,'j','IMPVU','PCSYG','','YQWQY','VOJYZ','PLXXM',3,41,'l',NULL,NULL,'p','MLTAL','x',202); +INSERT INTO `cc` VALUES (NULL,NULL,'',2629257757454237696,NULL,'i',1,'j',-1743585280,'j','IMPVU','PCSYG','','YQWQY','VOJYZ','PLXXM',3,41,'l',NULL,NULL,'p','MLTAL','x',4); INSERT INTO `cc` VALUES (2,NULL,'',6,0,'n',6,'r',3,'y','j','k','','b','j','s',565379072,42,'v',2860067238356975616,NULL,'q','z','g',NULL); INSERT INTO `cc` VALUES (-6458724815602712576,NULL,'',-2535808065186299904,-1234370560,'BMUZU',4,'j',9,'WZXDM','f','ANLFN','','GHUWG','c','f',1963524096,43,'z',9,NULL,'k','ZEPVL','r',-1140719616); INSERT INTO `cc` VALUES (NULL,NULL,'',593912200859484160,81264640,'QKXPE',6,'o',8,'XWQPC','g','TVVCQ','','d','RPMMK','OVZMJ',6,44,'z',-4979573812988215296,NULL,'k','ZIKTV','t',7); @@ -384,9 +384,9 @@ INSERT INTO `cc` VALUES (1,NULL,'',-8180507248141795328,6,'n',1,'s',0,'CSSAD','z','o','','VOIKA','TRTDY','GQWXQ',1007484928,64,'k',5,NULL,'j','JUCPU','q',NULL); INSERT INTO `cc` VALUES (6348668099708846080,NULL,'',-5700149753367494656,NULL,'d',7,'w',2,'u','AJFCE','CDPME','','j','o','RPGCS',2,65,'t',NULL,NULL,'d','e','i',NULL); INSERT INTO `cc` VALUES (8,NULL,'',1,-1140260864,'z',5,'g',9,'j','y','p','','QDVDA','t','q',216334336,66,'q',NULL,NULL,'k','p','k',0); -INSERT INTO `cc` VALUES (NULL,NULL,'',9,763822080,'IYECQ',2,'f',6,'ZWNHD','HYZDS','s','','o','OZMSP','b',1654390784,67,'y',NULL,NULL,'y','BBXVF','s',202); +INSERT INTO `cc` VALUES (NULL,NULL,'',9,763822080,'IYECQ',2,'f',6,'ZWNHD','HYZDS','s','','o','OZMSP','b',1654390784,67,'y',NULL,NULL,'y','BBXVF','s',4); INSERT INTO `cc` VALUES (7,NULL,'',-8326029811101204480,1,'o',2575496036902502400,'s',6,'VTUOW','m','XAQFH','','o','BFIAT','UHSRZ',5,68,'b',8850136217736445952,NULL,'s','x','z',NULL); -INSERT INTO `cc` VALUES (NULL,NULL,'',1147292005072633856,NULL,'CAPBU',-7585469147375468544,'n',-1573847040,'k','QCNBO','UUUDD','','h','t','VGHVI',-823656448,69,'u',NULL,NULL,'i','t','s',202); +INSERT INTO `cc` VALUES (NULL,NULL,'',1147292005072633856,NULL,'CAPBU',-7585469147375468544,'n',-1573847040,'k','QCNBO','UUUDD','','h','t','VGHVI',-823656448,69,'u',NULL,NULL,'i','t','s',NULL); INSERT INTO `cc` VALUES (-7381962739213664256,NULL,'',1,5,'CGFWS',2,'l',-439222272,'RBRAK','XSHVX','GXTKF','','c','a','t',9,70,'m',1,NULL,'b','AAJPX','k',NULL); INSERT INTO `cc` VALUES (NULL,NULL,'',2,-491716608,'z',0,'h',292814848,'c','DRHAJ','j','','SIDCH','d','TIXRJ',8,71,'x',0,NULL,'q','y','q',NULL); INSERT INTO `cc` VALUES (NULL,NULL,'',1,2004549632,'u',6,'g',1,'a','ISHIG','k','','KHAXU','o','ILKRM',368443392,72,'n',4,NULL,'z','j','f',2); @@ -407,7 +407,7 @@ INSERT INTO `cc` VALUES (2,NULL,'',7,-564789248,'v',-2349471630603845632,'h',-1410990080,'t','b','QENOI','','KMKNZ','h','n',8,87,'m',5759822448430153728,NULL,'m','s','s',-528089088); INSERT INTO `cc` VALUES (NULL,NULL,'',4,NULL,'p',7168604706866987008,'e',-965083136,'SBAXM','l','e','','TKJQP','VHYYE','COBTI',1709768704,88,'h',2,NULL,'o','a','b',9); INSERT INTO `cc` VALUES (NULL,NULL,'',-5368572230802341888,151060480,'z',8,'f',2,'TJNXG','MFOBW','i','','l','DHQDF','XSPTS',7,89,'h',7,NULL,'e','UJSSH','c',724434944); -INSERT INTO `cc` VALUES (NULL,NULL,'',-5348024557502464000,1383792640,'GWUHS',0,'t',12779520,'CAMHQ','MYQYS','QKMBF','','MZTZG','q','EKYLZ',0,90,'t',NULL,NULL,'y','GGUVL','u',202); +INSERT INTO `cc` VALUES (NULL,NULL,'',-5348024557502464000,1383792640,'GWUHS',0,'t',12779520,'CAMHQ','MYQYS','QKMBF','','MZTZG','q','EKYLZ',0,90,'t',NULL,NULL,'y','GGUVL','u',675479552); INSERT INTO `cc` VALUES (4641522365958717440,NULL,'',0,NULL,'WCTKD',5,'r',1094909952,'o','z','u','','s','LFEUJ','p',6,91,'d',-518476907101028352,NULL,'n','ZQSGE','a',86900736); INSERT INTO `cc` VALUES (NULL,NULL,'',6136717442245722112,NULL,'t',6,'w',1,'h','CAEVX','GUCRQ','','f','OGREP','RALPK',-953090048,92,'h',8202743771301937152,NULL,'w','r','j',NULL); INSERT INTO `cc` VALUES (4,NULL,'',7371548165075369984,231800832,'c',-8581609089954480128,'n',6,'c','JYANA','MUXAH','','x','r','f',-1464664064,93,'h',4099120085837283328,NULL,'e','r','k',9); @@ -478,6 +478,7 @@ KEY `col_char_1024_key` (`col_char_1024_key`(255)), KEY `col_char_1024_not_null_key` (`col_char_1024_not_null_key`(255)) ) ENGINE=InnoDB COLLATE = utf8_general_ci; +INSERT INTO `d` VALUES (-231342080,NULL,'x','x',592117760,'q','',6,-1504483750518456320,NULL,NULL,6,'TEDXQ','c',1,'a',NULL,'XPTZF','','r','e','z','n','YCJZX',NULL); CREATE TABLE `dd` ( `col_enum_not_null_key` ENUM('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') NOT NULL, `col_char_1024_key` VARCHAR(1024) COLLATE utf8_general_ci DEFAULT NULL, @@ -538,6 +539,7 @@ INSERT INTO `dd` VALUES ('o','c',7,'','PHUQL',5,6,'b',18,4,'v','IUXTM','c',-5854960990558355456,3,NULL,NULL,4,5,'r','u','','m','MOLZV','OKRUI'); INSERT INTO `dd` VALUES ('h','UCCMJ',6,'','OVDIS',2,3,'j',19,-1005780992,'p','k','KZFXW',8144196976146120704,2026373120,NULL,NULL,NULL,7,'n','s','','r','HUAWE','DQHDV'); INSERT INTO `dd` VALUES ('e','t',NULL,'','MLBOG',9,3,'q',20,NULL,'m','b','SMVMX',6153042990894940160,290979840,NULL,NULL,NULL,1,'d','b','','h','e','c'); +INSERT INTO `dd` VALUES ('m','RBBUR',NULL,'','NWXKW',4,6,'QHUSJ',21,-1187512320,'i','l','l',0,-532283392,NULL,NULL,NULL,8,'c','b','','f','KFAVT','p'); INSERT INTO `dd` VALUES ('z','IUAGQ',2,'','b',958985245653204992,8505610846242603008,'ZGYDT',22,6,'i','l','XXKQO',9,1,NULL,NULL,2,9,'w','l','','c','UWUQT','j'); INSERT INTO `dd` VALUES ('r','QYFYE',2,'','IGWJE',6,2785194894551941120,'o',23,-35651584,'k','c','r',4,-525533184,NULL,NULL,7,-467075072,'a','o','','f','t','v'); INSERT INTO `dd` VALUES ('c','CDUIQ',-1835466752,'','p',6068037547928322048,7285698297178619904,'p',24,7,'q','YKNIL','p',7015763794513100800,7,NULL,NULL,NULL,4,'RYDLD','r','','a','g','p'); # 2010-09-20T13:06:06 Cleaning up validation server... # 2010-09-20T13:06:07 Resetting validation server... # 2010-09-20T13:06:07 Differences between the two servers were found after comparing dumpfiles # 2010-09-20T13:06:07 diff command: diff --unified /tmp//translog_rpl_dump_14883_9306.sql /tmp//translog_rpl_dump_14883_9307.sql # 2010-09-20T13:06:07 Master dumpfile: # 2010-09-20T13:06:07 Slave dumpfile: # 2010-09-20T13:06:08 Killing periodic reporting process with pid 14882... # 2010-09-20T13:06:08 Kill GenTest::ErrorFilter(14881) # 2010-09-20T13:06:08 Test completed with failure status STATUS_REPLICATION_FAILURE (103)