From owner-freebsd-threads@FreeBSD.ORG Thu Apr 15 00:51:39 2004 Return-Path: Delivered-To: freebsd-threads@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 1B96816A4CE for ; Thu, 15 Apr 2004 00:51:39 -0700 (PDT) Received: from rms04.rommon.net (rms04.rommon.net [212.54.2.140]) by mx1.FreeBSD.org (Postfix) with ESMTP id C6C0D43D5C for ; Thu, 15 Apr 2004 00:51:37 -0700 (PDT) (envelope-from pete@he.iki.fi) Received: from he.iki.fi (h91.vuokselantie10.fi [193.64.42.145]) by rms04.rommon.net (8.12.10/8.12.9) with ESMTP id i3F7oumo045963; Thu, 15 Apr 2004 10:50:57 +0300 (EEST) (envelope-from pete@he.iki.fi) Message-ID: <407E3EDB.8020508@he.iki.fi> Date: Thu, 15 Apr 2004 10:50:51 +0300 From: Petri Helenius User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.6) Gecko/20040113 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Julian Elischer References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit cc: threads@freebsd.org cc: Alexander@Leidinger.net cc: kenm@icarz.com Subject: Re: FBSD 5.2.CURRENT-p4 and mysqld problems X-BeenThere: freebsd-threads@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Threading on FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 15 Apr 2004 07:51:39 -0000 Julian Elischer wrote: > >I know nothing about Mysql >so I suggest you talk to petri.. >look in the threads mailing list archive.. look for MySQL. > > The same problem I have had since quite a while still persist. The problem is that after running for a while, mysqld stops responding to SIGTERM and a clean shutdown is not possible. I should probably check if this issue still persists with -CURRENT but just havenīt taken the time to upgrade our application test machines. (mostly because I havenīt had the time to check if going there would mean breaking some unrelated things) Iīll try to get there eventually. This is on 5.2.1-RELEASE-p1. Using libmap.conf of ; > cat /etc/libmap.conf libc_r.so.5 libkse.so.1 libc_r.so libkse.so > ps axH |grep mysql 651 ?? IL 1194:05,89 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql 651 ?? IL 1194:05,89 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql 651 ?? IL 1194:05,89 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql 651 ?? SL 1194:05,89 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql 651 ?? SL 1194:05,89 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql 651 ?? SL 1194:05,89 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql 651 ?? SL 1194:05,89 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql 651 ?? SL 1194:05,89 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql 651 ?? IL 1194:05,89 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql 651 ?? IL 1194:05,89 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql 651 ?? IL 1194:05,89 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql 651 ?? SL 1194:05,89 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql 651 ?? SL 1194:05,89 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql 651 ?? SL 1194:05,89 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql 30988 p4 DL+ 0:00,00 grep mysql 574 con- IL 0:00,02 /bin/sh /usr/local/bin/mysqld_safe --user=mysql --datadir=/var/db/mysql --pid-file=/ Pete