From owner-freebsd-ports@FreeBSD.ORG Tue May 12 06:17:53 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 3743CE9A for ; Tue, 12 May 2015 06:17:53 +0000 (UTC) Received: from sdf.lonestar.org (mx.sdf.org [192.94.73.24]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client CN "mx.sdf.org", Issuer "SDF.ORG" (not verified)) by mx1.freebsd.org (Postfix) with ESMTPS id 001C91C04 for ; Tue, 12 May 2015 06:17:52 +0000 (UTC) Received: from sdf.org (IDENT:bennett@otaku.freeshell.org [192.94.73.9]) by sdf.lonestar.org (8.14.8/8.14.5) with ESMTP id t4C6HkdD009262 (using TLSv1/SSLv3 with cipher DHE-RSA-AES256-GCM-SHA384 (256 bits) verified NO) for ; Tue, 12 May 2015 06:17:46 GMT Received: (from bennett@localhost) by sdf.org (8.14.8/8.12.8/Submit) id t4C6HkA3019096 for freebsd-ports@freebsd.org; Tue, 12 May 2015 01:17:46 -0500 (CDT) From: Scott Bennett Message-Id: <201505120617.t4C6HkA3019096@sdf.org> Date: Tue, 12 May 2015 01:17:46 -0500 To: freebsd-ports@freebsd.org Subject: damage to pkg's sqlite data base User-Agent: Heirloom mailx 12.5 6/20/10 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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: Tue, 12 May 2015 06:17:53 -0000 For nearly two weeks I've been stymied by an apparently damaged record in the sqlite data base used by pkg(8) and pkg-static(8). Unfortunately, it is a record for a port that is depended upon rather heavily, lang/gcc. lang/gcc compiled and linked just fine, but any attempt to install the result ends up like this. ===> Checking if gcc already installed ===> Registering installation for gcc-4.8.4_3 Installing gcc-4.8.4_3... pkg-static: sqlite error while executing iterator in file pkgdb_iterator.c:931: database disk image is malformed pkg-static: sqlite error while executing INSERT OR REPLACE INTO files (path, sha256, package_id) VALUES (?1, ?2, ?3) in file pkgdb.c:1722: database disk image is malformed *** Error code 70 Stop. make: stopped in /usr/ports/lang/gcc I'm not familiar with sqlite commands, nor with the structure of the pkg data base, nor any of several other relevant topics. But I do have questions: 1) how might the damage have happened? 2) how might such an event be avoided/prevented in the future? 3) most urgently, how can I *fix* it? 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? Thanks again for any help here. Scott Bennett, Comm. ASMELG, CFIAG ********************************************************************** * Internet: bennett at sdf.org *xor* bennett at freeshell.org * *--------------------------------------------------------------------* * "A well regulated and disciplined militia, is at all times a good * * objection to the introduction of that bane of all free governments * * -- a standing army." * * -- Gov. John Hancock, New York Journal, 28 January 1790 * **********************************************************************