# 2019-01-10T03:58:02 [24290] Converted --seed=time to --seed=1547092682 # 2019-01-10T03:58:02 [24290] Copyright (c) 2010,2011 Oracle and/or its affiliates. All rights reserved. Use is subject to license terms. # 2019-01-10T03:58:02 [24290] Please see http://forge.mysql.com/wiki/Category:RandomQueryGenerator for more information on this test framework. # 2019-01-10T03:58:02 [24290] Starting # 2019-01-10T03:58:02 [24290] # ./runall-new.pl \ # 2019-01-10T03:58:02 [24290] # --basedir=/home/travis/server \ # 2019-01-10T03:58:02 [24290] # --vardir=/home/travis/logs/vardir \ # 2019-01-10T03:58:02 [24290] # --duration=350 \ # 2019-01-10T03:58:02 [24290] # --threads=4 \ # 2019-01-10T03:58:02 [24290] # --seed=time \ # 2019-01-10T03:58:02 [24290] # --reporters=Backtrace,ErrorLog,Deadlock \ # 2019-01-10T03:58:02 [24290] # --skip-gendata \ # 2019-01-10T03:58:02 [24290] # --gendata-advanced \ # 2019-01-10T03:58:02 [24290] # --views \ # 2019-01-10T03:58:02 [24290] # --grammar=conf/mariadb/generic-dml.yy \ # 2019-01-10T03:58:02 [24290] # --redefine=conf/mariadb/bulk_insert.yy \ # 2019-01-10T03:58:02 [24290] # --mysqld=--log_output=FILE \ # 2019-01-10T03:58:02 [24290] # --mysqld=--max-statement-time=20 \ # 2019-01-10T03:58:02 [24290] # --mysqld=--lock-wait-timeout=10 \ # 2019-01-10T03:58:02 [24290] # --mysqld=--loose-innodb-lock-wait-timeout=5 \ # 2019-01-10T03:58:02 [24290] # --mysqld=--loose-debug_assert_on_not_freed_memory=0 \ # 2019-01-10T03:58:02 [24290] # --filter=/home/travis/mariadb-toolbox/travis/10.4-combo-filter.ff \ # 2019-01-10T03:58:02 [24290] # --mysqld=--innodb-compression-algorithm=none \ # 2019-01-10T03:58:02 [24290] # --innodb-page-size=8K \ # 2019-01-10T03:58:02 [24290] # --engine=InnoDB \ # 2019-01-10T03:58:02 [24290] # --scenario=MariaBackupFull \ # 2019-01-10T03:58:02 [24290] # --redefine=conf/mariadb/alter_table.yy \ # 2019-01-10T03:58:02 [24290] # --redefine=conf/mariadb/modules/admin.yy \ # 2019-01-10T03:58:02 [24290] # --redefine=conf/mariadb/versioning.yy \ # 2019-01-10T03:58:02 [24290] # --redefine=conf/mariadb/sequences.yy # 2019-01-10T03:58:02 [24290] Ports : 19300 19300 19302 19304 MTR_BUILD_THREAD : 930 # 2019-01-10T03:58:02 [24290] Final command line: # 2019-01-10T03:58:02 [24290] perl ./runall-new.pl --basedir=/home/travis/server --vardir=/home/travis/logs/vardir --duration=350 --threads=4 --seed=1547092682 --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-compression-algorithm=none --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-10T03:58:02 [24290] # 2019-01-10T03:58:02 [24290] ================================= # 2019-01-10T03:58:02 [24290] === Full MariaBackup scenario === # 2019-01-10T03:58:02 [24290] ================================= # 2019-01-10T03:58:02 [24290] # 2019-01-10T03:58:02 [24290] Creating MySQL 10.4.2 database at /home/travis/logs/vardir/data # 2019-01-10T03:58:02 [24290] 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-compression-algorithm=none" "--skip-log-bin" "--loose-innodb-encrypt-tables=OFF" "--loose-innodb-encrypt-log=OFF" "--bootstrap" < "/home/travis/logs/vardir/boot.sql" # 2019-01-10T03:58:05 [24290] -- Server info: -- # 2019-01-10T03:58:05 [24290] 10.4.2 # 2019-01-10T03:58:05 [24290] --log_output=FILE # 2019-01-10T03:58:05 [24290] --max-statement-time=20 # 2019-01-10T03:58:05 [24290] --lock-wait-timeout=10 # 2019-01-10T03:58:05 [24290] --loose-innodb-lock-wait-timeout=5 # 2019-01-10T03:58:05 [24290] --loose-debug_assert_on_not_freed_memory=0 # 2019-01-10T03:58:05 [24290] --innodb-compression-algorithm=none # 2019-01-10T03:58:05 [24290] #-------------------------# # 2019-01-10T03:58:05 [24290] #-- Starting the server --# # 2019-01-10T03:58:05 [24290] #-------------------------# # 2019-01-10T03:58:05 [24290] MySQL Version: 10.4.2 # 2019-01-10T03:58:05 [24290] Binary: /home/travis/server/bin/mysqld # 2019-01-10T03:58:05 [24290] Type: Debug # 2019-01-10T03:58:05 [24290] Datadir: /home/travis/logs/vardir/data # 2019-01-10T03:58:05 [24290] Tmpdir: /home/travis/logs/vardir/tmp # 2019-01-10T03:58:05 [24290] Corefile: /home/travis/logs/vardir/data/core. # 2019-01-10T03:58:05 [24290] 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-compression-algorithm=none # 2019-01-10T03:58:05 [24290] Pid file does not exist and timeout hasn't passed yet, but the error log has already been updated # 2019-01-10T03:58:05 [24290] Found PID 24347 in the error log # 2019-01-10T03:58:06 [24290] Server started with PID 24347 # 2019-01-10T03:58:06 [24290] Connecting to 19300 # 2019-01-10T03:58:06 [24290] #---------------------------------------------# # 2019-01-10T03:58:06 [24290] #-- Running initial test flow on the server --# # 2019-01-10T03:58:06 [24290] #---------------------------------------------# # 2019-01-10T03:58:06 [24379] ------------------------------- # 2019-01-10T03:58:06 [24379] Configuration # 2019-01-10T03:58:06 [24379] debug_server => ['', '', ''] # 2019-01-10T03:58:06 [24379] dsn => ['dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test:mysql_local_infile=1'] # 2019-01-10T03:58:06 [24379] duration => 233 # 2019-01-10T03:58:06 [24379] engine => ['InnoDB', 'InnoDB', 'InnoDB'] # 2019-01-10T03:58:06 [24379] filter => /home/travis/mariadb-toolbox/travis/10.4-combo-filter.ff # 2019-01-10T03:58:06 [24379] gendata-advanced => 1 # 2019-01-10T03:58:06 [24379] generator => FromGrammar # 2019-01-10T03:58:06 [24379] grammar => conf/mariadb/generic-dml.yy # 2019-01-10T03:58:06 [24379] queries => 100000000 # 2019-01-10T03:58:06 [24379] 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-10T03:58:06 [24379] reporters => ['Backtrace', 'ErrorLog', 'Deadlock'] # 2019-01-10T03:58:06 [24379] seed => 1547092682 # 2019-01-10T03:58:06 [24379] servers => ['DBServer::MySQL::MySQLd=ARRAY(0x232dc20)'] # 2019-01-10T03:58:06 [24379] strict_fields => 1 # 2019-01-10T03:58:06 [24379] threads => 4 # 2019-01-10T03:58:06 [24379] transformers => [''] # 2019-01-10T03:58:06 [24379] validators => [''] # 2019-01-10T03:58:06 [24379] vcols => ['', '', ''] # 2019-01-10T03:58:06 [24379] views => ['', '', ''] # 2019-01-10T03:58:06 [24379] Creating MySQL table t1, size 0 rows, engine InnoDB . # 2019-01-10T03:58:06 [24379] Executor::MySQL::execute: 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 # 2019-01-10T03:58:06 [24379] Executor::MySQL::execute: 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 # 2019-01-10T03:58:06 [24379] Executor::MySQL::execute: Query: ALTER TABLE t1 ADD UNIQUE(col_datetime,col_date,col_time,col_varchar(64)) /* QNO 7 CON_ID 9 */ failed: 4097 Compressed column 'col_varchar' can't be used in key specification # 2019-01-10T03:58:06 [24379] Executor::MySQL::execute: Query: ALTER TABLE t1 ADD INDEX(col_blob(64),col_char(64),col_timestamp) /* QNO 9 CON_ID 9 */ failed: 4097 Compressed column 'col_blob' can't be used in key specification # 2019-01-10T03:58:06 [24379] Executor::MySQL::execute: Query: ALTER TABLE t1 ADD INDEX(col_year,col_timestamp,pk,col_blob(64)) /* QNO 10 CON_ID 9 */ failed: 4097 Compressed column 'col_blob' can't be used in key specification # 2019-01-10T03:58:06 [24379] Creating MySQL table t2, size 1 rows, engine InnoDB . # 2019-01-10T03:58:06 [24379] Creating MySQL table t3, size 20 rows, engine InnoDB . # 2019-01-10T03:58:06 [24379] Creating MySQL table t4, size 100 rows, engine InnoDB . # 2019-01-10T03:58:06 [24379] Creating MySQL table t5, size 1000 rows, engine InnoDB . # 2019-01-10T03:58:06 [24379] Executor::MySQL::execute: Query: ALTER TABLE t5 ADD INDEX(col_blob(64),col_enum,pk) /* QNO 46 CON_ID 9 */ failed: 4097 Compressed column 'col_blob' can't be used in key specification # 2019-01-10T03:58:07 [24379] Creating MySQL table t6, size 0 rows, engine InnoDB . # 2019-01-10T03:58:07 [24379] Executor::MySQL::execute: Query: ALTER TABLE t6 ADD INDEX(col_blob(64),col_int) /* QNO 57 CON_ID 9 */ failed: 4097 Compressed column 'col_blob' can't be used in key specification # 2019-01-10T03:58:07 [24379] Executor::MySQL::execute: Query: ALTER TABLE t6 ADD UNIQUE(col_char(27),col_blob(64),col_bit) /* QNO 59 CON_ID 9 */ failed: 4097 Compressed column 'col_blob' can't be used in key specification # 2019-01-10T03:58:07 [24379] Creating MySQL table t7, size 1 rows, engine InnoDB . # 2019-01-10T03:58:07 [24379] Creating MySQL table t8, size 20 rows, engine InnoDB . # 2019-01-10T03:58:07 [24379] Creating MySQL table t9, size 100 rows, engine InnoDB . # 2019-01-10T03:58:07 [24379] Executor::MySQL::execute: Query: ALTER TABLE t9 ADD UNIQUE(col_year,col_time,col_blob(64),col_datetime) /* QNO 85 CON_ID 9 */ failed: 4097 Compressed column 'col_blob' can't be used in key specification # 2019-01-10T03:58:07 [24379] Reading grammar from file conf/mariadb/generic-dml.yy # 2019-01-10T03:58:07 [24379] Reading grammar from file conf/mariadb/bulk_insert.yy # 2019-01-10T03:58:07 [24379] Reading grammar from file conf/mariadb/alter_table.yy # 2019-01-10T03:58:07 [24379] Reading grammar from file conf/mariadb/modules/admin.yy # 2019-01-10T03:58:07 [24379] Reading grammar from file conf/mariadb/versioning.yy # 2019-01-10T03:58:07 [24379] Reading grammar from file conf/mariadb/sequences.yy # 2019-01-10T03:58:07 [24379] Reporters: Backtrace, ErrorLog, Deadlock # 2019-01-10T03:58:07 [24379] Validators: QueryProperties # 2019-01-10T03:58:07 [24379] Caching schema metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test:mysql_local_infile=1 # 2019-01-10T03:58:08 [24379] Loaded 5 filtering rules from '/home/travis/mariadb-toolbox/travis/10.4-combo-filter.ff' # 2019-01-10T03:58:08 [24379] Starting 4 processes, 100000000 queries each, duration 233 seconds. # 2019-01-10T03:58:08 [24379] GenTest::ErrorFilter(24382) started # 2019-01-10T03:58:08 [24384] Mixer: Loading Validator GenTest::Validator::QueryProperties. # 2019-01-10T03:58:08 [24382] ErrorFilter: Query: CREATE OR REPLACE TABLE `view_t6` (icol4 SMALLINT NOT NULL DEFAULT 0, scol8 VARCHAR(23992) NULL, scol8 VARBINARY(28095) NULL DEFAULT '' ) ROW_FORMAT COMPRESSED /* QNO 91 CON_ID 14 */ failed: 1965 'test.view_t%d' is a view. Further errors of this kind will be suppressed. # 2019-01-10T03:58:08 [24382] ErrorFilter: Query: CREATE OR REPLACE TABLE t7 (icol1 MEDIUMINT UNSIGNED NOT NULL DEFAULT NULL ) /* QNO 92 CON_ID 14 */ failed: 1067 Invalid default value for 'icol%d'. Further errors of this kind will be suppressed. # 2019-01-10T03:58:09 [24384] Executor::MySQL::execute: Query: CREATE OR REPLACE TABLE t8 (scol4 TEXT, icol10 TINYINT ) ROW_FORMAT = PAGE /* QNO 96 CON_ID 14 */ failed: 1005 Can't create table `test`.`t8` (errno: 140 "Wrong create options") # 2019-01-10T03:58:09 [24384] Executor::MySQL::execute: Query: CREATE OR REPLACE TABLE t3 (icol7 MEDIUMINT NULL DEFAULT NULL, tcol7 DATE NOT NULL /*!100303 INVISIBLE */ /*!100201 CHECK (tscol8 <= `col_timestamp`) */) ROW_FORMAT DYNAMIC /* QNO 97 CON_ID 14 */ failed: 4108 Invisible column `tcol7` must have a default value # 2019-01-10T03:58:09 [24385] Mixer: Loading Validator GenTest::Validator::QueryProperties. # 2019-01-10T03:58:09 [24382] ErrorFilter: Query: CREATE OR REPLACE TABLE t7 (vcol6 BIGINT AS ( icol2 + 0 ) VIRTUAL ) /* QNO 98 CON_ID 14 */ failed: 1054 Unknown column '%s' in 'GENERATED ALWAYS AS'. Further errors of this kind will be suppressed. # 2019-01-10T03:58:09 [24382] ErrorFilter: Query: CREATE OR REPLACE TABLE t5 (scol6 TEXT NULL /*!100303 INVISIBLE */ ) /* QNO 91 CON_ID 15 */ failed: 1113 A table must have at least %d column. Further errors of this kind will be suppressed. # 2019-01-10T03:58:09 [24382] ErrorFilter: Query: SHOW CREATE FUNCTION b /* QNO 101 CON_ID 14 */ failed: 1305 FUNCTION %s does not exist. Further errors of this kind will be suppressed. # 2019-01-10T03:58:09 [24382] ErrorFilter: Query: UPDATE IGNORE `t3` SET `col_enum` = '' ORDER BY `col_bit` LIMIT 1 /* QNO 104 CON_ID 14 */ failed: 1146 Table '%s' doesn't exist. Further errors of this kind will be suppressed. # 2019-01-10T03:58:09 [24387] Mixer: Loading Validator GenTest::Validator::QueryProperties. # 2019-01-10T03:58:09 [24382] ErrorFilter: Query: UPDATE IGNORE `view_t3` SET `col_blob` = 'w' ORDER BY `col_year` LIMIT 1 /* QNO 109 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-10T03:58:09 [24389] Mixer: Loading Validator GenTest::Validator::QueryProperties. # 2019-01-10T03:58:09 [24389] Executor::MySQL::execute: Query: CREATE OR REPLACE TABLE t2 (`col_char` BINARY NULL ) ROW_FORMAT PAGE /* QNO 92 CON_ID 17 */ failed: 1005 Can't create table `test`.`t2` (errno: 140 "Wrong create options") # 2019-01-10T03:58:09 [24387] Executor::MySQL::execute: Query: CREATE OR REPLACE TEMPORARY TABLE t8 (tscol10 TIMESTAMP NULL DEFAULT 0 ) ROW_FORMAT = FIXED /* QNO 94 CON_ID 16 */ failed: 1005 Can't create table `test`.`t8` (errno: 140 "Wrong create options") # 2019-01-10T03:58:09 [24382] ErrorFilter: Query: SHOW EXPLAIN FOR 160 /* QNO 137 CON_ID 14 */ failed: 1094 Unknown thread id: %s%d. Further errors of this kind will be suppressed. # 2019-01-10T03:58:09 [24382] ErrorFilter: Query: CREATE TABLE t8 LIKE `view_t2` /* QNO 139 CON_ID 14 */ failed: 1347 'test.view_t%d' is not of type 'BASE TABLE'. Further errors of this kind will be suppressed. # 2019-01-10T03:58:09 [24382] ErrorFilter: Query: INSERT IGNORE INTO `view_t7` () VALUES () /* QNO 146 CON_ID 14 */ failed: 1136 Column count doesn't match value count at row %d. Further errors of this kind will be suppressed. # 2019-01-10T03:58:09 [24383] Started periodic reporting process... # 2019-01-10T03:58:09 [24382] ErrorFilter: Query: CREATE SEQUENCE seq4 MAXVALUE = -1277051969336246272 INCREMENT = 7 ENGINE=InnoDB /* QNO 111 CON_ID 17 */ failed: 4085 Sequence 'test.seq%d' values are conflicting. Further errors of this kind will be suppressed. # 2019-01-10T03:58:09 [24382] ErrorFilter: Query: ALTER TABLE `t4` DROP PARTITION IF EXISTS ver_p4 /* QNO 110 CON_ID 16 */ failed: 1505 Partition management on a not partitioned table is not possible. Further errors of this kind will be suppressed. # 2019-01-10T03:58:09 [24382] ErrorFilter: Query: REPLACE INTO `t3` () VALUES () /* QNO 131 CON_ID 15 */ failed: 1364 Field 'next_not_cached_value' doesn't have a default value. Further errors of this kind will be suppressed. # 2019-01-10T03:58:09 [24382] ErrorFilter: Query: ALTER ONLINE TABLE t10 DROP INDEX ind6, /*!100200 DROP CONSTRAINT s */ /* COMMENT 'Skipped DROP CONSTRAINT' */, ADD CONSTRAINT v CHECK (tcol8 >= `pk`), ADD KEY(ecol5) /*!100307, ALGORITHM=INSTANT */, AUTO_INCREMENT 799145984, DROP COLUMN IF EXISTS tscol2, ALGORITHM=DEFAULT, LOCK=SHARED /* QNO 165 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-10T03:58:09 [24382] ErrorFilter: Query: DELETE FROM `view_t1` ORDER BY `col_datetime` LIMIT 1 /* QNO 137 CON_ID 17 */ failed: 1213 Deadlock found when trying to get lock; try restarting transaction. Further errors of this kind will be suppressed. # 2019-01-10T03:58:09 [24382] ErrorFilter: Query: SELECT * FROM `t2` INTO OUTFILE 'load_t2' /* QNO 156 CON_ID 16 */ failed: 1086 File '%s' already exists. Further errors of this kind will be suppressed. # 2019-01-10T03:58:09 [24382] ErrorFilter: Query: ALTER IGNORE TABLE `t4` ADD IF NOT EXISTS ( tcol3 DATE /*!100201 CHECK (scol5 >= ncol6) */ ) /*!100307, ALGORITHM=NOCOPY */, LOCK=DEFAULT, ADD FULLTEXT KEY(scol7), ALGORITHM=INPLACE /* QNO 152 CON_ID 17 */ failed: 1072 Key column '%s' doesn't exist in table. Further errors of this kind will be suppressed. # 2019-01-10T03:58:09 [24382] ErrorFilter: Query: ALTER TABLE t9 MODIFY COLUMN IF EXISTS `pk` TINYINT FIRST, ALGORITHM=DEFAULT, LOCK=SHARED, ADD FOREIGN KEY (tcol3) REFERENCES t10 (`col_date`) /* QNO 162 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-10T03:58:09 [24382] ErrorFilter: Query: ALTER TABLE t3 /*!100301 NOWAIT */ RENAME TO `t1` /* QNO 172 CON_ID 15 */ failed: 1205 Lock wait timeout exceeded; try restarting transaction. Further errors of this kind will be suppressed. # 2019-01-10T03:58:09 [24382] ErrorFilter: Query: CREATE TABLE t5 LIKE `t5` /* QNO 238 CON_ID 14 */ failed: 1066 Not unique table/alias: '%s'. Further errors of this kind will be suppressed. # 2019-01-10T03:58:09 [24382] ErrorFilter: Query: ALTER ONLINE TABLE t3 RENAME TO t2 /* QNO 178 CON_ID 15 */ failed: 1845 LOCK=NONE/SHARED is not supported for this operation. Try LOCK=EXCLUSIVE. Further errors of this kind will be suppressed. # 2019-01-10T03:58:09 [24382] ErrorFilter: Query: SHOW CREATE USER root /* QNO 196 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-10T03:58:09 [24382] ErrorFilter: Query: ALTER TABLE t4 PARTITION BY KEY(ecol6) /* QNO 254 CON_ID 14 */ failed: 1488 Field in list of fields for partition function not found in table. Further errors of this kind will be suppressed. # 2019-01-10T03:58:09 [24382] ErrorFilter: Query: ALTER TABLE t10 ADD COLUMN IF NOT EXISTS bcol3 BIT NULL, ADD KEY(tcol7), ALGORITHM=INPLACE, LOCK=NONE, DROP SYSTEM VERSIONING /* QNO 195 CON_ID 17 */ failed: 4124 Table `t%d` is not system-versioned. Further errors of this kind will be suppressed. # 2019-01-10T03:58:10 [24382] ErrorFilter: Query: ALTER TABLE t2 PARTITION BY KEY(ecol5) /* QNO 271 CON_ID 14 */ failed: 1562 Cannot create temporary table with partitions. Further errors of this kind will be suppressed. # 2019-01-10T03:58:10 [24382] ErrorFilter: Query: SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE `t2` ADD SYSTEM VERSIONING /* QNO 313 CON_ID 14 */ failed: 4137 TEMPORARY tables do not support system versioning. Further errors of this kind will be suppressed. # 2019-01-10T03:58:10 [24382] ErrorFilter: Query: REPLACE INTO `t1` ( `col_date`, `col_date` ) VALUES ( 'y', 49 ) /* QNO 233 CON_ID 17 */ failed: 1110 Column '%s' specified twice. Further errors of this kind will be suppressed. # 2019-01-10T03:58:10 [24382] ErrorFilter: Query: CREATE TABLE `t4` LIKE `view_t1` /* QNO 239 CON_ID 16 */ failed: 1050 Table '%s' already exists. Further errors of this kind will be suppressed. # 2019-01-10T03:58:10 [24382] ErrorFilter: Query: DROP SEQUENCE seq5 /* QNO 282 CON_ID 17 */ failed: 4091 Unknown SEQUENCE: 'test.seq%d'. Further errors of this kind will be suppressed. # 2019-01-10T03:58:10 [24382] ErrorFilter: Query: SET STATEMENT `sql_mode`=ORACLE FOR SELECT seq10.nextval /* QNO 293 CON_ID 16 */ failed: 1109 Unknown table '%s' in field list. Further errors of this kind will be suppressed. # 2019-01-10T03:58:10 [24382] ErrorFilter: Query: SELECT row_end FROM `view_t3` ORDER BY RAND() LIMIT 1 INTO @trx_user_var /* QNO 330 CON_ID 16 */ failed: 1100 Table 'view_t%d' was not locked with LOCK TABLES. Further errors of this kind will be suppressed. # 2019-01-10T03:58:10 [24382] ErrorFilter: Query: SHOW ENGINE RocksDB MUTEX /* QNO 468 CON_ID 14 */ failed: 1286 Unknown storage engine 'RocksDB'. Further errors of this kind will be suppressed. # 2019-01-10T03:58:10 [24382] ErrorFilter: Query: SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE `t3` MODIFY COLUMN IF EXISTS ncol1 FLOAT NOT NULL, LOCK=SHARED, ADD PERIOD FOR SYSTEM_TIME(`row_start`, `row_start`), ADD PRIMARY KEY(ncol7), ADD COLUMN IF NOT EXISTS `pk` SMALLINT UNSIGNED, ENGINE=InnoDB /* QNO 345 CON_ID 17 */ failed: 4086 Sequence 'test.t%d' table structure is invalid (Wrong number of columns). Further errors of this kind will be suppressed. # 2019-01-10T03:58:10 [24382] ErrorFilter: Query: SHOW CREATE TRIGGER z /* QNO 350 CON_ID 17 */ failed: 1360 Trigger does not exist. Further errors of this kind will be suppressed. # 2019-01-10T03:58:10 [24382] ErrorFilter: Query: SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE t9 ADD SYSTEM VERSIONING /* QNO 487 CON_ID 14 */ failed: 4135 Table `t%d` is already system-versioned. Further errors of this kind will be suppressed. # 2019-01-10T03:58:11 [24382] ErrorFilter: Query: FLUSH PRIVILEGES, USER_RESOURCES, SLAVE, SLAVE /* QNO 441 CON_ID 16 */ failed: 1221 Incorrect usage of %s and %sSLAVE. Further errors of this kind will be suppressed. # 2019-01-10T03:58:11 [24382] ErrorFilter: Query: SHOW MASTER LOGS /* QNO 497 CON_ID 15 */ failed: 1381 You are not using binary logging. Further errors of this kind will be suppressed. # 2019-01-10T03:58:11 [24382] ErrorFilter: Query: ALTER SEQUENCE IF EXISTS seq6 START 60644 NO MINVALUE RESTART 2954079880578334720 INCREMENT = 4 MAXVALUE = 3971547136 START WITH 0 START 0 /* QNO 456 CON_ID 16 */ failed: 1225 Option 'START' used twice in statement. Further errors of this kind will be suppressed. # 2019-01-10T03:58:11 [24385] Executor::MySQL::execute: Query: ALTER IGNORE TABLE t4 /*!100301 WAIT 5 */ ALTER COLUMN /*!100305 IF EXISTS */ icol2 SET DEFAULT NULL, /*!100108 IETF_QUOTES = NO */ /* QNO 512 CON_ID 15 */ failed: 1911 Unknown option 'IETF_QUOTES' # 2019-01-10T03:58:11 [24382] ErrorFilter: Query: REPLACE INTO `view_t1` ( `col_time`, `col_enum` ) VALUES ( NULL, 'v' ) /* QNO 466 CON_ID 17 */ failed: 1048 Column '%s' cannot be null. Further errors of this kind will be suppressed. # 2019-01-10T03:58:11 [24382] ErrorFilter: Query: SHOW CREATE EVENT s /* QNO 605 CON_ID 14 */ failed: 1539 Unknown event '%s'. Further errors of this kind will be suppressed. # 2019-01-10T03:58:11 [24382] ErrorFilter: Query: REPLACE INTO `t1` ( `pk` ) VALUES ( '' ) /* QNO 504 CON_ID 17 */ failed: 1366 Incorrect integer value: '' for column `test`.`t%d`.`pk` at row %d. Further errors of this kind will be suppressed. # 2019-01-10T03:58:11 [24385] Executor::MySQL::execute: Query: ALTER TABLE `t6` PARTITION BY HASH(tscol4) /* QNO 599 CON_ID 15 */ failed: 1478 Table storage engine 'partition' does not support the create option 'SEQUENCE' # 2019-01-10T03:58:11 [24382] ErrorFilter: Query: SHOW TRIGGERS IN n /* QNO 527 CON_ID 17 */ failed: 1049 Unknown database '%s'. Further errors of this kind will be suppressed. # 2019-01-10T03:58:12 [24382] ErrorFilter: Query: SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE t3 ADD SYSTEM VERSIONING, ADD COLUMN IF NOT EXISTS `vers_start` BIGINT UNSIGNED GENERATED ALWAYS AS ROW START /* QNO 751 CON_ID 14 */ failed: 4125 Wrong parameters for `t%d`: missing 'AS ROW END'. Further errors of this kind will be suppressed. # 2019-01-10T03:58:12 [24382] ErrorFilter: Query: INSERT INTO `t1` SELECT * FROM `t1` /* QNO 621 CON_ID 17 */ failed: 1062 Duplicate entry '%s' for key '%s'. Further errors of this kind will be suppressed. # 2019-01-10T03:58:12 [24382] ErrorFilter: Query: REPLACE INTO `view_t1` ( `col_date`, `col_time` ) VALUES ( 'foreigner', 'c' ) /* QNO 692 CON_ID 16 */ failed: 1292 Incorrect date value: 'foreigner' for column `test`.`t%d`.`col_date` at row %d. Further errors of this kind will be suppressed. # 2019-01-10T03:58:12 [24385] WARNING: Table/view 'view_t7' in schema 'test' has no 'char' columns # 2019-01-10T03:58:12 [24382] ErrorFilter: Query: SET `system_versioning_innodb_algorithm_simple` = OFF /* QNO 793 CON_ID 17 */ failed: 1193 Unknown system variable 'system_versioning_innodb_algorithm_simple'. Further errors of this kind will be suppressed. # 2019-01-10T03:58:12 [24382] ErrorFilter: Query: DROP TABLE t7 /* QNO 795 CON_ID 17 */ failed: 1051 Unknown table '%s'. Further errors of this kind will be suppressed. # 2019-01-10T03:58:13 [24387] Executor::MySQL::execute: Query: ALTER TABLE t3 PARTITION BY KEY(`col_varchar`) /* QNO 1091 CON_ID 16 */ failed: 1478 Table storage engine 'partition' does not support the create option 'SEQUENCE' # 2019-01-10T03:58:14 [24382] ErrorFilter: Query: SHOW EXPLAIN FOR 8 /* QNO 1172 CON_ID 17 */ failed: 1933 Target is not running an EXPLAINable command. Further errors of this kind will be suppressed. # 2019-01-10T03:58:14 [24382] ErrorFilter: Query: SET `system_versioning_asof` = ALL /* QNO 1327 CON_ID 15 */ 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-10T03:58:14 [24382] ErrorFilter: Query: SELECT * from `view_t9` FOR system_time BETWEEN 103 AND '20301210100303.006275' /* QNO 1379 CON_ID 15 */ failed: 4111 Transaction system versioning for `t%d` is not supported. Further errors of this kind will be suppressed. # 2019-01-10T03:58:14 [24384] WARNING: Table/view 'view_t7' in schema 'test' has no 'char' columns # 2019-01-10T03:58:16 [24382] ErrorFilter: Query: SELECT NEXT VALUE FOR seq9 /* QNO 1768 CON_ID 14 */ failed: 4084 Sequence 'test.seq%d' has run out. Further errors of this kind will be suppressed. # 2019-01-10T03:58:16 [24382] ErrorFilter: Query: ALTER TABLE t3 DROP FOREIGN KEY h /* QNO 1510 CON_ID 17 */ failed: 1025 Error on rename of './test/t%d' to './test/#sql%d-%df%db-%d' (errno: %d "Cannot delete a parent row"). Further errors of this kind will be suppressed. # 2019-01-10T03:58:16 [24382] ErrorFilter: Query: SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE t8 ADD PRIMARY KEY(`col_bit`), ALGORITHM=COPY, ADD COLUMN IF NOT EXISTS ncol6 FLOAT UNSIGNED NOT NULL FIRST, ALGORITHM=COPY, CHANGE COLUMN IF EXISTS `row_start` `vers_start` TIMESTAMP(6) GENERATED ALWAYS AS ROW START /* QNO 1855 CON_ID 14 */ failed: 4130 Can not change system versioning field `vers_start`. Further errors of this kind will be suppressed. # 2019-01-10T03:58:18 [24382] ErrorFilter: Query: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED /* QNO 2137 CON_ID 16 */ failed: 1568 Transaction characteristics can't be changed while a transaction is in progress. Further errors of this kind will be suppressed. # 2019-01-10T03:58:18 [24382] ErrorFilter: Query: ALTER ONLINE TABLE t10 /*!100301 NOWAIT */ ADD IF NOT EXISTS ( scol5 VARCHAR(33030) NOT NULL /*!100201 CHECK (tcol10 < 8) */, scol5 BINARY NULL ), ALGORITHM=COPY, LOCK=NONE, ADD CONSTRAINT z CHECK (scol8 NOT LIKE ecol3) /* QNO 1943 CON_ID 17 */ failed: 1846 LOCK=NONE is not supported. Reason: COPY algorithm requires a lock. Try LOCK=SHARED. Further errors of this kind will be suppressed. # 2019-01-10T03:58:18 [24382] ErrorFilter: Query: SHOW GRANTS FOR '' /* QNO 2229 CON_ID 16 */ failed: 1959 Invalid role specification ``. Further errors of this kind will be suppressed. # 2019-01-10T03:58:18 [24389] WARNING: Table/view 'view_t7' in schema 'test' has no 'char' columns # 2019-01-10T03:58:18 [24382] ErrorFilter: Query: SHOW EVENTS FROM performance_schema /* QNO 2241 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-10T03:58:20 [24389] Executor::MySQL::execute: Query: SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE t8 DROP SYSTEM VERSIONING /* QNO 2363 CON_ID 17 */ failed: 4131 Can not DROP SYSTEM VERSIONING for table `t8` partitioned BY SYSTEM_TIME # 2019-01-10T03:58:22 [24385] Executor::MySQL::execute: Query: ALTER TABLE `t8` DROP SYSTEM VERSIONING, DROP PRIMARY KEY /* QNO 2610 CON_ID 15 */ failed: 4131 Can not DROP SYSTEM VERSIONING for table `t8` partitioned BY SYSTEM_TIME # 2019-01-10T03:58:22 [24382] ErrorFilter: Query: SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE t10 PARTITION BY system_time LIMIT 9 ( PARTITION ver_p1 HISTORY, PARTITION ver_pn CURRENT ) /* QNO 2974 CON_ID 16 */ failed: 1178 The storage engine for the table doesn't support GEOMETRY. Further errors of this kind will be suppressed. # 2019-01-10T03:58:23 [24382] ErrorFilter: Query: ALTER TABLE t10 ADD COLUMN IF NOT EXISTS `row_start` TIMESTAMP(6) GENERATED ALWAYS AS ROW START, DROP COLUMN IF EXISTS `col_date`, ALGORITHM=COPY, LOCK=SHARED, ADD COLUMN IF NOT EXISTS icol8 TINYINT NOT NULL, ALGORITHM=COPY, LOCK=SHARED, ADD COLUMN bcol1 BIT AUTO_INCREMENT, LOCK=NONE, MODIFY COLUMN IF EXISTS scol6 VARCHAR(25279) NULL, ALGORITHM=COPY, CHANGE COLUMN IF EXISTS icol1 bcol7 BIT NOT NULL, ALGORITHM=INPLACE, LOCK=NONE, ADD KEY(tscol9), LOCK=NONE /* QNO 3173 CON_ID 14 */ failed: 1063 Incorrect column specifier for column 'bcol%d'. Further errors of this kind will be suppressed. # 2019-01-10T03:58:27 [24382] ErrorFilter: Query: RENAME TABLE `view_t6` TO tmp_rename_24385, tmp_rename_24385 TO view_t6 /* QNO 3562 CON_ID 15 */ 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-10T03:58:28 [24382] ErrorFilter: Query: SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE t7 ADD SYSTEM VERSIONING, CHANGE COLUMN `row_end` `row_end` TIME GENERATED ALWAYS AS ROW END, DROP COLUMN `row_start`, ADD COLUMN IF NOT EXISTS `vers_end` BIGINT UNSIGNED GENERATED ALWAYS AS ROW END /* QNO 3754 CON_ID 15 */ failed: 4134 Duplicate ROW END column `vers_end`. Further errors of this kind will be suppressed. # 2019-01-10T03:58:29 [24382] ErrorFilter: Query: REPLACE INTO `t5` ( `col_year` ) VALUES ( 172 ) /* QNO 4126 CON_ID 15 */ failed: 1264 Out of range value for column 'col_year' at row %d. Further errors of this kind will be suppressed. # 2019-01-10T03:58:38 [24382] ErrorFilter: Query: SHOW GRANTS FOR root /* QNO 6316 CON_ID 16 */ failed: 1141 There is no such grant defined for user '%s' on host '%s'. Further errors of this kind will be suppressed. # 2019-01-10T03:58:40 [24384] Executor::MySQL::execute: Query: CREATE OR REPLACE TABLE t8 (tcol4 DATE ) ROW_FORMAT PAGE /* QNO 6778 CON_ID 14 */ failed: 1005 Can't create table `test`.`t8` (errno: 140 "Wrong create options") # 2019-01-10T03:58:44 [24387] WARNING: Table/view 'view_t7' in schema 'test' has no 'char' columns # 2019-01-10T03:58:48 [24385] Executor::MySQL::execute: Query: CREATE OR REPLACE TEMPORARY TABLE t2 (scol6 BINARY, scol4 VARBINARY(58987), icol8 INT NULL ) ROW_FORMAT FIXED /* QNO 8557 CON_ID 15 */ failed: 1005 Can't create table `test`.`t2` (errno: 140 "Wrong create options") # 2019-01-10T03:58:49 [24387] Executor::MySQL::execute: Query: CREATE OR REPLACE TABLE t8 (icol5 SMALLINT ) ROW_FORMAT = FIXED /* QNO 8883 CON_ID 16 */ failed: 1005 Can't create table `test`.`t8` (errno: 140 "Wrong create options") # 2019-01-10T03:58:50 [24387] Executor::MySQL::execute: Query: CREATE OR REPLACE TABLE t3 (icol9 MEDIUMINT UNSIGNED NOT NULL /*!100303 INVISIBLE */, bcol3 BIT NOT NULL, tscol3 DATETIME NULL ) /* QNO 9132 CON_ID 16 */ failed: 4108 Invisible column `icol9` must have a default value # 2019-01-10T03:58:52 [24382] ErrorFilter: Query: LOAD DATA INFILE 'load_t6' IGNORE INTO TABLE t6 /* QNO 9413 CON_ID 16 */ failed: 1416 Cannot get geometry object from data you send to the GEOMETRY field. Further errors of this kind will be suppressed. # 2019-01-10T03:58:55 [24382] ErrorFilter: Query: SHOW FULL FIELDS IN `view_t9` /* QNO 10592 CON_ID 14 */ failed: 1684 Table 'test'.'t%d' was skipped since its definition is being modified by concurrent DDL statement. Further errors of this kind will be suppressed. # 2019-01-10T03:58:56 [24382] ErrorFilter: Query: LOAD DATA INFILE 'load_t6' REPLACE INTO TABLE t6 /* QNO 10507 CON_ID 16 */ failed: 1265 Data truncated for column 'ecol%d' at row %d. Further errors of this kind will be suppressed. # 2019-01-10T03:58:57 [24384] Executor::MySQL::execute: Query: ALTER ONLINE TABLE `t5` DROP COLUMN IF EXISTS ecol10, LOCK=SHARED, DROP FOREIGN KEY j, ADD COLUMN IF NOT EXISTS ( scol2 VARCHAR(19983), ncol3 DOUBLE NULL DEFAULT NULL /*!100303 INVISIBLE */, geocol9 POLYGON NOT NULL /*!100303 INVISIBLE */ ), ALGORITHM=DEFAULT /* QNO 11033 CON_ID 14 */ failed: 1074 Column length too big for column 'scol2' (max = 16383); use BLOB or TEXT instead # 2019-01-10T03:58:58 [24385] Executor::MySQL::execute: Query: LOAD DATA INFILE 'load_t7' REPLACE INTO TABLE t7 /* QNO 11235 CON_ID 15 */ failed: 1263 Column set to default value; NULL supplied to NOT NULL column 'col_char' at row 1 # 2019-01-10T03:59:00 [24385] Executor::MySQL::execute: Query: ALTER IGNORE TABLE `t9` /*!100301 WAIT 4 */ RENAME TO `t2`, ROW_FORMAT = FIXED /* QNO 11677 CON_ID 15 */ failed: 1478 Table storage engine 'InnoDB' does not support the create option 'ROW_TYPE' # 2019-01-10T03:59:07 [24382] ErrorFilter: Query: LOAD DATA INFILE 'load_t3' REPLACE INTO TABLE t3 /* QNO 12650 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-10T03:59:10 [24382] ErrorFilter: Query: ALTER ONLINE TABLE t4 DROP FOREIGN KEY t /* QNO 13852 CON_ID 16 */ failed: 1506 Foreign key clause is not yet supported in conjunction with partitioning. Further errors of this kind will be suppressed. # 2019-01-10T03:59:14 [24382] ErrorFilter: Query: LOAD DATA INFILE 'load_t3' REPLACE INTO TABLE t3 /* QNO 15125 CON_ID 16 */ 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-10T03:59:17 [24385] Executor::MySQL::execute: Query: CREATE OR REPLACE TABLE t6 (ncol5 DOUBLE NULL ) ROW_FORMAT FIXED /* QNO 16183 CON_ID 15 */ failed: 1005 Can't create table `test`.`t6` (errno: 140 "Wrong create options") # 2019-01-10T03:59:17 [24382] ErrorFilter: Query: ALTER ONLINE TABLE t10 /*!100301 WAIT 2 */ ADD FULLTEXT KEY(scol4) /* QNO 16203 CON_ID 15 */ failed: 1283 Column 'scol%d' cannot be part of FULLTEXT index. Further errors of this kind will be suppressed. # 2019-01-10T03:59:18 [24385] Executor::MySQL::execute: Query: SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE `t4` DROP SYSTEM VERSIONING /* QNO 16378 CON_ID 15 */ failed: 4131 Can not DROP SYSTEM VERSIONING for table `t4` partitioned BY SYSTEM_TIME # 2019-01-10T03:59:18 [24387] Executor::MySQL::execute: Query: ALTER TABLE t2 /*!100108 IETF_QUOTES = YES */ /* QNO 15888 CON_ID 16 */ failed: 1911 Unknown option 'IETF_QUOTES' # 2019-01-10T03:59:20 [24385] Executor::MySQL::execute: Query: ALTER TABLE t2 /*!100301 WAIT 9 */ /*!100104 ENCRYPTION_KEY_ID = 4 */ /* QNO 16675 CON_ID 15 */ failed: 1478 Table storage engine 'InnoDB' does not support the create option 'ENCRYPTION_KEY_ID' # 2019-01-10T03:59:22 [24387] Executor::MySQL::execute: Query: SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE `t4` DROP SYSTEM VERSIONING /* QNO 16664 CON_ID 16 */ failed: 4131 Can not DROP SYSTEM VERSIONING for table `t4` partitioned BY SYSTEM_TIME # 2019-01-10T03:59:22 [24385] Executor::MySQL::execute: Query: SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE t4 DROP SYSTEM VERSIONING /* QNO 17158 CON_ID 15 */ failed: 4131 Can not DROP SYSTEM VERSIONING for table `t4` partitioned BY SYSTEM_TIME # 2019-01-10T03:59:25 [24385] Executor::MySQL::execute: Query: ALTER TABLE t4 ADD COLUMN scol7 VARBINARY(2593) NOT NULL, DROP INDEX ind4, ADD COLUMN bcol2 BIT NULL, ALGORITHM=COPY, LOCK=SHARED, ADD FULLTEXT KEY(scol7), ALGORITHM=INPLACE, LOCK=SHARED, DROP SYSTEM VERSIONING /* QNO 17743 CON_ID 15 */ failed: 4131 Can not DROP SYSTEM VERSIONING for table `t4` partitioned BY SYSTEM_TIME # 2019-01-10T03:59:26 [24382] ErrorFilter: Query: FLUSH TABLES /* QNO 17788 CON_ID 16 */ failed: 1099 Table 't%d' was locked with a READ lock and can't be updated. Further errors of this kind will be suppressed. # 2019-01-10T03:59:29 [24389] Executor::MySQL::execute: Query: ALTER IGNORE TABLE `t2` ADD FOREIGN KEY p (tscol1) REFERENCES t4 (scol1) ON UPDATE CASCADE /* QNO 17989 CON_ID 17 */ failed: 1005 Can't create table `test`.`#sql-5f1b_11` (errno: 150 "Foreign key constraint is incorrectly formed") # 2019-01-10T03:59:32 [24382] ErrorFilter: Query: SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE t2 DROP PARTITION ver_p4 /* QNO 19036 CON_ID 16 */ failed: 1507 Error in list of partitions to DROP. Further errors of this kind will be suppressed. # 2019-01-10T03:59:32 [24389] Executor::MySQL::execute: Query: ALTER TABLE `t1` /*!100301 WAIT 6 */ ADD ( scol8 BLOB NOT NULL /*!100303 INVISIBLE */ ) /* QNO 18846 CON_ID 17 */ failed: 4108 Invisible column `scol8` must have a default value # 2019-01-10T03:59:36 [24382] ErrorFilter: Query: ALTER TABLE t3 ADD IF NOT EXISTS ( ecol3 SET('foo','bar') /*!100303 INVISIBLE */ /*!100201 CHECK (icol2 <= tscol1) */, scol10 VARBINARY(5269), `col_varchar` VARBINARY(65406) NULL DEFAULT '' ) /*!100307, ALGORITHM=NOCOPY */, LOCK=DEFAULT /* QNO 20153 CON_ID 16 */ failed: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is %d. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs. Further errors of this kind will be suppressed. # 2019-01-10T03:59:43 [24385] Executor::MySQL::execute: Query: ALTER IGNORE TABLE `t8` KEY_BLOCK_SIZE = 32768 /* QNO 22556 CON_ID 15 */ failed: 1478 Table storage engine 'InnoDB' does not support the create option 'KEY_BLOCK_SIZE' # 2019-01-10T03:59:54 [24382] ErrorFilter: Query: ALTER TABLE t6 PARTITION BY HASH(scol7) /* QNO 25515 CON_ID 15 */ failed: 1659 Field 'scol%d' is of a not allowed type for this type of partitioning. Further errors of this kind will be suppressed. # 2019-01-10T03:59:54 [24382] ErrorFilter: Query: CREATE OR REPLACE TABLE t4 (icol7 SMALLINT NULL AUTO_INCREMENT ) ROW_FORMAT = REDUNDANT /* QNO 24914 CON_ID 16 */ failed: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key. Further errors of this kind will be suppressed. # 2019-01-10T03:59:54 [24385] Executor::MySQL::execute: Query: LOAD DATA INFILE 'load_t7' REPLACE INTO TABLE t7 /* QNO 25591 CON_ID 15 */ failed: 1263 Column set to default value; NULL supplied to NOT NULL column 'ncol9' at row 1 # 2019-01-10T03:59:56 [24385] Executor::MySQL::execute: Query: LOAD DATA INFILE 'load_t7' REPLACE INTO TABLE t7 /* QNO 26101 CON_ID 15 */ failed: 1263 Column set to default value; NULL supplied to NOT NULL column 'ncol9' at row 1 # 2019-01-10T03:59:58 [24387] Executor::MySQL::execute: Query: LOAD DATA INFILE 'load_t7' REPLACE INTO TABLE t7 /* QNO 26164 CON_ID 16 */ failed: 1263 Column set to default value; NULL supplied to NOT NULL column 'ncol9' at row 1 # 2019-01-10T03:59:59 [24389] Executor::MySQL::execute: Query: CREATE OR REPLACE TEMPORARY TABLE t3 (tcol7 DATE ) ROW_FORMAT = FIXED /* QNO 25444 CON_ID 17 */ failed: 1005 Can't create table `test`.`t3` (errno: 140 "Wrong create options") # 2019-01-10T04:00:02 [24290] #--------------------------# # 2019-01-10T04:00:02 [24290] #-- Creating full backup --# # 2019-01-10T04:00:02 [24290] #--------------------------# # 2019-01-10T04:00:02 [24290] /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-10T04:00:04 [24290] #---------------------------------------# # 2019-01-10T04:00:04 [24290] #-- Continuing test flow after backup --# # 2019-01-10T04:00:04 [24290] #---------------------------------------# # 2019-01-10T04:00:05 [24387] Executor::MySQL::execute: Query: CREATE OR REPLACE TABLE t6 (bcol6 BIT NULL DEFAULT NULL ) ROW_FORMAT PAGE /* QNO 27503 CON_ID 16 */ failed: 1005 Can't create table `test`.`t6` (errno: 140 "Wrong create options") # 2019-01-10T04:00:07 [24384] Executor::MySQL::execute: Query: ALTER TABLE t1 /*!100108 IETF_QUOTES = NO */ /* QNO 28644 CON_ID 14 */ failed: 1911 Unknown option 'IETF_QUOTES' # 2019-01-10T04:00:13 [24387] Executor::MySQL::execute: Query: CREATE OR REPLACE TABLE t2 (scol5 CHAR NOT NULL /*!100303 INVISIBLE */, icol8 INT NOT NULL /*!100201 CHECK (`col_dec` = vcol5) */) /* QNO 28997 CON_ID 16 */ failed: 4108 Invisible column `scol5` must have a default value # 2019-01-10T04:00:17 [24385] Executor::MySQL::execute: Query: CREATE OR REPLACE TABLE t2 (tcol8 DATE NOT NULL /*!100303 INVISIBLE */, tscol1 DATETIME NOT NULL ) ROW_FORMAT DEFAULT /* QNO 30583 CON_ID 15 */ failed: 4108 Invisible column `tcol8` must have a default value # 2019-01-10T04:00:19 [24385] Executor::MySQL::execute: Query: SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE t1 DROP PARTITION IF EXISTS ver_p2 /* QNO 30850 CON_ID 15 */ failed: 4116 Can only drop oldest partitions when rotating by INTERVAL # 2019-01-10T04:00:20 [24385] Executor::MySQL::execute: Query: CREATE OR REPLACE TEMPORARY TABLE t5 (ncol2 DECIMAL ) ROW_FORMAT PAGE /* QNO 31134 CON_ID 15 */ failed: 1005 Can't create table `test`.`t5` (errno: 140 "Wrong create options") # 2019-01-10T04:00:23 [24382] ErrorFilter: Query: CREATE OR REPLACE TABLE `t4` (tcol4 DATE NOT NULL /*!100303 INVISIBLE */, tcol4 DATE NULL /*!100201 CHECK (ecol9 >= 8) */) ROW_FORMAT FIXED /* QNO 31815 CON_ID 15 */ failed: 1060 Duplicate column name '%s'. Further errors of this kind will be suppressed. # 2019-01-10T04:00:25 [24384] Executor::MySQL::execute: Query: ALTER IGNORE TABLE `view_t1` ADD CONSTRAINT CHECK (ecol6 <= ncol1), /*!100108 IETF_QUOTES = NO */, AVG_ROW_LENGTH 82 /* QNO 32454 CON_ID 14 */ failed: 1911 Unknown option 'IETF_QUOTES' # 2019-01-10T04:00:26 [24382] ErrorFilter: Query: LOAD DATA INFILE 'load_t7' REPLACE INTO TABLE t7 /* QNO 32769 CON_ID 14 */ failed: 1261 Row %d doesn't contain data for all columns. Further errors of this kind will be suppressed. # 2019-01-10T04:00:28 [24382] ErrorFilter: Query: CREATE OR REPLACE TEMPORARY TABLE `t7` (icol8 INT UNSIGNED NULL ) ROW_FORMAT COMPRESSED /* QNO 32573 CON_ID 16 */ 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-10T04:00:28 [24387] Executor::MySQL::execute: Query: LOAD DATA INFILE 'load_t7' REPLACE INTO TABLE t7 /* QNO 32602 CON_ID 16 */ failed: 1263 Column set to default value; NULL supplied to NOT NULL column 'geocol5' at row 1 # 2019-01-10T04:00:28 [24387] Executor::MySQL::execute: Query: LOAD DATA INFILE 'load_t7' IGNORE INTO TABLE t7 /* QNO 32627 CON_ID 16 */ failed: 1263 Column set to default value; NULL supplied to NOT NULL column 'geocol5' at row 1 # 2019-01-10T04:00:29 [24384] Executor::MySQL::execute: Query: LOAD DATA INFILE 'load_t7' IGNORE INTO TABLE t7 /* QNO 33357 CON_ID 14 */ failed: 1263 Column set to default value; NULL supplied to NOT NULL column 'geocol5' at row 1 # 2019-01-10T04:00:30 [24384] Executor::MySQL::execute: Query: LOAD DATA INFILE 'load_t7' IGNORE INTO TABLE t7 /* QNO 33689 CON_ID 14 */ failed: 1263 Column set to default value; NULL supplied to NOT NULL column 'geocol5' at row 1 # 2019-01-10T04:00:31 [24387] Executor::MySQL::execute: Query: LOAD DATA INFILE 'load_t7' IGNORE INTO TABLE t7 /* QNO 33341 CON_ID 16 */ failed: 1263 Column set to default value; NULL supplied to NOT NULL column 'geocol5' at row 1 # 2019-01-10T04:00:32 [24389] Executor::MySQL::execute: Query: LOAD DATA INFILE 'load_t7' IGNORE INTO TABLE t7 /* QNO 32448 CON_ID 17 */ failed: 1263 Column set to default value; NULL supplied to NOT NULL column 'geocol5' at row 1 # 2019-01-10T04:00:32 [24385] Executor::MySQL::execute: Query: LOAD DATA INFILE 'load_t7' IGNORE INTO TABLE t7 /* QNO 34171 CON_ID 15 */ failed: 1263 Column set to default value; NULL supplied to NOT NULL column 'geocol5' at row 1 # 2019-01-10T04:00:32 [24389] Executor::MySQL::execute: Query: LOAD DATA INFILE 'load_t7' IGNORE INTO TABLE t7 /* QNO 32505 CON_ID 17 */ failed: 1263 Column set to default value; NULL supplied to NOT NULL column 'geocol5' at row 1 # 2019-01-10T04:00:32 [24387] Executor::MySQL::execute: Query: LOAD DATA INFILE 'load_t7' IGNORE INTO TABLE t7 /* QNO 33724 CON_ID 16 */ failed: 1263 Column set to default value; NULL supplied to NOT NULL column 'geocol5' at row 1 # 2019-01-10T04:00:33 [24387] Executor::MySQL::execute: Query: LOAD DATA INFILE 'load_t7' IGNORE INTO TABLE t7 /* QNO 33812 CON_ID 16 */ failed: 1263 Column set to default value; NULL supplied to NOT NULL column 'geocol5' at row 1 # 2019-01-10T04:00:35 [24387] Executor::MySQL::execute: Query: LOAD DATA INFILE 'load_t7' REPLACE INTO TABLE t7 /* QNO 34168 CON_ID 16 */ failed: 1263 Column set to default value; NULL supplied to NOT NULL column 'geocol5' at row 1 # 2019-01-10T04:00:36 [24384] Executor::MySQL::execute: Query: ALTER IGNORE TABLE t2 /*!100301 NOWAIT */ ADD CONSTRAINT c FOREIGN KEY (ecol3) REFERENCES t5 (`col_year`) ON DELETE RESTRICT /* QNO 35042 CON_ID 14 */ failed: 1005 Can't create table `test`.`#sql-5f1b_e` (errno: 150 "Foreign key constraint is incorrectly formed") # 2019-01-10T04:00:38 [24385] Executor::MySQL::execute: Query: ALTER IGNORE TABLE t4 /*!100108 IETF_QUOTES = NO */ /* QNO 35563 CON_ID 15 */ failed: 1911 Unknown option 'IETF_QUOTES' # 2019-01-10T04:00:39 [24387] Executor::MySQL::execute: Query: LOAD DATA INFILE 'load_t7' REPLACE INTO TABLE t7 /* QNO 35142 CON_ID 16 */ failed: 1263 Column set to default value; NULL supplied to NOT NULL column 'geocol5' at row 1 # 2019-01-10T04:00:40 [24384] Executor::MySQL::execute: Query: SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE t10 DROP SYSTEM VERSIONING /* QNO 35816 CON_ID 14 */ failed: 4131 Can not DROP SYSTEM VERSIONING for table `t10` partitioned BY SYSTEM_TIME # 2019-01-10T04:00:40 [24387] Executor::MySQL::execute: Query: LOAD DATA INFILE 'load_t7' IGNORE INTO TABLE t7 /* QNO 35334 CON_ID 16 */ failed: 1263 Column set to default value; NULL supplied to NOT NULL column 'geocol5' at row 1 # 2019-01-10T04:00:45 [24389] Executor::MySQL::execute: Query: LOAD DATA INFILE 'load_t1' REPLACE INTO TABLE t1 /* QNO 35428 CON_ID 17 */ failed: 1263 Column set to default value; NULL supplied to NOT NULL column 'bcol6' at row 1 # 2019-01-10T04:00:47 [24387] Executor::MySQL::execute: Query: LOAD DATA INFILE 'load_t1' REPLACE INTO TABLE t1 /* QNO 36913 CON_ID 16 */ failed: 1263 Column set to default value; NULL supplied to NOT NULL column 'bcol6' at row 1 # 2019-01-10T04:00:51 [24387] Executor::MySQL::execute: Query: CREATE OR REPLACE TABLE t5 (icol5 MEDIUMINT ) ROW_FORMAT PAGE /* QNO 38020 CON_ID 16 */ failed: 1005 Can't create table `test`.`t5` (errno: 140 "Wrong create options") # 2019-01-10T04:00:52 [24387] Executor::MySQL::execute: Query: CREATE OR REPLACE TABLE `t2` (tscol9 DATETIME NOT NULL ) ROW_FORMAT = FIXED /* QNO 38215 CON_ID 16 */ failed: 1005 Can't create table `test`.`t2` (errno: 140 "Wrong create options") # 2019-01-10T04:00:57 [24387] Executor::MySQL::execute: Query: CREATE OR REPLACE TABLE t7 (`col_int` TINYINT UNSIGNED NULL ) ROW_FORMAT = PAGE /* QNO 39509 CON_ID 16 */ failed: 1005 Can't create table `test`.`t7` (errno: 140 "Wrong create options") # 2019-01-10T04:01:00 [24385] Executor::MySQL::execute: Query: CREATE OR REPLACE TABLE t6 (icol3 SMALLINT DEFAULT NULL ) ROW_FORMAT = PAGE /* QNO 40918 CON_ID 15 */ failed: 1005 Can't create table `test`.`t6` (errno: 140 "Wrong create options") # 2019-01-10T04:01:00 [24382] ErrorFilter: Query: ALTER TABLE t9 /*!100301 WAIT 1 */ ADD CONSTRAINT t PRIMARY KEY(`col_char`(54089)) /*!100307, ALGORITHM=NOCOPY */, LOCK=SHARED /* QNO 39406 CON_ID 17 */ failed: 1089 Incorrect prefix key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't support unique prefix keys. Further errors of this kind will be suppressed. # 2019-01-10T04:01:03 [24384] Executor::MySQL::execute: Query: SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE t4 DROP SYSTEM VERSIONING, ADD UNIQUE(`col_varchar`(65340), ncol1, tscol8) /* QNO 41817 CON_ID 14 */ failed: 4131 Can not DROP SYSTEM VERSIONING for table `t4` partitioned BY SYSTEM_TIME # 2019-01-10T04:01:09 [24384] Executor::MySQL::execute: Query: SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE `t4` DROP SYSTEM VERSIONING, ADD COLUMN IF NOT EXISTS tcol1 DATE NOT NULL, ALGORITHM=INPLACE /* QNO 42776 CON_ID 14 */ failed: 4131 Can not DROP SYSTEM VERSIONING for table `t4` partitioned BY SYSTEM_TIME # 2019-01-10T04:01:09 [24384] Executor::MySQL::execute: Query: SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE t4 DROP PARTITION ver_p5 /* QNO 42835 CON_ID 14 */ failed: 4128 Wrong partitions for `t4`: must have at least one HISTORY and exactly one last CURRENT # 2019-01-10T04:01:19 [24389] Executor::MySQL::execute: Query: CREATE OR REPLACE TABLE t6 (icol5 MEDIUMINT UNSIGNED ) ROW_FORMAT = PAGE /* QNO 43644 CON_ID 17 */ failed: 1005 Can't create table `test`.`t6` (errno: 140 "Wrong create options") # 2019-01-10T04:01:19 [24389] Executor::MySQL::execute: Query: CREATE TABLE IF NOT EXISTS t10 (`vers_start` BIGINT UNSIGNED GENERATED ALWAYS AS ROW START, `row_end` SET('foo','bar') GENERATED ALWAYS AS ROW END, PERIOD FOR SYSTEM_TIME ( `vers_start`, `row_end` )) ENGINE=MyISAM ROW_FORMAT=COMPACT WITH SYSTEM VERSIONING /* QNO 43765 CON_ID 17 */ failed: 4123 Table `t10` must have at least one versioned column # 2019-01-10T04:01:23 [24385] Executor::MySQL::execute: Query: CREATE OR REPLACE TEMPORARY TABLE `view_t6` (`col_char` VARBINARY(4983) DEFAULT '' ) ROW_FORMAT PAGE /* QNO 46868 CON_ID 15 */ failed: 1005 Can't create table `test`.`view_t6` (errno: 140 "Wrong create options") # 2019-01-10T04:01:26 [24385] Executor::MySQL::execute: Query: LOAD DATA INFILE 'load_t7' IGNORE INTO TABLE t7 /* QNO 47805 CON_ID 15 */ failed: 1263 Column set to default value; NULL supplied to NOT NULL column 'geocol10' at row 1 # 2019-01-10T04:01:28 [24385] Executor::MySQL::execute: Query: LOAD DATA INFILE 'load_t7' IGNORE INTO TABLE t7 /* QNO 48168 CON_ID 15 */ failed: 1263 Column set to default value; NULL supplied to NOT NULL column 'geocol10' at row 1 # 2019-01-10T04:01:31 [24387] Executor::MySQL::execute: Query: ALTER TABLE t2 ADD ( tcol5 TIME, scol4 VARCHAR(5326) NOT NULL /*!100303 INVISIBLE */ ) /*!100307, ALGORITHM=NOCOPY */ /* QNO 47543 CON_ID 16 */ failed: 4108 Invisible column `scol4` must have a default value # 2019-01-10T04:01:35 [24384] Executor::MySQL::execute: Query: ALTER ONLINE IGNORE TABLE t1 KEY_BLOCK_SIZE 32768 /* QNO 49421 CON_ID 14 */ failed: 1478 Table storage engine 'InnoDB' does not support the create option 'KEY_BLOCK_SIZE' # 2019-01-10T04:01:46 [24385] Executor::MySQL::execute: Query: SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE t7 ENGINE=InnoDB, DROP SYSTEM VERSIONING, ROW_FORMAT=COMPRESSED, ADD COLUMN IF NOT EXISTS ncol8 DOUBLE AFTER ia_col_name, DROP PRIMARY KEY /* QNO 52777 CON_ID 15 */ failed: 4131 Can not DROP SYSTEM VERSIONING for table `t7` partitioned BY SYSTEM_TIME # 2019-01-10T04:01:46 [24389] Executor::MySQL::execute: Query: SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE t7 DROP SYSTEM VERSIONING, ENGINE=InnoDB /* QNO 51182 CON_ID 17 */ failed: 4131 Can not DROP SYSTEM VERSIONING for table `t7` partitioned BY SYSTEM_TIME # 2019-01-10T04:02:00 [24290] #-------------------------# # 2019-01-10T04:02:00 [24290] #-- Stopping the server --# # 2019-01-10T04:02:00 [24290] #-------------------------# # 2019-01-10T04:02:00 [24290] Stopping server on port 19300 # 2019-01-10T04:02:00 [24384] Executor::MySQL::execute: Query: DELETE FROM `view_t2` ORDER BY `col_varchar` LIMIT 1 /* QNO 55859 CON_ID 14 */ failed: 2013 Lost connection to MySQL server during query # 2019-01-10T04:02:00 [24384] Mixer: Server crash or critical failure 2013 (STATUS_SERVER_CRASHED) reported at dsn dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test:mysql_local_infile=1 # 2019-01-10T04:02:00 [24384] GenTest: Server crash or critical failure (STATUS_SERVER_CRASHED) reported, the child will be stopped # 2019-01-10T04:02:00 [24384] GenTest: child 24384 is being stopped with status STATUS_SERVER_CRASHED # 2019-01-10T04:02:00 [24389] Executor::MySQL::execute: Query: REPLACE INTO `t4` ( `col_enum`, `col_dec` ) VALUES ( 'y', 'latter' ) /* QNO 54306 CON_ID 17 */ failed: 2013 Lost connection to MySQL server during query # 2019-01-10T04:02:00 [24389] Mixer: Server crash or critical failure 2013 (STATUS_SERVER_CRASHED) reported at dsn dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test:mysql_local_infile=1 # 2019-01-10T04:02:00 [24389] GenTest: Server crash or critical failure (STATUS_SERVER_CRASHED) reported, the child will be stopped # 2019-01-10T04:02:00 [24389] GenTest: child 24389 is being stopped with status STATUS_SERVER_CRASHED # 2019-01-10T04:02:00 [24387] Executor::MySQL::execute: Query: SELECT START_VALUE, START_VALUE, CYCLE_OPTION FROM seq1 /* QNO 54691 CON_ID 16 */ failed: 2013 Lost connection to MySQL server during query # 2019-01-10T04:02:00 [24385] Executor::MySQL::execute: Query: UPDATE IGNORE `t8` SET `col_datetime` = 'claim' ORDER BY `pk` LIMIT 1 /* QNO 56360 CON_ID 15 */ failed: 2013 Lost connection to MySQL server during query # 2019-01-10T04:02:00 [24387] Mixer: Server crash or critical failure 2013 (STATUS_SERVER_CRASHED) reported at dsn dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test:mysql_local_infile=1 # 2019-01-10T04:02:00 [24385] Mixer: Server crash or critical failure 2013 (STATUS_SERVER_CRASHED) reported at dsn dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test:mysql_local_infile=1 # 2019-01-10T04:02:00 [24387] GenTest: Server crash or critical failure (STATUS_SERVER_CRASHED) reported, the child will be stopped # 2019-01-10T04:02:00 [24385] GenTest: Server crash or critical failure (STATUS_SERVER_CRASHED) reported, the child will be stopped # 2019-01-10T04:02:00 [24387] GenTest: child 24387 is being stopped with status STATUS_SERVER_CRASHED # 2019-01-10T04:02:00 [24385] GenTest: child 24385 is being stopped with status STATUS_SERVER_CRASHED # 2019-01-10T04:02:02 [24290] Server has been stopped # 2019-01-10T04:02:02 [24290] #-------------------------------------------------------------# # 2019-01-10T04:02:02 [24290] #-- Checking the server log for fatal errors after shutdown --# # 2019-01-10T04:02:02 [24290] #-------------------------------------------------------------# # 2019-01-10T04:02:02 [24290] Checking server log for important errors starting from the beginning # 2019-01-10T04:02:02 [24290] #----------------------------------------------# # 2019-01-10T04:02:02 [24290] #-- Backing up data directory before restart --# # 2019-01-10T04:02:02 [24290] #----------------------------------------------# # 2019-01-10T04:02:02 [24290] Copying datadir... (interrupting the copy operation may cause investigation problems later) # 2019-01-10T04:02:02 [24290] #----------------------# # 2019-01-10T04:02:02 [24290] #-- Preparing backup --# # 2019-01-10T04:02:02 [24290] #----------------------# # 2019-01-10T04:02:02 [24290] Storing the backup before prepare attempt... # 2019-01-10T04:02:02 [24290] /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-10T04:02:04 [24290] #----------------------# # 2019-01-10T04:02:04 [24290] #-- Restoring backup --# # 2019-01-10T04:02:04 [24290] #----------------------# # 2019-01-10T04:02:04 [24290] /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-10T04:02:04 [24290] #---------------------------# # 2019-01-10T04:02:04 [24290] #-- Restarting the server --# # 2019-01-10T04:02:04 [24290] #---------------------------# # 2019-01-10T04:02:04 [24290] MySQL Version: 10.4.2 # 2019-01-10T04:02:04 [24290] Binary: /home/travis/server/bin/mysqld # 2019-01-10T04:02:04 [24379] Process with pid 24385 ended with status STATUS_SERVER_CRASHED # 2019-01-10T04:02:04 [24379] Killing remaining worker process with pid 24389... # 2019-01-10T04:02:04 [24379] Killing remaining worker process with pid 24387... # 2019-01-10T04:02:04 [24379] Killing remaining worker process with pid 24384... # 2019-01-10T04:02:04 [24290] Type: Debug # 2019-01-10T04:02:04 [24290] Datadir: /home/travis/logs/vardir/data # 2019-01-10T04:02:04 [24290] Tmpdir: /home/travis/logs/vardir/tmp # 2019-01-10T04:02:04 [24290] Corefile: /home/travis/logs/vardir/data/core.24347 # 2019-01-10T04:02:04 [24290] 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-compression-algorithm=none # 2019-01-10T04:02:04 [24290] Pid file does not exist and timeout hasn't passed yet, but the error log has already been updated # 2019-01-10T04:02:04 [24290] Found PID 24442 in the error log # 2019-01-10T04:02:05 [24290] Server started with PID 24442 # 2019-01-10T04:02:05 [24290] #------------------------------------------------------------# # 2019-01-10T04:02:05 [24290] #-- Checking the server error log for errors after restart --# # 2019-01-10T04:02:05 [24290] #------------------------------------------------------------# # 2019-01-10T04:02:05 [24290] Checking server log for important errors starting from the beginning # 2019-01-10T04:02:05 [24290] ------ # 2019-01-10T04:02:05 [24290] 2019-01-10 4:02:04 0 [ERROR] InnoDB: Operating system error number 2 in a file operation. # 2019-01-10T04:02:05 [24290] 2019-01-10 4:02:04 0 [ERROR] InnoDB: The error means the system cannot find the path specified. # 2019-01-10T04:02:05 [24290] 2019-01-10 4:02:04 0 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them. # 2019-01-10T04:02:05 [24290] 2019-01-10 4:02:04 0 [ERROR] InnoDB: Cannot open datafile for read-only: './test/seq9.ibd' OS error: 71 # 2019-01-10T04:02:05 [24290] 2019-01-10 4:02:04 0 [ERROR] InnoDB: Operating system error number 2 in a file operation. # 2019-01-10T04:02:05 [24290] 2019-01-10 4:02:04 0 [ERROR] InnoDB: The error means the system cannot find the path specified. # 2019-01-10T04:02:05 [24290] 2019-01-10 4:02:04 0 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them. # 2019-01-10T04:02:05 [24290] 2019-01-10 4:02:04 0 [ERROR] InnoDB: Could not find a valid tablespace file for ``test`.`seq9``. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue. # 2019-01-10T04:02:05 [24290] ------ # 2019-01-10T04:02:05 [24290][ERROR] Found errors in the log, restart has apparently failed # 2019-01-10T04:02:05 [24290] Killed process 24442 # 2019-01-10T04:02:05 [24290] [24290] ./runall-new.pl will exit with exit status STATUS_BACKUP_FAILURE (108)