See <http://hudson.drizzle.org/job/drizzle-staging-randgen-transaction-log/147/>
------------------------------------------ [...truncated 458 lines...] # 2011-01-08T00:27:18 # Creating Drizzle table: test.BB; engine: innodb; rows: 75 . # 2011-01-08T00:27:19 # Creating Drizzle table: test.CC; engine: innodb; rows: 100 . # 2011-01-08T00:27:25 # Creating Drizzle table: test.DD; engine: innodb; rows: 100 . # 2011-01-08T00:27:28 Reporters: DrizzleTransactionLog DBD::drizzle::db selectrow_arrayref failed: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'SLAVE HOSTS' at line 1 at lib/GenTest/Reporter.pm line 79. DBD::drizzle::db selectall_arrayref failed: Table 'information_schema.plugins' doesn't exist at lib/GenTest/Reporter.pm line 84. # 2011-01-08T00:27:28 Validators: ErrorMessageCorruption # 2011-01-08T00:27:28 Starting 5 processes, 100 queries each, duration 3600 seconds. # 2011-01-08T00:27:28 GenTest::ErrorFilter(1823) started # 2011-01-08T00:27:28 Default schema: test # 2011-01-08T00:27:28 Executor initialized, id 1 # 2011-01-08T00:27:28 Caching schema metadata for dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test # 2011-01-08T00:27:28 Default schema: test # 2011-01-08T00:27:28 Executor initialized, id 1 # 2011-01-08T00:27:28 Caching schema metadata for dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test # 2011-01-08T00:27:28 Query: ROLLBACK TO SAVEPOINT A failed: 1305 SAVEPOINT %s does not exist. Further errors of this kind will be suppressed. # 2011-01-08T00:27:28 Query: SELECT * FROM `B` AS X LEFT JOIN `D` AS Y USING ( `col_char_10_not_null_key` ) WHERE X . `col_enum_key` IN ( 4 , 4228775936 , 4 , 26345472 , 110 ) LIMIT 7 failed: 1691 Received an invalid enum value '%d'.. Further errors of this kind will be suppressed. # 2011-01-08T00:27:28 Default schema: test # 2011-01-08T00:27:28 Executor initialized, id 1 # 2011-01-08T00:27:28 Caching schema metadata for dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test # 2011-01-08T00:27:28 Default schema: test # 2011-01-08T00:27:28 Executor initialized, id 1 # 2011-01-08T00:27:28 Caching schema metadata for dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test # 2011-01-08T00:27:28 Query: ROLLBACK TO SAVEPOINT A failed: 1305 SAVEPOINT %s does not exist. Further errors of this kind will be suppressed. # 2011-01-08T00:27:28 Default schema: test # 2011-01-08T00:27:28 Executor initialized, id 1 # 2011-01-08T00:27:28 Caching schema metadata for dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test # 2011-01-08T00:27:29 Started periodic reporting process... # 2011-01-08T00:27:29 Query: UPDATE `C` SET `col_int_key` = 'i' WHERE `col_char_1024_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 7 failed: 1366 Incorrect integer value: 'i' for column 'col_int_key' at row %d. Further errors of this kind will be suppressed. # 2011-01-08T00:27:29 Query: UPDATE `DD` SET `col_int_not_null_key` = 1 WHERE `col_bigint` = 8 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 failed: 1213 Deadlock found when trying to get lock; try restarting transaction. Further errors of this kind will be suppressed. # 2011-01-08T00:27:29 Query: UPDATE `A` SET `col_int_key` = 5 WHERE `col_int_not_null` BETWEEN 8 AND 211 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 failed: 1213 Deadlock found when trying to get lock; try restarting transaction. Further errors of this kind will be suppressed. # 2011-01-08T00:27:30 Query: ROLLBACK TO SAVEPOINT A failed: 1305 SAVEPOINT %s does not exist. Further errors of this kind will be suppressed. # 2011-01-08T00:27:31 Query: ROLLBACK TO SAVEPOINT A failed: 1305 SAVEPOINT %s does not exist. Further errors of this kind will be suppressed. # 2011-01-08T00:27:32 Query: ROLLBACK TO SAVEPOINT A failed: 1305 SAVEPOINT %s does not exist. Further errors of this kind will be suppressed. # 2011-01-08T00:27:33 Query: DELETE FROM `DD` WHERE `col_int_not_null_key` = ( SELECT `col_char_1024_key` FROM `DD` WHERE `pk` = 386727936 ) 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 failed: 1093 You can't specify target table '%s' for update in FROM clause. Further errors of this kind will be suppressed. # 2011-01-08T00:27:33 Query: DELETE FROM `B` WHERE `col_text_not_null` = 'QBLGC' 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 failed: 1213 Deadlock found when trying to get lock; try restarting transaction. Further errors of this kind will be suppressed. # 2011-01-08T00:27:37 Query: DELETE FROM `C` WHERE `col_char_10_not_null_key` = ( SELECT `col_char_1024_key` FROM `C` WHERE `pk` = 'r' ) 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 failed: 1093 You can't specify target table '%s' for update in FROM clause. Further errors of this kind will be suppressed. # 2011-01-08T00:27:38 Query: UPDATE `D` SET `col_int` = 'q' WHERE `col_int_not_null_key` IN (8) 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 failed: 1366 Incorrect integer value: 'q' for column 'col_int' at row %d. Further errors of this kind will be suppressed. # 2011-01-08T00:27:47 Query: UPDATE `C` SET `col_int_not_null_key` = 1 WHERE `col_char_10_key` IN ( SELECT `col_bigint_not_null_key` FROM `C` WHERE `pk` = 'k' ) 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 failed: 1093 You can't specify target table '%s' for update in FROM clause. Further errors of this kind will be suppressed. # 2011-01-08T00:27:47 Query: UPDATE `AA` SET `col_int_key` = 10 WHERE `col_int_key` IN ( SELECT `col_enum_not_null_key` FROM `AA` WHERE `pk` = 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 failed: 1093 You can't specify target table '%s' for update in FROM clause. Further errors of this kind will be suppressed. # 2011-01-08T00:27:48 Query: UPDATE `AA` SET `col_bigint_key` = 'r' WHERE `col_enum_key` > 8 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 failed: 1366 Incorrect integer value: 'r' for column 'col_bigint_key' at row %d. Further errors of this kind will be suppressed. # 2011-01-08T00:27:52 Query: INSERT INTO `A` ( `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 `col_int_not_null_key` >= 'r' 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 failed: 1292 Truncated incorrect DOUBLE value: 'r'. Further errors of this kind will be suppressed. # 2011-01-08T00:27:53 Query: DELETE FROM `A` WHERE `col_char_1024_not_null` > 'RETGO' 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 failed: 1213 Deadlock found when trying to get lock; try restarting transaction. Further errors of this kind will be suppressed. # 2011-01-08T00:27:54 Query: SELECT X . `col_enum_key` FROM `BB` AS X WHERE X . `col_bigint` BETWEEN 199 AND 4107730944 LIMIT 6 LOCK IN SHARE MODE failed: 1213 Deadlock found when trying to get lock; try restarting transaction. Further errors of this kind will be suppressed. # 2011-01-08T00:27:56 Query: SELECT X . `col_int_key` FROM `D` AS X LEFT JOIN `CC` AS Y USING ( `col_char_1024_key` ) WHERE X . `col_enum_key` IN ( 8 , 1170014208 , 4246274048 , 51 , 2794127360 ) LIMIT 6 FOR UPDATE failed: 1691 Received an invalid enum value '%d'.. Further errors of this kind will be suppressed. # 2011-01-08T00:27:57 Query: DELETE FROM `A` WHERE `col_enum_not_null_key` = 52 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 failed: 1691 Received an invalid enum value '%d'.. Further errors of this kind will be suppressed. # 2011-01-08T00:27:58 Query: UPDATE `D` SET `col_int` = '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 6 failed: 1366 Incorrect integer value: 'b' for column 'col_int' at row %d. Further errors of this kind will be suppressed. # 2011-01-08T00:28:01 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 `C` WHERE `col_int_not_null_key` = 3952934912 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 failed: 1264 Out of range value for column 'col_int_not_null_key' at row 1 # 2011-01-08T00:28:01 Query: UPDATE `A` SET `col_bigint_key` = 'v' 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 failed: 1366 Incorrect integer value: 'v' for column 'col_bigint_key' at row %d. Further errors of this kind will be suppressed. # 2011-01-08T00:28:10 Query: UPDATE `CC` SET `col_int_key` = 'j' WHERE `col_char_1024_key` > '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 7 failed: 1366 Incorrect integer value: 'j' for column 'col_int_key' at row %d. Further errors of this kind will be suppressed. # 2011-01-08T00:28:11 Query: REPLACE INTO `C` ( `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_int_key` <= 'k' 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 failed: 1366 Incorrect integer value: 'k' for column 'col_int_key' at row %d. Further errors of this kind will be suppressed. # 2011-01-08T00:28:17 Child process completed successfully. # 2011-01-08T00:28:18 Child process completed successfully. # 2011-01-08T00:28:21 Child process completed successfully. # 2011-01-08T00:28:22 Child process completed successfully. # 2011-01-08T00:28:23 Child process completed successfully. # 2011-01-08T00:28:24 Killing periodic reporting process with pid 1824... # 2011-01-08T00:28:24 Kill GenTest::ErrorFilter(1823) # 2011-01-08T00:28:24 dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test # 2011-01-08T00:28:24 transaction_log output file: /tmp//translog_1816_.sql # 2011-01-08T00:28:24 <http://hudson.drizzle.org/job/drizzle-staging-randgen-transaction-log/ws/plugin/transaction_log/utilities/transaction_reader> <http://hudson.drizzle.org/job/drizzle-staging-randgen-transaction-log/ws/var/local/transaction.log> > /tmp//translog_1816_.sql # 2011-01-08T00:28:24 Replicating from transaction_log output... # 2011-01-08T00:28:24 <http://hudson.drizzle.org/job/drizzle-staging-randgen-transaction-log/ws/client/drizzle> --host=127.0.0.1 --port=9307 --user=root test < /tmp//translog_1816_.sql ERROR 1727 (HY000): Transactional DDL not supported # 2011-01-08T00:28:24 Test completed with failure status STATUS_UNKNOWN_ERROR (2) Sat Jan 8 00:28:24 2011 INFO: Pinging Drizzled server on port 9306 Sat Jan 8 00:28:24 2011 INFO: Stopping Drizzled server on port 9306 Sat Jan 8 00:28:27 2011 INFO: Clearing Drizzled server on port 9306 Sat Jan 8 00:28:27 2011 INFO: Starting Drizzled server on port 9306 Sat Jan 8 00:28:27 2011 INFO: PWD: /home/hudson/repos/randgen Sat Jan 8 00:28:34 2011 INFO: Dropping any test database previously setup. Sat Jan 8 00:28:34 2011 INFO: Creating test database. Sat Jan 8 00:28:34 2011 INFO: Pinging Drizzled server on port 9307 Sat Jan 8 00:28:34 2011 INFO: Stopping Drizzled server on port 9307 Sat Jan 8 00:28:37 2011 INFO: Clearing Drizzled server on port 9307 Sat Jan 8 00:28:37 2011 INFO: Starting Drizzled server on port 9307 Sat Jan 8 00:28:37 2011 INFO: PWD: /home/hudson/repos/randgen Sat Jan 8 00:28:48 2011 INFO: Dropping any test database previously setup. Sat Jan 8 00:28:48 2011 INFO: Creating test database. Sat Jan 8 00:28:48 2011 INFO: Running : single_thread3 with ./gentest.pl --dsn=dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test --threads=5 --queries=500 --engine=Innodb --gendata=conf/drizzle/translog_drizzle.zz --grammar=conf/drizzle/translog_concurrent3.yy --Reporter=DrizzleTransactionLog --queries=100 --threads=1 Sat Jan 8 00:29:28 2011 INFO: single_thread3 FAILED # 2011-01-08T00:28:49 Starting # 2011-01-08T00:28:49 ./gentest.pl \ # 2011-01-08T00:28:49 --dsn=dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test \ # 2011-01-08T00:28:49 --threads=5 \ # 2011-01-08T00:28:49 --queries=500 \ # 2011-01-08T00:28:49 --engine=Innodb \ # 2011-01-08T00:28:49 --gendata=conf/drizzle/translog_drizzle.zz \ # 2011-01-08T00:28:49 --grammar=conf/drizzle/translog_concurrent3.yy \ # 2011-01-08T00:28:49 --Reporter=DrizzleTransactionLog \ # 2011-01-08T00:28:49 --queries=100 \ # 2011-01-08T00:28:49 --threads=1 # 2011-01-08T00:28:49 ------------------------------- # 2011-01-08T00:28:49 Configuration # 2011-01-08T00:28:49 dsn => ['dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test'] # 2011-01-08T00:28:49 duration => 3600 # 2011-01-08T00:28:49 engine => Innodb # 2011-01-08T00:28:49 gendata => conf/drizzle/translog_drizzle.zz # 2011-01-08T00:28:49 grammar => conf/drizzle/translog_concurrent3.yy # 2011-01-08T00:28:49 queries => 100 # 2011-01-08T00:28:49 reporters => ['DrizzleTransactionLog'] # 2011-01-08T00:28:49 seed => 1 # 2011-01-08T00:28:49 threads => 1 # 2011-01-08T00:28:49 validators => [''] # 2011-01-08T00:28:49 Default schema: test # 2011-01-08T00:28:49 Executor initialized, id GenTest::Executor::Drizzle 2011.01.2063 () # 2011-01-08T00:28:49 # Creating Drizzle table: test.A; engine: innodb; rows: 10 . # 2011-01-08T00:28:50 # Creating Drizzle table: test.B; engine: innodb; rows: 10 . # 2011-01-08T00:28:51 # Creating Drizzle table: test.C; engine: innodb; rows: 50 . # 2011-01-08T00:28:52 # Creating Drizzle table: test.D; engine: innodb; rows: 50 . # 2011-01-08T00:28:53 # Creating Drizzle table: test.AA; engine: innodb; rows: 75 . # 2011-01-08T00:28:54 # Creating Drizzle table: test.BB; engine: innodb; rows: 75 . # 2011-01-08T00:28:55 # Creating Drizzle table: test.CC; engine: innodb; rows: 100 . # 2011-01-08T00:28:57 # Creating Drizzle table: test.DD; engine: innodb; rows: 100 . # 2011-01-08T00:29:00 Reporters: DrizzleTransactionLog DBD::drizzle::db selectrow_arrayref failed: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'SLAVE HOSTS' at line 1 at lib/GenTest/Reporter.pm line 79. DBD::drizzle::db selectall_arrayref failed: Table 'information_schema.plugins' doesn't exist at lib/GenTest/Reporter.pm line 84. # 2011-01-08T00:29:00 Validators: ErrorMessageCorruption # 2011-01-08T00:29:00 Starting 1 processes, 100 queries each, duration 3600 seconds. # 2011-01-08T00:29:00 GenTest::ErrorFilter(2438) started # 2011-01-08T00:29:00 Default schema: test # 2011-01-08T00:29:00 Executor initialized, id 1 # 2011-01-08T00:29:00 Caching schema metadata for dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test # 2011-01-08T00:29:01 Started periodic reporting process... # 2011-01-08T00:29:01 Query: ROLLBACK TO SAVEPOINT A /*Generated by THREAD_ID 1*/ failed: 1305 SAVEPOINT %s does not exist. Further errors of this kind will be suppressed. # 2011-01-08T00:29:04 Query: DELETE FROM `B` WHERE `col_char_10_not_null_key` = ( SELECT `col_char_1024_key` FROM `B` WHERE `pk` = 'z' ) 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 /*Generated by THREAD_ID 1*/ failed: 1093 You can't specify target table '%s' for update in FROM clause. Further errors of this kind will be suppressed. # 2011-01-08T00:29:20 Query: UPDATE `BB` SET `col_int_not_null_key` = 'r' WHERE `col_char_1024` >= '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 5 /*Generated by THREAD_ID 1*/ failed: 1366 Incorrect integer value: 'r' for column 'col_int_not_null_key' at row %d. Further errors of this kind will be suppressed. # 2011-01-08T00:29:22 Query: UPDATE `DD` SET `col_int_not_null` = 3674013696 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 /*Generated by THREAD_ID 1*/ failed: 1264 Out of range value for column 'col_int_not_null' at row 1 # 2011-01-08T00:29:27 Child process completed successfully. # 2011-01-08T00:29:28 Killing periodic reporting process with pid 2439... # 2011-01-08T00:29:28 Kill GenTest::ErrorFilter(2438) # 2011-01-08T00:29:28 dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test # 2011-01-08T00:29:28 transaction_log output file: /tmp//translog_2431_.sql # 2011-01-08T00:29:28 <http://hudson.drizzle.org/job/drizzle-staging-randgen-transaction-log/ws/plugin/transaction_log/utilities/transaction_reader> <http://hudson.drizzle.org/job/drizzle-staging-randgen-transaction-log/ws/var/local/transaction.log> > /tmp//translog_2431_.sql # 2011-01-08T00:29:28 Replicating from transaction_log output... # 2011-01-08T00:29:28 <http://hudson.drizzle.org/job/drizzle-staging-randgen-transaction-log/ws/client/drizzle> --host=127.0.0.1 --port=9307 --user=root test < /tmp//translog_2431_.sql ERROR 1727 (HY000): Transactional DDL not supported # 2011-01-08T00:29:28 Test completed with failure status STATUS_UNKNOWN_ERROR (2) Sat Jan 8 00:29:28 2011 INFO: Pinging Drizzled server on port 9306 Sat Jan 8 00:29:28 2011 INFO: Stopping Drizzled server on port 9306 Sat Jan 8 00:29:31 2011 INFO: Clearing Drizzled server on port 9306 Sat Jan 8 00:29:31 2011 INFO: Starting Drizzled server on port 9306 Sat Jan 8 00:29:31 2011 INFO: PWD: /home/hudson/repos/randgen Sat Jan 8 00:29:39 2011 INFO: Dropping any test database previously setup. Sat Jan 8 00:29:39 2011 INFO: Creating test database. Sat Jan 8 00:29:39 2011 INFO: Pinging Drizzled server on port 9307 Sat Jan 8 00:29:39 2011 INFO: Stopping Drizzled server on port 9307 Sat Jan 8 00:29:42 2011 INFO: Clearing Drizzled server on port 9307 Sat Jan 8 00:29:42 2011 INFO: Starting Drizzled server on port 9307 Sat Jan 8 00:29:42 2011 INFO: PWD: /home/hudson/repos/randgen Sat Jan 8 00:29:49 2011 INFO: Dropping any test database previously setup. Sat Jan 8 00:29:49 2011 INFO: Creating test database. Sat Jan 8 00:29:49 2011 INFO: Running : multi_thread3_mix with ./gentest.pl --dsn=dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test --threads=5 --queries=500 --engine=Innodb --gendata=conf/drizzle/translog_drizzle.zz --grammar=conf/drizzle/translog_concurrent3.yy --Reporter=DrizzleTransactionLog --queries=250 --seed=time --threads=2 Sat Jan 8 00:32:24 2011 INFO: multi_thread3_mix FAILED # 2011-01-08T00:29:49 Starting # 2011-01-08T00:29:49 ./gentest.pl \ # 2011-01-08T00:29:49 --dsn=dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test \ # 2011-01-08T00:29:49 --threads=5 \ # 2011-01-08T00:29:49 --queries=500 \ # 2011-01-08T00:29:49 --engine=Innodb \ # 2011-01-08T00:29:49 --gendata=conf/drizzle/translog_drizzle.zz \ # 2011-01-08T00:29:49 --grammar=conf/drizzle/translog_concurrent3.yy \ # 2011-01-08T00:29:49 --Reporter=DrizzleTransactionLog \ # 2011-01-08T00:29:49 --queries=250 \ # 2011-01-08T00:29:49 --seed=time \ # 2011-01-08T00:29:49 --threads=2 # 2011-01-08T00:29:49 Converting --seed=time to --seed=1294446589 # 2011-01-08T00:29:49 ------------------------------- # 2011-01-08T00:29:49 Configuration # 2011-01-08T00:29:49 dsn => ['dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test'] # 2011-01-08T00:29:49 duration => 3600 # 2011-01-08T00:29:49 engine => Innodb # 2011-01-08T00:29:49 gendata => conf/drizzle/translog_drizzle.zz # 2011-01-08T00:29:49 grammar => conf/drizzle/translog_concurrent3.yy # 2011-01-08T00:29:49 queries => 250 # 2011-01-08T00:29:49 reporters => ['DrizzleTransactionLog'] # 2011-01-08T00:29:49 seed => time # 2011-01-08T00:29:49 threads => 2 # 2011-01-08T00:29:49 validators => [''] # 2011-01-08T00:29:49 Default schema: test # 2011-01-08T00:29:49 Executor initialized, id GenTest::Executor::Drizzle 2011.01.2063 () # 2011-01-08T00:29:49 # Creating Drizzle table: test.A; engine: innodb; rows: 10 . # 2011-01-08T00:29:50 # Creating Drizzle table: test.B; engine: innodb; rows: 10 . # 2011-01-08T00:29:50 # Creating Drizzle table: test.C; engine: innodb; rows: 50 . # 2011-01-08T00:29:51 # Creating Drizzle table: test.D; engine: innodb; rows: 50 . # 2011-01-08T00:29:53 # Creating Drizzle table: test.AA; engine: innodb; rows: 75 . # 2011-01-08T00:29:53 # Creating Drizzle table: test.BB; engine: innodb; rows: 75 . # 2011-01-08T00:29:54 # Creating Drizzle table: test.CC; engine: innodb; rows: 100 . # 2011-01-08T00:29:55 # Creating Drizzle table: test.DD; engine: innodb; rows: 100 . # 2011-01-08T00:29:56 Reporters: DrizzleTransactionLog DBD::drizzle::db selectrow_arrayref failed: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'SLAVE HOSTS' at line 1 at lib/GenTest/Reporter.pm line 79. DBD::drizzle::db selectall_arrayref failed: Table 'information_schema.plugins' doesn't exist at lib/GenTest/Reporter.pm line 84. # 2011-01-08T00:29:56 Validators: ErrorMessageCorruption # 2011-01-08T00:29:56 Starting 2 processes, 250 queries each, duration 3600 seconds. # 2011-01-08T00:29:56 GenTest::ErrorFilter(3015) started # 2011-01-08T00:29:56 Default schema: test # 2011-01-08T00:29:56 Executor initialized, id 1 # 2011-01-08T00:29:56 Caching schema metadata for dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test # 2011-01-08T00:29:56 Default schema: test # 2011-01-08T00:29:56 Executor initialized, id 1 # 2011-01-08T00:29:56 Caching schema metadata for dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test # 2011-01-08T00:29:57 Started periodic reporting process... # 2011-01-08T00:29:58 Query: ROLLBACK TO SAVEPOINT A /*Generated by THREAD_ID 2*/ failed: 1305 SAVEPOINT %s does not exist. Further errors of this kind will be suppressed. # 2011-01-08T00:30:06 Query: REPLACE INTO `C` ( `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 `col_enum_key` = ( SELECT `col_int_not_null_key` FROM `DD` WHERE `pk` = 203 ) 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: 1691 Received an invalid enum value '-%d'.. Further errors of this kind will be suppressed. # 2011-01-08T00:30:09 Query: ROLLBACK TO SAVEPOINT A /*Generated by THREAD_ID 1*/ failed: 1305 SAVEPOINT %s does not exist. Further errors of this kind will be suppressed. # 2011-01-08T00:30:15 Query: UPDATE `B` SET `col_int_not_null_key` = 1 WHERE `col_char_10_not_null_key` = ( SELECT `col_enum_key` FROM `B` WHERE `pk` = 'r' ) 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 /*Generated by THREAD_ID 1*/ failed: 1093 You can't specify target table '%s' for update in FROM clause. Further errors of this kind will be suppressed. # 2011-01-08T00:30:16 Query: DELETE FROM `A` WHERE `col_char_1024_not_null_key` = ( SELECT `col_char_1024_not_null_key` FROM `A` WHERE `pk` = 'f' ) 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 /*Generated by THREAD_ID 2*/ failed: 1093 You can't specify target table '%s' for update in FROM clause. Further errors of this kind will be suppressed. # 2011-01-08T00:30:16 Query: DELETE FROM `B` WHERE `col_char_1024_key` < 'NZWJB' 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 /*Generated by THREAD_ID 1*/ failed: 1213 Deadlock found when trying to get lock; try restarting transaction. Further errors of this kind will be suppressed. # 2011-01-08T00:30:23 Query: UPDATE `B` SET `col_bigint_key` = 4 WHERE `col_int_not_null_key` <= 8 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 /*Generated by THREAD_ID 2*/ failed: 1213 Deadlock found when trying to get lock; try restarting transaction. Further errors of this kind will be suppressed. # 2011-01-08T00:30:33 Query: REPLACE 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 `B` WHERE `col_bigint_key` > 'g' 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 2*/ failed: 1366 Incorrect integer value: 'g' for column 'col_bigint_key' at row %d. Further errors of this kind will be suppressed. # 2011-01-08T00:30:41 Query: INSERT INTO `C` ( `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_int_not_null_key` = 2669805568 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 2*/ failed: 1264 Out of range value for column 'col_int_not_null_key' at row 1 # 2011-01-08T00:30:51 Query: UPDATE `DD` SET `col_int` = 'y' WHERE `col_int` > 1 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 /*Generated by THREAD_ID 2*/ failed: 1366 Incorrect integer value: 'y' for column 'col_int' at row %d. Further errors of this kind will be suppressed. # 2011-01-08T00:30:53 Query: UPDATE `DD` SET `col_int` = 2577334272 WHERE `col_int_key` < 8 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 /*Generated by THREAD_ID 1*/ failed: 1264 Out of range value for column 'col_int' at row 1 # 2011-01-08T00:30:55 Query: UPDATE `CC` SET `col_bigint_key` = 't' WHERE `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 8 /*Generated by THREAD_ID 2*/ failed: 1366 Incorrect integer value: 't' for column 'col_bigint_key' at row %d. Further errors of this kind will be suppressed. # 2011-01-08T00:30:59 Query: UPDATE `D` SET `col_int_key` = 'k' WHERE `col_bigint` BETWEEN 2 AND 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 6 /*Generated by THREAD_ID 1*/ failed: 1366 Incorrect integer value: 'k' for column 'col_int_key' at row %d. Further errors of this kind will be suppressed. # 2011-01-08T00:31:14 Query: UPDATE `CC` SET `col_bigint` = 'a' WHERE `col_char_10_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 2*/ failed: 1366 Incorrect integer value: 'a' for column 'col_bigint' at row %d. Further errors of this kind will be suppressed. # 2011-01-08T00:32:05 Query: UPDATE `D` SET `col_int_not_null_key` = 'b' WHERE `col_bigint_key` >= 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 8 /*Generated by THREAD_ID 1*/ failed: 1366 Incorrect integer value: 'b' for column 'col_int_not_null_key' at row %d. Further errors of this kind will be suppressed. # 2011-01-08T00:32:05 Query: UPDATE `CC` SET `col_int_not_null` = 4263378944 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 5 /*Generated by THREAD_ID 1*/ failed: 1264 Out of range value for column 'col_int_not_null' at row 1 # 2011-01-08T00:32:06 Query: UPDATE `BB` SET `col_int` = 't' WHERE `col_int` > 6 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 /*Generated by THREAD_ID 1*/ failed: 1366 Incorrect integer value: 't' for column 'col_int' at row %d. Further errors of this kind will be suppressed. # 2011-01-08T00:32:11 Child process completed successfully. # 2011-01-08T00:32:20 Query: INSERT INTO `C` ( `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 `col_enum_not_null_key` = ( SELECT `col_char_10_not_null_key` FROM `AA` WHERE `pk` = 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 25 /*Generated by THREAD_ID 2*/ failed: 1691 Received an invalid enum value 'LSEFI'.. Further errors of this kind will be suppressed. # 2011-01-08T00:32:22 Child process completed successfully. # 2011-01-08T00:32:23 Killing periodic reporting process with pid 3016... # 2011-01-08T00:32:23 Kill GenTest::ErrorFilter(3015) # 2011-01-08T00:32:23 dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test # 2011-01-08T00:32:23 transaction_log output file: /tmp//translog_3008_.sql # 2011-01-08T00:32:23 <http://hudson.drizzle.org/job/drizzle-staging-randgen-transaction-log/ws/plugin/transaction_log/utilities/transaction_reader> <http://hudson.drizzle.org/job/drizzle-staging-randgen-transaction-log/ws/var/local/transaction.log> > /tmp//translog_3008_.sql # 2011-01-08T00:32:24 Replicating from transaction_log output... # 2011-01-08T00:32:24 <http://hudson.drizzle.org/job/drizzle-staging-randgen-transaction-log/ws/client/drizzle> --host=127.0.0.1 --port=9307 --user=root test < /tmp//translog_3008_.sql ERROR 1727 (HY000): Transactional DDL not supported # 2011-01-08T00:32:24 Test completed with failure status STATUS_UNKNOWN_ERROR (2) Sat Jan 8 00:32:24 2011 INFO: Pinging Drizzled server on port 9306 Sat Jan 8 00:32:24 2011 INFO: Stopping Drizzled server on port 9306 Sat Jan 8 00:32:27 2011 INFO: Clearing Drizzled server on port 9306 Sat Jan 8 00:32:27 2011 INFO: Starting Drizzled server on port 9306 Sat Jan 8 00:32:27 2011 INFO: PWD: /home/hudson/repos/randgen Sat Jan 8 00:32:33 2011 INFO: Dropping any test database previously setup. Sat Jan 8 00:32:33 2011 INFO: Creating test database. Sat Jan 8 00:32:33 2011 INFO: Pinging Drizzled server on port 9307 Sat Jan 8 00:32:33 2011 INFO: Stopping Drizzled server on port 9307 Sat Jan 8 00:32:36 2011 INFO: Clearing Drizzled server on port 9307 Sat Jan 8 00:32:36 2011 INFO: Starting Drizzled server on port 9307 Sat Jan 8 00:32:36 2011 INFO: PWD: /home/hudson/repos/randgen Sat Jan 8 00:32:40 2011 INFO: Dropping any test database previously setup. Sat Jan 8 00:32:40 2011 INFO: Creating test database. Sat Jan 8 00:32:40 2011 INFO: Stopping Drizzled server on port 9306 Sat Jan 8 00:32:41 2011 INFO: Stopping Drizzled server on port 9307 Sat Jan 8 00:32:41 2011 INFO: 0 tests passed Sat Jan 8 00:32:41 2011 INFO: 7 tests failed _______________________________________________ Mailing list: https://launchpad.net/~drizzle-builds Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-builds More help : https://help.launchpad.net/ListHelp
