diff options
author | Rinat Ibragimov <ri@tempesta-tech.com> | 2020-10-21 23:34:36 +0300 |
---|---|---|
committer | Monty <monty@mariadb.org> | 2020-10-22 00:18:33 +0300 |
commit | 709ba7dcae871e365697f67677c908b55ad4a964 (patch) | |
tree | dde2860dddbc468d6f1a4484b8e109baff7226a5 /mysql-test/main/implicit_commit.test | |
parent | ac8d20579512e05001f9bf8193187e47c870d35a (diff) | |
download | mariadb-git-709ba7dcae871e365697f67677c908b55ad4a964.tar.gz |
MDEV-20945: BACKUP UNLOCK + FTWRL assertion failure
MDEV-20945: BACKUP UNLOCK + FTWRL assertion failure | SIGSEGV in I_P_List
from MDL_context::release_lock on INSERT w/ BACKUP LOCK (on optimized
builds) | Assertion `ticket->m_duration == MDL_EXPLICIT' failed
BACKUP LOCK behavior is modified so it won't be used wrong:
- BACKUP LOCK should commit any active transactions.
- BACKUP LOCK should not be allowed in stored procedures.
- When BACKUP LOCK is active, don't allow any DDL's for that connection.
- FTWRL is forbidden on the same connection while BACKUP LOCK is active.
Reviewed-by: monty@mariadb.com
Diffstat (limited to 'mysql-test/main/implicit_commit.test')
-rw-r--r-- | mysql-test/main/implicit_commit.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/main/implicit_commit.test b/mysql-test/main/implicit_commit.test index bcc43865395..09f2e2e921e 100644 --- a/mysql-test/main/implicit_commit.test +++ b/mysql-test/main/implicit_commit.test @@ -1115,6 +1115,16 @@ source include/implicit_commit_helper.inc; #source include/implicit_commit_helper.inc; --echo # +--echo # SQLCOM_BACKUP_LOCK +--echo # + +INSERT INTO db1.trans VALUES (1); +BACKUP LOCK t1; +ROLLBACK; +BACKUP UNLOCK; +CALL db1.test_if_commit(); + +--echo # --echo # SQLCOM_SHOW_ARCHIVE --echo # |