It looks like there were two other queries using table `a` in the same time frame as our failure here - an UPDATE to `a` and another INSERT...SELECT...FROM `a`. It is possible that we were *very* lucky in hitting this bug and the threads coordinated just right for us. I leave it to the experts to determine if this might have contributed or not.
UPDATE `a` SET `col_bigint_key` = 7 WHERE `col_char_1024_not_null_key` >= '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 8 /*Generated by THREAD_ID 3*/;
It looks like there were two other queries using table `a` in the same time frame as our failure here - an UPDATE to `a` and another INSERT. ..SELECT. ..FROM `a`. It is possible that we were *very* lucky in hitting this bug and the threads coordinated just right for us. I leave it to the experts to determine if this might have contributed or not.
UPDATE `a` SET `col_bigint_key` = 7 WHERE `col_char_ 1024_not_ null_key` >= '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 8 /*Generated by THREAD_ID 3*/;
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 `a` WHERE `col_char_10` >= '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 25 /*Generated by THREAD_ID 4*/ ;
# 2010-11-09T12:20:17 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 `a` 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 /*Generated by THREAD_ID 2*/ failed: 1032 Can't find record in 'a'