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/21074 #21074: Large query_cache freezes mysql server sporadically under heavy load http://bugs.mysql.com/bug.php?id=21074 Submitted by: Ananth Reddy
Category: Server: Query Cache
Status: Closed
Severity: 3
OS: Linux (RedHat 4)
Version: 5.0.27, 4.1.19-standard-log
]]> Fri, 14 Jul 2006 23:36:51 +0000 Server: Query Cache http://bugs.mysql.com/30269 #30269: Query cache eats memory http://bugs.mysql.com/bug.php?id=30269 Submitted by: Vadim TKACHENKO
Category: Server: Query Cache
Status: Closed
Severity: 3
OS: Any
Version: 5.0.45
]]> Tue, 07 Aug 2007 07:09:48 +0000 Server: Query Cache http://bugs.mysql.com/30768 #30768: query cache patch for bug #21074 crashes on windows http://bugs.mysql.com/bug.php?id=30768 Submitted by: Shane Bester
Category: Server: Query Cache
Status: Closed
Severity: 3
OS: Windows (xp)
Version: 5.0.50
]]> Mon, 03 Sep 2007 11:55:57 +0000 Server: Query Cache http://bugs.mysql.com/30887 #30887: Server crashes on SET GLOBAL query_cache_size=0 http://bugs.mysql.com/bug.php?id=30887 Submitted by: Kristofer Pettersson
Category: Server: Query Cache
Status: Closed
Severity: 2
OS: Any
Version: 5.1 BK
]]> Fri, 07 Sep 2007 08:29:26 +0000 Server: Query Cache http://bugs.mysql.com/31892 #31892: ON DUPLICATE KEY UPDATE does not refresh query cache. http://bugs.mysql.com/bug.php?id=31892 Submitted by: Devon Yates
Category: Server: Query Cache
Status: Closed
Severity: 3
OS: Windows (Windows 2000 5.00.2195 SP4)
Version: 5.0.37-community-nt-log
]]> Fri, 26 Oct 2007 21:48:36 +0000 Server: Query Cache http://bugs.mysql.com/33362 #33362: Query cache invalidation may hang/crash if cached query uses many tables http://bugs.mysql.com/bug.php?id=33362 Submitted by: Bjorn Julander
Category: Server: Query Cache
Status: Closed
Severity: 2
OS: Any
Version: all
]]> Wed, 19 Dec 2007 10:42:35 +0000 Server: Query Cache http://bugs.mysql.com/33756 #33756: query cache with concurrent_insert=0 appears broken http://bugs.mysql.com/bug.php?id=33756 Submitted by: Sean Pringle
Category: Server: Query Cache
Status: Closed
Severity: 3
OS: Any
Version: 5.0.54, 5.0.50
]]> Wed, 09 Jan 2008 05:10:44 +0000 Server: Query Cache http://bugs.mysql.com/35749 #35749: Test 'query_cache_debug' fails with "Unknown thread id: 0" http://bugs.mysql.com/bug.php?id=35749 Submitted by: Kent Boortz
Category: Server: Query Cache
Status: Closed
Severity: 2
OS: FreeBSD (6.0)
]]> Tue, 01 Apr 2008 17:49:54 +0000 Server: Query Cache http://bugs.mysql.com/36326 #36326: nested transaction and select http://bugs.mysql.com/bug.php?id=36326 Submitted by: Renaud Paquay
Category: Server: Query Cache
Status: Closed
Severity: 3
OS: Windows (Vista)
Version: 5.0.54
]]> Thu, 24 Apr 2008 20:55:46 +0000 Server: Query Cache http://bugs.mysql.com/36892 #36892: Compiler warning on Windows 32-bit http://bugs.mysql.com/bug.php?id=36892 Submitted by: Hakan Küçükyılmaz
Category: Server: Query Cache
Status: Closed
Severity: 3
OS: Windows (32-bit)
Version: 6.0-bk
]]> Thu, 22 May 2008 19:00:38 +0000 Server: Query Cache http://bugs.mysql.com/37416 #37416: When SQL_NO_CACHE is used, MySQL still lookup into the query cache http://bugs.mysql.com/bug.php?id=37416 Submitted by: jocelyn fournier
Category: Server: Query Cache
Status: Closed
Severity: 5
OS: Any
Version: 5.0.51a,5.1
]]> Sun, 15 Jun 2008 22:56:11 +0000 Server: Query Cache http://bugs.mysql.com/38551 #38551: RBR/MBR + Query Cache + "invalidating query cache entries (table)" => slow slave http://bugs.mysql.com/bug.php?id=38551 Submitted by: Neel Nadgir
Category: Server: Query Cache
Status: Closed
Severity: 5
OS: Any
Version: 5.1, 6.0
]]> Mon, 04 Aug 2008 22:08:50 +0000 Server: Query Cache http://bugs.mysql.com/38692 #38692: concurrent inserts cause valgrind errors in Query_cache::invalidate http://bugs.mysql.com/bug.php?id=38692 Submitted by: Shane Bester
Category: Server: Query Cache
Status: Closed
Severity: 1
OS: Any
Version: 5.1.26, 5.1.28, 6.0.7
]]> Sat, 09 Aug 2008 17:14:00 +0000 Server: Query Cache http://bugs.mysql.com/39253 #39253: Large query cache still freezes server after fix for bug #21074 http://bugs.mysql.com/bug.php?id=39253 Submitted by: Sveta Smirnova
Category: Server: Query Cache
Status: Closed
Severity: 2
OS: Any
Version: 5.1 bzr
]]> Thu, 04 Sep 2008 18:47:10 +0000 Server: Query Cache http://bugs.mysql.com/40264 #40264: Aborted cached query causes query to hang indefinitely on next cache hit http://bugs.mysql.com/bug.php?id=40264 Submitted by: Lucas Madar
Category: Server: Query Cache
Status: Closed
Severity: 2
OS: Any (FreeBSD 7.0-STABLE, MP; Linux)
Version: 5.0.67, 5.0 bzr
]]> Wed, 22 Oct 2008 18:53:31 +0000 Server: Query Cache http://bugs.mysql.com/41098 #41098: Query Cache returns wrong result with concurrent insert http://bugs.mysql.com/bug.php?id=41098 Submitted by: Matthias Leich
Category: Server: Query Cache
Status: Closed
Severity: 3
OS: Any
Version: 5.1,6.0
]]> Fri, 28 Nov 2008 14:33:32 +0000 Server: Query Cache http://bugs.mysql.com/43758 #43758: Query cache can lock up threads in 'freeing items' state http://bugs.mysql.com/bug.php?id=43758 Submitted by: Harrison Fisk
Category: Server: Query Cache
Status: Closed
Severity: 2
OS: Any
Version: 5.1.32, 5.0
]]> Thu, 19 Mar 2009 19:21:43 +0000 Server: Query Cache http://bugs.mysql.com/43861 #43861: main.query_cache_28249 fails sporadically http://bugs.mysql.com/bug.php?id=43861 Submitted by: Alexander Nozdrin
Category: Server: Query Cache
Status: Closed
Severity: 3
OS: Any
Version: 5.1
]]> Wed, 25 Mar 2009 15:52:25 +0000 Server: Query Cache http://bugs.mysql.com/46615 #46615: Assertion in Query_cache::invalidate in INSERT in a VIEW of a MERGE table http://bugs.mysql.com/bug.php?id=46615 Submitted by: Philip Stoev
Category: Server: Query Cache
Status: Closed
Severity: 3
OS: Any
Version: 5.1,5.4
]]> Sat, 08 Aug 2009 09:03:27 +0000 Server: Query Cache http://bugs.mysql.com/47378 #47378: assertion in query cache when running event scheduler http://bugs.mysql.com/bug.php?id=47378 Submitted by: Shane Bester
Category: Server: Query Cache
Status: Closed
Severity: 1
OS: Any
Version: 5.1.38-debug
]]> Wed, 16 Sep 2009 15:12:55 +0000 Server: Query Cache http://bugs.mysql.com/56569 #56569: mysqld got signal 11 http://bugs.mysql.com/bug.php?id=56569 Submitted by: Martin Pawlack
Category: Server: Query Cache
Status: Closed
Severity: 1
OS: Linux (Ubuntu 8.04.4 32bit)
Version: 5.0.51a-3ubuntu5.7
]]> Sun, 05 Sep 2010 13:34:04 +0000 Server: Query Cache http://bugs.mysql.com/60801 #60801: Select Query is too much slow and taking upto 23 seconds to complete http://bugs.mysql.com/bug.php?id=60801 Submitted by: Devang Modi
Category: Server: Query Cache
Status: Closed
Severity: 2
OS: Linux (Red Hat Enterprise Linux Server release 5.3 )
Version: mysql Ver 14.12 Distrib 5.0.45
]]> Fri, 08 Apr 2011 03:51:45 +0000 Server: Query Cache http://bugs.mysql.com/64164 #64164: 5.5.16 waits for the query cache even with SQL_NO_CACHE hint http://bugs.mysql.com/bug.php?id=64164 Submitted by: Simon Mudd
Category: Server: Query Cache
Status: Closed
Severity: 3
OS: Linux (CentOS 5.4 x86_64)
Version: 5.5.16 GPL
]]> Mon, 30 Jan 2012 14:54:46 +0000 Server: Query Cache http://bugs.mysql.com/64821 #64821: Query Cache not used when table name contains dollar sign and engine is innodb http://bugs.mysql.com/bug.php?id=64821 Submitted by: Ryan Streb
Category: Server: Query Cache
Status: Closed
Severity: 2
OS: Any
Version: 5.1.61, 5.5.11
]]> Fri, 30 Mar 2012 23:33:14 +0000 Server: Query Cache http://bugs.mysql.com/66781 #66781: Debug assertion failure in query cache code on sysbench oltp test http://bugs.mysql.com/bug.php?id=66781 Submitted by: Alexey Kopytov
Category: Server: Query Cache
Status: Closed
Severity: 3
OS: Any
Version: 5.1.65, 5.5.27, 5.5.29, 5.7.0
]]> Wed, 12 Sep 2012 09:02:17 +0000 Server: Query Cache http://bugs.mysql.com/67156 #67156: Sporadic query cache related crash in pthread_rwlock_init() http://bugs.mysql.com/bug.php?id=67156 Submitted by: Davi Arnaut
Category: Server: Query Cache
Status: Closed
Severity: 2
OS: MacOS (10.7.5)
Version: 5.5.27
]]> Tue, 09 Oct 2012 18:21:00 +0000 Server: Query Cache http://bugs.mysql.com/69396 #69396: Can't set query_cache_type to 0 when it is already 0 http://bugs.mysql.com/bug.php?id=69396 Submitted by: Rolf Neuberger
Category: Server: Query Cache
Status: Closed
Severity: 3
OS: Any
Version: 5.6.11, 5.5.31
]]> Tue, 04 Jun 2013 12:08:08 +0000 Server: Query Cache http://bugs.mysql.com/72547 #72547: Query cache not invalidated on cascade delete if db name has special symbols http://bugs.mysql.com/bug.php?id=72547 Submitted by: Elena Stepanova
Category: Server: Query Cache
Status: Closed
Severity: 2
OS: Any
Version: 5.6, 5.7
]]> Tue, 06 May 2014 10:49:11 +0000 Server: Query Cache http://bugs.mysql.com/80026 #80026: "The statement (1) has no open cursor" pops sometimes with prepared+query_cache http://bugs.mysql.com/bug.php?id=80026 Submitted by: Andrii Nikitin
Category: Server: Query Cache
Status: Closed
Severity: 2
OS: Any
Version: 5.6.27
]]> Mon, 18 Jan 2016 09:29:19 +0000 Server: Query Cache http://bugs.mysql.com/86047 #86047: FROM sub query with 'group by' is cached by mistake http://bugs.mysql.com/bug.php?id=86047 Submitted by: Meiji Kimura
Category: Server: Query Cache
Status: Closed
Severity: 2
OS: Any
Version: 5.6,5.7,8.0, 5.6.36
]]> Sun, 23 Apr 2017 07:58:10 +0000 Server: Query Cache