Date: Sat, 28 Mar 2015 10:58:07 +0100 From: "O. Hartmann" <ohartman@zedat.fu-berlin.de> To: FreeBSD Ports <freebsd-ports@freebsd.org> Subject: pkg-static: sqlite error while executing INSERT OR REPLACE INTO Message-ID: <20150328105807.7db95a09.ohartman@zedat.fu-berlin.de>
next in thread | raw e-mail | index | archive | help
--Sig_/D0LJeZmGEwNUtTA6E4w6cfj Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable I can not update/reinstall port textproc/clucene due to the following error= message: [...] =3D=3D=3D> Installing for clucene-2.3.3.4_6 =3D=3D=3D> Registering installation for clucene-2.3.3.4_6 Installing clucene-2.3.3.4_6... pkg-static: sqlite error while executing INSERT OR REPLACE INTO packages( o= rigin, name, version, comment, desc, message, arch, maintainer, www, prefix, flatsize, a= utomatic, 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 =3D ?14), NOW(), ?15) in file pkgdb.c:1602: FOREIGN KEY const= raint failed *** Error code 70 [...] It seems that the sql statement gets trapped in some inconsistent databasef= ile 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, Oliver --Sig_/D0LJeZmGEwNUtTA6E4w6cfj Content-Type: application/pgp-signature Content-Description: OpenPGP digital signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iQEcBAEBCAAGBQJVFnsvAAoJEOgBcD7A/5N8w/4H/jrr8cfozT7WyPM319Br2sfI +6iXBeijOu6daaytTfTNuk3T7otrrClAAtDVtU1J6zoTPliU3fWwOFoZLuN15Gbi lhDeYjjILllV1PHPO1RO5IRZtz+Ut0es8oAhD1JejHVMiGeJ6VOcdrhTUx5avpMl tfvASMYRU9gJyjdUYH9QsCEuk/DUk6G7jgYcQCvUvirsYO5+asqOdDU21umP99wv ghjNDFu4cN26fA1FHKMuSjqezqCYSZRADP95617lhhhMGiz5I3cXKVqeiEVBn39k wD4MwISWYA4uCUosbxxq9pzJeM61Zd2slG8MSc7+zklrpJ3Lw7UF80cM8lykSy8= =sVXM -----END PGP SIGNATURE----- --Sig_/D0LJeZmGEwNUtTA6E4w6cfj--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20150328105807.7db95a09.ohartman>