Attachment 8925 Details for Bug 20143 – Patched version

Patched version

mysqld-wait-ready (text/plain), 2.12 KB, created by Raphael Gertz on 2017-02-03 15:59:58 CET

(hide)

Description:

Filename:

MIME Type:

Creator: Raphael Gertz

Created: 2017-02-03 15:59:58 CET

Size: 2.12 KB

patch

obsolete

>#!/bin/sh
>
># This script waits for mysqld to be ready to accept connections
># (which can be many seconds or even minutes after launch, if there's
># a lot of crash-recovery work to do).
># Running this as ExecStartPost is useful so that services declared as
># "After mysqld" won't be started until the database is really ready.
>
># extract value of a MySQL option from config files
># Usage: get_mysql_option SECTION VARNAME DEFAULT
># result is returned in $result
># We use my_print_defaults which prints all options from multiple files,
># with the more specific ones later; hence take the last match.
>get_mysql_option(){
>	result=`/usr/bin/my_print_defaults "$1" | sed -n "s/^--$2=//p" | tail -n 1`
>	if [ -z "$result" ]; then
>	    # not found, use default
>	    result="$3"
>	fi
>}
>
># Defaults here had better match what mysqld_safe will default to
>get_mysql_option mysqld datadir "/var/lib/mysql"
>datadir="$result"
>get_mysql_option mysqld socket "$datadir/mysql.sock"
>socketfile="$result"
>get_mysql_option mysqld pid-file "/var/run/mysqld/mysqld.pid"
>pidfile="$result"
>
># Service file passes us the daemon's PID
>daemon_pid="$1"
>
># Wait for socketfile and pidfile for 30 seconds
>timeout=30
>if [ -z "$daemon_pid" -o ! -S "$socketfile" -o ! -s "$pidfile" ]; then
>	while [ $timeout -gt 0 ]; do
>		sleep 1;
>		timeout=$(($timeout - 1));
>		if [ -z "$daemon_pid" -a -s $pidfile ]; then
>			daemon_pid=`cat $pidfile`;
>		fi
>		if [ ! -z "$daemon_pid" -a -S "$socketfile" -a -s "$pidfile" ]; then
>			break;
>		fi
>	done
>fi
>
># Wait for the server to come up or for the mysqld process to disappear
>ret=0
>while /bin/true; do
>	RESPONSE=`/usr/bin/mysqladmin --socket="$socketfile" --user=UNKNOWN_MYSQL_USER ping 2>&1`
>	mret=$?
>	if [ $mret -eq 0 ]; then
>	    break
>	fi
>	# exit codes 1, 11 (EXIT_CANNOT_CONNECT_TO_SERVICE) are expected,
>	# anything else suggests a configuration error
>	if [ $mret -ne 1 -a $mret -ne 11 ]; then
>	    ret=1
>	    break
>	fi
>	# "Access denied" also means the server is alive
>	echo "$RESPONSE" | \grep -q "Access denied for user" && break
>
>	# Check process still exists
>	if ! /bin/kill -0 $daemon_pid 2>/dev/null; then
>	    ret=1
>	    break
>	fi
>	sleep 1
>done
>
>exit $ret

#!/bin/sh

# This script waits for mysqld to be ready to accept connections
# (which can be many seconds or even minutes after launch, if there's
# a lot of crash-recovery work to do).
# Running this as ExecStartPost is useful so that services declared as
# "After mysqld" won't be started until the database is really ready.

# extract value of a MySQL option from config files
# Usage: get_mysql_option SECTION VARNAME DEFAULT
# result is returned in $result
# We use my_print_defaults which prints all options from multiple files,
# with the more specific ones later; hence take the last match.
get_mysql_option(){
	result=`/usr/bin/my_print_defaults "$1" | sed -n "s/^--$2=//p" | tail -n 1`
	if [ -z "$result" ]; then
	    # not found, use default
	    result="$3"
	fi
}

# Defaults here had better match what mysqld_safe will default to
get_mysql_option mysqld datadir "/var/lib/mysql"
datadir="$result"
get_mysql_option mysqld socket "$datadir/mysql.sock"
socketfile="$result"
get_mysql_option mysqld pid-file "/var/run/mysqld/mysqld.pid"
pidfile="$result"

# Service file passes us the daemon's PID
daemon_pid="$1"

# Wait for socketfile and pidfile for 30 seconds
timeout=30
if [ -z "$daemon_pid" -o ! -S "$socketfile" -o ! -s "$pidfile" ]; then
	while [ $timeout -gt 0 ]; do
		sleep 1;
		timeout=$(($timeout - 1));
		if [ -z "$daemon_pid" -a -s $pidfile ]; then
			daemon_pid=`cat $pidfile`;
		fi
		if [ ! -z "$daemon_pid" -a -S "$socketfile" -a -s "$pidfile" ]; then
			break;
		fi
	done
fi

# Wait for the server to come up or for the mysqld process to disappear
ret=0
while /bin/true; do
	RESPONSE=`/usr/bin/mysqladmin --socket="$socketfile" --user=UNKNOWN_MYSQL_USER ping 2>&1`
	mret=$?
	if [ $mret -eq 0 ]; then
	    break
	fi
	# exit codes 1, 11 (EXIT_CANNOT_CONNECT_TO_SERVICE) are expected,
	# anything else suggests a configuration error
	if [ $mret -ne 1 -a $mret -ne 11 ]; then
	    ret=1
	    break
	fi
	# "Access denied" also means the server is alive
	echo "$RESPONSE" | \grep -q "Access denied for user" && break

	# Check process still exists
	if ! /bin/kill -0 $daemon_pid 2>/dev/null; then
	    ret=1
	    break
	fi
	sleep 1
done

exit $ret

Actions: View

Attachments on bug 20143: 8915 | 8925 | 8936 | 8937 | 8938 | 8944 | 8952 | 8953 | 8954 | 8955