From owner-freebsd-ports@FreeBSD.ORG Sat Aug 2 14:04:56 2014 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 ESMTPS id 23CDC581; Sat, 2 Aug 2014 14:04:56 +0000 (UTC) Received: from outpost1.zedat.fu-berlin.de (outpost1.zedat.fu-berlin.de [130.133.4.66]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id D40AB23E9; Sat, 2 Aug 2014 14:04:55 +0000 (UTC) Received: from inpost2.zedat.fu-berlin.de ([130.133.4.69]) by outpost.zedat.fu-berlin.de (Exim 4.82) with esmtp (envelope-from ) id <1XDZva-0017Ic-5O>; Sat, 02 Aug 2014 16:04:54 +0200 Received: from g225049112.adsl.alicedsl.de ([92.225.49.112] helo=thor.walstatt.dynvpn.de) by inpost2.zedat.fu-berlin.de (Exim 4.82) with esmtpsa (envelope-from ) id <1XDZva-0034Zg-1q>; Sat, 02 Aug 2014 16:04:54 +0200 Date: Sat, 2 Aug 2014 16:04:49 +0200 From: "O. Hartmann" To: Michael Gmelin Subject: Re: pkg-static: sqlite error while executing INSERT OR REPLACE INTO packages Message-ID: <20140802160449.7c687631.ohartman@zedat.fu-berlin.de> In-Reply-To: <30A9F813-1DE0-431D-9D7E-E6C98C77818A@freebsd.org> References: <20140802151750.3deddd5f.ohartman@zedat.fu-berlin.de> <30A9F813-1DE0-431D-9D7E-E6C98C77818A@freebsd.org> Organization: FU Berlin X-Mailer: Claws Mail 3.10.1 (GTK+ 2.24.22; amd64-portbld-freebsd11.0) MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; boundary="Sig_/qoGjEUNL8dWY=QQKLI5vxsd"; protocol="application/pgp-signature" X-Originating-IP: 92.225.49.112 X-ZEDAT-Hint: A Cc: FreeBSD Ports X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 02 Aug 2014 14:04:56 -0000 --Sig_/qoGjEUNL8dWY=QQKLI5vxsd Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Am Sat, 2 Aug 2014 15:30:36 +0200 Michael Gmelin schrieb: >=20 >=20 > > On 02 Aug 2014, at 15:17, "O. Hartmann" w= rote: > >=20 > >=20 > >=20 > > Update of port windowmaker fails during registration with pkg: > >=20 > >=20 > > =3D=3D=3D> Installing for windowmaker-0.95.5_4 > > =3D=3D=3D> Registering installation for windowmaker-0.95.5_4 > > pkg-static: sqlite error while executing INSERT OR REPLACE INTO package= s( origin, > > name, version, comment, desc, message, arch, maintainer, www, prefix, f= latsize, > > automatic, 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:1595: FOREIGN KEY c= onstraint failed > > *** Error code 70 > >=20 > > Box is running CURRENT and uptodate ports tree: > >=20 > >=20 > > FreeBSD 11.0-CURRENT #1 r269391: Fri Aug 1 21:02:11 CEST 2014 =20 > >=20 > > How to repair this? Seems strange ... > >=20 > > Please CC me. > >=20 > > Oliver >=20 > Which version of pkg? I had a similar issue on 1.3.3 that disappeared aft= er updating to > 1.3.4. pkg is up to date on the machine in question: name : pkg Version : 1.3.4 Installed on : Fri Aug 1 22:40:59 CEST 2014 Origin : ports-mgmt/pkg But it has been sticky since pkg 1.2.X --Sig_/qoGjEUNL8dWY=QQKLI5vxsd Content-Type: application/pgp-signature; name=signature.asc Content-Disposition: attachment; filename=signature.asc -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iQEcBAEBAgAGBQJT3PAFAAoJEOgBcD7A/5N8JRQH/iphPHrFB17fFQoY1hUJVqe+ BHtVw5f7CX9e0Fis08dO6N4jXcFvySdL2R3zqawBH1cztwqrfXg6T/CVT9r92+Q+ KSDxpS/968vO5y+az7TXi1eM7r/Ox9m9s0Q1kc+eFXv7KdLpx21F75po5N/NNaOz Ahly+V/5OXfyYb01uG1+8sMQdOP81scEtybAImA9c7CDVHho7dJ25uwDXVIWEf3H 0rcmQvNVF7Oa2KXhk2tg7ztEp15FR/6SbWPZMBaMZx3hMe4yFyFXCBKdO50Y3yjw rQTWuXirILZ4O7dlZ0C4/mNuuw8+pK85Za8TzWEuoBQpo2rs69fyNJtg/lIXWh0= =YwfX -----END PGP SIGNATURE----- --Sig_/qoGjEUNL8dWY=QQKLI5vxsd--