[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-internals
Subject:    Cannot shutdown the server - it restarts, maybe related to BUG 15869
From:       Alexander Hinneburg <hinneburg () informatik ! uni-halle ! de>
Date:       2007-04-27 13:49:01
Message-ID: 4631FF4D.9020606 () informatik ! uni-halle ! de
[Download RAW message or body]

When trying to shutdown a running mysqld with 'mysqladmin shutdown' the 
mysqld just restarts.

The situation is similar to BUG 15869 reported by Joerg Behrens, 19 Dec 
2005 22:04, which appeared in Versions 4.1.16 and  5.0.20a . Details can 
be found at  http://bugs.mysql.com/bug.php?id=15869 . The report says 
that the bug should be fixed, but it seems not the case.

I am running mysql 5.0.37 on solaris 10. I have got the compiled version 
of mysql 5.0.37 from http://www.blastwave.org, so I don't know how it is 
compiled. The maintainer Alex Moore can be contacted through a form at 
http://www.blastwave.org/packages.php/mysql5 .

Is there any known way to shutdown the mysqld without rebooting the 
machine?

Here is an example what happens, when I try to shutdown the mysqld. Note 
the different PIDs of mysqld and mysqld_safe after the shutdown.
-------------------------
Sun Microsystems Inc.   SunOS 5.10      Generic January 2005
You have mail.
 > bash
bash-3.00$ cd /opt/csw/mysql5/bin/
bash-3.00$ ps -ef |grep mysql
    mysql 17000 16983   0 15:31:03 pts/12      0:00 grep mysql
    mysql 16983 16968   0 15:30:38 pts/12      0:00 bash
     root 10420     1   0 14:43:12 ?           0:00 /bin/sh 
/opt/csw/mysql5/bin/mysqld_safe --pid-file=/opt/csw/mysql5/var/mysql.pi
    mysql 16968 14014   0 15:30:34 pts/12      0:00 -tcsh
    mysql 10489 10420   0 14:43:12 ?           0:04 
/opt/csw/mysql5/libexec/mysqld --basedir=/opt/csw/mysql5 
--datadir=/opt/csw/mys
    mysql 16999 16983   1 15:31:03 pts/12      0:00 ps -ef
bash-3.00$ ./mysqladmin -u root -p shutdown
Enter password:
bash-3.00$ ps -ef |grep mysql
    mysql 17263 16983   0 15:34:57 pts/12      0:00 grep mysql
    mysql 16983 16968   0 15:30:38 pts/12      0:00 bash
     root 17196     1   0 15:34:49 ?           0:00 /bin/sh 
/opt/csw/mysql5/bin/mysqld_safe --pid-file=/opt/csw/mysql5/var/mysql.pi
    mysql 17262 16983   0 15:34:57 pts/12      0:00 ps -ef
    mysql 16968 14014   0 15:30:34 pts/12      0:00 -tcsh
    mysql 17260 17196   0 15:34:49 ?           0:00 
/opt/csw/mysql5/libexec/mysqld --basedir=/opt/csw/mysql5 
--datadir=/opt/csw/mys
bash-3.00$ ./mysql --version
./mysql  Ver 14.12 Distrib 5.0.37
bash-3.00$
-------------------------

Best regards,
Alexander

-- 
MySQL Internals Mailing List
For list archives: http://lists.mysql.com/internals
To unsubscribe:    http://lists.mysql.com/internals?unsub=mysql-internals@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]