From owner-freebsd-ports@FreeBSD.ORG Wed May 13 14:04:35 2015 Return-Path: Delivered-To: freebsd-ports@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) (using TLSv1.2 with cipher AECDH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id B32403AF for ; Wed, 13 May 2015 14:04:35 +0000 (UTC) Received: from udns.ultimatedns.net (unknown [IPv6:2602:d1:b4d6:e600:4261:86ff:fef6:aa2a]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 2A8061DF3 for ; Wed, 13 May 2015 14:04:34 +0000 (UTC) Received: from ultimatedns.net (localhost [127.0.0.1]) by udns.ultimatedns.net (8.14.9/8.14.9) with ESMTP id t4DE4vda064137; Wed, 13 May 2015 07:05:04 -0700 (PDT) (envelope-from bsd-lists@bsdforge.com) To: andrew clarke Cc: In-Reply-To: <20150513082611.GA19960@ozzmosis.com> References: <201505120617.t4C6HkA3019096@sdf.org> <0dcbdcb9fdfdebc53a2563b11494f61b@ultimatedns.net> <201505130512.t4D5Cpqa011080@sdf.org> <5f1749d3e664fbb487aa98f160e6cf92@ultimatedns.net>, <20150513082611.GA19960@ozzmosis.com> From: "Chris H" Subject: Re: damage to pkg's sqlite data base Date: Wed, 13 May 2015 07:05:04 -0700 Content-Type: text/plain; charset=UTF-8; format=fixed MIME-Version: 1.0 Message-id: <70aef0efb16a2d046fab3c5c24779e9d@ultimatedns.net> Content-Transfer-Encoding: 8bit X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.20 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 13 May 2015 14:04:35 -0000 On Wed, 13 May 2015 18:26:11 +1000 andrew clarke wrote > On Tue 2015-05-12 23:47:02 UTC-0700, Chris H (bsd-lists@bsdforge.com) wrote: > > > I whined about it the first time my DB blew up. It's become > > corrupted several times since on different boxes/versions. *but* > > after the first time, I made it a habit of making a copy of it *before* > > embarking on an upgrade, or install of any ports. > > Can you post a link to your message and/or a link to your FreeBSD PR on > Bugzilla? > > I use FreeBSD on a number of machines (bare metal & virtual) and have > never encountered local.sqlite corruption, and maybe I haven't been > paying attention but I haven't noticed anyone else mention it on the > list until now. > > As I said to the OP, if you encounter this problem and you're sure > it's not caused externally (hardware or filesystem corruption) then > it's probably worthwhile making your corrupted local.sqlite available > somewhere for it to be looked at by someone who understands SQLite. That's exactly what I did. In fact, Bapt asked for the DB, which I happily provided. While I've run into the problem several times, and on different hardware/FreeBSD versions, I've only mentioned it once, and it was on the mailing list. On the upside, I (knock on wood) haven't run into the problem for at least 2 mos. So here's hoping that work that's been done has [at least] *minimized* the likelihood of DB corruption. :) > > Regards > Andrew > _______________________________________________ > freebsd-ports@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-ports > To unsubscribe, send any mail to "freebsd-ports-unsubscribe@freebsd.org" --Chris --