hi there
As anyone faced the problem that PRM restarts the MYSQL server everytime it runs?
Even when it has 0 processes?
Mysqld log...........................
Number of processes running now: 0
050927 10:08:46 mysqld restarted
050927 10:08:46 Warning: Asked for 196608 thread stack, but got 126976
050927 10:08:46 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 115871
InnoDB: Doing recovery: scanned up to log sequence number 0 115871
InnoDB: Last MySQL binlog file position 0 29367740, file name ./server01-bin.051
050927 10:08:46 InnoDB: Flushing modified pages from the buffer pool...
050927 10:08:46 InnoDB: Started
/usr/sbin/mysqld: ready for connections.
Version: '4.0.23-standard-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Official MySQL RPM
......................................................
My CONF.PRm is set like:
.......................................................
#
# PRM 0.5 [[email protected]]
###
# Copyright (C) 1999-2003, R-fx Networks <[email protected]>
# Copyright (C) 2003, Ryan MacDonald <[email protected]>
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2 of the License, or
# (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
###
#
# NOTE: This file should be edited with word/line wrapping off,
# if your using pico please start it with the -w switch.
# (e.g: pico -w filename)
#
#
# [ Main config ]
#
# installation path
INSPATH="/usr/local/prm"
# string based ignore file
IGNORE="$INSPATH/ignore"
# directory path to process rules
PRULES="$INSPATH/rules"
# enable kernel logging [0=disabled,1=enabled]
USE_KLOG="0"
# path to kernel log
KLOG="/var/log/messages"
# enable user e-mail alerts [0=disabled,1=enabled]
USR_ALERT="1"
# e-mail address for alerts
USR_ADDR="[email protected]"
# path to user e-mail message file
USR_MSG="$INSPATH/usr.msg"
# subject of e-mail alerts
SUBJ="webtux24.com: Process status report from $HOSTNAME"
# check 5,10,15 minute load average. [1,2,3 respective of 5,10,15]
LC="1"
# min load level required to run (decimal values unsupported)
MIN_LOAD="0"
# seconds to wait before rechecking a flaged pid (pid's noted resource
# intensive but not yet killed).
WAIT="10"
# counter limit that a process must reach prior to kill. the counter value
# increases for a process flaged resource intensive on rechecks.
KILL_TRIG="3"
# argument to pass onto kill commands
KARG="9"
# Max CPU usage readout for a process - % of all cpu resources (decimal values unsupported)
MAXCPU="35"
# Max MEM usage readout for a process - % of system total memory (decimal values unsupported)
MAXMEM="15"
# Max processes for a given command - this is not max processes for user but rather the executable
MAXPS="25"
# [ Misc. config ]
#
# temp file for proc listing
PROCLS_TMP="$INSPATH/.procls"
# data directory for kill info files
KSP="$INSPATH/killed"
# main log file
LOG="$INSPATH/prm_log"
# misc temp file
TMP="$INSPATH/.tmp"
# app name as seen in logs
APPN="prm"
# unix time for lock tracking
UTIME=`date +"%s"`
# lock file path
LOCK="$INSPATH/lock.utime"
# lock file timeout in seconds
LOCK_TIMEOUT="180"
.......................................................
Mysql is running version 4.0.23
Any help is welcomed.
As anyone faced the problem that PRM restarts the MYSQL server everytime it runs?
Even when it has 0 processes?
Mysqld log...........................
Number of processes running now: 0
050927 10:08:46 mysqld restarted
050927 10:08:46 Warning: Asked for 196608 thread stack, but got 126976
050927 10:08:46 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 115871
InnoDB: Doing recovery: scanned up to log sequence number 0 115871
InnoDB: Last MySQL binlog file position 0 29367740, file name ./server01-bin.051
050927 10:08:46 InnoDB: Flushing modified pages from the buffer pool...
050927 10:08:46 InnoDB: Started
/usr/sbin/mysqld: ready for connections.
Version: '4.0.23-standard-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Official MySQL RPM
......................................................
My CONF.PRm is set like:
.......................................................
#
# PRM 0.5 [[email protected]]
###
# Copyright (C) 1999-2003, R-fx Networks <[email protected]>
# Copyright (C) 2003, Ryan MacDonald <[email protected]>
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2 of the License, or
# (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
###
#
# NOTE: This file should be edited with word/line wrapping off,
# if your using pico please start it with the -w switch.
# (e.g: pico -w filename)
#
#
# [ Main config ]
#
# installation path
INSPATH="/usr/local/prm"
# string based ignore file
IGNORE="$INSPATH/ignore"
# directory path to process rules
PRULES="$INSPATH/rules"
# enable kernel logging [0=disabled,1=enabled]
USE_KLOG="0"
# path to kernel log
KLOG="/var/log/messages"
# enable user e-mail alerts [0=disabled,1=enabled]
USR_ALERT="1"
# e-mail address for alerts
USR_ADDR="[email protected]"
# path to user e-mail message file
USR_MSG="$INSPATH/usr.msg"
# subject of e-mail alerts
SUBJ="webtux24.com: Process status report from $HOSTNAME"
# check 5,10,15 minute load average. [1,2,3 respective of 5,10,15]
LC="1"
# min load level required to run (decimal values unsupported)
MIN_LOAD="0"
# seconds to wait before rechecking a flaged pid (pid's noted resource
# intensive but not yet killed).
WAIT="10"
# counter limit that a process must reach prior to kill. the counter value
# increases for a process flaged resource intensive on rechecks.
KILL_TRIG="3"
# argument to pass onto kill commands
KARG="9"
# Max CPU usage readout for a process - % of all cpu resources (decimal values unsupported)
MAXCPU="35"
# Max MEM usage readout for a process - % of system total memory (decimal values unsupported)
MAXMEM="15"
# Max processes for a given command - this is not max processes for user but rather the executable
MAXPS="25"
# [ Misc. config ]
#
# temp file for proc listing
PROCLS_TMP="$INSPATH/.procls"
# data directory for kill info files
KSP="$INSPATH/killed"
# main log file
LOG="$INSPATH/prm_log"
# misc temp file
TMP="$INSPATH/.tmp"
# app name as seen in logs
APPN="prm"
# unix time for lock tracking
UTIME=`date +"%s"`
# lock file path
LOCK="$INSPATH/lock.utime"
# lock file timeout in seconds
LOCK_TIMEOUT="180"
.......................................................
Mysql is running version 4.0.23
Any help is welcomed.