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/13893 #13893: INSERTION BLOCKED (WITH TRIGGER) MEANWHILE A BIG SELECT ON THE TABLE IS RUNNING http://bugs.mysql.com/bug.php?id=13893 Submitted by: ANGEL MARTIN
Category: Server: Locking
Status: Duplicate
Severity: 1
OS: Windows (WINXP/Linux)
Version: 5.0.13/5.0.16 BK source
]]> Mon, 10 Oct 2005 10:59:45 +0000 Server: Locking http://bugs.mysql.com/24144 #24144: strange transactional behaviour: DROP TABLE drops also locks http://bugs.mysql.com/bug.php?id=24144 Submitted by: Matthias Leich
Category: Server: Locking
Status: Duplicate
Severity: 2
OS: Linux (Linux)
Version: 5.1-BK
]]> Thu, 09 Nov 2006 14:20:26 +0000 Server: Locking http://bugs.mysql.com/25180 #25180: Sub-select fails when table is locked http://bugs.mysql.com/bug.php?id=25180 Submitted by: Karl Lloyd
Category: Server: Locking
Status: Duplicate
Severity: 3
OS: Linux (Linux, ubuntu 6.06.2)
Version: 5.0.34-BK, 5.0.22
]]> Tue, 19 Dec 2006 15:45:16 +0000 Server: Locking http://bugs.mysql.com/25820 #25820: CPU pegged at 100% after optimizing table belonging to merge set http://bugs.mysql.com/bug.php?id=25820 Submitted by: Shane Bester
Category: Server: Locking
Status: Duplicate
Severity: 3
OS: Any (*)
Version: 5.0.36BK
]]> Wed, 24 Jan 2007 11:15:21 +0000 Server: Locking http://bugs.mysql.com/26240 #26240: Creating a trigger on a locked table hangs the session http://bugs.mysql.com/bug.php?id=26240 Submitted by: Giuseppe Maxia
Category: Server: Locking
Status: Duplicate
Severity: 2
OS: Linux (Linux, Mac OS X)
Version: 5.0.36,5.1.15
]]> Fri, 09 Feb 2007 21:42:56 +0000 Server: Locking http://bugs.mysql.com/29334 #29334: pseudo-finished SHOW GLOBAL STATUS http://bugs.mysql.com/bug.php?id=29334 Submitted by: Victoria Reznichenko
Category: Server: Locking
Status: Duplicate
Severity: 2
OS: Any
Version: 5.1.20
]]> Mon, 25 Jun 2007 11:04:44 +0000 Server: Locking http://bugs.mysql.com/29393 #29393: MySQL Server is locked because of a "flush query cache" on heavy load http://bugs.mysql.com/bug.php?id=29393 Submitted by: Frédéric Dhieux
Category: Server: Locking
Status: Duplicate
Severity: 1
OS: Linux (X86_64 binary)
Version: 5.0.41
]]> Wed, 27 Jun 2007 16:07:42 +0000 Server: Locking http://bugs.mysql.com/34502 #34502: mysqladmin debug causes a crash when server is creating/dropping many tmp tables http://bugs.mysql.com/bug.php?id=34502 Submitted by: Shane Bester
Category: Server: Locking
Status: Duplicate
Severity: 3
OS: Any
Version: 5.1.23-debug, 5.1.24, 5.1.30
]]> Tue, 12 Feb 2008 22:03:59 +0000 Server: Locking http://bugs.mysql.com/37731 #37731: Stored Function and Trigger should be No Pre-Locking with RBR or non-binlog http://bugs.mysql.com/bug.php?id=37731 Submitted by: Akiko Yonemura
Category: Server: Locking
Status: Duplicate
Severity: 3
OS: Any
Version: 5.1
]]> Mon, 30 Jun 2008 03:06:47 +0000 Server: Locking http://bugs.mysql.com/37963 #37963: all threads wait in 'opening tables' or 'closing tables' status on mutex/lock http://bugs.mysql.com/bug.php?id=37963 Submitted by: Shane Bester
Category: Server: Locking
Status: Duplicate
Severity: 2
OS: Any
Version: 5.x
]]> Tue, 08 Jul 2008 11:06:40 +0000 Server: Locking http://bugs.mysql.com/37998 #37998: Lock doesn't allow to copy data from general_log to another table http://bugs.mysql.com/bug.php?id=37998 Submitted by: Markus Popp
Category: Server: Locking
Status: Duplicate
Severity: 3
OS: Any
Version: 5.1.25
]]> Wed, 09 Jul 2008 17:38:30 +0000 Server: Locking http://bugs.mysql.com/40473 #40473: SET GLOBAL read_only=0|1 performs an unnecessary FLUSH TABLES WITH READ LOCK http://bugs.mysql.com/bug.php?id=40473 Submitted by: Pascal Hofmann
Category: Server: Locking
Status: Duplicate
Severity: 3
OS: Any
Version: 5.1.29, 5.1, 6.0 bzr
]]> Sun, 02 Nov 2008 10:50:49 +0000 Server: Locking http://bugs.mysql.com/40842 #40842: Serious freeze in Mysql 5.1.x versions http://bugs.mysql.com/bug.php?id=40842 Submitted by: Jerry Potokar
Category: Server: Locking
Status: Duplicate
Severity: 1
OS: Windows (windows server 2003)
Version: 5.1.x
]]> Wed, 19 Nov 2008 08:50:52 +0000 Server: Locking http://bugs.mysql.com/41802 #41802: SP with multitable update with derived table + flush tables crashes server http://bugs.mysql.com/bug.php?id=41802 Submitted by: Shane Bester
Category: Server: Locking
Status: Duplicate
Severity: 1
OS: Any
Version: 5.0.74,5.1.25, 5.1.26,5.1.30
]]> Wed, 31 Dec 2008 07:00:09 +0000 Server: Locking http://bugs.mysql.com/43160 #43160: InnoDB uses X locks when S locks would work in DML subqueries http://bugs.mysql.com/bug.php?id=43160 Submitted by: Harrison Fisk
Category: Server: Locking
Status: Duplicate
Severity: 3
OS: Any
Version: 5.0.72, 5.1.31
]]> Tue, 24 Feb 2009 21:45:57 +0000 Server: Locking http://bugs.mysql.com/43591 #43591: Deadlock on concurrent inserts results in "Lock wait timeout" for other tables http://bugs.mysql.com/bug.php?id=43591 Submitted by: Igor Usoltsev
Category: Server: Locking
Status: Duplicate
Severity: 5
OS: Linux (2.6.27-11 SMP x86_64 GNU/Linux)
Version: 5.0.67
]]> Thu, 12 Mar 2009 12:00:04 +0000 Server: Locking http://bugs.mysql.com/44693 #44693: MYSQL Daemon hangs when rotating and deleting binlogs http://bugs.mysql.com/bug.php?id=44693 Submitted by: Etienne SAmmut
Category: Server: Locking
Status: Duplicate
Severity: 2
OS: Linux (Centos 4.4)
Version: mysql-5.1.31
]]> Wed, 06 May 2009 13:11:52 +0000 Server: Locking http://bugs.mysql.com/45210 #45210: Combination of procedures, flush tables and autocommit crashes the mysql server http://bugs.mysql.com/bug.php?id=45210 Submitted by: Hema Sridharan
Category: Server: Locking
Status: Duplicate
Severity: 3
OS: Linux
Version: 5.4.4, mysql-6.0-backup, 6.0, azalea
]]> Sat, 30 May 2009 23:00:04 +0000 Server: Locking http://bugs.mysql.com/45536 #45536: ORDER BY RANDOM HANGS UP QUERRIES http://bugs.mysql.com/bug.php?id=45536 Submitted by: Bugs System
Category: Server: Locking
Status: Duplicate
Severity: 3
OS: Solaris (Solais 10 u6)
Version: 5.0.67 5.1.31 5.1.35
]]> Tue, 16 Jun 2009 18:02:34 +0000 Server: Locking http://bugs.mysql.com/45643 #45643: Server crash due to gap locking mechanism http://bugs.mysql.com/bug.php?id=45643 Submitted by: Joao de Araujo
Category: Server: Locking
Status: Duplicate
Severity: 2
OS: Windows (Windows Server 2008)
Version: 5.1.35
]]> Mon, 22 Jun 2009 03:20:31 +0000 Server: Locking http://bugs.mysql.com/46321 #46321: Deadlock in tdc_wait_for_old_versions() on non-concurrent DDL on partitions http://bugs.mysql.com/bug.php?id=46321 Submitted by: Philip Stoev
Category: Server: Locking
Status: Duplicate
Severity: 2
OS: Any
Version: 5.4
]]> Tue, 21 Jul 2009 12:38:10 +0000 Server: Locking http://bugs.mysql.com/47024 #47024: server hangs on FLUSH TABLES WITH READ LOCK or UNLOCK TABLES http://bugs.mysql.com/bug.php?id=47024 Submitted by: Matthias Leich
Category: Server: Locking
Status: Duplicate
Severity: 3
OS: Any
Version: 5.4
]]> Mon, 31 Aug 2009 15:31:34 +0000 Server: Locking http://bugs.mysql.com/47770 #47770: 100% CPU loop in the MDL_context::wait_for_locks hash http://bugs.mysql.com/bug.php?id=47770 Submitted by: Philip Stoev
Category: Server: Locking
Status: Duplicate
Severity: 3
OS: Any
Version: 6.0
]]> Thu, 01 Oct 2009 17:46:38 +0000 Server: Locking http://bugs.mysql.com/48155 #48155: assert in handler::ha_external_lock http://bugs.mysql.com/bug.php?id=48155 Submitted by: Matthias Leich
Category: Server: Locking
Status: Duplicate
Severity: 3
OS: Any
Version: mysql-6.0-codebase-bugfixing
]]> Mon, 19 Oct 2009 16:31:57 +0000 Server: Locking http://bugs.mysql.com/48747 #48747: Segmentation fault due to MDL in 5.1-rep+3 http://bugs.mysql.com/bug.php?id=48747 Submitted by: Alfranio Tavares Correia Junior
Category: Server: Locking
Status: Duplicate
Severity: 2
OS: Any
Version: 5.1-rep+3
]]> Fri, 13 Nov 2009 01:10:59 +0000 Server: Locking http://bugs.mysql.com/49493 #49493: assertion !table->file || table->file->inited == handler::NONE on DDL workload http://bugs.mysql.com/bug.php?id=49493 Submitted by: Philip Stoev
Category: Server: Locking
Status: Duplicate
Severity: 3
OS: Any
Version: 6.0-codebase-bugfixing
]]> Mon, 07 Dec 2009 09:20:46 +0000 Server: Locking http://bugs.mysql.com/49730 #49730: During Fast Index creation mysql client is locked http://bugs.mysql.com/bug.php?id=49730 Submitted by: Vadim TKACHENKO
Category: Server: Locking
Status: Duplicate
Severity: 2
OS: Any
Version: 5.1.47 + plugin 1.0.8, 5.5.5, 5.6.99
]]> Wed, 16 Dec 2009 06:09:57 +0000 Server: Locking http://bugs.mysql.com/50406 #50406: Deadlock around system variables and the fill_status() function http://bugs.mysql.com/bug.php?id=50406 Submitted by: Philip Stoev
Category: Server: Locking
Status: Duplicate
Severity: 1
OS: Any
Version: next-mr, 6.0-codebase-bugfixing
]]> Mon, 18 Jan 2010 10:26:44 +0000 Server: Locking http://bugs.mysql.com/51449 #51449: Deadlock between INSERT and ALTER TABLE ... MODIFY ... CHARACTER SET http://bugs.mysql.com/bug.php?id=51449 Submitted by: Elena Stepanova
Category: Server: Locking
Status: Duplicate
Severity: 2
OS: Windows
Version: Celosia (M3)
]]> Wed, 24 Feb 2010 08:19:50 +0000 Server: Locking http://bugs.mysql.com/53627 #53627: Mysql randomly crashing in read_view_sees_trx_id http://bugs.mysql.com/bug.php?id=53627 Submitted by: Jonatas Cruz
Category: Server: Locking
Status: Duplicate
Severity: 1
OS: Any (RedHat 5.3 x64, Mac OS X, Windows)
Version: >=5.1.34, 5.1.46, 5.1.48-bzr
]]> Thu, 13 May 2010 18:46:38 +0000 Server: Locking