Bug #17584 Problems with server PID file
Submitted: 20 Feb 2006 16:50 Modified: 29 May 2006 11:21
Reporter: Joerg Bruehe Email Updates:
Status: Duplicate Impact on me:
None 
Category:Instance Manager Severity:S3 (Non-critical)
Version:5.1.7-beta + 5.0.20 OS:Other (SCO OSR 6, OpenBSD)
Assigned to: Assigned Account CPU Architecture:Any

[20 Feb 2006 16:50] Joerg Bruehe
Description:
Build of 5.1.7-beta, based on ChangeSet
  1.2139 06/02/20 00:32:07 kent@mysql.com +3 -0
  mysql-test-run.pl:
    Added --restart-cleanup option
  drop-on-restart.inc:
    DROP commands to cleanup on restart
    new file
  mysqltest.c:
    Added option --include=<sql-file>

Failure is specific to SCO, and occurs only in non-debug builds:
-------------------------------------------------------
*** r/im_life_cycle.result
--- r/im_life_cycle.reject
***************
*** 43,51
  instance_name status
  mysqld1       online
  mysqld2       offline
! Killing the process...
! Sleeping...
! Success: the process was restarted.
  SHOW INSTANCES;
  instance_name status
  mysqld1       online
--- 43,49
  instance_name status
  mysqld1       online
  mysqld2       offline
! Error: invalid PID path (/home/mysqldev/opnsrv6c/test/mysql-5.1.7-beta-sco-osr6-i686/mysql-test/var/run/mysqld_1.pid) or PID file does not exist.
  SHOW INSTANCES;
  instance_name status
  mysqld1       online
-------------------------------------------------------

This is the line called:
    124 --exec $MYSQL_TEST_DIR/t/kill_n_check.sh $IM_MYSQLD1_PATH_PID restarted

How to repeat:
Occurs when running the test suite.
[31 Mar 2006 15:21] Joerg Bruehe
Symptom is spreading:

-------------------------------------------------------
*** r/im_daemon_life_cycle.result
--- r/im_daemon_life_cycle.reject
***************
*** 2,7
  instance_name status
  mysqld1       online
  mysqld2       offline
! Killing the process...
! Sleeping...
! Success: the process was restarted.
--- 2,5
  instance_name status
  mysqld1       online
  mysqld2       offline
! Error: invalid PID path (/home/mysqldev/granny/test/mysql-standard-5.0.20-openbsd3.9-i386/mysql-test/var/run/im.pid) or P
ID file does not exist.
-------------------------------------------------------
Occurred on OpenBSD:
granny-5.0-standard.log   normal
[22 May 2006 12:28] Konstantin Osipov
Chad, I'm taking this over, this looks like an instance manager bug.
[29 May 2006 11:21] Alexander Nozdrin
This bug is a duplicate of BUG#18023.