Date: Mon, 5 Aug 2013 14:00:20 +0300 From: Kimmo Paasiala <kpaasial@gmail.com> To: Thomas Mueller <mueller6724@bellsouth.net> Cc: freebsd-ports@freebsd.org Subject: Re: libpkg, sqlite and database problems prevent building any packages Message-ID: <CA%2B7WWSfDFLZWL4dqfNvWrE783hxuarrL_LrNDitxe_8r_WYyYA@mail.gmail.com> In-Reply-To: <506913.46359.bm@smtp105.sbc.mail.bf1.yahoo.com> References: <506913.46359.bm@smtp105.sbc.mail.bf1.yahoo.com>
next in thread | previous in thread | raw e-mail | index | archive | help
On Mon, Aug 5, 2013 at 1:42 PM, Thomas Mueller
<mueller6724@bellsouth.net> 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 <flags> 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CA%2B7WWSfDFLZWL4dqfNvWrE783hxuarrL_LrNDitxe_8r_WYyYA>