# 2019-07-29T19:59:58 [167700] Using Log::Log4perl # 2019-07-29T19:59:58 [167700] DEBUG: rqg_home might be ->/home/mleich/work/RQG_mleich2<- # 2019-07-29T19:59:58 [167700] INFO: Environment variable 'RQG_HOME' set to '/home/mleich/work/RQG_mleich2' # DEBUG: $0 ->/home/mleich/work/RQG_mleich2/rqg.pl<- # DEBUG: rqg_home_call ->/home/mleich/work/RQG_mleich2<- # DEBUG: rqg_home_env ->/home/mleich/work/RQG_mleich2<- # DEBUG: start_cwd ->/home/mleich/work/RQG_mleich2<- # 2019-07-29T19:59:58 [167700] INFO: script_debug : # 2019-07-29T19:59:58 [167700] script_debug -><- # 2019-07-29T19:59:58 [167700] DEBUG: After reading command line options # 2019-07-29T19:59:58 [167700] INFO: RQG workdir : '/home/mleich/work/RQG_mleich2/storage/1564423196/9' and infrastructure is prepared. # 2019-07-29T19:59:58 [167700] INFO: RQG archiver_call : # 2019-07-29T19:59:58 [167700] DEBUG: Initial gendata_sql_files files : ->conf/mariadb/table_stress.sql<- # 2019-07-29T19:59:58 [167700] DEBUG: no_mask is defind. Therefore setting mask_level=0 , mask=0 and no_mask=undef. # 2019-07-29T19:59:58 [167700] Reading grammar from file '/home/mleich/work/RQG_mleich2/storage/1564423196/c00000.yy'. # 2019-07-29T19:59:58 [167700] DEBUG: grammar_string -----BEGIN ----- # 2019-07-29T19:59:58 [167700] §_split_§ # 2019-07-29T19:59:58 [167700] thread1: # 2019-07-29T19:59:58 [167700] ALTER TABLE t4 ADD COLUMN IF NOT EXISTS col_string_g CHAR(13) GENERATED ALWAYS AS (SUBSTR(col_string,4,13)) VIRTUAL , ALGORITHM = NOCOPY , LOCK = SHARED ; ALTER TABLE t4 DROP COLUMN IF EXISTS col_string_g , ALGORITHM = NOCOPY , LOCK = SHARED §_split_§ # 2019-07-29T19:59:58 [167700] thread1_connect: # 2019-07-29T19:59:58 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 §_split_§ # 2019-07-29T19:59:58 [167700] thread1_init: # 2019-07-29T19:59:58 [167700] CREATE TABLE t3 ( col1 INT, col2 INT , UNIQUE KEY uidx3 ( col2 ) ) ENGINE = InnoDB ROW_FORMAT = Compact ; CREATE TABLE t4 ( col1 INT , col_string CHAR(19) ) ENGINE = InnoDB §_split_§ # 2019-07-29T19:59:58 [167700] thread2: # 2019-07-29T19:59:58 [167700] CHECK TABLE t3 §_split_§ # 2019-07-29T19:59:58 [167700] thread2_connect: # 2019-07-29T19:59:58 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 §_split_§ # 2019-07-29T19:59:58 [167700] thread2_init: # 2019-07-29T19:59:58 [167700] §_split_§ # 2019-07-29T19:59:58 [167700] thread3: # 2019-07-29T19:59:58 [167700] INSERT INTO t3 (col1,col2) VALUES ( { $my_int= $prng->int(513, 4096) } , $my_int ); COMMIT §_split_§ # 2019-07-29T19:59:58 [167700] thread3_connect: # 2019-07-29T19:59:58 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 §_split_§ # 2019-07-29T19:59:58 [167700] thread3_init: # 2019-07-29T19:59:58 [167700] §_split_§ # 2019-07-29T19:59:58 [167700] DEBUG: grammar_string -----END ------- # 2019-07-29T19:59:58 [167700] DEBUG: grammar_string after splitting -----BEGIN ----- # 2019-07-29T19:59:58 [167700] # 2019-07-29T19:59:58 [167700] thread1: # 2019-07-29T19:59:58 [167700] ALTER TABLE t4 ADD COLUMN IF NOT EXISTS col_string_g CHAR(13) GENERATED ALWAYS AS (SUBSTR(col_string,4,13)) VIRTUAL , ALGORITHM = NOCOPY , LOCK = SHARED ; ALTER TABLE t4 DROP COLUMN IF EXISTS col_string_g , ALGORITHM = NOCOPY , LOCK = SHARED # 2019-07-29T19:59:58 [167700] thread1_connect: # 2019-07-29T19:59:58 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 # 2019-07-29T19:59:58 [167700] thread1_init: # 2019-07-29T19:59:58 [167700] CREATE TABLE t3 ( col1 INT, col2 INT , UNIQUE KEY uidx3 ( col2 ) ) ENGINE = InnoDB ROW_FORMAT = Compact ; CREATE TABLE t4 ( col1 INT , col_string CHAR(19) ) ENGINE = InnoDB # 2019-07-29T19:59:58 [167700] thread2: # 2019-07-29T19:59:58 [167700] CHECK TABLE t3 # 2019-07-29T19:59:58 [167700] thread2_connect: # 2019-07-29T19:59:58 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 # 2019-07-29T19:59:58 [167700] thread2_init: # 2019-07-29T19:59:58 [167700] # 2019-07-29T19:59:58 [167700] thread3: # 2019-07-29T19:59:58 [167700] INSERT INTO t3 (col1,col2) VALUES ( { $my_int= $prng->int(513, 4096) } , $my_int ); COMMIT # 2019-07-29T19:59:58 [167700] thread3_connect: # 2019-07-29T19:59:58 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 # 2019-07-29T19:59:58 [167700] thread3_init: # 2019-07-29T19:59:58 [167700] # 2019-07-29T19:59:58 [167700] DEBUG: grammar_string after splitting -----END ------- # 2019-07-29T19:59:58 [167700] DEBUG: Rule '' rule_string -><- components_string -><- # 2019-07-29T19:59:58 [167700] DEBUG: Rule ' # 2019-07-29T19:59:58 [167700] thread1' rule_string -> # 2019-07-29T19:59:58 [167700] thread1: # 2019-07-29T19:59:58 [167700] ALTER TABLE t4 ADD COLUMN IF NOT EXISTS col_string_g CHAR(13) GENERATED ALWAYS AS (SUBSTR(col_string,4,13)) VIRTUAL , ALGORITHM = NOCOPY , LOCK = SHARED ; ALTER TABLE t4 DROP COLUMN IF EXISTS col_string_g , ALGORITHM = NOCOPY , LOCK = SHARED <- components_string -> # 2019-07-29T19:59:58 [167700] ALTER TABLE t4 ADD COLUMN IF NOT EXISTS col_string_g CHAR(13) GENERATED ALWAYS AS (SUBSTR(col_string,4,13)) VIRTUAL , ALGORITHM = NOCOPY , LOCK = SHARED ; ALTER TABLE t4 DROP COLUMN IF EXISTS col_string_g , ALGORITHM = NOCOPY , LOCK = SHARED <- # 2019-07-29T19:59:58 [167700] DEBUG: Rule ' # 2019-07-29T19:59:58 [167700] thread1_connect' rule_string -> # 2019-07-29T19:59:58 [167700] thread1_connect: # 2019-07-29T19:59:58 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 <- components_string -> # 2019-07-29T19:59:58 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 <- # 2019-07-29T19:59:58 [167700] DEBUG: Rule ' # 2019-07-29T19:59:58 [167700] thread1_init' rule_string -> # 2019-07-29T19:59:58 [167700] thread1_init: # 2019-07-29T19:59:58 [167700] CREATE TABLE t3 ( col1 INT, col2 INT , UNIQUE KEY uidx3 ( col2 ) ) ENGINE = InnoDB ROW_FORMAT = Compact ; CREATE TABLE t4 ( col1 INT , col_string CHAR(19) ) ENGINE = InnoDB <- components_string -> # 2019-07-29T19:59:58 [167700] CREATE TABLE t3 ( col1 INT, col2 INT , UNIQUE KEY uidx3 ( col2 ) ) ENGINE = InnoDB ROW_FORMAT = Compact ; CREATE TABLE t4 ( col1 INT , col_string CHAR(19) ) ENGINE = InnoDB <- # 2019-07-29T19:59:58 [167700] DEBUG: Rule ' # 2019-07-29T19:59:58 [167700] thread2' rule_string -> # 2019-07-29T19:59:58 [167700] thread2: # 2019-07-29T19:59:58 [167700] CHECK TABLE t3 <- components_string -> # 2019-07-29T19:59:58 [167700] CHECK TABLE t3 <- # 2019-07-29T19:59:58 [167700] DEBUG: Rule ' # 2019-07-29T19:59:58 [167700] thread2_connect' rule_string -> # 2019-07-29T19:59:58 [167700] thread2_connect: # 2019-07-29T19:59:58 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 <- components_string -> # 2019-07-29T19:59:58 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 <- # 2019-07-29T19:59:58 [167700] DEBUG: Rule ' # 2019-07-29T19:59:58 [167700] thread2_init' rule_string -> # 2019-07-29T19:59:58 [167700] thread2_init: # 2019-07-29T19:59:58 [167700] <- components_string -> # 2019-07-29T19:59:58 [167700] <- # 2019-07-29T19:59:58 [167700] DEBUG: Rule ' # 2019-07-29T19:59:58 [167700] thread3' rule_string -> # 2019-07-29T19:59:58 [167700] thread3: # 2019-07-29T19:59:58 [167700] INSERT INTO t3 (col1,col2) VALUES ( { $my_int= $prng->int(513, 4096) } , $my_int ); COMMIT <- components_string -> # 2019-07-29T19:59:58 [167700] INSERT INTO t3 (col1,col2) VALUES ( { $my_int= $prng->int(513, 4096) } , $my_int ); COMMIT <- # 2019-07-29T19:59:58 [167700] DEBUG: Rule ' # 2019-07-29T19:59:58 [167700] thread3_connect' rule_string -> # 2019-07-29T19:59:58 [167700] thread3_connect: # 2019-07-29T19:59:58 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 <- components_string -> # 2019-07-29T19:59:58 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 <- # 2019-07-29T19:59:58 [167700] DEBUG: Rule ' # 2019-07-29T19:59:58 [167700] thread3_init' rule_string -> # 2019-07-29T19:59:58 [167700] thread3_init: # 2019-07-29T19:59:58 [167700] <- components_string -> # 2019-07-29T19:59:58 [167700] <- # 2019-07-29T19:59:58 [167700] MLML grammar_string after fiddling 1 -----BEGIN ----- # 2019-07-29T19:59:58 [167700] # 2019-07-29T19:59:58 [167700] thread1: # 2019-07-29T19:59:58 [167700] ALTER TABLE t4 ADD COLUMN IF NOT EXISTS col_string_g CHAR(13) GENERATED ALWAYS AS (SUBSTR(col_string,4,13)) VIRTUAL , ALGORITHM = NOCOPY , LOCK = SHARED ; ALTER TABLE t4 DROP COLUMN IF EXISTS col_string_g , ALGORITHM = NOCOPY , LOCK = SHARED # 2019-07-29T19:59:58 [167700] thread1_connect: # 2019-07-29T19:59:58 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 # 2019-07-29T19:59:58 [167700] thread1_init: # 2019-07-29T19:59:58 [167700] CREATE TABLE t3 ( col1 INT, col2 INT , UNIQUE KEY uidx3 ( col2 ) ) ENGINE = InnoDB ROW_FORMAT = Compact ; CREATE TABLE t4 ( col1 INT , col_string CHAR(19) ) ENGINE = InnoDB # 2019-07-29T19:59:58 [167700] thread2: # 2019-07-29T19:59:58 [167700] CHECK TABLE t3 # 2019-07-29T19:59:58 [167700] thread2_connect: # 2019-07-29T19:59:58 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 # 2019-07-29T19:59:58 [167700] thread2_init: # 2019-07-29T19:59:58 [167700] # 2019-07-29T19:59:58 [167700] thread3: # 2019-07-29T19:59:58 [167700] INSERT INTO t3 (col1,col2) VALUES ( { $my_int= $prng->int(513, 4096) } , $my_int ); COMMIT # 2019-07-29T19:59:58 [167700] thread3_connect: # 2019-07-29T19:59:58 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 # 2019-07-29T19:59:58 [167700] thread3_init: # 2019-07-29T19:59:58 [167700] # 2019-07-29T19:59:58 [167700] MLML grammar_string after fiddling 1 -----END ------- # 2019-07-29T19:59:58 [167700] MLML grammar_string after fiddling 2 -----BEGIN ----- # 2019-07-29T19:59:58 [167700] # 2019-07-29T19:59:58 [167700] thread1: # 2019-07-29T19:59:58 [167700] ALTER TABLE t4 ADD COLUMN IF NOT EXISTS col_string_g CHAR(13) GENERATED ALWAYS AS (SUBSTR(col_string,4,13)) VIRTUAL , ALGORITHM = NOCOPY , LOCK = SHARED ; ALTER TABLE t4 DROP COLUMN IF EXISTS col_string_g , ALGORITHM = NOCOPY , LOCK = SHARED # 2019-07-29T19:59:58 [167700] thread1_connect: # 2019-07-29T19:59:58 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 # 2019-07-29T19:59:58 [167700] thread1_init: # 2019-07-29T19:59:58 [167700] CREATE TABLE t3 ( col1 INT, col2 INT , UNIQUE KEY uidx3 ( col2 ) ) ENGINE = InnoDB ROW_FORMAT = Compact ; CREATE TABLE t4 ( col1 INT , col_string CHAR(19) ) ENGINE = InnoDB # 2019-07-29T19:59:58 [167700] thread2: # 2019-07-29T19:59:58 [167700] CHECK TABLE t3 # 2019-07-29T19:59:58 [167700] thread2_connect: # 2019-07-29T19:59:58 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 # 2019-07-29T19:59:58 [167700] thread2_init: # 2019-07-29T19:59:58 [167700] # 2019-07-29T19:59:58 [167700] thread3: # 2019-07-29T19:59:58 [167700] INSERT INTO t3 (col1,col2) VALUES ( { $my_int= $prng->int(513, 4096) } , $my_int ); COMMIT # 2019-07-29T19:59:58 [167700] thread3_connect: # 2019-07-29T19:59:58 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 # 2019-07-29T19:59:58 [167700] thread3_init: # 2019-07-29T19:59:58 [167700] # 2019-07-29T19:59:58 [167700] MLML grammar_string after fiddling 2 -----END ------- # 2019-07-29T19:59:58 [167700] MLML: Rule 'thread3_init' -> # 2019-07-29T19:59:58 [167700] <- # 2019-07-29T19:59:58 [167700] MLML: Rule 'thread3_init' components_string is now -><- # 2019-07-29T19:59:58 [167700] MLML: Rule 'thread3_init' components_string is empty. # 2019-07-29T19:59:58 [167700] MLML: Rule 'thread3_init' component_string initial : # 2019-07-29T19:59:58 [167700] MLML: Rule 'thread3_init' component_string after stripping whitespaces : # 2019-07-29T19:59:58 [167700] MLML: Rule 'thread3_init' component_string is empty. # 2019-07-29T19:59:58 [167700] MLML: Rule 'thread3_connect' -> # 2019-07-29T19:59:58 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 <- # 2019-07-29T19:59:58 [167700] MLML: Rule 'thread3_connect' components_string is now -> # 2019-07-29T19:59:58 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1<- # 2019-07-29T19:59:58 [167700] MLML: Rule 'thread3_connect' component_string initial : # 2019-07-29T19:59:58 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 # 2019-07-29T19:59:58 [167700] MLML: Rule 'thread3_connect' component_string after stripping whitespaces : SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 # 2019-07-29T19:59:58 [167700] MLML: Rule 'thread2_init' -> # 2019-07-29T19:59:58 [167700] <- # 2019-07-29T19:59:58 [167700] MLML: Rule 'thread2_init' components_string is now -><- # 2019-07-29T19:59:58 [167700] MLML: Rule 'thread2_init' components_string is empty. # 2019-07-29T19:59:58 [167700] MLML: Rule 'thread2_init' component_string initial : # 2019-07-29T19:59:58 [167700] MLML: Rule 'thread2_init' component_string after stripping whitespaces : # 2019-07-29T19:59:58 [167700] MLML: Rule 'thread2_init' component_string is empty. # 2019-07-29T19:59:58 [167700] MLML: Rule 'thread2' -> # 2019-07-29T19:59:58 [167700] CHECK TABLE t3 <- # 2019-07-29T19:59:58 [167700] MLML: Rule 'thread2' components_string is now -> # 2019-07-29T19:59:58 [167700] CHECK TABLE t3<- # 2019-07-29T19:59:58 [167700] MLML: Rule 'thread2' component_string initial : # 2019-07-29T19:59:58 [167700] CHECK TABLE t3 # 2019-07-29T19:59:58 [167700] MLML: Rule 'thread2' component_string after stripping whitespaces : CHECK TABLE t3 # 2019-07-29T19:59:58 [167700] MLML: Rule 'thread2_connect' -> # 2019-07-29T19:59:58 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 <- # 2019-07-29T19:59:58 [167700] MLML: Rule 'thread2_connect' components_string is now -> # 2019-07-29T19:59:58 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1<- # 2019-07-29T19:59:58 [167700] MLML: Rule 'thread2_connect' component_string initial : # 2019-07-29T19:59:58 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 # 2019-07-29T19:59:58 [167700] MLML: Rule 'thread2_connect' component_string after stripping whitespaces : SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 # 2019-07-29T19:59:58 [167700] MLML: Rule 'thread1' -> # 2019-07-29T19:59:58 [167700] ALTER TABLE t4 ADD COLUMN IF NOT EXISTS col_string_g CHAR(13) GENERATED ALWAYS AS (SUBSTR(col_string,4,13)) VIRTUAL , ALGORITHM = NOCOPY , LOCK = SHARED ; ALTER TABLE t4 DROP COLUMN IF EXISTS col_string_g , ALGORITHM = NOCOPY , LOCK = SHARED <- # 2019-07-29T19:59:58 [167700] MLML: Rule 'thread1' components_string is now -> # 2019-07-29T19:59:58 [167700] ALTER TABLE t4 ADD COLUMN IF NOT EXISTS col_string_g CHAR(13) GENERATED ALWAYS AS (SUBSTR(col_string,4,13)) VIRTUAL , ALGORITHM = NOCOPY , LOCK = SHARED ; ALTER TABLE t4 DROP COLUMN IF EXISTS col_string_g , ALGORITHM = NOCOPY , LOCK = SHARED<- # 2019-07-29T19:59:58 [167700] MLML: Rule 'thread1' component_string initial : # 2019-07-29T19:59:58 [167700] ALTER TABLE t4 ADD COLUMN IF NOT EXISTS col_string_g CHAR(13) GENERATED ALWAYS AS (SUBSTR(col_string,4,13)) VIRTUAL , ALGORITHM = NOCOPY , LOCK = SHARED ; ALTER TABLE t4 DROP COLUMN IF EXISTS col_string_g , ALGORITHM = NOCOPY , LOCK = SHARED # 2019-07-29T19:59:58 [167700] MLML: Rule 'thread1' component_string after stripping whitespaces : ALTER TABLE t4 ADD COLUMN IF NOT EXISTS col_string_g CHAR(13) GENERATED ALWAYS AS (SUBSTR(col_string,4,13)) VIRTUAL , ALGORITHM = NOCOPY , LOCK = SHARED ; ALTER TABLE t4 DROP COLUMN IF EXISTS col_string_g , ALGORITHM = NOCOPY , LOCK = SHARED # 2019-07-29T19:59:58 [167700] MLML: Rule 'thread1_init' -> # 2019-07-29T19:59:58 [167700] CREATE TABLE t3 ( col1 INT, col2 INT , UNIQUE KEY uidx3 ( col2 ) ) ENGINE = InnoDB ROW_FORMAT = Compact ; CREATE TABLE t4 ( col1 INT , col_string CHAR(19) ) ENGINE = InnoDB <- # 2019-07-29T19:59:58 [167700] MLML: Rule 'thread1_init' components_string is now -> # 2019-07-29T19:59:58 [167700] CREATE TABLE t3 ( col1 INT, col2 INT , UNIQUE KEY uidx3 ( col2 ) ) ENGINE = InnoDB ROW_FORMAT = Compact ; CREATE TABLE t4 ( col1 INT , col_string CHAR(19) ) ENGINE = InnoDB<- # 2019-07-29T19:59:58 [167700] MLML: Rule 'thread1_init' component_string initial : # 2019-07-29T19:59:58 [167700] CREATE TABLE t3 ( col1 INT, col2 INT , UNIQUE KEY uidx3 ( col2 ) ) ENGINE = InnoDB ROW_FORMAT = Compact ; CREATE TABLE t4 ( col1 INT , col_string CHAR(19) ) ENGINE = InnoDB # 2019-07-29T19:59:58 [167700] MLML: Rule 'thread1_init' component_string after stripping whitespaces : CREATE TABLE t3 ( col1 INT, col2 INT , UNIQUE KEY uidx3 ( col2 ) ) ENGINE = InnoDB ROW_FORMAT = Compact ; CREATE TABLE t4 ( col1 INT , col_string CHAR(19) ) ENGINE = InnoDB # 2019-07-29T19:59:58 [167700] MLML: Rule 'thread3' -> # 2019-07-29T19:59:58 [167700] INSERT INTO t3 (col1,col2) VALUES ( { $my_int= $prng->int(513, 4096) } , $my_int ); COMMIT <- # 2019-07-29T19:59:58 [167700] MLML: Rule 'thread3' components_string is now -> # 2019-07-29T19:59:58 [167700] INSERT INTO t3 (col1,col2) VALUES ( { $my_int= $prng->int(513, 4096) } , $my_int ); COMMIT<- # 2019-07-29T19:59:58 [167700] MLML: Rule 'thread3' component_string initial : # 2019-07-29T19:59:58 [167700] INSERT INTO t3 (col1,col2) VALUES ( { $my_int= $prng->int(513, 4096) } , $my_int ); COMMIT # 2019-07-29T19:59:58 [167700] MLML: Rule 'thread3' component_string after stripping whitespaces : INSERT INTO t3 (col1,col2) VALUES ( { $my_int= $prng->int(513, 4096) } , $my_int ); COMMIT # 2019-07-29T19:59:58 [167700] MLML: Rule 'thread1_connect' -> # 2019-07-29T19:59:58 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 <- # 2019-07-29T19:59:58 [167700] MLML: Rule 'thread1_connect' components_string is now -> # 2019-07-29T19:59:58 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1<- # 2019-07-29T19:59:58 [167700] MLML: Rule 'thread1_connect' component_string initial : # 2019-07-29T19:59:58 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 # 2019-07-29T19:59:58 [167700] MLML: Rule 'thread1_connect' component_string after stripping whitespaces : SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 # 2019-07-29T19:59:58 [167700] Copyright (c) 2010,2011 Oracle and/or its affiliates. All rights reserved. Use is subject to license terms. # 2019-07-29T19:59:58 [167700] Please see http://forge.mysql.com/wiki/Category:RandomQueryGenerator for more information on this test framework. # 2019-07-29T19:59:58 [167700] Starting # 2019-07-29T19:59:58 [167700] # /home/mleich/work/RQG_mleich2/rqg.pl \ # 2019-07-29T19:59:58 [167700] # --duration=300 \ # 2019-07-29T19:59:58 [167700] # --queries=1000000 \ # 2019-07-29T19:59:58 [167700] # --threads=3 \ # 2019-07-29T19:59:58 [167700] # --no_mask \ # 2019-07-29T19:59:58 [167700] # --seed=random \ # 2019-07-29T19:59:58 [167700] # --rpl_mode=none \ # 2019-07-29T19:59:58 [167700] # --noarchiving \ # 2019-07-29T19:59:58 [167700] # --gendata=conf/mariadb/table_stress.zz \ # 2019-07-29T19:59:58 [167700] # --gendata_sql=conf/mariadb/table_stress.sql \ # 2019-07-29T19:59:58 [167700] # --engine=InnoDB \ # 2019-07-29T19:59:58 [167700] # --mysqld=--log-output=none \ # 2019-07-29T19:59:58 [167700] # --mysqld=--net_read_timeout=30 \ # 2019-07-29T19:59:58 [167700] # --mysqld=--net_write_timeout=60 \ # 2019-07-29T19:59:58 [167700] # --mysqld=--loose-table_lock_wait_timeout=50 \ # 2019-07-29T19:59:58 [167700] # --mysqld=--loose-idle_write_transaction_timeout=0 \ # 2019-07-29T19:59:58 [167700] # --mysqld=--innodb_stats_persistent=off \ # 2019-07-29T19:59:58 [167700] # --mysqld=--loose-idle_transaction_timeout=0 \ # 2019-07-29T19:59:58 [167700] # --mysqld=--lock-wait-timeout=86400 \ # 2019-07-29T19:59:58 [167700] # --mysqld=--loose_innodb_use_native_aio=0 \ # 2019-07-29T19:59:58 [167700] # --mysqld=--wait_timeout=28800 \ # 2019-07-29T19:59:58 [167700] # --mysqld=--loose_innodb_lock_schedule_algorithm=fcfs \ # 2019-07-29T19:59:58 [167700] # --mysqld=--loose-idle_readonly_transaction_timeout=0 \ # 2019-07-29T19:59:58 [167700] # --mysqld=--innodb-lock-wait-timeout=50 \ # 2019-07-29T19:59:58 [167700] # --mysqld=--slave_net_timeout=60 \ # 2019-07-29T19:59:58 [167700] # --mysqld=--connect_timeout=60 \ # 2019-07-29T19:59:58 [167700] # --mysqld=--interactive_timeout=28800 \ # 2019-07-29T19:59:58 [167700] # --whitelist_statuses='STATUS_SERVER_CRASHED' \ # 2019-07-29T19:59:58 [167700] # --whitelist_patterns='InnoDB: Failing assertion: \(block\)->index \|\| \(block\)->n_pointers == 0','InnoDB: Failing assertion: \(block\)->n_pointers == 0' \ # 2019-07-29T19:59:58 [167700] # --blacklist_statuses='STATUS_OK','STATUS_SERVER_DEADLOCKED' \ # 2019-07-29T19:59:58 [167700] # --blacklist_patterns='mysqld.{1,150}row0sel.cc.{1,20} dberr_t row_sel_get_clust_rec_for_mysql.{1,250} Assertion .0. failed','mysqld:.{1,200}dict0dict.ic:.{1,30}dict_index_get_nth_field.{1,500} Assertion .pos < index->n_def. failed','mysqld: .{1,150}data0data.h:.{1,20} dfield_t. dtuple_get_nth_field.{1,30}: Assertion .n < tuple->n_fields. failed.','mysqld:.{1,100}rem0rec.cc:.{1,30}bool rec_offs_validate.{1,500} failed','mysqld:.{1,200}btr0cur.cc:.{1,30}dberr_t btr_cur_search_to_nth_level_func.{1,500} failed','InnoDB: Failing assertion: \!cursor->index->is_committed\(\)','Possible endless loop in grammar.','\[ERROR\] InnoDB: preallocating .{1,120} with error 28',' is truncated: expected core file size ' \ # 2019-07-29T19:59:58 [167700] # --reporters=Deadlock1,ErrorLog,None,ServerDead \ # 2019-07-29T19:59:58 [167700] # --validators=None \ # 2019-07-29T19:59:58 [167700] # --grammar=/home/mleich/work/RQG_mleich2/storage/1564423196/c00000.yy \ # 2019-07-29T19:59:58 [167700] # --grammar=/home/mleich/work/RQG_mleich2/storage/1564423196/c00000.yy \ # 2019-07-29T19:59:58 [167700] # --workdir=/home/mleich/work/RQG_mleich2/storage/1564423196/9 \ # 2019-07-29T19:59:58 [167700] # --vardir=/dev/shm/vardir/1564423196/9 \ # 2019-07-29T19:59:58 [167700] # --mtr-build-thread=946 \ # 2019-07-29T19:59:58 [167700] # --basedir1=/home/mleich/work/10.4/bld_debug # 2019-07-29T19:59:58 [167700] INFO: build_thread : 946 # 2019-07-29T19:59:58 [167700] INFO: master_port : 19460 slave_port : 19462 ports : 19460 19462 19464 MTR_BUILD_THREAD : 946 # 2019-07-29T19:59:58 [167700] INFO: Number of servers involved = 1. (0 means unknown) # 2019-07-29T19:59:58 [167700] INFO: Early RQG basedirs : ->undef<-->/home/mleich/work/10.4/bld_debug<-->undef<-->undef<- # 2019-07-29T19:59:58 [167700] DEBUG: $basedirs[0] is not defined or eq ''. Setting it to $basedirs[1] '/home/mleich/work/10.4/bld_debug'. # 2019-07-29T19:59:58 [167700] INFO: Final RQG basedirs : ->/home/mleich/work/10.4/bld_debug<-->/home/mleich/work/10.4/bld_debug<-->undef<-->undef<- # 2019-07-29T19:59:58 [167700] DEBUG: 'git --version 2>&1' exited with value 0 # 2019-07-29T19:59:58 [167700] GIT: $rqg_home('/home/mleich/work/RQG_mleich2') HEAD -> experimental, origin/experimental bb02e4c7279b7ef925393826476e06f48d2fb437 2019-07-09T13:09:13+02:00 # 2019-07-29T19:59:58 [167700] GIT: $basedirs[0]('/home/mleich/work/10.4/bld_debug') HEAD -> 10.4, origin/HEAD, origin/10.4 819c40d694071e56adb62ded97561717edb59f23 2019-07-22T16:34:12+03:00 # 2019-07-29T19:59:58 [167700] GIT: $basedirs[1]('/home/mleich/work/10.4/bld_debug') HEAD -> 10.4, origin/HEAD, origin/10.4 819c40d694071e56adb62ded97561717edb59f23 2019-07-22T16:34:12+03:00 # 2019-07-29T19:59:58 [167700] INFO: Final RQG vardirs : ->/dev/shm/vardir/1564423196/9<-->/dev/shm/vardir/1564423196/9/1<- # 2019-07-29T19:59:58 [167700] tmpdir in GenTest ->/dev/shm/vardir/1564423196/9/<- # 2019-07-29T19:59:58 [167700] tmpdir in DBServer ->/dev/shm/vardir/1564423196/9/<- # 2019-07-29T19:59:58 [167700] DEBUG: subdir_list : ->sql<-->libexec<-->bin<-->sbin<- # 2019-07-29T19:59:58 [167700] DEBUG: Basedirs : ->/home/mleich/work/10.4/bld_debug<-->/home/mleich/work/10.4/bld_debug<-->undef<-->undef<- # 2019-07-29T19:59:58 [167700] DEBUG: debug_server : ->undef<-->undef<-->undef<- # 2019-07-29T19:59:58 [167700] DEBUG: Server binary found : '/home/mleich/work/10.4/bld_debug/sql/mysqld'. # 2019-07-29T19:59:58 [167700] DEBUG: Server binary found : '/home/mleich/work/10.4/bld_debug/sql/mysqld'. # 2019-07-29T19:59:58 [167700] INFO: seed eq 'random'. Computation. seed : 16291 # 2019-07-29T19:59:58 [167700] INFO: Final command line: ->perl /home/mleich/work/RQG_mleich2/rqg.pl --duration=300 --queries=1000000 --threads=3 --no_mask --rpl_mode=none --noarchiving --gendata=conf/mariadb/table_stress.zz --gendata_sql=conf/mariadb/table_stress.sql --engine=InnoDB --mysqld=--log-output=none --mysqld=--net_read_timeout=30 --mysqld=--net_write_timeout=60 --mysqld=--loose-table_lock_wait_timeout=50 --mysqld=--loose-idle_write_transaction_timeout=0 --mysqld=--innodb_stats_persistent=off --mysqld=--loose-idle_transaction_timeout=0 --mysqld=--lock-wait-timeout=86400 --mysqld=--loose_innodb_use_native_aio=0 --mysqld=--wait_timeout=28800 --mysqld=--loose_innodb_lock_schedule_algorithm=fcfs --mysqld=--loose-idle_readonly_transaction_timeout=0 --mysqld=--innodb-lock-wait-timeout=50 --mysqld=--slave_net_timeout=60 --mysqld=--connect_timeout=60 --mysqld=--interactive_timeout=28800 --whitelist_statuses='STATUS_SERVER_CRASHED' --whitelist_patterns='InnoDB: Failing assertion: \(block\)->index \|\| \(block\)->n_pointers == 0','InnoDB: Failing assertion: \(block\)->n_pointers == 0' --blacklist_statuses='STATUS_OK','STATUS_SERVER_DEADLOCKED' --blacklist_patterns='mysqld.{1,150}row0sel.cc.{1,20} dberr_t row_sel_get_clust_rec_for_mysql.{1,250} Assertion .0. failed','mysqld:.{1,200}dict0dict.ic:.{1,30}dict_index_get_nth_field.{1,500} Assertion .pos < index->n_def. failed','mysqld: .{1,150}data0data.h:.{1,20} dfield_t. dtuple_get_nth_field.{1,30}: Assertion .n < tuple->n_fields. failed.','mysqld:.{1,100}rem0rec.cc:.{1,30}bool rec_offs_validate.{1,500} failed','mysqld:.{1,200}btr0cur.cc:.{1,30}dberr_t btr_cur_search_to_nth_level_func.{1,500} failed','InnoDB: Failing assertion: \!cursor->index->is_committed\(\)','Possible endless loop in grammar.','\[ERROR\] InnoDB: preallocating .{1,120} with error 28',' is truncated: expected core file size ' --reporters=Deadlock1,ErrorLog,None,ServerDead --validators=None --grammar=/home/mleich/work/RQG_mleich2/storage/1564423196/c00000.yy --grammar=/home/mleich/work/RQG_mleich2/storage/1564423196/c00000.yy --workdir=/home/mleich/work/RQG_mleich2/storage/1564423196/9 --vardir=/dev/shm/vardir/1564423196/9 --mtr-build-thread=946 --basedir1=/home/mleich/work/10.4/bld_debug --seed=16291<- # 2019-07-29T19:59:58 [167700] MATCHING: Region start ===================== # 2019-07-29T19:59:58 [167700] DEBUG: rpl_mode is 'none' # 2019-07-29T19:59:58 [167700] DEBUG: max_id is 0 # 2019-07-29T19:59:59 [167700] Found source directory at /work/10.4 # 2019-07-29T19:59:59 [167700] Creating MySQL 10.4.7 database at /dev/shm/vardir/1564423196/9/1/data # 2019-07-29T19:59:59 [167700] Bootstrap command: cat "/dev/shm/vardir/1564423196/9/1/boot.sql" | "/home/mleich/work/10.4/bld_debug/sql/mysqld" "--no-defaults" "--basedir=/home/mleich/work/10.4/bld_debug" "--lc-messages-dir=/home/mleich/work/10.4/bld_debug/sql/share" "--character-sets-dir=/work/10.4/sql/share/charsets" "--tmpdir=/dev/shm/vardir/1564423196/9/1/tmp" "--datadir=/dev/shm/vardir/1564423196/9/1/data" "--log-output=none" "--net_read_timeout=30" "--net_write_timeout=60" "--loose-table_lock_wait_timeout=50" "--loose-idle_write_transaction_timeout=0" "--innodb_stats_persistent=off" "--loose-idle_transaction_timeout=0" "--lock-wait-timeout=86400" "--loose_innodb_use_native_aio=0" "--wait_timeout=28800" "--loose_innodb_lock_schedule_algorithm=fcfs" "--loose-idle_readonly_transaction_timeout=0" "--innodb-lock-wait-timeout=50" "--slave_net_timeout=60" "--connect_timeout=60" "--interactive_timeout=28800" "--sql-mode=no_engine_substitution" "--skip-log-bin" "--loose-innodb-encrypt-tables=OFF" "--loose-innodb-encrypt-log=OFF" "--bootstrap" # 2019-07-29T20:00:01 [167700] INFO: Starting MySQL 10.4.7: "/home/mleich/work/10.4/bld_debug/sql/mysqld" "--no-defaults" "--basedir=/home/mleich/work/10.4/bld_debug" "--lc-messages-dir=/home/mleich/work/10.4/bld_debug/sql/share" "--character-sets-dir=/work/10.4/sql/share/charsets" "--tmpdir=/dev/shm/vardir/1564423196/9/1/tmp" "--core-file" "--datadir=/dev/shm/vardir/1564423196/9/1/data" "--max-allowed-packet=128Mb" "--port=19460" "--socket=/dev/shm/vardir/1564423196/9/1/mysql.sock" "--pid-file=/dev/shm/vardir/1564423196/9/1/mysql.pid" "--general-log" "--general-log-file=/dev/shm/vardir/1564423196/9/1/mysql.log" --log-output=none --net_read_timeout=30 --net_write_timeout=60 --loose-table_lock_wait_timeout=50 --loose-idle_write_transaction_timeout=0 --innodb_stats_persistent=off --loose-idle_transaction_timeout=0 --lock-wait-timeout=86400 --loose_innodb_use_native_aio=0 --wait_timeout=28800 --loose_innodb_lock_schedule_algorithm=fcfs --loose-idle_readonly_transaction_timeout=0 --innodb-lock-wait-timeout=50 --slave_net_timeout=60 --connect_timeout=60 --interactive_timeout=28800 --sql-mode=no_engine_substitution # 2019-07-29T20:00:01 [167700] MySQL Version: 10.4.7 # 2019-07-29T20:00:01 [167700] Binary: /home/mleich/work/10.4/bld_debug/sql/mysqld # 2019-07-29T20:00:01 [167700] Type: Debug # 2019-07-29T20:00:01 [167700] Datadir: /dev/shm/vardir/1564423196/9/1/data # 2019-07-29T20:00:01 [167700] Tmpdir: /dev/shm/vardir/1564423196/9/1/tmp # 2019-07-29T20:00:01 [167700] Corefile: /dev/shm/vardir/1564423196/9/1/data/core.168624 # 2019-07-29T20:00:01 [167700] Connecting to 19460 # 2019-07-29T20:00:01 [167700] DEBUG: dsns[0] defined. # 2019-07-29T20:00:01 [167700] --------------------------------------------------------------- # 2019-07-29T20:00:01 [167700] debug_server => ['undef', 'undef', 'undef'] # 2019-07-29T20:00:01 [167700] dsn => ['dbi:mysql:host=127.0.0.1:port=19460:user=root:database=test:mysql_local_infile=1'] # 2019-07-29T20:00:01 [167700] duration => 300 # 2019-07-29T20:00:01 [167700] engine => ['InnoDB', 'InnoDB', 'InnoDB'] # 2019-07-29T20:00:01 [167700] gendata => /home/mleich/work/RQG_mleich2/storage/1564423196/9/rqg.zz # 2019-07-29T20:00:01 [167700] gendata_sql => ['/home/mleich/work/RQG_mleich2/storage/1564423196/9/rqg.sql'] # 2019-07-29T20:00:01 [167700] generator => FromGrammar # 2019-07-29T20:00:01 [167700] grammar => /home/mleich/work/RQG_mleich2/storage/1564423196/9/rqg.yy # 2019-07-29T20:00:01 [167700] logfile => /home/mleich/work/RQG_mleich2/storage/1564423196/9/rqg.log # 2019-07-29T20:00:01 [167700] mask => 0 # 2019-07-29T20:00:01 [167700] mask-level => 0 # 2019-07-29T20:00:01 [167700] queries => 1000000 # 2019-07-29T20:00:01 [167700] reporters => ['Deadlock1', 'ErrorLog', 'None', 'ServerDead'] # 2019-07-29T20:00:01 [167700] rpl_mode => none # 2019-07-29T20:00:01 [167700] seed => 16291 # 2019-07-29T20:00:01 [167700] servers => ['DBServer::MySQL::MySQLd=ARRAY(0x5627095151a8)'] # 2019-07-29T20:00:01 [167700] threads => 3 # 2019-07-29T20:00:01 [167700] validators => ['None'] # 2019-07-29T20:00:01 [167700] vcols => ['undef', 'undef', 'undef'] # 2019-07-29T20:00:01 [167700] views => ['undef', 'undef', 'undef'] # 2019-07-29T20:00:01 [167700] --------------------------------------------------------------- # 2019-07-29T20:00:01 [167700] ------------------------------- # 2019-07-29T20:00:01 [167700] Configuration # 2019-07-29T20:00:01 [167700] debug_server => ['undef', 'undef', 'undef'] # 2019-07-29T20:00:01 [167700] dsn => ['dbi:mysql:host=127.0.0.1:port=19460:user=root:database=test:mysql_local_infile=1'] # 2019-07-29T20:00:01 [167700] duration => 300 # 2019-07-29T20:00:01 [167700] engine => ['InnoDB', 'InnoDB', 'InnoDB'] # 2019-07-29T20:00:01 [167700] gendata => /home/mleich/work/RQG_mleich2/storage/1564423196/9/rqg.zz # 2019-07-29T20:00:01 [167700] gendata_sql => ['/home/mleich/work/RQG_mleich2/storage/1564423196/9/rqg.sql'] # 2019-07-29T20:00:01 [167700] generator => FromGrammar # 2019-07-29T20:00:01 [167700] grammar => /home/mleich/work/RQG_mleich2/storage/1564423196/9/rqg.yy # 2019-07-29T20:00:01 [167700] logfile => /home/mleich/work/RQG_mleich2/storage/1564423196/9/rqg.log # 2019-07-29T20:00:01 [167700] mask => 0 # 2019-07-29T20:00:01 [167700] mask-level => 0 # 2019-07-29T20:00:01 [167700] queries => 1000000 # 2019-07-29T20:00:01 [167700] reporters => ['Deadlock1', 'ErrorLog', 'None', 'ServerDead'] # 2019-07-29T20:00:01 [167700] rpl_mode => none # 2019-07-29T20:00:01 [167700] seed => 16291 # 2019-07-29T20:00:01 [167700] servers => ['DBServer::MySQL::MySQLd=ARRAY(0x5627095151a8)'] # 2019-07-29T20:00:01 [167700] threads => 3 # 2019-07-29T20:00:01 [167700] validators => ['None'] # 2019-07-29T20:00:01 [167700] vcols => ['undef', 'undef', 'undef'] # 2019-07-29T20:00:01 [167700] views => ['undef', 'undef', 'undef'] # 2019-07-29T20:00:01 [167700] INFO: Starting GenTest::App::Gendata # 2019-07-29T20:00:01 [167700] Creating MySQL table: test.table0_innodb_int; engine: innodb; rows: 0 . # 2019-07-29T20:00:01 [167700] INFO: Start processing the SQL file '/home/mleich/work/RQG_mleich2/storage/1564423196/9/rqg.sql'. # 2019-07-29T20:00:01 [167700] INFO: Starting GenTest::App::GendataSQL # 2019-07-29T20:00:01 [167700] GenData returned status STATUS_OK (0) # 2019-07-29T20:00:01 [167700] INFO: RQG GenData runtime in s : 0 # 2019-07-29T20:00:01 [167700] INFO: GenTest: Start of running queries : 1564423204 # 2019-07-29T20:00:01 [167700] Reading grammar from file '/home/mleich/work/RQG_mleich2/storage/1564423196/9/rqg.yy'. # 2019-07-29T20:00:01 [167700] DEBUG: grammar_string -----BEGIN ----- # 2019-07-29T20:00:01 [167700] §_split_§ # 2019-07-29T20:00:01 [167700] thread1: # 2019-07-29T20:00:01 [167700] ALTER TABLE t4 ADD COLUMN IF NOT EXISTS col_string_g CHAR(13) GENERATED ALWAYS AS (SUBSTR(col_string,4,13)) VIRTUAL , ALGORITHM = NOCOPY , LOCK = SHARED ; ALTER TABLE t4 DROP COLUMN IF EXISTS col_string_g , ALGORITHM = NOCOPY , LOCK = SHARED §_split_§ # 2019-07-29T20:00:01 [167700] thread1_connect: # 2019-07-29T20:00:01 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 §_split_§ # 2019-07-29T20:00:01 [167700] thread1_init: # 2019-07-29T20:00:01 [167700] CREATE TABLE t3 ( col1 INT, col2 INT , UNIQUE KEY uidx3 ( col2 ) ) ENGINE = InnoDB ROW_FORMAT = Compact ; CREATE TABLE t4 ( col1 INT , col_string CHAR(19) ) ENGINE = InnoDB §_split_§ # 2019-07-29T20:00:01 [167700] thread2: # 2019-07-29T20:00:01 [167700] CHECK TABLE t3 §_split_§ # 2019-07-29T20:00:01 [167700] thread2_connect: # 2019-07-29T20:00:01 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 §_split_§ # 2019-07-29T20:00:01 [167700] thread2_init: # 2019-07-29T20:00:01 [167700] §_split_§ # 2019-07-29T20:00:01 [167700] thread3: # 2019-07-29T20:00:01 [167700] INSERT INTO t3 (col1,col2) VALUES ( { $my_int= $prng->int(513, 4096) } , $my_int ); COMMIT §_split_§ # 2019-07-29T20:00:01 [167700] thread3_connect: # 2019-07-29T20:00:01 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 §_split_§ # 2019-07-29T20:00:01 [167700] thread3_init: # 2019-07-29T20:00:01 [167700] §_split_§ # 2019-07-29T20:00:01 [167700] DEBUG: grammar_string -----END ------- # 2019-07-29T20:00:01 [167700] DEBUG: grammar_string after splitting -----BEGIN ----- # 2019-07-29T20:00:01 [167700] # 2019-07-29T20:00:01 [167700] thread1: # 2019-07-29T20:00:01 [167700] ALTER TABLE t4 ADD COLUMN IF NOT EXISTS col_string_g CHAR(13) GENERATED ALWAYS AS (SUBSTR(col_string,4,13)) VIRTUAL , ALGORITHM = NOCOPY , LOCK = SHARED ; ALTER TABLE t4 DROP COLUMN IF EXISTS col_string_g , ALGORITHM = NOCOPY , LOCK = SHARED # 2019-07-29T20:00:01 [167700] thread1_connect: # 2019-07-29T20:00:01 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 # 2019-07-29T20:00:01 [167700] thread1_init: # 2019-07-29T20:00:01 [167700] CREATE TABLE t3 ( col1 INT, col2 INT , UNIQUE KEY uidx3 ( col2 ) ) ENGINE = InnoDB ROW_FORMAT = Compact ; CREATE TABLE t4 ( col1 INT , col_string CHAR(19) ) ENGINE = InnoDB # 2019-07-29T20:00:01 [167700] thread2: # 2019-07-29T20:00:01 [167700] CHECK TABLE t3 # 2019-07-29T20:00:01 [167700] thread2_connect: # 2019-07-29T20:00:01 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 # 2019-07-29T20:00:01 [167700] thread2_init: # 2019-07-29T20:00:01 [167700] # 2019-07-29T20:00:01 [167700] thread3: # 2019-07-29T20:00:01 [167700] INSERT INTO t3 (col1,col2) VALUES ( { $my_int= $prng->int(513, 4096) } , $my_int ); COMMIT # 2019-07-29T20:00:01 [167700] thread3_connect: # 2019-07-29T20:00:01 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 # 2019-07-29T20:00:01 [167700] thread3_init: # 2019-07-29T20:00:01 [167700] # 2019-07-29T20:00:01 [167700] DEBUG: grammar_string after splitting -----END ------- # 2019-07-29T20:00:01 [167700] DEBUG: Rule '' rule_string -><- components_string -><- # 2019-07-29T20:00:01 [167700] DEBUG: Rule ' # 2019-07-29T20:00:01 [167700] thread1' rule_string -> # 2019-07-29T20:00:01 [167700] thread1: # 2019-07-29T20:00:01 [167700] ALTER TABLE t4 ADD COLUMN IF NOT EXISTS col_string_g CHAR(13) GENERATED ALWAYS AS (SUBSTR(col_string,4,13)) VIRTUAL , ALGORITHM = NOCOPY , LOCK = SHARED ; ALTER TABLE t4 DROP COLUMN IF EXISTS col_string_g , ALGORITHM = NOCOPY , LOCK = SHARED <- components_string -> # 2019-07-29T20:00:01 [167700] ALTER TABLE t4 ADD COLUMN IF NOT EXISTS col_string_g CHAR(13) GENERATED ALWAYS AS (SUBSTR(col_string,4,13)) VIRTUAL , ALGORITHM = NOCOPY , LOCK = SHARED ; ALTER TABLE t4 DROP COLUMN IF EXISTS col_string_g , ALGORITHM = NOCOPY , LOCK = SHARED <- # 2019-07-29T20:00:01 [167700] DEBUG: Rule ' # 2019-07-29T20:00:01 [167700] thread1_connect' rule_string -> # 2019-07-29T20:00:01 [167700] thread1_connect: # 2019-07-29T20:00:01 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 <- components_string -> # 2019-07-29T20:00:01 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 <- # 2019-07-29T20:00:01 [167700] DEBUG: Rule ' # 2019-07-29T20:00:01 [167700] thread1_init' rule_string -> # 2019-07-29T20:00:01 [167700] thread1_init: # 2019-07-29T20:00:01 [167700] CREATE TABLE t3 ( col1 INT, col2 INT , UNIQUE KEY uidx3 ( col2 ) ) ENGINE = InnoDB ROW_FORMAT = Compact ; CREATE TABLE t4 ( col1 INT , col_string CHAR(19) ) ENGINE = InnoDB <- components_string -> # 2019-07-29T20:00:01 [167700] CREATE TABLE t3 ( col1 INT, col2 INT , UNIQUE KEY uidx3 ( col2 ) ) ENGINE = InnoDB ROW_FORMAT = Compact ; CREATE TABLE t4 ( col1 INT , col_string CHAR(19) ) ENGINE = InnoDB <- # 2019-07-29T20:00:01 [167700] DEBUG: Rule ' # 2019-07-29T20:00:01 [167700] thread2' rule_string -> # 2019-07-29T20:00:01 [167700] thread2: # 2019-07-29T20:00:01 [167700] CHECK TABLE t3 <- components_string -> # 2019-07-29T20:00:01 [167700] CHECK TABLE t3 <- # 2019-07-29T20:00:01 [167700] DEBUG: Rule ' # 2019-07-29T20:00:01 [167700] thread2_connect' rule_string -> # 2019-07-29T20:00:01 [167700] thread2_connect: # 2019-07-29T20:00:01 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 <- components_string -> # 2019-07-29T20:00:01 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 <- # 2019-07-29T20:00:01 [167700] DEBUG: Rule ' # 2019-07-29T20:00:01 [167700] thread2_init' rule_string -> # 2019-07-29T20:00:01 [167700] thread2_init: # 2019-07-29T20:00:01 [167700] <- components_string -> # 2019-07-29T20:00:01 [167700] <- # 2019-07-29T20:00:01 [167700] DEBUG: Rule ' # 2019-07-29T20:00:01 [167700] thread3' rule_string -> # 2019-07-29T20:00:01 [167700] thread3: # 2019-07-29T20:00:01 [167700] INSERT INTO t3 (col1,col2) VALUES ( { $my_int= $prng->int(513, 4096) } , $my_int ); COMMIT <- components_string -> # 2019-07-29T20:00:01 [167700] INSERT INTO t3 (col1,col2) VALUES ( { $my_int= $prng->int(513, 4096) } , $my_int ); COMMIT <- # 2019-07-29T20:00:01 [167700] DEBUG: Rule ' # 2019-07-29T20:00:01 [167700] thread3_connect' rule_string -> # 2019-07-29T20:00:01 [167700] thread3_connect: # 2019-07-29T20:00:01 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 <- components_string -> # 2019-07-29T20:00:01 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 <- # 2019-07-29T20:00:01 [167700] DEBUG: Rule ' # 2019-07-29T20:00:01 [167700] thread3_init' rule_string -> # 2019-07-29T20:00:01 [167700] thread3_init: # 2019-07-29T20:00:01 [167700] <- components_string -> # 2019-07-29T20:00:01 [167700] <- # 2019-07-29T20:00:01 [167700] MLML grammar_string after fiddling 1 -----BEGIN ----- # 2019-07-29T20:00:01 [167700] # 2019-07-29T20:00:01 [167700] thread1: # 2019-07-29T20:00:01 [167700] ALTER TABLE t4 ADD COLUMN IF NOT EXISTS col_string_g CHAR(13) GENERATED ALWAYS AS (SUBSTR(col_string,4,13)) VIRTUAL , ALGORITHM = NOCOPY , LOCK = SHARED ; ALTER TABLE t4 DROP COLUMN IF EXISTS col_string_g , ALGORITHM = NOCOPY , LOCK = SHARED # 2019-07-29T20:00:01 [167700] thread1_connect: # 2019-07-29T20:00:01 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 # 2019-07-29T20:00:01 [167700] thread1_init: # 2019-07-29T20:00:01 [167700] CREATE TABLE t3 ( col1 INT, col2 INT , UNIQUE KEY uidx3 ( col2 ) ) ENGINE = InnoDB ROW_FORMAT = Compact ; CREATE TABLE t4 ( col1 INT , col_string CHAR(19) ) ENGINE = InnoDB # 2019-07-29T20:00:01 [167700] thread2: # 2019-07-29T20:00:01 [167700] CHECK TABLE t3 # 2019-07-29T20:00:01 [167700] thread2_connect: # 2019-07-29T20:00:01 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 # 2019-07-29T20:00:01 [167700] thread2_init: # 2019-07-29T20:00:01 [167700] # 2019-07-29T20:00:01 [167700] thread3: # 2019-07-29T20:00:01 [167700] INSERT INTO t3 (col1,col2) VALUES ( { $my_int= $prng->int(513, 4096) } , $my_int ); COMMIT # 2019-07-29T20:00:01 [167700] thread3_connect: # 2019-07-29T20:00:01 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 # 2019-07-29T20:00:01 [167700] thread3_init: # 2019-07-29T20:00:01 [167700] # 2019-07-29T20:00:01 [167700] MLML grammar_string after fiddling 1 -----END ------- # 2019-07-29T20:00:01 [167700] MLML grammar_string after fiddling 2 -----BEGIN ----- # 2019-07-29T20:00:01 [167700] # 2019-07-29T20:00:01 [167700] thread1: # 2019-07-29T20:00:01 [167700] ALTER TABLE t4 ADD COLUMN IF NOT EXISTS col_string_g CHAR(13) GENERATED ALWAYS AS (SUBSTR(col_string,4,13)) VIRTUAL , ALGORITHM = NOCOPY , LOCK = SHARED ; ALTER TABLE t4 DROP COLUMN IF EXISTS col_string_g , ALGORITHM = NOCOPY , LOCK = SHARED # 2019-07-29T20:00:01 [167700] thread1_connect: # 2019-07-29T20:00:01 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 # 2019-07-29T20:00:01 [167700] thread1_init: # 2019-07-29T20:00:01 [167700] CREATE TABLE t3 ( col1 INT, col2 INT , UNIQUE KEY uidx3 ( col2 ) ) ENGINE = InnoDB ROW_FORMAT = Compact ; CREATE TABLE t4 ( col1 INT , col_string CHAR(19) ) ENGINE = InnoDB # 2019-07-29T20:00:01 [167700] thread2: # 2019-07-29T20:00:01 [167700] CHECK TABLE t3 # 2019-07-29T20:00:01 [167700] thread2_connect: # 2019-07-29T20:00:01 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 # 2019-07-29T20:00:01 [167700] thread2_init: # 2019-07-29T20:00:01 [167700] # 2019-07-29T20:00:01 [167700] thread3: # 2019-07-29T20:00:01 [167700] INSERT INTO t3 (col1,col2) VALUES ( { $my_int= $prng->int(513, 4096) } , $my_int ); COMMIT # 2019-07-29T20:00:01 [167700] thread3_connect: # 2019-07-29T20:00:01 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 # 2019-07-29T20:00:01 [167700] thread3_init: # 2019-07-29T20:00:01 [167700] # 2019-07-29T20:00:01 [167700] MLML grammar_string after fiddling 2 -----END ------- # 2019-07-29T20:00:01 [167700] MLML: Rule 'thread2_init' -> # 2019-07-29T20:00:01 [167700] <- # 2019-07-29T20:00:01 [167700] MLML: Rule 'thread2_init' components_string is now -><- # 2019-07-29T20:00:01 [167700] MLML: Rule 'thread2_init' components_string is empty. # 2019-07-29T20:00:01 [167700] MLML: Rule 'thread2_init' component_string initial : # 2019-07-29T20:00:01 [167700] MLML: Rule 'thread2_init' component_string after stripping whitespaces : # 2019-07-29T20:00:01 [167700] MLML: Rule 'thread2_init' component_string is empty. # 2019-07-29T20:00:01 [167700] MLML: Rule 'thread2' -> # 2019-07-29T20:00:01 [167700] CHECK TABLE t3 <- # 2019-07-29T20:00:01 [167700] MLML: Rule 'thread2' components_string is now -> # 2019-07-29T20:00:01 [167700] CHECK TABLE t3<- # 2019-07-29T20:00:01 [167700] MLML: Rule 'thread2' component_string initial : # 2019-07-29T20:00:01 [167700] CHECK TABLE t3 # 2019-07-29T20:00:01 [167700] MLML: Rule 'thread2' component_string after stripping whitespaces : CHECK TABLE t3 # 2019-07-29T20:00:01 [167700] MLML: Rule 'thread1_connect' -> # 2019-07-29T20:00:01 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 <- # 2019-07-29T20:00:01 [167700] MLML: Rule 'thread1_connect' components_string is now -> # 2019-07-29T20:00:01 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1<- # 2019-07-29T20:00:01 [167700] MLML: Rule 'thread1_connect' component_string initial : # 2019-07-29T20:00:01 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 # 2019-07-29T20:00:01 [167700] MLML: Rule 'thread1_connect' component_string after stripping whitespaces : SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 # 2019-07-29T20:00:01 [167700] MLML: Rule 'thread1_init' -> # 2019-07-29T20:00:01 [167700] CREATE TABLE t3 ( col1 INT, col2 INT , UNIQUE KEY uidx3 ( col2 ) ) ENGINE = InnoDB ROW_FORMAT = Compact ; CREATE TABLE t4 ( col1 INT , col_string CHAR(19) ) ENGINE = InnoDB <- # 2019-07-29T20:00:01 [167700] MLML: Rule 'thread1_init' components_string is now -> # 2019-07-29T20:00:01 [167700] CREATE TABLE t3 ( col1 INT, col2 INT , UNIQUE KEY uidx3 ( col2 ) ) ENGINE = InnoDB ROW_FORMAT = Compact ; CREATE TABLE t4 ( col1 INT , col_string CHAR(19) ) ENGINE = InnoDB<- # 2019-07-29T20:00:01 [167700] MLML: Rule 'thread1_init' component_string initial : # 2019-07-29T20:00:01 [167700] CREATE TABLE t3 ( col1 INT, col2 INT , UNIQUE KEY uidx3 ( col2 ) ) ENGINE = InnoDB ROW_FORMAT = Compact ; CREATE TABLE t4 ( col1 INT , col_string CHAR(19) ) ENGINE = InnoDB # 2019-07-29T20:00:01 [167700] MLML: Rule 'thread1_init' component_string after stripping whitespaces : CREATE TABLE t3 ( col1 INT, col2 INT , UNIQUE KEY uidx3 ( col2 ) ) ENGINE = InnoDB ROW_FORMAT = Compact ; CREATE TABLE t4 ( col1 INT , col_string CHAR(19) ) ENGINE = InnoDB # 2019-07-29T20:00:01 [167700] MLML: Rule 'thread3' -> # 2019-07-29T20:00:01 [167700] INSERT INTO t3 (col1,col2) VALUES ( { $my_int= $prng->int(513, 4096) } , $my_int ); COMMIT <- # 2019-07-29T20:00:01 [167700] MLML: Rule 'thread3' components_string is now -> # 2019-07-29T20:00:01 [167700] INSERT INTO t3 (col1,col2) VALUES ( { $my_int= $prng->int(513, 4096) } , $my_int ); COMMIT<- # 2019-07-29T20:00:01 [167700] MLML: Rule 'thread3' component_string initial : # 2019-07-29T20:00:01 [167700] INSERT INTO t3 (col1,col2) VALUES ( { $my_int= $prng->int(513, 4096) } , $my_int ); COMMIT # 2019-07-29T20:00:01 [167700] MLML: Rule 'thread3' component_string after stripping whitespaces : INSERT INTO t3 (col1,col2) VALUES ( { $my_int= $prng->int(513, 4096) } , $my_int ); COMMIT # 2019-07-29T20:00:01 [167700] MLML: Rule 'thread2_connect' -> # 2019-07-29T20:00:01 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 <- # 2019-07-29T20:00:01 [167700] MLML: Rule 'thread2_connect' components_string is now -> # 2019-07-29T20:00:01 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1<- # 2019-07-29T20:00:01 [167700] MLML: Rule 'thread2_connect' component_string initial : # 2019-07-29T20:00:01 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 # 2019-07-29T20:00:01 [167700] MLML: Rule 'thread2_connect' component_string after stripping whitespaces : SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 # 2019-07-29T20:00:01 [167700] MLML: Rule 'thread1' -> # 2019-07-29T20:00:01 [167700] ALTER TABLE t4 ADD COLUMN IF NOT EXISTS col_string_g CHAR(13) GENERATED ALWAYS AS (SUBSTR(col_string,4,13)) VIRTUAL , ALGORITHM = NOCOPY , LOCK = SHARED ; ALTER TABLE t4 DROP COLUMN IF EXISTS col_string_g , ALGORITHM = NOCOPY , LOCK = SHARED <- # 2019-07-29T20:00:01 [167700] MLML: Rule 'thread1' components_string is now -> # 2019-07-29T20:00:01 [167700] ALTER TABLE t4 ADD COLUMN IF NOT EXISTS col_string_g CHAR(13) GENERATED ALWAYS AS (SUBSTR(col_string,4,13)) VIRTUAL , ALGORITHM = NOCOPY , LOCK = SHARED ; ALTER TABLE t4 DROP COLUMN IF EXISTS col_string_g , ALGORITHM = NOCOPY , LOCK = SHARED<- # 2019-07-29T20:00:01 [167700] MLML: Rule 'thread1' component_string initial : # 2019-07-29T20:00:01 [167700] ALTER TABLE t4 ADD COLUMN IF NOT EXISTS col_string_g CHAR(13) GENERATED ALWAYS AS (SUBSTR(col_string,4,13)) VIRTUAL , ALGORITHM = NOCOPY , LOCK = SHARED ; ALTER TABLE t4 DROP COLUMN IF EXISTS col_string_g , ALGORITHM = NOCOPY , LOCK = SHARED # 2019-07-29T20:00:01 [167700] MLML: Rule 'thread1' component_string after stripping whitespaces : ALTER TABLE t4 ADD COLUMN IF NOT EXISTS col_string_g CHAR(13) GENERATED ALWAYS AS (SUBSTR(col_string,4,13)) VIRTUAL , ALGORITHM = NOCOPY , LOCK = SHARED ; ALTER TABLE t4 DROP COLUMN IF EXISTS col_string_g , ALGORITHM = NOCOPY , LOCK = SHARED # 2019-07-29T20:00:01 [167700] MLML: Rule 'thread3_init' -> # 2019-07-29T20:00:01 [167700] <- # 2019-07-29T20:00:01 [167700] MLML: Rule 'thread3_init' components_string is now -><- # 2019-07-29T20:00:01 [167700] MLML: Rule 'thread3_init' components_string is empty. # 2019-07-29T20:00:01 [167700] MLML: Rule 'thread3_init' component_string initial : # 2019-07-29T20:00:01 [167700] MLML: Rule 'thread3_init' component_string after stripping whitespaces : # 2019-07-29T20:00:01 [167700] MLML: Rule 'thread3_init' component_string is empty. # 2019-07-29T20:00:01 [167700] MLML: Rule 'thread3_connect' -> # 2019-07-29T20:00:01 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 <- # 2019-07-29T20:00:01 [167700] MLML: Rule 'thread3_connect' components_string is now -> # 2019-07-29T20:00:01 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1<- # 2019-07-29T20:00:01 [167700] MLML: Rule 'thread3_connect' component_string initial : # 2019-07-29T20:00:01 [167700] SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 # 2019-07-29T20:00:01 [167700] MLML: Rule 'thread3_connect' component_string after stripping whitespaces : SET SESSION lock_wait_timeout = 2 ; SET SESSION innodb_lock_wait_timeout = 1 # 2019-07-29T20:00:01 [167700] Reporters (for Simplifier): ->Deadlock1<->ErrorLog<->None<->ServerDead<- # 2019-07-29T20:00:01 [167700] Validators (for Simplifier): ->None<- # 2019-07-29T20:00:01 [167700] Caching schema metadata for dbi:mysql:host=127.0.0.1:port=19460:user=root:database=test:mysql_local_infile=1 # 2019-07-29T20:00:02 [167700] Starting 3 processes, 1000000 queries each, duration 300 seconds. # 2019-07-29T20:00:02 [167700] GenTest::ErrorFilter(169122) started # 2019-07-29T20:00:02 [169124] INFO: Thread1 : Mixer created. # 2019-07-29T20:00:02 [169125] INFO: Thread2 : Mixer created. # 2019-07-29T20:00:02 [169126] INFO: Thread3 : Mixer created. # 2019-07-29T20:00:02 [169123] INFO: Periodic reporting process at begin of activity # 2019-07-29T20:00:04 [169122] ErrorFilter: Query: INSERT INTO t3 (col1,col2) VALUES ( 1155, 1155 ) /* E_R Thread3 QNO 131 CON_ID 18 */ failed: 1062 Duplicate entry '%s' for key '%s'. Further errors of this kind will be suppressed. # 2019-07-29T20:00:20 [169125] Executor::MySQL::execute: Query: CHECK TABLE t3 /* E_R Thread2 QNO 193 CON_ID 17 */ failed: 2013 Lost connection to MySQL server during query # 2019-07-29T20:00:20 [169124] Executor::MySQL::execute: Query: ALTER TABLE t4 ADD COLUMN IF NOT EXISTS col_string_g CHAR(13) GENERATED ALWAYS AS (SUBSTR(col_string,4,13)) VIRTUAL, ALGORITHM = NOCOPY, LOCK = SHARED /* E_R Thread1 QNO 2271 CON_ID 16 */ failed: 2013 Lost connection to MySQL server during query # 2019-07-29T20:00:20 [169126] Executor::MySQL::execute: Query: INSERT INTO t3 (col1,col2) VALUES ( 1065, 1065 ) /* E_R Thread3 QNO 5315 CON_ID 18 */ failed: 2013 Lost connection to MySQL server during query DBI connect('host=127.0.0.1:port=19460:user=root:database=test:mysql_local_infile=1','',...) failed: Can't connect to MySQL server on '127.0.0.1' (111) at lib/GenTest/Reporter/Deadlock1.pm line 135. # 2019-07-29T20:00:22 [169123] ERROR: Reporter 'Deadlock': The connect attempt to dsn dbi:mysql:host=127.0.0.1:port=19460:user=root:database=test:mysql_local_infile=1 failed: Can't connect to MySQL server on '127.0.0.1' (111) # 2019-07-29T20:00:22 [169123] ERROR: Reporter 'Deadlock': Will return status 101. # 2019-07-29T20:00:22 [169123] ERROR: Periodic reporting process: Critical status STATUS_SERVER_CRASHED got. Will exit with that. # 2019-07-29T20:00:22 [169123] GenTest: child 169123 is being stopped with status STATUS_SERVER_CRASHED # 2019-07-29T20:00:27 [167700] Process with pid 169123 for periodic reporter ended with status STATUS_SERVER_CRASHED # 2019-07-29T20:00:27 [167700] Killing remaining worker process with pid 169125... # 2019-07-29T20:00:27 [167700] Killing remaining worker process with pid 169126... # 2019-07-29T20:00:27 [167700] Killing remaining worker process with pid 169124... # 2019-07-29T20:00:27 [167700] Kill GenTest::ErrorFilter(169122) # 2019-07-29T20:00:27 [167700] INFO: GenTest: Effective duration in s : 23 # 2019-07-29T20:00:27 [167700] Server crash reported, initiating post-crash analysis... # 2019-07-29T20:00:27 [167700] INFO: Reporter 'ErrorLog' ------------------------------ Begin # 2019-07-29T20:00:27 [167700] --------- Contents of /dev/shm/vardir/1564423196/9/1/data//../mysql.err ------------- # 2019-07-29T20:00:27 [167700] | 2019-07-29 20:00:01 0 [Note] /home/mleich/work/10.4/bld_debug/sql/mysqld (mysqld 10.4.7-MariaDB-debug-log) starting as process 168624 ... # 2019-07-29T20:00:27 [167700] | 2019-07-29 20:00:01 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! # 2019-07-29T20:00:27 [167700] | 2019-07-29 20:00:01 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins # 2019-07-29T20:00:27 [167700] | 2019-07-29 20:00:01 0 [Note] InnoDB: Uses event mutexes # 2019-07-29T20:00:27 [167700] | 2019-07-29 20:00:01 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 # 2019-07-29T20:00:27 [167700] | 2019-07-29 20:00:01 0 [Note] InnoDB: Number of pools: 1 # 2019-07-29T20:00:27 [167700] | 2019-07-29 20:00:01 0 [Note] InnoDB: Using SSE2 crc32 instructions # 2019-07-29T20:00:27 [167700] | 2019-07-29 20:00:01 0 [Note] mysqld: O_TMPFILE is not supported on /dev/shm/vardir/1564423196/9/1/tmp (disabling future attempts) # 2019-07-29T20:00:27 [167700] | 2019-07-29 20:00:01 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M # 2019-07-29T20:00:27 [167700] | 2019-07-29 20:00:01 0 [Note] InnoDB: Completed initialization of buffer pool # 2019-07-29T20:00:27 [167700] | 2019-07-29 20:00:01 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). # 2019-07-29T20:00:27 [167700] | 2019-07-29 20:00:01 0 [Note] InnoDB: 128 out of 128 rollback segments are active. # 2019-07-29T20:00:27 [167700] | 2019-07-29 20:00:01 0 [Note] InnoDB: Creating shared tablespace for temporary tables # 2019-07-29T20:00:27 [167700] | 2019-07-29 20:00:01 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... # 2019-07-29T20:00:27 [167700] | 2019-07-29 20:00:01 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. # 2019-07-29T20:00:27 [167700] | 2019-07-29 20:00:01 0 [Note] InnoDB: Waiting for purge to start # 2019-07-29T20:00:27 [167700] | 2019-07-29 20:00:01 0 [Note] InnoDB: 10.4.7 started; log sequence number 137156; transaction id 17 # 2019-07-29T20:00:27 [167700] | 2019-07-29 20:00:01 0 [Note] InnoDB: Loading buffer pool(s) from /dev/shm/vardir/1564423196/9/1/data/ib_buffer_pool # 2019-07-29T20:00:27 [167700] | 2019-07-29 20:00:01 0 [Note] Plugin 'FEEDBACK' is disabled. # 2019-07-29T20:00:27 [167700] | 2019-07-29 20:00:01 0 [Warning] /home/mleich/work/10.4/bld_debug/sql/mysqld: unknown variable 'loose-table_lock_wait_timeout=50' # 2019-07-29T20:00:27 [167700] | 2019-07-29 20:00:01 0 [Note] InnoDB: Buffer pool(s) load completed at 190729 20:00:01 # 2019-07-29T20:00:27 [167700] | 2019-07-29 20:00:01 0 [Note] Server socket created on IP: '::'. # 2019-07-29T20:00:27 [167700] | 2019-07-29 20:00:01 0 [Note] Reading of all Master_info entries succeeded # 2019-07-29T20:00:27 [167700] | 2019-07-29 20:00:01 0 [Note] Added new Master_info '' to hash table # 2019-07-29T20:00:27 [167700] | 2019-07-29 20:00:01 0 [Note] /home/mleich/work/10.4/bld_debug/sql/mysqld: ready for connections. # 2019-07-29T20:00:27 [167700] | Version: '10.4.7-MariaDB-debug-log' socket: '/dev/shm/vardir/1564423196/9/1/mysql.sock' port: 19460 Source distribution # 2019-07-29T20:00:27 [167700] | 2019-07-29 20:00:18 0x7f8fac14b700 InnoDB: Assertion failure in file /work/10.4/storage/innobase/btr/btr0sea.cc line 1668 # 2019-07-29T20:00:27 [167700] | InnoDB: Failing assertion: (block)->index || (block)->n_pointers == 0 # 2019-07-29T20:00:27 [167700] | InnoDB: We intentionally generate a memory trap. # 2019-07-29T20:00:27 [167700] | InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ # 2019-07-29T20:00:27 [167700] | InnoDB: If you get repeated assertion failures or crashes, even # 2019-07-29T20:00:27 [167700] | InnoDB: immediately after the mysqld startup, there may be # 2019-07-29T20:00:27 [167700] | InnoDB: corruption in the InnoDB tablespace. Please refer to # 2019-07-29T20:00:27 [167700] | InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/ # 2019-07-29T20:00:27 [167700] | InnoDB: about forcing recovery. # 2019-07-29T20:00:27 [167700] | 190729 20:00:18 [ERROR] mysqld got signal 6 ; # 2019-07-29T20:00:27 [167700] | This could be because you hit a bug. It is also possible that this binary # 2019-07-29T20:00:27 [167700] | or one of the libraries it was linked against is corrupt, improperly built, # 2019-07-29T20:00:27 [167700] | or misconfigured. This error can also be caused by malfunctioning hardware. # 2019-07-29T20:00:27 [167700] | # 2019-07-29T20:00:27 [167700] | To report this bug, see https://mariadb.com/kb/en/reporting-bugs # 2019-07-29T20:00:27 [167700] | # 2019-07-29T20:00:27 [167700] | We will try our best to scrape up some info that will hopefully help # 2019-07-29T20:00:27 [167700] | diagnose the problem, but since we have already crashed, # 2019-07-29T20:00:27 [167700] | something is definitely wrong and this may fail. # 2019-07-29T20:00:27 [167700] | # 2019-07-29T20:00:27 [167700] | Server version: 10.4.7-MariaDB-debug-log # 2019-07-29T20:00:27 [167700] | key_buffer_size=134217728 # 2019-07-29T20:00:27 [167700] | read_buffer_size=131072 # 2019-07-29T20:00:27 [167700] | max_used_connections=5 # 2019-07-29T20:00:27 [167700] | max_threads=153 # 2019-07-29T20:00:27 [167700] | thread_count=11 # 2019-07-29T20:00:27 [167700] | It is possible that mysqld could use up to # 2019-07-29T20:00:27 [167700] | key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467840 K bytes of memory # 2019-07-29T20:00:27 [167700] | Hope that's ok; if not, decrease some variables in the equation. # 2019-07-29T20:00:27 [167700] | # 2019-07-29T20:00:27 [167700] | Thread pointer: 0x7f8f08000a98 # 2019-07-29T20:00:27 [167700] | Attempting backtrace. You can use the following information to find out # 2019-07-29T20:00:27 [167700] | where mysqld died. If you see no messages after this, something went # 2019-07-29T20:00:27 [167700] | terribly wrong... # 2019-07-29T20:00:27 [167700] | stack_bottom = 0x7f8fac14aec0 thread_stack 0x49000 # 2019-07-29T20:00:27 [167700] | /home/mleich/work/10.4/bld_debug/sql/mysqld(my_print_stacktrace+0x40)[0x5599999f57eb] # 2019-07-29T20:00:27 [167700] | mysys/stacktrace.c:269(my_print_stacktrace)[0x55999917ad7d] # 2019-07-29T20:00:27 [167700] | /lib/x86_64-linux-gnu/libpthread.so.0(+0x11670)[0x7f8faf7c0670] # 2019-07-29T20:00:27 [167700] | linux/raise.c:58(__GI_raise)[0x7f8fae97177f] # 2019-07-29T20:00:27 [167700] | stdlib/abort.c:91(__GI_abort)[0x7f8fae97337a] # 2019-07-29T20:00:27 [167700] | /home/mleich/work/10.4/bld_debug/sql/mysqld(+0xf8f47b)[0x5599995d947b] # 2019-07-29T20:00:27 [167700] | ut/ut0mem.cc:42(ut_strlcpy(char*, char const*, unsigned long))[0x55999962e95f] # 2019-07-29T20:00:27 [167700] | btr/btr0sea.cc:1669(btr_search_update_hash_on_delete(btr_cur_t*))[0x5599996159fd] # 2019-07-29T20:00:27 [167700] | btr/btr0cur.cc:5773(btr_cur_optimistic_delete_func(btr_cur_t*, unsigned long, mtr_t*))[0x5599997510e6] # 2019-07-29T20:00:27 [167700] | row/row0uins.cc:166(row_undo_ins_remove_clust_rec(undo_node_t*))[0x559999752536] # 2019-07-29T20:00:27 [167700] | row/row0uins.cc:593(row_undo_ins(undo_node_t*, que_thr_t*))[0x55999955decc] # 2019-07-29T20:00:27 [167700] | row/row0undo.cc:438(row_undo(undo_node_t*, que_thr_t*))[0x55999955e113] # 2019-07-29T20:00:27 [167700] | row/row0undo.cc:499(row_undo_step(que_thr_t*))[0x5599994c046d] # 2019-07-29T20:00:27 [167700] | que/que0que.cc:1040(que_thr_step(que_thr_t*))[0x5599994c06bd] # 2019-07-29T20:00:27 [167700] | que/que0que.cc:1104(que_run_threads_low(que_thr_t*))[0x5599994c08af] # 2019-07-29T20:00:27 [167700] | trx/trx0roll.cc:140(trx_rollback_to_savepoint_low(trx_t*, trx_savept_t*))[0x5599995ba9be] # 2019-07-29T20:00:27 [167700] | trx/trx0roll.cc:191(trx_rollback_to_savepoint(trx_t*, trx_savept_t*))[0x5599995badb8] # 2019-07-29T20:00:27 [167700] | row/row0mysql.cc:738(row_mysql_handle_errors(dberr_t*, trx_t*, que_thr_t*, trx_savept_t*))[0x559999517984] # 2019-07-29T20:00:27 [167700] | row/row0mysql.cc:1472(row_insert_for_mysql(unsigned char const*, row_prebuilt_t*, ins_mode_t))[0x559999519805] # 2019-07-29T20:00:27 [167700] | handler/ha_innodb.cc:8078(ha_innobase::write_row(unsigned char const*))[0x5599993b1074] # 2019-07-29T20:00:27 [167700] | sql/handler.cc:6682(handler::ha_write_row(unsigned char const*))[0x55999918f515] # 2019-07-29T20:00:27 [167700] | sql/sql_insert.cc:2037(write_record(THD*, TABLE*, st_copy_info*))[0x559998dfd7e8] # 2019-07-29T20:00:27 [167700] | sql/sql_insert.cc:1075(mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool))[0x559998dfaaf7] # 2019-07-29T20:00:27 [167700] | sql/sql_parse.cc:4528(mysql_execute_command(THD*))[0x559998e4571e] # 2019-07-29T20:00:27 [167700] | sql/sql_parse.cc:7908(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x559998e515cf] # 2019-07-29T20:00:27 [167700] | sql/sql_parse.cc:1845(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x559998e3d878] # 2019-07-29T20:00:27 [167700] | sql/sql_parse.cc:1360(do_command(THD*))[0x559998e3bfbe] # 2019-07-29T20:00:27 [167700] | sql/sql_connect.cc:1404(do_handle_one_connection(CONNECT*))[0x559998fb54f8] # 2019-07-29T20:00:27 [167700] | sql/sql_connect.cc:1307(handle_one_connection)[0x559998fb5247] # 2019-07-29T20:00:27 [167700] | nptl/pthread_create.c:456(start_thread)[0x7f8faf7b66da] # 2019-07-29T20:00:27 [167700] | x86_64/clone.S:107(clone)[0x7f8faea44d7f] # 2019-07-29T20:00:27 [167700] | # 2019-07-29T20:00:27 [167700] | Trying to get some variables. # 2019-07-29T20:00:27 [167700] | Some pointers may be invalid and cause the dump to abort. # 2019-07-29T20:00:27 [167700] | Query (0x7f8f08011190): INSERT INTO t3 (col1,col2) VALUES ( 1065, 1065 ) /* E_R Thread3 QNO 5315 CON_ID 18 */ # 2019-07-29T20:00:27 [167700] | Connection ID (thread ID): 18 # 2019-07-29T20:00:27 [167700] | Status: NOT_KILLED # 2019-07-29T20:00:27 [167700] | # 2019-07-29T20:00:27 [167700] | Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on # 2019-07-29T20:00:27 [167700] | # 2019-07-29T20:00:27 [167700] | The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains # 2019-07-29T20:00:27 [167700] | information that should help you find out what is causing the crash. # 2019-07-29T20:00:27 [167700] | Writing a core file... # 2019-07-29T20:00:27 [167700] | Working directory at /dev/shm/vardir/1564423196/9/1/data # 2019-07-29T20:00:27 [167700] | Resource Limits: # 2019-07-29T20:00:27 [167700] | Limit Soft Limit Hard Limit Units # 2019-07-29T20:00:27 [167700] | Max cpu time unlimited unlimited seconds # 2019-07-29T20:00:27 [167700] | Max file size unlimited unlimited bytes # 2019-07-29T20:00:27 [167700] | Max data size unlimited unlimited bytes # 2019-07-29T20:00:27 [167700] | Max stack size 8388608 unlimited bytes # 2019-07-29T20:00:27 [167700] | Max core file size unlimited unlimited bytes # 2019-07-29T20:00:27 [167700] | Max resident set unlimited unlimited bytes # 2019-07-29T20:00:27 [167700] | Max processes 768201 768201 processes # 2019-07-29T20:00:27 [167700] | Max open files 40960 1048576 files # 2019-07-29T20:00:27 [167700] | Max locked memory 65536 65536 bytes # 2019-07-29T20:00:27 [167700] | Max address space unlimited unlimited bytes # 2019-07-29T20:00:27 [167700] | Max file locks unlimited unlimited locks # 2019-07-29T20:00:27 [167700] | Max pending signals 768201 768201 signals # 2019-07-29T20:00:27 [167700] | Max msgqueue size 819200 819200 bytes # 2019-07-29T20:00:27 [167700] | Max nice priority 0 0 # 2019-07-29T20:00:27 [167700] | Max realtime priority 0 0 # 2019-07-29T20:00:27 [167700] | Max realtime timeout unlimited unlimited us # 2019-07-29T20:00:27 [167700] | Core pattern: |/usr/share/apport/apport %p %s %c %d %P # 2019-07-29T20:00:27 [167700] | # 2019-07-29T20:00:27 [167700] | Aborted (core dumped) # 2019-07-29T20:00:27 [167700] ---------------------------------- # 2019-07-29T20:00:27 [167700] INFO: Reporter 'ErrorLog' ------------------------------ End # 2019-07-29T20:00:27 [167700] error_log is /dev/shm/vardir/1564423196/9/1/data/../mysql.err # 2019-07-29T20:00:27 [167700] pid_file is /dev/shm/vardir/1564423196/9/1/mysql.pid # 2019-07-29T20:00:28 [167700] DEBUG: server pid : 168624 , server_running : 0 # 2019-07-29T20:00:28 [167700] INFO: Reporter 'ServerDead': The process of the DB server 168624 is no more running. Will return STATUS_SERVER_CRASHED. # 2019-07-29T20:00:28 [167700] ERROR: ReporterManager : Reporter 'ServerDead' reported 101 # 2019-07-29T20:00:28 [167700] INFO: The reporters to be run at test end delivered status 101. # 2019-07-29T20:00:28 [167700] Test completed with failure status STATUS_SERVER_CRASHED (101) # 2019-07-29T20:00:28 [167700] GenTest returned status STATUS_SERVER_CRASHED (101) # 2019-07-29T20:00:28 [167700] INFO: RQG GenTest runtime in s : 27 # 2019-07-29T20:00:28 [167700] RESULT: The core of the RQG run ended with status STATUS_SERVER_CRASHED (101) # 2019-07-29T20:00:28 [167700] Stopping server(s)... # 2019-07-29T20:00:28 [167700] DEBUG: DBServer::MySQL::MySQLd::stopServer: The server with process [168624] is already no more running. # 2019-07-29T20:00:28 [167700] DEBUG: Omitting shutdown attempt, but will clean up and return DBSTATUS_OK. # 2019-07-29T20:00:28 [167700] RESULT: The RQG run ended with status STATUS_SERVER_CRASHED (101) # 2019-07-29T20:00:28 [167700] Stopping server(s)... # 2019-07-29T20:00:28 [167700] DEBUG: DBServer::MySQL::MySQLd::stopServer: The server with process [168624] is already no more running. # 2019-07-29T20:00:28 [167700] DEBUG: Omitting shutdown attempt, but will clean up and return DBSTATUS_OK. # 2019-07-29T20:00:28 [167700] MATCHING: Region end ===================== # 2019-07-29T20:00:28 [167700] INFO: RQG total runtime in s : 30 # 2019-07-29T20:00:28 [167700] MATCHING: STATUS_OK, element ' The RQG run ended with status STATUS_OK' : no match # 2019-07-29T20:00:28 [167700] MATCHING: Stop the run element 'BATCH: Stop the run' : no match # 2019-07-29T20:00:28 [167700] MATCHING: Blacklist statuses, element ' The RQG run ended with status STATUS_OK' : no match # 2019-07-29T20:00:28 [167700] MATCHING: Blacklist statuses, element ' The RQG run ended with status STATUS_SERVER_DEADLOCKED' : no match # 2019-07-29T20:00:28 [167700] DEBUG: Blacklist status matching returned : match_no # 2019-07-29T20:00:28 [167700] DEBUG: maybe_interest : 1, maybe_match : 1 # 2019-07-29T20:00:28 [167700] MATCHING: Blacklist text patterns element 'mysqld.{1,150}row0sel.cc.{1,20} dberr_t row_sel_get_clust_rec_for_mysql.{1,250} Assertion .0. failed' : no match # 2019-07-29T20:00:28 [167700] MATCHING: Blacklist text patterns element 'mysqld:.{1,200}dict0dict.ic:.{1,30}dict_index_get_nth_field.{1,500} Assertion .pos < index->n_def. failed' : no match # 2019-07-29T20:00:28 [167700] MATCHING: Blacklist text patterns element 'mysqld: .{1,150}data0data.h:.{1,20} dfield_t. dtuple_get_nth_field.{1,30}: Assertion .n < tuple->n_fields. failed.' : no match # 2019-07-29T20:00:28 [167700] MATCHING: Blacklist text patterns element 'mysqld:.{1,100}rem0rec.cc:.{1,30}bool rec_offs_validate.{1,500} failed' : no match # 2019-07-29T20:00:28 [167700] MATCHING: Blacklist text patterns element 'mysqld:.{1,200}btr0cur.cc:.{1,30}dberr_t btr_cur_search_to_nth_level_func.{1,500} failed' : no match # 2019-07-29T20:00:28 [167700] MATCHING: Blacklist text patterns element 'InnoDB: Failing assertion: \!cursor->index->is_committed\(\)' : no match # 2019-07-29T20:00:28 [167700] MATCHING: Blacklist text patterns element 'Possible endless loop in grammar.' : no match # 2019-07-29T20:00:28 [167700] MATCHING: Blacklist text patterns element '\[ERROR\] InnoDB: preallocating .{1,120} with error 28' : no match # 2019-07-29T20:00:28 [167700] MATCHING: Blacklist text patterns element ' is truncated: expected core file size ' : no match # 2019-07-29T20:00:28 [167700] DEBUG: Blacklist pattern matching returned : match_no # 2019-07-29T20:00:28 [167700] DEBUG: maybe_interest : 1, maybe_match : 1 # 2019-07-29T20:00:28 [167700] MATCHING: Whitelist statuses, element ' The RQG run ended with status STATUS_SERVER_CRASHED' : match # 2019-07-29T20:00:28 [167700] DEBUG: Whitelist status matching returned : match_yes # 2019-07-29T20:00:28 [167700] DEBUG: maybe_interest : 1, maybe_match : 1 # 2019-07-29T20:00:28 [167700] MATCHING: Whitelist text patterns element 'InnoDB: Failing assertion: \(block\)->index \|\| \(block\)->n_pointers == 0' : match # 2019-07-29T20:00:28 [167700] MATCHING: Whitelist text patterns element 'InnoDB: Failing assertion: \(block\)->n_pointers == 0' : no match # 2019-07-29T20:00:28 [167700] DEBUG: Whitelist pattern matching returned : match_yes # 2019-07-29T20:00:28 [167700] DEBUG: maybe_interest : 1, maybe_match : 1 # 2019-07-29T20:00:28 [167700] VERDICT: replay # 2019-07-29T20:00:28 [167700] DEBUG: 'du -sk /dev/shm/vardir/1564423196/9 | cut -f1' exited with value 0 # 2019-07-29T20:00:28 [167700] INFO: vardir_size : 826604 # 2019-07-29T20:00:28 [167700] DEBUG: The RQG vardir '/dev/shm/vardir/1564423196/9' was removed. # 2019-07-29T20:00:28 [167700] SUMMARY: Final command line: ->perl /home/mleich/work/RQG_mleich2/rqg.pl --duration=300 --queries=1000000 --threads=3 --no_mask --rpl_mode=none --noarchiving --gendata=conf/mariadb/table_stress.zz --gendata_sql=conf/mariadb/table_stress.sql --engine=InnoDB --mysqld=--log-output=none --mysqld=--net_read_timeout=30 --mysqld=--net_write_timeout=60 --mysqld=--loose-table_lock_wait_timeout=50 --mysqld=--loose-idle_write_transaction_timeout=0 --mysqld=--innodb_stats_persistent=off --mysqld=--loose-idle_transaction_timeout=0 --mysqld=--lock-wait-timeout=86400 --mysqld=--loose_innodb_use_native_aio=0 --mysqld=--wait_timeout=28800 --mysqld=--loose_innodb_lock_schedule_algorithm=fcfs --mysqld=--loose-idle_readonly_transaction_timeout=0 --mysqld=--innodb-lock-wait-timeout=50 --mysqld=--slave_net_timeout=60 --mysqld=--connect_timeout=60 --mysqld=--interactive_timeout=28800 --whitelist_statuses='STATUS_SERVER_CRASHED' --whitelist_patterns='InnoDB: Failing assertion: \(block\)->index \|\| \(block\)->n_pointers == 0','InnoDB: Failing assertion: \(block\)->n_pointers == 0' --blacklist_statuses='STATUS_OK','STATUS_SERVER_DEADLOCKED' --blacklist_patterns='mysqld.{1,150}row0sel.cc.{1,20} dberr_t row_sel_get_clust_rec_for_mysql.{1,250} Assertion .0. failed','mysqld:.{1,200}dict0dict.ic:.{1,30}dict_index_get_nth_field.{1,500} Assertion .pos < index->n_def. failed','mysqld: .{1,150}data0data.h:.{1,20} dfield_t. dtuple_get_nth_field.{1,30}: Assertion .n < tuple->n_fields. failed.','mysqld:.{1,100}rem0rec.cc:.{1,30}bool rec_offs_validate.{1,500} failed','mysqld:.{1,200}btr0cur.cc:.{1,30}dberr_t btr_cur_search_to_nth_level_func.{1,500} failed','InnoDB: Failing assertion: \!cursor->index->is_committed\(\)','Possible endless loop in grammar.','\[ERROR\] InnoDB: preallocating .{1,120} with error 28',' is truncated: expected core file size ' --reporters=Deadlock1,ErrorLog,None,ServerDead --validators=None --grammar=/home/mleich/work/RQG_mleich2/storage/1564423196/c00000.yy --grammar=/home/mleich/work/RQG_mleich2/storage/1564423196/c00000.yy --workdir=/home/mleich/work/RQG_mleich2/storage/1564423196/9 --vardir=/dev/shm/vardir/1564423196/9 --mtr-build-thread=946 --basedir1=/home/mleich/work/10.4/bld_debug --seed=16291<- # 2019-07-29T20:00:28 [167700] SUMMARY: RQG GenData runtime in s : 0 # 2019-07-29T20:00:28 [167700] SUMMARY: RQG GenTest runtime in s : 27 # 2019-07-29T20:00:28 [167700] SUMMARY: RQG total runtime in s : 30 # 2019-07-29T20:00:28 [167700] SUMMARY: RQG verdict : replay # 2019-07-29T20:00:28 [167700] /home/mleich/work/RQG_mleich2/rqg.pl will exit with exit status STATUS_SERVER_CRASHED(101)