From owner-freebsd-questions@FreeBSD.ORG Wed Mar 21 17:49:14 2007 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 0F9B116A4CB for ; Wed, 21 Mar 2007 17:49:14 +0000 (UTC) (envelope-from cswiger@mac.com) Received: from mail-out4.apple.com (mail-out4.apple.com [17.254.13.23]) by mx1.freebsd.org (Postfix) with ESMTP id EC10913C448 for ; Wed, 21 Mar 2007 17:49:13 +0000 (UTC) (envelope-from cswiger@mac.com) Received: from relay5.apple.com (a17-128-113-35.apple.com [17.128.113.35]) by mail-out4.apple.com (8.13.8/8.13.8) with ESMTP id l2LHn7U1009290; Wed, 21 Mar 2007 10:49:07 -0700 (PDT) Received: from relay5.apple.com (unknown [127.0.0.1]) by relay5.apple.com (Symantec Mail Security) with ESMTP id 691E329C002; Wed, 21 Mar 2007 10:49:07 -0700 (PDT) X-AuditID: 11807123-afe2ebb000005a91-17-46017013070e Received: from [17.214.13.96] (cswiger1.apple.com [17.214.13.96]) (using TLSv1 with cipher AES128-SHA (128/128 bits)) (No client certificate requested) by relay5.apple.com (Apple SCV relay) with ESMTP id 5F6FE30400E; Wed, 21 Mar 2007 10:49:07 -0700 (PDT) In-Reply-To: <20070321141600.M10788@ezo.net> References: <20070321141600.M10788@ezo.net> Mime-Version: 1.0 (Apple Message framework v752.2) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <89B49790-595F-4082-8D0B-26589BE4FE4F@mac.com> Content-Transfer-Encoding: 7bit From: Chuck Swiger Date: Wed, 21 Mar 2007 10:49:06 -0700 To: jflowers@ezo.net X-Mailer: Apple Mail (2.752.2) X-Brightmail-Tracker: AAAAAA== Cc: freebsd-questions@freebsd.org Subject: Re: Mysql Unlinked Files 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: Wed, 21 Mar 2007 17:49:14 -0000 On Mar 21, 2007, at 7:24 AM, Jim Flowers wrote: > On startup of mysql-server 5.0.12 on FBSD 5.4-RELEASE my server > always has 3 > 0-size unreferenced files with 69 links reported by lsof +L1. > > 23 groups of: > mysqld 6179 mysql 6u VREG 4,17 0 0 9 /var (/ > dev/aacd0s1d) > mysqld 6179 mysql 7u VREG 4,17 0 0 23 /var (/ > dev/aacd0s1d) > mysqld 6179 mysql 11u VREG 4,17 0 0 24 /var (/ > dev/aacd0s1d) > > This doesn't cause problems but I am curious as to what is causing > it and if I > could do anything to fix it? Do they go away if you kill mysqld? If not, consider rebooting to single-user mode or off of a CD, and running fsck by hand on /var... -- -Chuck