From owner-freebsd-questions@FreeBSD.ORG Sun Dec 8 17:24:31 2013 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) (using TLSv1 with cipher ADH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id A088935C for ; Sun, 8 Dec 2013 17:24:31 +0000 (UTC) Received: from avasout08.plus.net (avasout08.plus.net [212.159.14.20]) by mx1.freebsd.org (Postfix) with ESMTP id F12DC1143 for ; Sun, 8 Dec 2013 17:24:30 +0000 (UTC) Received: from [192.168.1.68] ([31.185.194.24]) by avasout08 with smtp id z5QM1m0020Y3Cvz015QNxx; Sun, 08 Dec 2013 17:24:23 +0000 X-CM-Score: 0.00 X-CNFS-Analysis: v=2.1 cv=Rvb8ckWK c=1 sm=1 tr=0 a=nD1E1HL59k9I5EBiANpUSQ==:117 a=nD1E1HL59k9I5EBiANpUSQ==:17 a=0Bzu9jTXAAAA:8 a=2YU7Ix1lbqoA:10 a=QFqIbbMyswYA:10 a=ihvODaAuJD4A:10 a=EBOSESyhAAAA:8 a=XMZvbY3doRAA:10 a=r77TgQKjGQsHNAKrUKIA:9 a=9iDbn-4jx3cA:10 a=cKsnjEOsciEA:10 a=6I5d2MoRAAAA:8 a=WF2pI21SAAAA:8 a=Rl5zt_vRDQv0L03jJ3EA:9 a=wPNLvfGTeEIA:10 a=7h-0_gVHhOpnrfSzGJ4A:9 a=03aspSGdIk-6lH3S:21 a=Ln74Kn5zmgIVHyT9:21 a=Pvu-R9F2TZn3Pw0K:21 a=_W_S_7VecoQA:10 a=SV7veod9ZcQA:10 Message-ID: <52A4AB38.1020505@mansionfamily.plus.com> Date: Sun, 08 Dec 2013 17:24:08 +0000 From: james User-Agent: Mozilla/5.0 (Windows NT 6.2; WOW64; rv:17.0) Gecko/20130107 Thunderbird/17.0.2 MIME-Version: 1.0 To: Matthew Seaman Subject: Infinite pkg loop, was Re: pkg-ng problem, how do I recover? References: <529B4657.3040201@mansionfamily.plus.com> <529B7A6B.6020800@FreeBSD.org> In-Reply-To: <529B7A6B.6020800@FreeBSD.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Content-Filtered-By: Mailman/MimeDel 2.1.17 Cc: FreeBSD Mailing List X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.17 Precedence: list Reply-To: james@mansionfamily.plus.com List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 08 Dec 2013 17:24:31 -0000 On 01/12/2013 18:05, Matthew Seaman wrote: > On 01/12/2013 14:23, james wrote: >> >How can I recover from this? >> > >> >root@nas:~ # pkg update -f >> >Updating repository catalogue >> >digests.txz 100% 1093KB 1.1MB/s 1.1MB/s 00:01 >> >packagesite.txz 100% 5886KB 1.4MB/s 2.0MB/s 00:04 >> >pkg: sqlite: database disk image is malformed (pkgdb_repo.c:545) >> >Incremental update completed, 0 packages processed: >> >0 packages updated, 372 removed and 13769 added. >> >pkg: No digest falling back on legacy catalog format >> >pkg:http://pkg.FreeBSD.org/freebsd:9:x86:64/latest/repo.txz: Not Found >> >root@nas:~ # >> > >> >Earlier, I tried to pkgupgrade, but it seemed to get into a loop with >> >docbook claiming malformed info, so I quit that. >> > >> >This is: >> > >> >root@nas:~ # uname -a >> >FreeBSD nas 9.2-RELEASE FreeBSD 9.2-RELEASE #0 r255898: Thu Sep 26 >> >22:50:31 UTC 2013 >> >root@bake.isc.freebsd.org:/usr/obj/usr/src/sys/GENERIC amd64 >> >root@nas:~ # > If pkg(8) complains about a corrupted database, the first thing to try is: > > # rm /var/db/pkg/repo-*.sqlite > > The vast majority of the time this will cure the problem, and it's safe > enough to do, as everything in those repo-*.sqlite databases is derived > from repository catalogues which you can just download again. > > Cheers, > > Matthew > > -- Dr Matthew J Seaman MA, D.Phil. PGP: > http://www.infracaninophile.co.uk/pgpkey Thanks, I tried but when I do the original problem persists: root@nas:~ # pkg upgrade Updating repository catalogue digests.txz 100% 1092KB 1.1MB/s 1.1MB/s 00:01 packagesite.txz 100% 5877KB 1.9MB/s 1.4MB/s 00:03 pkg: Skipping malformed dependency docbook-xml pkg: Skipping malformed dependency docbook pkg: Skipping malformed dependency docbook-xml pkg: Skipping malformed dependency docbook pkg: Skipping malformed dependency docbook-xml pkg: Skipping malformed dependency docbook pkg: Skipping malformed dependency docbook-xml pkg: Skipping malformed dependency docbook pkg: Skipping malformed dependency docbook-xml pkg: Skipping malformed dependency docbook pkg: Skipping malformed dependency docbook-xml pkg: Skipping malformed dependency docbook pkg: Skipping malformed dependency docbook-xml pkg: Skipping malformed dependency docbook pkg: Skipping malformed dependency docbook-xml pkg: Skipping malformed dependency docbook pkg: Skipping malformed dependency docbook-xml pkg: Skipping malformed dependency docbook and so on, until I press Ctrl-C. And then then retry gives: root@nas:~ # pkg upgrade Updating repository catalogue pkg: sqlite: database disk image is malformed (pkgdb.c:3069) pkg: Unable to query repository root@nas:~ # pkg info thinks I don't have docbook or docbook-xml installed. Any ideas what I should do now? Its entirely repeatable if I delete the repo sqlite. James