drizzle-merge team mailing list archive

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

To: Andrew Hutchings <andrew@xxxxxxxxxxxxxxx>, Patrick Crews <gleebix@xxxxxxxxx>
From: Lee Bieber <kalebral@xxxxxxxxx>
Date: Mon, 6 Dec 2010 15:43:49 -0500
Cc: drizzle-merge@xxxxxxxxxxxxxxxxxxx
In-reply-to: <297180150.151291666861388.JavaMail.hudson@hudson>
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
>
Follow ups

Re: [Drizzle-builds] Build failed in Hudson: drizzle-staging-randgen-transaction-log #64
From: Patrick Crews, 2010-12-06