Date: Wed, 13 May 2015 07:47:54 +0000 From: =?utf-8?Q?Reve=20Trip?= <manager.revetrip.yahoo.com@send.mailchimpapp.com> To: =?utf-8?Q??= <ports@freebsd.org> Subject: =?utf-8?Q?Greece=20=2D=20In=20the=20Footsteps=20of=20St.=20Paul=20with=20Islands=20Cruise?= Message-ID: <167c6a6f77f69d6f455b5e2c5ce4a82b1c7.20150513074741@mail193.atl21.rsgsv.net>
next in thread | raw e-mail | index | archive | help
Visit Greece on Land and Cruise (http://revetrip.us10.list-manage.com/trac= k/click?u=3D167c6a6f77f69d6f455b5e2c5&id=3D151f0c0e9a&e=3Dce4a82b1c7= ) View this email in your browser (http://us10.campaign-archive1.com/?u=3D16= 7c6a6f77f69d6f455b5e2c5&id=3D4c1bf42239&e=3Dce4a82b1c7) http://revetrip.us10.list-manage.com/track/click?u=3D167c6a6f77f69d6f455b5= e2c5&id=3Dea2c6a4066&e=3Dce4a82b1c7 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Copyright =C2=A9 2015 Reve Trip=2C All rights reserved. Glad to design your dream trips Our mailing address is: Reve Trip Lebanon Nabay Beirut 00961 Lebanon ** unsubscribe from this list (http://revetrip.us10.list-manage2.com/unsub= scribe?u=3D167c6a6f77f69d6f455b5e2c5&id=3Ddcdf8c4acb&e=3Dce4a82b1c7&c=3D4c1b= f42239) ** update subscription preferences (http://revetrip.us10.list-manage.com/p= rofile?u=3D167c6a6f77f69d6f455b5e2c5&id=3Ddcdf8c4acb&e=3Dce4a82b1c7) Email Marketing Powered by MailChimp http://www.mailchimp.com/monkey-rewards/?utm_source=3Dfreemium_newsletter&= utm_medium=3Demail&utm_campaign=3Dmonkey_rewards&aid=3D167c6a6f77f69d6f455= b5e2c5&afl=3D1 From owner-freebsd-ports@FreeBSD.ORG Wed May 13 08:12:47 2015 Return-Path: <owner-freebsd-ports@FreeBSD.ORG> Delivered-To: freebsd-ports@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [8.8.178.115]) (using TLSv1.2 with cipher AECDH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id 2437FDD5 for <freebsd-ports@freebsd.org>; Wed, 13 May 2015 08:12:47 +0000 (UTC) Received: from homiemail-a47.g.dreamhost.com (sub5.mail.dreamhost.com [208.113.200.129]) by mx1.freebsd.org (Postfix) with ESMTP id 091D01F80 for <freebsd-ports@freebsd.org>; Wed, 13 May 2015 08:12:46 +0000 (UTC) Received: from homiemail-a47.g.dreamhost.com (localhost [127.0.0.1]) by homiemail-a47.g.dreamhost.com (Postfix) with ESMTP id 4760028405B; Wed, 13 May 2015 01:12:46 -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=ow4IPysJWJnjR1R4J03+0rgByNo=; b= sSXnZ3QL4t22JqK8JmfpDjK95VG/Nhn1pnbGbzpEX5rrAIhsB0tkSRaVClppLGT0 ShjsDsP3yFcGY55dP1arNMCf9XVrDkvNSdRK6r3C0hdCQNTgAEciUYOy8ZyaieOd wwoNmmPkmcg1ws3ZD2yuLjoCAer7BUsLA8DnEnpsbc0= 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-a47.g.dreamhost.com (Postfix) with ESMTPSA id 08D34284058; Wed, 13 May 2015 01:12:46 -0700 (PDT) Received: by blizzard.ozzmosis.com (Postfix, from userid 1001) id 701A35CC5; Wed, 13 May 2015 18:12:44 +1000 (AEST) Date: Wed, 13 May 2015 18:12:44 +1000 From: andrew clarke <mail@ozzmosis.com> To: Scott Bennett <bennett@sdf.org> Cc: freebsd-ports@freebsd.org Subject: Re: damage to pkg's sqlite data base Message-ID: <20150513081244.GB18834@ozzmosis.com> References: <201505120617.t4C6HkA3019096@sdf.org> <0dcbdcb9fdfdebc53a2563b11494f61b@ultimatedns.net> <201505130512.t4D5Cpqa011080@sdf.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <201505130512.t4D5Cpqa011080@sdf.org> 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 <freebsd-ports.freebsd.org> List-Unsubscribe: <http://lists.freebsd.org/mailman/options/freebsd-ports>, <mailto:freebsd-ports-request@freebsd.org?subject=unsubscribe> List-Archive: <http://lists.freebsd.org/pipermail/freebsd-ports/>; List-Post: <mailto:freebsd-ports@freebsd.org> List-Help: <mailto:freebsd-ports-request@freebsd.org?subject=help> List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-ports>, <mailto:freebsd-ports-request@freebsd.org?subject=subscribe> X-List-Received-Date: Wed, 13 May 2015 08:12:47 -0000 On Wed 2015-05-13 00:12:51 UTC-0500, Scott Bennett (bennett@sdf.org) wrote: > > Simply rename your (now) corrupt db, and copy the backup over. > > However, if I do that, then what happens to all the ports that have > been updated or added since that version of the data base was backed up? > I have run "portmaster -a" (with some additional options) quite a few > times since the lang/gcc problem first appeared, so an old local.sqlite > will no longer accurately reflect what is currently installed. You can reinstall just those ports. Check /var/log/messages, eg. $ grep pkg /var/log/messages May 12 14:34:38 blizzard pkg: poudriere upgraded: 3.1.4 -> 3.1.6 May 12 14:38:08 blizzard pkg: git-lite-2.4.0 installed May 13 08:29:04 blizzard pkg: sqlite3 upgraded: 3.8.9_1 -> 3.8.10.1 May 13 08:29:05 blizzard pkg: spamassassin reinstalled: 3.4.1_1 -> 3.4.1_1 May 13 08:29:05 blizzard pkg: ca_root_nss upgraded: 3.18.1 -> 3.19 > > > 4) I was unable to find any instructions for recreating a pkg data > > > base if the data base gets damaged/destroyed. Is there a way to > > > do that that I missed? > > There must be a way to do this, right? I mean, really, it's pretty > fundamental that no new data base be put into production without a way to > rebuild it. The FreeBSD developers haven't really broken so ancient and > basic a principle, have they? So what's the trick? What is the method > to rebuild /var/db/pkg/local.sqlite from scratch based upon the currently > installed ports/packages? You can't rebuild it. You couldn't rebuild it in the years before pkgng existed, either. The "trick" is to revert to a known-good backup of the pkg database that's generated daily by /usr/local/etc/periodic/daily/411.pkg-backup in /var/backups/ : -rw-r--r-- 1 root wheel 2207320 2015-05-13 04:20:30 pkg.sql.xz -rw-r--r-- 1 root wheel 2196088 2015-05-12 04:21:24 pkg.sql.xz.2 The .sql.xz files are just a SQLite dump, in xz compressed format. Regards Andrew
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?167c6a6f77f69d6f455b5e2c5ce4a82b1c7.20150513074741>