From owner-freebsd-ports@FreeBSD.ORG Mon Aug 5 11:00:21 2013 Return-Path: Delivered-To: freebsd-ports@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 ESMTP id D18F5BB5 for ; Mon, 5 Aug 2013 11:00:21 +0000 (UTC) (envelope-from kpaasial@gmail.com) Received: from mail-qc0-x235.google.com (mail-qc0-x235.google.com [IPv6:2607:f8b0:400d:c01::235]) (using TLSv1 with cipher ECDHE-RSA-RC4-SHA (128/128 bits)) (No client certificate requested) by mx1.freebsd.org (Postfix) with ESMTPS id 93DBC24E3 for ; Mon, 5 Aug 2013 11:00:21 +0000 (UTC) Received: by mail-qc0-f181.google.com with SMTP id k15so1577616qcv.40 for ; Mon, 05 Aug 2013 04:00:20 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; bh=+hoppdYR61MQvUCLdjiCoGipwNeYGJjtCA3SbyJppj8=; b=UyrxExRqMsdQgbJGPxY+Nggz7UQ4oQGWHpeYDUCqJ/pm5UySDH7eflT7Qpg0I/60// XJ2CS1Pj3oEYRM9xXAC0TbwkcVSL9gYOYPwFs285czhxTUba2KRCwMvuQGjHDw2Vk+zl EO8lAVw4e2La5hTlXvtinyF9OPqcjZL3p6hc5n+W7TeqnAfnJ8aJlNymc9aQ/PahdTqH LF4ptHwFoo8Tb/7PtNYZCz2a0LNYDjMlNFXfGNR21xG6+u8r8vd0UM97IrU9dnnpKEwl M0BFBa9A+YjHeO05lksMwlQPDHh3iCTAgnq7MOllq8M/tvehNrGEPGQMIbdohsf/ae7L ZNYw== MIME-Version: 1.0 X-Received: by 10.224.67.8 with SMTP id p8mr28201735qai.5.1375700420419; Mon, 05 Aug 2013 04:00:20 -0700 (PDT) Received: by 10.224.78.194 with HTTP; Mon, 5 Aug 2013 04:00:20 -0700 (PDT) In-Reply-To: <506913.46359.bm@smtp105.sbc.mail.bf1.yahoo.com> References: <506913.46359.bm@smtp105.sbc.mail.bf1.yahoo.com> Date: Mon, 5 Aug 2013 14:00:20 +0300 Message-ID: Subject: Re: libpkg, sqlite and database problems prevent building any packages From: Kimmo Paasiala To: Thomas Mueller Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Cc: freebsd-ports@freebsd.org X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 05 Aug 2013 11:00:21 -0000 On Mon, Aug 5, 2013 at 1:42 PM, Thomas Mueller wrote: > I have smaller FreeBSD 9.1-STABLE and 9.2-BETA2 installations that I upda= te less frequently than the main hard-drive installation. > > On the USB-stick installations, I find I can't upgrade or build any ports= because of a database mess. I get error messages mentioning sqlite even f= or packages that don't depend on sqlite3. > > I tried to build or upgrade devel/subversion, ports-mgmt/pkg, databases/s= qlite3 and ports-mgmt/portmaster, and get error messages every time like > > =3D=3D=3D>>> Starting check for runtime dependencies > =3D=3D=3D>>> Gathering dependency list for ports-mgmt/pkg from ports > pkg-static: warning: database version 19 is newer than libpkg(3) version = 12, but still compatible > pkg-static: sqlite: no such column: infos (pkgdb.c:1086) > =3D=3D=3D>>> No dependencies for ports-mgmt/pkg > > pkg-static: warning: database version 19 is newer than libpkg(3) version = 12, but still compatible > pkg-static: sqlite: no such column: infos (pkgdb.c:1086) > pkg-static: warning: database version 19 is newer than libpkg(3) version = 12, but still compatible > pkg-static: sqlite: no such column: infos (pkgdb.c:1086) > =3D=3D=3D> Installing for pkg-1.1.4_1 > =3D=3D=3D> Generating temporary packing list > =3D=3D=3D> Checking if ports-mgmt/pkg already installed > pkg-static: warning: database version 19 is newer than libpkg(3) version = 12, but still compatible > pkg-static: sqlite: no such column: infos (pkgdb.c:1086) > *** [check-already-installed] Error code 74 > > Stop in /BETA1/usr/ports/ports-mgmt/pkg. > *** [/BETA1/usr/ports/ports-mgmt/pkg/worki386/.install_done.pkg._usr_loca= l] Error code 1 > > Stop in /BETA1/usr/ports/ports-mgmt/pkg. > > =3D=3D=3D>>> Installation of pkg-1.1.4_1 (ports-mgmt/pkg) failed > =3D=3D=3D>>> Aborting update > > =3D=3D=3D>>> Update for ports-mgmt/pkg failed > =3D=3D=3D>>> Aborting update > > =3D=3D=3D>>> Update for converters/libiconv failed > =3D=3D=3D>>> Aborting update > > =3D=3D=3D>>> Update for devel/gettext failed > =3D=3D=3D>>> Aborting update > > =3D=3D=3D>>> Update for devel/gmake failed > =3D=3D=3D>>> Aborting update > > =3D=3D=3D>>> Update for devel/icu failed > =3D=3D=3D>>> Aborting update > > =3D=3D=3D>>> Killing background jobs > Terminated > > =3D=3D=3D>>> You can restart from the point of failure with this command = line: > portmaster databases/sqlite3 devel/icu devel/gmake devel/g= ettext converters/libiconv ports-mgmt/pkg > > =3D=3D=3D>>> Exiting > > > I also get messages even when running pkg, this is the new pkgng. > > You might want to see my /etc/make.conf . > > Main hard drive installation: > > > PORTSDIR=3D/BETA1/usr/ports > PACKAGES=3D/usr/packages > WRKDIR=3D${.CURDIR}/work9amd64 > # WITH_NEW_XORG=3Dyes > # WITH_KMS=3Dyes > WITH_PKGNG=3Dyes > OPTIONS_SET=3DDOCS NLS > mpop_SET=3DGNUTLS NLS > # added by use.perl 2013-06-16 03:51:03 > PERL_VERSION=3D5.16.3 > > > for USB-stick installation with 9.2-BETA2 amd64: > > > PORTSDIR=3D/BETA1/usr/ports > PACKAGES=3D/usr/packages > WRKDIR=3D${.CURDIR}/workusb64 > WITH_PKGNG=3Dyes > OPTIONS_SET.mpop=3DGNUTLS NLS > # added by use.perl 2012-09-23 09:49:32 > PERL_VERSION=3D5.14.2 > > > for USB-stick installation with 9.1-STABLE i386: > > > PORTSDIR=3D/BETA1/usr/ports > PACKAGES=3D/usr/packages > WRKDIR=3D${.CURDIR}/worki386 > # WITH_NEW_XORG=3Dyes > # WITH_KMS=3Dyes > WITH_PKGNG=3Dyes > OPTIONS_SET=3DDOCS NLS > # WITHOUT_MODULES=3D usb/ulpt # This does not work > SRC_BASE=3D/STABLE1/usr/src > # added by use.perl 2013-06-17 12:56:10 > PERL_VERSION=3D5.16.3 > > > I know there was a major change in database format when subversion was up= dated in ports from 1.7 to 1.8, but would this cause the problems that are = driving me crazy? There ought to be a way to resolve this, but I can't see= what to do, everything I try leads to the same error messages. > > Tom > This has nothing to do with subversion. Your pkg(8) client is out of date compared to the /var/db/pkg/local.sqlite database. -Kimmo