Bug #2652 A thread doing repair by keycache is not killable
Submitted: 5 Feb 2004 8:27 Modified: 28 May 2004 21:24
Reporter: Tim Bunce Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:4.0.17 OS:Solaris (Solaris)
Assigned to: Sergei Golubchik CPU Architecture:Any

[5 Feb 2004 8:27] Tim Bunce 
Description:
A thread doing repair by keycache is not killable

How to repeat:
Corrupt a large table such that it needs repair by keycache
(ours was 4.7GB)

Try to kill the thread.

(Then, for extra fun, try to shutdown the server. It won't shutdown and you won't be able to connect to find out what's going on except by using low-level tools like truss and pstack.)

Suggested fix:
Ensure that *all* actions within the server that may be long running can be killed.
[4 Mar 2004 6:22] Michael Widenius 
I have filed this as a feature request for a future MySQL version.
[28 May 2004 21:24] Sergei Golubchik 
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/

Additional info:

Implemented in 4.1.1 (or may be even in 4.1.0)