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

O. Hartmann ohartman at
Sat Mar 28 10:01:36 UTC 2015

I can not update/reinstall port textproc/clucene due to the following error message:

===>  Installing for clucene-
===>   Registering installation for clucene-
Installing clucene-
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:1602: FOREIGN KEY constraint failed ***
Error code 70

It seems that the sql statement gets trapped in some inconsistent databasefile and I do
not know how to fix this problem.

How can I fix/repair this issue if related to a sqlite problem?

The system is
FreeBSD 11.0-CURRENT #2 r280457: Tue Mar 24 21:30:21 CET 2015 amd64,
the /usr/ports tree is at Revision: 382449, I use "portmaster" as the tool of choice.

Please CC me, do not subscribe this list.

Regards and thanks in advance,
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 473 bytes
Desc: OpenPGP digital signature
URL: <>

More information about the freebsd-ports mailing list