G:\pb2\scripts\tmp-qauser\randgen>perl runall.pl --mysqld=--loose-skip-safemalloc --grammar=conf/engines/maria/maria_stress.yy --reporters=Deadlock,ErrorLog,Backtrace,Shutdown --duration=600 --basedir=G:\pb2\scripts\tmp-qauser\5.5-bugteam_nov08_mysql-5.5.8-win-x86 --mysqld=--log-output=file --queries=100000 --engine=myisam --threads=10 # 2010-11-08T14:37:43 Copyright (c) 2008-2009 Sun Microsystems, Inc. All rights reserved. Use is subject to license terms. # 2010-11-08T14:37:43 Please see http://forge.mysql.com/wiki/Category:RandomQueryGenerator for more information on this test framework. # 2010-11-08T14:37:43 Starting # 2010-11-08T14:37:43 # runall.pl \ # 2010-11-08T14:37:43 # --mysqld=--loose-skip-safemalloc \ # 2010-11-08T14:37:43 # --grammar=conf/engines/maria/maria_stress.yy \ # 2010-11-08T14:37:43 # --reporters=Deadlock,ErrorLog,Backtrace,Shutdown \ # 2010-11-08T14:37:43 # --duration=600 \ # 2010-11-08T14:37:43 # --basedir=G:\pb2\scripts\tmp-qauser\5.5-bugteam_nov08_mysql-5.5.8-win-x86 \ # 2010-11-08T14:37:43 # --mysqld=--log-output=file \ # 2010-11-08T14:37:43 # --queries=100000 \ # 2010-11-08T14:37:43 # --engine=myisam \ # 2010-11-08T14:37:43 # --threads=10 # 2010-11-08T14:37:43 master_port : 10010 slave_port : 10012 master_ports : 10010 10012 MTR_BUILD_THREAD : 1 # 2010-11-08T14:37:43 Running perl mysql-test-run.pl --start-and-exit --skip-ndb --mysqld=--core-file --mysqld=--loose-new --mysqld=--sql-mode=no_engine_substitution --mysqld=--relay-log=slave-relay-bin --mysqld=--loose-innodb --mysqld=--loose-falcon-debug-mask=2 --mysqld=--secure-file-priv= --mysqld=--max-allowed-packet=16Mb --mysqld=--loose-innodb-status-file=1 --mysqld=--master-retry-count=65535 --master_port=10010 --mysqld="--loose-skip-safemalloc" --mysqld="--log-output=file" 1st 2>&1 . ======================================================= 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=--sql-mode=no_engine_substitution --mysqld=--relay-log=slave-relay-bin --mysqld=--loose-innodb --mysqld=--loose-falcon-debug-mask=2 --mysqld=--secure-file-priv= --mysqld=--max-allowed-packet=16Mb --mysqld=--loose-innodb-status-file=1 --mysqld=--master-retry-count=65535 --master_port=10010 --mysqld=--loose-skip-safemalloc --mysqld=--log-output=file 1st 101108 14:37:43 [Note] Plugin 'FEDERATED' is disabled. MySQL Version 5.5.8 Using dynamic switching of binlog format Disable Instance manager - testing not supported on Windows Skipping ndbcluster Setting mysqld to support SSL connections Binaries are debug compiled Using MTR_BUILD_THREAD = 1 Using MASTER_MYPORT = 10010 Using MASTER_MYPORT1 = 10011 Using SLAVE_MYPORT = 10012 Using SLAVE_MYPORT1 = 10013 Using SLAVE_MYPORT2 = 10014 Killing Possible Leftover Processes mysql-test-run: WARNING: Found non pid file master.err in G:/pb2/scripts/tmp-qauser/5.5-bugteam_nov08_mysql-5.5.8-win-x86/mysql-test/var/run Removing Stale Files Creating Directories Installing Master Database ======================================================= TEST RESULT TIME (ms) ------------------------------------------------------- Servers started, exiting # 2010-11-08T14:38:06 Starting # 2010-11-08T14:38:06 gentest.pl \ # 2010-11-08T14:38:06 --gendata= \ # 2010-11-08T14:38:06 --engine=myisam \ # 2010-11-08T14:38:06 --reporter=Deadlock \ # 2010-11-08T14:38:06 --reporter=ErrorLog \ # 2010-11-08T14:38:06 --reporter=Backtrace \ # 2010-11-08T14:38:06 --reporter=Shutdown \ # 2010-11-08T14:38:06 --threads=10 \ # 2010-11-08T14:38:06 --queries=100000 \ # 2010-11-08T14:38:06 --duration=600 \ # 2010-11-08T14:38:06 --dsn=dbi:mysql:host=127.0.0.1:port=10010:user=root:database=test \ # 2010-11-08T14:38:06 --grammar=conf/engines/maria/maria_stress.yy # 2010-11-08T14:38:06 ------------------------------- # 2010-11-08T14:38:06 Configuration # 2010-11-08T14:38:06 dsn => ['dbi:mysql:host=127.0.0.1:port=10010:user=root:database=test'] # 2010-11-08T14:38:06 duration => 600 # 2010-11-08T14:38:06 engine => myisam # 2010-11-08T14:38:06 gendata => # 2010-11-08T14:38:06 grammar => conf/engines/maria/maria_stress.yy # 2010-11-08T14:38:06 queries => 100000 # 2010-11-08T14:38:06 reporters => ['Deadlock', 'ErrorLog', 'Backtrace', 'Shutdown'] # 2010-11-08T14:38:06 seed => 1 # 2010-11-08T14:38:06 threads => 10 # 2010-11-08T14:38:06 validators => [''] # 2010-11-08T14:38:06 Creating MySQL table A, size 0 rows, engine myisam . # 2010-11-08T14:38:06 Creating MySQL table B, size 1 rows, engine myisam . # 2010-11-08T14:38:07 Creating MySQL table C, size 20 rows, engine myisam . # 2010-11-08T14:38:07 Creating MySQL table D, size 100 rows, engine myisam . # 2010-11-08T14:38:09 Creating MySQL table E, size 1000 rows, engine myisam . # 2010-11-08T14:38:09 Creating MySQL table AA, size 0 rows, engine myisam . # 2010-11-08T14:38:09 Creating MySQL table BB, size 1 rows, engine myisam . # 2010-11-08T14:38:09 Creating MySQL table CC, size 20 rows, engine myisam . # 2010-11-08T14:38:09 Creating MySQL table DD, size 100 rows, engine myisam . # 2010-11-08T14:38:10 Caching schema metadata for dbi:mysql:host=127.0.0.1:port=10010:user=root:database=test # 2010-11-08T14:38:13 Reporters: Deadlock, ErrorLog, Backtrace, Shutdown # 2010-11-08T14:38:15 Validators: ErrorMessageCorruption # 2010-11-08T14:38:15 Starting 10 processes, 100000 queries each, duration 600 seconds. # 2010-11-08T14:38:17 Query: INSERT INTO D ( `col_varchar_nokey` , `pk` ) VALUES ( '2009-07-22 20:19:27' , 6 ) failed: 1062 Duplicate entry '%s' for key '%s'. Further errors of this kind will be suppressed. # 2010-11-08T14:38:17 Query: INSERT INTO C ( `col_int_nokey` , `col_int_nokey` ) VALUES ( '2006-02-17' , 8 ) failed: 1110 Column '%s' specified twice. Further errors of this kind will be suppressed. # 2010-11-08T14:38:17 Query: INSERT INTO D ( `col_datetime_key` , `col_datetime_key` ) VALUES ( 5 , 0 ) failed: 1110 Column '%s' specified twice. Further errors of this kind will be suppressed. # 2010-11-08T14:38:17 Query: INSERT INTO C ( `col_date_key` , `col_date_key` ) VALUES ( ' t ' , ' k ' ) failed: 1110 Column '%s' specified twice. Further errors of this kind will be suppressed. # 2010-11-08T14:38:17 Query: UPDATE C AS X SET `pk` = '00:59:42' WHERE X . `col_date_key` < '22:54:57' ORDER BY X . `col_datetime_nokey` failed: 1062 Duplicate entry '%s' for key '%s'. Further errors of this kind will be suppressed. # 2010-11-08T14:38:17 Query: INSERT INTO A ( `col_varchar_key` , `pk` ) VALUES ( '2007-09-27' , 4 ) failed: 1062 Duplicate entry '%s' for key '%s'. Further errors of this kind will be suppressed. # 2010-11-08T14:38:17 Query: INSERT INTO B ( `col_datetime_nokey` , `col_datetime_nokey` ) VALUES ( '2006-01-13' , '2001-11-02' ) failed: 1110 Column '%s' specified twice. Further errors of this kind will be suppressed. # 2010-11-08T14:38:17 Query: INSERT INTO D ( `col_varchar_key` , `pk` ) VALUES ( 0 , '06:52:33' ) failed: 1062 Duplicate entry '%s' for key '%s'. Further errors of this kind will be suppressed. # 2010-11-08T14:38:17 Started periodic reporting process... # 2010-11-08T14:38:19 Query: UPDATE B AS X SET `pk` = ' l ' WHERE X . `col_time_key` < '2000-07-23 01:40:23' ORDER BY X . `col_varchar_nokey` failed: 1062 Duplicate entry '%s' for key '%s'. Further errors of this kind will be suppressed. # 2010-11-08T14:38:20 Query: INSERT INTO D ( `col_varchar_key` , `col_varchar_key` ) VALUES ( ' v ' , '2001-10-13 12:32:00' ) failed: 1110 Column '%s' specified twice. Further errors of this kind will be suppressed. # 2010-11-08T14:38:20 Query: INSERT INTO D ( `col_date_key` , `col_date_key` ) VALUES ( '2007-09-28' , '2000-03-06' ) failed: 1110 Column '%s' specified twice. Further errors of this kind will be suppressed. # 2010-11-08T14:38:21 Query: UPDATE B AS X SET `pk` = 7 LIMIT 6 failed: 1062 Duplicate entry '%s' for key '%s'. Further errors of this kind will be suppressed. # 2010-11-08T14:38:29 Query: INSERT INTO A ( `col_time_key` , `col_time_key` ) VALUES ( 9 , '2007-11-06' ) failed: 1110 Column '%s' specified twice. Further errors of this kind will be suppressed. # 2010-11-08T14:38:29 Query: UPDATE A AS X SET `pk` = '2000-02-07 11:10:26' WHERE X . `col_time_key` < '2002-11-24 10:10:50' failed: 1062 Duplicate entry '%s' for key '%s'. Further errors of this kind will be suppressed. # 2010-11-08T14:38:45 Query: UPDATE C AS X SET `pk` = 5 WHERE X . `col_varchar_nokey` < '2007-09-14' ORDER BY X . `col_time_nokey` failed: 1062 Duplicate entry '%s' for key '%s'. Further errors of this kind will be suppressed. # 2010-11-08T14:38:45 Query: INSERT INTO A ( `col_int_nokey` , `col_int_nokey` ) VALUES ( '2007-08-23 11:28:28' , 5 ) failed: 1110 Column '%s' specified twice. Further errors of this kind will be suppressed. # 2010-11-08T14:38:54 GenTest::ErrorFilter(5) started # 2010-11-08T14:38:58 Query: INSERT INTO B ( `col_int_nokey` , `col_int_nokey` ) VALUES ( '13:52:57' , 4 ) failed: 1110 Column '%s' specified twice. Further errors of this kind will be suppressed. # 2010-11-08T14:39:01 Query: UPDATE B AS X SET `pk` = '02:11:22' ORDER BY X . `col_int_key` failed: 1062 Duplicate entry '%s' for key '%s'. Further errors of this kind will be suppressed. # 2010-11-08T14:39:04 Query: INSERT INTO C ( `col_date_key` , `col_date_key` ) VALUES ( 9 , '00:44:51' ) failed: 1110 Column '%s' specified twice. Further errors of this kind will be suppressed. # 2010-11-08T14:39:12 Query: UPDATE A AS X SET `pk` = ' u ' WHERE X . `pk` > '2009-12-16 04:00:48' ORDER BY X . `col_datetime_key` failed: 1062 Duplicate entry '%s' for key '%s'. Further errors of this kind will be suppressed. # 2010-11-08T14:40:32 Entire-server deadlock detected. # 2010-11-08T14:44:07 Child process completed successfully. # 2010-11-08T14:44:16 Child process completed successfully. DBI connect('host=127.0.0.1:port=10010:user=root:database=test','',...) failed: Lost connection to MySQL server at 'reading initial communication packet', system error: 0 at lib/GenTest/Reporter/Deadlock.pm line 188 thread 27 # 2010-11-08T14:45:30 Query: INSERT INTO B ( `col_date_key` , `col_date_key` ) VALUES ( '2000-12-18 10:55:38' , '17:20:11' ) failed: 2006 MySQL server has gone away # 2010-11-08T14:45:30 Server crash reported at dsn dbi:mysql:host=127.0.0.1:port=10010:user=root:database=test # 2010-11-08T14:45:30 Killing child process with pid -2560... # 2010-11-08T14:45:30 Killing child process with pid -3788... # 2010-11-08T14:45:30 Killing child process with pid -744... # 2010-11-08T14:45:30 Killing child process with pid -3080... # 2010-11-08T14:45:30 Killing child process with pid -2980... # 2010-11-08T14:45:30 Killing child process with pid -3824... # 2010-11-08T14:45:30 Killing child process with pid -1876... # 2010-11-08T14:45:30 Query: DELETE FROM B WHERE `pk` = '2007-09-04' LIMIT 2 failed: 2013 Lost connection to MySQL server during query # 2010-11-08T14:45:30 Server crash reported at dsn dbi:mysql:host=127.0.0.1:port=10010:user=root:database=test # 2010-11-08T14:45:30 Query: ROLLBACK failed: 2006 MySQL server has gone away # 2010-11-08T14:45:30 Server crash reported at dsn dbi:mysql:host=127.0.0.1:port=10010:user=root:database=test # 2010-11-08T14:45:30 Query: INSERT INTO B ( `col_varchar_key` , `col_datetime_nokey` ) VALUES ( ' x ' , '19:39:18' ) failed: 2013 Lost connection to MySQL server during query # 2010-11-08T14:45:30 Server crash reported at dsn dbi:mysql:host=127.0.0.1:port=10010:user=root:database=test # 2010-11-08T14:45:30 Query: SELECT COUNT( * ) FROM D AS X LEFT JOIN D AS Y ON ( X . `col_time_key` = Y . `col_date_nokey` ) ORDER BY X . `col_time_key` failed: 2013 Lost connection to MySQL server during query # 2010-11-08T14:45:30 Server crash reported at dsn dbi:mysql:host=127.0.0.1:port=10010:user=root:database=test # 2010-11-08T14:45:30 Query: START TRANSACTION failed: 2013 Lost connection to MySQL server during query # 2010-11-08T14:45:30 Server crash reported at dsn dbi:mysql:host=127.0.0.1:port=10010:user=root:database=test # 2010-11-08T14:45:30 Query: SELECT COUNT( * ) FROM C AS X LIMIT 0 failed: 2013 Lost connection to MySQL server during query # 2010-11-08T14:45:30 Server crash reported at dsn dbi:mysql:host=127.0.0.1:port=10010:user=root:database=test # 2010-11-08T14:45:30 Query: COMMIT failed: 2013 Lost connection to MySQL server during query # 2010-11-08T14:45:30 Server crash reported at dsn dbi:mysql:host=127.0.0.1:port=10010:user=root:database=test # 2010-11-08T14:45:31 Killing periodic reporting process with pid -1764... # 2010-11-08T14:45:32 Server crash reported, initiating post-crash analysis... # 2010-11-08T14:45:32 The last 100 lines from G:\pb2\scripts\tmp-qauser\5.5-bugteam_nov08_mysql-5.5.8-win-x86\mysql-test\var\run\master.err : 'tail' is not recognized as an internal or external command, operable program or batch file. # 2010-11-08T14:45:32 datadir is G:\pb2\scripts\tmp-qauser\5.5-bugteam_nov08_mysql-5.5.8-win-x86\mysql-test\var\master-data\ # 2010-11-08T14:45:32 binary is G:/pb2/scripts/tmp-qauser/5.5-bugteam_nov08_mysql-5.5.8-win-x86/mysql-test/../sql/Debug/mysqld.exe # 2010-11-08T14:45:32 bindir is G:/pb2/scripts/tmp-qauser/5.5-bugteam_nov08_mysql-5.5.8-win-x86/mysql-test/../sql/Debug # 2010-11-08T14:45:32 core is 'cdb' is not recognized as an internal or external command, operable program or batch file. # 2010-11-08T14:45:32 # 2010-11-08T14:45:33 Test completed with failure status STATUS_SERVER_CRASHED (101) # 2010-11-08T14:45:33 gentest.pl exited with exit status STATUS_SERVER_CRASHED (101) 2010-11-08T14:45:33 [3596] runall.pl will exit with exit status STATUS_SERVER_CRASHED (101)