perl runall-new.pl --basedir=/pxc --galera=ms --reporter=Shutdown,Backtrace,ErrorLog,ErrorLogAlarm,Deadlock --grammar=conf/galera/galera_stress.yy --gendata=conf/galera/galera_stress.zz --threads=16 --queries=1000 --mysqld=--wsrep-provider=/pxc/lib/libgalera_smm.so --mysqld=--innodb_flush_method=O_DIRECT # 2013-08-26T22:54:05 [34333] Using Log::Log4perl # 2013-08-26T22:54:05 [34333] Copyright (c) 2010,2011 Oracle and/or its affiliates. All rights reserved. Use is subject to license terms. # 2013-08-26T22:54:05 [34333] Please see http://forge.mysql.com/wiki/Category:RandomQueryGenerator for more information on this test framework. # 2013-08-26T22:54:05 [34333] Starting # 2013-08-26T22:54:05 [34333] # runall-new.pl \ # 2013-08-26T22:54:05 [34333] # --basedir=/pxc \ # 2013-08-26T22:54:05 [34333] # --galera=ms \ # 2013-08-26T22:54:05 [34333] # --reporter=Shutdown,Backtrace,ErrorLog,ErrorLogAlarm,Deadlock \ # 2013-08-26T22:54:05 [34333] # --grammar=conf/galera/galera_stress.yy \ # 2013-08-26T22:54:05 [34333] # --gendata=conf/galera/galera_stress.zz \ # 2013-08-26T22:54:05 [34333] # --threads=16 \ # 2013-08-26T22:54:05 [34333] # --queries=1000 \ # 2013-08-26T22:54:05 [34333] # --mysqld=--wsrep-provider=/pxc/lib/libgalera_smm.so \ # 2013-08-26T22:54:05 [34333] # --mysqld=--innodb_flush_method=O_DIRECT # 2013-08-26T22:54:05 [34333] master_port : 19300 slave_port : 19302 ports : 19300 19302 MTR_BUILD_THREAD : 930 # 2013-08-26T22:54:05 [34333] /media/Tintin/Work/code/randgen/pxc Revno: 897 # 2013-08-26T22:54:05 [34333] /media/Tintin/Work/code/randgen/pxc Revision-Id: raghavendra.prabhu@percona.com-20130816070557-262yfxsxv5hbd8br # 2013-08-26T22:54:05 [34333] /pxc does not look like a bzr branch, cannot get revision info. # 2013-08-26T22:54:06 [34333] Creating MySQL 5.5.33 database at /pxc/mysql-test/var/node0/data # 2013-08-26T22:54:13 [34333] Creating MySQL 5.5.33 database at /pxc/mysql-test/var/node1/data # 2013-08-26T22:54:20 [34333] MySQL Version:5.5.33 # 2013-08-26T22:54:20 [34333] Binary: /pxc/bin/mysqld # 2013-08-26T22:54:20 [34333] Type: Debug # 2013-08-26T22:54:20 [34333] Datadir: /pxc/mysql-test/var/node0/data # 2013-08-26T22:54:20 [34333] Tmpdir: /pxc/mysql-test/var/node0/tmp # 2013-08-26T22:54:20 [34333] Corefile: /pxc/mysql-test/var/node0/data/core. # 2013-08-26T22:54:20 [34333] Starting MySQL 5.5.33: "/pxc/bin/mysqld" "--no-defaults" "--basedir=/pxc" "--datadir=/pxc/mysql-test/var/node0/data" "--lc-messages-dir=/pxc/share/mysql" "--character-sets-dir=/pxc/share/mysql/charsets" "--tmpdir=/pxc/mysql-test/var/node0/tmp" "--core-file" "--max-allowed-packet=128Mb" "--port=19300" "--socket=/pxc/mysql-test/var/node0/mysql.sock" "--pid-file=/pxc/mysql-test/var/node0/mysql.pid" "--general-log" "--general-log-file=/pxc/mysql-test/var/node0/mysql.log" --wsrep_sst_method=rsync --innodb_autoinc_lock_mode=2 --default-storage-engine=InnoDB --innodb_locks_unsafe_for_binlog=1 --binlog-format=row --wsrep_node_incoming_address=127.0.0.1 --wsrep_node_address=127.0.0.1 --wsrep_cluster_address='gcomm://?gmcast.listen_addr=tcp://127.0.0.1:5215&pc.ignore_sb=true' --wsrep_sst_receive_address=127.0.0.1:5218 --wsrep-provider=/pxc/lib/libgalera_smm.so --innodb_flush_method=O_DIRECT # 2013-08-26T22:54:21 [34333] Cluster size after starting node 0: 1 # 2013-08-26T22:54:21 [34333] MySQL Version:5.5.33 # 2013-08-26T22:54:21 [34333] Binary: /pxc/bin/mysqld # 2013-08-26T22:54:21 [34333] Type: Debug # 2013-08-26T22:54:21 [34333] Datadir: /pxc/mysql-test/var/node1/data # 2013-08-26T22:54:21 [34333] Tmpdir: /pxc/mysql-test/var/node1/tmp # 2013-08-26T22:54:21 [34333] Corefile: /pxc/mysql-test/var/node1/data/core. # 2013-08-26T22:54:21 [34333] Starting MySQL 5.5.33: "/pxc/bin/mysqld" "--no-defaults" "--basedir=/pxc" "--datadir=/pxc/mysql-test/var/node1/data" "--lc-messages-dir=/pxc/share/mysql" "--character-sets-dir=/pxc/share/mysql/charsets" "--tmpdir=/pxc/mysql-test/var/node1/tmp" "--core-file" "--max-allowed-packet=128Mb" "--port=19301" "--socket=/pxc/mysql-test/var/node1/mysql.sock" "--pid-file=/pxc/mysql-test/var/node1/mysql.pid" "--general-log" "--general-log-file=/pxc/mysql-test/var/node1/mysql.log" --wsrep_sst_method=rsync --innodb_autoinc_lock_mode=2 --default-storage-engine=InnoDB --innodb_locks_unsafe_for_binlog=1 --binlog-format=row --wsrep_node_incoming_address=127.0.0.1 --wsrep_node_address=127.0.0.1 --wsrep_cluster_address='gcomm://127.0.0.1:5215?gmcast.listen_addr=tcp://127.0.0.1:5216&pc.ignore_sb=true' --wsrep_sst_receive_address=127.0.0.1:5219 --wsrep-provider=/pxc/lib/libgalera_smm.so --innodb_flush_method=O_DIRECT # 2013-08-26T22:54:29 [34333] Cluster size after starting node 1: 2 # 2013-08-26T22:54:29 [34333] ------------------------------- # 2013-08-26T22:54:29 [34333] Configuration # 2013-08-26T22:54:29 [34333] debug_server => ['', ''] # 2013-08-26T22:54:29 [34333] dsn => ['dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test'] # 2013-08-26T22:54:29 [34333] duration => 3600 # 2013-08-26T22:54:29 [34333] gendata => conf/galera/galera_stress.zz # 2013-08-26T22:54:29 [34333] generator => FromGrammar # 2013-08-26T22:54:29 [34333] grammar => conf/galera/galera_stress.yy # 2013-08-26T22:54:29 [34333] queries => 1000 # 2013-08-26T22:54:29 [34333] reporters => ['Shutdown', 'Backtrace', 'ErrorLog', 'ErrorLogAlarm', 'Deadlock'] # 2013-08-26T22:54:29 [34333] servers => ['DBServer::MySQL::MySQLd=ARRAY(0x2ab2568)', 'DBServer::MySQL::MySQLd=ARRAY(0x2ac0708)'] # 2013-08-26T22:54:29 [34333] threads => 16 # 2013-08-26T22:54:29 [34333] views => ['', ''] # 2013-08-26T22:54:29 [34333] # Creating MySQL table: test.table0_innodb_int; engine: innodb; rows: 0 . # 2013-08-26T22:54:29 [34333] # Creating MySQL table: test.table0_innodb_int_autoinc; engine: innodb; rows: 0 . # 2013-08-26T22:54:29 [34333] # Creating MySQL table: test.table0_innodb_key_pk_parts_2_int; engine: innodb; rows: 0 . # 2013-08-26T22:54:30 [34333] # Creating MySQL table: test.table0_innodb_key_pk_parts_2_int_autoinc; engine: innodb; rows: 0 . # 2013-08-26T22:54:30 [34333] # Creating MySQL table: test.table1_innodb_int; engine: innodb; rows: 1 . # 2013-08-26T22:54:30 [34333] # Creating MySQL table: test.table1_innodb_int_autoinc; engine: innodb; rows: 1 . # 2013-08-26T22:54:30 [34333] # Creating MySQL table: test.table1_innodb_key_pk_parts_2_int; engine: innodb; rows: 1 . # 2013-08-26T22:54:30 [34333] # Creating MySQL table: test.table1_innodb_key_pk_parts_2_int_autoinc; engine: innodb; rows: 1 . # 2013-08-26T22:54:31 [34333] # Creating MySQL table: test.table100_innodb_int; engine: innodb; rows: 100 . # 2013-08-26T22:54:31 [34333] # Creating MySQL table: test.table100_innodb_int_autoinc; engine: innodb; rows: 100 . # 2013-08-26T22:54:31 [34333] # Creating MySQL table: test.table100_innodb_key_pk_parts_2_int; engine: innodb; rows: 100 . # 2013-08-26T22:54:32 [34333] # Creating MySQL table: test.table100_innodb_key_pk_parts_2_int_autoinc; engine: innodb; rows: 100 . # 2013-08-26T22:54:32 [34333] # Creating MySQL table: test.table1000_innodb_int; engine: innodb; rows: 1000 . # 2013-08-26T22:54:33 [34333] # Creating MySQL table: test.table1000_innodb_int_autoinc; engine: innodb; rows: 1000 . # 2013-08-26T22:54:33 [34333] # Creating MySQL table: test.table1000_innodb_key_pk_parts_2_int; engine: innodb; rows: 1000 . # 2013-08-26T22:54:34 [34333] # Creating MySQL table: test.table1000_innodb_key_pk_parts_2_int_autoinc; engine: innodb; rows: 1000 . # 2013-08-26T22:54:35 [34333] Reporters: Shutdown, Backtrace, ErrorLog, ErrorLogAlarm, Deadlock # 2013-08-26T22:54:35 [34333] Validators: ErrorMessageCorruption # 2013-08-26T22:54:35 [34333] Caching schema metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2013-08-26T22:54:35 [34333] Starting 16 processes, 1000 queries each, duration 3600 seconds. # 2013-08-26T22:54:35 [34333] GenTest::ErrorFilter(34867) started # 2013-08-26T22:54:35 [34869] Loading Validator GenTest::Validator::ErrorMessageCorruption. # 2013-08-26T22:54:36 [34871] Loading Validator GenTest::Validator::ErrorMessageCorruption. # 2013-08-26T22:54:36 [34873] Loading Validator GenTest::Validator::ErrorMessageCorruption. # 2013-08-26T22:54:36 [34867] Query: INSERT INTO `table100_innodb_int` ( `col_char_12_key` , `col_char_12_key` ) VALUES ( 250 , 's' ) , ( 'z' , 245 ) failed: 1110 Column '%s' specified twice. Further errors of this kind will be suppressed. # 2013-08-26T22:54:36 [34875] Loading Validator GenTest::Validator::ErrorMessageCorruption. # 2013-08-26T22:54:36 [34877] Loading Validator GenTest::Validator::ErrorMessageCorruption. # 2013-08-26T22:54:36 [34879] Loading Validator GenTest::Validator::ErrorMessageCorruption. # 2013-08-26T22:54:36 [34881] Loading Validator GenTest::Validator::ErrorMessageCorruption. # 2013-08-26T22:54:36 [34867] Query: ROLLBACK TO SAVEPOINT A failed: 1305 SAVEPOINT %s does not exist. Further errors of this kind will be suppressed. # 2013-08-26T22:54:36 [34883] Loading Validator GenTest::Validator::ErrorMessageCorruption. # 2013-08-26T22:54:36 [34885] Loading Validator GenTest::Validator::ErrorMessageCorruption. # 2013-08-26T22:54:36 [34887] Loading Validator GenTest::Validator::ErrorMessageCorruption. # 2013-08-26T22:54:36 [34889] Loading Validator GenTest::Validator::ErrorMessageCorruption. # 2013-08-26T22:54:37 [34891] Loading Validator GenTest::Validator::ErrorMessageCorruption. # 2013-08-26T22:54:37 [34893] Loading Validator GenTest::Validator::ErrorMessageCorruption. # 2013-08-26T22:54:37 [34895] Loading Validator GenTest::Validator::ErrorMessageCorruption. # 2013-08-26T22:54:37 [34897] Loading Validator GenTest::Validator::ErrorMessageCorruption. # 2013-08-26T22:54:37 [34899] Loading Validator GenTest::Validator::ErrorMessageCorruption. # 2013-08-26T22:54:37 [34868] Started periodic reporting process... # 2013-08-26T22:54:37 [34868] ErrorLogAlarm Reporter will monitor the log file /pxc/mysql-test/var/node0/data/../mysql.err # 2013-08-26T22:54:38 [34867] Query: INSERT INTO `table1000_innodb_key_pk_parts_2_int` ( `col_int_key` , `col_char_12` ) VALUES ( 'y' , 436535296 ) , ( 'a' , 0 ) failed: 1062 Duplicate entry '%s' for key '%s'. Further errors of this kind will be suppressed. # 2013-08-26T22:54:38 [34867] Query: REPLACE INTO `table0_innodb_int_autoinc` ( `col_char_12` ) SELECT `col_char_12_key` FROM `table0_innodb_int` AS X ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 5 failed: 1213 Deadlock found when trying to get lock; try restarting transaction. Further errors of this kind will be suppressed. # 2013-08-26T22:54:58 [34867] Query: ALTER TABLE `table1_innodb_int` MODIFY `col_char_12` FLOAT NOT NULL DEFAULT 0 AFTER `col_char_12` failed: 1054 Unknown column '%s' in 'table%d_innodb_int'. Further errors of this kind will be suppressed. # 2013-08-26T22:54:58 [34899] Query: REPLACE INTO `table100_innodb_int_autoinc` ( `col_char_12_key` ) SELECT `col_char_12_key` FROM `table1000_innodb_key_pk_parts_2_int_autoinc` AS X ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 6 failed: 1467 Failed to read auto-increment value from storage engine # 2013-08-26T22:55:08 [34891] Query: ALTER TABLE `table1000_innodb_key_pk_parts_2_int_autoinc` MODIFY `col_char_12_key` CHAR( 0 ) NOT NULL DEFAULT 0 failed: 1167 The used storage engine can't index column 'col_char_12_key' # 2013-08-26T22:55:17 [34868] ALARM from ErrorLogAlarm reporter: Pattern '^Error:|^ERROR|\[ERROR\]|allocated at line|missing DBUG_RETURN|^safe_mutex:|Invalid.*old.*table or database|InnoDB: Warning|InnoDB: Error:|InnoDB: Operating system error|Error while setting value|\[Warning\] Invalid' was found in error log. Matching line was: # 2013-08-26T22:55:17 [34868] 130826 22:55:14 [ERROR] /pxc/bin/mysqld: Got error -1 from storage engine # 2013-08-26T22:55:26 [34867] Query: ALTER TABLE `table100_innodb_int_autoinc` MODIFY `col_char_12` INT NULL DEFAULT NULL AFTER `col_char_12` failed: 1054 Unknown column '%s' in 'table%d_innodb_int_autoinc'. Further errors of this kind will be suppressed. # 2013-08-26T22:56:19 [34867] Query: UPDATE `table1000_innodb_key_pk_parts_2_int` AS X SET `col_char_12_key` = 9 WHERE X . `col_int_key` IN ( 5 , 0 , 'n' , 65 , 3276800000 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 5 failed: 1205 Lock wait timeout exceeded; try restarting transaction. Further errors of this kind will be suppressed. # 2013-08-26T22:56:21 [34867] Query: ALTER TABLE `table1000_innodb_key_pk_parts_2_int` MODIFY `col_char_12_key` DECIMAL NULL DEFAULT NULL AFTER `col_char_12_key` failed: 1054 Unknown column '%s' in 'table%d_innodb_key_pk_parts_%d_int'. Further errors of this kind will be suppressed. # 2013-08-26T23:01:00 [34885] Query: INSERT IGNORE INTO `table100_innodb_int_autoinc` ( `col_char_12_key` ) SELECT `col_int_key` FROM `table100_innodb_key_pk_parts_2_int` AS X ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 7 failed: 1467 Failed to read auto-increment value from storage engine # 2013-08-26T23:01:08 [34867] Query: ALTER TABLE `table1_innodb_key_pk_parts_2_int_autoinc` MODIFY `col_int` VARCHAR ( 0 ) NOT NULL DEFAULT 0 AFTER `col_int` failed: 1054 Unknown column '%s' in 'table%d_innodb_key_pk_parts_%d_int_autoinc'. Further errors of this kind will be suppressed. # 2013-08-26T23:02:11 [34875] Query: ALTER TABLE `table1_innodb_key_pk_parts_2_int` MODIFY `col_int_key` VARCHAR ( 0 ) FIRST failed: 1167 The used storage engine can't index column 'col_int_key' # 2013-08-26T23:02:34 [34877] Query: INSERT IGNORE INTO `table100_innodb_int_autoinc` ( `col_char_12_key` ) SELECT `col_char_12_key` FROM `table100_innodb_key_pk_parts_2_int_autoinc` AS X WHERE X . `col_char_12_key` IN ( 'q' , 'm' , 2 , 122 , 3051552768 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 8 failed: 1467 Failed to read auto-increment value from storage engine