From owner-freebsd-ports@FreeBSD.ORG Wed May 13 08:26:14 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 5A07A222 for ; Wed, 13 May 2015 08:26:14 +0000 (UTC) Received: from homiemail-a57.g.dreamhost.com (sub5.mail.dreamhost.com [208.113.200.129]) by mx1.freebsd.org (Postfix) with ESMTP id 3E15110ED for ; Wed, 13 May 2015 08:26:13 +0000 (UTC) Received: from homiemail-a57.g.dreamhost.com (localhost [127.0.0.1]) by homiemail-a57.g.dreamhost.com (Postfix) with ESMTP id 5AB2020806D; Wed, 13 May 2015 01:26:13 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha1; c=relaxed; d=ozzmosis.com; h=date:from :to:cc:subject:message-id:references:mime-version:content-type: in-reply-to; s=ozzmosis.com; bh=JHhY3zLEa+vxvuZLSJk2OTWBLbg=; b= NqfExuyrv5lc2zaThfQ5bj/jNj0nh5qG+0I/JX9pNHBZygP/gAv7hwjx9wJdi9ET IsWamVYEE+P8ePubumtEAhvIQnXgAxCnOTCn9vqobbasvHT9AoDRwyCl0JVoJG1N X44slQBJFTJaflwfNv44IN2jHheL5UYdyYtLPjgVG0o= Received: from blizzard.ozzmosis.com (124-170-17-20.dyn.iinet.net.au [124.170.17.20]) (using TLSv1 with cipher ADH-AES256-SHA (256/256 bits)) (No client certificate requested) (Authenticated sender: relay@ozzmosis.com) by homiemail-a57.g.dreamhost.com (Postfix) with ESMTPSA id 22445208063; Wed, 13 May 2015 01:26:13 -0700 (PDT) Received: by blizzard.ozzmosis.com (Postfix, from userid 1001) id 8773D5CCC; Wed, 13 May 2015 18:26:11 +1000 (AEST) Date: Wed, 13 May 2015 18:26:11 +1000 From: andrew clarke To: Chris H Cc: freebsd-ports@freebsd.org Subject: Re: damage to pkg's sqlite data base Message-ID: <20150513082611.GA19960@ozzmosis.com> References: <201505120617.t4C6HkA3019096@sdf.org> <0dcbdcb9fdfdebc53a2563b11494f61b@ultimatedns.net> <201505130512.t4D5Cpqa011080@sdf.org> <5f1749d3e664fbb487aa98f160e6cf92@ultimatedns.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <5f1749d3e664fbb487aa98f160e6cf92@ultimatedns.net> User-Agent: Mutt/1.5.23 (2014-03-12) 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 08:26:14 -0000 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. Regards Andrew