Failing set of queries: COMMIT /*Generated by THREAD_ID 2*/ ; SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED /*Generated by THREAD_ID 2*/ ; SET AUTOCOMMIT=ON /*Generated by THREAD_ID 2*/; 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*/; # 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' DELETE FROM `d` WHERE `pk` <= 5 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 /*Generated by THREAD_ID 2*/; SET AUTOCOMMIT=OFF /*Generated by THREAD_ID 2*/ ; START TRANSACTION /*Generated by THREAD_ID 2*/; What is problematic is that from the output of the transaction log (transaction_id = 1393), these queries are considered bundled in a transaction, despite *not* actually being part of one :-/ ./transaction_reader --transaction-id 1393 transaction.log OUTPUT: START TRANSACTION; INSERT INTO `test`.`aa` (`col_text_key`,`col_char_10_not_null`,`col_enum_not_null`,`col_text_not_null_key`,`col_int_not_null_key`,`col_int`,`col_int_key`,`col_char_10`,`col_enum_key`,`col_bigint_key`,`col_char_1024_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_text`,`pk`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null_key`,`col_bigint_not_null_key`,`col_enum_not_null_key`,`col_bigint_not_null`,`col_text_not_null`,`col_char_10_key`,`col_int_not_null`,`col_bigint`) VALUES ('','been','e','',3,5,NULL,'a','z',NULL,'OIILA','r','o','',993,'NILAN','about','CVZCR',5,'z',-4307411568603168768,'','I',9,NULL); INSERT INTO `test`.`aa` (`col_text_key`,`col_char_10_not_null`,`col_enum_not_null`,`col_text_not_null_key`,`col_int_not_null_key`,`col_int`,`col_int_key`,`col_char_10`,`col_enum_key`,`col_bigint_key`,`col_char_1024_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_text`,`pk`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null_key`,`col_bigint_not_null_key`,`col_enum_not_null_key`,`col_bigint_not_null`,`col_text_not_null`,`col_char_10_key`,`col_int_not_null`,`col_bigint`) VALUES ('','been','e','',3,5,NULL,'a','z',NULL,'OIILA','r','o','',994,'NILAN','about','CVZCR',5,'z',-4307411568603168768,'','I',9,NULL); INSERT INTO `test`.`aa` (`col_text_key`,`col_char_10_not_null`,`col_enum_not_null`,`col_text_not_null_key`,`col_int_not_null_key`,`col_int`,`col_int_key`,`col_char_10`,`col_enum_key`,`col_bigint_key`,`col_char_1024_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_text`,`pk`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null_key`,`col_bigint_not_null_key`,`col_enum_not_null_key`,`col_bigint_not_null`,`col_text_not_null`,`col_char_10_key`,`col_int_not_null`,`col_bigint`) VALUES ('','been','e','',3,5,NULL,'a','z',NULL,'OIILA','r','o','',995,'NILAN','about','CVZCR',5,'z',-4307411568603168768,'','I',9,NULL); INSERT INTO `test`.`aa` (`col_text_key`,`col_char_10_not_null`,`col_enum_not_null`,`col_text_not_null_key`,`col_int_not_null_key`,`col_int`,`col_int_key`,`col_char_10`,`col_enum_key`,`col_bigint_key`,`col_char_1024_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_text`,`pk`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null_key`,`col_bigint_not_null_key`,`col_enum_not_null_key`,`col_bigint_not_null`,`col_text_not_null`,`col_char_10_key`,`col_int_not_null`,`col_bigint`) VALUES ('','been','e','',3,5,NULL,'a','z',NULL,'OIILA','r','o','',996,'NILAN','about','CVZCR',5,'z',-4307411568603168768,'','I',9,NULL); INSERT INTO `test`.`aa` (`col_text_key`,`col_char_10_not_null`,`col_enum_not_null`,`col_text_not_null_key`,`col_int_not_null_key`,`col_int`,`col_int_key`,`col_char_10`,`col_enum_key`,`col_bigint_key`,`col_char_1024_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_text`,`pk`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null_key`,`col_bigint_not_null_key`,`col_enum_not_null_key`,`col_bigint_not_null`,`col_text_not_null`,`col_char_10_key`,`col_int_not_null`,`col_bigint`) VALUES ('','been','e','',3,5,NULL,'a','z',NULL,'OIILA','r','o','',997,'NILAN','about','CVZCR',5,'z',-4307411568603168768,'','I',9,NULL); INSERT INTO `test`.`aa` (`col_text_key`,`col_char_10_not_null`,`col_enum_not_null`,`col_text_not_null_key`,`col_int_not_null_key`,`col_int`,`col_int_key`,`col_char_10`,`col_enum_key`,`col_bigint_key`,`col_char_1024_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_text`,`pk`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null_key`,`col_bigint_not_null_key`,`col_enum_not_null_key`,`col_bigint_not_null`,`col_text_not_null`,`col_char_10_key`,`col_int_not_null`,`col_bigint`) VALUES ('','been','e','',3,5,NULL,'a','z',NULL,'OIILA','r','o','',998,'NILAN','about','CVZCR',5,'z',-4307411568603168768,'','I',9,NULL); INSERT INTO `test`.`aa` (`col_text_key`,`col_char_10_not_null`,`col_enum_not_null`,`col_text_not_null_key`,`col_int_not_null_key`,`col_int`,`col_int_key`,`col_char_10`,`col_enum_key`,`col_bigint_key`,`col_char_1024_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_text`,`pk`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null_key`,`col_bigint_not_null_key`,`col_enum_not_null_key`,`col_bigint_not_null`,`col_text_not_null`,`col_char_10_key`,`col_int_not_null`,`col_bigint`) VALUES ('','been','e','',3,5,NULL,'a','z',NULL,'OIILA','r','o','',999,'NILAN','about','CVZCR',5,'z',-4307411568603168768,'','I',9,NULL); INSERT INTO `test`.`aa` (`col_text_key`,`col_char_10_not_null`,`col_enum_not_null`,`col_text_not_null_key`,`col_int_not_null_key`,`col_int`,`col_int_key`,`col_char_10`,`col_enum_key`,`col_bigint_key`,`col_char_1024_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_text`,`pk`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null_key`,`col_bigint_not_null_key`,`col_enum_not_null_key`,`col_bigint_not_null`,`col_text_not_null`,`col_char_10_key`,`col_int_not_null`,`col_bigint`) VALUES ('','been','e','',3,5,NULL,'a','z',NULL,'OIILA','r','o','',1000,'NILAN','about','CVZCR',5,'z',-4307411568603168768,'','I',9,NULL); INSERT INTO `test`.`aa` (`col_text_key`,`col_char_10_not_null`,`col_enum_not_null`,`col_text_not_null_key`,`col_int_not_null_key`,`col_int`,`col_int_key`,`col_char_10`,`col_enum_key`,`col_bigint_key`,`col_char_1024_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_text`,`pk`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null_key`,`col_bigint_not_null_key`,`col_enum_not_null_key`,`col_bigint_not_null`,`col_text_not_null`,`col_char_10_key`,`col_int_not_null`,`col_bigint`) VALUES ('','been','e','',3,5,NULL,'a','z',NULL,'OIILA','r','o','',1001,'NILAN','about','CVZCR',5,'z',-4307411568603168768,'','I',9,NULL); INSERT INTO `test`.`aa` (`col_text_key`,`col_char_10_not_null`,`col_enum_not_null`,`col_text_not_null_key`,`col_int_not_null_key`,`col_int`,`col_int_key`,`col_char_10`,`col_enum_key`,`col_bigint_key`,`col_char_1024_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_text`,`pk`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null_key`,`col_bigint_not_null_key`,`col_enum_not_null_key`,`col_bigint_not_null`,`col_text_not_null`,`col_char_10_key`,`col_int_not_null`,`col_bigint`) VALUES ('','been','e','',3,5,NULL,'a','z',NULL,'OIILA','r','o','',1002,'NILAN','about','CVZCR',5,'z',-4307411568603168768,'','I',9,NULL); INSERT INTO `test`.`aa` (`col_text_key`,`col_char_10_not_null`,`col_enum_not_null`,`col_text_not_null_key`,`col_int_not_null_key`,`col_int`,`col_int_key`,`col_char_10`,`col_enum_key`,`col_bigint_key`,`col_char_1024_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_text`,`pk`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null_key`,`col_bigint_not_null_key`,`col_enum_not_null_key`,`col_bigint_not_null`,`col_text_not_null`,`col_char_10_key`,`col_int_not_null`,`col_bigint`) VALUES ('','been','e','',3,5,NULL,'a','z',NULL,'OIILA','r','o','',1003,'NILAN','about','CVZCR',5,'z',-4307411568603168768,'','I',9,NULL); INSERT INTO `test`.`aa` (`col_text_key`,`col_char_10_not_null`,`col_enum_not_null`,`col_text_not_null_key`,`col_int_not_null_key`,`col_int`,`col_int_key`,`col_char_10`,`col_enum_key`,`col_bigint_key`,`col_char_1024_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_text`,`pk`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null_key`,`col_bigint_not_null_key`,`col_enum_not_null_key`,`col_bigint_not_null`,`col_text_not_null`,`col_char_10_key`,`col_int_not_null`,`col_bigint`) VALUES ('','been','e','',3,5,NULL,'a','z',NULL,'OIILA','r','o','',1004,'NILAN','about','CVZCR',5,'z',-4307411568603168768,'','I',9,NULL); INSERT INTO `test`.`aa` (`col_text_key`,`col_char_10_not_null`,`col_enum_not_null`,`col_text_not_null_key`,`col_int_not_null_key`,`col_int`,`col_int_key`,`col_char_10`,`col_enum_key`,`col_bigint_key`,`col_char_1024_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_text`,`pk`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null_key`,`col_bigint_not_null_key`,`col_enum_not_null_key`,`col_bigint_not_null`,`col_text_not_null`,`col_char_10_key`,`col_int_not_null`,`col_bigint`) VALUES ('','been','e','',3,5,NULL,'a','z',NULL,'OIILA','r','o','',1005,'NILAN','about','CVZCR',5,'z',-4307411568603168768,'','I',9,NULL); INSERT INTO `test`.`aa` (`col_text_key`,`col_char_10_not_null`,`col_enum_not_null`,`col_text_not_null_key`,`col_int_not_null_key`,`col_int`,`col_int_key`,`col_char_10`,`col_enum_key`,`col_bigint_key`,`col_char_1024_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_text`,`pk`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null_key`,`col_bigint_not_null_key`,`col_enum_not_null_key`,`col_bigint_not_null`,`col_text_not_null`,`col_char_10_key`,`col_int_not_null`,`col_bigint`) VALUES ('','been','e','',3,5,NULL,'a','z',NULL,'OIILA','r','o','',1006,'NILAN','about','CVZCR',5,'z',-4307411568603168768,'','I',9,NULL); INSERT INTO `test`.`aa` (`col_text_key`,`col_char_10_not_null`,`col_enum_not_null`,`col_text_not_null_key`,`col_int_not_null_key`,`col_int`,`col_int_key`,`col_char_10`,`col_enum_key`,`col_bigint_key`,`col_char_1024_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_text`,`pk`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null_key`,`col_bigint_not_null_key`,`col_enum_not_null_key`,`col_bigint_not_null`,`col_text_not_null`,`col_char_10_key`,`col_int_not_null`,`col_bigint`) VALUES ('','been','e','',3,5,NULL,'a','z',NULL,'OIILA','r','o','',1007,'NILAN','about','CVZCR',5,'z',-4307411568603168768,'','I',9,NULL); INSERT INTO `test`.`aa` (`col_text_key`,`col_char_10_not_null`,`col_enum_not_null`,`col_text_not_null_key`,`col_int_not_null_key`,`col_int`,`col_int_key`,`col_char_10`,`col_enum_key`,`col_bigint_key`,`col_char_1024_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_text`,`pk`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null_key`,`col_bigint_not_null_key`,`col_enum_not_null_key`,`col_bigint_not_null`,`col_text_not_null`,`col_char_10_key`,`col_int_not_null`,`col_bigint`) VALUES ('','been','e','',3,5,NULL,'a','z',NULL,'OIILA','r','o','',1008,'NILAN','about','CVZCR',5,'z',-4307411568603168768,'','I',9,NULL); DELETE FROM `test`.`d` WHERE `pk`=4; DELETE FROM `test`.`d` WHERE `pk`=3; DELETE FROM `test`.`d` WHERE `pk`=1; COMMIT;