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

[Michael Gmelin]

> On 02 Aug 2014, at 16:04, "O. Hartmann" <ohartman at zedat.fu-berlin.de> wrote:
> 
> 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
> 
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.