drizzle-merge team mailing list archive

Thread
Date
Re: [Drizzle-builds] Build failed in Hudson: drizzle-staging-randgen-transaction-log #62

To: Patrick Crews <gleebix@xxxxxxxxx>
From: Lee Bieber <kalebral@xxxxxxxxx>
Date: Sun, 5 Dec 2010 20:00:12 -0800
Cc: drizzle-merge@xxxxxxxxxxxxxxxxxxx, Andrew Hutchings <andrew@xxxxxxxxxxxxxxx>
In-reply-to: <298731385.111291606690198.JavaMail.hudson@hudson>
Hi Patrick,
I was merging Andrew's branch which is fixing a bunch of drizzledump bugs
when I got these test failures. I have run this twice now with the same set
of failures each time.  I can't imagine any of Andrew's changes would affect
this, would you take a look and let us know what you think?

On Sun, Dec 5, 2010 at 7:38 PM, <kalebral@xxxxxxxxx> wrote:

> See <
> http://hudson.drizzle.org/job/drizzle-staging-randgen-transaction-log/62/>
>
> ------------------------------------------
> [...truncated 418 lines...]
> # 2010-12-06T03:36:25 Query:  DELETE FROM `DD` WHERE
> `col_char_1024_not_null_key` != 7 ORDER BY
> `col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk`
> LIMIT 3  failed: 1213 Deadlock found when trying to get lock; try restarting
> transaction. Further errors of this kind will be suppressed.
> # 2010-12-06T03:36:25 Query:  ROLLBACK TO SAVEPOINT A  failed: 1305
> SAVEPOINT %s does not exist. Further errors of this kind will be suppressed.
> # 2010-12-06T03:36:25 Query:  ROLLBACK TO SAVEPOINT A  failed: 1305
> SAVEPOINT %s does not exist. Further errors of this kind will be suppressed.
> # 2010-12-06T03:36:25 Query: DELETE FROM `D` WHERE
> `col_bigint_not_null_key` IN ( SELECT `col_enum_key` FROM `D` WHERE `pk` =
> 1071513600 ) 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.
> # 2010-12-06T03:36:25 Query:  ROLLBACK TO SAVEPOINT A  failed: 1305
> SAVEPOINT %s does not exist. Further errors of this kind will be suppressed.
> # 2010-12-06T03:36:25 Started periodic reporting process...
> # 2010-12-06T03:36:25 Query:  UPDATE `A` SET `col_int_key` = 8 WHERE
> `col_text_not_null_key` <= 'ROBRB' 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: 1213 Deadlock found when trying to get lock; try restarting
> transaction. Further errors of this kind will be suppressed.
> # 2010-12-06T03:36:25 Query:  ROLLBACK TO SAVEPOINT A  failed: 1305
> SAVEPOINT %s does not exist. Further errors of this kind will be suppressed.
> # 2010-12-06T03:36:25 Query:  DELETE FROM `C` WHERE `col_text_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 4  failed: 1213 Deadlock found when trying to get lock; try restarting
> transaction. Further errors of this kind will be suppressed.
> # 2010-12-06T03:36:26 Query: ROLLBACK TO SAVEPOINT A failed: 1305 SAVEPOINT
> %s does not exist. Further errors of this kind will be suppressed.
> # 2010-12-06T03:36:26 Query:  DELETE FROM `D` WHERE `col_enum_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 3  failed: 1691 Received an invalid enum value '%d'.. Further errors
> of this kind will be suppressed.
> # 2010-12-06T03:36:26 Query:  INSERT INTO `B` ( `col_char_10` ,
> `col_char_10_key` , `col_char_10_not_null` , `col_char_10_not_null_key` ,
> `col_char_1024` , `col_char_1024_key` , `col_char_1024_not_null` ,
> `col_char_1024_not_null_key` , `col_int` , `col_int_key` ,
> `col_int_not_null` , `col_int_not_null_key` , `col_bigint` ,
> `col_bigint_key` , `col_bigint_not_null` , `col_bigint_not_null_key` ,
> `col_enum` , `col_enum_key` , `col_enum_not_null` , `col_enum_not_null_key`
> , `col_text` , `col_text_key` , `col_text_not_null` ,
> `col_text_not_null_key` ) SELECT `col_char_10` , `col_char_10_key` ,
> `col_char_10_not_null` , `col_char_10_not_null_key` , `col_char_1024` ,
> `col_char_1024_key` , `col_char_1024_not_null` ,
> `col_char_1024_not_null_key` , `col_int` , `col_int_key` ,
> `col_int_not_null` , `col_int_not_null_key` , `col_bigint` ,
> `col_bigint_key` , `col_bigint_not_null` , `col_bigint_not_null_key` ,
> `col_enum` , `col_enum_key` , `col_enum_not_null` , `col_enum_not_null_key`
> , `col_text` , `col_text_key` , `col_text_not_null` ,
> `col_text_not_null_key` FROM `A` WHERE `col_bigint_not_null_key` = 'd' 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: 'd' for column
> 'col_bigint_not_null_key' at row %d. Further errors of this kind will be
> suppressed.
> # 2010-12-06T03:36:26 Query:  SELECT X . `col_char_10_not_null` FROM `BB`
> AS X WHERE X . `col_enum_key` IN ( 2 , 122 , 1997537280 , 0 , 76 ) LIMIT 6
> failed: 1691 Received an invalid enum value '%d'.. Further errors of this
> kind will be suppressed.
> # 2010-12-06T03:36:26 Query:  DELETE FROM `C` WHERE
> `col_bigint_not_null_key` IN ( SELECT `col_text_key` FROM `C` WHERE `pk` =
> 205 ) 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: 1093 You can't specify target table '%s' for update in FROM
> clause. Further errors of this kind will be suppressed.
> # 2010-12-06T03:36:26 Query:  INSERT INTO `D` ( `col_char_10` ,
> `col_char_10_key` , `col_char_10_not_null` , `col_char_10_not_null_key` ,
> `col_char_1024` , `col_char_1024_key` , `col_char_1024_not_null` ,
> `col_char_1024_not_null_key` , `col_int` , `col_int_key` ,
> `col_int_not_null` , `col_int_not_null_key` , `col_bigint` ,
> `col_bigint_key` , `col_bigint_not_null` , `col_bigint_not_null_key` ,
> `col_enum` , `col_enum_key` , `col_enum_not_null` , `col_enum_not_null_key`
> , `col_text` , `col_text_key` , `col_text_not_null` ,
> `col_text_not_null_key` ) SELECT `col_char_10` , `col_char_10_key` ,
> `col_char_10_not_null` , `col_char_10_not_null_key` , `col_char_1024` ,
> `col_char_1024_key` , `col_char_1024_not_null` ,
> `col_char_1024_not_null_key` , `col_int` , `col_int_key` ,
> `col_int_not_null` , `col_int_not_null_key` , `col_bigint` ,
> `col_bigint_key` , `col_bigint_not_null` , `col_bigint_not_null_key` ,
> `col_enum` , `col_enum_key` , `col_enum_not_null` , `col_enum_not_null_key`
> , `col_text` , `col_text_key` , `col_text_not_null` ,
> `col_text_not_null_key` FROM `AA` WHERE `col_int_key` IN ('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 25  failed: 1292 Truncated incorrect DOUBLE value: 'n'. Further errors
> of this kind will be suppressed.
> # 2010-12-06T03:36:26 Query:  UPDATE `AA` SET `col_int_not_null` = 190
>  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: 1213 Deadlock found when trying to get lock; try restarting
> transaction. Further errors of this kind will be suppressed.
> # 2010-12-06T03:36:26 Query:  SELECT X . `col_int_key` FROM `C` AS X LEFT
> JOIN `D` AS Y USING ( `col_char_10_key` ) WHERE X . `col_enum_not_null_key`
> IN ( 4 , 917504 , 188 , 182 , 2814967808 ) LIMIT 6 FOR UPDATE  failed: 1691
> Received an invalid enum value '%d'.. Further errors of this kind will be
> suppressed.
> # 2010-12-06T03:36:26 Query:  SELECT * FROM `DD` AS X LEFT JOIN `DD` AS Y
> USING ( `col_int_not_null_key` ) WHERE X . `col_enum_key` IN ( 40 , 2 ,
> 1425211392 , 6 , 34 ) LIMIT 7   failed: 1691 Received an invalid enum value
> '%d'.. Further errors of this kind will be suppressed.
> # 2010-12-06T03:36:26 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 `C` WHERE `col_int_not_null_key` BETWEEN 4 AND
> 2287665152 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
> # 2010-12-06T03:36:26 Query:  DELETE FROM `A` WHERE `col_text_not_null_key`
> IN ( SELECT `col_char_1024_not_null_key` FROM `A` WHERE `pk` = 2058420224 )
> 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.
> # 2010-12-06T03:36:27 Query:  UPDATE `CC` SET `col_int_not_null` = 'p'
> WHERE `col_int_not_null` < 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 5  failed: 1366 Incorrect integer value: 'p' for column
> 'col_int_not_null' at row %d. Further errors of this kind will be
> suppressed.
> # 2010-12-06T03:36:27 Query:  UPDATE `C` SET `col_int_not_null_key` =
> 3479306240  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_key'
> at row 1
> # 2010-12-06T03:36:27 Query: UPDATE `AA` SET `col_int` = 2542600192 WHERE
> `col_char_10` IN ('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 8 failed: 1264 Out of range value for column 'col_int' at row 1
> # 2010-12-06T03:36:27 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_not_null_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 10  failed: 1366 Incorrect integer value: 'g' for column
> 'col_bigint_not_null_key' at row %d. Further errors of this kind will be
> suppressed.
> # 2010-12-06T03:36:27 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 `DD` WHERE `col_int_not_null_key` = 'c' ORDER
> BY
> `col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk`
> LIMIT 25  failed: 1366 Incorrect integer value: 'c' for column
> 'col_int_not_null_key' at row %d. Further errors of this kind will be
> suppressed.
> # 2010-12-06T03:36:27 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 `DD` WHERE `col_int_key` = 2846949376 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_key' at row 1
> # 2010-12-06T03:36:27 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_key` = '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 25  failed: 1292 Truncated incorrect DOUBLE value: 'l'. Further errors
> of this kind will be suppressed.
> # 2010-12-06T03:36:27 Query:  UPDATE `C` SET `col_int_not_null_key` = 't'
> WHERE `col_int_key` IN (2, 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 5  failed: 1366 Incorrect integer value: 't' for column
> 'col_int_not_null_key' at row %d. Further errors of this kind will be
> suppressed.
> # 2010-12-06T03:36:28 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_bigint_not_null_key` = ( SELECT
> `col_char_10_key` FROM `D` WHERE `pk` = 9 ) 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: 'would' for column
> 'col_bigint_not_null_key' at row %d. Further errors of this kind will be
> suppressed.
> # 2010-12-06T03:36:28 Query:  UPDATE `DD` SET `col_int` = 'i' WHERE
> `col_char_10_not_null_key` != 1076035584 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' at
> row %d. Further errors of this kind will be suppressed.
> # 2010-12-06T03:36:28 Query:  INSERT INTO `AA` ( `col_char_10` ,
> `col_char_10_key` , `col_char_10_not_null` , `col_char_10_not_null_key` ,
> `col_char_1024` , `col_char_1024_key` , `col_char_1024_not_null` ,
> `col_char_1024_not_null_key` , `col_int` , `col_int_key` ,
> `col_int_not_null` , `col_int_not_null_key` , `col_bigint` ,
> `col_bigint_key` , `col_bigint_not_null` , `col_bigint_not_null_key` ,
> `col_enum` , `col_enum_key` , `col_enum_not_null` , `col_enum_not_null_key`
> , `col_text` , `col_text_key` , `col_text_not_null` ,
> `col_text_not_null_key` ) SELECT `col_char_10` , `col_char_10_key` ,
> `col_char_10_not_null` , `col_char_10_not_null_key` , `col_char_1024` ,
> `col_char_1024_key` , `col_char_1024_not_null` ,
> `col_char_1024_not_null_key` , `col_int` , `col_int_key` ,
> `col_int_not_null` , `col_int_not_null_key` , `col_bigint` ,
> `col_bigint_key` , `col_bigint_not_null` , `col_bigint_not_null_key` ,
> `col_enum` , `col_enum_key` , `col_enum_not_null` , `col_enum_not_null_key`
> , `col_text` , `col_text_key` , `col_text_not_null` ,
> `col_text_not_null_key` FROM `A` WHERE `col_enum_not_null_key` = 143 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: 1691 Received an invalid enum value '%d'.. Further errors
> of this kind will be suppressed.
> # 2010-12-06T03:36:28 Query: UPDATE `D` SET `col_bigint` = 'f' WHERE
> `col_bigint` < 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 failed: 1366 Incorrect integer value: 'f' for column 'col_bigint' at
> row %d. Further errors of this kind will be suppressed.
> # 2010-12-06T03:36:28 Child process completed successfully.
> # 2010-12-06T03:36:28 Query:  REPLACE 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_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 10  failed: 1292 Truncated incorrect DOUBLE value: 's'. Further errors
> of this kind will be suppressed.
> # 2010-12-06T03:36:28 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 `CC` WHERE `col_int_key` BETWEEN 2453602304 AND
> 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 25 failed: 1264 Out of range value for column 'col_int_key' at row 1
> # 2010-12-06T03:36:28 Query:  DELETE FROM `B` WHERE
> `col_char_1024_not_null_key` IN ( SELECT `col_enum_key` FROM `B` WHERE `pk`
> = 1234567168 ) 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.
> # 2010-12-06T03:36:28 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 `A` WHERE `col_int_key` BETWEEN 'u' AND 9 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: 'u'. Further errors
> of this kind will be suppressed.
> # 2010-12-06T03:36:28 Child process completed successfully.
> # 2010-12-06T03:36:29 Child process completed successfully.
> # 2010-12-06T03:36:29 Query:  INSERT INTO `DD` ( `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_not_null_key` > 'o' 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: 'o' for column
> 'col_bigint_not_null_key' at row %d. Further errors of this kind will be
> suppressed.
> # 2010-12-06T03:36:29 Child process completed successfully.
> # 2010-12-06T03:36:29 Child process completed successfully.
> # 2010-12-06T03:36:30 Killing periodic reporting process with pid 1718...
> # 2010-12-06T03:36:30 Kill GenTest::ErrorFilter(1717)
> # 2010-12-06T03:36:30
> dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
> # 2010-12-06T03:36:30 transaction_log output file:
>  /tmp//translog_1710_.sql
> # 2010-12-06T03:36:30 <
> 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_1710_.sql
> # 2010-12-06T03:36:31 Replicating from transaction_log output...
> # 2010-12-06T03:36:31 <
> 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_1710_.sql
> # 2010-12-06T03:36:34 Validating replication via dumpfile compare...
> # 2010-12-06T03:36:34 /tmp//translog_rpl_dump_1710_9306.sql
> # 2010-12-06T03:36:34 <
> http://hudson.drizzle.org/job/drizzle-staging-randgen-transaction-log/ws/client/drizzledump>
> --compact --skip-extended-insert --host=127.0.0.1 --port=9306 --user=root
> test >/tmp//translog_rpl_dump_1710_9306.sql
> Error: Data for column col_bigint_not_null_key is greater than max BIGINT,
> cannot migrate automatically
> # 2010-12-06T03:36:34 Test completed with failure status
> STATUS_UNKNOWN_ERROR (2)
> Mon Dec  6 03:36:34 2010 INFO: Pinging Drizzled server on port 9306
> Mon Dec  6 03:36:34 2010 INFO: Stopping Drizzled server on port 9306
> Mon Dec  6 03:36:37 2010 INFO: Clearing Drizzled server on port 9306
> Mon Dec  6 03:36:37 2010 INFO: Starting Drizzled server on port 9306
> Mon Dec  6 03:36:37 2010 INFO: PWD:  /home/hudson/repos/randgen
> Mon Dec  6 03:36:38 2010 INFO: Dropping any test database previously setup.
> Mon Dec  6 03:36:39 2010 INFO: Creating test database.
> Mon Dec  6 03:36:39 2010 INFO: Pinging Drizzled server on port 9307
> Mon Dec  6 03:36:39 2010 INFO: Stopping Drizzled server on port 9307
> Mon Dec  6 03:36:42 2010 INFO: Clearing Drizzled server on port 9307
> Mon Dec  6 03:36:42 2010 INFO: Starting Drizzled server on port 9307
> Mon Dec  6 03:36:42 2010 INFO: PWD:  /home/hudson/repos/randgen
> Mon Dec  6 03:36:43 2010 INFO: Dropping any test database previously setup.
> Mon Dec  6 03:36:43 2010 INFO: Creating test database.
> Mon Dec  6 03:36:43 2010 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
> Mon Dec  6 03:36:55 2010 INFO: single_thread3 FAILED
> # 2010-12-06T03:36:43 Starting
> # 2010-12-06T03:36:43  ./gentest.pl \
> # 2010-12-06T03:36:43
>  --dsn=dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
> \
> # 2010-12-06T03:36:43  --threads=5 \
> # 2010-12-06T03:36:43  --queries=500 \
> # 2010-12-06T03:36:43  --engine=Innodb \
> # 2010-12-06T03:36:43  --gendata=conf/drizzle/translog_drizzle.zz \
> # 2010-12-06T03:36:43  --grammar=conf/drizzle/translog_concurrent3.yy \
> # 2010-12-06T03:36:43  --Reporter=DrizzleTransactionLog \
> # 2010-12-06T03:36:43  --queries=100 \
> # 2010-12-06T03:36:43  --threads=1
> # 2010-12-06T03:36:43 -------------------------------
> # 2010-12-06T03:36:43 Configuration
> # 2010-12-06T03:36:43   dsn =>
> ['dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test']
> # 2010-12-06T03:36:43   duration => 3600
> # 2010-12-06T03:36:43   engine => Innodb
> # 2010-12-06T03:36:43   gendata => conf/drizzle/translog_drizzle.zz
> # 2010-12-06T03:36:43   grammar => conf/drizzle/translog_concurrent3.yy
> # 2010-12-06T03:36:43   queries => 100
> # 2010-12-06T03:36:43   reporters => ['DrizzleTransactionLog']
> # 2010-12-06T03:36:43   seed => 1
> # 2010-12-06T03:36:43   threads => 1
> # 2010-12-06T03:36:43   validators => ['']
> # 2010-12-06T03:36:43 Default schema: test
> # 2010-12-06T03:36:43 Executor initialized, id GenTest::Executor::Drizzle
> 2010.12.1977 ()
> # 2010-12-06T03:36:43 # Creating Drizzle table: test.A; engine: innodb;
> rows: 10 .
> # 2010-12-06T03:36:44 # Creating Drizzle table: test.B; engine: innodb;
> rows: 10 .
> # 2010-12-06T03:36:44 # Creating Drizzle table: test.C; engine: innodb;
> rows: 50 .
> # 2010-12-06T03:36:44 # Creating Drizzle table: test.D; engine: innodb;
> rows: 50 .
> # 2010-12-06T03:36:44 # Creating Drizzle table: test.AA; engine: innodb;
> rows: 75 .
> # 2010-12-06T03:36:45 # Creating Drizzle table: test.BB; engine: innodb;
> rows: 75 .
> # 2010-12-06T03:36:46 # Creating Drizzle table: test.CC; engine: innodb;
> rows: 100 .
> # 2010-12-06T03:36:46 # Creating Drizzle table: test.DD; engine: innodb;
> rows: 100 .
> # 2010-12-06T03:36:47 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.
> # 2010-12-06T03:36:47 Validators: ErrorMessageCorruption
> # 2010-12-06T03:36:47 Starting 1 processes, 100 queries each, duration 3600
> seconds.
> # 2010-12-06T03:36:47 GenTest::ErrorFilter(2112) started
> # 2010-12-06T03:36:47 Default schema: test
> # 2010-12-06T03:36:47 Executor initialized, id 1
> # 2010-12-06T03:36:47 Caching schema metadata for
> dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
> # 2010-12-06T03:36:47 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.
> # 2010-12-06T03:36:47 Started periodic reporting process...
> # 2010-12-06T03:36:47 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.
> # 2010-12-06T03:36:50 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.
> # 2010-12-06T03:36:50 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
> # 2010-12-06T03:36:50 Child process completed successfully.
> # 2010-12-06T03:36:51 Killing periodic reporting process with pid 2113...
> # 2010-12-06T03:36:51 Kill GenTest::ErrorFilter(2112)
> # 2010-12-06T03:36:51
> dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
> # 2010-12-06T03:36:51 transaction_log output file:
>  /tmp//translog_2105_.sql
> # 2010-12-06T03:36:51 <
> 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_2105_.sql
> # 2010-12-06T03:36:51 Replicating from transaction_log output...
> # 2010-12-06T03:36:51 <
> 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_2105_.sql
> # 2010-12-06T03:36:54 Validating replication via dumpfile compare...
> # 2010-12-06T03:36:54 /tmp//translog_rpl_dump_2105_9306.sql
> # 2010-12-06T03:36:54 <
> http://hudson.drizzle.org/job/drizzle-staging-randgen-transaction-log/ws/client/drizzledump>
> --compact --skip-extended-insert --host=127.0.0.1 --port=9306 --user=root
> test >/tmp//translog_rpl_dump_2105_9306.sql
> Error: Data for column col_bigint_not_null_key is greater than max BIGINT,
> cannot migrate automatically
> # 2010-12-06T03:36:55 Test completed with failure status
> STATUS_UNKNOWN_ERROR (2)
> Mon Dec  6 03:36:55 2010 INFO: Pinging Drizzled server on port 9306
> Mon Dec  6 03:36:55 2010 INFO: Stopping Drizzled server on port 9306
> Mon Dec  6 03:36:58 2010 INFO: Clearing Drizzled server on port 9306
> Mon Dec  6 03:36:58 2010 INFO: Starting Drizzled server on port 9306
> Mon Dec  6 03:36:58 2010 INFO: PWD:  /home/hudson/repos/randgen
> Mon Dec  6 03:36:59 2010 INFO: Dropping any test database previously setup.
> Mon Dec  6 03:36:59 2010 INFO: Creating test database.
> Mon Dec  6 03:36:59 2010 INFO: Pinging Drizzled server on port 9307
> Mon Dec  6 03:36:59 2010 INFO: Stopping Drizzled server on port 9307
> Mon Dec  6 03:37:02 2010 INFO: Clearing Drizzled server on port 9307
> Mon Dec  6 03:37:03 2010 INFO: Starting Drizzled server on port 9307
> Mon Dec  6 03:37:03 2010 INFO: PWD:  /home/hudson/repos/randgen
> Mon Dec  6 03:37:04 2010 INFO: Dropping any test database previously setup.
> Mon Dec  6 03:37:04 2010 INFO: Creating test database.
> Mon Dec  6 03:37:04 2010 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
> Mon Dec  6 03:37:38 2010 INFO: multi_thread3_mix FAILED
> # 2010-12-06T03:37:04 Starting
> # 2010-12-06T03:37:04  ./gentest.pl \
> # 2010-12-06T03:37:04
>  --dsn=dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
> \
> # 2010-12-06T03:37:04  --threads=5 \
> # 2010-12-06T03:37:04  --queries=500 \
> # 2010-12-06T03:37:04  --engine=Innodb \
> # 2010-12-06T03:37:04  --gendata=conf/drizzle/translog_drizzle.zz \
> # 2010-12-06T03:37:04  --grammar=conf/drizzle/translog_concurrent3.yy \
> # 2010-12-06T03:37:04  --Reporter=DrizzleTransactionLog \
> # 2010-12-06T03:37:04  --queries=250 \
> # 2010-12-06T03:37:04  --seed=time \
> # 2010-12-06T03:37:04  --threads=2
> # 2010-12-06T03:37:04 Converting --seed=time to --seed=1291606624
> # 2010-12-06T03:37:04 -------------------------------
> # 2010-12-06T03:37:04 Configuration
> # 2010-12-06T03:37:04   dsn =>
> ['dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test']
> # 2010-12-06T03:37:04   duration => 3600
> # 2010-12-06T03:37:04   engine => Innodb
> # 2010-12-06T03:37:04   gendata => conf/drizzle/translog_drizzle.zz
> # 2010-12-06T03:37:04   grammar => conf/drizzle/translog_concurrent3.yy
> # 2010-12-06T03:37:04   queries => 250
> # 2010-12-06T03:37:04   reporters => ['DrizzleTransactionLog']
> # 2010-12-06T03:37:04   seed => time
> # 2010-12-06T03:37:04   threads => 2
> # 2010-12-06T03:37:04   validators => ['']
> # 2010-12-06T03:37:04 Default schema: test
> # 2010-12-06T03:37:04 Executor initialized, id GenTest::Executor::Drizzle
> 2010.12.1977 ()
> # 2010-12-06T03:37:04 # Creating Drizzle table: test.A; engine: innodb;
> rows: 10 .
> # 2010-12-06T03:37:04 # Creating Drizzle table: test.B; engine: innodb;
> rows: 10 .
> # 2010-12-06T03:37:04 # Creating Drizzle table: test.C; engine: innodb;
> rows: 50 .
> # 2010-12-06T03:37:05 # Creating Drizzle table: test.D; engine: innodb;
> rows: 50 .
> # 2010-12-06T03:37:05 # Creating Drizzle table: test.AA; engine: innodb;
> rows: 75 .
> # 2010-12-06T03:37:05 # Creating Drizzle table: test.BB; engine: innodb;
> rows: 75 .
> # 2010-12-06T03:37:06 # Creating Drizzle table: test.CC; engine: innodb;
> rows: 100 .
> # 2010-12-06T03:37:06 # Creating Drizzle table: test.DD; engine: innodb;
> rows: 100 .
> # 2010-12-06T03:37:07 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.
> # 2010-12-06T03:37:07 Validators: ErrorMessageCorruption
> # 2010-12-06T03:37:07 Starting 2 processes, 250 queries each, duration 3600
> seconds.
> # 2010-12-06T03:37:07 GenTest::ErrorFilter(2508) started
> # 2010-12-06T03:37:07 Default schema: test
> # 2010-12-06T03:37:07 Executor initialized, id 1
> # 2010-12-06T03:37:07 Caching schema metadata for
> dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
> # 2010-12-06T03:37:07 Default schema: test
> # 2010-12-06T03:37:07 Executor initialized, id 1
> # 2010-12-06T03:37:07 Caching schema metadata for
> dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
> # 2010-12-06T03:37:07 Query: UPDATE `CC` SET `col_bigint_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 5 /*Generated by THREAD_ID 2*/ failed: 1366 Incorrect integer value:
> 'q' for column 'col_bigint_key' at row %d. Further errors of this kind will
> be suppressed.
> # 2010-12-06T03:37:07 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.
> # 2010-12-06T03:37:07 Started periodic reporting process...
> # 2010-12-06T03:37:07 Query:  DELETE FROM `CC` WHERE `col_char_10_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 /*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.
> # 2010-12-06T03:37:07 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.
> # 2010-12-06T03:37:08 Query:  UPDATE `D` SET `col_bigint` = 'a' WHERE
> `col_bigint` BETWEEN 1 AND 7 ORDER BY
> `col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk`
> LIMIT 7 /*Generated by THREAD_ID 1*/  failed: 1366 Incorrect integer value:
> 'a' for column 'col_bigint' at row %d. Further errors of this kind will be
> suppressed.
> # 2010-12-06T03:37:08 Query:  UPDATE `C` SET `col_bigint` = 'l' WHERE
> `col_text_not_null` < '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 6 /*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.
> # 2010-12-06T03:37:08 Query:  UPDATE `D` SET `col_int` = 'j' WHERE
> `col_bigint` >= 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 6 /*Generated by THREAD_ID 1*/  failed: 1366 Incorrect integer value:
> 'j' for column 'col_int' at row %d. Further errors of this kind will be
> suppressed.
> # 2010-12-06T03:37:09 Query:  UPDATE `B` SET `col_int_not_null` = 0 WHERE
> `col_enum_not_null_key` = ( SELECT `col_char_10_key` FROM `B` WHERE `pk` =
> 196 ) 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.
> # 2010-12-06T03:37:09 Query:  INSERT INTO `DD` ( `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_key` = 'j' 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 /*Generated by THREAD_ID 1*/  failed: 1292 Truncated incorrect
> DOUBLE value: 'j'. Further errors of this kind will be suppressed.
> # 2010-12-06T03:37:09 Query:  UPDATE `CC` SET `col_int_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 5 /*Generated by THREAD_ID 1*/  failed: 1366 Incorrect integer value:
> 'g' for column 'col_int_key' at row %d. Further errors of this kind will be
> suppressed.
> # 2010-12-06T03:37:09 Query:  UPDATE `DD` SET `col_int_key` = 4009164800
> WHERE `col_int_not_null_key` <= 7 ORDER BY
> `col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk`
> LIMIT 7 /*Generated by THREAD_ID 2*/  failed: 1264 Out of range value for
> column 'col_int_key' at row 1
> # 2010-12-06T03:37:10 Query:  UPDATE `DD` SET `col_bigint` = 6 WHERE
> `col_enum_key` = ( SELECT `col_int_not_null_key` FROM `CC` WHERE `pk` = 63 )
> 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: 1691 Received an invalid enum
> value '%d'.. Further errors of this kind will be suppressed.
> # 2010-12-06T03:37:10 Query:  UPDATE `D` SET `col_int` = 25 WHERE
> `col_bigint_key` < 7 ORDER BY
> `col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk`
> LIMIT 8 /*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.
> # 2010-12-06T03:37:10 Query:  UPDATE `BB` SET `col_bigint_key` = 'k' WHERE
> `col_char_1024_not_null` < '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 5 /*Generated by THREAD_ID 1*/  failed: 1366 Incorrect integer value:
> 'k' for column 'col_bigint_key' at row %d. Further errors of this kind will
> be suppressed.
> # 2010-12-06T03:37:11 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 `C` WHERE `col_int_not_null_key` < 'i' 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 /*Generated by THREAD_ID 1*/  failed: 1366 Incorrect integer value:
> 'i' for column 'col_int_not_null_key' at row %d. Further errors of this kind
> will be suppressed.
> # 2010-12-06T03:37:14 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` > '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 50 /*Generated by THREAD_ID 1*/ failed: 1292 Truncated incorrect
> DOUBLE value: 'l'. Further errors of this kind will be suppressed.
> # 2010-12-06T03:37:14 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 `D` WHERE `col_int_not_null_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 50 /*Generated by THREAD_ID 1*/  failed: 1366 Incorrect integer value:
> 'g' for column 'col_int_not_null_key' at row %d. Further errors of this kind
> will be suppressed.
> # 2010-12-06T03:37:15 Query:  UPDATE `CC` SET `col_bigint_key` = 'c' WHERE
> `col_bigint` < 7 ORDER BY
> `col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk`
> LIMIT 7 /*Generated by THREAD_ID 1*/  failed: 1366 Incorrect integer value:
> 'c' for column 'col_bigint_key' at row %d. Further errors of this kind will
> be suppressed.
> # 2010-12-06T03:37:17 Query:  UPDATE `CC` SET `col_int_not_null_key` =
> 2425225216  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: 1264 Out of range value for
> column 'col_int_not_null_key' at row 1
> # 2010-12-06T03:37:17 Query:  UPDATE `DD` SET `col_bigint_key` = 'v' WHERE
> `col_bigint_not_null_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 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.
> # 2010-12-06T03:37:19 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 `A` WHERE `col_enum_key` = ( SELECT
> `col_char_10_key` FROM `C` WHERE `pk` = 5 ) ORDER BY
> `col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk`
> LIMIT 25 /*Generated by THREAD_ID 2*/  failed: 1691 Received an invalid enum
> value 'WSWNP'.. Further errors of this kind will be suppressed.
> # 2010-12-06T03:37: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 `BB` WHERE `col_int_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 25 /*Generated by THREAD_ID 1*/  failed: 1366 Incorrect integer value:
> 'a' for column 'col_int_key' at row %d. Further errors of this kind will be
> suppressed.
> # 2010-12-06T03:37:24 Query: UPDATE `AA` SET `col_int` = 'u' 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 8 /*Generated by THREAD_ID 2*/ failed: 1366 Incorrect integer value:
> 'u' for column 'col_int' at row %d. Further errors of this kind will be
> suppressed.
> # 2010-12-06T03:37:28 Child process completed successfully.
> # 2010-12-06T03:37:30 Child process completed successfully.
> # 2010-12-06T03:37:31 Killing periodic reporting process with pid 2509...
> # 2010-12-06T03:37:31 Kill GenTest::ErrorFilter(2508)
> # 2010-12-06T03:37:31
> dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
> # 2010-12-06T03:37:31 transaction_log output file:
>  /tmp//translog_2501_.sql
> # 2010-12-06T03:37:31 <
> 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_2501_.sql
> # 2010-12-06T03:37:31 Replicating from transaction_log output...
> # 2010-12-06T03:37:31 <
> 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_2501_.sql
> # 2010-12-06T03:37:38 Validating replication via dumpfile compare...
> # 2010-12-06T03:37:38 /tmp//translog_rpl_dump_2501_9306.sql
> # 2010-12-06T03:37:38 <
> http://hudson.drizzle.org/job/drizzle-staging-randgen-transaction-log/ws/client/drizzledump>
> --compact --skip-extended-insert --host=127.0.0.1 --port=9306 --user=root
> test >/tmp//translog_rpl_dump_2501_9306.sql
> Error: Data for column col_bigint_not_null is greater than max BIGINT,
> cannot migrate automatically
> # 2010-12-06T03:37:38 Test completed with failure status
> STATUS_UNKNOWN_ERROR (2)
> Mon Dec  6 03:37:38 2010 INFO: Pinging Drizzled server on port 9306
> Mon Dec  6 03:37:38 2010 INFO: Stopping Drizzled server on port 9306
> Mon Dec  6 03:37:41 2010 INFO: Clearing Drizzled server on port 9306
> Mon Dec  6 03:37:41 2010 INFO: Starting Drizzled server on port 9306
> Mon Dec  6 03:37:41 2010 INFO: PWD:  /home/hudson/repos/randgen
> Mon Dec  6 03:37:42 2010 INFO: Dropping any test database previously setup.
> Mon Dec  6 03:37:43 2010 INFO: Creating test database.
> Mon Dec  6 03:37:43 2010 INFO: Pinging Drizzled server on port 9307
> Mon Dec  6 03:37:43 2010 INFO: Stopping Drizzled server on port 9307
> Mon Dec  6 03:37:46 2010 INFO: Clearing Drizzled server on port 9307
> Mon Dec  6 03:37:46 2010 INFO: Starting Drizzled server on port 9307
> Mon Dec  6 03:37:46 2010 INFO: PWD:  /home/hudson/repos/randgen
> Mon Dec  6 03:37:47 2010 INFO: Dropping any test database previously setup.
> Mon Dec  6 03:37:47 2010 INFO: Creating test database.
> Mon Dec  6 03:37:47 2010 INFO: Stopping Drizzled server on port 9306
> Mon Dec  6 03:37:47 2010 INFO: Stopping Drizzled server on port 9307
> Mon Dec  6 03:37:47 2010 INFO: 1 tests passed
> Mon Dec  6 03:37:47 2010 INFO: 6 tests failed
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~drizzle-builds<https://launchpad.net/%7Edrizzle-builds>
> Post to     : drizzle-builds@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~drizzle-builds<https://launchpad.net/%7Edrizzle-builds>
> More help   : https://help.launchpad.net/ListHelp
>