ports/120575: mysql50-server 5.0.51a won't restart/stop anymore

[Michael Scheidell]

>Number:         120575
>Category:       ports
>Synopsis:       mysql50-server  5.0.51a won't restart/stop anymore
>Confidential:   no
>Severity:       critical
>Priority:       high
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          sw-bug
>Submitter-Id:   current-users
>Arrival-Date:   Tue Feb 12 23:10:01 UTC 2008
>Closed-Date:
>Last-Modified:
>Originator:     Michael Scheidell
>Release:        6.2 r9
>Organization:
SECNAP Network Security
>Environment:
6.2-RELEASE-p9 FreeBSD 6.2-RELEASE-p9 #3: Mon Dec 31 14:39:40 EST 2007     admin at jailer.secnap.com:/usr/obj/usr/src/sys/JAILER  i386

>Description:
Ugraded mysql from 5.0.37 to 5.0.51a and can't stop it anymore.
5.0.37 was fine.
using /usr/local/etc/rc.d/mysql-server.sh stop OR restart.  it just hangs.


/var/db/mysql/* shows no abberations:
tail /var/db/mysql/*err
080212 18:00:12  mysqld restarted
080212 18:00:12  InnoDB: Started; log sequence number 0 44044
080212 18:00:12 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.0.51a'  socket: '/tmp/mysql.sock'  port: 3306  FreeBSD port: mysql-server-5.0.51a
080212 18:00:59 [Note] /usr/local/libexec/mysqld: Normal shutdown

080212 18:01:13  mysqld restarted
080212 18:01:13  InnoDB: Started; log sequence number 0 44044
080212 18:01:13 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.0.51a'  socket: '/tmp/mysql.sock'  port: 3306  FreeBSD port: mysql-server-5.0.51a


etc/init.d/mysql-server.sh restart
Stopping mysql.
Waiting for PIDS: 12691, 12691, 12691, 12691, 12691, 12691, 12691, 12691, 12691, 12691, 12691, 12691, 12691, 12691, 12691, 12691, 12691, 12691, 12691, 12691


 ps -auxww | grep mysql
mysql     12667  0.0  0.2  1784  1180  p0  I     5:58PM   0:00.02 /bin/sh /usr/local/bin/mysqld_safe --defaults-extra-file=/var/db/mysql/my.cnf --user=mysql --datadir=/var/db/mysql --pid-file=/var/db/mysql/listserver.hackertrap.net.pid
mysql     12691  0.0 11.0 327968 56944  p0  S     5:58PM   0:00.89 /usr/local/libexec/mysqld --defaults-extra-file=/var/db/mysql/my.cnf --basedir=/usr/local --datadir=/var/db/mysql --pid-file=/var/db/mysql/listserver.hackertrap.net.pid --port=3306 --socket=/tmp/mysql.sock
root      12721  0.0  0.2  1888  1272  p0  T     5:58PM   0:00.02 /bin/sh /etc/init.d/mysql-server.sh restart
root      12730  0.0  0.3  1888  1308  p0  T     5:58PM   0:00.05 /bin/sh /etc/init.d/mysql-server.sh stop

>How-To-Repeat:
upgrade to mysql50a.

/usr/local/etc/rc.d/mysql-server stop.
only difference I have it a edit to mysql-server to look for extra commands in /etc/my.cnf 

>Fix:


>Release-Note:
>Audit-Trail:
>Unformatted: