MySQL Bugs MySQL AB Bugs Database http://bugs.mysql.com/ MySQL Bugs http://bugs.mysql.com/images/mysql_100x52-64.gif http://bugs.mysql.com/ http://bugs.mysql.com/22246 #22246: Allow LOCK TABLE WRITE lock a non-existent table. http://bugs.mysql.com/bug.php?id=22246 Submitted by: Shawn Green
Category: Server: Locking
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 4.1.22, 5.0.45, 5.1.43, 6.0.14
]]> Mon, 11 Sep 2006 21:37:49 +0000 Server: Locking http://bugs.mysql.com/41364 #41364: CHECK TABLE does not work with --external-locking on Windows http://bugs.mysql.com/bug.php?id=41364 Submitted by: Ingo Strüwing
Category: Server: Locking
Status: Verified
Severity: 3
OS: Windows
Version: 6.0 and probably earlier
]]> Wed, 10 Dec 2008 17:26:49 +0000 Server: Locking http://bugs.mysql.com/43197 #43197: mysqldump: table is open on delete - Windows debug build http://bugs.mysql.com/bug.php?id=43197 Submitted by: Ingo Strüwing
Category: Server: Locking
Status: Verified
Severity: 3
OS: Windows
Version: 5.5.18, 6.0
]]> Wed, 25 Feb 2009 16:22:21 +0000 Server: Locking http://bugs.mysql.com/43766 #43766: unnecessary locking on update even with tx_isolation=READ-COMMITTED or http://bugs.mysql.com/bug.php?id=43766 Submitted by: Nishant Deshpande
Category: Server: Locking
Status: Verified
Severity: 3
OS: Linux
Version: 5.1.25, 5.1.31, 4.1, 5.0, 5.1, 6.0 bzr
]]> Fri, 20 Mar 2009 10:19:12 +0000 Server: Locking http://bugs.mysql.com/44884 #44884: KILL of FLUSH TABLES does not remove TDC version lock on tables in use http://bugs.mysql.com/bug.php?id=44884 Submitted by: Shawn Green
Category: Server: Locking
Status: Verified
Severity: 3
OS: Any
Version: 5.0.51a,5.0.66a,5.1.31sp1
]]> Thu, 14 May 2009 18:50:37 +0000 Server: Locking http://bugs.mysql.com/47938 #47938: "grant update on view" does not initialize the table_list lock_type. http://bugs.mysql.com/bug.php?id=47938 Submitted by: Lars-Erik Bjørk
Category: Server: Locking
Status: Verified
Severity: 3
OS: Any
Version: 6.0.14-alpha
]]> Fri, 09 Oct 2009 09:13:35 +0000 Server: Locking http://bugs.mysql.com/53045 #53045: LOCK_thread_count locked when per connection threads created http://bugs.mysql.com/bug.php?id=53045 Submitted by: Mark Callaghan
Category: Server: Locking
Status: Verified
Severity: 5
OS: Any
Version: 5.1.45, 5.5
]]> Thu, 22 Apr 2010 04:58:26 +0000 Server: Locking http://bugs.mysql.com/56764 #56764: if clause causes unnecessary locking http://bugs.mysql.com/bug.php?id=56764 Submitted by: Michael Skulsky
Category: Server: Locking
Status: Verified
Severity: 2
OS: Linux
Version: 5.0.91, 5.1.39, 5.1.50, 5.5.7
]]> Tue, 14 Sep 2010 07:42:35 +0000 Server: Locking http://bugs.mysql.com/57118 #57118: Undetected deadlock with select for update on a InnoDB + MyISAM join http://bugs.mysql.com/bug.php?id=57118 Submitted by: Andrew Pimlott
Category: Server: Locking
Status: Verified
Severity: 3
OS: Any
Version: 5.1.49, 5.1.52-bzr
]]> Thu, 30 Sep 2010 00:51:04 +0000 Server: Locking http://bugs.mysql.com/58618 #58618: Warning: found too many locks at read: read lock with no write locks http://bugs.mysql.com/bug.php?id=58618 Submitted by: Shane Bester
Category: Server: Locking
Status: Verified
Severity: 3
OS: Any
Version: 5.1.55-debug,5.5.9-debug
]]> Wed, 01 Dec 2010 04:52:59 +0000 Server: Locking http://bugs.mysql.com/58787 #58787: InnoDB enforcing order of DDL and DML in binary log? http://bugs.mysql.com/bug.php?id=58787 Submitted by: Matthew Lord
Category: Server: Locking
Status: Verified
Severity: 1
OS: Any
]]> Tue, 07 Dec 2010 15:18:21 +0000 Server: Locking http://bugs.mysql.com/59663 #59663: Error 11 - can't unlock file when using external_locking http://bugs.mysql.com/bug.php?id=59663 Submitted by: Peter Laursen
Category: Server: Locking
Status: Verified
Severity: 2
OS: Windows (7/64 - 64 bit server)
Version: 5.1.54
]]> Fri, 21 Jan 2011 17:05:32 +0000 Server: Locking http://bugs.mysql.com/59999 #59999: mysqlhotcopy returns error and crashes debug server http://bugs.mysql.com/bug.php?id=59999 Submitted by: Sveta Smirnova
Category: Server: Locking
Status: Verified
Severity: 3
OS: Any
Version: 5.5, 5.6.2
]]> Mon, 07 Feb 2011 21:11:02 +0000 Server: Locking http://bugs.mysql.com/60951 #60951: DELETE statement locks http://bugs.mysql.com/bug.php?id=60951 Submitted by: Vinod Sugur
Category: Server: Locking
Status: Verified
Severity: 2
OS: Any
Version: 5.1.55-community-log, 5.1.59, 5.6.3
]]> Fri, 22 Apr 2011 11:21:11 +0000 Server: Locking http://bugs.mysql.com/62286 #62286: call multiple accepts per poll http://bugs.mysql.com/bug.php?id=62286 Submitted by: Domas Mituzas
Category: Server: Locking
Status: Verified
Severity: 5
OS: Any
Version: 5.1, 5.5, ...
]]> Sun, 28 Aug 2011 22:02:51 +0000 Server: Locking http://bugs.mysql.com/62287 #62287: don't serialize thread cache http://bugs.mysql.com/bug.php?id=62287 Submitted by: Domas Mituzas
Category: Server: Locking
Status: Verified
Severity: 3
OS: Any
Version: 5.1, 5.5
]]> Sun, 28 Aug 2011 22:07:41 +0000 Server: Locking http://bugs.mysql.com/64814 #64814: Inconsistent error when concurrently dropping table and trigger http://bugs.mysql.com/bug.php?id=64814 Submitted by: Pedro Fonseca
Category: Server: Locking
Status: Verified
Severity: 3
OS: Any
Version: 5.5.19
]]> Fri, 30 Mar 2012 12:26:06 +0000 Server: Locking http://bugs.mysql.com/67924 #67924: Row lock isn't released after evaluating WHERE condition in READ COMMITTED http://bugs.mysql.com/bug.php?id=67924 Submitted by: Vitaly Litvak
Category: Server: Locking
Status: Verified
Severity: 2
OS: Linux
Version: 5.1.59, 5.5.24
]]> Mon, 17 Dec 2012 15:01:51 +0000 Server: Locking http://bugs.mysql.com/71055 #71055: Using IF EXISTS(SELECT * ...) acquires a lock when using read uncommitted http://bugs.mysql.com/bug.php?id=71055 Submitted by: Yoseph Phillips
Category: Server: Locking
Status: Verified
Severity: 2
OS: Windows
Version: 5.5.12, 5.5.35, 5.6.16
]]> Tue, 03 Dec 2013 05:18:20 +0000 Server: Locking http://bugs.mysql.com/71060 #71060: INSERT-SELECT statement takes shared locks in trigger and causes deadlock http://bugs.mysql.com/bug.php?id=71060 Submitted by: Sadao Hiratsuka
Category: Server: Locking
Status: Verified
Severity: 2
OS: Any
Version: 5.6.15, 5.6.16, 5.5.35, 5.1.74
]]> Tue, 03 Dec 2013 14:08:29 +0000 Server: Locking http://bugs.mysql.com/71110 #71110: "create temporary table select * from table" does not produce consistent data http://bugs.mysql.com/bug.php?id=71110 Submitted by: Toni Sanavullah
Category: Server: Locking
Status: Verified
Severity: 2
OS: Linux
Version: mysql-5.6.14
]]> Sun, 08 Dec 2013 16:31:14 +0000 Server: Locking http://bugs.mysql.com/71214 #71214: WITH CONSISTENT SNAPSHOT doesn't isolate from concurrent RENAME TABLE http://bugs.mysql.com/bug.php?id=71214 Submitted by: Dmitry Lenev
Category: Server: Locking
Status: Verified
Severity: 3
OS: Any
Version: 5.6.16
]]> Mon, 23 Dec 2013 10:47:36 +0000 Server: Locking http://bugs.mysql.com/71215 #71215: WITH CONSISTENT SNAPSHOT doesn't isolate from some concurrent ALTER TABLEs http://bugs.mysql.com/bug.php?id=71215 Submitted by: Dmitry Lenev
Category: Server: Locking
Status: Verified
Severity: 3
OS: Any
Version: 5.6.16-bzr
]]> Mon, 23 Dec 2013 10:57:37 +0000 Server: Locking http://bugs.mysql.com/71216 #71216: WITH CONSISTENT SNAPSHOT doesn't isolate from concurrent DDL on stored programs http://bugs.mysql.com/bug.php?id=71216 Submitted by: Dmitry Lenev
Category: Server: Locking
Status: Verified
Severity: 3
OS: Any
Version: 5.6.16-bzr
]]> Mon, 23 Dec 2013 11:22:08 +0000 Server: Locking http://bugs.mysql.com/71580 #71580: FLUSH TABLES WITH READ LOCK hangs when many clients run SELECT FOR UPDATE twice http://bugs.mysql.com/bug.php?id=71580 Submitted by: Sadao Hiratsuka
Category: Server: Locking
Status: Verified
Severity: 2
OS: Any
Version: 5.6.16, 5.5.36
]]> Tue, 04 Feb 2014 09:02:09 +0000 Server: Locking http://bugs.mysql.com/73463 #73463: Out of memory error when concurrently write locking tables with triggers http://bugs.mysql.com/bug.php?id=73463 Submitted by: István Rozsnyai
Category: Server: Locking
Status: Verified
Severity: 2
OS: Linux (Centos 5)
Version: 5.5.36, 5.6.21
]]> Mon, 04 Aug 2014 11:37:29 +0000 Server: Locking http://bugs.mysql.com/73666 #73666: DEADLOCK WHEN DDL UNDER LOCK TABLES WRITE, READ LOCAL + PREPARE. http://bugs.mysql.com/bug.php?id=73666 Submitted by: Dmitry Lenev
Category: Server: Locking
Status: Verified
Severity: 3
OS: Any
Version: 5.5.37-bzr, 5.6.21-bzr, 5.7.5-bzr
]]> Thu, 21 Aug 2014 09:09:12 +0000 Server: Locking http://bugs.mysql.com/73803 #73803: don't acquire global_sid_lock->rdlock if gtid is disabled http://bugs.mysql.com/bug.php?id=73803 Submitted by: zhai weixiang
Category: Server: Locking
Status: Verified
Severity: 3
OS: Any
Version: 5.6.20
]]> Thu, 04 Sep 2014 08:40:08 +0000 Server: Locking http://bugs.mysql.com/73829 #73829: Multi-threaded mysqld lockup issue with ~50-55 second timeout http://bugs.mysql.com/bug.php?id=73829 Submitted by: Roel Van de Paar
Category: Server: Locking
Status: Verified
Severity: 1
OS: Any
Version: 5.6, 5.6.21, 5.6.23, 5.7.6
]]> Mon, 08 Sep 2014 05:06:37 +0000 Server: Locking http://bugs.mysql.com/74893 #74893: mdl m_unused_lock_objects shouldn't be volatile http://bugs.mysql.com/bug.php?id=74893 Submitted by: Stewart Smith
Category: Server: Locking
Status: Verified
Severity: 3
OS: Any
Version: 5.7.7
]]> Mon, 17 Nov 2014 07:23:51 +0000 Server: Locking