Re: PID file being removed

[Shannon E. Reall]

Here is the rc script for mysql:

#!/sbin/sh
#

case "$1" in
'start')
        su mysql -c "exec /usr/local/mysql/libexec/mysqld" &
        ;;

'stop')
        ps -ef | grep mysqld | grep -v grep | awk '{print $2}' | xargs kill
-9
        ;;

*)
        echo "Usage: $0 { start | stop }"
        exit 1
        ;;
esac


**The pid file is definately there after mysql is started.  

Here is the  output from running monit in verbose mode:

Runtime constants:
 Control file       = /etc/monitrc
 Log file           = /var/log/monit
 Pid file           = /var/run/monit.pid
 Debug              = True
 Log                = True
 Use syslog         = False
 Is Daemon          = False
 Use process engine = True
 Poll time          = 0 seconds
 Mail server        = (not defined)
 Mail from          = (not defined)
 Mail subject       = (not defined)
 Mail message       = (not defined)
 Start monit httpd  = False

The process list contains the following entries:

Process Name          = mysql
 Group                = (not defined)
 Pid file             = /usr/local/mysql/var/sun07.pid
 Monitoring mode      = active
 Start program        = /etc/init.d/mysql
 Stop program         = /etc/init.d/mysql
 Host:Port            = (not defined)
 Resource Limits      = (not defined)
 Every                = (not defined)
 Timeout              = Do timeout if 3 restart within 3 cycles
 Alert mail to        = address@hidden
   alert from         = (default)
   alert subject      = (default)
   alert message      = (default)
   alert on timeout   = no
   alert on restart   = yes
   alert on checksum  = no
   alert on resource  = no
   alert on stop      = no
   alert on timestamp = no
 Alert mail to        = address@hidden
   alert from         = (default)
   alert subject      = (default)
   alert message      = (default)
   alert on timeout   = yes
   alert on restart   = no
   alert on checksum  = no
   alert on resource  = no
   alert on stop      = no
   alert on timestamp = no

-------------------------------------------------------------------------------
start: (mysql) /etc/init.d/mysql
monit: Warning process 'mysql' was not started
Monitoring enabled -- process mysql
Restart notification is sent to address@hidden

Thanks,
Shannon

address@hidden wrote:

------------------------------

Message: 3
Date: Thu, 28 Aug 2003 13:12:41 +0200
From: Martin Pala <address@hidden>
Subject: Re: PID file being removed
To: This is the general mailing list for monit
	<address@hidden>
Message-ID: <address@hidden>
Content-Type: text/plain; charset=ISO-8859-2; format=flowed

Hi,

the problem is probably caused in your mysql startup script, which 
probably removes it. Monit is not able to remove the monitored service's 
pidfile (until instructed to do so via exec statement which is not this 
case).

Please:

1.) attach your mysql rc script - we can figure out where and why it 
removed the pidfile.

2.) optionaly trace the process as described in FAQ.txt distributed with 
monit, it could help to see the actions/environment which preceded to 
start method execution and the cause why monit decided to start mysql 
though it was running before monit started (which is not normal - there 
must be some reason for it - it works in 3.2 well).

3.) run monit in verbose mode ('-v' command line option)


If it is problem for you to do any of above hints, please send kindly 
just some of these informations.


Thanks for feedback 
Martin

> Message: 2
> Date: Fri, 22 Aug 2003 07:49:19 -0400
> From: "Shannon E. Reall" <address@hidden>
> Subject: PID file being removed
> To: address@hidden
> Message-ID: <address@hidden>
> Content-Type: text/plain; charset=us-ascii; format=flowed
>
> I recently upgraded to 3.2 and am now having a problem monitoring 
> mysqld.  Here is that portion of the conf file:
>
> check mysql with pidfile /usr/local/mysql/var/sun07.pid
> timeout(3,3)
> start program = "/etc/init.d/mysql start"
> stop program = "/etc/init.d/mysql stop"
> alert address@hidden on { timeout }
> alert address@hidden on { restart }
>
> The pid file exists before I start monit but then it disappears.  Here 
> is what I did for testing:
>
> address@hidden:/# ps -ef |grep mysql
>    mysql   455     1  0 18:05:55 ?        0:01 
> /usr/local/mysql/libexec/mysqld
>     root 23227 19786  0 07:47:11 pts/3    0:00 grep mysql
>
> address@hidden:/# echo 455 > /usr/local/mysql/var/sun07.pid
>
> address@hidden:/# ls -l /usr/local/mysql/var/sun07.pid
> -rw-r--r--   1 root     other          4 Aug 22 07:47 
> /usr/local/mysql/var/sun07.pid
>
> address@hidden:/# /usr/local/bin/monit -d 60
> Starting monit daemon
>
> address@hidden:/# tail /var/log/monit
> [EDT Aug 22 07:37:20] Starting monit daemon
> [EDT Aug 22 07:39:44] Stopping monit HTTP server
> [EDT Aug 22 07:39:44] monit daemon with pid [22123] killed
> [EDT Aug 22 07:43:28] Starting monit daemon
> [EDT Aug 22 07:43:28] start: (mysql) /etc/init.d/mysql
> [EDT Aug 22 07:44:28] monit: Warning process 'mysql' was not started
> [EDT Aug 22 07:44:29] Stopping monit HTTP server
> [EDT Aug 22 07:44:29] monit daemon with pid [23002] killed
> [EDT Aug 22 07:47:47] Starting monit daemon
> [EDT Aug 22 07:47:47] start: (mysql) /etc/init.d/mysql
> [EDT Aug 22 07:48:47] monit: Warning process 'mysql' was not started
>
> address@hidden:/# ls -l /usr/local/mysql/var/sun07.pid
> /usr/local/mysql/var/sun07.pid: No such file or directory
>
> Am I missing something?  Thanks for any help you can provide.

-- 
Shannon