From owner-freebsd-ports@FreeBSD.ORG Wed May 13 08:03:02 2015 Return-Path: Delivered-To: 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 B5798A1E for ; Wed, 13 May 2015 08:03:02 +0000 (UTC) Received: from mail193.atl21.rsgsv.net (mail193.atl21.rsgsv.net [205.201.133.193]) by mx1.freebsd.org (Postfix) with ESMTP id 7B50D1E59 for ; Wed, 13 May 2015 08:03:02 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; s=k1; d=mail193.atl21.rsgsv.net; h=Subject:From:Reply-To:To:Date:Message-ID:List-ID:List-Unsubscribe:Sender:Content-Type:MIME-Version; i=manager.revetrip=3Dyahoo.com@mail193.atl21.rsgsv.net; bh=zLam/dQLKlkeujxdl6z37TDfHqM=; b=AVcqLPx5sf7URDaJZhLDJfyFFxReg9M/or5g8nsxP6kksy7AT3zzvtbAtT6crCu1Hn9JOuDfDbJY ZG3VZQv1rZrT9lsrzvOU6OqrtE+cqP5MKFYRyAgN3S2xypYidDViTMW6AbQukwtbLPJeNwOLCYiu aScEamUu0YXDX8IPs6s= DomainKey-Signature: a=rsa-sha1; c=nofws; q=dns; s=k1; d=mail193.atl21.rsgsv.net; b=dDSfB4Vq0acjdkzeeXs0DRWNhGUehaUClO8sbicKjpKCbtJ7nGgOUAvvdlSmbPL8Z0BqEjtIWNo7 T/htd94YZUqBnfEmYrw+4sTKocFIduCNeaX9DrIJTb03UoFAuNeIAo4+T0nDcB/QxUh20oRxMAk8 +H5YP0xqHptqLMzoHKc=; Received: from (127.0.0.1) by mail193.atl21.rsgsv.net id hac2jc1lgi4o for ; Wed, 13 May 2015 07:47:54 +0000 (envelope-from ) Subject: =?utf-8?Q?Greece=20=2D=20In=20the=20Footsteps=20of=20St.=20Paul=20with=20Islands=20Cruise?= From: =?utf-8?Q?Reve=20Trip?= Reply-To: To: =?utf-8?Q??= Date: Wed, 13 May 2015 07:47:54 +0000 Message-ID: <167c6a6f77f69d6f455b5e2c5ce4a82b1c7.20150513074741@mail193.atl21.rsgsv.net> X-Mailer: MailChimp Mailer - **CID4c1bf42239ce4a82b1c7** X-Campaign: mailchimp167c6a6f77f69d6f455b5e2c5.4c1bf42239 X-campaignid: mailchimp167c6a6f77f69d6f455b5e2c5.4c1bf42239 X-Report-Abuse: Please report abuse for this campaign here: http://www.mailchimp.com/abuse/abuse.phtml?u=167c6a6f77f69d6f455b5e2c5&id=4c1bf42239&e=ce4a82b1c7 X-MC-User: 167c6a6f77f69d6f455b5e2c5 X-Feedback-ID: 42106093:42106093.242421:us10:mc X-Accounttype: ff X-Original-Sender: manager.revetrip@yahoo.com Sender: "Reve Trip" x-mcda: FALSE MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8"; format="fixed" Content-Transfer-Encoding: quoted-printable X-Content-Filtered-By: Mailman/MimeDel 2.1.20 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:03:02 -0000 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: 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 ; 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 ; 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 To: Scott Bennett 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-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