FAQ
Hi

Patch for WL#799 on mysql-5.1.28-rc/scripts/mysqld_safe.sh

--- mysqld_safe.sh 2008-08-28 11:40:52.000000000 -0400
+++ mysqld_safe_mod.sh 2008-10-05 10:10:12.000000000 -0400
@@ -513,6 +513,30 @@
fi
fi

+# if there exists a socket file, check if server is alive.
+# If it gets alive signal by ping command from mysqladmin
+# then terminate, otherwise proceed.
+if test -S $safe_mysql_unix_port
+then
+ if test -x ./bin/mysqladmin
+ then
+ my_admin="./bin/mysqladmin"
+ elif test -x @bindir@/mysqladmin
+ then
+ my_admin="@bindir@/mysqladmin"
+ else
+ my_admin="mysqladmin"
+ fi
+
+ cmd="$my_admin --socket=$safe_mysql_unix_port $USER_OPTION ping"
+ if eval $cmd | grep -v grep | grep "mysqld is alive" > /dev/null
+ then
+ echo "A mysqld process is alive on socket "$safe_mysql_unix_port
+ echo "A mysqld process is alive on socket "$safe_mysql_unix_port `date` >> $err_log
+ exit 1
+ fi
+fi
+
#
# Uncomment the following lines if you want all tables to be automatically
# checked and repaired during startup. You should add sensible key_buffer

I could reproduce the problem mentioned in the work log for case where
some one deletes the pid file. No idea about others ways to reproduce.

Regards
Pathik



__________________________________________________________________
Be smarter than spam. See how smart SpamGuard is at giving junk email the boot with the All-new Yahoo! Mail. Click on Options in Mail and switch to New Mail today or register for free at http://mail.yahoo.ca

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupcontributions @
categoriesmysql
postedOct 5, '08 at 2:44p
activeOct 5, '08 at 2:44p
posts1
users1
websitemysql.com
irc#mysql

1 user in discussion

Mohammad Rahman: 1 post

People

Translate

site design / logo © 2021 Grokbase