# 2013-08-08T14:30:48 Copyright (c) 2008,2011 Oracle and/or its affiliates. All rights reserved. Use is subject to license terms. # 2013-08-08T14:30:48 Please see http://forge.mysql.com/wiki/Category:RandomQueryGenerator for more information on this test framework. # 2013-08-08T14:30:48 Starting: /home/buildbot/randgen/runall.pl --basedir=. --vardir=../../vardir-maria_varchar --grammar=/home/buildbot/randgen/conf/engines/varchar.yy --gendata=/home/buildbot/randgen/conf/engines/varchar.zz --reporter=Backtrace,ErrorLog,Recovery,Shutdown --duration=120 --queries=1M --engine=Aria --mysqld=--aria-checkpoint-interval=0 --mysqld=--log-output=file --seed=time --mysqld=--loose-skip-innodb --mysqld=--loose-pbxt=OFF --mysqld=--safe-mode --mysqld=--default-storage-engine=Aria # 2013-08-08T14:30:48 master_port : 19300 slave_port : 19302 master_ports : 19300 19302 MTR_BUILD_THREAD : 930 # 2013-08-08T14:30:50 /home/buildbot/buildbot_basedir/rqg-perpush-mariaengine/build Revno: 3848 # 2013-08-08T14:30:50 /home/buildbot/buildbot_basedir/rqg-perpush-mariaengine/build Revision-Id: bar@mariadb.org-20130808094121-cqmjldq0lh2bhl3m # 2013-08-08T14:30:52 . Revno: 3848 # 2013-08-08T14:30:52 . Revision-Id: bar@mariadb.org-20130808094121-cqmjldq0lh2bhl3m # 2013-08-08T14:30:52 Running perl mysql-test-run.pl --start-and-exit --skip-ndb --mysqld=--core-file --mysqld=--loose-new --mysqld=--default-storage-engine=Aria --mysqld=--sql-mode=no_engine_substitution --mysqld=--relay-log=slave-relay-bin --mysqld=--loose-innodb --mysqld=--secure-file-priv= --mysqld=--max-allowed-packet=16Mb --mysqld=--loose-innodb-status-file=1 --mysqld=--master-retry-count=65535 --mysqld=--loose-debug-assert-if-crashed-table --mysqld=--loose-debug-assert-on-error --mysqld=--skip-name-resolve --vardir=../../vardir-maria_varchar --master_port=19300 --mysqld="--aria-checkpoint-interval=0" --mysqld="--log-output=file" --mysqld="--loose-skip-innodb" --mysqld="--loose-pbxt=OFF" --mysqld="--safe-mode" --mysqld="--default-storage-engine=Aria" 1st 2>&1 . # 2013-08-08T14:30:52 Unable to open mtr_command: No such file or directory ======================================================= WARNING: Using mysql-test-run.pl version 1! ======================================================= Logging: lib/v1/mysql-test-run.pl --start-and-exit --skip-ndb --mysqld=--core-file --mysqld=--loose-new --mysqld=--default-storage-engine=Aria --mysqld=--sql-mode=no_engine_substitution --mysqld=--relay-log=slave-relay-bin --mysqld=--loose-innodb --mysqld=--secure-file-priv= --mysqld=--max-allowed-packet=16Mb --mysqld=--loose-innodb-status-file=1 --mysqld=--master-retry-count=65535 --mysqld=--loose-debug-assert-if-crashed-table --mysqld=--loose-debug-assert-on-error --mysqld=--skip-name-resolve --vardir=../../vardir-maria_varchar --master_port=19300 --mysqld=--aria-checkpoint-interval=0 --mysqld=--log-output=file --mysqld=--loose-skip-innodb --mysqld=--loose-pbxt=OFF --mysqld=--safe-mode --mysqld=--default-storage-engine=Aria 1st 130808 14:30:52 [Note] Plugin 'FEEDBACK' is disabled. MySQL Version 5.5.32 Using dynamic switching of binlog format Using default engine 'Aria' Skipping ndbcluster Setting mysqld to support SSL connections Binaries are debug compiled Use of uninitialized value in scalar assignment at lib/v1/mysql-test-run.pl line 1956. Using MTR_BUILD_THREAD = 930 Using MASTER_MYPORT = 19300 Using MASTER_MYPORT1 = 19301 Using SLAVE_MYPORT = 19302 Using SLAVE_MYPORT1 = 19303 Using SLAVE_MYPORT2 = 19304 Using IM_PORT = 19307 Using IM_MYSQLD1_PORT = 19308 Using IM_MYSQLD2_PORT = 19309 Killing Possible Leftover Processes Removing Stale Files Creating Directories Installing Master Database ======================================================= TEST RESULT TIME (ms) ------------------------------------------------------- Servers started, exiting # 2013-08-08T14:31:11 Starting: /home/buildbot/randgen/gentest.pl --gendata=/home/buildbot/randgen/conf/engines/varchar.zz --engine=Aria --reporter=Backtrace --reporter=ErrorLog --reporter=Recovery --reporter=Shutdown --threads=10 --queries=1M --duration=120 --dsn=dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test --grammar=/home/buildbot/randgen/conf/engines/varchar.yy --seed=time # 2013-08-08T14:31:11 Converting --seed=time to --seed=1375961471 # 2013-08-08T14:31:11 ------------------------------- # 2013-08-08T14:31:11 Configuration # 2013-08-08T14:31:11 debug_server => [''] # 2013-08-08T14:31:11 dsn => ['dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test'] # 2013-08-08T14:31:11 duration => 120 # 2013-08-08T14:31:11 engine => Aria # 2013-08-08T14:31:11 gendata => /home/buildbot/randgen/conf/engines/varchar.zz # 2013-08-08T14:31:11 generator => FromGrammar # 2013-08-08T14:31:11 grammar => /home/buildbot/randgen/conf/engines/varchar.yy # 2013-08-08T14:31:11 queries => 1000000 # 2013-08-08T14:31:11 reporters => ['Backtrace', 'ErrorLog', 'Recovery', 'Shutdown'] # 2013-08-08T14:31:11 seed => 1375961471 # 2013-08-08T14:31:11 threads => 10 # 2013-08-08T14:31:11 transformers => [''] # 2013-08-08T14:31:11 validators => [''] # 2013-08-08T14:31:11 views => ['', ''] # 2013-08-08T14:31:11 # Creating MySQL table: test.table1_aria_varchar_378_not_null; engine: aria; rows: 1 . # 2013-08-08T14:31:11 # Creating MySQL table: test.table1_aria_key_pk_parts_2_varchar_378_not_null; engine: aria; rows: 1 . # 2013-08-08T14:31:11 # Creating MySQL table: test.table1000_aria_varchar_378_not_null; engine: aria; rows: 1000 . # 2013-08-08T14:31:12 # Creating MySQL table: test.table1000_aria_key_pk_parts_2_varchar_378_not_null; engine: aria; rows: 1000 . # 2013-08-08T14:31:13 # Creating MySQL table: test.table10000_aria_varchar_378_not_null; engine: aria; rows: 10000 . # 2013-08-08T14:31:21 # Progress: loaded 10000 out of 10000 rows # 2013-08-08T14:31:24 # Creating MySQL table: test.table10000_aria_key_pk_parts_2_varchar_378_not_null; engine: aria; rows: 10000 . # 2013-08-08T14:31:31 # Progress: loaded 10000 out of 10000 rows # 2013-08-08T14:31:34 Reporters: Backtrace, ErrorLog, Recovery, Shutdown # 2013-08-08T14:31:34 Validators: ErrorMessageCorruption # 2013-08-08T14:31:34 Caching schema metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2013-08-08T14:31:34 Starting 10 processes, 1000000 queries each, duration 120 seconds. # 2013-08-08T14:31:34 GenTest::ErrorFilter(13228) started # 2013-08-08T14:31:34 Loading Validator GenTest::Validator::ErrorMessageCorruption. # 2013-08-08T14:31:34 Loading Validator GenTest::Validator::ErrorMessageCorruption. # 2013-08-08T14:31:34 Loading Validator GenTest::Validator::ErrorMessageCorruption. # 2013-08-08T14:31:35 Loading Validator GenTest::Validator::ErrorMessageCorruption. # 2013-08-08T14:31:35 Loading Validator GenTest::Validator::ErrorMessageCorruption. # 2013-08-08T14:31:35 Loading Validator GenTest::Validator::ErrorMessageCorruption. # 2013-08-08T14:31:35 Loading Validator GenTest::Validator::ErrorMessageCorruption. # 2013-08-08T14:31:35 Loading Validator GenTest::Validator::ErrorMessageCorruption. # 2013-08-08T14:31:35 Loading Validator GenTest::Validator::ErrorMessageCorruption. # 2013-08-08T14:31:35 Loading Validator GenTest::Validator::ErrorMessageCorruption. # 2013-08-08T14:33:25 Query: DELETE FROM `table1000_aria_key_pk_parts_2_varchar_378_not_null` WHERE `col_varchar_1024_utf8_not_null` IN ( 'uwgdihhmdxvieztojifnfjznltqosharpyzqrdxkzgqvuidudvpurxvziyfyizbowacsptfcudprxufcuytoredwcuqadbrsbdlrkkpnbbkawvsbzhpenlbkhosxjuuomrszchjmhoiujoeqqhzqnthgjaykdwqmcbewjpzxfjffmsnkdhmpmhv' , 'wgdihhmdxvieztojifnfjznltqosharpyzqrdxkzgqvuidudvpurxvziyfyizbowacsptfcudprxufcuytoredwcuqadbrsbdlrkkpnbbkawvsbzhpenlbkhosxjuuomrszchjmhoiujoeqqhzqnthgjaykdwqmcbewjpzxfjffmsnkdh' , 'b' , 'look' , 'a' , 'gdihhmdxvieztojifnfjznltqosharpyzqrdxkzgqvuidudvpurxvziyfyizbowacsptfcudprxufcuytoredwcuqadbrsbdlrkkpnbbkawvsbzhpenlbkhos' , 'dihhmdxvieztojifnfjznltqosharpyzqrdxkzgqvuidudvpurxvziyfyizbowacsptfcudprxufcuytoredwcuqadbrsbdlrkkpnbbkawvsbzhpen' , 'g' , 'with' , 'ihhmdxvieztojifnfjznltqosharpyzqrdxkzgqvuidudvpurxvziyfyizbowacsptfcudprxufcuytoredwcuqadbrsbdlrkkpnbbkawvsbzhpenlbkhosxjuuomrszchjmhoiujoeqqhzqnthgjaykdwqmcbewjpzxfjffmsnkdhmpmhvltjclwyvflebhdelrzbuhryouodgkyqaajctntqeikdrgbuaxmqgzerjivo' , "that's" ) LIMIT 1 failed: 2013 Lost connection to MySQL server during query # 2013-08-08T14:33:25 Query: REPLACE INTO `table10000_aria_key_pk_parts_2_varchar_378_not_null` ( `col_varchar_1024_latin1_not_null` , `col_varchar_1024_utf8_not_null` ) VALUES ( 'rboxscqdahqweqvhqfkpbezvwgftxtkmadolskyhwsiaclyxaohlwubgdariszrzgdapkxofvdygsytebjhxjebeokeopraizyptsdonkfznyniewribulvyjrgciqvkzfxjogavjdeftrscexbdovflmsllqwbaiupjhmsyknghftwnwbmvvsfrpuanlwizmgygjgvaicnkxwsyygtivq' , 'boxscqdahqweqvhqfkpbezvwgftxtkmadolskyhwsiaclyxaohlwu' ) failed: 2013 Lost connection to MySQL server during query # 2013-08-08T14:33:25 Server crash reported at dsn dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2013-08-08T14:33:25 Server crash reported at dsn dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2013-08-08T14:33:25 Query: REPLACE INTO `table1000_aria_varchar_378_not_null` ( `col_varchar_1024_latin1_key_default_null` ) SELECT `col_varchar_1024_latin1_key` FROM `table10000_aria_varchar_378_not_null` WHERE `col_varchar_1024_latin1_default_null` <=> 'was' ORDER BY `col_varchar_1024_utf8` , `col_varchar_1024_latin1_not_null_key` LIMIT 0 failed: 2013 Lost connection to MySQL server during query # 2013-08-08T14:33:25 Server crash reported at dsn dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2013-08-08T14:33:25 Query: UPDATE `table10000_aria_key_pk_parts_2_varchar_378_not_null` SET `col_varchar_1024_latin1_not_null_key` = 4 WHERE `col_varchar_1024_latin1_not_null_key` > 'p' failed: 2013 Lost connection to MySQL server during query # 2013-08-08T14:33:25 Query: INSERT INTO `table1000_aria_key_pk_parts_2_varchar_378_not_null` ( `col_varchar_1024_latin1_default_null` ) SELECT `col_varchar_1024_utf8_default_null` FROM `table10000_aria_varchar_378_not_null` WHERE `col_varchar_1024_utf8_default_null` <= 'kcugfhmcvsmfwgefyilujinetagxifkbuqeexeaqmnmnonhqeryqbmwjsadykaxqvrmgvefqqjjsvxgbowkxecgivugtaoxtqtflonlflahhthmtcqnwuncqxigkuio' LIMIT 6 failed: 2013 Lost connection to MySQL server during query # 2013-08-08T14:33:25 Query: UPDATE `table1000_aria_key_pk_parts_2_varchar_378_not_null` SET `col_varchar_1024_utf8_not_null` = 8 WHERE `col_varchar_1024_latin1` < 'd' failed: 2013 Lost connection to MySQL server during query # 2013-08-08T14:33:25 Server crash reported at dsn dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2013-08-08T14:33:25 Server crash reported at dsn dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2013-08-08T14:33:25 Server crash reported at dsn dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2013-08-08T14:33:25 Query: UPDATE `table10000_aria_key_pk_parts_2_varchar_378_not_null` SET `col_varchar_1024_latin1_key_default_null` = 1 WHERE `col_varchar_1024_utf8_key` < 'nnzsclbfvbztdsjzmygfsahciwefguocdknhvkryyjlplgcftinll' ORDER BY `col_varchar_1024_utf8_key_default_null` , `col_varchar_1024_utf8_key` failed: 2013 Lost connection to MySQL server during query # 2013-08-08T14:33:25 Server crash reported at dsn dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2013-08-08T14:31:34 Query: INSERT INTO `table10000_aria_varchar_378_not_null` ( `col_varchar_1024_utf8_key_default_null` ) SELECT `col_varchar_1024_utf8_not_null` FROM `table1000_aria_key_pk_parts_2_varchar_378_not_null` WHERE `col_varchar_1024_utf8_key_default_null` BETWEEN 'laybpzjppkisyuvqufkenqqpgjtuujnjsldzulodhaznnlgqdkdsrmoujvut' AND 'n' LIMIT 9 failed: 1062 Duplicate entry '%s' for key '%s'. Further errors of this kind will be suppressed. # 2013-08-08T14:31:37 Query: REPLACE INTO `table10000_aria_key_pk_parts_2_varchar_378_not_null` ( `col_varchar_1024_utf8_key_default_null` , `col_varchar_1024_utf8_key_default_null` ) VALUES ( 'gxqzuatoirswxnfuxkjm' , 'now' ) failed: 1110 Column '%s' specified twice. Further errors of this kind will be suppressed. DBI connect('host=127.0.0.1:port=19300:user=root:database=test','',...) failed: Can't connect to MySQL server on '127.0.0.1' (111) at /home/buildbot/randgen//lib/GenTest/Reporter/Recovery.pm line 88 # 2013-08-08T14:33:25 Killing remaining worker process with pid 13244... # 2013-08-08T14:33:25 Killing remaining worker process with pid 13240... # 2013-08-08T14:33:25 Killing remaining worker process with pid 13238... # 2013-08-08T14:33:25 Killing remaining worker process with pid 13234... # 2013-08-08T14:33:25 Killing remaining worker process with pid 13248... # 2013-08-08T14:33:25 Killing remaining worker process with pid 13232... # 2013-08-08T14:33:25 Killing remaining worker process with pid 13242... # 2013-08-08T14:33:25 Killing remaining worker process with pid 13246... # 2013-08-08T14:33:25 Killing remaining worker process with pid 13236... # 2013-08-08T14:33:26 Killing periodic reporting process with pid 13229... # 2013-08-08T14:33:26 Kill GenTest::ErrorFilter(13228) # 2013-08-08T14:33:26 Copying datadir... (interrupting the copy operation may cause a false recovery failure to be reported below # 2013-08-08T14:33:33 Attempting database recovery using aria_read_log ... # 2013-08-08T14:33:39 Copying complete aria_read_log: /home/buildbot/buildbot_basedir/rqg-perpush-mariaengine/build/storage/maria/ma_loghandler.c:3833: translog_init_with_table: Assertion `sure_page <= last_page' failed. # 2013-08-08T14:33:40 gentest.pl exited with exit status STATUS_RECOVERY_FAILURE (104) 2013-08-08T14:33:40 [13163] /home/buildbot/randgen/runall.pl will exit with exit status STATUS_RECOVERY_FAILURE (104)