textproc/clucene: pkg-static: sqlite error while executing INSERT OR REPLACE INTO packages
Since today's CURRENT update (running FreeBSD 11.0-CURRENT #1 r280149: Mon Mar 16 19:41:00 CET 2015 amd64) I receive this nasty error on a box while updating ports: textproc/clucene: Installing clucene-2.3.3.4_5... 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 something went wrong after the system's update and I have no clue what it could mean. Filesystem doesn't seem to be corrupted. Is there a way to solve this problem? Please CC me, I'm not subscribing the list. Regards and thanks in advance, Oliver pgpYusxawXAKM.pgp Description: OpenPGP digital signature
Re: pkg-static: sqlite error while executing INSERT OR REPLACE INTO packages
On 02 Aug 2014, at 16:04, O. Hartmann ohart...@zedat.fu-berlin.de wrote: Am Sat, 2 Aug 2014 15:30:36 +0200 Michael Gmelin gre...@freebsd.org schrieb: On 02 Aug 2014, at 15:17, O. Hartmann ohart...@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. ___ freebsd-ports@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-ports To unsubscribe, send any mail to freebsd-ports-unsubscr...@freebsd.org
pkg-static: sqlite error while executing INSERT OR REPLACE INTO packages
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 signature.asc Description: PGP signature
Re: pkg-static: sqlite error while executing INSERT OR REPLACE INTO packages
On 02 Aug 2014, at 15:17, O. Hartmann ohart...@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. ___ freebsd-ports@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-ports To unsubscribe, send any mail to freebsd-ports-unsubscr...@freebsd.org
Re: pkg-static: sqlite error while executing INSERT OR REPLACE INTO packages
Am Sat, 2 Aug 2014 15:30:36 +0200 Michael Gmelin gre...@freebsd.org schrieb: On 02 Aug 2014, at 15:17, O. Hartmann ohart...@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 signature.asc Description: PGP signature
