Bug #14106 IM: im_life_cycle and im_utils tests fail on FreeBSD
Submitted: 18 Oct 2005 3:29 Modified: 24 May 2006 21:26
Reporter: Petr Chardin
Status: Closed
Category:Instance Manager Severity:S3 (Non-critical)
Version:5.0 OS:
Assigned to: Alexander Nozdrin Target Version:

[18 Oct 2005 3:29] Petr Chardin 
Description:
mentioned tests fail on FreeBSD

TEST                           RESULT
-------------------------------------------------------

im_life_cycle                  [ fail ]

Errors are (from /usr/home/mysqldev/petr/mysql-5.0.15/mysql-test/var/log/mysqltest-time)
:
mysqltest: At line 132: query 'START INSTANCE mysqld2' failed: 3002: The instance is
already started
(the last lines may be the most important ones)

This happens since IM cannot kill the instance. Something strange happens with kill
there: kill(SIGTERM) only forces an instance to remove the pidfile, but the server is
still alive. kill(SIGKILL)  issued by IM right after that doesn't work. However if IM
just always do kill(SIGKILL), instances are killed fine.
Looks like a FreeBSD thread issue.

How to repeat:
run tests
[5 May 2006 15:20] 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/6012
[6 May 2006 11:58] 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/6046
[6 May 2006 12:54] Konstantin Osipov 
The patch is OK to push.
[10 May 2006 12:33] 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/6187
[18 May 2006 23:16] Dmitri Lenev 
Fixed in 5.0.22 and 5.1.11
[24 May 2006 21:26] Paul DuBois 
Noted in 5.0.23, 5.1.11 changelogs.

Added the <option>--angel-pid-file</option> option to
<command>mysqlmanager</command> for specifying the file in
which the angel process records its process ID when
<command>mysqlmanager</command> runs in daemon mode. 

The bug involves test cases, but the fix involves a new option
(--angel-pid-file), so I've added that to the mysqlmanager section
in the manual.