Bug #5730 Query cache crashes mysqld
Submitted: 24 Sep 2004 11:59 Modified: 6 Dec 2004 6:47
Reporter: Dean Ellis Email Updates:
Status: Closed Impact on me:
Category:MySQL Server Severity:S1 (Critical)
Version:4.1.4 OS:
Assigned to: Alexey Botchkov CPU Architecture:Any

[24 Sep 2004 11:59] Dean Ellis
With query_cache_size=50M and query_cache_limit=25M, mysqld eventually crashes in a load that makes heavy use of the query cache (many hits, inserts, lowmem-prunes), generally while cacheing/removing large results.

Seems to involve stack clobbering, possibly due to recursion in Query_cache::allocate_data_chain().  Debug binary does not seem to crash.

How to repeat:
No reliable test case available yet.

Suggested fix:
[1 Oct 2004 15:24] Alexey Botchkov
bk commit - 4.1 tree (hf:1.2038) BUG#5730
[6 Dec 2004 6:47] Alexey Botchkov
Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at