Bug #20051 Parallel OPTIMIZE TABLE deadlocks and ignores myisam_repair_threads value
Submitted: 24 May 2006 17:58 Modified: 28 Jun 2006 15:58
Reporter: Antony Curtis Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: MyISAM storage engine Severity:S2 (Serious)
Version:4.1.9 OS:Any (Any)
Assigned to: Assigned Account CPU Architecture:Any

[24 May 2006 17:58] Antony Curtis 
Description:
Sub-bug created from Bug#8283: OPTIMIZE TABLE causes data loss

OPTIMIZE/REPAIR TABLE can deadlock, leave zombie threads, and it doesn't respect the number of threads requested in myisam_repair_threads variable

How to repeat:
See Bug#8283
[24 May 2006 19:47] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/6853
[25 May 2006 22:04] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/6893
[28 Jun 2006 15:58] Calvin Sun 
will be fixed in bug#8283