From owner-freebsd-current@FreeBSD.ORG Fri Apr 3 13:33:08 2015 Return-Path: Delivered-To: freebsd-current@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 AFD2E436 for ; Fri, 3 Apr 2015 13:33:08 +0000 (UTC) Received: from outpost1.zedat.fu-berlin.de (outpost1.zedat.fu-berlin.de [130.133.4.66]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 66702A79 for ; Fri, 3 Apr 2015 13:33:07 +0000 (UTC) Received: from inpost2.zedat.fu-berlin.de ([130.133.4.69]) by outpost.zedat.fu-berlin.de (Exim 4.85) for freebsd-current@freebsd.org with esmtp (envelope-from ) id <1Ye1iW-001AGh-G3>; Fri, 03 Apr 2015 15:33:00 +0200 Received: from x5ce2b0a4.dyn.telefonica.de ([92.226.176.164] helo=thor.walstatt.dynvpn.de) by inpost2.zedat.fu-berlin.de (Exim 4.85) for freebsd-current@freebsd.org with esmtpsa (envelope-from ) id <1Ye1iW-002UxT-Be>; Fri, 03 Apr 2015 15:33:00 +0200 Date: Fri, 3 Apr 2015 15:32:55 +0200 From: "O. Hartmann" To: FreeBSD CURRENT Subject: pkg-static: sqlite error while executing INSERT OR REPLACE INTO Message-ID: <20150403153255.6d281130.ohartman@zedat.fu-berlin.de> Organization: FU Berlin X-Mailer: Claws Mail 3.11.1 (GTK+ 2.24.27; amd64-portbld-freebsd11.0) MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha256; boundary="Sig_/NhKZU/4+8fmCLtkSux2hJof"; protocol="application/pgp-signature" X-Originating-IP: 92.226.176.164 X-ZEDAT-Hint: A X-BeenThere: freebsd-current@freebsd.org X-Mailman-Version: 2.1.18-1 Precedence: list List-Id: Discussions about the use of FreeBSD-current List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 03 Apr 2015 13:33:08 -0000 --Sig_/NhKZU/4+8fmCLtkSux2hJof Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable On a CURRENT system (FreeBSD 11.0-CURRENT #0 r280991: Thu Apr 2 19:01:05 C= EST 2015) with most recent SVN tree revision of /usr/ports (Revision: 383115) I run i= nto a very nasty/sticky problem, which prevents updating/reinstalling/deleting port textproc/clucene, see below. I tried to reinstall/recompile sqlite and all requisite ports, but with no = effect. I maintain my ports in the traditional/flexible FreeBSD style by compiling th= em - not using packages. I also tried to use pkg to install the port in question, see this error ben= eath the error when using portmaster: "portmaster -da" / or "portmaster clucene" [...] =3D=3D=3D>>> Starting check for runtime dependencies =3D=3D=3D>>> Gathering dependency list for textproc/clucene from ports =3D=3D=3D>>> No dependencies for textproc/clucene =3D=3D=3D> Installing for clucene-2.3.3.4_6 =3D=3D=3D> Registering installation for clucene-2.3.3.4_6 Installing clucene-2.3.3.4_6... pkg-static: sqlite error while executing INSERT OR REPLACE INTO packages( o= rigin, name, version, comment, desc, message, arch, maintainer, www, prefix, flatsize, a= utomatic, licenselogic, mtree_id, time, manifestdigest) VALUES( ?1, ?2, ?3, ?4, ?5, ?6, ?7, ?8, ?9, ?10, ?11, ?12, ?13, (SELECT id = FROM mtree WHERE content =3D ?14), NOW(), ?15) in file pkgdb.c:1602: FOREIGN KEY const= raint failed *** Error code 70 Stop. make: stopped in /usr/ports/textproc/clucene root: [ports] pkg install textproc/clucene Updating FreeBSD repository catalogue... FreeBSD repository is up-to-date. All repositories are up-to-date. Checking integrity...Assertion failed: (strcmp(uid, p->uid) !=3D 0), functi= on pkg_conflicts_check_local_path, file pkg_jobs_conflicts.c, line 360. Child = process pid=3D49420 terminated abnormally: Abort trap Can somebody help? Regards, Oliver --Sig_/NhKZU/4+8fmCLtkSux2hJof Content-Type: application/pgp-signature Content-Description: OpenPGP digital signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iQEcBAEBCAAGBQJVHpaHAAoJEOgBcD7A/5N8BzIIAKcqoBb6QfutLVfsjeStaDQI QQ3EJ13x1wM2VNWqwINEstAFdX/pmhR2GWINA1pk7BBTg4JuvAs5jh2yUHh3iWEV 8H2LSu3A83lzcxy9GaMNLHIQEmEoCo2P5L/jSc5bPbKXGrpmjiLWvXwqgIpeAfZY aGpC/B5WsNWn5AWocrrUSN5W8DR+ldh9vIIqS7lUluEbJaGvT1A1zcZEWkVpk2TM xqz/tTgmK4ibUxClJ4o2Vo6TimfwZdgw7svVsrFDKIWFwi5jIEkZSSYoU7OWE4g0 M308x88If9cNveYIP3E0I4D433JCJxHWJEX/ZivR1SEZOBUf4pLQf5pLGhsuP7k= =orsH -----END PGP SIGNATURE----- --Sig_/NhKZU/4+8fmCLtkSux2hJof--