MySQL Bugs: #5730: Query cache crashes mysqld

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:	None
Category:	MySQL Server	Severity:	S1 (Critical)
Version:	4.1.4	OS:
Assigned to:	Alexey Botchkov	CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
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:
n/a

bk commit - 4.1 tree (hf:1.2038) BUG#5730

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 
http://www.mysql.com/downloads/