From owner-freebsd-questions@FreeBSD.ORG Thu Jun 19 18:03:01 2008 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id A6F921065670 for ; Thu, 19 Jun 2008 18:03:01 +0000 (UTC) (envelope-from peter@boosten.org) Received: from smtpq2.tilbu1.nb.home.nl (smtpq2.tilbu1.nb.home.nl [213.51.146.201]) by mx1.freebsd.org (Postfix) with ESMTP id 545CA8FC1B for ; Thu, 19 Jun 2008 18:03:01 +0000 (UTC) (envelope-from peter@boosten.org) Received: from [213.51.146.188] (port=49989 helo=smtp3.tilbu1.nb.home.nl) by smtpq2.tilbu1.nb.home.nl with esmtp (Exim 4.60) (envelope-from ) id 1K9OTL-0004fi-Ni; Thu, 19 Jun 2008 20:02:59 +0200 Received: from cp268254-a.landg1.lb.home.nl ([84.25.65.88]:5007 helo=ra.egypt.nl) by smtp3.tilbu1.nb.home.nl with esmtp (Exim 4.60) (envelope-from ) id 1K9OTL-0004TI-A0; Thu, 19 Jun 2008 20:02:59 +0200 Received: from [127.0.0.1] (xp.egypt.nl [192.168.13.35]) by ra.egypt.nl (Postfix) with ESMTP id 9BEA93987B; Thu, 19 Jun 2008 20:02:58 +0200 (CEST) Message-ID: <485A9F53.4090306@boosten.org> Date: Thu, 19 Jun 2008 20:02:59 +0200 From: Peter Boosten User-Agent: Thunderbird 2.0.0.14 (Windows/20080421) MIME-Version: 1.0 To: Paul Schmehl References: <20080619035949.GB8205@shepherd> <4859FC8F.5020308@ibctech.ca> <421A1EE3E8C305AD72BBA2BE@utd65257.utdallas.edu> In-Reply-To: <421A1EE3E8C305AD72BBA2BE@utd65257.utdallas.edu> X-Enigmail-Version: 0.95.6 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Antivirus: avast! (VPS 080619-0, 06/19/2008), Outbound message X-Antivirus-Status: Clean X-Spam-Score: -0.0 (/) Cc: freebsd-questions@freebsd.org Subject: Re: /var full X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 19 Jun 2008 18:03:01 -0000 Paul Schmehl wrote: >> >>> I'm leaning toward some sort of bug in mysql version 5.0.51 which >>> creates a temporary file (in the wrong place) and then doesn't >>> release it until it exhausts the space on the drive. In any case, >>> I'm going to report it to the mysql folks as such and hope they can >>> figure out what the cause is. >> try to find the file with # fstat | grep var This will give a list with inodes for open files (the 6th column). # find /var -inum will the display the file (unless it has been deleted while still open - seen that once: restarting mysql probably will resolve that). Peter -- http://www.boosten.org