diff --git a/heartbeat/sybaseASE.in b/heartbeat/sybaseASE.in
index 9ddd429be..7ff30bd31 100755
--- a/heartbeat/sybaseASE.in
+++ b/heartbeat/sybaseASE.in
@@ -1,890 +1,888 @@
#!@BASH_SHELL@
#
# Sybase Availability Agent for Red Hat Cluster v15.0.2
# Copyright (C) - 2007
# Sybase, Inc. All rights reserved.
#
# Sybase Availability Agent for Red Hat Cluster v15.0.2 is licensed
# under the GNU General Public License Version 2.
#
# Author(s):
# Jian-ping Hui <jphui@sybase.com>
#
# Description: Service script for starting/stopping/monitoring \
# Sybase Adaptive Server on: \
# Red Hat Enterprise Linux 7 ES \
# Red Hat Enterprise Linux 7 AS
#
# NOTES:
#
# (1) Before running this script, we assume that user has installed
# Sybase ASE 15.0.2 or higher version on the machine. Please
# customize your configuration in /etc/cluster/cluster.conf according
# to your actual environment. We assume the following files exist before
# you start the service:
# /$sybase_home/SYBASE.sh
# /$sybase_home/$sybase_ase/install/RUN_$server_name
#
# (2) You can customize the interval value in the meta-data section if needed:
# <action name="start" timeout="300s" />
# <action name="stop" timeout="300s" />
#
# <!-- Checks to see if it''s mounted in the right place -->
# <action name="status" interval="30s" timeout="100s" />
# <action name="monitor" interval="30s" timeout="100s" />
#
# <!--Checks to see if we can read from the mountpoint -->
# <action name="status" depth="10" timeout="100s" interval="120s" />
# <action name="monitor" depth="10" timeout="100s" interval="120s" />
#
# <action name="meta-data" timeout="5s" />
# <action name="validate-all" timeout="5s" />
# The timeout value is not supported by Redhat in RHCS5.0.
#
#######################################################################
# Initialization:
if [ -f /etc/init.d/functions ]; then
. /etc/init.d/functions
fi
: ${OCF_FUNCTIONS_DIR=${OCF_ROOT}/lib/heartbeat}
. ${OCF_FUNCTIONS_DIR}/ocf-shellfuncs
#######################################################################
# Default timeouts when we aren't using the rgmanager wrapper
if ! ocf_is_true "$OCF_RESKEY_is_rgmanager_wrapper"; then
if [ -z "$OCF_RESKEY_CRM_meta_timeout" ]; then
case $1 in
start|stop) OCF_RESKEY_CRM_meta_timeout=300000 ;;
*) OCF_RESKEY_CRM_meta_timeout=100000 ;;
esac
fi
default_timeout=$(((${OCF_RESKEY_CRM_meta_timeout}/1000) - 5))
default_force_stop_timeout=$(((${OCF_RESKEY_CRM_meta_timeout}/1000) - 5))
: ${OCF_RESKEY_shutdown_timeout=${default_force_stop_timeout}}
: ${OCF_RESKEY_deep_probe_timeout=${default_timeout}}
: ${OCF_RESKEY_start_timeout=${default_timeout}}
fi
sybase_user_default="sybase"
sybase_home_default="detect"
ase_default="detect"
ocs_default="detect"
: ${OCF_RESKEY_sybase_user=${sybase_user_default}}
: ${OCF_RESKEY_sybase_ase=${ase_default}}
: ${OCF_RESKEY_sybase_ocs=${ocs_default}}
: ${OCF_RESKEY_sybase_home=${sybase_home_default}}
if [ "$__OCF_ACTION" != "meta-data" ]; then
if [ "$OCF_RESKEY_sybase_home" = "detect" ]; then
if [ -d "/opt/sap" ]; then
OCF_RESKEY_sybase_home="/opt/sap"
elif [ -d "/opt/sybase" ]; then
OCF_RESKEY_sybase_home="/opt/sybase"
else
ocf_log err "sybaseASE: Unable to detect 'sybase_home'."
exit $OCF_ERR_ARGS
fi
fi
sybase_env="$OCF_RESKEY_sybase_home/SYBASE.env"
if [ "$OCF_RESKEY_sybase_ase" = "detect" ]; then
if [ -f "$sybase_env" ]; then
OCF_RESKEY_sybase_ase=$(grep "SYBASE_ASE" "$sybase_env" | cut -d= -f2)
else
ocf_log err "sybaseASE: Unable to detect 'sybase_ase'."
exit $OCF_ERR_ARGS
fi
fi
if [ "$OCF_RESKEY_sybase_ocs" = "detect" ]; then
if [ -f "$sybase_env" ]; then
OCF_RESKEY_sybase_ocs=$(grep "SYBASE_OCS" "$sybase_env" | cut -d= -f2)
else
ocf_log err "sybaseASE: Unable to detect 'sybase_ocs'."
exit $OCF_ERR_ARGS
fi
fi
fi
interfaces_file_default="${OCF_RESKEY_sybase_home}/interfaces"
: ${OCF_RESKEY_interfaces_file=${interfaces_file_default}}
export LD_POINTER_GUARD=0
#######################################################################################
# Declare some variables we will use in the script. #
#######################################################################################
declare login_string=""
declare RUNSERVER_SCRIPT=$OCF_RESKEY_sybase_home/$OCF_RESKEY_sybase_ase/install/RUN_$OCF_RESKEY_server_name
declare CONSOLE_LOG=$OCF_RESKEY_sybase_home/$OCF_RESKEY_sybase_ase/install/$OCF_RESKEY_server_name.log
##################################################################################################
# This function will be called by Pacemaker to get the meta data of resource agent "sybaseASE". #
##################################################################################################
meta_data()
{
cat <<EOT
<?xml version="1.0" ?>
<!DOCTYPE resource-agent SYSTEM "ra-api-1.dtd">
<resource-agent name="sybaseASE" >
<version>1.0</version>
<longdesc lang="en">
Sybase ASE Failover Instance
</longdesc>
<shortdesc lang="en">
Sybase ASE Failover Instance
</shortdesc>
<parameters>
<parameter name="sybase_home">
<longdesc lang="en">
The home directory of sybase products
</longdesc>
<shortdesc lang="en">
SYBASE home directory
</shortdesc>
<content type="string" default="${sybase_home_default}"/>
</parameter>
<parameter name="sybase_ase">
<longdesc lang="en">
The directory name under sybase_home where ASE products are installed
</longdesc>
<shortdesc lang="en">
SYBASE_ASE directory name
</shortdesc>
<content type="string" default="$ase_default" />
</parameter>
<parameter name="sybase_ocs">
<longdesc lang="en">
The directory name under sybase_home where OCS products are installed, i.e. ASE-15_0
</longdesc>
<shortdesc lang="en">
SYBASE_OCS directory name
</shortdesc>
<content type="string" default="${ocs_default}" />
</parameter>
<parameter name="server_name" unique="1" required="1">
<longdesc lang="en">
The ASE server name which is configured for the HA service
</longdesc>
<shortdesc lang="en">
ASE server name
</shortdesc>
<content type="string" />
</parameter>
<parameter name="interfaces_file">
<longdesc lang="en">
The full path of interfaces file which is used to start/access the ASE server
</longdesc>
<shortdesc lang="en">
Interfaces file
</shortdesc>
<content type="string" default="$interfaces_file_default"/>
</parameter>
<parameter name="sybase_user">
<longdesc lang="en">
The user who can run ASE server
</longdesc>
<shortdesc lang="en">
Sybase user
</shortdesc>
<content type="string" default="$sybase_user_default" />
</parameter>
<parameter name="db_user" required="1">
<longdesc lang="en">
The database user required to login to isql.
</longdesc>
<shortdesc lang="en">
Sybase user
</shortdesc>
<content type="string"/>
</parameter>
<parameter name="db_passwd">
<longdesc lang="en">
The database user's password required to login to isql.
</longdesc>
<shortdesc lang="en">
Sybase user
</shortdesc>
<content type="string"/>
</parameter>
</parameters>
<actions>
<action name="start" timeout="300s" />
<action name="stop" timeout="300s" />
<!-- Checks to see if it''s mounted in the right place -->
<action name="status" interval="30s" timeout="100s" />
<action name="monitor" interval="30s" timeout="100s" />
<!--Checks to see if we can read from the mountpoint -->
<action name="status" depth="10" timeout="100s" interval="120s" />
<action name="monitor" depth="10" timeout="100s" interval="120s" />
<action name="meta-data" timeout="5s" />
<action name="validate-all" timeout="5s" />
</actions>
</resource-agent>
EOT
}
ase_engine0_process()
{
sed -n -e '/engine 0/s/^.*os pid \([0-9]*\).*online$/\1/p' $CONSOLE_LOG
}
ase_engine0_thread()
{
sed -n -e 's/.*Thread.*LWP \([0-9]*\).*online as engine 0.*/\1/p' $CONSOLE_LOG
}
ase_engine_threadpool_pid()
{
sed -n -e 's/.*Adaptive Server is running as process id \([0-9]*\).*/\1/p' $CONSOLE_LOG
}
ase_all_pids()
{
local PIDS=$(sed -n -e '/engine /s/^.*os pid \([0-9]*\).*online$/\1/p' $CONSOLE_LOG)
if [ -z "$PIDS" ]; then
#engines are running in a threadpool
PIDS=$(ase_engine_threadpool_pid)
fi
echo $PIDS
}
##################################################################################################
# Function Name: verify_all #
# Parameter: None #
# Return value: #
# 0 SUCCESS #
# OCF_ERR_ARGS Parameters are invalid #
# Description: Do some validation on the user-configurable stuff at the beginning of the script. #
##################################################################################################
verify_all()
{
ocf_log debug "sybaseASE: Start 'verify_all'"
check_binary "ksh"
# Check if the parameter 'sybase_home' is set.
if [[ -z "$OCF_RESKEY_sybase_home" ]]
then
ocf_log err "sybaseASE: The parameter 'sybase_home' is not set."
return $OCF_ERR_ARGS
fi
# Check if the parameter 'sybase_home' is a valid path.
if [[ ! -d $OCF_RESKEY_sybase_home ]]
then
ocf_log err "sybaseASE: The sybase_home '$OCF_RESKEY_sybase_home' doesn't exist."
return $OCF_ERR_ARGS
fi
# Check if the script file SYBASE.sh exists
if [[ ! -f $OCF_RESKEY_sybase_home/SYBASE.sh ]]
then
ocf_log err "sybaseASE: The file $OCF_RESKEY_sybase_home/SYBASE.sh is required to run this script. Failed to run the script."
return $OCF_ERR_ARGS
fi
# Check if the parameter 'sybase_ase' is set.
if [[ -z "$OCF_RESKEY_sybase_ase" ]]
then
ocf_log err "sybaseASE: The parameter 'sybase_ase' is not set."
return $OCF_ERR_ARGS
fi
# Check if the directory /$OCF_RESKEY_sybase_home/$OCF_RESKEY_sybase_ase exists.
if [[ ! -d $OCF_RESKEY_sybase_home/$OCF_RESKEY_sybase_ase ]]
then
ocf_log err "sybaseASE: The directory '$OCF_RESKEY_sybase_home/$OCF_RESKEY_sybase_ase' doesn't exist."
return $OCF_ERR_ARGS
fi
# Check if the parameter 'sybase_ocs' is set.
if [[ -z "$OCF_RESKEY_sybase_ocs" ]]
then
ocf_log err "sybaseASE: The parameter 'sybase_ocs' is not set."
return $OCF_ERR_ARGS
fi
# Check if the directory /$OCF_RESKEY_sybase_home/$OCF_RESKEY_sybase_ocs exists.
if [[ ! -d $OCF_RESKEY_sybase_home/$OCF_RESKEY_sybase_ocs ]]
then
ocf_log err "sybaseASE: The directory '$OCF_RESKEY_sybase_home/$OCF_RESKEY_sybase_ocs' doesn't exist."
return $OCF_ERR_ARGS
fi
# Check if the parameter 'server_name' is set.
if [[ -z "$OCF_RESKEY_server_name" ]]
then
ocf_log err "sybaseASE: The parameter 'server_name' is not set."
return $OCF_ERR_ARGS
fi
# Check if the Run_server file exists.
if [[ ! -f $RUNSERVER_SCRIPT ]]
then
ocf_log err "sybaseASE: The file $RUNSERVER_SCRIPT doesn't exist. The sybase directory may be incorrect."
return $OCF_ERR_ARGS
fi
# Check if the user 'sybase_user' exist
id -u $OCF_RESKEY_sybase_user
if [[ $? != 0 ]]
then
ocf_log err "sybaseASE: The user '$OCF_RESKEY_sybase_user' doesn't exist in the system."
return $OCF_ERR_ARGS
fi
# Check if the parameter 'interfaces_file' is set
if [[ -z "$OCF_RESKEY_interfaces_file" ]]
then
ocf_log err "sybaseASE: The parameter 'interfaces_file' is not set."
return $OCF_ERR_ARGS
fi
# Check if the file 'interfaces_file' exists
if [[ ! -f $OCF_RESKEY_interfaces_file ]]
then
ocf_log err "sybaseASE: The interfaces file '$OCF_RESKEY_interfaces_file' doesn't exist."
return $OCF_ERR_ARGS
fi
# Check if the parameter 'db_user' is set
if [[ -z "$OCF_RESKEY_db_user" ]]
then
ocf_log err "sybaseASE: The parameter 'db_user' is not set."
return $OCF_ERR_ARGS
fi
# Check if the parameter 'shutdown_timeout' is a valid value
if [[ $OCF_RESKEY_shutdown_timeout -eq 0 ]]
then
ocf_log err "sybaseASE: The parameter 'shutdown_timeout' is not set. Its value cannot be zero."
return $OCF_ERR_ARGS
fi
# Check if the parameter 'start_timeout' is a valid value
if [[ $OCF_RESKEY_start_timeout -eq 0 ]]
then
ocf_log err "sybaseASE: The parameter 'start_timeout' is not set. Its value cannot be zero."
return $OCF_ERR_ARGS
fi
# Check if the parameter 'deep_probe_timeout' is a valid value
if [[ $OCF_RESKEY_deep_probe_timeout -eq 0 ]]
then
ocf_log err "sybaseASE: The parameter 'deep_probe_timeout' is not set. Its value cannot be zero."
return $OCF_ERR_ARGS
fi
ocf_log debug "sybaseASE: End 'verify_all' successfully."
return $OCF_SUCCESS
}
set_login_string()
{
tmpstring=""
login_sting=""
login_string="-U$OCF_RESKEY_db_user -P$OCF_RESKEY_db_passwd"
return 0
}
##############################################################################################
# Function name: ase_start #
# Parameter: None #
# Return value: #
# 0 SUCCESS #
# 1 FAIL #
# Description: This function is used to start the ASE server in primary or secondary server. #
##############################################################################################
ase_start()
{
ocf_log debug "sybaseASE: Start 'ase_start'"
# Check if the server is running. If yes, return SUCCESS directly. Otherwise, continue the start work.
ase_is_running
if [[ $? = 0 ]]
then
# The server is running.
ocf_log info "sybaseASE: Server is running. Start is success."
return $OCF_SUCCESS
fi
# The server is not running. We need to start it.
# If the log file existed, delete it.
if [[ -f $CONSOLE_LOG ]]
then
rm -f $CONSOLE_LOG
fi
ocf_log debug "sybaseASE: Starting '$OCF_RESKEY_server_name'..."
# Run runserver script to start the server. Since this script will be run by root and ASE server
# needs to be run by another user, we need to change the user to sybase_user first. Then, run
# the script to start the server.
su $OCF_RESKEY_sybase_user -c ksh << EOF
# set required SYBASE environment by running SYBASE.sh.
. $OCF_RESKEY_sybase_home/SYBASE.sh
# Run the RUNSERVER_SCRIPT to start the server.
. $RUNSERVER_SCRIPT > $CONSOLE_LOG 2>&1 &
EOF
# Monitor every 1 seconds if the server has
# recovered, until RECOVERY_TIMEOUT.
t=0
while [[ $t -le $OCF_RESKEY_start_timeout ]]
do
grep -s "Recovery complete." $CONSOLE_LOG > /dev/null 2>&1
if [[ $? != 0 ]]
then
# The server has not completed the recovery. We need to continue to monitor the recovery
# process.
t=`expr $t + 1`
else
# The server has completed the recovery.
ocf_log info "sybaseASE: ASE server '$OCF_RESKEY_server_name' started successfully."
break
fi
sleep 1
done
# If $t is larger than start_timeout, it means the ASE server cannot start in given time. Otherwise, it
# means the ASE server has started successfully.
if [[ $t -gt $OCF_RESKEY_start_timeout ]]
then
# The server cannot start in specified time. We think the start is failed.
ocf_log err "sybaseASE: Failed to start ASE server '$OCF_RESKEY_server_name'. Please check the server error log $CONSOLE_LOG for possible problems."
return $OCF_ERR_GENERIC
fi
ase_is_running
if [ $? -ne 0 ]; then
ocf_log err "sybaseASE: ase_start could not detect database initialized properly."
return $OCF_ERR_GENERIC
fi
ocf_log debug "sybaseASE: End 'ase_start' successfully."
return $OCF_SUCCESS
}
#############################################################################################
# Function name: ase_stop #
# Parameter: None #
# Return value: #
# 0 SUCCESS #
# 1 FAIL #
# Description: This function is used to stop the ASE server in primary or secondary server. #
#############################################################################################
ase_stop()
{
ocf_log debug "sybaseASE: Start 'ase_stop'"
# Check if the ASE server is still running.
ase_is_running
if [[ $? != 0 ]]
then
# The ASE server is not running. We need not to shutdown it.
ocf_log info "sybaseASE: The dataserver $OCF_RESKEY_server_name is not running."
return $OCF_SUCCESS
fi
set_login_string
# Just in case things are hung, start a process that will wait for the
# timeout period, then kill any remaining porcesses. We'll need to
# monitor this process (set -m), so we can terminate it later if it is
# not needed.
set -m
kill_ase $OCF_RESKEY_shutdown_timeout &
KILL_PID=$! # If successful, we will also terminate watchdog process
# Run "shutdown with nowait" from isql command line to shutdown the server
su $OCF_RESKEY_sybase_user -c ksh << EOF
# set required SYBASE environment by running SYBASE.sh.
. $OCF_RESKEY_sybase_home/SYBASE.sh
# Run "shutdown with nowait" to shutdown the server immediately.
(echo "use master" ; echo go ; echo "shutdown with nowait"; echo go) | \
\$SYBASE/\$SYBASE_OCS/bin/isql $login_string -S$OCF_RESKEY_server_name -I$OCF_RESKEY_interfaces_file &
EOF
sleep 5
# Check if the server has been shut down successfully
t=0
while [[ $t -lt $OCF_RESKEY_shutdown_timeout ]]
do
# Search "ueshutdown: exiting" in the server log. If found, it means the server has been shut down.
# Otherwise, we need to wait.
tail $CONSOLE_LOG | grep "ueshutdown: exiting" > /dev/null 2>&1
if [[ $? != 0 ]]
then
# The shutdown is still in processing. Wait...
sleep 2
t=`expr $t+2`
else
# The shutdown is success.
ocf_log info "sybaseASE: ASE server '$OCF_RESKEY_server_name' shutdown with isql successfully."
break
fi
done
# If $t is larger than shutdown_timeout, it means the ASE server cannot be shut down in given time. We need
# to wait for the background kill process to kill the OS processes directly.
if [[ $t -ge $OCF_RESKEY_shutdown_timeout ]]
then
ocf_log err "sybaseASE: Shutdown of '$OCF_RESKEY_server_name' from isql failed. Server is either down or unreachable."
fi
# Here, the ASE server has been shut down by isql command or killed by background process. We need to do
# further check to make sure all processes have gone away before saying shutdown is complete. This stops the
# other node from starting up the package before it has been stopped and the file system has been unmounted.
# Get all processes ids from log file
declare -a ENGINE_ALL=$(ase_all_pids)
typeset -i num_procs=${#ENGINE_ALL[@]}
# We cannot find any process id from log file. It may be because the log file is corrupted or be deleted.
# In this case, we determine the shutdown is failed.
if [[ ${#ENGINE_ALL[@]} -lt 1 ]]
then
ocf_log err "sybaseASE: Unable to find the process id from $CONSOLE_LOG."
ocf_log err "sybaseASE: Stop ASE server failed."
return $OCF_ERR_GENERIC
fi
# Monitor the system processes to make sure all ASE related processes have gone away.
while true
do
# To every engine process, search it in system processes list. If it is not in the
# list, it means this process has gone away. Otherwise, we need to wait for it is
# killed by background process.
for i in "${ENGINE_ALL[@]}"
do
ps -fu $OCF_RESKEY_sybase_user | awk '{print $2}' | grep $i | grep -v grep
if [[ $? != 0 ]]
then
ocf_log debug "sybaseASE: $i process has stopped."
c=0
while (( c < $num_procs ))
do
if [[ ${ENGINE_ALL[$c]} = $i ]]
then
unset ENGINE_ALL[$c]
c=$num_procs
fi
(( c = c + 1 ))
done
fi
done
# To here, all processes should have gone away.
if [[ ${#ENGINE_ALL[@]} -lt 1 ]]
then
#
# Looks like shutdown was successful, so kill the
# script to kill any hung processes, which we started earlier.
# Check to see if the script is still running. If jobs
# returns that the script is done, then we don't need to kill
# it.
#
job=$(jobs | grep -v Done)
if [[ ${job} != "" ]]
then
ocf_log debug "sybaseASE: Killing the kill_ase script."
kill -15 $KILL_PID > /dev/null 2>&1
fi
break
fi
sleep 5
done
ocf_log debug "sybaseASE: End 'ase_stop'."
return $OCF_SUCCESS
}
####################################################################################
# Function name: ase_is_running #
# Parameter: None #
# Return value: #
# 0 ASE server is running #
# 1 ASE server is not running or there are errors #
# Description: This function is used to check if the ASE server is still running . #
####################################################################################
ase_is_running()
{
local PID
local THREAD
# If the error log doesn't exist, we can say there is no ASE is running.
if [[ ! -f $CONSOLE_LOG ]]
then
ocf_log debug "could not find console log $CONSOLE_LOG"
return $OCF_NOT_RUNNING
fi
# The error log file exists. Check if the engine 0 is alive.
PID=$(ase_engine0_process)
if [ -n "$PID" ]; then
kill -s 0 $PID > /dev/null 2>&1
if [ $? -eq 0 ]; then
# The engine 0 is running.
ocf_log debug "Found engine 0 pid $PID to be running"
return $OCF_SUCCESS
fi
# The engine 0 is not running.
return $OCF_NOT_RUNNING
fi
PID=$(ase_engine_threadpool_pid)
THREAD=$(ase_engine0_thread)
if [ -n "$PID" ] && [ -n "$THREAD" ]; then
ps -AL | grep -q "${PID}[[:space:]]*${THREAD} "
if [ $? -eq 0 ]; then
# engine 0 thread is running
ocf_log debug "Found engine 0 thread $THREAD in pid $PID to be running"
return $OCF_SUCCESS
fi
# The engine 0 is not running.
return $OCF_NOT_RUNNING
fi
return $OCF_ERR_GENERIC
}
####################################################################################
# Function name: kill_ase #
# Parameter: #
# DELAY The seconds to wait before killing the ASE processes. 0 means #
# kill the ASE processes immediately. #
# Return value: None #
# 1 ASE server is not running or there are errors #
# Description: This function is used to check if the ASE server is still running . #
####################################################################################
kill_ase()
{
ocf_log debug "sybaseASE: Start 'kill_ase'."
DELAY=$1
# Wait for sometime before sending a kill signal.
t=0
while [[ $t -lt $DELAY ]]
do
sleep 1
t=`expr $t+1`
done
# Get the process ids from log file
declare -a ENGINE_ALL=$(ase_all_pids)
# If there is no process id found in the log file, we need not to continue.
if [[ ${#ENGINE_ALL[@]} -lt 1 ]]
then
ocf_log err "sybaseASE: Unable to find the process id from $CONSOLE_LOG."
return $OCF_ERR_GENERIC
fi
# Kill the datasever process(es)
for pid in "${ENGINE_ALL[@]}"
do
kill -9 $pid > /dev/null 2>&1
if [[ $? != 0 ]]
then
ocf_log info "sybaseASE: kill_ase function did NOT find process $pid running."
else
ocf_log info "sybaseASE: kill_ase function did find process $pid running. Sent SIGTERM."
fi
done
ocf_log debug "sybaseASE: End 'kill_ase'."
return $OCF_SUCCESS
}
#####################################################################################
# Function name: ase_status #
# Parameter: #
# 0 Level 0 probe. In this level, we just check if engine 0 is alive #
# 10 Level 10 probe. In this level, we need to probe if the ASE server #
# still has response. #
# Return value: #
# 0 The server is still alive #
# 1 The server is down #
# Description: This function is used to check if the ASE server is still running. #
#####################################################################################
ase_status()
{
local rc
ocf_log debug "sybaseASE: Start 'ase_status'."
# Step 1: Check if the engine 0 is alive
ase_is_running
rc=$?
if [ $rc -ne 0 ]; then
# ASE is down. Return fail to Pacemaker to trigger the failover process.
ocf_log err "sybaseASE: ASE server is down."
return $rc
fi
# ASE process is still alive.
# Step2: If this is level 10 probe, We need to check if the ASE server still has response.
if [[ $1 -gt 0 ]]
then
ocf_log debug "sybaseASE: Need to run deep probe."
# Run deep probe
deep_probe
if [[ $? = 1 ]]
then
# Deep probe failed. This means the server has been down.
ocf_log err "sybaseASE: Deep probe found the ASE server is down."
return $OCF_ERR_GENERIC
fi
fi
ocf_log debug "sybaseASE: End 'ase_status'."
return $OCF_SUCCESS
}
####################################################################################
# Function name: deep_probe #
# Parameter: None #
# Return value: #
# 0 ASE server is alive #
# 1 ASE server is down #
# Description: This function is used to run deep probe to make sure the ASE server #
# still has response. #
####################################################################################
deep_probe()
{
declare -i rv
ocf_log debug "sybaseASE: Start 'deep_probe'."
# Declare two temporary files which will be used in this probe.
tmpfile1="$(mktemp /tmp/sybaseASE.1.XXXXXX)"
tmpfile2="$(mktemp /tmp/sybaseASE.2.XXXXXX)"
set_login_string
rm -f $tmpfile1
rm -f $tmpfile2
# The login file is correct. We have gotten the login account and password from it.
# Run isql command in background.
su $OCF_RESKEY_sybase_user -c ksh << EOF
# set required SYBASE environment by running SYBASE.sh.
. $OCF_RESKEY_sybase_home/SYBASE.sh
# Run a very simple SQL statement to make sure the server is still ok. The output will be put to
# tmpfile1.
(echo "select 1"; echo "go") |
\$SYBASE/\$SYBASE_OCS/bin/isql $login_string -S$OCF_RESKEY_server_name -I$OCF_RESKEY_interfaces_file -t $OCF_RESKEY_deep_probe_timeout -e -o$tmpfile1 &
# Record the isql command process id to temporary file. If the isql is hung, we need this process id
# to kill the hung process.
echo \$! > $tmpfile2
EOF
declare -i t=0
# Monitor the output file tmpfile1.
while [[ $t -lt $OCF_RESKEY_deep_probe_timeout ]]
do
# If the SQL statement is executed successfully, we will get the following output:
# 1> select 1
#
# -----------
# 1
#
# (1 row affected)
# So, we determine if the execution is success by searching the keyword "(1 row affected)".
grep "(1 row affected)" $tmpfile1
if [[ $? = 0 ]]
then
ocf_log debug "sybaseASE: Deep probe sucess."
break
else
sleep 1
t=`expr $t+1`
fi
done
# If $t is larger than deep_probe_timeout, it means the isql command line cannot finish in given time.
# This means the deep probe failed. We need to kill the isql process manually.
if [[ $t -ge $OCF_RESKEY_deep_probe_timeout ]]
then
ocf_log err "sybaseASE: Deep probe fail. The dataserver has no response."
# Read the process id of isql process from tmpfile2
pid=`cat $tmpfile2 | awk '{print $1}'`
rm -f $tmpfile1
rm -f $tmpfile2
# Kill the isql process directly.
kill -9 $pid
return 1
fi
rm -f $tmpfile1
rm -f $tmpfile2
ocf_log debug "sybaseASE: End 'deep_probe'."
return 0
}
#############################
# Do some real work here... #
#############################
case $__OCF_ACTION in
start)
verify_all || exit $OCF_ERR_GENERIC
ase_start
exit $?
;;
stop)
- verify_all || exit $OCF_ERR_GENERIC
ase_stop
exit $?
;;
status | monitor)
- verify_all || exit $OCF_ERR_GENERIC
ase_status $OCF_CHECK_LEVEL
exit $?
;;
meta-data)
meta_data
exit $OCF_SUCCESS
;;
validate-all)
verify_all
exit $?
;;
*)
echo "Usage: $SCRIPT {start|stop|monitor|status|validate-all|meta-data}"
exit $OCF_ERR_UNIMPLEMENTED
;;
esac
exit 0