From owner-freebsd-ports-bugs@FreeBSD.ORG Tue Feb 12 23:10:01 2008 Return-Path: Delivered-To: freebsd-ports-bugs@hub.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 865D216A503 for ; Tue, 12 Feb 2008 23:10:01 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (freefall.freebsd.org [IPv6:2001:4f8:fff6::28]) by mx1.freebsd.org (Postfix) with ESMTP id 67E8613C465 for ; Tue, 12 Feb 2008 23:10:01 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (gnats@localhost [127.0.0.1]) by freefall.freebsd.org (8.14.2/8.14.2) with ESMTP id m1CNA1Le086829 for ; Tue, 12 Feb 2008 23:10:01 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.14.2/8.14.1/Submit) id m1CNA1oT086828; Tue, 12 Feb 2008 23:10:01 GMT (envelope-from gnats) Resent-Date: Tue, 12 Feb 2008 23:10:01 GMT Resent-Message-Id: <200802122310.m1CNA1oT086828@freefall.freebsd.org> Resent-From: FreeBSD-gnats-submit@FreeBSD.org (GNATS Filer) Resent-To: freebsd-ports-bugs@FreeBSD.org Resent-Reply-To: FreeBSD-gnats-submit@FreeBSD.org, Michael Scheidell Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 2FB3B16A41A for ; Tue, 12 Feb 2008 23:04:21 +0000 (UTC) (envelope-from nobody@FreeBSD.org) Received: from www.freebsd.org (www.freebsd.org [IPv6:2001:4f8:fff6::21]) by mx1.freebsd.org (Postfix) with ESMTP id 237CC13C46B for ; Tue, 12 Feb 2008 23:04:21 +0000 (UTC) (envelope-from nobody@FreeBSD.org) Received: from www.freebsd.org (localhost [127.0.0.1]) by www.freebsd.org (8.14.2/8.14.2) with ESMTP id m1CN25mC065564 for ; Tue, 12 Feb 2008 23:02:05 GMT (envelope-from nobody@www.freebsd.org) Received: (from nobody@localhost) by www.freebsd.org (8.14.2/8.14.1/Submit) id m1CN244E065563; Tue, 12 Feb 2008 23:02:04 GMT (envelope-from nobody) Message-Id: <200802122302.m1CN244E065563@www.freebsd.org> Date: Tue, 12 Feb 2008 23:02:04 GMT From: Michael Scheidell To: freebsd-gnats-submit@FreeBSD.org X-Send-Pr-Version: www-3.1 Cc: Subject: ports/120575: mysql50-server 5.0.51a won't restart/stop anymore X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 12 Feb 2008 23:10:01 -0000 >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@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: