diff options
author | Michael Widenius <monty@mariadb.org> | 2019-01-14 15:46:49 +0200 |
---|---|---|
committer | Michael Widenius <monty@mariadb.org> | 2019-01-14 16:18:50 +0200 |
commit | aad0165ceab4fa4e756f5fd473ef9df003a447cb (patch) | |
tree | 1ed8c68e116b67a51b810e6c8b0c6b408ff23708 /mysql-test/main/backup_locks.result | |
parent | 3975e22d55834930be7b1939ae9a5d416fa0905a (diff) | |
download | mariadb-git-aad0165ceab4fa4e756f5fd473ef9df003a447cb.tar.gz |
Added support for BACKUP LOCK / BACKUP UNLOCK
Diffstat (limited to 'mysql-test/main/backup_locks.result')
-rw-r--r-- | mysql-test/main/backup_locks.result | 46 |
1 files changed, 46 insertions, 0 deletions
diff --git a/mysql-test/main/backup_locks.result b/mysql-test/main/backup_locks.result new file mode 100644 index 00000000000..a3a66937cf9 --- /dev/null +++ b/mysql-test/main/backup_locks.result @@ -0,0 +1,46 @@ +# +# Test lock taken +# +BACKUP LOCK test.t1; +SELECT LOCK_MODE, LOCK_TYPE, TABLE_SCHEMA, TABLE_NAME FROM information_schema.metadata_lock_info; +LOCK_MODE LOCK_TYPE TABLE_SCHEMA TABLE_NAME +MDL_SHARED_HIGH_PRIO Table metadata lock test t1 +BACKUP UNLOCK; +SELECT LOCK_MODE, LOCK_TYPE, TABLE_SCHEMA, TABLE_NAME FROM information_schema.metadata_lock_info; +LOCK_MODE LOCK_TYPE TABLE_SCHEMA TABLE_NAME +BACKUP LOCK t1; +SELECT LOCK_MODE, LOCK_TYPE, TABLE_SCHEMA, TABLE_NAME FROM information_schema.metadata_lock_info; +LOCK_MODE LOCK_TYPE TABLE_SCHEMA TABLE_NAME +MDL_SHARED_HIGH_PRIO Table metadata lock test t1 +BACKUP UNLOCK; +BACKUP LOCK non_existing.t1; +SELECT LOCK_MODE, LOCK_TYPE, TABLE_SCHEMA, TABLE_NAME FROM information_schema.metadata_lock_info; +LOCK_MODE LOCK_TYPE TABLE_SCHEMA TABLE_NAME +MDL_SHARED_HIGH_PRIO Table metadata lock non_existing t1 +BACKUP UNLOCK; +# +# Test that backup lock protects against ddl +# +connect con1,localhost,root,,; +connection default; +create table t1 (a int) engine=innodb; +insert into t1 values (1); +backup lock t1; +select * from t1; +a +1 +connection con1; +drop table t1; +connection default; +SELECT LOCK_MODE, LOCK_TYPE, TABLE_SCHEMA, TABLE_NAME FROM information_schema.metadata_lock_info; +LOCK_MODE LOCK_TYPE TABLE_SCHEMA TABLE_NAME +MDL_SHARED_HIGH_PRIO Table metadata lock test t1 +MDL_INTENTION_EXCLUSIVE Schema metadata lock test +select * from t1; +ERROR 40001: Deadlock found when trying to get lock; try restarting transaction +backup unlock; +connection con1; +connection default; +disconnect con1; +show tables; +Tables_in_test |