From: Mohammad Rahman
Date: October 5 2008 2:44pm
Subject: Community contribution WL#799
List-Archive: http://lists.mysql.com/contributions/8
Message-Id: <664003.96761.qm@web59814.mail.ac4.yahoo.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="0-1151832654-1223217856=:96761"

--0-1151832654-1223217856=:96761
Content-Type: text/plain; charset=us-ascii

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
--0-1151832654-1223217856=:96761
Content-Type: text/x-diff; name="WL#799.patch"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="WL#799.patch"

LS0tIG15c3FsZF9zYWZlLnNoCTIwMDgtMDgtMjggMTE6NDA6NTIuMDAwMDAw
MDAwIC0wNDAwCisrKyBteXNxbGRfc2FmZV9tb2Quc2gJMjAwOC0xMC0wNSAx
MDoxMDoxMi4wMDAwMDAwMDAgLTA0MDAKQEAgLTUxMyw2ICs1MTMsMzAgQEAK
ICAgZmkKIGZpCiAKKyMgaWYgdGhlcmUgZXhpc3RzIGEgc29ja2V0IGZpbGUs
IGNoZWNrIGlmIHNlcnZlciBpcyBhbGl2ZS4KKyMgSWYgaXQgZ2V0cyBhbGl2
ZSBzaWduYWwgYnkgcGluZyBjb21tYW5kIGZyb20gbXlzcWxhZG1pbgorIyB0
aGVuIHRlcm1pbmF0ZSwgb3RoZXJ3aXNlIHByb2NlZWQuCitpZiB0ZXN0IC1T
ICRzYWZlX215c3FsX3VuaXhfcG9ydAordGhlbgorICBpZiB0ZXN0IC14IC4v
YmluL215c3FsYWRtaW4KKyAgdGhlbgorICAgIG15X2FkbWluPSIuL2Jpbi9t
eXNxbGFkbWluIgorICBlbGlmIHRlc3QgLXggQGJpbmRpckAvbXlzcWxhZG1p
bgorICB0aGVuCisgICAgbXlfYWRtaW49IkBiaW5kaXJAL215c3FsYWRtaW4i
CisgIGVsc2UKKyAgICBteV9hZG1pbj0ibXlzcWxhZG1pbiIKKyAgZmkKKwor
ICBjbWQ9IiRteV9hZG1pbiAtLXNvY2tldD0kc2FmZV9teXNxbF91bml4X3Bv
cnQgJFVTRVJfT1BUSU9OIHBpbmciCisgIGlmIGV2YWwgJGNtZCB8IGdyZXAg
LXYgZ3JlcCB8IGdyZXAgIm15c3FsZCBpcyBhbGl2ZSIgPiAvZGV2L251bGwK
KyAgdGhlbgorICAgIGVjaG8gIkEgbXlzcWxkIHByb2Nlc3MgaXMgYWxpdmUg
b24gc29ja2V0ICIkc2FmZV9teXNxbF91bml4X3BvcnQKKyAgICBlY2hvICJB
IG15c3FsZCBwcm9jZXNzIGlzIGFsaXZlIG9uIHNvY2tldCAiJHNhZmVfbXlz
cWxfdW5peF9wb3J0IGBkYXRlYCA+PiAkZXJyX2xvZworICAgIGV4aXQgMQor
ICBmaQorZmkKKwogIwogIyBVbmNvbW1lbnQgdGhlIGZvbGxvd2luZyBsaW5l
cyBpZiB5b3Ugd2FudCBhbGwgdGFibGVzIHRvIGJlIGF1dG9tYXRpY2FsbHkK
ICMgY2hlY2tlZCBhbmQgcmVwYWlyZWQgZHVyaW5nIHN0YXJ0dXAuIFlvdSBz
aG91bGQgYWRkIHNlbnNpYmxlIGtleV9idWZmZXIK

--0-1151832654-1223217856=:96761--