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/24922 #24922: Question about locking with mysqldump http://bugs.mysql.com/bug.php?id=24922 Submitted by: Lorraine Gray
Category: Server: Locking
Status: Not a Bug
Severity: 3
OS: Linux (Linux 2.6.13-1.1532_FC4T)
Version: 5.0.18-pro
]]> Fri, 08 Dec 2006 18:03:24 +0000 Server: Locking http://bugs.mysql.com/27459 #27459: Unknown system variable 'skip_external_locking' http://bugs.mysql.com/bug.php?id=27459 Submitted by: Eric Fox
Category: Server: Locking
Status: Not a Bug
Severity: 3
OS: Linux (Linux)
Version: 5.0.37-community
]]> Mon, 26 Mar 2007 23:15:08 +0000 Server: Locking http://bugs.mysql.com/28345 #28345: Queries in Locked state http://bugs.mysql.com/bug.php?id=28345 Submitted by: Pradeep Thiyag
Category: Server: Locking
Status: Not a Bug
Severity: 1
OS: Solaris (5.8)
Version: 4.1.22
]]> Thu, 10 May 2007 05:40:50 +0000 Server: Locking http://bugs.mysql.com/31080 #31080: LOCK TABLES + subqueries: Table 'test' was not locked with LOCK TABLES http://bugs.mysql.com/bug.php?id=31080 Submitted by: Martin Huber
Category: Server: Locking
Status: Not a Bug
Severity: 3
OS: Windows (2000 Server)
Version: 5.0.45
]]> Tue, 18 Sep 2007 14:12:59 +0000 Server: Locking http://bugs.mysql.com/31175 #31175: SELECT ... FOR UPDATE does not block http://bugs.mysql.com/bug.php?id=31175 Submitted by: Hakan Küçükyılmaz
Category: Server: Locking
Status: Not a Bug
Severity: 2
OS: Linux (64-bit)
Version: 5.1.23, 6.0.3
]]> Mon, 24 Sep 2007 13:17:59 +0000 Server: Locking http://bugs.mysql.com/32210 #32210: Deadlock when inserting into an InnoDB table and select from it at the same time http://bugs.mysql.com/bug.php?id=32210 Submitted by: Safari -
Category: Server: Locking
Status: Not a Bug
Severity: 2
OS: Linux (CentOS 5.0 x86_64)
Version: 5.0.22
]]> Fri, 09 Nov 2007 03:30:15 +0000 Server: Locking http://bugs.mysql.com/35425 #35425: Row level lock is preventing new rows being inserted in read-uncommitted mode http://bugs.mysql.com/bug.php?id=35425 Submitted by: Rizwan Maredia
Category: Server: Locking
Status: Not a Bug
Severity: 2
OS: Windows
Version: 5.1.22
]]> Wed, 19 Mar 2008 07:45:29 +0000 Server: Locking http://bugs.mysql.com/37593 #37593: read-uncommitted mode causes locks on selected rows during insert...select http://bugs.mysql.com/bug.php?id=37593 Submitted by: Gordon Shannon
Category: Server: Locking
Status: Not a Bug
Severity: 3
OS: Linux
Version: 5.1.24-rc-community-log
]]> Mon, 23 Jun 2008 20:02:07 +0000 Server: Locking http://bugs.mysql.com/38870 #38870: deadlocked threads with myisam table http://bugs.mysql.com/bug.php?id=38870 Submitted by: Shane Bester
Category: Server: Locking
Status: Not a Bug
Severity: 3
OS: Any
Version: 5.1.26, 5.1.28, 5.1.29
]]> Mon, 18 Aug 2008 18:16:02 +0000 Server: Locking http://bugs.mysql.com/39358 #39358: Concurrency locks causes deadlocks http://bugs.mysql.com/bug.php?id=39358 Submitted by: Julien B
Category: Server: Locking
Status: Not a Bug
Severity: 3
OS: Any
Version: 5.0.51-log
]]> Wed, 10 Sep 2008 05:38:05 +0000 Server: Locking http://bugs.mysql.com/40737 #40737: Lock wait timeout exceeded during inserting row http://bugs.mysql.com/bug.php?id=40737 Submitted by: NOT_FOUND NOT_FOUND
Category: Server: Locking
Status: Not a Bug
Severity: 2
OS: Any
Version: 5.0.67
]]> Fri, 14 Nov 2008 12:14:21 +0000 Server: Locking http://bugs.mysql.com/41667 #41667: Lock wait timeout exceeded when updating a row in a reference table http://bugs.mysql.com/bug.php?id=41667 Submitted by: Edrick Duero
Category: Server: Locking
Status: Not a Bug
Severity: 3
OS: Windows (XP SP3)
Version: 5.0.67
]]> Mon, 22 Dec 2008 01:54:12 +0000 Server: Locking http://bugs.mysql.com/42243 #42243: LOAD DATA CONCURRENT INFILE locks table even when concurrent_insert = 2 http://bugs.mysql.com/bug.php?id=42243 Submitted by: Bogdan Kecman
Category: Server: Locking
Status: Not a Bug
Severity: 2
OS: Any
Version: 5.1.30
]]> Wed, 21 Jan 2009 15:30:21 +0000 Server: Locking http://bugs.mysql.com/43073 #43073: START TRANSACTION and COMMIT do NOT change AUTOCOMMIT http://bugs.mysql.com/bug.php?id=43073 Submitted by: al baker
Category: Server: Locking
Status: Not a Bug
Severity: 2
OS: Other
Version: 5.0.32-Debian_7etch1-log
]]> Sat, 21 Feb 2009 07:07:51 +0000 Server: Locking http://bugs.mysql.com/43211 #43211: Deadlock detected on concurrent delete/insert into same table http://bugs.mysql.com/bug.php?id=43211 Submitted by: Royce Lithgo
Category: Server: Locking
Status: Not a Bug
Severity: 2
OS: Linux
Version: 5.0.51a-community-log
]]> Thu, 26 Feb 2009 07:14:51 +0000 Server: Locking http://bugs.mysql.com/43700 #43700: dead lock after insert inside transaction http://bugs.mysql.com/bug.php?id=43700 Submitted by: Alexandr Nikulin
Category: Server: Locking
Status: Not a Bug
Severity: 3
OS: Any (ubuntu)
Version: Ver 14.12 Distrib 5.0.54
]]> Tue, 17 Mar 2009 13:27:04 +0000 Server: Locking http://bugs.mysql.com/43722 #43722: Rows inserted into one transaction are not accessible in another http://bugs.mysql.com/bug.php?id=43722 Submitted by: Alexandr Nikulin
Category: Server: Locking
Status: Not a Bug
Severity: 3
OS: Linux (Ubuntu)
Version: Ver 14.12 Distrib 5.0.54
]]> Wed, 18 Mar 2009 08:02:18 +0000 Server: Locking http://bugs.mysql.com/44277 #44277: Abort (Ctrl+C) via mysql client can't free some locks in transaction http://bugs.mysql.com/bug.php?id=44277 Submitted by: rancpine cui
Category: Server: Locking
Status: Not a Bug
Severity: 2
OS: Linux
Version: 5.1.32
]]> Wed, 15 Apr 2009 02:56:49 +0000 Server: Locking http://bugs.mysql.com/44618 #44618: HIGH_PRIORITY/LOW_PRIORITY don't work http://bugs.mysql.com/bug.php?id=44618 Submitted by: Chris Bolt
Category: Server: Locking
Status: Not a Bug
Severity: 3
OS: Linux
Version: 5.0.75, 5.1 bzr
]]> Fri, 01 May 2009 22:12:36 +0000 Server: Locking http://bugs.mysql.com/44942 #44942: innodb_lock_wait_timeout sums up on concurrent mixed txn/non-txn queries http://bugs.mysql.com/bug.php?id=44942 Submitted by: Elena Stepanova
Category: Server: Locking
Status: Not a Bug
Severity: 3
OS: Any
Version: 5.0.81, 5.1.34, 5.0, 5.1, 6.0 bzr
]]> Tue, 19 May 2009 00:22:03 +0000 Server: Locking http://bugs.mysql.com/45107 #45107: Threads locked in "Freeing Items" state even without query cache http://bugs.mysql.com/bug.php?id=45107 Submitted by: Devon Weller
Category: Server: Locking
Status: Not a Bug
Severity: 2
OS: Linux (Centos 5.2)
Version: 5.1.34
]]> Tue, 26 May 2009 21:17:28 +0000 Server: Locking http://bugs.mysql.com/47295 #47295: Locked a record that shouldn't be such http://bugs.mysql.com/bug.php?id=47295 Submitted by: Saverio Miroddi
Category: Server: Locking
Status: Not a Bug
Severity: 3
OS: Any
Version: 5.1.31-1ubuntu2
]]> Sun, 13 Sep 2009 14:00:57 +0000 Server: Locking http://bugs.mysql.com/48128 #48128: unexpected lock timeout while selecting from innodb table http://bugs.mysql.com/bug.php?id=48128 Submitted by: A Ramos
Category: Server: Locking
Status: Not a Bug
Severity: 5
OS: Linux (Ubuntu build)
Version: 5.0.67
]]> Sat, 17 Oct 2009 05:18:33 +0000 Server: Locking http://bugs.mysql.com/50396 #50396: Deadlock between DROP DATABASE (mysql_rm_table_part2) and SELECT http://bugs.mysql.com/bug.php?id=50396 Submitted by: Philip Stoev
Category: Server: Locking
Status: Not a Bug
Severity: 2
OS: Any
Version: mysql-next-4284, 6.0-backup, backup-backport
]]> Sun, 17 Jan 2010 13:30:26 +0000 Server: Locking http://bugs.mysql.com/51086 #51086: last deadlock detected not showing a valid reason for the deadlock http://bugs.mysql.com/bug.php?id=51086 Submitted by: walid bakkar
Category: Server: Locking
Status: Not a Bug
Severity: 2
OS: Linux
Version: 5.0.51a
]]> Thu, 11 Feb 2010 11:11:54 +0000 Server: Locking http://bugs.mysql.com/52296 #52296: LOCK TABLES, if using Subfunction mysql say table was not locked http://bugs.mysql.com/bug.php?id=52296 Submitted by: Richard Teubel
Category: Server: Locking
Status: Not a Bug
Severity: 1
OS: Linux
Version: 5.1.41, 5.1.46-bzr
]]> Tue, 23 Mar 2010 09:21:15 +0000 Server: Locking http://bugs.mysql.com/55065 #55065: LOCK TABLES ... READ does not lock tables used in triggers http://bugs.mysql.com/bug.php?id=55065 Submitted by: Andrew Dalgleish
Category: Server: Locking
Status: Not a Bug
Severity: 3
OS: Any
Version: 5.1
]]> Thu, 08 Jul 2010 02:33:27 +0000 Server: Locking http://bugs.mysql.com/56571 #56571: DROP VIEW is not permitted if the view is locked by LOCK TABLE ... WRITE http://bugs.mysql.com/bug.php?id=56571 Submitted by: Elena Stepanova
Category: Server: Locking
Status: Not a Bug
Severity: 3
OS: Any
Version: 5.5.3-m3, 5.5.6-rc, 5.6.0-m4
]]> Sun, 05 Sep 2010 17:22:17 +0000 Server: Locking http://bugs.mysql.com/57249 #57249: crash in mysql_unlock_tables, sysbench with high number of threads http://bugs.mysql.com/bug.php?id=57249 Submitted by: Mikhail Izioumtchenko
Category: Server: Locking
Status: Not a Bug
Severity: 2
OS: Any
Version: 5.1,5.5
]]> Tue, 05 Oct 2010 13:53:05 +0000 Server: Locking http://bugs.mysql.com/58892 #58892: deadlock http://bugs.mysql.com/bug.php?id=58892 Submitted by: yang wang
Category: Server: Locking
Status: Not a Bug
Severity: 2
OS: Linux
Version: 5,1,47-x86-64
]]> Mon, 13 Dec 2010 06:45:23 +0000 Server: Locking