See
<http://hudson.drizzle.org/job/drizzle-staging-randgen-transaction-log/146/changes>
Changes:
[Lee Bieber] Merge Marisa - updated and new docs, fixed build warnings, adding
examples
Merge Stewart - 664222: DDL operations have an implicit commit
Merge Stewart - 695201: autocommit=1 not resetting session->server_status
properly when committing ongoing txn
------------------------------------------
[...truncated 461 lines...]
# 2011-01-07T23:25:17 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-07T23:25:17 Validators: ErrorMessageCorruption
# 2011-01-07T23:25:17 Starting 5 processes, 100 queries each, duration 3600
seconds.
# 2011-01-07T23:25:17 GenTest::ErrorFilter(29709) started
# 2011-01-07T23:25:17 Default schema: test
# 2011-01-07T23:25:17 Executor initialized, id 1
# 2011-01-07T23:25:17 Caching schema metadata for
dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
# 2011-01-07T23:25:17 Default schema: test
# 2011-01-07T23:25:17 Executor initialized, id 1
# 2011-01-07T23:25:17 Caching schema metadata for
dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
# 2011-01-07T23:25:17 Default schema: test
# 2011-01-07T23:25:17 Executor initialized, id 1
# 2011-01-07T23:25:17 Caching schema metadata for
dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
# 2011-01-07T23:25:18 Default schema: test
# 2011-01-07T23:25:18 Executor initialized, id 1
# 2011-01-07T23:25:18 Caching schema metadata for
dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
# 2011-01-07T23:25:18 Query: ROLLBACK TO SAVEPOINT A failed: 1305 SAVEPOINT
%s does not exist. Further errors of this kind will be suppressed.
# 2011-01-07T23:25:18 Default schema: test
# 2011-01-07T23:25:18 Executor initialized, id 1
# 2011-01-07T23:25:18 Caching schema metadata for
dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
# 2011-01-07T23:25:18 Started periodic reporting process...
# 2011-01-07T23:25:18 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 `B` WHERE `col_int_not_null`
< '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 50 failed: 1292 Truncated incorrect DOUBLE value: 'c'. Further errors
of this kind will be suppressed.
# 2011-01-07T23:25:18 Query: ROLLBACK TO SAVEPOINT A failed: 1305 SAVEPOINT
%s does not exist. Further errors of this kind will be suppressed.
# 2011-01-07T23:25:18 Query: ROLLBACK TO SAVEPOINT A failed: 1305 SAVEPOINT
%s does not exist. Further errors of this kind will be suppressed.
# 2011-01-07T23:25:18 Query: UPDATE `CC` SET `col_int_not_null_key` = 5 WHERE
`col_enum_not_null_key` = 46 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: 1691 Received an invalid enum value '%d'.. Further errors of
this kind will be suppressed.
# 2011-01-07T23:25:18 Query: UPDATE `CC` SET `col_int` = 0 WHERE `col_char_10`
IN ('UOESF') 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-07T23:25:18 Query: DELETE FROM `A` WHERE `col_bigint_key` = ( SELECT
`col_enum_not_null_key` FROM `A` WHERE `pk` = 120 ) 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: 1093 You can't specify target table '%s' for update in FROM
clause. Further errors of this kind will be suppressed.
# 2011-01-07T23:25:18 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` BETWEEN
1 AND 'x' 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: 1292 Truncated incorrect DOUBLE value: 'x'. Further errors
of this kind will be suppressed.
# 2011-01-07T23:25:18 Query: UPDATE `B` SET `col_int_not_null_key` = 'u' WHERE
`col_int_not_null` = 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 failed: 1366 Incorrect integer value: 'u' for column
'col_int_not_null_key' at row %d. Further errors of this kind will be
suppressed.
# 2011-01-07T23:25:19 Query: ROLLBACK TO SAVEPOINT A failed: 1305 SAVEPOINT
%s does not exist. Further errors of this kind will be suppressed.
# 2011-01-07T23:25:19 Query: UPDATE `BB` SET `col_int_key` = 3 WHERE
`col_enum_not_null_key` = ( SELECT `col_text_key` FROM `BB` 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 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-07T23:25:19 Query: UPDATE `D` SET `col_int_key` = 'x' 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: 'x' for column 'col_int_key' at
row %d. Further errors of this kind will be suppressed.
# 2011-01-07T23:25:19 Query: DELETE FROM `C` WHERE
`col_char_1024_not_null_key` != '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 failed: 1213 Deadlock found when trying to get lock; try restarting
transaction. Further errors of this kind will be suppressed.
# 2011-01-07T23:25:19 Query: DELETE FROM `BB` WHERE `col_char_1024_key` <
3639607296 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-07T23:25:19 Query: UPDATE `BB` SET `col_bigint` = 8 WHERE
`col_char_10_key` < 'n' 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: 1213 Deadlock found when trying to get lock; try restarting
transaction. Further errors of this kind will be suppressed.
# 2011-01-07T23:25:19 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 `B` WHERE
`col_int_not_null_key` >= 's' 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: 1366 Incorrect integer value: 's' for column
'col_int_not_null_key' at row %d. Further errors of this kind will be
suppressed.
# 2011-01-07T23:25:19 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_int_not_null_key` >= 'e' 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: 1292 Truncated incorrect DOUBLE value: 'e'. Further errors of
this kind will be suppressed.
# 2011-01-07T23:25:20 Query: UPDATE `C` SET `col_int` = 'm' WHERE
`col_char_1024_not_null_key` IN ('HPWCC', 'r', 'l') 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: 'm' for column 'col_int' at row
%d. Further errors of this kind will be suppressed.
# 2011-01-07T23:25:20 Query: UPDATE `B` SET `col_int` = 2171797504 WHERE
`col_bigint` IN (3, 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 failed: 1264 Out of range value for column 'col_int' at row 1
# 2011-01-07T23:25:21 Query: UPDATE `BB` SET `col_int` = 7 WHERE
`col_bigint_key` 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 failed: 1213 Deadlock found when trying to get lock; try restarting
transaction. Further errors of this kind will be suppressed.
# 2011-01-07T23:25:21 Query: UPDATE `A` SET `col_bigint_key` = 't' WHERE
`col_int` IN (3, 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: 't' for column 'col_bigint_key'
at row %d. Further errors of this kind will be suppressed.
# 2011-01-07T23:25:21 Query: UPDATE `CC` SET `col_bigint_key` = 'w' WHERE
`col_int_not_null` 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: 'w' for column 'col_bigint_key'
at row %d. Further errors of this kind will be suppressed.
# 2011-01-07T23:25:21 Query: ROLLBACK TO SAVEPOINT A failed: 1305 SAVEPOINT
%s does not exist. Further errors of this kind will be suppressed.
# 2011-01-07T23:25:21 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 `CC` WHERE
`col_int_not_null_key` IN (3542155264) 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 100 failed: 1264 Out of range value for column 'col_int_not_null_key'
at row 1
# 2011-01-07T23:25:21 Query: UPDATE `C` SET `col_int_not_null` = 7 WHERE
`col_char_10_not_null_key` = ( SELECT `col_enum_not_null_key` FROM `C` 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 8 failed: 1093 You can't specify target table '%s' for update in FROM
clause. Further errors of this kind will be suppressed.
# 2011-01-07T23:25:22 Query: DELETE FROM `AA` WHERE `col_char_10_key` = (
SELECT `col_int_key` FROM `AA` WHERE `pk` = 249 ) 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 failed: 1093 You can't specify target table '%s' for update in FROM
clause. Further errors of this kind will be suppressed.
# 2011-01-07T23:25:23 Query: DELETE FROM `CC` WHERE `col_text_not_null_key` IN
( SELECT `col_int_not_null_key` FROM `CC` WHERE `pk` = 179 ) 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 failed: 1093 You can't specify target table '%s' for update in FROM
clause. Further errors of this kind will be suppressed.
# 2011-01-07T23:25:24 Query: SELECT X . `col_text_not_null_key` FROM `AA` AS X
WHERE X . `col_enum_not_null_key` IN ( 25 , 1799356416 , 212 , 3 , 25 ) LIMIT 7
LOCK IN SHARE MODE failed: 1691 Received an invalid enum value '%d'.. Further
errors of this kind will be suppressed.
# 2011-01-07T23:25:25 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 `BB` WHERE `col_int` <= 'x'
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: 'x'. Further errors
of this kind will be suppressed.
# 2011-01-07T23:25:25 Query: UPDATE `A` SET `col_int_key` = 6 WHERE
`col_enum_not_null_key` = 2755723264 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: 1691 Received an invalid enum value '%d'.. Further errors of
this kind will be suppressed.
# 2011-01-07T23:25:25 Query: UPDATE `DD` SET `col_int` = 'p' WHERE
`col_bigint_key` IN (3, 16) 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: 'p' for column 'col_int' at row
%d. Further errors of this kind will be suppressed.
# 2011-01-07T23:25:26 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_bigint` IN
('o', 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 25 failed: 1292 Truncated incorrect DOUBLE value: 'o'. Further errors of
this kind will be suppressed.
# 2011-01-07T23:25:26 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 `D` WHERE `col_int_key` =
'q' 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 failed: 1366 Incorrect integer value: 'q' for column 'col_int_key' at
row %d. Further errors of this kind will be suppressed.
# 2011-01-07T23:25:30 Query: UPDATE `D` SET `col_int_not_null` = 2274754560
WHERE `col_char_1024` IN ('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 failed: 1264 Out of range value for column 'col_int_not_null' at row 1
# 2011-01-07T23:25:31 Query: UPDATE `C` SET `col_int_not_null_key` = 'y' 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: 'y' for column
'col_int_not_null_key' at row %d. Further errors of this kind will be
suppressed.
# 2011-01-07T23:25:31 Child process completed successfully.
# 2011-01-07T23:25:32 Child process completed successfully.
# 2011-01-07T23:25:32 Child process completed successfully.
# 2011-01-07T23:25:33 Child process completed successfully.
# 2011-01-07T23:25:33 Child process completed successfully.
# 2011-01-07T23:25:34 Killing periodic reporting process with pid 29710...
# 2011-01-07T23:25:34 Kill GenTest::ErrorFilter(29709)
# 2011-01-07T23:25:34
dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
# 2011-01-07T23:25:34 transaction_log output file: /tmp//translog_29702_.sql
# 2011-01-07T23:25:34
<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_29702_.sql
# 2011-01-07T23:25:34 Replicating from transaction_log output...
# 2011-01-07T23:25:34
<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_29702_.sql
ERROR 1727 (HY000): Transactional DDL not supported
# 2011-01-07T23:25:34 Test completed with failure status STATUS_UNKNOWN_ERROR
(2)
Fri Jan 7 23:25:34 2011 INFO: Pinging Drizzled server on port 9306
Fri Jan 7 23:25:34 2011 INFO: Stopping Drizzled server on port 9306
Fri Jan 7 23:25:37 2011 INFO: Clearing Drizzled server on port 9306
Fri Jan 7 23:25:37 2011 INFO: Starting Drizzled server on port 9306
Fri Jan 7 23:25:37 2011 INFO: PWD: /home/hudson/repos/randgen
Fri Jan 7 23:25:43 2011 INFO: Dropping any test database previously setup.
Fri Jan 7 23:25:43 2011 INFO: Creating test database.
Fri Jan 7 23:25:43 2011 INFO: Pinging Drizzled server on port 9307
Fri Jan 7 23:25:43 2011 INFO: Stopping Drizzled server on port 9307
Fri Jan 7 23:25:46 2011 INFO: Clearing Drizzled server on port 9307
Fri Jan 7 23:25:46 2011 INFO: Starting Drizzled server on port 9307
Fri Jan 7 23:25:46 2011 INFO: PWD: /home/hudson/repos/randgen
Fri Jan 7 23:25:49 2011 INFO: Dropping any test database previously setup.
Fri Jan 7 23:25:49 2011 INFO: Creating test database.
Fri Jan 7 23:25:49 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
Fri Jan 7 23:26:08 2011 INFO: single_thread3 FAILED
# 2011-01-07T23:25:50 Starting
# 2011-01-07T23:25:50 ./gentest.pl \
# 2011-01-07T23:25:50
--dsn=dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test \
# 2011-01-07T23:25:50 --threads=5 \
# 2011-01-07T23:25:50 --queries=500 \
# 2011-01-07T23:25:50 --engine=Innodb \
# 2011-01-07T23:25:50 --gendata=conf/drizzle/translog_drizzle.zz \
# 2011-01-07T23:25:50 --grammar=conf/drizzle/translog_concurrent3.yy \
# 2011-01-07T23:25:50 --Reporter=DrizzleTransactionLog \
# 2011-01-07T23:25:50 --queries=100 \
# 2011-01-07T23:25:50 --threads=1
# 2011-01-07T23:25:50 -------------------------------
# 2011-01-07T23:25:50 Configuration
# 2011-01-07T23:25:50 dsn =>
['dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test']
# 2011-01-07T23:25:50 duration => 3600
# 2011-01-07T23:25:50 engine => Innodb
# 2011-01-07T23:25:50 gendata => conf/drizzle/translog_drizzle.zz
# 2011-01-07T23:25:50 grammar => conf/drizzle/translog_concurrent3.yy
# 2011-01-07T23:25:50 queries => 100
# 2011-01-07T23:25:50 reporters => ['DrizzleTransactionLog']
# 2011-01-07T23:25:50 seed => 1
# 2011-01-07T23:25:50 threads => 1
# 2011-01-07T23:25:50 validators => ['']
# 2011-01-07T23:25:50 Default schema: test
# 2011-01-07T23:25:50 Executor initialized, id GenTest::Executor::Drizzle
2011.01.2063 ()
# 2011-01-07T23:25:50 # Creating Drizzle table: test.A; engine: innodb; rows:
10 .
# 2011-01-07T23:25:50 # Creating Drizzle table: test.B; engine: innodb; rows:
10 .
# 2011-01-07T23:25:50 # Creating Drizzle table: test.C; engine: innodb; rows:
50 .
# 2011-01-07T23:25:52 # Creating Drizzle table: test.D; engine: innodb; rows:
50 .
# 2011-01-07T23:25:52 # Creating Drizzle table: test.AA; engine: innodb; rows:
75 .
# 2011-01-07T23:25:53 # Creating Drizzle table: test.BB; engine: innodb; rows:
75 .
# 2011-01-07T23:25:54 # Creating Drizzle table: test.CC; engine: innodb; rows:
100 .
# 2011-01-07T23:25:55 # Creating Drizzle table: test.DD; engine: innodb; rows:
100 .
# 2011-01-07T23:25:55 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-07T23:25:55 Validators: ErrorMessageCorruption
# 2011-01-07T23:25:55 Starting 1 processes, 100 queries each, duration 3600
seconds.
# 2011-01-07T23:25:55 GenTest::ErrorFilter(30181) started
# 2011-01-07T23:25:55 Default schema: test
# 2011-01-07T23:25:55 Executor initialized, id 1
# 2011-01-07T23:25:55 Caching schema metadata for
dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
# 2011-01-07T23:25:56 Started periodic reporting process...
# 2011-01-07T23:25:56 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-07T23:25:56 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-07T23:26:05 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-07T23:26:07 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-07T23:26:07 Child process completed successfully.
# 2011-01-07T23:26:08 Killing periodic reporting process with pid 30182...
# 2011-01-07T23:26:08 Kill GenTest::ErrorFilter(30181)
# 2011-01-07T23:26:08
dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
# 2011-01-07T23:26:08 transaction_log output file: /tmp//translog_30174_.sql
# 2011-01-07T23:26:08
<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_30174_.sql
# 2011-01-07T23:26:08 Replicating from transaction_log output...
# 2011-01-07T23:26:08
<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_30174_.sql
ERROR 1727 (HY000): Transactional DDL not supported
# 2011-01-07T23:26:08 Test completed with failure status STATUS_UNKNOWN_ERROR
(2)
Fri Jan 7 23:26:08 2011 INFO: Pinging Drizzled server on port 9306
Fri Jan 7 23:26:08 2011 INFO: Stopping Drizzled server on port 9306
Fri Jan 7 23:26:11 2011 INFO: Clearing Drizzled server on port 9306
Fri Jan 7 23:26:12 2011 INFO: Starting Drizzled server on port 9306
Fri Jan 7 23:26:12 2011 INFO: PWD: /home/hudson/repos/randgen
Fri Jan 7 23:26:16 2011 INFO: Dropping any test database previously setup.
Fri Jan 7 23:26:16 2011 INFO: Creating test database.
Fri Jan 7 23:26:16 2011 INFO: Pinging Drizzled server on port 9307
Fri Jan 7 23:26:16 2011 INFO: Stopping Drizzled server on port 9307
Fri Jan 7 23:26:19 2011 INFO: Clearing Drizzled server on port 9307
Fri Jan 7 23:26:19 2011 INFO: Starting Drizzled server on port 9307
Fri Jan 7 23:26:19 2011 INFO: PWD: /home/hudson/repos/randgen
Fri Jan 7 23:26:23 2011 INFO: Dropping any test database previously setup.
Fri Jan 7 23:26:23 2011 INFO: Creating test database.
Fri Jan 7 23:26:23 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
Fri Jan 7 23:27:09 2011 INFO: multi_thread3_mix FAILED
# 2011-01-07T23:26:23 Starting
# 2011-01-07T23:26:23 ./gentest.pl \
# 2011-01-07T23:26:23
--dsn=dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test \
# 2011-01-07T23:26:23 --threads=5 \
# 2011-01-07T23:26:23 --queries=500 \
# 2011-01-07T23:26:23 --engine=Innodb \
# 2011-01-07T23:26:23 --gendata=conf/drizzle/translog_drizzle.zz \
# 2011-01-07T23:26:23 --grammar=conf/drizzle/translog_concurrent3.yy \
# 2011-01-07T23:26:23 --Reporter=DrizzleTransactionLog \
# 2011-01-07T23:26:23 --queries=250 \
# 2011-01-07T23:26:23 --seed=time \
# 2011-01-07T23:26:23 --threads=2
# 2011-01-07T23:26:23 Converting --seed=time to --seed=1294442783
# 2011-01-07T23:26:23 -------------------------------
# 2011-01-07T23:26:23 Configuration
# 2011-01-07T23:26:23 dsn =>
['dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test']
# 2011-01-07T23:26:23 duration => 3600
# 2011-01-07T23:26:23 engine => Innodb
# 2011-01-07T23:26:23 gendata => conf/drizzle/translog_drizzle.zz
# 2011-01-07T23:26:23 grammar => conf/drizzle/translog_concurrent3.yy
# 2011-01-07T23:26:23 queries => 250
# 2011-01-07T23:26:23 reporters => ['DrizzleTransactionLog']
# 2011-01-07T23:26:23 seed => time
# 2011-01-07T23:26:23 threads => 2
# 2011-01-07T23:26:23 validators => ['']
# 2011-01-07T23:26:23 Default schema: test
# 2011-01-07T23:26:23 Executor initialized, id GenTest::Executor::Drizzle
2011.01.2063 ()
# 2011-01-07T23:26:23 # Creating Drizzle table: test.A; engine: innodb; rows:
10 .
# 2011-01-07T23:26:23 # Creating Drizzle table: test.B; engine: innodb; rows:
10 .
# 2011-01-07T23:26:24 # Creating Drizzle table: test.C; engine: innodb; rows:
50 .
# 2011-01-07T23:26:24 # Creating Drizzle table: test.D; engine: innodb; rows:
50 .
# 2011-01-07T23:26:24 # Creating Drizzle table: test.AA; engine: innodb; rows:
75 .
# 2011-01-07T23:26:25 # Creating Drizzle table: test.BB; engine: innodb; rows:
75 .
# 2011-01-07T23:26:26 # Creating Drizzle table: test.CC; engine: innodb; rows:
100 .
# 2011-01-07T23:26:26 # Creating Drizzle table: test.DD; engine: innodb; rows:
100 .
# 2011-01-07T23:26:27 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-07T23:26:27 Validators: ErrorMessageCorruption
# 2011-01-07T23:26:27 Starting 2 processes, 250 queries each, duration 3600
seconds.
# 2011-01-07T23:26:27 GenTest::ErrorFilter(30629) started
# 2011-01-07T23:26:27 Default schema: test
# 2011-01-07T23:26:27 Executor initialized, id 1
# 2011-01-07T23:26:27 Caching schema metadata for
dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
# 2011-01-07T23:26:27 Default schema: test
# 2011-01-07T23:26:27 Executor initialized, id 1
# 2011-01-07T23:26:27 Caching schema metadata for
dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
# 2011-01-07T23:26:27 Started periodic reporting process...
# 2011-01-07T23:26:27 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-07T23:26:27 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-07T23:26:28 Query: UPDATE `DD` SET `col_int_key` = 'u' WHERE
`col_char_1024_not_null_key` > 'NLOZS' 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: 'u'
for column 'col_int_key' at row %d. Further errors of this kind will be
suppressed.
# 2011-01-07T23:26:29 Query: UPDATE `CC` SET `col_int_key` = 4 WHERE
`col_char_1024_key` IN ( SELECT `col_text_not_null_key` FROM `CC` WHERE `pk` =
804323328 ) 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: 1093 You can't specify target
table '%s' for update in FROM clause. Further errors of this kind will be
suppressed.
# 2011-01-07T23:26:29 Query: DELETE FROM `A` 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 3 /*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-07T23:26:30 Query: DELETE FROM `A` WHERE `col_int` BETWEEN 1 AND 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 4 /*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-07T23:26:32 Query: UPDATE `CC` SET `col_int_key` = 2853306368 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: 1264 Out of range value for
column 'col_int_key' at row 1
# 2011-01-07T23:26:40 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 `A` WHERE `col_enum_key` = (
SELECT `col_bigint_key` FROM `C` WHERE `pk` = 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 50 /*Generated by THREAD_ID 1*/ failed: 1691 Received an invalid enum
value '%d'.. Further errors of this kind will be suppressed.
# 2011-01-07T23:26:41 Query: UPDATE `A` SET `col_int_not_null_key` = 'k' WHERE
`col_text_not_null_key` != 'u' 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:
'k' for column 'col_int_not_null_key' at row %d. Further errors of this kind
will be suppressed.
# 2011-01-07T23:26:43 Query: UPDATE `AA` SET `col_int` = 7 WHERE `col_enum_key`
IN ( SELECT `col_char_10_not_null_key` FROM `AA` WHERE `pk` = 2719023104 )
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: 1093 You can't specify target
table '%s' for update in FROM clause. Further errors of this kind will be
suppressed.
# 2011-01-07T23:26:50 Query: UPDATE `DD` SET `col_bigint_key` = 'v' WHERE
`col_enum_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 7 /*Generated by THREAD_ID 1*/ failed: 1366 Incorrect integer value:
'v' for column 'col_bigint_key' at row %d. Further errors of this kind will be
suppressed.
# 2011-01-07T23:26:59 Query: UPDATE `D` SET `col_bigint` = 'l' WHERE
`col_int_key` BETWEEN 4 AND 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 /*Generated by THREAD_ID 1*/ failed: 1366 Incorrect integer value:
'l' for column 'col_bigint' at row %d. Further errors of this kind will be
suppressed.
# 2011-01-07T23:27:07 Child process completed successfully.
# 2011-01-07T23:27:08 Child process completed successfully.
# 2011-01-07T23:27:09 Killing periodic reporting process with pid 30630...
# 2011-01-07T23:27:09 Kill GenTest::ErrorFilter(30629)
# 2011-01-07T23:27:09
dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
# 2011-01-07T23:27:09 transaction_log output file: /tmp//translog_30622_.sql
# 2011-01-07T23:27:09
<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_30622_.sql
# 2011-01-07T23:27:09 Replicating from transaction_log output...
# 2011-01-07T23:27:09
<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_30622_.sql
ERROR 1727 (HY000): Transactional DDL not supported
# 2011-01-07T23:27:09 Test completed with failure status STATUS_UNKNOWN_ERROR
(2)
Fri Jan 7 23:27:09 2011 INFO: Pinging Drizzled server on port 9306
Fri Jan 7 23:27:09 2011 INFO: Stopping Drizzled server on port 9306
Fri Jan 7 23:27:12 2011 INFO: Clearing Drizzled server on port 9306
Fri Jan 7 23:27:12 2011 INFO: Starting Drizzled server on port 9306
Fri Jan 7 23:27:12 2011 INFO: PWD: /home/hudson/repos/randgen
Fri Jan 7 23:27:17 2011 INFO: Dropping any test database previously setup.
Fri Jan 7 23:27:17 2011 INFO: Creating test database.
Fri Jan 7 23:27:17 2011 INFO: Pinging Drizzled server on port 9307
Fri Jan 7 23:27:17 2011 INFO: Stopping Drizzled server on port 9307
Fri Jan 7 23:27:20 2011 INFO: Clearing Drizzled server on port 9307
Fri Jan 7 23:27:20 2011 INFO: Starting Drizzled server on port 9307
Fri Jan 7 23:27:20 2011 INFO: PWD: /home/hudson/repos/randgen
Fri Jan 7 23:27:26 2011 INFO: Dropping any test database previously setup.
Fri Jan 7 23:27:26 2011 INFO: Creating test database.
Fri Jan 7 23:27:26 2011 INFO: Stopping Drizzled server on port 9306
Fri Jan 7 23:27:26 2011 INFO: Stopping Drizzled server on port 9307
Fri Jan 7 23:27:26 2011 INFO: 0 tests passed
Fri Jan 7 23:27:26 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
