Date: Sun, 3 Aug 2014 22:34:02 +0200 From: Michael Gmelin <grembo@freebsd.org> To: "O. Hartmann" <ohartman@zedat.fu-berlin.de> Cc: FreeBSD Ports <freebsd-ports@freebsd.org> Subject: Re: pkg-static: sqlite error while executing INSERT OR REPLACE INTO packages Message-ID: <F796FC2A-3D7F-4A2D-A257-1101A349F7C2@freebsd.org> In-Reply-To: <20140802160449.7c687631.ohartman@zedat.fu-berlin.de> References: <20140802151750.3deddd5f.ohartman@zedat.fu-berlin.de> <30A9F813-1DE0-431D-9D7E-E6C98C77818A@freebsd.org> <20140802160449.7c687631.ohartman@zedat.fu-berlin.de>
next in thread | previous in thread | raw e-mail | index | archive | help
> On 02 Aug 2014, at 16:04, "O. Hartmann" <ohartman@zedat.fu-berlin.de> wrot= e: >=20 > Am Sat, 2 Aug 2014 15:30:36 +0200 > Michael Gmelin <grembo@freebsd.org> schrieb: >=20 >>=20 >>=20 >>> On 02 Aug 2014, at 15:17, "O. Hartmann" <ohartman@zedat.fu-berlin.de> wr= ote: >>>=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 packages= ( origin, >>> name, version, comment, desc, message, arch, maintainer, www, prefix, fl= atsize, >>> automatic, licenselogic, mtree_id, time, manifestdigest) >>> VALUES( ?1, ?2, ?3, ?4, ?5, ?6, ?7, ?8, ?9, ?10, ?11, ?12, ?13, (SELECT i= d FROM mtree >>> WHERE content =3D ?14), NOW(), ?15) in file pkgdb.c:1595: FOREIGN KEY co= nstraint 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. >=20 > 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 >=20 > But it has been sticky since pkg 1.2.X >=20 Sounds to me like your db is corrupted. You should be able to fix this using= sqlite. If you get stuck and your pkgdb contains no secrets, feel free to mail it to= me off list, if I find the time I will take a look at it.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?F796FC2A-3D7F-4A2D-A257-1101A349F7C2>