From 6b2da933592b54616467d08313fcb1d958fc67e4 Mon Sep 17 00:00:00 2001 From: Vladislav Vaintroub Date: Fri, 14 Sep 2018 09:35:18 +0100 Subject: MDEV-17192 Backup with -no-lock should fail, if DDL is detected at the end of backup --- .../suite/mariabackup/nolock_ddl_during_backup_end.test | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100644 mysql-test/suite/mariabackup/nolock_ddl_during_backup_end.test (limited to 'mysql-test/suite/mariabackup/nolock_ddl_during_backup_end.test') diff --git a/mysql-test/suite/mariabackup/nolock_ddl_during_backup_end.test b/mysql-test/suite/mariabackup/nolock_ddl_during_backup_end.test new file mode 100644 index 00000000000..f6bc51bd9a6 --- /dev/null +++ b/mysql-test/suite/mariabackup/nolock_ddl_during_backup_end.test @@ -0,0 +1,14 @@ +--source include/have_debug.inc +let $targetdir=$MYSQLTEST_VARDIR/tmp/backup; +mkdir $targetdir; + +CREATE TABLE t1(i int) ENGINE=INNODB; + +# this will table and populate it, after backup has list of tables to be copied +--let backup_fix_ddl=BEGIN NOT ATOMIC DROP TABLE test.t1;DO SLEEP(10000); END +echo # xtrabackup backup; +--disable_result_log +error 1; +exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --target-dir=$targetdir --no-lock --dbug=+d,mariabackup_events; +--enable_result_log +rmdir $targetdir; -- cgit v1.2.1