From owner-freebsd-questions@FreeBSD.ORG Thu Jun 19 16:10:07 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 E3B71106566C for ; Thu, 19 Jun 2008 16:10:06 +0000 (UTC) (envelope-from jeffrey@goldmark.org) Received: from out3.smtp.messagingengine.com (out3.smtp.messagingengine.com [66.111.4.27]) by mx1.freebsd.org (Postfix) with ESMTP id 917CD8FC18 for ; Thu, 19 Jun 2008 16:10:06 +0000 (UTC) (envelope-from jeffrey@goldmark.org) Received: from compute1.internal (compute1.internal [10.202.2.41]) by out1.messagingengine.com (Postfix) with ESMTP id CB575126EA0; Thu, 19 Jun 2008 12:10:05 -0400 (EDT) Received: from heartbeat2.messagingengine.com ([10.202.2.161]) by compute1.internal (MEProxy); Thu, 19 Jun 2008 12:10:05 -0400 X-Sasl-enc: PjV7kv7+gA6hmROFOERYWxa6fCjJI2IEsshrhNmnOiB+ 1213891805 Received: from hagrid.ewd.goldmark.org (n114.ewd.goldmark.org [72.64.118.114]) by mail.messagingengine.com (Postfix) with ESMTPSA id 3DA222DCA8; Thu, 19 Jun 2008 12:10:05 -0400 (EDT) Message-Id: From: Jeffrey Goldberg To: Paul Schmehl In-Reply-To: Content-Type: multipart/signed; boundary=Apple-Mail-2418--638597353; micalg=sha1; protocol="application/pkcs7-signature" Mime-Version: 1.0 (Apple Message framework v924) Date: Thu, 19 Jun 2008 11:09:57 -0500 References: <20080619035949.GB8205@shepherd> <4859FC8F.5020308@ibctech.ca> X-Mailer: Apple Mail (2.924) X-Content-Filtered-By: Mailman/MimeDel 2.1.5 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 16:10:07 -0000 --Apple-Mail-2418--638597353 Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit On Jun 19, 2008, at 9:40 AM, Paul Schmehl wrote: > As you can see from the df -i I posted (to which you responded), > inode exhaustion is not an issue. You are probably right about that, but could you also post the result of sudo tunefs -p /var That won't tell us what is in use, but it will confirm whether /var was set up with funky parameters or not. Also, the last time I ran out of inodes, the error messages made it clear that that was what was happening instead of merely giving a disk full error. > 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. That would be my guess. I haven't seen a mention of that of the mysql lists, but I don't follow the lists closely. (For the most part, I just go and clean out the mail folder they collect in every week or so.) Cheers, -j -- Jeffrey Goldberg http://www.goldmark.org/jeff/ --Apple-Mail-2418--638597353--