# 2019-01-10T03:50:47 [24581] Converted --seed=time to --seed=1547092247 # 2019-01-10T03:50:47 [24581] Copyright (c) 2010,2011 Oracle and/or its affiliates. All rights reserved. Use is subject to license terms. # 2019-01-10T03:50:47 [24581] Please see http://forge.mysql.com/wiki/Category:RandomQueryGenerator for more information on this test framework. # 2019-01-10T03:50:47 [24581] Starting # 2019-01-10T03:50:47 [24581] # ./runall-new.pl \ # 2019-01-10T03:50:47 [24581] # --basedir=/home/travis/server \ # 2019-01-10T03:50:47 [24581] # --vardir=/home/travis/logs/vardir \ # 2019-01-10T03:50:47 [24581] # --duration=350 \ # 2019-01-10T03:50:47 [24581] # --threads=4 \ # 2019-01-10T03:50:47 [24581] # --seed=time \ # 2019-01-10T03:50:47 [24581] # --reporters=Backtrace,ErrorLog,Deadlock \ # 2019-01-10T03:50:47 [24581] # --skip-gendata \ # 2019-01-10T03:50:47 [24581] # --gendata-advanced \ # 2019-01-10T03:50:47 [24581] # --views \ # 2019-01-10T03:50:47 [24581] # --grammar=conf/mariadb/generic-dml.yy \ # 2019-01-10T03:50:47 [24581] # --redefine=conf/mariadb/bulk_insert.yy \ # 2019-01-10T03:50:47 [24581] # --mysqld=--log_output=FILE \ # 2019-01-10T03:50:47 [24581] # --mysqld=--max-statement-time=20 \ # 2019-01-10T03:50:47 [24581] # --mysqld=--lock-wait-timeout=10 \ # 2019-01-10T03:50:47 [24581] # --mysqld=--loose-innodb-lock-wait-timeout=5 \ # 2019-01-10T03:50:47 [24581] # --mysqld=--loose-debug_assert_on_not_freed_memory=0 \ # 2019-01-10T03:50:47 [24581] # --filter=/home/travis/mariadb-toolbox/travis/10.4-combo-filter.ff \ # 2019-01-10T03:50:47 [24581] # --mysqld=--innodb-encrypt-tables \ # 2019-01-10T03:50:47 [24581] # --mysqld=--innodb-encrypt-log \ # 2019-01-10T03:50:47 [24581] # --mysqld=--innodb-encryption-threads=4 \ # 2019-01-10T03:50:47 [24581] # --mysqld=--aria-encrypt-tables=1 \ # 2019-01-10T03:50:47 [24581] # --mysqld=--encrypt-tmp-disk-tables=1 \ # 2019-01-10T03:50:47 [24581] # --mysqld=--file-key-management \ # 2019-01-10T03:50:47 [24581] # --mysqld=--file-key-management-filename=/home/travis/mariadb-toolbox/data/keys.txt \ # 2019-01-10T03:50:47 [24581] # --mysqld=--plugin-load-add=file_key_management \ # 2019-01-10T03:50:47 [24581] # --mysqld=--innodb-compression-algorithm=none \ # 2019-01-10T03:50:47 [24581] # --engine=InnoDB \ # 2019-01-10T03:50:47 [24581] # --scenario=MariaBackupIncremental \ # 2019-01-10T03:50:47 [24581] # --redefine=conf/mariadb/alter_table.yy \ # 2019-01-10T03:50:47 [24581] # --redefine=conf/mariadb/modules/admin.yy \ # 2019-01-10T03:50:47 [24581] # --redefine=conf/mariadb/versioning.yy \ # 2019-01-10T03:50:47 [24581] # --redefine=conf/mariadb/sequences.yy # 2019-01-10T03:50:47 [24581] Ports : 19300 19300 19302 19304 MTR_BUILD_THREAD : 930 # 2019-01-10T03:50:47 [24581] Final command line: # 2019-01-10T03:50:47 [24581] perl ./runall-new.pl --basedir=/home/travis/server --vardir=/home/travis/logs/vardir --duration=350 --threads=4 --seed=1547092247 --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=none --engine=InnoDB --scenario=MariaBackupIncremental --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:50:47 [24581] # 2019-01-10T03:50:47 [24581] ======================================== # 2019-01-10T03:50:47 [24581] === Incremental MariaBackup scenario === # 2019-01-10T03:50:47 [24581] ======================================== # 2019-01-10T03:50:47 [24581] # 2019-01-10T03:50:47 [24581] Creating MySQL 10.4.2 database at /home/travis/logs/vardir/data # 2019-01-10T03:50:47 [24581] 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=none" "--skip-log-bin" "--loose-innodb-encrypt-tables=OFF" "--loose-innodb-encrypt-log=OFF" "--bootstrap" < "/home/travis/logs/vardir/boot.sql" # 2019-01-10T03:50:50 [24581] -- Server info: -- # 2019-01-10T03:50:50 [24581] 10.4.2 # 2019-01-10T03:50:50 [24581] --log_output=FILE # 2019-01-10T03:50:50 [24581] --max-statement-time=20 # 2019-01-10T03:50:50 [24581] --lock-wait-timeout=10 # 2019-01-10T03:50:50 [24581] --loose-innodb-lock-wait-timeout=5 # 2019-01-10T03:50:50 [24581] --loose-debug_assert_on_not_freed_memory=0 # 2019-01-10T03:50:50 [24581] --innodb-encrypt-tables # 2019-01-10T03:50:50 [24581] --innodb-encrypt-log # 2019-01-10T03:50:50 [24581] --innodb-encryption-threads=4 # 2019-01-10T03:50:50 [24581] --aria-encrypt-tables=1 # 2019-01-10T03:50:50 [24581] --encrypt-tmp-disk-tables=1 # 2019-01-10T03:50:50 [24581] --file-key-management # 2019-01-10T03:50:50 [24581] --file-key-management-filename=/home/travis/mariadb-toolbox/data/keys.txt # 2019-01-10T03:50:50 [24581] --plugin-load-add=file_key_management # 2019-01-10T03:50:50 [24581] --innodb-compression-algorithm=none # 2019-01-10T03:50:50 [24581] #-------------------------# # 2019-01-10T03:50:50 [24581] #-- Starting the server --# # 2019-01-10T03:50:50 [24581] #-------------------------# # 2019-01-10T03:50:50 [24581] MySQL Version: 10.4.2 # 2019-01-10T03:50:50 [24581] Binary: /home/travis/server/bin/mysqld # 2019-01-10T03:50:50 [24581] Type: Debug # 2019-01-10T03:50:50 [24581] Datadir: /home/travis/logs/vardir/data # 2019-01-10T03:50:50 [24581] Tmpdir: /home/travis/logs/vardir/tmp # 2019-01-10T03:50:50 [24581] Corefile: /home/travis/logs/vardir/data/core. # 2019-01-10T03:50:50 [24581] 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=none # 2019-01-10T03:50:50 [24581] Pid file does not exist and timeout hasn't passed yet, but the error log has already been updated # 2019-01-10T03:50:50 [24581] Found PID 24641 in the error log # 2019-01-10T03:50:51 [24581] Server started with PID 24641 # 2019-01-10T03:50:51 [24581] Connecting to 19300 # 2019-01-10T03:50:51 [24581] #---------------------------------------------# # 2019-01-10T03:50:51 [24581] #-- Running initial test flow on the server --# # 2019-01-10T03:50:51 [24581] #---------------------------------------------# # 2019-01-10T03:50:51 [24677] ------------------------------- # 2019-01-10T03:50:51 [24677] Configuration # 2019-01-10T03:50:51 [24677] debug_server => ['', '', ''] # 2019-01-10T03:50:51 [24677] dsn => ['dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test:mysql_local_infile=1'] # 2019-01-10T03:50:51 [24677] duration => 280 # 2019-01-10T03:50:51 [24677] engine => ['InnoDB', 'InnoDB', 'InnoDB'] # 2019-01-10T03:50:51 [24677] filter => /home/travis/mariadb-toolbox/travis/10.4-combo-filter.ff # 2019-01-10T03:50:51 [24677] gendata-advanced => 1 # 2019-01-10T03:50:51 [24677] generator => FromGrammar # 2019-01-10T03:50:51 [24677] grammar => conf/mariadb/generic-dml.yy # 2019-01-10T03:50:51 [24677] queries => 100000000 # 2019-01-10T03:50:51 [24677] 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:50:51 [24677] reporters => ['Backtrace', 'ErrorLog', 'Deadlock'] # 2019-01-10T03:50:51 [24677] seed => 1547092247 # 2019-01-10T03:50:51 [24677] servers => ['DBServer::MySQL::MySQLd=ARRAY(0x35bc338)'] # 2019-01-10T03:50:51 [24677] strict_fields => 1 # 2019-01-10T03:50:51 [24677] threads => 4 # 2019-01-10T03:50:51 [24677] transformers => [''] # 2019-01-10T03:50:51 [24677] validators => [''] # 2019-01-10T03:50:51 [24677] vcols => ['', '', ''] # 2019-01-10T03:50:51 [24677] views => ['', '', ''] # 2019-01-10T03:50:51 [24677] Creating MySQL table t1, size 0 rows, engine InnoDB . # 2019-01-10T03:50:51 [24677] 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:50:51 [24677] 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:50:51 [24677] 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:50:51 [24677] 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:50:51 [24677] 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:50:51 [24677] Creating MySQL table t2, size 1 rows, engine InnoDB . # 2019-01-10T03:50:51 [24677] Creating MySQL table t3, size 20 rows, engine InnoDB . # 2019-01-10T03:50:51 [24677] Creating MySQL table t4, size 100 rows, engine InnoDB . # 2019-01-10T03:50:52 [24677] Creating MySQL table t5, size 1000 rows, engine InnoDB . # 2019-01-10T03:50:52 [24677] 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:50:53 [24677] Creating MySQL table t6, size 0 rows, engine InnoDB . # 2019-01-10T03:50:53 [24677] 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:50:53 [24677] 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:50:53 [24677] Creating MySQL table t7, size 1 rows, engine InnoDB . # 2019-01-10T03:50:53 [24677] Creating MySQL table t8, size 20 rows, engine InnoDB . # 2019-01-10T03:50:54 [24677] Creating MySQL table t9, size 100 rows, engine InnoDB . # 2019-01-10T03:50:54 [24677] 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:50:54 [24677] Reading grammar from file conf/mariadb/generic-dml.yy # 2019-01-10T03:50:54 [24677] Reading grammar from file conf/mariadb/bulk_insert.yy # 2019-01-10T03:50:54 [24677] Reading grammar from file conf/mariadb/alter_table.yy # 2019-01-10T03:50:54 [24677] Reading grammar from file conf/mariadb/modules/admin.yy # 2019-01-10T03:50:54 [24677] Reading grammar from file conf/mariadb/versioning.yy # 2019-01-10T03:50:54 [24677] Reading grammar from file conf/mariadb/sequences.yy # 2019-01-10T03:50:54 [24677] Reporters: Backtrace, ErrorLog, Deadlock # 2019-01-10T03:50:54 [24677] Validators: QueryProperties # 2019-01-10T03:50:54 [24677] Caching schema metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test:mysql_local_infile=1 # 2019-01-10T03:50:56 [24677] Loaded 5 filtering rules from '/home/travis/mariadb-toolbox/travis/10.4-combo-filter.ff' # 2019-01-10T03:50:56 [24677] Starting 4 processes, 100000000 queries each, duration 280 seconds. # 2019-01-10T03:50:56 [24677] GenTest::ErrorFilter(24680) started # 2019-01-10T03:50:56 [24682] Mixer: Loading Validator GenTest::Validator::QueryProperties. # 2019-01-10T03:50:56 [24683] Mixer: Loading Validator GenTest::Validator::QueryProperties. # 2019-01-10T03:50:57 [24682] Executor::MySQL::execute: Query: CREATE OR REPLACE TABLE t7 (ncol5 DECIMAL UNSIGNED DEFAULT NULL ) ROW_FORMAT PAGE /* QNO 94 CON_ID 14 */ failed: 1005 Can't create table `test`.`t7` (errno: 140 "Wrong create options") # 2019-01-10T03:50:57 [24680] ErrorFilter: Query: CREATE OR REPLACE TABLE `view_t5` (icol3 INT NOT NULL /*!100303 INVISIBLE */, geocol9 MULTILINESTRING NULL /*!100201 DEFAULT ST_GEOMFROMTEXT('Point(1 1)') */ ) /* QNO 91 CON_ID 15 */ failed: 1965 'test.view_t%d' is a view. Further errors of this kind will be suppressed. # 2019-01-10T03:50:57 [24680] ErrorFilter: Query: CREATE OR REPLACE TEMPORARY TABLE t8 (scol3 BLOB NOT NULL DEFAULT '' /*!100201 CHECK (ecol4 > vcol9) */) /* QNO 95 CON_ID 14 */ failed: 1054 Unknown column '%s' in 'CHECK'. Further errors of this kind will be suppressed. # 2019-01-10T03:50:57 [24680] ErrorFilter: Query: CREATE OR REPLACE TABLE `t2` (geocol4 MULTIPOLYGON /*!100201 DEFAULT ST_GEOMFROMTEXT('Point(1 1)') */ /*!100201 CHECK (`col_dec` <= `col_year`) */) ROW_FORMAT = COMPACT /* QNO 96 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-10T03:50:57 [24685] Mixer: Loading Validator GenTest::Validator::QueryProperties. # 2019-01-10T03:50:57 [24680] ErrorFilter: Query: CREATE OR REPLACE TEMPORARY TABLE `t1` (`col_bit` MEDIUMINT /*!100303 INVISIBLE */ /*!100201 CHECK (tscol5 NOT LIKE 4) */, scol7 TEXT NULL DEFAULT '' /*!100303 INVISIBLE */ /*!100201 CHECK (`col_char` <= 5) */) /* QNO 97 CON_ID 14 */ failed: 1113 A table must have at least %d column. Further errors of this kind will be suppressed. # 2019-01-10T03:50:57 [24680] ErrorFilter: Query: CREATE OR REPLACE TABLE `t4` (bcol7 BIT NULL DEFAULT 5 /*!100201 CHECK (`col_varchar` <= scol4) */) /* QNO 94 CON_ID 15 */ failed: 1067 Invalid default value for 'bcol%d'. Further errors of this kind will be suppressed. # 2019-01-10T03:50:57 [24687] Mixer: Loading Validator GenTest::Validator::QueryProperties. # 2019-01-10T03:50:57 [24680] ErrorFilter: Query: CREATE OR REPLACE TEMPORARY TABLE `t9` (ncol5 DOUBLE NULL DEFAULT NULL, tscol2 DATETIME NOT NULL DEFAULT 0 ) ROW_FORMAT COMPRESSED /* QNO 98 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-10T03:50:57 [24680] ErrorFilter: Query: CREATE TABLE t3 LIKE `t4` /* QNO 101 CON_ID 14 */ failed: 1050 Table '%s' already exists. Further errors of this kind will be suppressed. # 2019-01-10T03:50:57 [24680] ErrorFilter: Query: SELECT * FROM `view_t5` INTO OUTFILE 'load_view_t5' /* QNO 102 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:50:57 [24680] ErrorFilter: Query: UPDATE IGNORE `t7` SET `col_timestamp` = 'wound' ORDER BY `col_year` LIMIT 1 /* QNO 106 CON_ID 14 */ failed: 1146 Table '%s' doesn't exist. Further errors of this kind will be suppressed. # 2019-01-10T03:50:57 [24681] Started periodic reporting process... # 2019-01-10T03:50:57 [24680] ErrorFilter: Query: ALTER ONLINE IGNORE TABLE `view_t3` ADD FOREIGN KEY n (tcol5) REFERENCES `view_t2` (scol7) /* QNO 101 CON_ID 15 */ failed: 1347 'test.view_t%d' is not of type 'BASE TABLE'. Further errors of this kind will be suppressed. # 2019-01-10T03:50:57 [24680] ErrorFilter: Query: SHOW EXPLAIN FOR 26 /* QNO 114 CON_ID 14 */ failed: 1094 Unknown thread id: %s%d. Further errors of this kind will be suppressed. # 2019-01-10T03:50:57 [24680] ErrorFilter: Query: SET STATEMENT `sql_mode`=ORACLE FOR SELECT seq5.nextval /* QNO 115 CON_ID 14 */ failed: 1109 Unknown table '%s' in field list. Further errors of this kind will be suppressed. # 2019-01-10T03:50:57 [24680] ErrorFilter: Query: ALTER TABLE t3 PARTITION BY system_time LIMIT 2 ( PARTITION ver_p1 HISTORY, PARTITION ver_p2 HISTORY, PARTITION ver_p3 HISTORY, PARTITION ver_pn CURRENT ) /* QNO 111 CON_ID 15 */ failed: 1562 Cannot create temporary table with partitions. Further errors of this kind will be suppressed. # 2019-01-10T03:50:57 [24680] ErrorFilter: Query: SHOW TABLE STATUS FROM d /* QNO 120 CON_ID 15 */ failed: 1049 Unknown database '%s'. Further errors of this kind will be suppressed. # 2019-01-10T03:50:57 [24680] ErrorFilter: Query: SHOW BINARY LOGS /* QNO 136 CON_ID 14 */ failed: 1381 You are not using binary logging. Further errors of this kind will be suppressed. # 2019-01-10T03:50:57 [24680] ErrorFilter: Query: INSERT IGNORE INTO `view_t6` () VALUES () /* QNO 103 CON_ID 16 */ failed: 1136 Column count doesn't match value count at row %d. Further errors of this kind will be suppressed. # 2019-01-10T03:50:57 [24680] ErrorFilter: Query: SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE `t6` PARTITION BY system_time INTERVAL 3 MONTH ( PARTITION ver_p1 HISTORY, PARTITION ver_pn CURRENT ) /* QNO 127 CON_ID 15 */ failed: 4124 Table `t%d` is not system-versioned. Further errors of this kind will be suppressed. # 2019-01-10T03:50:57 [24680] ErrorFilter: Query: SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE t3 REMOVE PARTITIONING /* QNO 129 CON_ID 15 */ failed: 1505 Partition management on a not partitioned table is not possible. Further errors of this kind will be suppressed. # 2019-01-10T03:50:57 [24687] Executor::MySQL::execute: Query: CREATE OR REPLACE TABLE t7 (tscol9 TIMESTAMP NOT NULL, `col_char` BINARY NULL ) ROW_FORMAT = PAGE /* QNO 98 CON_ID 17 */ failed: 1005 Can't create table `test`.`t7` (errno: 140 "Wrong create options") # 2019-01-10T03:50:57 [24680] ErrorFilter: Query: ALTER TABLE t8 ADD FOREIGN KEY (vcol10) REFERENCES t5 (vcol3) ON UPDATE NO ACTION /* QNO 141 CON_ID 14 */ failed: 1072 Key column '%s' doesn't exist in table. Further errors of this kind will be suppressed. # 2019-01-10T03:50:57 [24680] ErrorFilter: Query: SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE `t1` CHANGE COLUMN IF EXISTS `row_end` `row_end` TIMESTAMP GENERATED ALWAYS AS ROW END, ADD COLUMN IF NOT EXISTS scol2 BLOB NULL DEFAULT NULL /* QNO 143 CON_ID 14 */ failed: 4130 Can not change system versioning field `row_end`. Further errors of this kind will be suppressed. # 2019-01-10T03:50:57 [24680] ErrorFilter: Query: INSERT IGNORE INTO `t9` () VALUES () /* QNO 153 CON_ID 14 */ failed: 4085 Sequence 'test.t%d' values are conflicting. Further errors of this kind will be suppressed. # 2019-01-10T03:50:57 [24680] ErrorFilter: Query: FLUSH SLAVE, SLAVE /* QNO 139 CON_ID 15 */ failed: 1221 Incorrect usage of %s and %sSLAVE. Further errors of this kind will be suppressed. # 2019-01-10T03:50:57 [24680] ErrorFilter: Query: SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE `t3` ADD SYSTEM VERSIONING, ADD COLUMN IF NOT EXISTS `row_start` TEXT GENERATED ALWAYS AS ROW START /* QNO 142 CON_ID 16 */ failed: 4137 TEMPORARY tables do not support system versioning. Further errors of this kind will be suppressed. # 2019-01-10T03:50:57 [24680] ErrorFilter: Query: SELECT * FROM `view_t3` INTO OUTFILE 'load_view_t3' /* QNO 154 CON_ID 15 */ failed: 1086 File '%s' already exists. Further errors of this kind will be suppressed. # 2019-01-10T03:50:57 [24680] ErrorFilter: Query: SHOW CREATE USER w@'%' /* QNO 151 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:50:57 [24680] ErrorFilter: Query: ALTER SEQUENCE seq7 NOMINVALUE RESTART = 2984197703086374912 RESTART 14701 /* QNO 159 CON_ID 15 */ failed: 1225 Option 'RESTART' used twice in statement. Further errors of this kind will be suppressed. # 2019-01-10T03:50:57 [24680] ErrorFilter: Query: SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE t9 ADD SYSTEM VERSIONING /* QNO 140 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:50:58 [24680] ErrorFilter: Query: ALTER TABLE t8 DROP PRIMARY KEY /* QNO 222 CON_ID 16 */ failed: 1091 Can't DROP INDEX `PRIMARY`; check that it exists. Further errors of this kind will be suppressed. # 2019-01-10T03:50:58 [24680] ErrorFilter: Query: REPLACE INTO `t2` () VALUES () /* QNO 203 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:50:58 [24680] ErrorFilter: Query: ALTER ONLINE TABLE t9 DROP FOREIGN KEY e, /*!100200 DROP CONSTRAINT IF EXISTS x */ /* COMMENT 'Skipped DROP CONSTRAINT' */ /* QNO 236 CON_ID 15 */ failed: 1845 LOCK=NONE is not supported for this operation. Try LOCK=SHARED. Further errors of this kind will be suppressed. # 2019-01-10T03:50:58 [24680] ErrorFilter: Query: ALTER ONLINE TABLE t5 /*!100301 NOWAIT */ MODIFY COLUMN IF EXISTS tscol2 DATETIME NULL FIRST, ALGORITHM=COPY /* QNO 290 CON_ID 14 */ 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:50:58 [24680] ErrorFilter: Query: REPLACE INTO `t3` ( `col_int`, `col_date` ) VALUES ( NULL, 'drop' ) /* QNO 308 CON_ID 14 */ failed: 1048 Column '%s' cannot be null. Further errors of this kind will be suppressed. # 2019-01-10T03:50:58 [24680] ErrorFilter: Query: LOAD DATA INFILE 'load_t2' REPLACE INTO TABLE t2 /* QNO 245 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:50:58 [24680] ErrorFilter: Query: DROP SEQUENCE IF EXISTS seq6, seq6 /* QNO 262 CON_ID 15 */ failed: 1066 Not unique table/alias: '%s'. Further errors of this kind will be suppressed. # 2019-01-10T03:50:58 [24680] ErrorFilter: Query: SHOW CREATE PACKAGE BODY b /* QNO 263 CON_ID 15 */ failed: 1305 PACKAGE %s does not exist. Further errors of this kind will be suppressed. # 2019-01-10T03:50:58 [24683] Executor::MySQL::execute: Query: ALTER TABLE t9 PARTITION BY HASH(tcol5) /* QNO 268 CON_ID 15 */ failed: 1478 Table storage engine 'partition' does not support the create option 'SEQUENCE' # 2019-01-10T03:50:58 [24680] ErrorFilter: Query: INSERT INTO `t7` SELECT * FROM `view_t7` /* QNO 272 CON_ID 17 */ failed: 1100 Table 't%d' was not locked with LOCK TABLES. Further errors of this kind will be suppressed. # 2019-01-10T03:50:59 [24685] Executor::MySQL::execute: Query: ALTER TABLE t5 PARTITION BY HASH(ecol4) /* QNO 341 CON_ID 16 */ failed: 1478 Table storage engine 'partition' does not support the create option 'SEQUENCE' # 2019-01-10T03:50:59 [24680] ErrorFilter: Query: INSERT IGNORE INTO `t5` () VALUES () /* QNO 302 CON_ID 15 */ 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:50:59 [24680] ErrorFilter: Query: DROP SEQUENCE seq10 /* QNO 377 CON_ID 14 */ failed: 4091 Unknown SEQUENCE: 'test.seq%d'. Further errors of this kind will be suppressed. # 2019-01-10T03:50:59 [24682] WARNING: Table/view 'view_t7' in schema 'test' has no 'char' columns # 2019-01-10T03:51:00 [24680] ErrorFilter: Query: ALTER TABLE t8 /*!100301 NOWAIT */ DROP FOREIGN KEY y /* QNO 440 CON_ID 14 */ failed: 1205 Lock wait timeout exceeded; try restarting transaction. Further errors of this kind will be suppressed. # 2019-01-10T03:51:00 [24680] ErrorFilter: Query: LOAD DATA INFILE 'load_t3' REPLACE INTO TABLE t3 /* QNO 445 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:51:00 [24680] ErrorFilter: Query: ALTER TABLE t8 ADD COLUMN icol8 SMALLINT UNSIGNED NOT NULL DEFAULT 8, ALGORITHM=INPLACE /* QNO 458 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:51:00 [24680] ErrorFilter: Query: SET `system_versioning_innodb_algorithm_simple` = ON /* QNO 481 CON_ID 16 */ failed: 1193 Unknown system variable 'system_versioning_innodb_algorithm_simple'. Further errors of this kind will be suppressed. # 2019-01-10T03:51:00 [24680] ErrorFilter: Query: REPLACE INTO `view_t3` ( `col_dec`, `col_bit` ) VALUES ( DEFAULT, 'translate' ) /* QNO 523 CON_ID 16 */ failed: 1406 Data too long for column 'col_bit' at row %d. Further errors of this kind will be suppressed. # 2019-01-10T03:51:00 [24680] ErrorFilter: Query: ALTER TABLE t10 PARTITION BY KEY(tscol9) /* QNO 565 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-10T03:51:00 [24680] ErrorFilter: Query: SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE t8 ADD SYSTEM VERSIONING /* QNO 612 CON_ID 14 */ failed: 4135 Table `t%d` is already system-versioned. Further errors of this kind will be suppressed. # 2019-01-10T03:51:01 [24680] ErrorFilter: Query: SHOW EXPLAIN FOR 16 /* QNO 648 CON_ID 14 */ failed: 1933 Target is not running an EXPLAINable command. Further errors of this kind will be suppressed. # 2019-01-10T03:51:01 [24680] ErrorFilter: Query: TRUNCATE TABLE t2 /* QNO 633 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-10T03:51:01 [24683] Executor::MySQL::execute: Query: CREATE OR REPLACE TABLE t4 (tscol7 DATETIME NULL ) ROW_FORMAT = FIXED /* QNO 635 CON_ID 15 */ failed: 1005 Can't create table `test`.`t4` (errno: 140 "Wrong create options") # 2019-01-10T03:51:01 [24685] Executor::MySQL::execute: Query: ALTER TABLE t3 /*!100104 ENCRYPTION_KEY_ID = 7 */ /* QNO 671 CON_ID 16 */ failed: 1005 Can't create table `test`.`#sql-6041_10` (errno: 140 "Wrong create options") # 2019-01-10T03:51:01 [24680] ErrorFilter: Query: SHOW CREATE EVENT o /* QNO 789 CON_ID 14 */ failed: 1539 Unknown event '%s'. Further errors of this kind will be suppressed. # 2019-01-10T03:51:02 [24680] ErrorFilter: Query: SHOW CREATE TRIGGER q /* QNO 843 CON_ID 14 */ failed: 1360 Trigger does not exist. Further errors of this kind will be suppressed. # 2019-01-10T03:51:02 [24687] Executor::MySQL::execute: Query: SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE `t1` DROP COLUMN `row_start`, ROW_FORMAT=COMPRESSED, MODIFY COLUMN IF EXISTS icol5 SMALLINT NULL DEFAULT 0 AFTER ia_col_name, ADD FULLTEXT KEY(scol7), ALGORITHM=INPLACE, LOCK=SHARED, ADD COLUMN IF NOT EXISTS scol1 VARCHAR(25877) NULL, ALGORITHM=COPY, DROP INDEX ind5, ADD COLUMN IF NOT EXISTS tscol1 DATETIME DEFAULT 0 FIRST, LOCK=SHARED, DROP SYSTEM VERSIONING /* QNO 948 CON_ID 17 */ failed: 4131 Can not DROP SYSTEM VERSIONING for table `t1` partitioned BY SYSTEM_TIME # 2019-01-10T03:51:02 [24680] ErrorFilter: Query: REPLACE INTO `view_t3` ( `col_time`, `col_time` ) VALUES ( 76, 184 ) /* QNO 959 CON_ID 15 */ failed: 1292 Incorrect time value: '%d' for column `test`.`t%d`.`col_time` at row %d. Further errors of this kind will be suppressed. # 2019-01-10T03:51:03 [24683] Executor::MySQL::execute: Query: LOAD DATA INFILE 'load_t8' REPLACE INTO TABLE t8 /* QNO 1142 CON_ID 15 */ failed: 1263 Column set to default value; NULL supplied to NOT NULL column 'ncol10' at row 1 # 2019-01-10T03:51:03 [24683] Executor::MySQL::execute: Query: CREATE OR REPLACE TABLE `t6` (ecol5 ENUM('foo','bar') ) ROW_FORMAT = FIXED /* QNO 1151 CON_ID 15 */ failed: 1005 Can't create table `test`.`t6` (errno: 140 "Wrong create options") # 2019-01-10T03:51:05 [24687] WARNING: Table/view 'view_t7' in schema 'test' has no 'char' columns # 2019-01-10T03:51:05 [24680] ErrorFilter: Query: ALTER TABLE t2 DROP FOREIGN KEY h, DROP FOREIGN KEY u /* QNO 1556 CON_ID 14 */ failed: 1025 Error on rename of './test/t%d' to './test/#sql%d-%d-e' (errno: %d "Cannot delete a parent row"). Further errors of this kind will be suppressed. # 2019-01-10T03:51:06 [24680] ErrorFilter: Query: SET SESSION `system_versioning_asof` = ALL /* QNO 1987 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-10T03:51:08 [24682] Executor::MySQL::execute: Query: LOAD DATA INFILE 'load_t8' REPLACE INTO TABLE t8 /* QNO 1951 CON_ID 14 */ failed: 1263 Column set to default value; NULL supplied to NOT NULL column 'ncol10' at row 1 # 2019-01-10T03:51:08 [24680] ErrorFilter: Query: ALTER ONLINE TABLE t2 DROP COLUMN IF EXISTS `col_varchar`, LOCK=DEFAULT /* QNO 1927 CON_ID 17 */ failed: 1090 You can't delete all columns with ALTER TABLE; use DROP TABLE instead. Further errors of this kind will be suppressed. # 2019-01-10T03:51:09 [24683] WARNING: Table/view 'view_t7' in schema 'test' has no 'char' columns # 2019-01-10T03:51:09 [24680] ErrorFilter: Query: DROP TABLE t9 /* QNO 2450 CON_ID 15 */ failed: 1051 Unknown table '%s'. Further errors of this kind will be suppressed. # 2019-01-10T03:51:20 [24685] Executor::MySQL::execute: Query: ALTER IGNORE TABLE t2 /*!100104 ENCRYPTION_KEY_ID = 9 */, AUTO_INCREMENT 755040256 /* QNO 2541 CON_ID 16 */ failed: 1478 Table storage engine 'InnoDB' does not support the create option 'ENCRYPTION_KEY_ID' # 2019-01-10T03:51:21 [24680] ErrorFilter: Query: SHOW EVENTS IN performance_schema /* QNO 3360 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:51:23 [24680] ErrorFilter: Query: LOAD DATA INFILE 'load_t6' REPLACE INTO TABLE t6 /* QNO 3108 CON_ID 17 */ failed: 1265 Data truncated for column 'ecol%d' at row %d. Further errors of this kind will be suppressed. # 2019-01-10T03:51:24 [24683] Executor::MySQL::execute: Query: CREATE OR REPLACE TABLE t1 (tscol9 DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ROW_FORMAT = PAGE /* QNO 3615 CON_ID 15 */ failed: 1005 Can't create table `test`.`t1` (errno: 140 "Wrong create options") # 2019-01-10T03:51:24 [24680] ErrorFilter: Query: ALTER TABLE t3 ADD FOREIGN KEY (`col_timestamp`) REFERENCES t10 (tscol8) ON DELETE NO ACTION /* QNO 4081 CON_ID 14 */ failed: 1506 Foreign key clause is not yet supported in conjunction with partitioning. Further errors of this kind will be suppressed. # 2019-01-10T03:51:24 [24687] Executor::MySQL::execute: Query: ALTER TABLE t6 /*!100108 IETF_QUOTES = NO */ /* QNO 3616 CON_ID 17 */ failed: 1911 Unknown option 'IETF_QUOTES' # 2019-01-10T03:51:25 [24680] ErrorFilter: Query: SELECT * from `view_t3` FOR system_time FROM NOW(6) TO TRANSACTION @trx_user_var /* QNO 4303 CON_ID 14 */ failed: 4111 Transaction system versioning for `t%d` is not supported. Further errors of this kind will be suppressed. # 2019-01-10T03:51:26 [24680] ErrorFilter: Query: SHOW GRANTS FOR t /* QNO 3996 CON_ID 17 */ 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:51:26 [24680] ErrorFilter: Query: ALTER TABLE t5 /*!100301 WAIT 6 */ ENGINE = MyISAM /* QNO 4447 CON_ID 16 */ failed: 4120 Not allowed for system-versioned `test`.`t%d`. Change to/from native system versioning engine is not supported.. Further errors of this kind will be suppressed. # 2019-01-10T03:51:26 [24680] ErrorFilter: Query: CREATE OR REPLACE TABLE t1 (icol3 MEDIUMINT ZEROFILL NULL, `col_varchar` BLOB DEFAULT '', icol3 MEDIUMINT ZEROFILL NULL ) ROW_FORMAT DYNAMIC /* QNO 4777 CON_ID 14 */ failed: 1060 Duplicate column name '%s'. Further errors of this kind will be suppressed. # 2019-01-10T03:51:27 [24682] Executor::MySQL::execute: Query: SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE t5 DROP SYSTEM VERSIONING /* QNO 4904 CON_ID 14 */ failed: 4131 Can not DROP SYSTEM VERSIONING for table `t5` partitioned BY SYSTEM_TIME # 2019-01-10T03:51:28 [24680] ErrorFilter: Query: ALTER TABLE t5 ADD COLUMN `vers_start` TIMESTAMP(6) GENERATED ALWAYS AS ROW START, ADD COLUMN IF NOT EXISTS `vers_start` BIGINT UNSIGNED GENERATED ALWAYS AS ROW START /* QNO 4578 CON_ID 15 */ failed: 4134 Duplicate ROW START column `vers_start`. Further errors of this kind will be suppressed. # 2019-01-10T03:51:28 [24680] ErrorFilter: Query: SET TRANSACTION ISOLATION LEVEL READ COMMITTED /* QNO 5149 CON_ID 14 */ 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:51:29 [24680] ErrorFilter: Query: CREATE OR REPLACE TABLE t1 (`vers_start` BIGINT UNSIGNED GENERATED ALWAYS AS ROW START, `row_end` SMALLINT GENERATED ALWAYS AS ROW END, PERIOD FOR SYSTEM_TIME ( `vers_start`, `row_end` )) ENGINE=MyISAM ROW_FORMAT=REDUNDANT /* QNO 5346 CON_ID 14 */ failed: 4125 Wrong parameters for `t%d`: missing 'WITH SYSTEM VERSIONING'. Further errors of this kind will be suppressed. # 2019-01-10T03:51:29 [24680] ErrorFilter: Query: ALTER ONLINE TABLE t5 /*!100301 WAIT 1 */ ADD UNIQUE (scol5(11521)), LOCK=SHARED, MODIFY COLUMN IF EXISTS vcol1 VARCHAR(25183) AS ( SUBSTR(scol10, 4, 1 ) ) VIRTUAL, ALGORITHM=DEFAULT /* QNO 5450 CON_ID 14 */ 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-10T03:51:30 [24680] ErrorFilter: Query: SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE t5 ADD PARTITION (PARTITION ver_p3 HISTORY) /* QNO 5510 CON_ID 14 */ failed: 1517 Duplicate partition name %sver_p%d. Further errors of this kind will be suppressed. # 2019-01-10T03:51:31 [24682] Executor::MySQL::execute: Query: ALTER TABLE t2 /*!100301 WAIT 8 */ ADD COLUMN IF NOT EXISTS ( ecol5 SET('foo','bar') NOT NULL /*!100303 INVISIBLE */ /*!100201 CHECK (scol1 = 6) */ ), ALGORITHM=DEFAULT, LOCK=SHARED /* QNO 5835 CON_ID 14 */ failed: 4108 Invisible column `ecol5` must have a default value # 2019-01-10T03:51:31 [24680] ErrorFilter: Query: RENAME TABLE t1 TO tmp_rename_24685, tmp_rename_24685 TO t1 /* QNO 5714 CON_ID 16 */ 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:51:38 [24685] WARNING: Table/view 'view_t7' in schema 'test' has no 'char' columns # 2019-01-10T03:51:39 [24680] ErrorFilter: Query: SHOW ENGINE RocksDB MUTEX /* QNO 6865 CON_ID 15 */ failed: 1286 Unknown storage engine 'RocksDB'. Further errors of this kind will be suppressed. # 2019-01-10T03:51:49 [24581] #--------------------------# # 2019-01-10T03:51:49 [24581] #-- Creating full backup --# # 2019-01-10T03:51:49 [24581] #--------------------------# # 2019-01-10T03:51:49 [24581] /home/travis/server/bin/mariabackup --backup --target-dir=/home/travis/logs/vardir/backup_0 --protocol=tcp --port=19300 --user=root 2>/home/travis/logs/vardir/mbackup_backup_0.log # 2019-01-10T03:51:50 [24581][ERROR] Full backup failed # 2019-01-10T03:51:50 [24581] --------- Contents of /home/travis/logs/vardir/mbackup_backup_0.log ------------- # 2019-01-10T03:51:50 [24581] | Info: Using unique option prefix 'backup' is error-prone and can break in the future. Please use the full name 'backup_encrypted' instead. # 2019-01-10T03:51:50 [24581] | 190110 03:51:49 Connecting to MySQL server host: localhost, user: root, password: set, port: 19300, socket: /var/run/mysqld/mysqld.sock # 2019-01-10T03:51:50 [24581] | Using server version 10.4.2-MariaDB-debug-log # 2019-01-10T03:51:50 [24581] | Can not open directory /var/lib/mysql: No such file or directory # 2019-01-10T03:51:50 [24581] | Warning: option 'datadir' points to nonexistent directory '/var/lib/mysql' # 2019-01-10T03:51:50 [24581] | Warning: option 'datadir' has different values: # 2019-01-10T03:51:50 [24581] | '/var/lib/mysql' in defaults file # 2019-01-10T03:51:50 [24581] | '/home/travis/logs/vardir/data/' in SHOW VARIABLES # 2019-01-10T03:51:50 [24581] | /home/travis/server/bin/mariabackup based on MariaDB server 10.4.2-MariaDB Linux (x86_64) # 2019-01-10T03:51:50 [24581] | mariabackup: uses posix_fadvise(). # 2019-01-10T03:51:50 [24581] | mariabackup: cd to /home/travis/logs/vardir/data/ # 2019-01-10T03:51:50 [24581] | Loading encryption plugin # 2019-01-10T03:51:50 [24581] | Encryption plugin parameter : '--file_key_management_encryption_algorithm=aes_cbc' # 2019-01-10T03:51:50 [24581] | Encryption plugin parameter : '--file_key_management_filekey=' # 2019-01-10T03:51:50 [24581] | Encryption plugin parameter : '--file_key_management_filename=/home/travis/mariadb-toolbox/data/keys.txt' # 2019-01-10T03:51:50 [24581] | mariabackup: open files limit requested 0, set to 30000 # 2019-01-10T03:51:50 [24581] | mariabackup: using the following InnoDB configuration: # 2019-01-10T03:51:50 [24581] | mariabackup: innodb_data_home_dir = # 2019-01-10T03:51:50 [24581] | mariabackup: innodb_data_file_path = ibdata1:12M:autoextend # 2019-01-10T03:51:50 [24581] | mariabackup: innodb_log_group_home_dir = ./ # 2019-01-10T03:51:50 [24581] | 2019-01-10 03:51:49 0x7fa4fbbdb740 InnoDB: Using Linux native AIO # 2019-01-10T03:51:50 [24581] | 2019-01-10 3:51:49 0 [Note] InnoDB: Number of pools: 1 # 2019-01-10T03:51:50 [24581] | mariabackup: Generating a list of tablespaces # 2019-01-10T03:51:50 [24581] | 2019-01-10 3:51:49 0 [Warning] InnoDB: Allocated tablespace ID 3 for mysql/transaction_registry, old maximum was 0 # 2019-01-10T03:51:50 [24581] | 2019-01-10 3:51:49 0 [ERROR] InnoDB: Operating system error number 2 in a file operation. # 2019-01-10T03:51:50 [24581] | 2019-01-10 3:51:49 0 [ERROR] InnoDB: The error means the system cannot find the path specified. # 2019-01-10T03:51:50 [24581] | 2019-01-10 3:51:49 0 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them. # 2019-01-10T03:51:50 [24581] | 2019-01-10 3:51:49 0 [ERROR] InnoDB: File ./test/#sql-6041_11.ibd: 'open' returned OS error 71. # 2019-01-10T03:51:50 [24581] | 2019-01-10 03:51:49 0x7fa4fbbdb740 InnoDB: Assertion failure in file /home/travis/src/storage/innobase/fil/fil0fil.cc line 657 # 2019-01-10T03:51:50 [24581] | InnoDB: Failing assertion: success # 2019-01-10T03:51:50 [24581] | InnoDB: We intentionally generate a memory trap. # 2019-01-10T03:51:50 [24581] | InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ # 2019-01-10T03:51:50 [24581] | InnoDB: If you get repeated assertion failures or crashes, even # 2019-01-10T03:51:50 [24581] | InnoDB: immediately after the mysqld startup, there may be # 2019-01-10T03:51:50 [24581] | InnoDB: corruption in the InnoDB tablespace. Please refer to # 2019-01-10T03:51:50 [24581] | InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/ # 2019-01-10T03:51:50 [24581] | InnoDB: about forcing recovery. # 2019-01-10T03:51:50 [24581] | 190110 3:51:49 [ERROR] mysqld got signal 6 ; # 2019-01-10T03:51:50 [24581] | This could be because you hit a bug. It is also possible that this binary # 2019-01-10T03:51:50 [24581] | or one of the libraries it was linked against is corrupt, improperly built, # 2019-01-10T03:51:50 [24581] | or misconfigured. This error can also be caused by malfunctioning hardware. # 2019-01-10T03:51:50 [24581] | # 2019-01-10T03:51:50 [24581] | To report this bug, see https://mariadb.com/kb/en/reporting-bugs # 2019-01-10T03:51:50 [24581] | # 2019-01-10T03:51:50 [24581] | We will try our best to scrape up some info that will hopefully help # 2019-01-10T03:51:50 [24581] | diagnose the problem, but since we have already crashed, # 2019-01-10T03:51:50 [24581] | something is definitely wrong and this may fail. # 2019-01-10T03:51:50 [24581] | # 2019-01-10T03:51:50 [24581] | Server version: 10.4.2-MariaDB-debug # 2019-01-10T03:51:50 [24581] | key_buffer_size=0 # 2019-01-10T03:51:50 [24581] | read_buffer_size=131072 # 2019-01-10T03:51:50 [24581] | max_used_connections=0 # 2019-01-10T03:51:50 [24581] | max_threads=1 # 2019-01-10T03:51:50 [24581] | thread_count=0 # 2019-01-10T03:51:50 [24581] | It is possible that mysqld could use up to # 2019-01-10T03:51:50 [24581] | key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 5736 K bytes of memory # 2019-01-10T03:51:50 [24581] | Hope that's ok; if not, decrease some variables in the equation. # 2019-01-10T03:51:50 [24581] | # 2019-01-10T03:51:50 [24581] | Thread pointer: 0x0 # 2019-01-10T03:51:50 [24581] | Attempting backtrace. You can use the following information to find out # 2019-01-10T03:51:50 [24581] | where mysqld died. If you see no messages after this, something went # 2019-01-10T03:51:50 [24581] | terribly wrong... # 2019-01-10T03:51:50 [24581] | stack_bottom = 0x0 thread_stack 0x49000 # 2019-01-10T03:51:50 [24581] | /home/travis/server/bin/mariabackup(my_print_stacktrace+0x40)[0x55e5bbe1dff5] # 2019-01-10T03:51:50 [24581] | /home/travis/server/bin/mariabackup(handle_fatal_signal+0x3e1)[0x55e5bb6f127a] # 2019-01-10T03:51:50 [24581] | /lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7fa4fb7c3390] # 2019-01-10T03:51:50 [24581] | /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x38)[0x7fa4f9845428] # 2019-01-10T03:51:50 [24581] | /lib/x86_64-linux-gnu/libc.so.6(abort+0x16a)[0x7fa4f984702a] # 2019-01-10T03:51:50 [24581] | /home/travis/server/bin/mariabackup(+0xfc703a)[0x55e5bbb9003a] # 2019-01-10T03:51:50 [24581] | /home/travis/server/bin/mariabackup(+0xd38cdf)[0x55e5bb901cdf] # 2019-01-10T03:51:50 [24581] | ut/ut0mem.cc:42(ut_strlcpy(char*, char const*, unsigned long))[0x55e5bb905105] # 2019-01-10T03:51:50 [24581] | fil/fil0fil.cc:658(fil_node_open_file(fil_node_t*))[0x55e5bb1e3d2e] # 2019-01-10T03:51:50 [24581] | fil/fil0fil.cc:1647(fil_space_t::open())[0x55e5bb1e4126] # 2019-01-10T03:51:50 [24581] | mariabackup/xtrabackup.cc:3136(xb_load_single_table_tablespace(char const*, char const*, bool))[0x55e5bb1e46c1] # 2019-01-10T03:51:50 [24581] | mariabackup/xtrabackup.cc:3251(enumerate_ibd_files(void (*)(char const*, char const*, bool)))[0x55e5bb1e6509] # 2019-01-10T03:51:50 [24581] | mariabackup/xtrabackup.cc:3421(xb_load_tablespaces())[0x55e5bb1eda33] # 2019-01-10T03:51:50 [24581] | mariabackup/xtrabackup.cc:4250(xtrabackup_backup_func())[0x55e5bb1ed283] # 2019-01-10T03:51:50 [24581] | /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf0)[0x7fa4f9830830] # 2019-01-10T03:51:50 [24581] | /home/travis/server/bin/mariabackup(_start+0x29)[0x55e5bb1dcef9] # 2019-01-10T03:51:50 [24581] | The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains # 2019-01-10T03:51:50 [24581] | information that should help you find out what is causing the crash. # 2019-01-10T03:51:50 [24581] | Aborted (core dumped) # 2019-01-10T03:51:50 [24581] ---------------------------------- # 2019-01-10T03:51:50 [24687] Executor::MySQL::execute: Query: UPDATE IGNORE `view_t4` SET `col_int` = DEFAULT ORDER BY `col_blob` LIMIT 1 /* QNO 9611 CON_ID 17 */ failed: 2013 Lost connection to MySQL server during query # 2019-01-10T03:51:50 [24682] Executor::MySQL::execute: Query: SET `system_versioning_innodb_algorithm_simple` = ON /* QNO 10228 CON_ID 14 */ failed: 2013 Lost connection to MySQL server during query # 2019-01-10T03:51:50 [24682] 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-10T03:51:50 [24687] 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-10T03:51:50 [24682] GenTest: Server crash or critical failure (STATUS_SERVER_CRASHED) reported, the child will be stopped # 2019-01-10T03:51:50 [24687] GenTest: Server crash or critical failure (STATUS_SERVER_CRASHED) reported, the child will be stopped # 2019-01-10T03:51:50 [24682] GenTest: child 24682 is being stopped with status STATUS_SERVER_CRASHED # 2019-01-10T03:51:50 [24687] GenTest: child 24687 is being stopped with status STATUS_SERVER_CRASHED # 2019-01-10T03:51:50 [24685] Executor::MySQL::execute: Query: SET SQL_MODE=@@global.sql_mode /* QNO 10598 CON_ID 16 */ failed: 2013 Lost connection to MySQL server during query # 2019-01-10T03:51:50 [24683] Executor::MySQL::execute: Query: SELECT SETVAL(seq4, 118) /* QNO 9818 CON_ID 15 */ failed: 2013 Lost connection to MySQL server during query # 2019-01-10T03:51:50 [24683] 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-10T03:51:50 [24685] 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-10T03:51:50 [24685] GenTest: Server crash or critical failure (STATUS_SERVER_CRASHED) reported, the child will be stopped # 2019-01-10T03:51:50 [24683] GenTest: Server crash or critical failure (STATUS_SERVER_CRASHED) reported, the child will be stopped # 2019-01-10T03:51:50 [24683] GenTest: child 24683 is being stopped with status STATUS_SERVER_CRASHED # 2019-01-10T03:51:50 [24685] GenTest: child 24685 is being stopped with status STATUS_SERVER_CRASHED # 2019-01-10T03:51:50 [24581] Killed process 24641 # 2019-01-10T03:51:50 [24581] [24581] ./runall-new.pl will exit with exit status STATUS_BACKUP_FAILURE (108)