# 2019-01-16T23:37:19 [23636] Converted --seed=time to --seed=1547681839 # 2019-01-16T23:37:19 [23636] Copyright (c) 2010,2011 Oracle and/or its affiliates. All rights reserved. Use is subject to license terms. # 2019-01-16T23:37:19 [23636] Please see http://forge.mysql.com/wiki/Category:RandomQueryGenerator for more information on this test framework. # 2019-01-16T23:37:19 [23636] Starting # 2019-01-16T23:37:19 [23636] # ./runall-new.pl \ # 2019-01-16T23:37:19 [23636] # --basedir=/home/travis/server \ # 2019-01-16T23:37:19 [23636] # --vardir=/home/travis/logs/vardir \ # 2019-01-16T23:37:19 [23636] # --duration=350 \ # 2019-01-16T23:37:19 [23636] # --threads=4 \ # 2019-01-16T23:37:19 [23636] # --seed=time \ # 2019-01-16T23:37:19 [23636] # --reporters=Backtrace,ErrorLog,Deadlock \ # 2019-01-16T23:37:19 [23636] # --skip-gendata \ # 2019-01-16T23:37:19 [23636] # --gendata-advanced \ # 2019-01-16T23:37:19 [23636] # --views \ # 2019-01-16T23:37:19 [23636] # --grammar=conf/mariadb/generic-dml.yy \ # 2019-01-16T23:37:19 [23636] # --redefine=conf/mariadb/bulk_insert.yy \ # 2019-01-16T23:37:19 [23636] # --mysqld=--log_output=FILE \ # 2019-01-16T23:37:19 [23636] # --mysqld=--max-statement-time=20 \ # 2019-01-16T23:37:19 [23636] # --mysqld=--lock-wait-timeout=10 \ # 2019-01-16T23:37:19 [23636] # --mysqld=--loose-innodb-lock-wait-timeout=5 \ # 2019-01-16T23:37:19 [23636] # --mysqld=--loose-debug_assert_on_not_freed_memory=0 \ # 2019-01-16T23:37:19 [23636] # --filter=/home/travis/mariadb-toolbox/travis/10.4-combo-filter.ff \ # 2019-01-16T23:37:19 [23636] # --mysqld=--innodb-encrypt-tables \ # 2019-01-16T23:37:19 [23636] # --mysqld=--innodb-encrypt-log \ # 2019-01-16T23:37:19 [23636] # --mysqld=--innodb-encryption-threads=4 \ # 2019-01-16T23:37:19 [23636] # --mysqld=--aria-encrypt-tables=1 \ # 2019-01-16T23:37:19 [23636] # --mysqld=--encrypt-tmp-disk-tables=1 \ # 2019-01-16T23:37:19 [23636] # --mysqld=--file-key-management \ # 2019-01-16T23:37:19 [23636] # --mysqld=--file-key-management-filename=/home/travis/mariadb-toolbox/data/keys.txt \ # 2019-01-16T23:37:19 [23636] # --mysqld=--plugin-load-add=file_key_management \ # 2019-01-16T23:37:19 [23636] # --mysqld=--innodb-compression-algorithm=zlib \ # 2019-01-16T23:37:19 [23636] # --mysqld=--innodb-page-size=8K \ # 2019-01-16T23:37:19 [23636] # --engine=InnoDB \ # 2019-01-16T23:37:19 [23636] # --scenario=MariaBackupFull \ # 2019-01-16T23:37:19 [23636] # --redefine=conf/mariadb/alter_table.yy \ # 2019-01-16T23:37:19 [23636] # --redefine=conf/mariadb/modules/admin.yy \ # 2019-01-16T23:37:19 [23636] # --redefine=conf/mariadb/versioning.yy \ # 2019-01-16T23:37:19 [23636] # --redefine=conf/mariadb/sequences.yy # 2019-01-16T23:37:19 [23636] Ports : 19300 19300 19302 19304 MTR_BUILD_THREAD : 930 # 2019-01-16T23:37:19 [23636] Final command line: # 2019-01-16T23:37:19 [23636] perl ./runall-new.pl --basedir=/home/travis/server --vardir=/home/travis/logs/vardir --duration=350 --threads=4 --seed=1547681839 --reporters=Backtrace,ErrorLog,Deadlock --skip-gendata --gendata-advanced --views --grammar=conf/mariadb/generic-dml.yy --redefine=conf/mariadb/bulk_insert.yy --mysqld=--log_output=FILE --mysqld=--max-statement-time=20 --mysqld=--lock-wait-timeout=10 --mysqld=--loose-innodb-lock-wait-timeout=5 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --filter=/home/travis/mariadb-toolbox/travis/10.4-combo-filter.ff --mysqld=--innodb-encrypt-tables --mysqld=--innodb-encrypt-log --mysqld=--innodb-encryption-threads=4 --mysqld=--aria-encrypt-tables=1 --mysqld=--encrypt-tmp-disk-tables=1 --mysqld=--file-key-management --mysqld=--file-key-management-filename=/home/travis/mariadb-toolbox/data/keys.txt --mysqld=--plugin-load-add=file_key_management --mysqld=--innodb-compression-algorithm=zlib --mysqld=--innodb-page-size=8K --engine=InnoDB --scenario=MariaBackupFull --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/modules/admin.yy --redefine=conf/mariadb/versioning.yy --redefine=conf/mariadb/sequences.yy # 2019-01-16T23:37:19 [23636] # 2019-01-16T23:37:19 [23636] ================================= # 2019-01-16T23:37:19 [23636] === Full MariaBackup scenario === # 2019-01-16T23:37:19 [23636] ================================= # 2019-01-16T23:37:19 [23636] # 2019-01-16T23:37:20 [23636] Creating MySQL 10.4.2 database at /home/travis/logs/vardir/data # 2019-01-16T23:37:20 [23636] Bootstrap command: "/home/travis/server/bin/mysqld" "--no-defaults" "--basedir=/home/travis/server" "--lc-messages-dir=/home/travis/server/share" "--character-sets-dir=/home/travis/server/share/charsets" "--tmpdir=/home/travis/logs/vardir/tmp" "--datadir=/home/travis/logs/vardir/data" "--log_output=FILE" "--max-statement-time=20" "--lock-wait-timeout=10" "--loose-innodb-lock-wait-timeout=5" "--loose-debug_assert_on_not_freed_memory=0" "--innodb-encrypt-tables" "--innodb-encrypt-log" "--innodb-encryption-threads=4" "--aria-encrypt-tables=1" "--encrypt-tmp-disk-tables=1" "--file-key-management" "--file-key-management-filename=/home/travis/mariadb-toolbox/data/keys.txt" "--plugin-load-add=file_key_management" "--innodb-compression-algorithm=zlib" "--innodb-page-size=8K" "--skip-log-bin" "--loose-innodb-encrypt-tables=OFF" "--loose-innodb-encrypt-log=OFF" "--bootstrap" < "/home/travis/logs/vardir/boot.sql" # 2019-01-16T23:37:22 [23636] -- Server info: -- # 2019-01-16T23:37:22 [23636] 10.4.2 # 2019-01-16T23:37:22 [23636] --log_output=FILE # 2019-01-16T23:37:22 [23636] --max-statement-time=20 # 2019-01-16T23:37:22 [23636] --lock-wait-timeout=10 # 2019-01-16T23:37:22 [23636] --loose-innodb-lock-wait-timeout=5 # 2019-01-16T23:37:22 [23636] --loose-debug_assert_on_not_freed_memory=0 # 2019-01-16T23:37:22 [23636] --innodb-encrypt-tables # 2019-01-16T23:37:22 [23636] --innodb-encrypt-log # 2019-01-16T23:37:22 [23636] --innodb-encryption-threads=4 # 2019-01-16T23:37:22 [23636] --aria-encrypt-tables=1 # 2019-01-16T23:37:22 [23636] --encrypt-tmp-disk-tables=1 # 2019-01-16T23:37:22 [23636] --file-key-management # 2019-01-16T23:37:22 [23636] --file-key-management-filename=/home/travis/mariadb-toolbox/data/keys.txt # 2019-01-16T23:37:22 [23636] --plugin-load-add=file_key_management # 2019-01-16T23:37:22 [23636] --innodb-compression-algorithm=zlib # 2019-01-16T23:37:22 [23636] --innodb-page-size=8K # 2019-01-16T23:37:22 [23636] #-------------------------# # 2019-01-16T23:37:22 [23636] #-- Starting the server --# # 2019-01-16T23:37:22 [23636] #-------------------------# # 2019-01-16T23:37:22 [23636] MySQL Version: 10.4.2 # 2019-01-16T23:37:22 [23636] Binary: /home/travis/server/bin/mysqld # 2019-01-16T23:37:23 [23636] Type: Debug # 2019-01-16T23:37:23 [23636] Datadir: /home/travis/logs/vardir/data # 2019-01-16T23:37:23 [23636] Tmpdir: /home/travis/logs/vardir/tmp # 2019-01-16T23:37:23 [23636] Corefile: /home/travis/logs/vardir/data/core. # 2019-01-16T23:37:23 [23636] Starting MySQL 10.4.2: "/home/travis/server/bin/mysqld" "--no-defaults" "--basedir=/home/travis/server" "--lc-messages-dir=/home/travis/server/share" "--character-sets-dir=/home/travis/server/share/charsets" "--tmpdir=/home/travis/logs/vardir/tmp" "--core-file" "--datadir=/home/travis/logs/vardir/data" "--max-allowed-packet=128Mb" "--port=19300" "--socket=/home/travis/logs/vardir/mysql.sock" "--pid-file=/home/travis/logs/vardir/mysql.pid" "--general-log" "--general-log-file=/home/travis/logs/vardir/mysql.log" --log_output=FILE --max-statement-time=20 --lock-wait-timeout=10 --loose-innodb-lock-wait-timeout=5 --loose-debug_assert_on_not_freed_memory=0 --innodb-encrypt-tables --innodb-encrypt-log --innodb-encryption-threads=4 --aria-encrypt-tables=1 --encrypt-tmp-disk-tables=1 --file-key-management --file-key-management-filename=/home/travis/mariadb-toolbox/data/keys.txt --plugin-load-add=file_key_management --innodb-compression-algorithm=zlib --innodb-page-size=8K # 2019-01-16T23:37:23 [23636] Pid file does not exist and timeout hasn't passed yet, but the error log has already been updated # 2019-01-16T23:37:23 [23636] Found PID 23696 in the error log # 2019-01-16T23:37:24 [23636] Server started with PID 23696 # 2019-01-16T23:37:24 [23636] Connecting to 19300 # 2019-01-16T23:37:24 [23636] #---------------------------------------------# # 2019-01-16T23:37:24 [23636] #-- Running initial test flow on the server --# # 2019-01-16T23:37:24 [23636] #---------------------------------------------# # 2019-01-16T23:37:24 [23732] ------------------------------- # 2019-01-16T23:37:24 [23732] Configuration # 2019-01-16T23:37:24 [23732] debug_server => ['', '', ''] # 2019-01-16T23:37:24 [23732] dsn => ['dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test:mysql_local_infile=1'] # 2019-01-16T23:37:24 [23732] duration => 233 # 2019-01-16T23:37:24 [23732] engine => ['InnoDB', 'InnoDB', 'InnoDB'] # 2019-01-16T23:37:24 [23732] filter => /home/travis/mariadb-toolbox/travis/10.4-combo-filter.ff # 2019-01-16T23:37:24 [23732] gendata-advanced => 1 # 2019-01-16T23:37:24 [23732] generator => FromGrammar # 2019-01-16T23:37:24 [23732] grammar => conf/mariadb/generic-dml.yy # 2019-01-16T23:37:24 [23732] queries => 100000000 # 2019-01-16T23:37:24 [23732] redefine => ['conf/mariadb/bulk_insert.yy', 'conf/mariadb/alter_table.yy', 'conf/mariadb/modules/admin.yy', 'conf/mariadb/versioning.yy', 'conf/mariadb/sequences.yy'] # 2019-01-16T23:37:24 [23732] reporters => ['Backtrace', 'ErrorLog', 'Deadlock'] # 2019-01-16T23:37:24 [23732] seed => 1547681839 # 2019-01-16T23:37:24 [23732] servers => ['DBServer::MySQL::MySQLd=ARRAY(0x30c3910)'] # 2019-01-16T23:37:24 [23732] strict_fields => 1 # 2019-01-16T23:37:24 [23732] threads => 4 # 2019-01-16T23:37:24 [23732] transformers => [''] # 2019-01-16T23:37:24 [23732] validators => [''] # 2019-01-16T23:37:24 [23732] vcols => ['', '', ''] # 2019-01-16T23:37:24 [23732] views => ['', '', ''] # 2019-01-16T23:37:24 [23732] Creating MySQL table t1, size 0 rows, engine InnoDB . # 2019-01-16T23:37:24 [23732] Executor: Query: ALTER TABLE t1 ADD INDEX(col_dec,pk,col_blob(64)) /* QNO 4 CON_ID 9 */ failed: 4097 Compressed column 'col_blob' can't be used in key specification. Further errors of this kind will be suppressed. # 2019-01-16T23:37:24 [23732] Executor: Query: ALTER TABLE t1 ADD UNIQUE(col_enum,col_varchar(64),col_datetime,col_dec) /* QNO 6 CON_ID 9 */ failed: 4097 Compressed column 'col_varchar' can't be used in key specification. Further errors of this kind will be suppressed. # 2019-01-16T23:37:24 [23732] Creating MySQL table t2, size 1 rows, engine InnoDB . # 2019-01-16T23:37:24 [23732] Creating MySQL table t3, size 20 rows, engine InnoDB . # 2019-01-16T23:37:24 [23732] Creating MySQL table t4, size 100 rows, engine InnoDB . # 2019-01-16T23:37:24 [23732] Creating MySQL table t5, size 1000 rows, engine InnoDB . # 2019-01-16T23:37:25 [23732] Creating MySQL table t6, size 0 rows, engine InnoDB . # 2019-01-16T23:37:25 [23732] Creating MySQL table t7, size 1 rows, engine InnoDB . # 2019-01-16T23:37:25 [23732] Creating MySQL table t8, size 20 rows, engine InnoDB . # 2019-01-16T23:37:26 [23732] Creating MySQL table t9, size 100 rows, engine InnoDB . # 2019-01-16T23:37:26 [23732] Reading grammar from file conf/mariadb/generic-dml.yy # 2019-01-16T23:37:26 [23732] Reading grammar from file conf/mariadb/bulk_insert.yy # 2019-01-16T23:37:26 [23732] Reading grammar from file conf/mariadb/alter_table.yy # 2019-01-16T23:37:26 [23732] Reading grammar from file conf/mariadb/modules/admin.yy # 2019-01-16T23:37:26 [23732] Reading grammar from file conf/mariadb/versioning.yy # 2019-01-16T23:37:26 [23732] Reading grammar from file conf/mariadb/sequences.yy # 2019-01-16T23:37:26 [23732] Reporters: Backtrace, ErrorLog, Deadlock # 2019-01-16T23:37:26 [23732] Validators: QueryProperties # 2019-01-16T23:37:26 [23732] Caching schema metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test:mysql_local_infile=1 # 2019-01-16T23:37:28 [23732] Loaded 6 filtering rules from '/home/travis/mariadb-toolbox/travis/10.4-combo-filter.ff' # 2019-01-16T23:37:28 [23732] Starting 4 processes, 100000000 queries each, duration 233 seconds. # 2019-01-16T23:37:28 [23732] GenTest::ErrorFilter(23735) started # 2019-01-16T23:37:28 [23737] Mixer: Loading Validator GenTest::Validator::QueryProperties. # 2019-01-16T23:37:28 [23735] ErrorFilter: Query: CREATE OR REPLACE TABLE `view_t3` (icol3 MEDIUMINT NOT NULL DEFAULT 0 /*!100201 CHECK (ncol3 LIKE ecol7) */) ROW_FORMAT = REDUNDANT /* QNO 91 CON_ID 14 */ failed: 1965 'test.view_t%d' is a view. Further errors of this kind will be suppressed. # 2019-01-16T23:37:28 [23735] ErrorFilter: Query: CREATE OR REPLACE TABLE t6 (tcol2 YEAR NOT NULL /*!100303 INVISIBLE */ ) /* QNO 92 CON_ID 14 */ failed: 1113 A table must have at least %d column. Further errors of this kind will be suppressed. # 2019-01-16T23:37:29 [23738] Mixer: Loading Validator GenTest::Validator::QueryProperties. # 2019-01-16T23:37:29 [23737] Executor::MySQL::execute: Query: CREATE OR REPLACE TABLE t5 (tscol6 TIMESTAMP ) ROW_FORMAT = FIXED /* QNO 94 CON_ID 14 */ failed: 1005 Can't create table `test`.`t5` (errno: 140 "Wrong create options") # 2019-01-16T23:37:29 [23735] ErrorFilter: Query: CREATE OR REPLACE TABLE `t1` (bcol4 BIT NOT NULL DEFAULT NULL /*!100303 INVISIBLE */ ) ROW_FORMAT = DYNAMIC /* QNO 93 CON_ID 14 */ failed: 1067 Invalid default value for 'bcol%d'. Further errors of this kind will be suppressed. # 2019-01-16T23:37:29 [23735] ErrorFilter: Query: CREATE OR REPLACE TABLE t7 (vcol4 GEOMETRY AS ( geocol4 ) /*!100201 STORED */ /* PERSISTENT */ ) ROW_FORMAT = DEFAULT /* QNO 91 CON_ID 15 */ failed: 1054 Unknown column '%s' in 'GENERATED ALWAYS AS'. Further errors of this kind will be suppressed. # 2019-01-16T23:37:29 [23740] Mixer: Loading Validator GenTest::Validator::QueryProperties. # 2019-01-16T23:37:29 [23742] Mixer: Loading Validator GenTest::Validator::QueryProperties. # 2019-01-16T23:37:29 [23735] ErrorFilter: Query: CREATE OR REPLACE TABLE t7 (geocol10 MULTIPOLYGON NULL /*!100201 DEFAULT ST_GEOMFROMTEXT('Point(1 1)') */, ncol2 DECIMAL ZEROFILL NULL ) ROW_FORMAT DYNAMIC /* QNO 98 CON_ID 14 */ failed: 1366 Incorrect MULTIPOLYGON value: 'POINT' for column ``.``.`geocol%d` at row %d. Further errors of this kind will be suppressed. # 2019-01-16T23:37:29 [23736] Started periodic reporting process... # 2019-01-16T23:37:29 [23740] Executor::MySQL::execute: Query: CREATE OR REPLACE TABLE t9 (geocol7 GEOMETRYCOLLECTION NULL ) ROW_FORMAT = FIXED /* QNO 96 CON_ID 16 */ failed: 1005 Can't create table `test`.`t9` (errno: 140 "Wrong create options") # 2019-01-16T23:37:29 [23735] ErrorFilter: Query: UPDATE IGNORE `view_t7` SET `col_time` = '' ORDER BY `col_dec` LIMIT 1 /* QNO 103 CON_ID 14 */ failed: 1356 View 'test.view_t%d' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them. Further errors of this kind will be suppressed. # 2019-01-16T23:37:29 [23735] ErrorFilter: Query: ALTER SEQUENCE IF EXISTS seq4 START 83 INCREMENT BY 4 START 9830 /* QNO 107 CON_ID 14 */ failed: 1225 Option 'START' used twice in statement. Further errors of this kind will be suppressed. # 2019-01-16T23:37:29 [23735] ErrorFilter: Query: SET STATEMENT `sql_mode`=ORACLE FOR SELECT seq2.nextval /* QNO 105 CON_ID 15 */ failed: 1109 Unknown table '%s' in field list. Further errors of this kind will be suppressed. # 2019-01-16T23:37:29 [23735] ErrorFilter: Query: INSERT INTO `t1` SELECT * FROM `t4` /* QNO 107 CON_ID 15 */ failed: 1146 Table '%s' doesn't exist. Further errors of this kind will be suppressed. # 2019-01-16T23:37:29 [23735] ErrorFilter: Query: ALTER IGNORE TABLE t8 ADD CONSTRAINT g FOREIGN KEY (ncol3) REFERENCES t4 (tcol10) ON UPDATE NO ACTION /* QNO 110 CON_ID 14 */ failed: 1072 Key column '%s' doesn't exist in table. Further errors of this kind will be suppressed. # 2019-01-16T23:37:29 [23735] ErrorFilter: Query: SHOW EXPLAIN FOR 40 /* QNO 105 CON_ID 17 */ failed: 1094 Unknown thread id: %s%d. Further errors of this kind will be suppressed. # 2019-01-16T23:37:29 [23735] ErrorFilter: Query: INSERT IGNORE INTO `view_t8` () VALUES () /* QNO 108 CON_ID 17 */ failed: 1136 Column count doesn't match value count at row %d. Further errors of this kind will be suppressed. # 2019-01-16T23:37:29 [23735] ErrorFilter: Query: DROP SEQUENCE seq5 /* QNO 122 CON_ID 17 */ failed: 4091 Unknown SEQUENCE: 'test.seq%d'. Further errors of this kind will be suppressed. # 2019-01-16T23:37:29 [23735] ErrorFilter: Query: SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE t5 PARTITION BY system_time LIMIT 9382 ( PARTITION ver_p1 HISTORY, PARTITION ver_p2 HISTORY, PARTITION ver_p3 HISTORY, PARTITION ver_pn CURRENT ) /* QNO 103 CON_ID 16 */ failed: 1562 Cannot create temporary table with partitions. Further errors of this kind will be suppressed. # 2019-01-16T23:37:29 [23735] ErrorFilter: Query: SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE t4 ADD SYSTEM VERSIONING, ADD SYSTEM VERSIONING /* QNO 135 CON_ID 14 */ failed: 4086 Sequence 'test.t%d' table structure is invalid (Wrong number of columns). Further errors of this kind will be suppressed. # 2019-01-16T23:37:29 [23735] ErrorFilter: Query: SHOW EXPLAIN FOR 17 /* QNO 143 CON_ID 14 */ failed: 1933 Target is not running an EXPLAINable command. Further errors of this kind will be suppressed. # 2019-01-16T23:37:29 [23735] ErrorFilter: Query: DROP SEQUENCE IF EXISTS seq4, seq4 /* QNO 143 CON_ID 15 */ failed: 1066 Not unique table/alias: '%s'. Further errors of this kind will be suppressed. # 2019-01-16T23:37:29 [23735] ErrorFilter: Query: ALTER IGNORE TABLE `view_t8` ADD FULLTEXT KEY(`col_varchar`) /*!100307, ALGORITHM=INSTANT */, LOCK=SHARED, ADD COLUMN IF NOT EXISTS scol9 VARBINARY(20617) NULL AFTER tscol2 /* QNO 134 CON_ID 17 */ failed: 1347 'test.view_t%d' is not of type 'BASE TABLE'. Further errors of this kind will be suppressed. # 2019-01-16T23:37:29 [23735] ErrorFilter: Query: INSERT INTO seq1 VALUES (46850, 5831317092514660352, 3357343744, -90, 0, 115, 0, 1) /* QNO 125 CON_ID 16 */ failed: 4085 Sequence 'test.seq%d' values are conflicting. Further errors of this kind will be suppressed. # 2019-01-16T23:37:29 [23735] ErrorFilter: Query: SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE `t8` PARTITION BY system_time INTERVAL 7 HOUR ( PARTITION ver_p1 HISTORY, PARTITION ver_pn CURRENT ) /* QNO 147 CON_ID 17 */ failed: 4124 Table `t%d` is not system-versioned. Further errors of this kind will be suppressed. # 2019-01-16T23:37:29 [23735] ErrorFilter: Query: SET `system_versioning_innodb_algorithm_simple` = OFF /* QNO 171 CON_ID 14 */ failed: 1193 Unknown system variable 'system_versioning_innodb_algorithm_simple'. Further errors of this kind will be suppressed. # 2019-01-16T23:37:29 [23735] ErrorFilter: Query: SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE t3 REMOVE PARTITIONING /* QNO 164 CON_ID 17 */ failed: 1505 Partition management on a not partitioned table is not possible. Further errors of this kind will be suppressed. # 2019-01-16T23:37:29 [23735] ErrorFilter: Query: ALTER TABLE `t8` DROP INDEX ind5 /* QNO 179 CON_ID 14 */ failed: 1091 Can't DROP INDEX `ind%d`; check that it exists. Further errors of this kind will be suppressed. # 2019-01-16T23:37:29 [23735] ErrorFilter: Query: SHOW BINARY LOGS /* QNO 181 CON_ID 17 */ failed: 1381 You are not using binary logging. Further errors of this kind will be suppressed. # 2019-01-16T23:37:30 [23735] ErrorFilter: Query: ALTER IGNORE TABLE t5 /*!100301 NOWAIT */ RENAME TO t7, DROP INDEX ind4 /* QNO 203 CON_ID 14 */ failed: 1050 Table '%s' already exists. Further errors of this kind will be suppressed. # 2019-01-16T23:37:30 [23735] ErrorFilter: Query: SHOW CREATE DATABASE s /* QNO 221 CON_ID 14 */ failed: 1049 Unknown database '%s'. Further errors of this kind will be suppressed. # 2019-01-16T23:37:30 [23735] ErrorFilter: Query: REPLACE INTO `t7` () VALUES (),(),(),() /* QNO 161 CON_ID 16 */ failed: 1364 Field 'next_not_cached_value' doesn't have a default value. Further errors of this kind will be suppressed. # 2019-01-16T23:37:30 [23735] ErrorFilter: Query: SELECT * FROM `t3` INTO OUTFILE 'load_t3' /* QNO 294 CON_ID 14 */ failed: 1086 File '%s' already exists. Further errors of this kind will be suppressed. # 2019-01-16T23:37:30 [23735] ErrorFilter: Query: ROLLBACK TO SAVEPOINT sp /* QNO 298 CON_ID 15 */ failed: 1305 SAVEPOINT %s does not exist. Further errors of this kind will be suppressed. # 2019-01-16T23:37:30 [23735] ErrorFilter: Query: ALTER IGNORE TABLE t3 /*!100301 WAIT 3 */ MODIFY COLUMN IF EXISTS ncol6 FLOAT ZEROFILL NOT NULL /*!100307, ALGORITHM=NOCOPY */, LOCK=NONE /* QNO 305 CON_ID 15 */ failed: 4119 Not allowed for system-versioned `test`.`t%d`. Change @@system_versioning_alter_history to proceed with ALTER.. Further errors of this kind will be suppressed. # 2019-01-16T23:37:30 [23735] ErrorFilter: Query: INSERT IGNORE INTO `t3` () VALUES () /* QNO 382 CON_ID 17 */ failed: 1100 Table 't%d' was not locked with LOCK TABLES. Further errors of this kind will be suppressed. # 2019-01-16T23:37:31 [23735] ErrorFilter: Query: SHOW CREATE TRIGGER o /* QNO 492 CON_ID 17 */ failed: 1360 Trigger does not exist. Further errors of this kind will be suppressed. # 2019-01-16T23:37:31 [23735] ErrorFilter: Query: FLUSH SLAVE, SLAVE /* QNO 564 CON_ID 17 */ failed: 1221 Incorrect usage of %s and %sSLAVE. Further errors of this kind will be suppressed. # 2019-01-16T23:37:31 [23735] ErrorFilter: Query: ALTER TABLE `t5` ADD PERIOD FOR SYSTEM_TIME(`row_start`, `vers_start`) /* QNO 458 CON_ID 16 */ failed: 4137 TEMPORARY tables do not support system versioning. Further errors of this kind will be suppressed. # 2019-01-16T23:37:32 [23735] ErrorFilter: Query: SHOW CREATE USER root /* QNO 631 CON_ID 16 */ failed: 1133 Can't find any matching row in the user table. Further errors of this kind will be suppressed. # 2019-01-16T23:37:32 [23735] ErrorFilter: Query: LOAD DATA INFILE 'load_view_t2' IGNORE INTO TABLE view_t2 /* QNO 756 CON_ID 15 */ failed: 1213 Deadlock found when trying to get lock; try restarting transaction. Further errors of this kind will be suppressed. # 2019-01-16T23:37:32 [23735] ErrorFilter: Query: SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE `t2` ADD COLUMN `row_start` TIMESTAMP(6) GENERATED ALWAYS AS ROW START, ADD SYSTEM VERSIONING /* QNO 696 CON_ID 16 */ failed: 4125 Wrong parameters for `t%d`: missing 'AS ROW END'. Further errors of this kind will be suppressed. # 2019-01-16T23:37:32 [23740] WARNING: Table/view 'view_t7' in schema 'test' has no 'char' columns # 2019-01-16T23:37:33 [23735] ErrorFilter: Query: SHOW CREATE EVENT s /* QNO 879 CON_ID 16 */ failed: 1539 Unknown event '%s'. Further errors of this kind will be suppressed. # 2019-01-16T23:37:33 [23735] ErrorFilter: Query: SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE t3 ADD PERIOD FOR SYSTEM_TIME(`row_start`, `vers_start`) /* QNO 1156 CON_ID 14 */ failed: 4135 Table `t%d` is already system-versioned. Further errors of this kind will be suppressed. # 2019-01-16T23:37:34 [23737] Executor::MySQL::execute: Query: ALTER TABLE t5 PARTITION BY HASH(`col_year`) /* QNO 1310 CON_ID 14 */ failed: 1478 Table storage engine 'partition' does not support the create option 'SEQUENCE' # 2019-01-16T23:37:34 [23742] Executor::MySQL::execute: Query: ALTER IGNORE TABLE t2 ROW_FORMAT = PAGE /* QNO 1419 CON_ID 17 */ failed: 1005 Can't create table `test`.`#sql-5c90_11` (errno: 140 "Wrong create options") # 2019-01-16T23:37:34 [23735] ErrorFilter: Query: INSERT INTO `t8` SELECT * FROM `t3` /* QNO 1514 CON_ID 17 */ failed: 1048 Column '%s' cannot be null. Further errors of this kind will be suppressed. # 2019-01-16T23:37:35 [23735] ErrorFilter: Query: LOAD DATA INFILE 'load_t8' REPLACE INTO TABLE t8 /* QNO 1492 CON_ID 15 */ failed: 1262 Row %d was truncated; it contained more data than there were input columns. Further errors of this kind will be suppressed. # 2019-01-16T23:37:35 [23735] ErrorFilter: Query: DROP TABLE t4 /* QNO 1739 CON_ID 17 */ failed: 1051 Unknown table '%s'. Further errors of this kind will be suppressed. # 2019-01-16T23:37:36 [23735] ErrorFilter: Query: TRUNCATE TABLE `t5` /* QNO 1781 CON_ID 15 */ failed: 1031 Storage engine SEQUENCE of the table `test`.`t%d` doesn't have this option. Further errors of this kind will be suppressed. # 2019-01-16T23:37:36 [23735] ErrorFilter: Query: CREATE OR REPLACE TABLE t7 (ecol6 SET('foo','bar') NOT NULL, icol7 INT NOT NULL, bcol1 BIT NULL DEFAULT 0, `row_start` VARCHAR(47470) GENERATED ALWAYS AS ROW START, `vers_end` DATE GENERATED ALWAYS AS ROW END, PERIOD FOR SYSTEM_TIME ( `row_start`, `row_end` )) ENGINE=MyISAM ROW_FORMAT=REDUNDANT WITH SYSTEM VERSIONING /* QNO 2108 CON_ID 14 */ failed: 4126 PERIOD FOR SYSTEM_TIME must use columns `row_start` and `vers_end`. Further errors of this kind will be suppressed. # 2019-01-16T23:37:36 [23735] ErrorFilter: Query: ALTER ONLINE TABLE t2 FORCE /* QNO 2129 CON_ID 14 */ failed: 1845 LOCK=NONE is not supported for this operation. Try LOCK=SHARED. Further errors of this kind will be suppressed. # 2019-01-16T23:37:37 [23735] ErrorFilter: Query: ALTER TABLE t2 DROP FOREIGN KEY f /* QNO 1848 CON_ID 16 */ failed: 1025 Error on rename of './test/t%d' to './test/#sql%d-%dc%d-%d' (errno: %d "Cannot delete a parent row"). Further errors of this kind will be suppressed. # 2019-01-16T23:37:38 [23735] ErrorFilter: Query: SHOW EVENTS FROM performance_schema /* QNO 2765 CON_ID 14 */ failed: 1044 Access denied for user 'root'@'localhost' to database 'performance_schema'. Further errors of this kind will be suppressed. # 2019-01-16T23:37:39 [23735] ErrorFilter: Query: CREATE OR REPLACE TEMPORARY TABLE `t5` (icol10 TINYINT NULL ) ROW_FORMAT = COMPRESSED /* QNO 2737 CON_ID 15 */ failed: 4047 CREATE TEMPORARY TABLE is not allowed with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.. Further errors of this kind will be suppressed. # 2019-01-16T23:37:40 [23735] ErrorFilter: Query: INSERT INTO seq3 VALUES (3092284094143266816, 13536, -3380795945271689216, 0, 8, 138, 0, 0) /* QNO 3045 CON_ID 14 */ failed: 1099 Table 'seq%d' was locked with a READ lock and can't be updated. Further errors of this kind will be suppressed. # 2019-01-16T23:37:40 [23738] Executor::MySQL::execute: Query: ALTER TABLE t4 /*!100301 NOWAIT */ /*!100108 IETF_QUOTES = NO */ /* QNO 2881 CON_ID 15 */ failed: 1911 Unknown option 'IETF_QUOTES' # 2019-01-16T23:37:40 [23735] ErrorFilter: Query: ALTER ONLINE TABLE t5 /*!100301 NOWAIT */ DROP COLUMN ecol4, ALGORITHM=INPLACE, ADD IF NOT EXISTS ( ecol3 SET('foo','bar') NULL DEFAULT NULL /*!100303 INVISIBLE */ ) /* QNO 3153 CON_ID 17 */ failed: 1205 Lock wait timeout exceeded; try restarting transaction. Further errors of this kind will be suppressed. # 2019-01-16T23:37:42 [23737] Executor::MySQL::execute: Query: ALTER ONLINE TABLE t5 /*!100301 NOWAIT */ /*!100104 ENCRYPTION_KEY_ID = 3 */ /* QNO 3519 CON_ID 14 */ failed: 1478 Table storage engine 'InnoDB' does not support the create option 'ENCRYPTION_KEY_ID' # 2019-01-16T23:37:42 [23735] ErrorFilter: Query: SHOW GRANTS FOR '' /* QNO 3728 CON_ID 17 */ failed: 1959 Invalid role specification ``. Further errors of this kind will be suppressed. # 2019-01-16T23:37:42 [23735] ErrorFilter: Query: RENAME TABLE `t4` TO tmp_rename_23737, tmp_rename_23737 TO t4 /* QNO 3603 CON_ID 14 */ failed: 1192 Can't execute the given command because you have active locked tables or an active transaction. Further errors of this kind will be suppressed. # 2019-01-16T23:37:42 [23735] ErrorFilter: Query: SET `system_versioning_asof` = ALL /* QNO 3382 CON_ID 16 */ failed: 1231 Variable 'system_versioning_asof' can't be set to the value of 'ALL'. Further errors of this kind will be suppressed. # 2019-01-16T23:37:45 [23735] ErrorFilter: Query: SET TRANSACTION ISOLATION LEVEL REPEATABLE READ /* QNO 4736 CON_ID 17 */ failed: 1568 Transaction characteristics can't be changed while a transaction is in progress. Further errors of this kind will be suppressed. # 2019-01-16T23:37:45 [23735] ErrorFilter: Query: ALTER TABLE t9 PARTITION BY KEY(`col_char`) /* QNO 4788 CON_ID 17 */ failed: 1488 Field in list of fields for partition function not found in table. Further errors of this kind will be suppressed. # 2019-01-16T23:37:45 [23737] WARNING: Table/view 'view_t7' in schema 'test' has no 'char' columns # 2019-01-16T23:37:46 [23735] ErrorFilter: Query: SELECT NEXT VALUE FOR seq3 /* QNO 4783 CON_ID 14 */ failed: 4084 Sequence 'test.seq%d' has run out. Further errors of this kind will be suppressed. # 2019-01-16T23:37:50 [23735] ErrorFilter: Query: SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE t4 ADD COLUMN `vers_start` TIMESTAMP GENERATED ALWAYS AS ROW START, ADD PERIOD FOR SYSTEM_TIME(`row_start`, `vers_start`), ADD COLUMN `vers_start` TIMESTAMP(6) GENERATED ALWAYS AS ROW START /* QNO 5607 CON_ID 16 */ failed: 4134 Duplicate ROW START column `vers_start`. Further errors of this kind will be suppressed. # 2019-01-16T23:37:52 [23738] WARNING: Table/view 'view_t7' in schema 'test' has no 'char' columns # 2019-01-16T23:37:54 [23742] Executor::MySQL::execute: Query: ALTER IGNORE TABLE t3 KEY_BLOCK_SIZE 2048 /* QNO 7176 CON_ID 17 */ failed: 1478 Table storage engine 'InnoDB' does not support the create option 'KEY_BLOCK_SIZE' # 2019-01-16T23:37:54 [23735] ErrorFilter: Query: LOAD DATA INFILE 'load_t4' REPLACE INTO TABLE t4 /* QNO 7219 CON_ID 17 */ failed: 1406 Data too long for column 'bcol%d' at row %d. Further errors of this kind will be suppressed. # 2019-01-16T23:37:56 [23738] Executor::MySQL::execute: Query: CREATE OR REPLACE TABLE t8 (icol10 BIGINT UNSIGNED NOT NULL, ncol5 DOUBLE DEFAULT NULL /*!100303 INVISIBLE */ ) ROW_FORMAT PAGE /* QNO 7089 CON_ID 15 */ failed: 1005 Can't create table `test`.`t8` (errno: 140 "Wrong create options") # 2019-01-16T23:37:56 [23738] Executor::MySQL::execute: Query: CREATE TABLE IF NOT EXISTS t9 (`vers_start` TIMESTAMP(6) GENERATED ALWAYS AS ROW START, `vers_end` ENUM('foo','bar') GENERATED ALWAYS AS ROW END, PERIOD FOR SYSTEM_TIME ( `row_start`, `vers_end` )) ROW_FORMAT=DYNAMIC WITH SYSTEM VERSIONING PARTITION BY system_time INTERVAL 2 WEEK ( PARTITION ver_p1 HISTORY, PARTITION ver_pn CURRENT ) /* QNO 7182 CON_ID 15 */ failed: 4123 Table `t9` must have at least one versioned column # 2019-01-16T23:37:58 [23735] ErrorFilter: Query: SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE t9 CHANGE COLUMN IF EXISTS `row_end` `vers_end` TIMESTAMP(6) GENERATED ALWAYS AS ROW END, ADD COLUMN IF NOT EXISTS `vers_start` TIMESTAMP(6) GENERATED ALWAYS AS ROW START /* QNO 7534 CON_ID 16 */ failed: 4130 Can not change system versioning field `vers_end`. Further errors of this kind will be suppressed. # 2019-01-16T23:38:00 [23740] Executor::MySQL::execute: Query: CREATE TABLE t6 (`vers_start` BIGINT UNSIGNED GENERATED ALWAYS AS ROW START, `row_end` TIMESTAMP GENERATED ALWAYS AS ROW END, PERIOD FOR SYSTEM_TIME ( `vers_start`, `vers_end` )) ENGINE=InnoDB ROW_FORMAT=COMPACT WITH SYSTEM VERSIONING PARTITION BY system_time INTERVAL 3 MINUTE ( PARTITION ver_p1 HISTORY, PARTITION ver_p2 HISTORY, PARTITION ver_pn CURRENT ) /* QNO 7919 CON_ID 16 */ failed: 4123 Table `t6` must have at least one versioned column # 2019-01-16T23:38:00 [23737] Executor::MySQL::execute: Query: CREATE OR REPLACE TABLE t5 (scol4 TEXT NOT NULL ) ROW_FORMAT PAGE /* QNO 8117 CON_ID 14 */ failed: 1005 Can't create table `test`.`t5` (errno: 140 "Wrong create options") # 2019-01-16T23:38:02 [23735] ErrorFilter: Query: SHOW GRANTS FOR root /* QNO 8554 CON_ID 15 */ failed: 1141 There is no such grant defined for user '%s' on host '%s'. Further errors of this kind will be suppressed. # 2019-01-16T23:39:04 [23735] ErrorFilter: Query: SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE t4 ADD SYSTEM VERSIONING /* QNO 10174 CON_ID 14 */ failed: 1969 Query execution was interrupted (max_statement_time exceeded). Further errors of this kind will be suppressed. # 2019-01-16T23:39:20 [23636] #--------------------------# # 2019-01-16T23:39:20 [23636] #-- Creating full backup --# # 2019-01-16T23:39:20 [23636] #--------------------------# # 2019-01-16T23:39:20 [23636] /home/travis/server/bin/mariabackup --backup --target-dir=/home/travis/logs/vardir/backup --protocol=tcp --port=19300 --user=root 2>/home/travis/logs/vardir/mbackup_backup.log # 2019-01-16T23:39:22 [23636] #---------------------------------------# # 2019-01-16T23:39:22 [23636] #-- Continuing test flow after backup --# # 2019-01-16T23:39:22 [23636] #---------------------------------------# # 2019-01-16T23:39:31 [23735] ErrorFilter: Query: DELETE HISTORY FROM `t6` BEFORE SYSTEM_TIME 2 /* QNO 10701 CON_ID 14 */ failed: 4111 Transaction system versioning for `t%d` is not supported. Further errors of this kind will be suppressed. # 2019-01-16T23:39:39 [23742] WARNING: Table/view 'view_t7' in schema 'test' has no 'char' columns # 2019-01-16T23:39:39 [23735] ErrorFilter: Query: LOAD DATA INFILE 'load_t9' REPLACE INTO TABLE t9 /* QNO 10827 CON_ID 16 */ failed: 1261 Row %d doesn't contain data for all columns. Further errors of this kind will be suppressed. # 2019-01-16T23:39:42 [23740] Executor::MySQL::execute: Query: CREATE OR REPLACE TEMPORARY TABLE t5 (icol4 MEDIUMINT DEFAULT 2 ) ROW_FORMAT FIXED /* QNO 10874 CON_ID 16 */ failed: 1005 Can't create table `test`.`t5` (errno: 140 "Wrong create options") # 2019-01-16T23:40:08 [23735] ErrorFilter: Query: ALTER IGNORE TABLE `t9` ADD FOREIGN KEY (icol4) REFERENCES `t7` (ncol5) ON DELETE SET DEFAULT, /*!100200 DROP CONSTRAINT IF EXISTS k */ /* COMMENT 'Skipped DROP CONSTRAINT' */ /* QNO 11505 CON_ID 15 */ failed: 1506 Foreign key clause is not yet supported in conjunction with partitioning. Further errors of this kind will be suppressed. # 2019-01-16T23:40:21 [23738] Executor::MySQL::execute: Query: CREATE OR REPLACE TABLE t2 (icol3 BIGINT UNSIGNED NOT NULL, vcol8 SET('foo','bar') AS ( ecol9 ) /*!100201 STORED */ /* PERSISTENT */, icol8 INT UNSIGNED NOT NULL /*!100303 INVISIBLE */ ) ROW_FORMAT FIXED /* QNO 11612 CON_ID 15 */ failed: 4108 Invisible column `icol8` must have a default value # 2019-01-16T23:41:18 [23636] #-------------------------# # 2019-01-16T23:41:18 [23636] #-- Stopping the server --# # 2019-01-16T23:41:18 [23636] #-------------------------# # 2019-01-16T23:41:18 [23636] Stopping server on port 19300 # 2019-01-16T23:41:18 [23740] Executor::MySQL::execute: Query: INSERT INTO t10 ( ncol8 ) SELECT vcol10 FROM t6 /* QNO 12078 CON_ID 16 */ failed: 1053 Server shutdown in progress # 2019-01-16T23:41:18 [23740] Mixer: Server crash or critical failure 1053 (STATUS_SERVER_KILLED) reported at dsn dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test:mysql_local_infile=1 # 2019-01-16T23:41:18 [23740] GenTest: Server crash or critical failure (STATUS_SERVER_KILLED) reported, the child will be stopped # 2019-01-16T23:41:18 [23740] GenTest: child 23740 is being stopped with status STATUS_SERVER_KILLED # 2019-01-16T23:41:18 [23738] Executor::MySQL::execute: Query: ALTER ONLINE TABLE t10 DROP FOREIGN KEY IF EXISTS t /* QNO 12359 CON_ID 15 */ failed: 1053 Server shutdown in progress # 2019-01-16T23:41:18 [23738] Mixer: Server crash or critical failure 1053 (STATUS_SERVER_KILLED) reported at dsn dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test:mysql_local_infile=1 # 2019-01-16T23:41:18 [23738] GenTest: Server crash or critical failure (STATUS_SERVER_KILLED) reported, the child will be stopped # 2019-01-16T23:41:18 [23738] GenTest: child 23738 is being stopped with status STATUS_SERVER_KILLED # 2019-01-16T23:41:18 [23737] Executor::MySQL::execute: Query: SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE t10 REMOVE PARTITIONING /* QNO 11863 CON_ID 14 */ failed: 1053 Server shutdown in progress # 2019-01-16T23:41:18 [23737] Mixer: Server crash or critical failure 1053 (STATUS_SERVER_KILLED) reported at dsn dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test:mysql_local_infile=1 # 2019-01-16T23:41:18 [23737] GenTest: Server crash or critical failure (STATUS_SERVER_KILLED) reported, the child will be stopped # 2019-01-16T23:41:18 [23737] GenTest: child 23737 is being stopped with status STATUS_SERVER_KILLED # 2019-01-16T23:41:18 [23742] Executor::MySQL::execute: Query: SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE t10 PARTITION BY system_time INTERVAL 6 MINUTE ( PARTITION ver_p1 HISTORY, PARTITION ver_p2 HISTORY, PARTITION ver_pn CURRENT ) /* QNO 12317 CON_ID 17 */ failed: 1053 Server shutdown in progress # 2019-01-16T23:41:18 [23742] Mixer: Server crash or critical failure 1053 (STATUS_SERVER_KILLED) reported at dsn dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test:mysql_local_infile=1 # 2019-01-16T23:41:18 [23742] GenTest: Server crash or critical failure (STATUS_SERVER_KILLED) reported, the child will be stopped # 2019-01-16T23:41:18 [23742] GenTest: child 23742 is being stopped with status STATUS_SERVER_KILLED # 2019-01-16T23:41:19 [23732] Process with pid 23738 ended with status STATUS_SERVER_KILLED # 2019-01-16T23:41:19 [23732] Killing remaining worker process with pid 23740... # 2019-01-16T23:41:19 [23732] Killing remaining worker process with pid 23737... # 2019-01-16T23:41:19 [23732] Killing remaining worker process with pid 23742... DBI connect('host=127.0.0.1:port=19300:user=root:database=test:mysql_local_infile=1','',...) failed: Can't connect to MySQL server on '127.0.0.1' (111) at /home/travis/rqg/lib/GenTest/Reporter/Deadlock.pm line 82. # 2019-01-16T23:41:19 [23736] GenTest: child 23736 is being stopped with status STATUS_SERVER_CRASHED # 2019-01-16T23:41:19 [23636] Server has been stopped # 2019-01-16T23:41:19 [23636] #-------------------------------------------------------------# # 2019-01-16T23:41:19 [23636] #-- Checking the server log for fatal errors after shutdown --# # 2019-01-16T23:41:19 [23636] #-------------------------------------------------------------# # 2019-01-16T23:41:19 [23636] Checking server log for important errors starting from the beginning # 2019-01-16T23:41:19 [23636] #----------------------------------------------# # 2019-01-16T23:41:19 [23636] #-- Backing up data directory before restart --# # 2019-01-16T23:41:19 [23636] #----------------------------------------------# # 2019-01-16T23:41:19 [23636] Copying datadir... (interrupting the copy operation may cause investigation problems later) # 2019-01-16T23:41:20 [23636] #----------------------# # 2019-01-16T23:41:20 [23636] #-- Preparing backup --# # 2019-01-16T23:41:20 [23636] #----------------------# # 2019-01-16T23:41:20 [23636] Storing the backup before prepare attempt... # 2019-01-16T23:41:20 [23732] Killing periodic reporting process with pid 23736... # 2019-01-16T23:41:20 [23732] For pid 23736 reporter status STATUS_SERVER_CRASHED # 2019-01-16T23:41:20 [23732] Kill GenTest::ErrorFilter(23735) # 2019-01-16T23:41:20 [23732] Test completed successfully. # 2019-01-16T23:41:20 [23636] /home/travis/server/bin/mariabackup --prepare --target-dir=/home/travis/logs/vardir/backup --user=root 2>/home/travis/logs/vardir/mbackup_prepare.log # 2019-01-16T23:41:21 [23636] #----------------------# # 2019-01-16T23:41:21 [23636] #-- Restoring backup --# # 2019-01-16T23:41:21 [23636] #----------------------# # 2019-01-16T23:41:21 [23636] /home/travis/server/bin/mariabackup --copy-back --target-dir=/home/travis/logs/vardir/backup --datadir=/home/travis/logs/vardir/data --user=root 2>/home/travis/logs/vardir/mbackup_restore.log # 2019-01-16T23:41:22 [23636] #---------------------------# # 2019-01-16T23:41:22 [23636] #-- Restarting the server --# # 2019-01-16T23:41:22 [23636] #---------------------------# # 2019-01-16T23:41:22 [23636] MySQL Version: 10.4.2 # 2019-01-16T23:41:22 [23636] Binary: /home/travis/server/bin/mysqld # 2019-01-16T23:41:22 [23636] Type: Debug # 2019-01-16T23:41:22 [23636] Datadir: /home/travis/logs/vardir/data # 2019-01-16T23:41:22 [23636] Tmpdir: /home/travis/logs/vardir/tmp # 2019-01-16T23:41:22 [23636] Corefile: /home/travis/logs/vardir/data/core.23696 # 2019-01-16T23:41:22 [23636] Starting MySQL 10.4.2: "/home/travis/server/bin/mysqld" "--no-defaults" "--basedir=/home/travis/server" "--lc-messages-dir=/home/travis/server/share" "--character-sets-dir=/home/travis/server/share/charsets" "--tmpdir=/home/travis/logs/vardir/tmp" "--core-file" "--datadir=/home/travis/logs/vardir/data" "--max-allowed-packet=128Mb" "--port=19300" "--socket=/home/travis/logs/vardir/mysql.sock" "--pid-file=/home/travis/logs/vardir/mysql.pid" "--general-log" "--general-log-file=/home/travis/logs/vardir/mysql.log" --log_output=FILE --max-statement-time=20 --lock-wait-timeout=10 --loose-innodb-lock-wait-timeout=5 --loose-debug_assert_on_not_freed_memory=0 --innodb-encrypt-tables --innodb-encrypt-log --innodb-encryption-threads=4 --aria-encrypt-tables=1 --encrypt-tmp-disk-tables=1 --file-key-management --file-key-management-filename=/home/travis/mariadb-toolbox/data/keys.txt --plugin-load-add=file_key_management --innodb-compression-algorithm=zlib --innodb-page-size=8K # 2019-01-16T23:41:22 [23636] Pid file does not exist and timeout hasn't passed yet, but the error log has already been updated # 2019-01-16T23:41:22 [23636] Found PID 23791 in the error log # 2019-01-16T23:41:23 [23636] Server started with PID 23791 # 2019-01-16T23:41:23 [23636] #------------------------------------------------------------# # 2019-01-16T23:41:23 [23636] #-- Checking the server error log for errors after restart --# # 2019-01-16T23:41:23 [23636] #------------------------------------------------------------# # 2019-01-16T23:41:23 [23636] Checking server log for important errors starting from the beginning # 2019-01-16T23:41:23 [23636] ------ # 2019-01-16T23:41:23 [23636] 2019-01-16 23:41:23 0 [ERROR] InnoDB: Operating system error number 2 in a file operation. # 2019-01-16T23:41:23 [23636] 2019-01-16 23:41:23 0 [ERROR] InnoDB: The error means the system cannot find the path specified. # 2019-01-16T23:41:23 [23636] 2019-01-16 23:41:23 0 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them. # 2019-01-16T23:41:23 [23636] 2019-01-16 23:41:23 0 [ERROR] InnoDB: Cannot open datafile for read-only: './test/#sql-5c90_11.ibd' OS error: 71 # 2019-01-16T23:41:23 [23636] 2019-01-16 23:41:23 0 [ERROR] InnoDB: Operating system error number 2 in a file operation. # 2019-01-16T23:41:23 [23636] 2019-01-16 23:41:23 0 [ERROR] InnoDB: The error means the system cannot find the path specified. # 2019-01-16T23:41:23 [23636] 2019-01-16 23:41:23 0 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them. # 2019-01-16T23:41:23 [23636] 2019-01-16 23:41:23 0 [ERROR] InnoDB: Could not find a valid tablespace file for ``test`.`#sql-5c90_11``. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue. # 2019-01-16T23:41:23 [23636] 2019-01-16 23:41:23 0 [ERROR] InnoDB: Operating system error number 2 in a file operation. # 2019-01-16T23:41:23 [23636] 2019-01-16 23:41:23 0 [ERROR] InnoDB: The error means the system cannot find the path specified. # 2019-01-16T23:41:23 [23636] 2019-01-16 23:41:23 0 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them. # 2019-01-16T23:41:23 [23636] 2019-01-16 23:41:23 0 [ERROR] InnoDB: Cannot open datafile for read-only: './test/#sql-5c90_e.ibd' OS error: 71 # 2019-01-16T23:41:23 [23636] 2019-01-16 23:41:23 0 [ERROR] InnoDB: Operating system error number 2 in a file operation. # 2019-01-16T23:41:23 [23636] 2019-01-16 23:41:23 0 [ERROR] InnoDB: The error means the system cannot find the path specified. # 2019-01-16T23:41:23 [23636] 2019-01-16 23:41:23 0 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them. # 2019-01-16T23:41:23 [23636] 2019-01-16 23:41:23 0 [ERROR] InnoDB: Could not find a valid tablespace file for ``test`.`#sql-5c90_e``. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue. # 2019-01-16T23:41:23 [23636] 2019-01-16 23:41:23 0 [ERROR] InnoDB: Operating system error number 2 in a file operation. # 2019-01-16T23:41:23 [23636] 2019-01-16 23:41:23 0 [ERROR] InnoDB: The error means the system cannot find the path specified. # 2019-01-16T23:41:23 [23636] 2019-01-16 23:41:23 0 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them. # 2019-01-16T23:41:23 [23636] 2019-01-16 23:41:23 0 [ERROR] InnoDB: Cannot open datafile for read-only: './test/#sql-5c90_11.ibd' OS error: 71 # 2019-01-16T23:41:23 [23636] 2019-01-16 23:41:23 0 [ERROR] InnoDB: Operating system error number 2 in a file operation. # 2019-01-16T23:41:23 [23636] 2019-01-16 23:41:23 0 [ERROR] InnoDB: The error means the system cannot find the path specified. # 2019-01-16T23:41:23 [23636] 2019-01-16 23:41:23 0 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them. # 2019-01-16T23:41:23 [23636] 2019-01-16 23:41:23 0 [ERROR] InnoDB: Could not find a valid tablespace file for ``test`.`#sql-5c90_11``. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue. # 2019-01-16T23:41:23 [23636] 2019-01-16 23:41:23 0 [ERROR] InnoDB: Operating system error number 2 in a file operation. # 2019-01-16T23:41:23 [23636] 2019-01-16 23:41:23 0 [ERROR] InnoDB: The error means the system cannot find the path specified. # 2019-01-16T23:41:23 [23636] 2019-01-16 23:41:23 0 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them. # 2019-01-16T23:41:23 [23636] 2019-01-16 23:41:23 0 [ERROR] InnoDB: Cannot open datafile for read-only: './test/#sql-5c90_e.ibd' OS error: 71 # 2019-01-16T23:41:23 [23636] 2019-01-16 23:41:23 0 [ERROR] InnoDB: Operating system error number 2 in a file operation. # 2019-01-16T23:41:23 [23636] 2019-01-16 23:41:23 0 [ERROR] InnoDB: The error means the system cannot find the path specified. # 2019-01-16T23:41:23 [23636] 2019-01-16 23:41:23 0 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them. # 2019-01-16T23:41:23 [23636] 2019-01-16 23:41:23 0 [ERROR] InnoDB: Could not find a valid tablespace file for ``test`.`#sql-5c90_e``. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue. # 2019-01-16T23:41:23 [23636] ------ # 2019-01-16T23:41:23 [23636][ERROR] Found errors in the log, restart has apparently failed # 2019-01-16T23:41:23 [23636] Killed process 23791 # 2019-01-16T23:41:23 [23636] [23636] ./runall-new.pl will exit with exit status STATUS_BACKUP_FAILURE (108)