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

[Michael Gmelin]

> 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.