# 2019-01-10T18:34:36 [2030] Copyright (c) 2010,2011 Oracle and/or its affiliates. All rights reserved. Use is subject to license terms. # 2019-01-10T18:34:36 [2030] Please see http://forge.mysql.com/wiki/Category:RandomQueryGenerator for more information on this test framework. # 2019-01-10T18:34:36 [2030] Starting # 2019-01-10T18:34:36 [2030] # ./runall-new.pl \ # 2019-01-10T18:34:36 [2030] # --basedir=/home/travis/server \ # 2019-01-10T18:34:36 [2030] # --vardir=/home/travis/logs/vardir \ # 2019-01-10T18:34:36 [2030] # --duration=350 \ # 2019-01-10T18:34:36 [2030] # --threads=4 \ # 2019-01-10T18:34:36 [2030] # --seed=1547101908 \ # 2019-01-10T18:34:36 [2030] # --reporters=Backtrace,ErrorLog,Deadlock \ # 2019-01-10T18:34:36 [2030] # --skip-gendata \ # 2019-01-10T18:34:36 [2030] # --gendata-advanced \ # 2019-01-10T18:34:36 [2030] # --views \ # 2019-01-10T18:34:36 [2030] # --grammar=conf/mariadb/generic-dml.yy \ # 2019-01-10T18:34:36 [2030] # --redefine=conf/mariadb/bulk_insert.yy \ # 2019-01-10T18:34:36 [2030] # --mysqld=--log_output=FILE \ # 2019-01-10T18:34:36 [2030] # --mysqld=--max-statement-time=20 \ # 2019-01-10T18:34:36 [2030] # --mysqld=--lock-wait-timeout=10 \ # 2019-01-10T18:34:36 [2030] # --mysqld=--loose-innodb-lock-wait-timeout=5 \ # 2019-01-10T18:34:36 [2030] # --mysqld=--loose-debug_assert_on_not_freed_memory=0 \ # 2019-01-10T18:34:36 [2030] # --filter=/home/travis/mariadb-toolbox/travis/10.4-combo-filter.ff \ # 2019-01-10T18:34:36 [2030] # --mysqld=--plugin-load-add=ha_rocksdb \ # 2019-01-10T18:34:36 [2030] # --mysqld=--binlog-format=row \ # 2019-01-10T18:34:36 [2030] # --engine=RocksDB \ # 2019-01-10T18:34:36 [2030] # --scenario=MariaBackupIncremental # 2019-01-10T18:34:36 [2030] Ports : 19300 19300 19302 19304 MTR_BUILD_THREAD : 930 # 2019-01-10T18:34:36 [2030] Final command line: # 2019-01-10T18:34:36 [2030] perl ./runall-new.pl --basedir=/home/travis/server --vardir=/home/travis/logs/vardir --duration=350 --threads=4 --seed=1547101908 --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=--plugin-load-add=ha_rocksdb --mysqld=--binlog-format=row --engine=RocksDB --scenario=MariaBackupIncremental # 2019-01-10T18:34:36 [2030] # 2019-01-10T18:34:36 [2030] ======================================== # 2019-01-10T18:34:36 [2030] === Incremental MariaBackup scenario === # 2019-01-10T18:34:36 [2030] ======================================== # 2019-01-10T18:34:36 [2030] Cannot find 'mysqld-debug' in '/home/travis/server/sql','/home/travis/server/libexec','/home/travis/server/bin','/home/travis/server/sbin', at lib/GenTest/Scenario.pm line 127. elenst@ws:/data/src/rqg$ perl ./runall-new.pl --basedir=/home/travis/server/10.4 --vardir=/home/travis/logs/vardir --duration=350 --threads=4 --seed=1547101908 --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=--plugin-load-add=ha_rocksdb --mysqld=--binlog-format=row --engine=RocksDB --scenario=MariaBackupIncremental # 2019-01-10T18:34:42 [2160] Copyright (c) 2010,2011 Oracle and/or its affiliates. All rights reserved. Use is subject to license terms. # 2019-01-10T18:34:42 [2160] Please see http://forge.mysql.com/wiki/Category:RandomQueryGenerator for more information on this test framework. # 2019-01-10T18:34:42 [2160] Starting # 2019-01-10T18:34:42 [2160] # ./runall-new.pl \ # 2019-01-10T18:34:42 [2160] # --basedir=/home/travis/server/10.4 \ # 2019-01-10T18:34:42 [2160] # --vardir=/home/travis/logs/vardir \ # 2019-01-10T18:34:42 [2160] # --duration=350 \ # 2019-01-10T18:34:42 [2160] # --threads=4 \ # 2019-01-10T18:34:42 [2160] # --seed=1547101908 \ # 2019-01-10T18:34:42 [2160] # --reporters=Backtrace,ErrorLog,Deadlock \ # 2019-01-10T18:34:42 [2160] # --skip-gendata \ # 2019-01-10T18:34:42 [2160] # --gendata-advanced \ # 2019-01-10T18:34:42 [2160] # --views \ # 2019-01-10T18:34:42 [2160] # --grammar=conf/mariadb/generic-dml.yy \ # 2019-01-10T18:34:42 [2160] # --redefine=conf/mariadb/bulk_insert.yy \ # 2019-01-10T18:34:42 [2160] # --mysqld=--log_output=FILE \ # 2019-01-10T18:34:42 [2160] # --mysqld=--max-statement-time=20 \ # 2019-01-10T18:34:42 [2160] # --mysqld=--lock-wait-timeout=10 \ # 2019-01-10T18:34:42 [2160] # --mysqld=--loose-innodb-lock-wait-timeout=5 \ # 2019-01-10T18:34:42 [2160] # --mysqld=--loose-debug_assert_on_not_freed_memory=0 \ # 2019-01-10T18:34:42 [2160] # --filter=/home/travis/mariadb-toolbox/travis/10.4-combo-filter.ff \ # 2019-01-10T18:34:42 [2160] # --mysqld=--plugin-load-add=ha_rocksdb \ # 2019-01-10T18:34:42 [2160] # --mysqld=--binlog-format=row \ # 2019-01-10T18:34:42 [2160] # --engine=RocksDB \ # 2019-01-10T18:34:42 [2160] # --scenario=MariaBackupIncremental # 2019-01-10T18:34:42 [2160] Ports : 19300 19300 19302 19304 MTR_BUILD_THREAD : 930 # 2019-01-10T18:34:42 [2160] Final command line: # 2019-01-10T18:34:42 [2160] perl ./runall-new.pl --basedir=/home/travis/server/10.4 --vardir=/home/travis/logs/vardir --duration=350 --threads=4 --seed=1547101908 --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=--plugin-load-add=ha_rocksdb --mysqld=--binlog-format=row --engine=RocksDB --scenario=MariaBackupIncremental # 2019-01-10T18:34:42 [2160] # 2019-01-10T18:34:42 [2160] ======================================== # 2019-01-10T18:34:42 [2160] === Incremental MariaBackup scenario === # 2019-01-10T18:34:42 [2160] ======================================== # 2019-01-10T18:34:42 [2160] # 2019-01-10T18:34:42 [2160] Creating MySQL 10.4.2 database at /home/travis/logs/vardir/data # 2019-01-10T18:34:42 [2160] Bootstrap command: "/home/travis/server/10.4/bin/mysqld" "--no-defaults" "--basedir=/home/travis/server/10.4" "--lc-messages-dir=/home/travis/server/10.4/share" "--character-sets-dir=/home/travis/server/10.4/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" "--plugin-load-add=ha_rocksdb" "--binlog-format=row" "--skip-log-bin" "--loose-innodb-encrypt-tables=OFF" "--loose-innodb-encrypt-log=OFF" "--bootstrap" < "/home/travis/logs/vardir/boot.sql" # 2019-01-10T18:34:45 [2160] -- Server info: -- # 2019-01-10T18:34:45 [2160] 10.4.2 # 2019-01-10T18:34:45 [2160] --log_output=FILE # 2019-01-10T18:34:45 [2160] --max-statement-time=20 # 2019-01-10T18:34:45 [2160] --lock-wait-timeout=10 # 2019-01-10T18:34:45 [2160] --loose-innodb-lock-wait-timeout=5 # 2019-01-10T18:34:45 [2160] --loose-debug_assert_on_not_freed_memory=0 # 2019-01-10T18:34:45 [2160] --plugin-load-add=ha_rocksdb # 2019-01-10T18:34:45 [2160] --binlog-format=row # 2019-01-10T18:34:45 [2160] #-------------------------# # 2019-01-10T18:34:45 [2160] #-- Starting the server --# # 2019-01-10T18:34:45 [2160] #-------------------------# # 2019-01-10T18:34:45 [2160] MySQL Version: 10.4.2 # 2019-01-10T18:34:45 [2160] Binary: /home/travis/server/10.4/bin/mysqld # 2019-01-10T18:34:45 [2160] Type: Debug # 2019-01-10T18:34:45 [2160] Datadir: /home/travis/logs/vardir/data # 2019-01-10T18:34:45 [2160] Tmpdir: /home/travis/logs/vardir/tmp # 2019-01-10T18:34:45 [2160] Corefile: /home/travis/logs/vardir/data/core. # 2019-01-10T18:34:45 [2160] Starting MySQL 10.4.2: "/home/travis/server/10.4/bin/mysqld" "--no-defaults" "--basedir=/home/travis/server/10.4" "--lc-messages-dir=/home/travis/server/10.4/share" "--character-sets-dir=/home/travis/server/10.4/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 --plugin-load-add=ha_rocksdb --binlog-format=row # 2019-01-10T18:34:45 [2160] Pid file does not exist and timeout hasn't passed yet, but the error log has already been updated # 2019-01-10T18:34:45 [2160] Found PID 2288 in the error log # 2019-01-10T18:34:45 [2160] Server started with PID 2288 # 2019-01-10T18:34:45 [2160] Connecting to 19300 # 2019-01-10T18:34:45 [2160] #---------------------------------------------# # 2019-01-10T18:34:45 [2160] #-- Running initial test flow on the server --# # 2019-01-10T18:34:45 [2160] #---------------------------------------------# # 2019-01-10T18:34:45 [2329] ------------------------------- # 2019-01-10T18:34:45 [2329] Configuration # 2019-01-10T18:34:45 [2329] debug_server => ['', '', ''] # 2019-01-10T18:34:45 [2329] dsn => ['dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test:mysql_local_infile=1'] # 2019-01-10T18:34:45 [2329] duration => 280 # 2019-01-10T18:34:45 [2329] engine => ['RocksDB', 'RocksDB', 'RocksDB'] # 2019-01-10T18:34:45 [2329] filter => /home/travis/mariadb-toolbox/travis/10.4-combo-filter.ff # 2019-01-10T18:34:45 [2329] gendata-advanced => 1 # 2019-01-10T18:34:45 [2329] generator => FromGrammar # 2019-01-10T18:34:45 [2329] grammar => conf/mariadb/generic-dml.yy # 2019-01-10T18:34:45 [2329] queries => 100000000 # 2019-01-10T18:34:45 [2329] redefine => ['conf/mariadb/bulk_insert.yy'] # 2019-01-10T18:34:45 [2329] reporters => ['Backtrace', 'ErrorLog', 'Deadlock'] # 2019-01-10T18:34:45 [2329] seed => 1547101908 # 2019-01-10T18:34:45 [2329] servers => ['DBServer::MySQL::MySQLd=ARRAY(0x1c8e258)'] # 2019-01-10T18:34:45 [2329] strict_fields => 1 # 2019-01-10T18:34:45 [2329] threads => 4 # 2019-01-10T18:34:45 [2329] transformers => [''] # 2019-01-10T18:34:45 [2329] validators => [''] # 2019-01-10T18:34:45 [2329] vcols => ['', '', ''] # 2019-01-10T18:34:45 [2329] views => ['', '', ''] # 2019-01-10T18:34:45 [2329] Creating MySQL table t1, size 0 rows, engine RocksDB . # 2019-01-10T18:34:45 [2329] 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-10T18:34:45 [2329] 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-10T18:34:45 [2329] 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-10T18:34:45 [2329] 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-10T18:34:45 [2329] 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-10T18:34:45 [2329] Creating MySQL table t2, size 1 rows, engine RocksDB . # 2019-01-10T18:34:45 [2329] Creating MySQL table t3, size 20 rows, engine RocksDB . # 2019-01-10T18:34:46 [2329] Creating MySQL table t4, size 100 rows, engine RocksDB . # 2019-01-10T18:34:46 [2329] Creating MySQL table t5, size 1000 rows, engine RocksDB . # 2019-01-10T18:34:46 [2329] 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-10T18:34:46 [2329] Creating MySQL table t6, size 0 rows, engine RocksDB . # 2019-01-10T18:34:46 [2329] 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-10T18:34:46 [2329] 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-10T18:34:46 [2329] Creating MySQL table t7, size 1 rows, engine RocksDB . # 2019-01-10T18:34:46 [2329] Creating MySQL table t8, size 20 rows, engine RocksDB . # 2019-01-10T18:34:47 [2329] Creating MySQL table t9, size 100 rows, engine RocksDB . # 2019-01-10T18:34:47 [2329] 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-10T18:34:47 [2329] Reading grammar from file conf/mariadb/generic-dml.yy # 2019-01-10T18:34:47 [2329] Reading grammar from file conf/mariadb/bulk_insert.yy # 2019-01-10T18:34:47 [2329] Reporters: Backtrace, ErrorLog, Deadlock # 2019-01-10T18:34:47 [2329] Validators: (none) # 2019-01-10T18:34:47 [2329] Caching schema metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test:mysql_local_infile=1 # 2019-01-10T18:34:47 [2329] Loaded 5 filtering rules from '/home/travis/mariadb-toolbox/travis/10.4-combo-filter.ff' # 2019-01-10T18:34:47 [2329] Starting 4 processes, 100000000 queries each, duration 280 seconds. # 2019-01-10T18:34:47 [2329] GenTest::ErrorFilter(2374) started # 2019-01-10T18:34:47 [2374] ErrorFilter: Query: SELECT `col_year` FROM `view_t1` ORDER BY `col_int` LIMIT 1 /* QNO 93 CON_ID 14 */ failed: 1054 Unknown column '%s' in 'field list'. Further errors of this kind will be suppressed. # 2019-01-10T18:34:47 [2374] ErrorFilter: Query: INSERT INTO `view_t7` SELECT * FROM `view_t5` /* QNO 98 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-10T18:34:48 [2374] ErrorFilter: Query: REPLACE INTO `view_t9` ( `col_dec`, `col_timestamp` ) VALUES ( 'w', '' ) /* QNO 92 CON_ID 15 */ failed: 1366 Incorrect decimal value: 'w' for column `test`.`t%d`.`col_dec` at row %d. Further errors of this kind will be suppressed. # 2019-01-10T18:34:48 [2374] ErrorFilter: Query: UPDATE IGNORE `t7` SET `col_timestamp` = 124 ORDER BY `col_enum` LIMIT 1 /* QNO 103 CON_ID 15 */ failed: 1213 Deadlock found when trying to get lock; try restarting transaction (snapshot conflict). Further errors of this kind will be suppressed. # 2019-01-10T18:34:48 [2374] ErrorFilter: Query: INSERT IGNORE INTO `t3` ( `pk`, `pk` ) VALUES ( '', '' ) /* QNO 188 CON_ID 14 */ failed: 1110 Column '%s' specified twice. Further errors of this kind will be suppressed. # 2019-01-10T18:34:48 [2374] ErrorFilter: Query: SELECT * FROM `view_t7` INTO OUTFILE 'load_view_t7' /* QNO 172 CON_ID 15 */ failed: 1086 File '%s' already exists. Further errors of this kind will be suppressed. # 2019-01-10T18:34:48 [2374] ErrorFilter: Query: REPLACE INTO `t6` ( `col_timestamp`, `col_blob` ) VALUES ( '', DEFAULT ) /* QNO 188 CON_ID 15 */ failed: 1292 Incorrect datetime value: '' for column `test`.`t%d`.`col_timestamp` at row %d. Further errors of this kind will be suppressed. # 2019-01-10T18:34:48 [2374] ErrorFilter: Query: REPLACE INTO `view_t7` ( `col_blob`, `col_bit` ) VALUES ( DEFAULT, NULL ) /* QNO 189 CON_ID 15 */ failed: 1048 Column '%s' cannot be null. Further errors of this kind will be suppressed. # 2019-01-10T18:34:48 [2375] Started periodic reporting process... # 2019-01-10T18:34:49 [2374] ErrorFilter: Query: LOAD DATA INFILE 'load_t3' REPLACE INTO TABLE t3 /* QNO 93 CON_ID 17 */ failed: 1205 Lock wait timeout exceeded; try restarting transaction. Further errors of this kind will be suppressed. # 2019-01-10T18:34:49 [2374] ErrorFilter: Query: INSERT INTO `t8` SELECT * FROM `t8` /* QNO 239 CON_ID 14 */ failed: 1062 Duplicate entry '%s' for key '%s'. Further errors of this kind will be suppressed. # 2019-01-10T18:34:50 [2374] ErrorFilter: Query: INSERT INTO `view_t1` SELECT * FROM `view_t6` /* QNO 167 CON_ID 17 */ failed: 1265 Data truncated for column 'col_enum' at row %d. Further errors of this kind will be suppressed. # 2019-01-10T18:34:50 [2374] ErrorFilter: Query: REPLACE INTO `t4` ( `col_bit`, `pk` ) VALUES ( 'fault', '' ) /* QNO 336 CON_ID 14 */ failed: 1406 Data too long for column 'col_bit' at row %d. Further errors of this kind will be suppressed. # 2019-01-10T18:34:59 [2374] ErrorFilter: Query: INSERT INTO `t5` SELECT * FROM `t9` /* QNO 330 CON_ID 15 */ failed: 1264 Out of range value for column 'col_int' at row %d. Further errors of this kind will be suppressed. # 2019-01-10T18:35:43 [2160] #--------------------------# # 2019-01-10T18:35:43 [2160] #-- Creating full backup --# # 2019-01-10T18:35:43 [2160] #--------------------------# # 2019-01-10T18:35:43 [2160] /home/travis/server/10.4/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-10T18:35:46 [2160] #--------------------------------------------# # 2019-01-10T18:35:46 [2160] #-- Continuing test flow after full backup --# # 2019-01-10T18:35:46 [2160] #--------------------------------------------# # 2019-01-10T18:36:44 [2160] #-------------------------------------# # 2019-01-10T18:36:44 [2160] #-- Creating 1st incremental backup --# # 2019-01-10T18:36:44 [2160] #-------------------------------------# # 2019-01-10T18:36:44 [2160] /home/travis/server/10.4/bin/mariabackup --backup --target-dir=/home/travis/logs/vardir/backup_1 --incremental-basedir=/home/travis/logs/vardir/backup_0 --protocol=tcp --port=19300 --user=root 2>/home/travis/logs/vardir/mbackup_backup_1.log # 2019-01-10T18:36:47 [2160] #-------------------------------------------------------# # 2019-01-10T18:36:47 [2160] #-- Continuing test flow after 1st incremental backup --# # 2019-01-10T18:36:47 [2160] #-------------------------------------------------------# # 2019-01-10T18:37:45 [2160] #-------------------------------------# # 2019-01-10T18:37:45 [2160] #-- Creating 2nd incremental backup --# # 2019-01-10T18:37:45 [2160] #-------------------------------------# # 2019-01-10T18:37:45 [2160] /home/travis/server/10.4/bin/mariabackup --backup --target-dir=/home/travis/logs/vardir/backup_2 --incremental-basedir=/home/travis/logs/vardir/backup_1 --protocol=tcp --port=19300 --user=root 2>/home/travis/logs/vardir/mbackup_backup_2.log # 2019-01-10T18:37:48 [2160] #-------------------------# # 2019-01-10T18:37:48 [2160] #-- Stopping the server --# # 2019-01-10T18:37:48 [2160] #-------------------------# # 2019-01-10T18:37:48 [2160] Stopping server on port 19300 # 2019-01-10T18:37:48 [2376] Executor::MySQL::execute: Query: SELECT * FROM `t8` INTO OUTFILE 'load_t8' /* QNO 3284 CON_ID 14 */ failed: 2013 Lost connection to MySQL server during query # 2019-01-10T18:37:48 [2383] Executor::MySQL::execute: Query: SELECT `pk` FROM `view_t6` ORDER BY `col_dec` LIMIT 1 /* QNO 3547 CON_ID 17 */ failed: 2013 Lost connection to MySQL server during query # 2019-01-10T18:37:48 [2376] 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-10T18:37:48 [2376] GenTest: Server crash or critical failure (STATUS_SERVER_CRASHED) reported, the child will be stopped # 2019-01-10T18:37:48 [2376] GenTest: child 2376 is being stopped with status STATUS_SERVER_CRASHED # 2019-01-10T18:37:48 [2383] 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-10T18:37:48 [2374] ErrorFilter: Query: INSERT IGNORE INTO `t4` ( `col_time`, `col_varchar` ) VALUES ( NULL, NULL ) /* QNO 3488 CON_ID 15 */ failed: 2006 MySQL server has gone away. Further errors of this kind will be suppressed. # 2019-01-10T18:37:48 [2383] GenTest: Server crash or critical failure (STATUS_SERVER_CRASHED) reported, the child will be stopped # 2019-01-10T18:37:48 [2383] GenTest: child 2383 is being stopped with status STATUS_SERVER_CRASHED # 2019-01-10T18:37:51 [2160] Server has been stopped # 2019-01-10T18:37:51 [2160] #-------------------------------------------------------------# # 2019-01-10T18:37:51 [2160] #-- Checking the server log for fatal errors after shutdown --# # 2019-01-10T18:37:51 [2160] #-------------------------------------------------------------# # 2019-01-10T18:37:51 [2160] Checking server log for important errors starting from the beginning # 2019-01-10T18:37:51 [2160] #----------------------------------------------# # 2019-01-10T18:37:51 [2160] #-- Backing up data directory before restart --# # 2019-01-10T18:37:51 [2160] #----------------------------------------------# # 2019-01-10T18:37:51 [2160] Copying datadir... (interrupting the copy operation may cause investigation problems later) # 2019-01-10T18:37:51 [2160] Storing the backups before prepare attempt... # 2019-01-10T18:37:51 [2160] #---------------------------# # 2019-01-10T18:37:51 [2160] #-- Preparing full backup --# # 2019-01-10T18:37:51 [2160] #---------------------------# # 2019-01-10T18:37:51 [2160] /home/travis/server/10.4/bin/mariabackup --prepare --apply-log-only --innodb-file-io-threads=1 --target-dir=/home/travis/logs/vardir/backup_0 --user=root 2>/home/travis/logs/vardir/mbackup_prepare_0.log # 2019-01-10T18:37:52 [2160] #--------------------------------------# # 2019-01-10T18:37:52 [2160] #-- Preparing 1st incremental backup --# # 2019-01-10T18:37:52 [2160] #--------------------------------------# # 2019-01-10T18:37:52 [2160] /home/travis/server/10.4/bin/mariabackup --prepare --apply-log-only --innodb-file-io-threads=1 --target-dir=/home/travis/logs/vardir/backup_0 --incremental-dir=/home/travis/logs/vardir/backup_1 --user=root 2>/home/travis/logs/vardir/mbackup_prepare_1.log # 2019-01-10T18:37:53 [2160] #--------------------------------------# # 2019-01-10T18:37:53 [2160] #-- Preparing 2nd incremental backup --# # 2019-01-10T18:37:53 [2160] #--------------------------------------# # 2019-01-10T18:37:53 [2160] /home/travis/server/10.4/bin/mariabackup --prepare --apply-log-only --innodb-file-io-threads=1 --target-dir=/home/travis/logs/vardir/backup_0 --incremental-dir=/home/travis/logs/vardir/backup_2 --user=root 2>/home/travis/logs/vardir/mbackup_prepare_2.log # 2019-01-10T18:37:53 [2329] Process with pid 2383 ended with status STATUS_SERVER_CRASHED # 2019-01-10T18:37:53 [2329] Killing remaining worker process with pid 2381... # 2019-01-10T18:37:53 [2329] Killing remaining worker process with pid 2379... # 2019-01-10T18:37:53 [2329] Killing remaining worker process with pid 2376... # 2019-01-10T18:37:54 [2329] Killing periodic reporting process with pid 2375... DBI connect('host=127.0.0.1:port=19300:user=root:database=test:mysql_local_infile=1','',...) failed: Can't connect to MySQL server on '127.0.0.1' (111) at lib/GenTest/Reporter/Deadlock.pm line 82. # 2019-01-10T18:37:54 [2375] GenTest: child 2375 is being stopped with status STATUS_SERVER_CRASHED # 2019-01-10T18:37:54 [2329] For pid 2375 reporter status STATUS_SERVER_CRASHED # 2019-01-10T18:37:54 [2329] Kill GenTest::ErrorFilter(2374) # 2019-01-10T18:37:54 [2329] Server crash reported, initiating post-crash analysis... # 2019-01-10T18:37:54 [2329] datadir is /home/travis/logs/vardir/data/ # 2019-01-10T18:37:54 [2329] binary is /home/travis/server/10.4/bin/mysqld # 2019-01-10T18:37:54 [2329] bindir is /home/travis/server/10.4/bin # 2019-01-10T18:37:54 [2329] WARNING: Core file not found! # 2019-01-10T18:37:54 [2160] #----------------------# # 2019-01-10T18:37:54 [2160] #-- Restoring backup --# # 2019-01-10T18:37:54 [2160] #----------------------# # 2019-01-10T18:37:54 [2160] /home/travis/server/10.4/bin/mariabackup --copy-back --target-dir=/home/travis/logs/vardir/backup_0 --datadir=/home/travis/logs/vardir/data --user=root 2>/home/travis/logs/vardir/mbackup_restore.log # 2019-01-10T18:37:54 [2160] #---------------------------# # 2019-01-10T18:37:54 [2160] #-- Restarting the server --# # 2019-01-10T18:37:54 [2160] #---------------------------# # 2019-01-10T18:37:54 [2160] MySQL Version: 10.4.2 # 2019-01-10T18:37:54 [2160] Binary: /home/travis/server/10.4/bin/mysqld # 2019-01-10T18:37:54 [2160] Type: Debug # 2019-01-10T18:37:54 [2160] Datadir: /home/travis/logs/vardir/data # 2019-01-10T18:37:54 [2160] Tmpdir: /home/travis/logs/vardir/tmp # 2019-01-10T18:37:54 [2160] Corefile: /home/travis/logs/vardir/data/core.2288 # 2019-01-10T18:37:54 [2160] Starting MySQL 10.4.2: "/home/travis/server/10.4/bin/mysqld" "--no-defaults" "--basedir=/home/travis/server/10.4" "--lc-messages-dir=/home/travis/server/10.4/share" "--character-sets-dir=/home/travis/server/10.4/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 --plugin-load-add=ha_rocksdb --binlog-format=row # 2019-01-10T18:37:54 [2160] Pid file does not exist and timeout hasn't passed yet, but the error log has already been updated # 2019-01-10T18:37:54 [2160] Found PID 5587 in the error log # 2019-01-10T18:37:55 [2160] Server started with PID 5587 # 2019-01-10T18:37:55 [2160] #------------------------------------------------------------# # 2019-01-10T18:37:55 [2160] #-- Checking the server error log for errors after restart --# # 2019-01-10T18:37:55 [2160] #------------------------------------------------------------# # 2019-01-10T18:37:55 [2160] Checking server log for important errors starting from the beginning # 2019-01-10T18:37:55 [2160] ------ # 2019-01-10T18:37:55 [2160] 2019-01-10 18:37:54 0 [ERROR] Plugin 'ROCKSDB' registration as a STORAGE ENGINE failed. # 2019-01-10T18:37:55 [2160] ------ # 2019-01-10T18:37:55 [2160][ERROR] Found errors in the log, restart has apparently failed "/data/src/rqg" is not a core dump: Is a directory backtrace.gdb:19: Error in sourced command file: No stack. # 2019-01-10T18:37:55 [2329] # 2019-01-10T18:37:55 [2160] Killed process 5587 # 2019-01-10T18:37:55 [2160] [2160] ./runall-new.pl will exit with exit status STATUS_BACKUP_FAILURE (108) elenst@ws:/data/src/rqg$ "/data/src/rqg" is not a core dump: Is a directory # 2019-01-10T18:37:56 [2329] # 2019-01-10T18:37:56 [2329] The last 200 lines from /home/travis/logs/vardir/data//../mysql.err : 2019-01-10 18:37:54 0 [Note] /home/travis/server/10.4/bin/mysqld (mysqld 10.4.2-MariaDB-debug-log) starting as process 5587 ... 2019-01-10 18:37:54 0 [Warning] You need to use --log-bin to make --binlog-format work. 2019-01-10 18:37:54 0 [Note] RocksDB: Got ENOENT when listing column families 2019-01-10 18:37:54 0 [Note] RocksDB: assuming that we're creating a new database 2019-01-10 18:37:54 0 [Note] RocksDB: Column Families at start: 2019-01-10 18:37:54 0 [Note] cf=default 2019-01-10 18:37:54 0 [Note] write_buffer_size=67108864 2019-01-10 18:37:54 0 [Note] target_file_size_base=67108864 2019-01-10 18:37:54 0 [Note] RocksDB: creating a column family __system__ 2019-01-10 18:37:54 0 [Note] write_buffer_size=67108864 2019-01-10 18:37:54 0 [Note] target_file_size_base=67108864 2019-01-10 18:37:54 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table test.t1, but that table is not registered in RocksDB 2019-01-10 18:37:54 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table test.t2, but that table is not registered in RocksDB 2019-01-10 18:37:54 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table test.t3, but that table is not registered in RocksDB 2019-01-10 18:37:54 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table test.t4, but that table is not registered in RocksDB 2019-01-10 18:37:54 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table test.t5, but that table is not registered in RocksDB 2019-01-10 18:37:54 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table test.t6, but that table is not registered in RocksDB 2019-01-10 18:37:54 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table test.t7, but that table is not registered in RocksDB 2019-01-10 18:37:54 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table test.t8, but that table is not registered in RocksDB 2019-01-10 18:37:54 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table test.t9, but that table is not registered in RocksDB 2019-01-10 18:37:54 0 [ERROR] RocksDB: Problems validating data dictionary against .frm files, exiting 2019-01-10 18:37:54 0 [ERROR] RocksDB: Failed to initialize DDL manager. 2019-01-10 18:37:54 0 [ERROR] Plugin 'ROCKSDB' init function returned error. 2019-01-10 18:37:54 0 [ERROR] Plugin 'ROCKSDB' registration as a STORAGE ENGINE failed. 2019-01-10 18:37:54 0 [Note] InnoDB: Using Linux native AIO 2019-01-10 18:37:54 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2019-01-10 18:37:54 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-01-10 18:37:54 0 [Note] InnoDB: Uses event mutexes 2019-01-10 18:37:54 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2019-01-10 18:37:54 0 [Note] InnoDB: Number of pools: 1 2019-01-10 18:37:54 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-01-10 18:37:54 0 [Note] mysqld: O_TMPFILE is not supported on /home/travis/logs/vardir/tmp (disabling future attempts) 2019-01-10 18:37:54 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2019-01-10 18:37:54 0 [Note] InnoDB: Completed initialization of buffer pool 2019-01-10 18:37:54 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-01-10 18:37:54 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 50331648 bytes 2019-01-10 18:37:54 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 50331648 bytes 2019-01-10 18:37:54 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2019-01-10 18:37:54 0 [Note] InnoDB: New log files created, LSN=139821 2019-01-10 18:37:54 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-01-10 18:37:54 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-01-10 18:37:54 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-01-10 18:37:54 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-01-10 18:37:54 0 [Note] InnoDB: Waiting for purge to start 2019-01-10 18:37:55 0 [Note] InnoDB: 10.4.2 started; log sequence number 140300; transaction id 21 2019-01-10 18:37:55 0 [Note] InnoDB: Loading buffer pool(s) from /dev/shm/vardir/data/ib_buffer_pool 2019-01-10 18:37:55 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-01-10 18:37:55 0 [Note] InnoDB: Buffer pool(s) load completed at 190110 18:37:55 2019-01-10 18:37:55 0 [Note] Server socket created on IP: '::'. 2019-01-10 18:37:55 0 [Note] Reading of all Master_info entries succeded 2019-01-10 18:37:55 0 [Note] Added new Master_info '' to hash table 2019-01-10 18:37:55 0 [Note] /home/travis/server/10.4/bin/mysqld: ready for connections. Version: '10.4.2-MariaDB-debug-log' socket: '/home/travis/logs/vardir/mysql.sock' port: 19300 Source distribution Killed # 2019-01-10T18:37:56 [2329] Test completed with failure status STATUS_SERVER_CRASHED (101) ^C