--source include/have_innodb.inc --source include/have_sequence.inc call mtr.add_suppression("InnoDB: New log files created"); let $basedir=$MYSQLTEST_VARDIR/tmp/backup; let $incremental_dir=$MYSQLTEST_VARDIR/tmp/backup_inc1; CREATE TABLE t(a varchar(60)) ENGINE INNODB; start transaction; INSERT INTO t VALUES(1); --disable_result_log exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --target-dir=$basedir; --enable_result_log start transaction; INSERT INTO t select uuid() from seq_1_to_100000; # SELECT * FROM t; exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --ftwrl-wait-timeout=5 --ftwrl-wait-threshold=300 --ftwrl-wait-query-type=all --target-dir=$incremental_dir --incremental-basedir=$basedir ; # --disable_result_log exec $XTRABACKUP --prepare --apply-log-only --target-dir=$basedir ; # exec ls -lRa $MYSQLTEST_VARDIR; # exec grep -r 'must be rolled back' $MYSQLTEST_VARDIR; let SEARCH_FILE=$MYSQLTEST_VARDIR/log/current_test ; --let SEARCH_PATTERN= Rollback of trx with id --source include/search_pattern_in_file.inc --echo # expect NOT FOUND exec $XTRABACKUP --prepare --apply-log-only --target-dir=$basedir --incremental-dir=$incremental_dir ; let SEARCH_FILE=$MYSQLTEST_VARDIR/log/current_test ; --let SEARCH_PATTERN= Rollback of trx with id --source include/search_pattern_in_file.inc --echo # expect NOT FOUND echo # Restore and check results; let $targetdir=$basedir; -- source include/restart_and_restore.inc # --enable_result_log SELECT count(*) FROM t; DROP TABLE t; # Cleanup rmdir $basedir;