See
<http://hudson.drizzle.org/job/drizzle-staging-randgen-transaction-log/152/changes>
Changes:
[Brian Aker] Dead parser bits, plus reduce conflicts.
[Brian Aker] Rolling up session cleanup.
------------------------------------------
[...truncated 38 lines...]
Sun Jan 9 04:44:27 2011 INFO: Dropping any test database previously setup.
Sun Jan 9 04:44:27 2011 INFO: Creating test database.
Sun Jan 9 04:44:27 2011 INFO: Pinging Drizzled server on port 9307
Sun Jan 9 04:44:27 2011 INFO: Stopping Drizzled server on port 9307
Sun Jan 9 04:44:30 2011 INFO: Clearing Drizzled server on port 9307
Sun Jan 9 04:44:30 2011 INFO: Starting Drizzled server on port 9307
Sun Jan 9 04:44:30 2011 INFO: PWD: /home/hudson/repos/randgen
Sun Jan 9 04:44:36 2011 INFO: Dropping any test database previously setup.
Sun Jan 9 04:44:36 2011 INFO: Creating test database.
Sun Jan 9 04:44:36 2011 INFO: Running : multi_thread2 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
Sun Jan 9 04:45:47 2011 INFO: multi_thread2 Passed
Sun Jan 9 04:45:47 2011 INFO: Pinging Drizzled server on port 9306
Sun Jan 9 04:45:47 2011 INFO: Stopping Drizzled server on port 9306
Sun Jan 9 04:45:50 2011 INFO: Clearing Drizzled server on port 9306
Sun Jan 9 04:45:52 2011 INFO: Starting Drizzled server on port 9306
Sun Jan 9 04:45:52 2011 INFO: PWD: /home/hudson/repos/randgen
Sun Jan 9 04:46:09 2011 INFO: Dropping any test database previously setup.
Sun Jan 9 04:46:09 2011 INFO: Creating test database.
Sun Jan 9 04:46:10 2011 INFO: Pinging Drizzled server on port 9307
Sun Jan 9 04:46:10 2011 INFO: Stopping Drizzled server on port 9307
Sun Jan 9 04:46:13 2011 INFO: Clearing Drizzled server on port 9307
Sun Jan 9 04:46:13 2011 INFO: Starting Drizzled server on port 9307
Sun Jan 9 04:46:13 2011 INFO: PWD: /home/hudson/repos/randgen
Sun Jan 9 04:46:19 2011 INFO: Dropping any test database previously setup.
Sun Jan 9 04:46:19 2011 INFO: Creating test database.
Sun Jan 9 04:46:20 2011 INFO: Running : multi_thread1 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_concurrent1.yy --Reporter=DrizzleTransactionLog
--queries=100
Sun Jan 9 04:47:44 2011 INFO: multi_thread1 Passed
Sun Jan 9 04:47:44 2011 INFO: Pinging Drizzled server on port 9306
Sun Jan 9 04:47:44 2011 INFO: Stopping Drizzled server on port 9306
Sun Jan 9 04:47:48 2011 INFO: Clearing Drizzled server on port 9306
Sun Jan 9 04:47:48 2011 INFO: Starting Drizzled server on port 9306
Sun Jan 9 04:47:48 2011 INFO: PWD: /home/hudson/repos/randgen
Sun Jan 9 04:48:03 2011 INFO: Dropping any test database previously setup.
Sun Jan 9 04:48:03 2011 INFO: Creating test database.
Sun Jan 9 04:48:03 2011 INFO: Pinging Drizzled server on port 9307
Sun Jan 9 04:48:03 2011 INFO: Stopping Drizzled server on port 9307
Sun Jan 9 04:48:06 2011 INFO: Clearing Drizzled server on port 9307
Sun Jan 9 04:48:06 2011 INFO: Starting Drizzled server on port 9307
Sun Jan 9 04:48:06 2011 INFO: PWD: /home/hudson/repos/randgen
Sun Jan 9 04:48:12 2011 INFO: Dropping any test database previously setup.
Sun Jan 9 04:48:12 2011 INFO: Creating test database.
Sun Jan 9 04:48:12 2011 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
Sun Jan 9 04:51:28 2011 INFO: ordering Passed
Sun Jan 9 04:51:28 2011 INFO: Pinging Drizzled server on port 9306
Sun Jan 9 04:51:28 2011 INFO: Stopping Drizzled server on port 9306
Sun Jan 9 04:51:31 2011 INFO: Clearing Drizzled server on port 9306
Sun Jan 9 04:51:31 2011 INFO: Starting Drizzled server on port 9306
Sun Jan 9 04:51:31 2011 INFO: PWD: /home/hudson/repos/randgen
Sun Jan 9 04:51:39 2011 INFO: Dropping any test database previously setup.
Sun Jan 9 04:51:39 2011 INFO: Creating test database.
Sun Jan 9 04:51:40 2011 INFO: Pinging Drizzled server on port 9307
Sun Jan 9 04:51:40 2011 INFO: Stopping Drizzled server on port 9307
Sun Jan 9 04:51:43 2011 INFO: Clearing Drizzled server on port 9307
Sun Jan 9 04:51:43 2011 INFO: Starting Drizzled server on port 9307
Sun Jan 9 04:51:43 2011 INFO: PWD: /home/hudson/repos/randgen
Sun Jan 9 04:51:48 2011 INFO: Dropping any test database previously setup.
Sun Jan 9 04:51:48 2011 INFO: Creating test database.
Sun Jan 9 04:51:48 2011 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
Sun Jan 9 04:52:51 2011 INFO: multi_thread2_mix FAILED
# 2011-01-09T04:51:49 Starting
# 2011-01-09T04:51:49 ./gentest.pl \
# 2011-01-09T04:51:49
--dsn=dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test \
# 2011-01-09T04:51:49 --threads=5 \
# 2011-01-09T04:51:49 --queries=500 \
# 2011-01-09T04:51:49 --engine=Innodb \
# 2011-01-09T04:51:49 --gendata=conf/drizzle/translog_drizzle.zz \
# 2011-01-09T04:51:49 --grammar=conf/drizzle/translog_concurrent2.yy \
# 2011-01-09T04:51:49 --Reporter=DrizzleTransactionLog \
# 2011-01-09T04:51:49 --queries=100 \
# 2011-01-09T04:51:49 --seed=time
# 2011-01-09T04:51:49 Converting --seed=time to --seed=1294548709
# 2011-01-09T04:51:49 -------------------------------
# 2011-01-09T04:51:49 Configuration
# 2011-01-09T04:51:49 dsn =>
['dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test']
# 2011-01-09T04:51:49 duration => 3600
# 2011-01-09T04:51:49 engine => Innodb
# 2011-01-09T04:51:49 gendata => conf/drizzle/translog_drizzle.zz
# 2011-01-09T04:51:49 grammar => conf/drizzle/translog_concurrent2.yy
# 2011-01-09T04:51:49 queries => 100
# 2011-01-09T04:51:49 reporters => ['DrizzleTransactionLog']
# 2011-01-09T04:51:49 seed => time
# 2011-01-09T04:51:49 threads => 5
# 2011-01-09T04:51:49 validators => ['']
# 2011-01-09T04:51:49 Default schema: test
# 2011-01-09T04:51:49 Executor initialized, id GenTest::Executor::Drizzle
2011.01.2067 ()
# 2011-01-09T04:51:49 # Creating Drizzle table: test.A; engine: innodb; rows:
10 .
# 2011-01-09T04:51:49 # Creating Drizzle table: test.B; engine: innodb; rows:
10 .
# 2011-01-09T04:51:50 # Creating Drizzle table: test.C; engine: innodb; rows:
50 .
# 2011-01-09T04:51:50 # Creating Drizzle table: test.D; engine: innodb; rows:
50 .
# 2011-01-09T04:51:51 # Creating Drizzle table: test.AA; engine: innodb; rows:
75 .
# 2011-01-09T04:51:52 # Creating Drizzle table: test.BB; engine: innodb; rows:
75 .
# 2011-01-09T04:51:54 # Creating Drizzle table: test.CC; engine: innodb; rows:
100 .
# 2011-01-09T04:51:54 # Creating Drizzle table: test.DD; engine: innodb; rows:
100 .
# 2011-01-09T04:51:56 Reporters: DrizzleTransactionLog
DBD::drizzle::db selectrow_arrayref failed: You have an error in your SQL
syntax; check the manual that corresponds to your Drizzle server version for
the right syntax to use near 'SLAVE HOSTS' at line 1 at lib/GenTest/Reporter.pm
line 79.
DBD::drizzle::db selectall_arrayref failed: Table 'information_schema.plugins'
doesn't exist at lib/GenTest/Reporter.pm line 84.
# 2011-01-09T04:51:56 Validators: ErrorMessageCorruption
# 2011-01-09T04:51:56 Starting 5 processes, 100 queries each, duration 3600
seconds.
# 2011-01-09T04:51:56 GenTest::ErrorFilter(20508) started
# 2011-01-09T04:51:56 Default schema: test
# 2011-01-09T04:51:56 Executor initialized, id 1
# 2011-01-09T04:51:56 Caching schema metadata for
dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
# 2011-01-09T04:51:56 Default schema: test
# 2011-01-09T04:51:56 Executor initialized, id 1
# 2011-01-09T04:51:56 Caching schema metadata for
dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
# 2011-01-09T04:51:56 Default schema: test
# 2011-01-09T04:51:56 Executor initialized, id 1
# 2011-01-09T04:51:56 Caching schema metadata for
dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
# 2011-01-09T04:51:56 Query: ROLLBACK TO SAVEPOINT A failed: 1305 SAVEPOINT
%s does not exist. Further errors of this kind will be suppressed.
# 2011-01-09T04:51:56 Default schema: test
# 2011-01-09T04:51:56 Executor initialized, id 1
# 2011-01-09T04:51:56 Caching schema metadata for
dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
# 2011-01-09T04:51:56 Default schema: test
# 2011-01-09T04:51:56 Executor initialized, id 1
# 2011-01-09T04:51:56 Caching schema metadata for
dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
# 2011-01-09T04:51:57 Started periodic reporting process...
# 2011-01-09T04:51:57 Query: DELETE FROM `AA` WHERE `col_char_10_not_null_key`
= ( SELECT `col_char_1024_not_null_key` FROM `AA` WHERE `pk` = 186 ) ORDER BY
`col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk`
LIMIT 4 failed: 1093 You can't specify target table '%s' for update in FROM
clause. Further errors of this kind will be suppressed.
# 2011-01-09T04:51:57 Query: DELETE FROM `D` WHERE `col_char_10_not_null` IN
('m', 'n') ORDER BY
`col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk`
LIMIT 2 failed: 1213 Deadlock found when trying to get lock; try restarting
transaction. Further errors of this kind will be suppressed.
# 2011-01-09T04:51:57 Query: UPDATE `CC` SET `col_int_key` = 251 WHERE
`col_int_not_null_key` != 7 ORDER BY
`col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk`
LIMIT 5 failed: 1213 Deadlock found when trying to get lock; try restarting
transaction. Further errors of this kind will be suppressed.
# 2011-01-09T04:51:58 Query: ROLLBACK TO SAVEPOINT A failed: 1305 SAVEPOINT
%s does not exist. Further errors of this kind will be suppressed.
# 2011-01-09T04:51:59 Query: ROLLBACK TO SAVEPOINT A failed: 1305 SAVEPOINT
%s does not exist. Further errors of this kind will be suppressed.
# 2011-01-09T04:52:00 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 `D` WHERE `col_int_key`
BETWEEN 's' AND 8 ORDER BY
`col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk`
LIMIT 25 failed: 1292 Truncated incorrect DOUBLE value: 's'. Further errors of
this kind will be suppressed.
# 2011-01-09T04:52:03 Query: ROLLBACK TO SAVEPOINT A failed: 1305 SAVEPOINT
%s does not exist. Further errors of this kind will be suppressed.
# 2011-01-09T04:52:04 Query: DELETE FROM `AA` WHERE `col_int` > 50 ORDER BY
`col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk`
LIMIT 2 failed: 1213 Deadlock found when trying to get lock; try restarting
transaction. Further errors of this kind will be suppressed.
# 2011-01-09T04:52:05 Query: ROLLBACK TO SAVEPOINT A failed: 1305 SAVEPOINT
%s does not exist. Further errors of this kind will be suppressed.
# 2011-01-09T04:52:06 Query: INSERT INTO `DD` ( `col_char_10` ,
`col_char_10_key` , `col_char_10_not_null` , `col_char_10_not_null_key` ,
`col_char_1024` , `col_char_1024_key` , `col_char_1024_not_null` ,
`col_char_1024_not_null_key` , `col_int` , `col_int_key` , `col_int_not_null` ,
`col_int_not_null_key` , `col_bigint` , `col_bigint_key` ,
`col_bigint_not_null` , `col_bigint_not_null_key` , `col_enum` , `col_enum_key`
, `col_enum_not_null` , `col_enum_not_null_key` , `col_text` , `col_text_key` ,
`col_text_not_null` , `col_text_not_null_key` ) SELECT `col_char_10` ,
`col_char_10_key` , `col_char_10_not_null` , `col_char_10_not_null_key` ,
`col_char_1024` , `col_char_1024_key` , `col_char_1024_not_null` ,
`col_char_1024_not_null_key` , `col_int` , `col_int_key` , `col_int_not_null` ,
`col_int_not_null_key` , `col_bigint` , `col_bigint_key` ,
`col_bigint_not_null` , `col_bigint_not_null_key` , `col_enum` , `col_enum_key`
, `col_enum_not_null` , `col_enum_not_null_key` , `col_text` , `col_text_key` ,
`col_text_not_null` , `col_text_not_null_key` FROM `D` WHERE `col_int_key` IN
('o') ORDER BY
`col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk`
LIMIT 50 failed: 1292 Truncated incorrect DOUBLE value: 'o'. Further errors
of this kind will be suppressed.
# 2011-01-09T04:52:07 Query: UPDATE `DD` SET `col_int_not_null` = 9 WHERE
`col_text_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 7 failed: 1213 Deadlock found when trying to get lock; try restarting
transaction. Further errors of this kind will be suppressed.
# 2011-01-09T04:52:07 Query: UPDATE `BB` SET `col_int_not_null_key` =
2152202240 WHERE `col_int_key` = 4 ORDER BY
`col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk`
LIMIT 8 failed: 1264 Out of range value for column 'col_int_not_null_key' at
row 1
# 2011-01-09T04:52:08 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 `D` WHERE `col_int_not_null`
BETWEEN 'y' AND 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 10 failed: 1292 Truncated incorrect DOUBLE value: 'y'. Further errors of
this kind will be suppressed.
# 2011-01-09T04:52:08 Query: UPDATE `B` SET `col_int_not_null` = 2149384192
WHERE `col_enum_key` <= 2989490176 ORDER BY
`col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk`
LIMIT 5 failed: 1264 Out of range value for column 'col_int_not_null' at row 1
# 2011-01-09T04:52:08 Query: DELETE FROM `AA` WHERE `col_bigint` BETWEEN 3 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 4 failed: 1213 Deadlock found when trying to get lock; try restarting
transaction. Further errors of this kind will be suppressed.
# 2011-01-09T04:52:08 Query: SELECT X . `col_char_10_not_null_key` FROM `CC`
AS X LEFT JOIN `D` AS Y USING ( `col_text_key` ) WHERE X .
`col_enum_not_null_key` IN ( 213 , 1919483904 , 1902116864 , 3 , 2231894016 )
LIMIT 7 failed: 1691 Received an invalid enum value '%d'.. Further errors of
this kind will be suppressed.
# 2011-01-09T04:52:09 Query: INSERT INTO `AA` ( `col_char_10` ,
`col_char_10_key` , `col_char_10_not_null` , `col_char_10_not_null_key` ,
`col_char_1024` , `col_char_1024_key` , `col_char_1024_not_null` ,
`col_char_1024_not_null_key` , `col_int` , `col_int_key` , `col_int_not_null` ,
`col_int_not_null_key` , `col_bigint` , `col_bigint_key` ,
`col_bigint_not_null` , `col_bigint_not_null_key` , `col_enum` , `col_enum_key`
, `col_enum_not_null` , `col_enum_not_null_key` , `col_text` , `col_text_key` ,
`col_text_not_null` , `col_text_not_null_key` ) SELECT `col_char_10` ,
`col_char_10_key` , `col_char_10_not_null` , `col_char_10_not_null_key` ,
`col_char_1024` , `col_char_1024_key` , `col_char_1024_not_null` ,
`col_char_1024_not_null_key` , `col_int` , `col_int_key` , `col_int_not_null` ,
`col_int_not_null_key` , `col_bigint` , `col_bigint_key` ,
`col_bigint_not_null` , `col_bigint_not_null_key` , `col_enum` , `col_enum_key`
, `col_enum_not_null` , `col_enum_not_null_key` , `col_text` , `col_text_key` ,
`col_text_not_null` , `col_text_not_null_key` FROM `D` WHERE `col_int_not_null`
IN ('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 100 failed: 1292 Truncated incorrect DOUBLE value: 'b'. Further errors
of this kind will be suppressed.
# 2011-01-09T04:52:10 Query: UPDATE `DD` SET `col_int` = 4049534976 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 7 failed: 1264 Out of range value for column 'col_int' at row 1
# 2011-01-09T04:52:11 Query: INSERT INTO `B` ( `col_char_10` ,
`col_char_10_key` , `col_char_10_not_null` , `col_char_10_not_null_key` ,
`col_char_1024` , `col_char_1024_key` , `col_char_1024_not_null` ,
`col_char_1024_not_null_key` , `col_int` , `col_int_key` , `col_int_not_null` ,
`col_int_not_null_key` , `col_bigint` , `col_bigint_key` ,
`col_bigint_not_null` , `col_bigint_not_null_key` , `col_enum` , `col_enum_key`
, `col_enum_not_null` , `col_enum_not_null_key` , `col_text` , `col_text_key` ,
`col_text_not_null` , `col_text_not_null_key` ) SELECT `col_char_10` ,
`col_char_10_key` , `col_char_10_not_null` , `col_char_10_not_null_key` ,
`col_char_1024` , `col_char_1024_key` , `col_char_1024_not_null` ,
`col_char_1024_not_null_key` , `col_int` , `col_int_key` , `col_int_not_null` ,
`col_int_not_null_key` , `col_bigint` , `col_bigint_key` ,
`col_bigint_not_null` , `col_bigint_not_null_key` , `col_enum` , `col_enum_key`
, `col_enum_not_null` , `col_enum_not_null_key` , `col_text` , `col_text_key` ,
`col_text_not_null` , `col_text_not_null_key` FROM `AA` WHERE
`col_int_not_null_key` IN ('a', 4, 6, 2) ORDER BY
`col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk`
LIMIT 10 failed: 1292 Truncated incorrect DOUBLE value: 'a'. Further errors
of this kind will be suppressed.
# 2011-01-09T04:52:11 Query: UPDATE `BB` SET `col_bigint_key` = 'd' WHERE
`col_enum_not_null_key` = 'j' ORDER BY
`col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk`
LIMIT 7 failed: 1366 Incorrect integer value: 'd' for column 'col_bigint_key'
at row %d. Further errors of this kind will be suppressed.
# 2011-01-09T04:52:11 Query: UPDATE `C` SET `col_int_not_null_key` = 2 WHERE
`col_bigint_not_null_key` = ( SELECT `col_int_key` FROM `C` WHERE `pk` =
2542665728 ) ORDER BY
`col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk`
LIMIT 8 failed: 1093 You can't specify target table '%s' for update in FROM
clause. Further errors of this kind will be suppressed.
# 2011-01-09T04:52:11 Query: UPDATE `A` SET `col_int_not_null` = 'w' WHERE
`col_bigint` < 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 5 failed: 1366 Incorrect integer value: 'w' for column
'col_int_not_null' at row %d. Further errors of this kind will be suppressed.
# 2011-01-09T04:52:14 Query: UPDATE `D` SET `col_bigint` = 'g' WHERE
`col_char_10` IN ('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 7 failed: 1366 Incorrect integer value: 'g' for column 'col_bigint' at
row %d. Further errors of this kind will be suppressed.
# 2011-01-09T04:52:20 Query: UPDATE `AA` SET `col_int_key` = 3 WHERE
`col_char_10_key` IN ( SELECT `col_bigint_key` FROM `AA` WHERE `pk` =
4053467136 ) ORDER BY
`col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk`
LIMIT 5 failed: 1093 You can't specify target table '%s' for update in FROM
clause. Further errors of this kind will be suppressed.
# 2011-01-09T04:52:20 Query: UPDATE `CC` SET `col_int_not_null_key` = 'v'
WHERE `col_char_10_key` IN ('e') ORDER BY
`col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk`
LIMIT 5 failed: 1366 Incorrect integer value: 'v' for column
'col_int_not_null_key' at row %d. Further errors of this kind will be
suppressed.
# 2011-01-09T04:52:21 Query: UPDATE `CC` SET `col_int_not_null` = 4 WHERE
`col_enum_key` = 0 ORDER BY
`col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk`
LIMIT 8 failed: 1691 Received an invalid enum value '%d'.. Further errors of
this kind will be suppressed.
# 2011-01-09T04:52:22 Query: UPDATE `C` SET `col_bigint` = 3 WHERE
`col_enum_not_null_key` = 4004052992 ORDER BY
`col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk`
LIMIT 5 failed: 1691 Received an invalid enum value '%d'.. Further errors of
this kind will be suppressed.
# 2011-01-09T04:52:22 Query: INSERT INTO `DD` ( `col_char_10` ,
`col_char_10_key` , `col_char_10_not_null` , `col_char_10_not_null_key` ,
`col_char_1024` , `col_char_1024_key` , `col_char_1024_not_null` ,
`col_char_1024_not_null_key` , `col_int` , `col_int_key` , `col_int_not_null` ,
`col_int_not_null_key` , `col_bigint` , `col_bigint_key` ,
`col_bigint_not_null` , `col_bigint_not_null_key` , `col_enum` , `col_enum_key`
, `col_enum_not_null` , `col_enum_not_null_key` , `col_text` , `col_text_key` ,
`col_text_not_null` , `col_text_not_null_key` ) SELECT `col_char_10` ,
`col_char_10_key` , `col_char_10_not_null` , `col_char_10_not_null_key` ,
`col_char_1024` , `col_char_1024_key` , `col_char_1024_not_null` ,
`col_char_1024_not_null_key` , `col_int` , `col_int_key` , `col_int_not_null` ,
`col_int_not_null_key` , `col_bigint` , `col_bigint_key` ,
`col_bigint_not_null` , `col_bigint_not_null_key` , `col_enum` , `col_enum_key`
, `col_enum_not_null` , `col_enum_not_null_key` , `col_text` , `col_text_key` ,
`col_text_not_null` , `col_text_not_null_key` FROM `A` WHERE `col_int_key` >=
'l' ORDER BY
`col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk`
LIMIT 10 failed: 1292 Truncated incorrect DOUBLE value: 'l'. Further errors
of this kind will be suppressed.
# 2011-01-09T04:52:28 Child process completed successfully.
# 2011-01-09T04:52:28 Query: INSERT INTO `B` ( `col_char_10` ,
`col_char_10_key` , `col_char_10_not_null` , `col_char_10_not_null_key` ,
`col_char_1024` , `col_char_1024_key` , `col_char_1024_not_null` ,
`col_char_1024_not_null_key` , `col_int` , `col_int_key` , `col_int_not_null` ,
`col_int_not_null_key` , `col_bigint` , `col_bigint_key` ,
`col_bigint_not_null` , `col_bigint_not_null_key` , `col_enum` , `col_enum_key`
, `col_enum_not_null` , `col_enum_not_null_key` , `col_text` , `col_text_key` ,
`col_text_not_null` , `col_text_not_null_key` ) SELECT `col_char_10` ,
`col_char_10_key` , `col_char_10_not_null` , `col_char_10_not_null_key` ,
`col_char_1024` , `col_char_1024_key` , `col_char_1024_not_null` ,
`col_char_1024_not_null_key` , `col_int` , `col_int_key` , `col_int_not_null` ,
`col_int_not_null_key` , `col_bigint` , `col_bigint_key` ,
`col_bigint_not_null` , `col_bigint_not_null_key` , `col_enum` , `col_enum_key`
, `col_enum_not_null` , `col_enum_not_null_key` , `col_text` , `col_text_key` ,
`col_text_not_null` , `col_text_not_null_key` FROM `C` WHERE `col_int_key` >=
'x' ORDER BY
`col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk`
LIMIT 25 failed: 1366 Incorrect integer value: 'x' for column 'col_int_key'
at row %d. Further errors of this kind will be suppressed.
# 2011-01-09T04:52:30 Child process completed successfully.
# 2011-01-09T04:52:30 Child process completed successfully.
# 2011-01-09T04:52:30 Child process completed successfully.
# 2011-01-09T04:52:30 Child process completed successfully.
# 2011-01-09T04:52:31 Killing periodic reporting process with pid 20509...
# 2011-01-09T04:52:31 Kill GenTest::ErrorFilter(20508)
# 2011-01-09T04:52:32
dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
# 2011-01-09T04:52:32 transaction_log output file: /tmp//translog_20501_.sql
# 2011-01-09T04:52:32
<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_20501_.sql
# 2011-01-09T04:52:32 Replicating from transaction_log output...
# 2011-01-09T04:52:32
<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_20501_.sql
# 2011-01-09T04:52:49 Validating replication via dumpfile compare...
# 2011-01-09T04:52:49 /tmp//translog_rpl_dump_20501_9306.sql
# 2011-01-09T04:52:49
<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_20501_9306.sql
# 2011-01-09T04:52:49 /tmp//translog_rpl_dump_20501_9307.sql
# 2011-01-09T04:52:49
<http://hudson.drizzle.org/job/drizzle-staging-randgen-transaction-log/ws/client/drizzledump>
--compact --skip-extended-insert --host=127.0.0.1 --port=9307 --user=root test
>/tmp//translog_rpl_dump_20501_9307.sql
# 2011-01-09T04:52:50 Executing diff --unified
/tmp//translog_rpl_dump_20501_9306.sql /tmp//translog_rpl_dump_20501_9307.sql
--- /tmp//translog_rpl_dump_20501_9306.sql 2011-01-09 04:52:49.000000000
+0000
+++ /tmp//translog_rpl_dump_20501_9307.sql 2011-01-09 04:52:50.000000000
+0000
@@ -558,7 +558,7 @@
INSERT INTO `AA` VALUES
('s','',3,'o','c','j',-2095054848,NULL,'ORDQG',0,'z','k','',8,'g','l','all',1363148800,'',66,'','n','w',NULL,-2504001392817995776);
INSERT INTO `AA` VALUES
('now','',1050746088060878848,'k','I\'ll','c',2141650944,NULL,'from',3,'been','a','',2,'h','NZEEI','n',-522518528,'',67,'','KCMEK','MEDXS',1,2);
INSERT INTO `AA` VALUES
('QDGXG','',6,'q','of','v',5,4,'can',345243648,'u','n','',-8825366419785908224,'z','b','e',697171968,'',68,'','at','a',9,3023322724849156096);
-INSERT INTO `AA` VALUES
('up','',7,'c','j','g',1357316096,NULL,'but',3,'for','x','',0,'w','TXMNN','RODXM',9,'',69,'','did','m',0,1);
+INSERT INTO `AA` VALUES
('up','',7,'c','j','g',1357316096,NULL,'but',3,'for','x','',100,'w','TXMNN','RODXM',9,'',69,'','did','m',0,1);
INSERT INTO `AA` VALUES
('x','',0,'i','I\'ll','y',NULL,6604247378562121728,'TADMN',2,'d','q','',1953717813348663296,'z','are','that\'s',7,'',70,'','something','was',NULL,-3684225970165776384);
INSERT INTO `AA` VALUES
('CZKDE','',5,'v','MTFHR','n',NULL,9,'LJQAL',1118896128,'b','g','',NULL,'b','LEBKY','OOYQQ',-1277427712,'',71,'','IANKZ','z',NULL,-1926696215584440320);
INSERT INTO `AA` VALUES
('do','',4526680575460769792,'n','QKZMW','f',363790336,6,'b',-244711424,'VGNYR','z','',NULL,'m','LNJBA','right',8,'',72,'','j','in',2,768145211443380224);
@@ -3550,7 +3550,6 @@
) ENGINE='InnoDB' COLLATE='utf8_general_ci';
INSERT INTO `D` VALUES
(6,'','',6,-7104428412176957440,'h','x','g',1793916928,'can','QLJQV','me','ZAIKN','AQBQH','it\'s','m','',1,3,'w',6890507429876858880,1471938560,3067232821216018432,'','f');
-INSERT INTO `D` VALUES
(5,'','',2102853632,4,'o','y','i',4,'MKHNZ','you','i','o','YVYMP','you','e','',3,6,'DMQFD',8,1,0,'','e');
INSERT INTO `D` VALUES
(6737947992499683328,'','',1,-71213169107795968,'are','h','b',6,'FMBIC','up','BOUVT','I\'ll','i','FCPSC','z','',4,-1841823744,'her',NULL,NULL,8,'','b');
INSERT INTO `D` VALUES
(5,'','',-16711680,-792915009393917952,'s','v','t',1614479360,'been','him','d','j','as','c','s','',5,0,'got',NULL,7,3,'','u');
INSERT INTO `D` VALUES
(-2148217022255726592,'','',-1949696000,307089199591325696,'that\'s','w','l',NULL,'o','been','d','HXWMV','l','hey','d','',7,-127991808,'UIFEU',1664361537290108928,9,1837187172990451712,'','n');
@@ -3562,7 +3561,6 @@
INSERT INTO `D` VALUES
(1673368736544849920,'','',1415643136,-3750372589692780544,'ZVAVY','c','u',9,'h','s','mean','be','mean','you','i','',15,772734976,'could',NULL,NULL,4,'','q');
INSERT INTO `D` VALUES
(936748722493063168,'','',8,2,'VIPHU','r','z',NULL,'URADV','z','u','QUHSZ','UGKYM','c','g','',17,-1516961792,'XPRJM',1903896742470877184,-2047541248,8,'','z');
INSERT INTO `D` VALUES
(-5020106209634549760,'','',3,-4655314639817539584,'x','y','t',5,'ZJJXA','m','PJGJP','all','say','o','l','',18,-1195442176,'p',NULL,NULL,4199043702569566208,'','f');
-INSERT INTO `D` VALUES
(2,'','',-1276313600,NULL,'for','m','j',NULL,'b','UJTQP','JKHZJ','NNQOU','PFENZ','i','x','',19,6,'WNAMC',6,-1725497344,3,'','t');
INSERT INTO `D` VALUES
(8,'','',599064576,4498814552766414848,'BDYJZ','y','x',-1887109120,'l','see','ABHAO','look','DCVSQ','i','j','',20,5,'r',6,3,-7499619279478718464,'','c');
INSERT INTO `D` VALUES
(7,'','',-370802688,0,'with','j','q',1411645440,'e','OXSSK','GPEXK','w','time','PGLQA','z','',21,555417600,'e',NULL,-964034560,-3014878475547836416,'','j');
INSERT INTO `D` VALUES
(1207809125065424896,'','',1742536704,3,'FXLJZ','e','c',6,'c','ok','i','for','h','you','n','',25,7,'QHOJA',5790784695868325888,9,1,'','m');
# 2011-01-09T04:52:50 Cleaning up validation server...
# 2011-01-09T04:52:51 Resetting validation server...
# 2011-01-09T04:52:51 0
# 2011-01-09T04:52:51 Differences between the two servers were found after
comparing dumpfiles
# 2011-01-09T04:52:51 diff command: diff --unified
/tmp//translog_rpl_dump_20501_9306.sql /tmp//translog_rpl_dump_20501_9307.sql
# 2011-01-09T04:52:51 Master dumpfile: /tmp//translog_rpl_dump_20501_9306.sql
# 2011-01-09T04:52:51 Slave dumpfile: /tmp//translog_rpl_dump_20501_9307.sql
# 2011-01-09T04:52:51 Transaction log: /tmp//translog_20501_.log
# 2011-01-09T04:52:51 Test completed with failure status
STATUS_REPLICATION_FAILURE (103)
Sun Jan 9 04:52:51 2011 INFO: Pinging Drizzled server on port 9306
Sun Jan 9 04:52:51 2011 INFO: Stopping Drizzled server on port 9306
Sun Jan 9 04:52:54 2011 INFO: Clearing Drizzled server on port 9306
Sun Jan 9 04:52:54 2011 INFO: Starting Drizzled server on port 9306
Sun Jan 9 04:52:54 2011 INFO: PWD: /home/hudson/repos/randgen
Sun Jan 9 04:53:06 2011 INFO: Dropping any test database previously setup.
Sun Jan 9 04:53:06 2011 INFO: Creating test database.
Sun Jan 9 04:53:07 2011 INFO: Pinging Drizzled server on port 9307
Sun Jan 9 04:53:07 2011 INFO: Stopping Drizzled server on port 9307
Sun Jan 9 04:53:10 2011 INFO: Clearing Drizzled server on port 9307
Sun Jan 9 04:53:10 2011 INFO: Starting Drizzled server on port 9307
Sun Jan 9 04:53:10 2011 INFO: PWD: /home/hudson/repos/randgen
Sun Jan 9 04:53:15 2011 INFO: Dropping any test database previously setup.
Sun Jan 9 04:53:15 2011 INFO: Creating test database.
Sun Jan 9 04:53:15 2011 INFO: Running : single_thread3 with ./gentest.pl
--dsn=dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
--threads=5 --queries=500 --engine=Innodb
--gendata=conf/drizzle/translog_drizzle.zz
--grammar=conf/drizzle/translog_concurrent3.yy --Reporter=DrizzleTransactionLog
--queries=100 --threads=1
Sun Jan 9 04:53:56 2011 INFO: single_thread3 Passed
Sun Jan 9 04:53:56 2011 INFO: Pinging Drizzled server on port 9306
Sun Jan 9 04:53:56 2011 INFO: Stopping Drizzled server on port 9306
Sun Jan 9 04:53:59 2011 INFO: Clearing Drizzled server on port 9306
Sun Jan 9 04:53:59 2011 INFO: Starting Drizzled server on port 9306
Sun Jan 9 04:53:59 2011 INFO: PWD: /home/hudson/repos/randgen
Sun Jan 9 04:54:08 2011 INFO: Dropping any test database previously setup.
Sun Jan 9 04:54:08 2011 INFO: Creating test database.
Sun Jan 9 04:54:08 2011 INFO: Pinging Drizzled server on port 9307
Sun Jan 9 04:54:08 2011 INFO: Stopping Drizzled server on port 9307
Sun Jan 9 04:54:11 2011 INFO: Clearing Drizzled server on port 9307
Sun Jan 9 04:54:12 2011 INFO: Starting Drizzled server on port 9307
Sun Jan 9 04:54:12 2011 INFO: PWD: /home/hudson/repos/randgen
Sun Jan 9 04:54:16 2011 INFO: Dropping any test database previously setup.
Sun Jan 9 04:54:16 2011 INFO: Creating test database.
Sun Jan 9 04:54:16 2011 INFO: Running : multi_thread3_mix with ./gentest.pl
--dsn=dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
--threads=5 --queries=500 --engine=Innodb
--gendata=conf/drizzle/translog_drizzle.zz
--grammar=conf/drizzle/translog_concurrent3.yy --Reporter=DrizzleTransactionLog
--queries=250 --seed=time --threads=2
Sun Jan 9 04:56:51 2011 INFO: multi_thread3_mix Passed
Sun Jan 9 04:56:51 2011 INFO: Pinging Drizzled server on port 9306
Sun Jan 9 04:56:51 2011 INFO: Stopping Drizzled server on port 9306
Sun Jan 9 04:56:54 2011 INFO: Clearing Drizzled server on port 9306
Sun Jan 9 04:56:54 2011 INFO: Starting Drizzled server on port 9306
Sun Jan 9 04:56:54 2011 INFO: PWD: /home/hudson/repos/randgen
Sun Jan 9 04:57:02 2011 INFO: Dropping any test database previously setup.
Sun Jan 9 04:57:02 2011 INFO: Creating test database.
Sun Jan 9 04:57:02 2011 INFO: Pinging Drizzled server on port 9307
Sun Jan 9 04:57:02 2011 INFO: Stopping Drizzled server on port 9307
Sun Jan 9 04:57:05 2011 INFO: Clearing Drizzled server on port 9307
Sun Jan 9 04:57:05 2011 INFO: Starting Drizzled server on port 9307
Sun Jan 9 04:57:05 2011 INFO: PWD: /home/hudson/repos/randgen
Sun Jan 9 04:57:11 2011 INFO: Dropping any test database previously setup.
Sun Jan 9 04:57:11 2011 INFO: Creating test database.
Sun Jan 9 04:57:11 2011 INFO: Stopping Drizzled server on port 9306
Sun Jan 9 04:57:11 2011 INFO: Stopping Drizzled server on port 9307
Sun Jan 9 04:57:11 2011 INFO: 6 tests passed
Sun Jan 9 04:57:11 2011 INFO: 1 tests failed
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-builds
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-builds
More help : https://help.launchpad.net/ListHelp
