diff options
| author | Konstantin Osipov <kostja@sun.com> | 2009-11-20 23:12:57 +0300 |
|---|---|---|
| committer | Konstantin Osipov <kostja@sun.com> | 2009-11-20 23:12:57 +0300 |
| commit | 98c4476b49b19a289ec61a645a22deea8c4ef8ee (patch) | |
| tree | b940e278253479fe87cee00334311b7226a75a1b /mysql-test/r/lock_multi.result | |
| parent | 1b34d593b5f981b523fdc8e923e2c2eb0da75a31 (diff) | |
| download | mariadb-git-98c4476b49b19a289ec61a645a22deea8c4ef8ee.tar.gz | |
Backport of:
------------------------------------------------------------
revno: 2476.1116.1
committer: davi@mysql.com/endora.local
timestamp: Fri 2007-12-14 10:10:19 -0200
message:
DROP TABLE under LOCK TABLES simultaneous to a FLUSH TABLES
WITH READ LOCK (global read lock) can lead to a deadlock.
The solution is to not wait for the global read lock if the
thread is holding any locked tables.
Related to bugs 23713 and 32395. This issues is being fixed
only on 6.0 because it depends on the fix for bug 25858 --
which was fixed only on 6.0.
Diffstat (limited to 'mysql-test/r/lock_multi.result')
| -rw-r--r-- | mysql-test/r/lock_multi.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/lock_multi.result b/mysql-test/r/lock_multi.result index 49e51631b91..3f1165fd069 100644 --- a/mysql-test/r/lock_multi.result +++ b/mysql-test/r/lock_multi.result @@ -210,3 +210,12 @@ select @tlwa < @tlwb; @tlwa < @tlwb 1 End of 5.1 tests +drop table if exists t1; +create table t1 (i int); +connection: default +lock tables t1 write; +connection: flush +flush tables with read lock;; +connection: default +flush tables; +drop table t1; |