From owner-freebsd-stable@FreeBSD.ORG Wed Nov 19 00:21:32 2014 Return-Path: Delivered-To: freebsd-stable@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 262C2386; Wed, 19 Nov 2014 00:21:32 +0000 (UTC) Received: from mail-wi0-x235.google.com (mail-wi0-x235.google.com [IPv6:2a00:1450:400c:c05::235]) (using TLSv1 with cipher ECDHE-RSA-RC4-SHA (128/128 bits)) (Client CN "smtp.gmail.com", Issuer "Google Internet Authority G2" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id A5819A3D; Wed, 19 Nov 2014 00:21:31 +0000 (UTC) Received: by mail-wi0-f181.google.com with SMTP id r20so127591wiv.2 for ; Tue, 18 Nov 2014 16:21:30 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=sender:date:from:to:cc:subject:message-id:references:mime-version :content-type:content-disposition:in-reply-to:user-agent; bh=eHp8wGyVNIetBBao/HN5xT5xavclZKAYZ3BLEPX8Kyg=; b=WC84JxtLETC9sKvKdeMhuFX4h3F/e5K6yiWkcAM++B/BnCCtQl5ZQduXMTVdHkNfcl KCA4TIYVY5jqxMj8/zN6nErFUtQbobLwHWL1l7HUUhe+sgvVoYNDRDWCPJqwoHmxBJzs IZ1NhTl/x4NSwQZ5EQkkm1CaPZ9mvQ6C/W1ShRpnxElLOrTZGaNTBh/5DZInI9yxJPic eZab1H47C6i00UN6EzeLnBR4zKAdrnqVHwFoxEHMesedB7IiYDHuz3eXt/ksdi67lllG YErUkJ3dXDgooAfhnENDrj4Wo4vbRQyeA3FPEXpeRF3/Ckxae0E+W7c78E4m1ODTqesw oSFQ== X-Received: by 10.194.59.17 with SMTP id v17mr7976888wjq.130.1416356490148; Tue, 18 Nov 2014 16:21:30 -0800 (PST) Received: from ivaldir.etoilebsd.net ([2001:41d0:8:db4c::1]) by mx.google.com with ESMTPSA id bj7sm43127wjc.33.2014.11.18.16.21.28 for (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Tue, 18 Nov 2014 16:21:29 -0800 (PST) Sender: Baptiste Daroussin Date: Wed, 19 Nov 2014 01:21:27 +0100 From: Baptiste Daroussin To: Chris H Subject: Re: How to recover local.sqlite (pkg(8) problem) Message-ID: <20141119002126.GN48896@ivaldir.etoilebsd.net> References: <61ee02eda8e8d3c86fadc175453ffb68@ultimatedns.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="5FetH82qe0Z6y/zI" Content-Disposition: inline In-Reply-To: <61ee02eda8e8d3c86fadc175453ffb68@ultimatedns.net> User-Agent: Mutt/1.5.23 (2014-03-12) Cc: FreeBSD STABLE , FreeBSD ports X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.18-1 Precedence: list List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 19 Nov 2014 00:21:32 -0000 --5FetH82qe0Z6y/zI Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Tue, Nov 18, 2014 at 04:18:33PM -0800, Chris H wrote: > Greetings, > During the building of a meta-port in the ports tree. My > /var/db/pkg/local.sqlite database became corrupted. I > spent some time, both with the pkg man pages, and with > sqlite3 itself attempting to use one of the backups > created by periodic(8). Located in /var/backups. But all > to no avail. For the record, I used > pkg backup -r /var/backup/pkg.sql.xz, as well as unpacking > a copy of that file, and issuing the same. Moving (renaming) > the corrupted database aside, prior to. I also issued > sqlite3 local.sqlite > followed by > read pkg.sql > and > quit > went w/o issue. But issuing > pkg info > emitted several error messages. Which appeared to be from > sqlite3(8). > This is on RELENG_9, w/source, and kernel world from about > 1 week ago. I know that the backup is in good shape, as I > had been using it w/o issue. > Is this a bug? >=20 > Thank you for all your time, and consideration. >=20 This is really surprising and first time this can of things get reported, c= an you provide me the the pkg.sql.xz file? Are you runing on nfs? if yes start the lockd first (pkg should fallback on= a working solution (I need to check for pkg backup) but sqlite3 cli tool does= not and sqlite3 cli tool on nfs without proper locking is known to corrupt data= base file. Best regards, Bapt --5FetH82qe0Z6y/zI Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iEYEARECAAYFAlRr4oYACgkQ8kTtMUmk6EyEnACffZfQHllsKs84dCUTt1328xTM TMMAoKf5hPCHC6b1c8BJw8vV5wpZ96Vi =7X7Y -----END PGP SIGNATURE----- --5FetH82qe0Z6y/zI--