From owner-freebsd-database@FreeBSD.ORG Mon Apr 3 15:24:49 2006 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id A609916A420 for ; Mon, 3 Apr 2006 15:24:49 +0000 (UTC) (envelope-from glenn@mail.more.net) Received: from libby.lpmo.org (libby.lpmo.org [216.106.2.138]) by mx1.FreeBSD.org (Postfix) with ESMTP id 0C75243D5A for ; Mon, 3 Apr 2006 15:24:44 +0000 (GMT) (envelope-from glenn@mail.more.net) Received: from gkar.earthdome.org (111.mnetw.more.net [207.160.138.111]) by libby.lpmo.org (Postfix) with ESMTP id EA38F2841B for ; Mon, 3 Apr 2006 10:22:56 -0500 (CDT) Received: by gkar.earthdome.org (Postfix, from userid 503) id 45E4E57EE3F; Mon, 3 Apr 2006 10:23:42 -0500 (CDT) Date: Mon, 3 Apr 2006 10:23:42 -0500 From: Glenn Nielsen To: freebsd-database@freebsd.org Message-ID: <20060403152341.GB27511@gkar.earthdome.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.4.2.1i Subject: [deischen@FreeBSD.org: Re: threads/95127: MySQL 4.1 SIGBUS failiure with FreeBSD 6.0] X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 03 Apr 2006 15:24:49 -0000 I filed a bug report on the MySQL 4.1 sigbus failure and FreeBSD 6 last week. A patch was found, applied, and worked. See below for a link to the bug report and resolution. Thanks to those who helped. Glenn ----- Forwarded message from Daniel Eischen ----- Date: Sun, 2 Apr 2006 15:15:28 GMT From: Daniel Eischen To: glenn@more.net, deischen@FreeBSD.org, freebsd-threads@FreeBSD.org Subject: Re: threads/95127: MySQL 4.1 SIGBUS failiure with FreeBSD 6.0 Synopsis: MySQL 4.1 SIGBUS failiure with FreeBSD 6.0 State-Changed-From-To: open->closed State-Changed-By: deischen State-Changed-When: Sun Apr 2 15:14:44 UTC 2006 State-Changed-Why: This bug has been fixed in 6.x-stable and 7-current. http://www.freebsd.org/cgi/query-pr.cgi?pr=95127 ----- End forwarded message ----- ---------------------------------------------------------------------- Glenn Nielsen glenn@more.net | /* Spelin donut madder | MOREnet System Programming | * if iz ina coment. | Missouri Research and Education Network | */ | ---------------------------------------------------------------------- From owner-freebsd-database@FreeBSD.ORG Wed Apr 5 07:14:57 2006 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 0FB6216A423 for ; Wed, 5 Apr 2006 07:14:57 +0000 (UTC) (envelope-from rzr@viko.lt) Received: from mail.viko.lt (mail.viko.lt [193.219.128.3]) by mx1.FreeBSD.org (Postfix) with ESMTP id 8F02443D45 for ; Wed, 5 Apr 2006 07:14:56 +0000 (GMT) (envelope-from rzr@viko.lt) Received: from localhost (localhost.viko.lt [127.0.0.1]) by mail.viko.lt (Postfix) with ESMTP id C49B6E0562 for ; Wed, 5 Apr 2006 10:14:54 +0300 (EEST) Received: from mail.viko.lt ([127.0.0.1]) by localhost (mail.viko.lt [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 79269-10 for ; Wed, 5 Apr 2006 10:14:50 +0300 (EEST) Received: from [192.168.1.13] (user21.satnet.lt [82.135.152.54]) by mail.viko.lt (Postfix) with ESMTP id B3765E056A for ; Wed, 5 Apr 2006 10:14:49 +0300 (EEST) Message-ID: <44336E69.6000107@viko.lt> Date: Wed, 05 Apr 2006 10:14:49 +0300 From: Ovidijus User-Agent: Thunderbird 1.5 (Windows/20051201) MIME-Version: 1.0 To: freebsd-database@freebsd.org Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: amavisd-new at mail.viko.lt Subject: MySQL 4.1.18 startup problems in FreeBSD 6.1-PRERELEASE X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 05 Apr 2006 07:14:57 -0000 Hi, My test box using the stable FreeBSD 6.1-PRERELEASE and from the ports system installed MySQL 4.1.18. The problem is: after reboot my test box, MySQL don't wakeup at startup, but manually (/usr/local/etc/rc.d/mysql-server start) it starts and works fine. Maybe it some bug? 1. In rc.conf i put this line as usually: mysql_enable="YES" 2. Datadir looks fine too: # ls -l /var/db/mysql/ total 20534 -rw-rw---- 1 mysql mysql 5242880 Apr 4 23:52 ib_logfile0 -rw-rw---- 1 mysql mysql 5242880 Apr 4 23:48 ib_logfile1 -rw-rw---- 1 mysql mysql 10485760 Apr 4 23:52 ibdata1 -rw-rw---- 1 mysql mysql 1316 Apr 4 23:52 test.err drwx------ 2 mysql mysql 1536 Apr 4 23:48 mysql drwx------ 2 mysql mysql 512 Apr 4 23:48 test After that, i tried to change "mysql" user to "root" into mysql startup script, but i got the same problem. Thanks for any comments. -- Ovidijus Boiko VIKO From owner-freebsd-database@FreeBSD.ORG Wed Apr 5 11:57:36 2006 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 7AA3116A420 for ; Wed, 5 Apr 2006 11:57:36 +0000 (UTC) (envelope-from rzr@viko.lt) Received: from mail.viko.lt (mail.viko.lt [193.219.128.3]) by mx1.FreeBSD.org (Postfix) with ESMTP id E69A743D94 for ; Wed, 5 Apr 2006 11:56:59 +0000 (GMT) (envelope-from rzr@viko.lt) Received: from localhost (localhost.viko.lt [127.0.0.1]) by mail.viko.lt (Postfix) with ESMTP id 5925DE0698 for ; Wed, 5 Apr 2006 14:56:55 +0300 (EEST) Received: from mail.viko.lt ([127.0.0.1]) by localhost (mail.viko.lt [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 20933-07 for ; Wed, 5 Apr 2006 14:56:51 +0300 (EEST) Received: from [192.168.1.13] (user21.satnet.lt [82.135.152.54]) by mail.viko.lt (Postfix) with ESMTP id 67D17E063E for ; Wed, 5 Apr 2006 14:56:51 +0300 (EEST) Message-ID: <4433B084.1030009@viko.lt> Date: Wed, 05 Apr 2006 14:56:52 +0300 From: Ovidijus User-Agent: Thunderbird 1.5 (Windows/20051201) MIME-Version: 1.0 To: freebsd-database@freebsd.org Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: amavisd-new at mail.viko.lt Subject: MySQL 4.1.18 startup problems in FreeBSD 6.1-PRERELEASE X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 05 Apr 2006 11:57:36 -0000 I found what was the point of this problem: by default mysql startup script was named as /usr/local/etc/rc.d/mysql-server. Solution: rename it with .sh extension :-) -- Ovidijus Boiko VIKO