Bug #21333 IM fails to restart an instance

• Submitted: 28 Jul 2006 17:19
• Modified: 31 Aug 2006 8:51
• Reporter: Joerg Bruehe
• Status: Can't repeat
• Category: Instance Manager
• Severity: S3 (Non-critical)
• Version: 5.0.24
• OS: Linux (Linux (ia64))
• Assigned to: Alexander Nozdrin
• CPU Architecture: Any

[28 Jul 2006 17:19] Joerg Bruehe

Description:
This looks like a subset of bug#18023,
but two fixes for that bug are contained in this tree:

ChangeSet@1.2164.11.2, 2006-06-19 14:13:34+04:00, [e-mail] +11 -0
ChangeSet@1.2144.1.3, 2006-05-29 17:30:30+04:00, [e-mail] +1 -0

Symptom:
-------------------------------------------------------
*** r/im_life_cycle.result
--- r/im_life_cycle.reject
***************
*** 46,55
  mysqld2       offline
  Killing the process...
  Sleeping...
! Success: the process was restarted.
  SHOW INSTANCES;
  instance_name status
! mysqld1       online
  mysqld2       offline

  --------------------------------------------------------------------
--- 46,55
  mysqld2       offline
  Killing the process...
  Sleeping...
! Error: the process was not restarted.
  SHOW INSTANCES;
  instance_name status
! mysqld1       offline
  mysqld2       offline

  --------------------------------------------------------------------
-------------------------------------------------------
Occurs:
ita2-rhas21-5.0-cluster.log   NDB
ita2-rhas21-5.0-max.log   NDB
ita2-rhas21-5.0-pro.log   normal
ita2-rhas21-5.0-pro-gpl.log   normal

Note that it does not occur in all builds or all tests,
it passes in the "normal" tests of the "max" and "cluster" build
(also in "debug" + "standard" build),
so a race conmdition is possible.

How to repeat:
Found when running the test suite.

[31 Aug 2006 8:51] Alexander Nozdrin

This bug seems to be fixed by the patch for BUG#21331:
http://lists.mysql.com/commits/10998

(fixed in 5.0.24a)