← Back to team overview

drizzle-merge team mailing list archive

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

 

Still looks like we are hitting the 'out of range value' error (col_int +
col_bigint were what I saw).
This shouldn't be happening though as we aren't using any unsigned columns
for these tests.

Of course, we also shouldn't be hitting this as we're drizzledumping *from*
drizzle in these tests : (

Please let me know if I can do anything to help getting this sorted.

Patrick

On Mon, Dec 6, 2010 at 3:43 PM, Lee Bieber <kalebral@xxxxxxxxx> wrote:

> Hi Andrew,
> Better results this time, but still seeing some failures.
>
> -Lee
>
>
>
> On Mon, Dec 6, 2010 at 3:21 PM, <kalebral@xxxxxxxxx> wrote:
>
>> See <
>> http://hudson.drizzle.org/job/drizzle-staging-randgen-transaction-log/64/
>> >
>>
>> ------------------------------------------
>> [...truncated 70 lines...]
>> Mon Dec  6 20:18:02 2010 INFO: Clearing Drizzled server on port 9307
>> Mon Dec  6 20:18:02 2010 INFO: Starting Drizzled server on port 9307
>> Mon Dec  6 20:18:02 2010 INFO: PWD:  /home/hudson/repos/randgen
>> Mon Dec  6 20:18:03 2010 INFO: Dropping any test database previously
>> setup.
>> Mon Dec  6 20:18:03 2010 INFO: Creating test database.
>> Mon Dec  6 20:18:03 2010 INFO: Running : ordering 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_ordering.zz
>> --grammar=conf/drizzle/translog_ordering.yy --Reporter=DrizzleTransactionLog
>> --threads=5  --queries=500
>> Mon Dec  6 20:19:03 2010 INFO: ordering Passed
>> Mon Dec  6 20:19:03 2010 INFO: Pinging Drizzled server on port 9306
>> Mon Dec  6 20:19:03 2010 INFO: Stopping Drizzled server on port 9306
>> Mon Dec  6 20:19:06 2010 INFO: Clearing Drizzled server on port 9306
>> Mon Dec  6 20:19:06 2010 INFO: Starting Drizzled server on port 9306
>> Mon Dec  6 20:19:06 2010 INFO: PWD:  /home/hudson/repos/randgen
>> Mon Dec  6 20:19:07 2010 INFO: Dropping any test database previously
>> setup.
>> Mon Dec  6 20:19:07 2010 INFO: Creating test database.
>> Mon Dec  6 20:19:07 2010 INFO: Pinging Drizzled server on port 9307
>> Mon Dec  6 20:19:07 2010 INFO: Stopping Drizzled server on port 9307
>> Mon Dec  6 20:19:10 2010 INFO: Clearing Drizzled server on port 9307
>> Mon Dec  6 20:19:10 2010 INFO: Starting Drizzled server on port 9307
>> Mon Dec  6 20:19:10 2010 INFO: PWD:  /home/hudson/repos/randgen
>> Mon Dec  6 20:19:12 2010 INFO: Dropping any test database previously
>> setup.
>> Mon Dec  6 20:19:12 2010 INFO: Creating test database.
>> Mon Dec  6 20:19:12 2010 INFO: Running : multi_thread2_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_concurrent2.yy
>> --Reporter=DrizzleTransactionLog  --queries=100 --seed=time
>> Mon Dec  6 20:19:24 2010 INFO: multi_thread2_mix FAILED
>> # 2010-12-06T20:19:12 Starting
>> # 2010-12-06T20:19:12  ./gentest.pl \
>> # 2010-12-06T20:19:12
>>  --dsn=dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
>> \
>> # 2010-12-06T20:19:12  --threads=5 \
>> # 2010-12-06T20:19:12  --queries=500 \
>> # 2010-12-06T20:19:12  --engine=Innodb \
>> # 2010-12-06T20:19:12  --gendata=conf/drizzle/translog_drizzle.zz \
>> # 2010-12-06T20:19:12  --grammar=conf/drizzle/translog_concurrent2.yy \
>> # 2010-12-06T20:19:12  --Reporter=DrizzleTransactionLog \
>> # 2010-12-06T20:19:12  --queries=100 \
>> # 2010-12-06T20:19:12  --seed=time
>> # 2010-12-06T20:19:12 Converting --seed=time to --seed=1291666752
>> # 2010-12-06T20:19:12 -------------------------------
>> # 2010-12-06T20:19:12 Configuration
>> # 2010-12-06T20:19:12   dsn =>
>> ['dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test']
>> # 2010-12-06T20:19:12   duration => 3600
>> # 2010-12-06T20:19:12   engine => Innodb
>> # 2010-12-06T20:19:12   gendata => conf/drizzle/translog_drizzle.zz
>> # 2010-12-06T20:19:12   grammar => conf/drizzle/translog_concurrent2.yy
>> # 2010-12-06T20:19:12   queries => 100
>> # 2010-12-06T20:19:12   reporters => ['DrizzleTransactionLog']
>> # 2010-12-06T20:19:12   seed => time
>> # 2010-12-06T20:19:12   threads => 5
>> # 2010-12-06T20:19:12   validators => ['']
>> # 2010-12-06T20:19:12 Default schema: test
>> # 2010-12-06T20:19:12 Executor initialized, id GenTest::Executor::Drizzle
>> 2010.12.1977 ()
>> # 2010-12-06T20:19:12 # Creating Drizzle table: test.A; engine: innodb;
>> rows: 10 .
>> # 2010-12-06T20:19:12 # Creating Drizzle table: test.B; engine: innodb;
>> rows: 10 .
>> # 2010-12-06T20:19:12 # Creating Drizzle table: test.C; engine: innodb;
>> rows: 50 .
>> # 2010-12-06T20:19:12 # Creating Drizzle table: test.D; engine: innodb;
>> rows: 50 .
>> # 2010-12-06T20:19:13 # Creating Drizzle table: test.AA; engine: innodb;
>> rows: 75 .
>> # 2010-12-06T20:19:13 # Creating Drizzle table: test.BB; engine: innodb;
>> rows: 75 .
>> # 2010-12-06T20:19:14 # Creating Drizzle table: test.CC; engine: innodb;
>> rows: 100 .
>> # 2010-12-06T20:19:14 # Creating Drizzle table: test.DD; engine: innodb;
>> rows: 100 .
>> # 2010-12-06T20:19:15 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-06T20:19:15 Validators: ErrorMessageCorruption
>> # 2010-12-06T20:19:15 Starting 5 processes, 100 queries each, duration
>> 3600 seconds.
>> # 2010-12-06T20:19:15 GenTest::ErrorFilter(15817) started
>> # 2010-12-06T20:19:15 Default schema: test
>> # 2010-12-06T20:19:15 Executor initialized, id 1
>> # 2010-12-06T20:19:15 Caching schema metadata for
>> dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
>> # 2010-12-06T20:19:15 Default schema: test
>> # 2010-12-06T20:19:15 Executor initialized, id 1
>> # 2010-12-06T20:19:15 Caching schema metadata for
>> dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
>> # 2010-12-06T20:19:15 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 `B` WHERE `col_int_not_null` IN ('t', 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 10  failed: 1292 Truncated incorrect DOUBLE value: 't'. Further errors
>> of this kind will be suppressed.
>> # 2010-12-06T20:19:15 Default schema: test
>> # 2010-12-06T20:19:15 Executor initialized, id 1
>> # 2010-12-06T20:19:15 Caching schema metadata for
>> dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
>> # 2010-12-06T20:19:15 Query: ROLLBACK TO SAVEPOINT A failed: 1305
>> SAVEPOINT %s does not exist. Further errors of this kind will be suppressed.
>> # 2010-12-06T20:19:15 Default schema: test
>> # 2010-12-06T20:19:15 Executor initialized, id 1
>> # 2010-12-06T20:19:15 Caching schema metadata for
>> dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
>> # 2010-12-06T20:19:15 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 `BB` WHERE `col_int_not_null_key` < 'p' 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: 'p' for column
>> 'col_int_not_null_key' at row %d. Further errors of this kind will be
>> suppressed.
>> # 2010-12-06T20:19:15 Query:  UPDATE `B` SET `col_int_key` = 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 5  failed: 1213 Deadlock found when trying to get lock; try restarting
>> transaction. Further errors of this kind will be suppressed.
>> # 2010-12-06T20:19:15 Default schema: test
>> # 2010-12-06T20:19:15 Executor initialized, id 1
>> # 2010-12-06T20:19:15 Caching schema metadata for
>> dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
>> # 2010-12-06T20:19:15 Query:  UPDATE `CC` SET `col_int` = 3215785984 WHERE
>> `col_char_10_not_null_key` < 'JVUOM' 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: 1264 Out of range value for column 'col_int' at row 1
>> # 2010-12-06T20:19:16 Started periodic reporting process...
>> # 2010-12-06T20:19:16 Query:  DELETE FROM `CC` WHERE `col_bigint` IN (1,
>> 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 3  failed: 1213 Deadlock found when trying to get lock; try restarting
>> transaction. Further errors of this kind will be suppressed.
>> # 2010-12-06T20:19:16 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 `C` WHERE `col_bigint_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 100  failed: 1366 Incorrect integer value: 'x' for column
>> 'col_bigint_key' at row %d. Further errors of this kind will be suppressed.
>> # 2010-12-06T20:19:16 Query:  DELETE FROM `BB` WHERE
>> `col_bigint_not_null_key` IN ( SELECT `col_bigint_key` FROM `BB` WHERE `pk`
>> = 22 ) 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.
>> # 2010-12-06T20:19:16 Query: SELECT ( SELECT `col_enum_key` FROM `B` WHERE
>> `pk` = 3122069504 ) FROM `B` AS X WHERE X . `col_enum_key` IN ( 1 , 94 ,
>> 2179203072 , 3887005696 , 191 ) LIMIT 6 LOCK IN SHARE MODE failed: 1691
>> Received an invalid enum value '%d'.. Further errors of this kind will be
>> suppressed.
>> # 2010-12-06T20:19:16 Query:  UPDATE `DD` SET `col_bigint_key` = 0 WHERE
>> `col_enum_not_null_key` IN ( SELECT `col_char_10_key` FROM `B` WHERE `pk` =
>> 189 ) 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: 1213 Deadlock found when trying to get lock; try restarting
>> transaction. Further errors of this kind will be suppressed.
>> # 2010-12-06T20:19:16 Query:  DELETE FROM `B`  ORDER BY
>> `col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk`
>> LIMIT 4  failed: 1213 Deadlock found when trying to get lock; try restarting
>> transaction. Further errors of this kind will be suppressed.
>> # 2010-12-06T20:19:16 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 `A` WHERE `col_int` IN ('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 10 failed: 1292 Truncated incorrect DOUBLE value: 'f'. Further errors
>> of this kind will be suppressed.
>> # 2010-12-06T20:19:16 Query:  ROLLBACK TO SAVEPOINT A  failed: 1305
>> SAVEPOINT %s does not exist. Further errors of this kind will be suppressed.
>> # 2010-12-06T20:19:16 Query:  UPDATE `BB` SET `col_int_not_null_key` = 'q'
>> WHERE `pk` BETWEEN 8 AND 10 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: 'q' for column
>> 'col_int_not_null_key' at row %d. Further errors of this kind will be
>> suppressed.
>> # 2010-12-06T20:19:16 Query:  SELECT X . `col_int_not_null` FROM `CC` AS X
>> LEFT JOIN `D` AS Y USING ( `col_text_not_null_key` ) WHERE X .
>> `col_enum_not_null_key` IN ( 3 , 7 , 79 , 145 , 1177681920 ) LIMIT 5
>> failed: 1691 Received an invalid enum value '%d'.. Further errors of this
>> kind will be suppressed.
>> # 2010-12-06T20:19:17 Query:  SELECT X . `pk` FROM `B` AS X LEFT JOIN `AA`
>> AS Y USING ( `col_char_1024_not_null_key` ) WHERE X .
>> `col_enum_not_null_key` IN ( 23 , 1235484672 , 4211539968 , 3732865024 ,
>> 1780350976 ) LIMIT 8 FOR UPDATE  failed: 1691 Received an invalid enum value
>> '%d'.. Further errors of this kind will be suppressed.
>> # 2010-12-06T20:19:17 Query:  UPDATE `C` SET `col_int_not_null` = 7 WHERE
>> `col_char_10_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 8  failed: 1093 You can't specify target table '%s' for update in FROM
>> clause. Further errors of this kind will be suppressed.
>> # 2010-12-06T20:19:17 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_key` = 'r' ORDER BY
>> `col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk`
>> LIMIT 10  failed: 1292 Truncated incorrect DOUBLE value: 'r'. Further errors
>> of this kind will be suppressed.
>> # 2010-12-06T20:19:17 Query:  ROLLBACK TO SAVEPOINT A  failed: 1305
>> SAVEPOINT %s does not exist. Further errors of this kind will be suppressed.
>> # 2010-12-06T20:19:17 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_key` = ( SELECT
>> `col_char_10_not_null_key` FROM `AA` 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 failed: 1366 Incorrect integer value: 'PCDXB' for column
>> 'col_bigint_key' at row %d. Further errors of this kind will be suppressed.
>> # 2010-12-06T20:19:17 Query:  ROLLBACK TO SAVEPOINT A  failed: 1305
>> SAVEPOINT %s does not exist. Further errors of this kind will be suppressed.
>> # 2010-12-06T20:19:17 Query:  UPDATE `B` SET `col_int_not_null_key` = 4
>> WHERE `col_char_1024_key` <= 'w' 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-06T20:19:18 Query: DELETE FROM `CC` WHERE
>> `col_bigint_not_null_key` IN ( SELECT `col_char_10_not_null_key` FROM `CC`
>> WHERE `pk` = 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 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-06T20:19:18 Child process completed successfully.
>> # 2010-12-06T20:19:18 Query:  ROLLBACK TO SAVEPOINT A  failed: 1305
>> SAVEPOINT %s does not exist. Further errors of this kind will be suppressed.
>> # 2010-12-06T20:19:18 Query:  UPDATE `BB` SET `col_int_not_null` = 50
>> WHERE `col_text_key` IN ( SELECT `col_char_10_key` FROM `BB` WHERE `pk` = 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 8  failed: 1093 You can't specify target table '%s' for update in FROM
>> clause. Further errors of this kind will be suppressed.
>> # 2010-12-06T20:19:19 Child process completed successfully.
>> # 2010-12-06T20:19:19 Query: UPDATE `DD` SET `col_bigint_key` = 'z' WHERE
>> `col_int_key` BETWEEN 5 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 6 failed: 1366 Incorrect integer value: 'z' for column
>> 'col_bigint_key' at row %d. Further errors of this kind will be suppressed.
>> # 2010-12-06T20:19:19 Child process completed successfully.
>> # 2010-12-06T20:19:19 Child process completed successfully.
>> # 2010-12-06T20:19:20 Child process completed successfully.
>> # 2010-12-06T20:19:21 Killing periodic reporting process with pid 15818...
>> # 2010-12-06T20:19:21 Kill GenTest::ErrorFilter(15817)
>> # 2010-12-06T20:19:21
>> dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
>> # 2010-12-06T20:19:21 transaction_log output file:
>>  /tmp//translog_15810_.sql
>> # 2010-12-06T20:19:21 <
>> 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_15810_.sql
>> # 2010-12-06T20:19:21 Replicating from transaction_log output...
>> # 2010-12-06T20:19:21 <
>> 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_15810_.sql
>> # 2010-12-06T20:19:24 Validating replication via dumpfile compare...
>> # 2010-12-06T20:19:24 /tmp//translog_rpl_dump_15810_9306.sql
>> # 2010-12-06T20:19:24 <
>> 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_15810_9306.sql
>> Error: Data for column col_bigint is greater than max BIGINT, cannot
>> migrate automatically
>> # 2010-12-06T20:19:24 Test completed with failure status
>> STATUS_UNKNOWN_ERROR (2)
>> Mon Dec  6 20:19:24 2010 INFO: Pinging Drizzled server on port 9306
>> Mon Dec  6 20:19:25 2010 INFO: Stopping Drizzled server on port 9306
>> Mon Dec  6 20:19:28 2010 INFO: Clearing Drizzled server on port 9306
>> Mon Dec  6 20:19:28 2010 INFO: Starting Drizzled server on port 9306
>> Mon Dec  6 20:19:28 2010 INFO: PWD:  /home/hudson/repos/randgen
>> Mon Dec  6 20:19:29 2010 INFO: Dropping any test database previously
>> setup.
>> Mon Dec  6 20:19:29 2010 INFO: Creating test database.
>> Mon Dec  6 20:19:29 2010 INFO: Pinging Drizzled server on port 9307
>> Mon Dec  6 20:19:29 2010 INFO: Stopping Drizzled server on port 9307
>> Mon Dec  6 20:19:32 2010 INFO: Clearing Drizzled server on port 9307
>> Mon Dec  6 20:19:32 2010 INFO: Starting Drizzled server on port 9307
>> Mon Dec  6 20:19:32 2010 INFO: PWD:  /home/hudson/repos/randgen
>> Mon Dec  6 20:19:33 2010 INFO: Dropping any test database previously
>> setup.
>> Mon Dec  6 20:19:33 2010 INFO: Creating test database.
>> Mon Dec  6 20:19:34 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 20:19:45 2010 INFO: single_thread3 Passed
>> Mon Dec  6 20:19:45 2010 INFO: Pinging Drizzled server on port 9306
>> Mon Dec  6 20:19:45 2010 INFO: Stopping Drizzled server on port 9306
>> Mon Dec  6 20:19:48 2010 INFO: Clearing Drizzled server on port 9306
>> Mon Dec  6 20:19:48 2010 INFO: Starting Drizzled server on port 9306
>> Mon Dec  6 20:19:48 2010 INFO: PWD:  /home/hudson/repos/randgen
>> Mon Dec  6 20:19:49 2010 INFO: Dropping any test database previously
>> setup.
>> Mon Dec  6 20:19:49 2010 INFO: Creating test database.
>> Mon Dec  6 20:19:50 2010 INFO: Pinging Drizzled server on port 9307
>> Mon Dec  6 20:19:50 2010 INFO: Stopping Drizzled server on port 9307
>> Mon Dec  6 20:19:53 2010 INFO: Clearing Drizzled server on port 9307
>> Mon Dec  6 20:19:53 2010 INFO: Starting Drizzled server on port 9307
>> Mon Dec  6 20:19:53 2010 INFO: PWD:  /home/hudson/repos/randgen
>> Mon Dec  6 20:19:54 2010 INFO: Dropping any test database previously
>> setup.
>> Mon Dec  6 20:19:54 2010 INFO: Creating test database.
>> Mon Dec  6 20:19:54 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 20:20:28 2010 INFO: multi_thread3_mix FAILED
>> # 2010-12-06T20:19:54 Starting
>> # 2010-12-06T20:19:54  ./gentest.pl \
>> # 2010-12-06T20:19:54
>>  --dsn=dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
>> \
>> # 2010-12-06T20:19:54  --threads=5 \
>> # 2010-12-06T20:19:54  --queries=500 \
>> # 2010-12-06T20:19:54  --engine=Innodb \
>> # 2010-12-06T20:19:54  --gendata=conf/drizzle/translog_drizzle.zz \
>> # 2010-12-06T20:19:54  --grammar=conf/drizzle/translog_concurrent3.yy \
>> # 2010-12-06T20:19:54  --Reporter=DrizzleTransactionLog \
>> # 2010-12-06T20:19:54  --queries=250 \
>> # 2010-12-06T20:19:54  --seed=time \
>> # 2010-12-06T20:19:54  --threads=2
>> # 2010-12-06T20:19:54 Converting --seed=time to --seed=1291666794
>> # 2010-12-06T20:19:54 -------------------------------
>> # 2010-12-06T20:19:54 Configuration
>> # 2010-12-06T20:19:54   dsn =>
>> ['dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test']
>> # 2010-12-06T20:19:54   duration => 3600
>> # 2010-12-06T20:19:54   engine => Innodb
>> # 2010-12-06T20:19:54   gendata => conf/drizzle/translog_drizzle.zz
>> # 2010-12-06T20:19:54   grammar => conf/drizzle/translog_concurrent3.yy
>> # 2010-12-06T20:19:54   queries => 250
>> # 2010-12-06T20:19:54   reporters => ['DrizzleTransactionLog']
>> # 2010-12-06T20:19:54   seed => time
>> # 2010-12-06T20:19:54   threads => 2
>> # 2010-12-06T20:19:54   validators => ['']
>> # 2010-12-06T20:19:54 Default schema: test
>> # 2010-12-06T20:19:54 Executor initialized, id GenTest::Executor::Drizzle
>> 2010.12.1977 ()
>> # 2010-12-06T20:19:54 # Creating Drizzle table: test.A; engine: innodb;
>> rows: 10 .
>> # 2010-12-06T20:19:54 # Creating Drizzle table: test.B; engine: innodb;
>> rows: 10 .
>> # 2010-12-06T20:19:55 # Creating Drizzle table: test.C; engine: innodb;
>> rows: 50 .
>> # 2010-12-06T20:19:55 # Creating Drizzle table: test.D; engine: innodb;
>> rows: 50 .
>> # 2010-12-06T20:19:55 # Creating Drizzle table: test.AA; engine: innodb;
>> rows: 75 .
>> # 2010-12-06T20:19:56 # Creating Drizzle table: test.BB; engine: innodb;
>> rows: 75 .
>> # 2010-12-06T20:19:56 # Creating Drizzle table: test.CC; engine: innodb;
>> rows: 100 .
>> # 2010-12-06T20:19:57 # Creating Drizzle table: test.DD; engine: innodb;
>> rows: 100 .
>> # 2010-12-06T20:19:57 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-06T20:19:57 Validators: ErrorMessageCorruption
>> # 2010-12-06T20:19:57 Starting 2 processes, 250 queries each, duration
>> 3600 seconds.
>> # 2010-12-06T20:19:57 GenTest::ErrorFilter(16680) started
>> # 2010-12-06T20:19:57 Default schema: test
>> # 2010-12-06T20:19:57 Executor initialized, id 1
>> # 2010-12-06T20:19:57 Caching schema metadata for
>> dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
>> # 2010-12-06T20:19:57 Default schema: test
>> # 2010-12-06T20:19:57 Executor initialized, id 1
>> # 2010-12-06T20:19:57 Caching schema metadata for
>> dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
>> # 2010-12-06T20:19:58 Started periodic reporting process...
>> # 2010-12-06T20:19:58 Query: DELETE FROM `CC` WHERE `col_bigint` < 8 ORDER
>> BY
>> `col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk`
>> LIMIT 2 /*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-06T20:19:58 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-06T20:19:58 Query:  UPDATE `D` SET `col_bigint` = 4 WHERE
>> `col_text_key` = ( SELECT `col_char_1024_key` FROM `D` WHERE `pk` = 6 )
>> ORDER BY
>> `col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk`
>> LIMIT 6 /*Generated by THREAD_ID 1*/  failed: 1093 You can't specify target
>> table '%s' for update in FROM clause. Further errors of this kind will be
>> suppressed.
>> # 2010-12-06T20:19:59 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_not_null_key` = ( SELECT
>> `col_char_1024_not_null_key` FROM `BB` WHERE `pk` = 25 ) 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: 1691 Received an invalid enum
>> value 'PETSJ'.. Further errors of this kind will be suppressed.
>> # 2010-12-06T20:19:59 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-06T20:19:59 Query:  UPDATE `D` SET `col_int_not_null_key` =
>> 3191734272 WHERE `col_int` >= 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 /*Generated by THREAD_ID 2*/  failed: 1264 Out of range value for
>> column 'col_int_not_null_key' at row 1
>> # 2010-12-06T20:19:59 Query:  UPDATE `B` SET `col_bigint_key` = 86 WHERE
>> `col_char_10` <= '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: 1213 Deadlock found when
>> trying to get lock; try restarting transaction. Further errors of this kind
>> will be suppressed.
>> # 2010-12-06T20:20:03 Query:  UPDATE `B` SET `col_bigint_key` = 'n' WHERE
>> `pk` < 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 5 /*Generated by THREAD_ID 2*/  failed: 1366 Incorrect integer value:
>> 'n' for column 'col_bigint_key' at row %d. Further errors of this kind will
>> be suppressed.
>> # 2010-12-06T20:20:04 Query:  UPDATE `D` SET `col_int` = '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:
>> 'u' for column 'col_int' at row %d. Further errors of this kind will be
>> suppressed.
>> # 2010-12-06T20:20:05 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 `AA` WHERE `col_int_key` >= 2580873216 ORDER BY
>> `col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk`
>> LIMIT 50 /*Generated by THREAD_ID 2*/  failed: 1264 Out of range value for
>> column 'col_int_key' at row 1
>> # 2010-12-06T20:20:05 Query:  UPDATE `AA` SET `col_int_not_null` = 'r'
>>  ORDER BY
>> `col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk`
>> LIMIT 5 /*Generated by THREAD_ID 1*/  failed: 1366 Incorrect integer value:
>> 'r' for column 'col_int_not_null' at row %d. Further errors of this kind
>> will be suppressed.
>> # 2010-12-06T20:20:05 Query:  UPDATE `C` SET `col_int_not_null` =
>> 3068461056 WHERE `col_int_not_null_key` >= 4 ORDER BY
>> `col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk`
>> LIMIT 7 /*Generated by THREAD_ID 1*/  failed: 1264 Out of range value for
>> column 'col_int_not_null' at row 1
>> # 2010-12-06T20:20:09 Query:  UPDATE `BB` SET `col_int_not_null` = 6 WHERE
>> `col_char_10_key` IN ( SELECT `col_enum_key` FROM `BB` WHERE `pk` = '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 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.
>> # 2010-12-06T20:20:11 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 `C` WHERE `col_int_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 /*Generated by THREAD_ID 1*/  failed: 1366 Incorrect integer value:
>> 'c' for column 'col_int_key' at row %d. Further errors of this kind will be
>> suppressed.
>> # 2010-12-06T20:20:12 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 `DD` WHERE `col_int_key` < 2467954688 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: 1264 Out of range value for
>> column 'col_int_key' at row 1
>> # 2010-12-06T20:20:13 Child process completed successfully.
>> # 2010-12-06T20:20:20 Child process completed successfully.
>> # 2010-12-06T20:20:21 Killing periodic reporting process with pid 16681...
>> # 2010-12-06T20:20:21 Kill GenTest::ErrorFilter(16680)
>> # 2010-12-06T20:20:21
>> dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
>> # 2010-12-06T20:20:21 transaction_log output file:
>>  /tmp//translog_16673_.sql
>> # 2010-12-06T20:20:21 <
>> 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_16673_.sql
>> # 2010-12-06T20:20:22 Replicating from transaction_log output...
>> # 2010-12-06T20:20:22 <
>> 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_16673_.sql
>> # 2010-12-06T20:20:27 Validating replication via dumpfile compare...
>> # 2010-12-06T20:20:27 /tmp//translog_rpl_dump_16673_9306.sql
>> # 2010-12-06T20:20:27 <
>> 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_16673_9306.sql
>> Error: Data for column col_bigint is greater than max BIGINT, cannot
>> migrate automatically
>> # 2010-12-06T20:20:28 Test completed with failure status
>> STATUS_UNKNOWN_ERROR (2)
>> Mon Dec  6 20:20:28 2010 INFO: Pinging Drizzled server on port 9306
>> Mon Dec  6 20:20:28 2010 INFO: Stopping Drizzled server on port 9306
>> Mon Dec  6 20:20:31 2010 INFO: Clearing Drizzled server on port 9306
>> Mon Dec  6 20:20:31 2010 INFO: Starting Drizzled server on port 9306
>> Mon Dec  6 20:20:31 2010 INFO: PWD:  /home/hudson/repos/randgen
>> Mon Dec  6 20:20:33 2010 INFO: Dropping any test database previously
>> setup.
>> Mon Dec  6 20:20:33 2010 INFO: Creating test database.
>> Mon Dec  6 20:20:33 2010 INFO: Pinging Drizzled server on port 9307
>> Mon Dec  6 20:20:34 2010 INFO: Stopping Drizzled server on port 9307
>> Mon Dec  6 20:20:37 2010 INFO: Clearing Drizzled server on port 9307
>> Mon Dec  6 20:20:37 2010 INFO: Starting Drizzled server on port 9307
>> Mon Dec  6 20:20:37 2010 INFO: PWD:  /home/hudson/repos/randgen
>> Mon Dec  6 20:20:38 2010 INFO: Dropping any test database previously
>> setup.
>> Mon Dec  6 20:20:38 2010 INFO: Creating test database.
>> Mon Dec  6 20:20:38 2010 INFO: Stopping Drizzled server on port 9306
>> Mon Dec  6 20:20:38 2010 INFO: Stopping Drizzled server on port 9307
>> Mon Dec  6 20:20:38 2010 INFO: 5 tests passed
>> Mon Dec  6 20:20:38 2010 INFO: 2 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
>>
>
>

References