pkg-static: sqlite error while executing INSERT OR REPLACE INTO packages

[O. Hartmann]

Am Sat, 2 Aug 2014 15:30:36 +0200
Michael Gmelin <grembo at freebsd.org> schrieb:

> 
> 
> > On 02 Aug 2014, at 15:17, "O. Hartmann" <ohartman at zedat.fu-berlin.de> wrote:
> > 
> > 
> > 
> > Update of port windowmaker fails during registration with pkg:
> > 
> > 
> > ===>  Installing for windowmaker-0.95.5_4
> > ===>   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, flatsize,
> > 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 = ?14), NOW(), ?15) in file pkgdb.c:1595: FOREIGN KEY constraint failed
> > *** Error code 70
> > 
> > Box is running CURRENT and uptodate ports tree:
> > 
> > 
> > FreeBSD 11.0-CURRENT #1 r269391: Fri Aug  1 21:02:11 CEST 2014  
> > 
> > How to repair this? Seems strange ...
> > 
> > Please CC me.
> > 
> > Oliver
> 
> Which version of pkg? I had a similar issue on 1.3.3 that disappeared after 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

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 473 bytes
Desc: not available
URL: <http://lists.freebsd.org/pipermail/freebsd-ports/attachments/20140802/114fd387/attachment.sig>