From owner-freebsd-questions@FreeBSD.ORG Tue Dec 16 01:48:22 2014 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [8.8.178.115]) (using TLSv1.2 with cipher AECDH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id 39ACA743 for ; Tue, 16 Dec 2014 01:48:22 +0000 (UTC) Received: from www81.your-server.de (www81.your-server.de [213.133.104.81]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id D0B68C98 for ; Tue, 16 Dec 2014 01:48:21 +0000 (UTC) Received: from [24.134.156.212] (helo=michael-think.fritz.box) by www81.your-server.de with esmtpsa (TLSv1:DHE-RSA-AES256-SHA:256) (Exim 4.80.1) (envelope-from ) id 1Y0gxn-0005oX-Ob for freebsd-questions@freebsd.org; Tue, 16 Dec 2014 02:30:11 +0100 Content-Type: text/plain; charset=iso-8859-15; format=flowed; delsp=yes Subject: pkg upgrade Problem: loop between packages, sqlite error To: "freebsd-questions@FreeBSD.org" Date: Tue, 16 Dec 2014 02:30:05 +0100 MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: "Michael Ross" Message-ID: User-Agent: Opera Mail/1.0 (Win32) X-Authenticated-Sender: gmx@ross.cx X-Virus-Scanned: Clear (ClamAV 0.98.4/19785/Mon Dec 15 22:47:20 2014) X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.18-1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 16 Dec 2014 01:48:22 -0000 Hello, pkg 1.4.0 FreeBSD 11.0-CURRENT #3 r275326 I'm trying to upgrade my packages, and pkg keeps toggling between two ghostscript versions and keeps upgrading the same packages over and over again "ABI changed". After I uninstall ghostscript, pkg just keeps upgrading the same packages over and over again. Reinstalling all packages "pkg upgrade -f " bombs until I manually remove db42-4.2.52_5 db48-4.8.30.0_2 db-1.14,2 db5-5.3.28_2 Now "pkg upgrade -f" does no longer bomb, but "pkg upgrade" keeps upgrading the same packages over and over again "ABI changed". Once again I install GraphicsMagick-1.3.20, this pulls in ghostscript9-9.06_9 The swap-ghostscript against ghostscript-nox11-loop ad infinitum starts again. I do not know how to proceed here, please help. Postscript: I've updated to FreeBSD 11.0-CURRENT #5 r275815. Now "pkg upgrade -f" works, else still all the same. ( Is this (in part) because I'm running -CURRENT? First time I try -CURRENT, I do not know too much about eventual gotchas? Went all smooth on 10.1 ) Details: 1st run of "pkg upgrade": The following 54 packages will be affected (of 0 checked): Installed packages to be REMOVED: ghostscript9-9.06_9 New packages to be INSTALLED: ghostscript9-nox11: 9.06_9 [FreeBSD] 2nd run of "pkg upgrade": The following 54 packages will be affected (of 0 checked): Installed packages to be REMOVED: ghostscript9-nox11-9.06_9 New packages to be INSTALLED: ghostscript9: 9.06_9 [FreeBSD] 3rd run like 1st run. Now I try "pkg upgrade -f": Updating FreeBSD repository catalogue... FreeBSD repository is up-to-date. Updating gurder repository catalogue... gurder repository is up-to-date. All repositories are up-to-date. Checking for upgrades (327 candidates): 92% db42 has no direct installation candidates, change it to db? [Y/n]: Checking for upgrades (327 candidates): 100% Processing candidates (327 candidates): 100% pkg: sqlite error while executing UPDATE packages SET name=?1 WHERE name=?2; in file pkg_jobs.c:1601: UNIQUE constraint failed: packages.name Checking integrity...pkg: cannot load files from tiff to check integrity pkg: cannot load files from python27 to check integrity pkg: cannot load files from py27-pytz to check integrity pkg: cannot load files from png to check integrity pkg: cannot load files from perl5 to check integrity pkg: cannot load files from pcre to check integrity pkg: cannot load files from p5-Locale-gettext to check integrity pkg: cannot load files from nginx to check integrity pkg: cannot load files from mysql56-server to check integrity pkg: cannot load files from mysql56-client to check integrity pkg: cannot load files from libxml2 to check integrity pkg: cannot load files from libxcb to check integrity pkg: cannot load files from libidn to check integrity pkg: cannot load files from libgpg-error to check integrity pkg: cannot load files from libXext to check integrity pkg: cannot load files from jpeg to check integrity pkg: cannot load files from gmake to check integrity pkg: cannot load files from ghostscript9-nox11 to check integrity pkg: cannot load files from gettext to check integrity pkg: cannot load files from freetype2 to check integrity pkg: cannot load files from expat to check integrity pkg: cannot load files from exim to check integrity Assertion failed: (strcmp(uid, p->uid) != 0), function pkg_conflicts_check_local_path, file pkg_jobs_conflicts.c, line 350. Child process pid=10094 terminated abnormally: Abort trap I remove the ghostscript port with "pkg delete ghostscript9-nox11-9.06_9". I try "pkg upgrade" again. It reinstalls 51 packages: xproto-7.0.26 [FreeBSD] (ABI changed) xextproto-7.3.0 [FreeBSD] (ABI changed) svgalib-1.4.3_7 [FreeBSD] (ABI changed) screen-4.2.1_3 [gurder] (ABI changed) python2-2_3 [gurder] (ABI changed) py27-zope.interface-3.8.0_1 [gurder] (ABI changed) py27-twistedWords-14.0.0 [gurder] (ABI changed) py27-twistedWeb-14.0.0 [gurder] (ABI changed) py27-twistedRunner-14.0.0 [gurder] (ABI changed) py27-twistedPair-14.0.0 [gurder] (ABI changed) py27-twistedNews-14.0.0 [gurder] (ABI changed) py27-twistedNames-14.0.0 [gurder] (ABI changed) py27-twistedMail-14.0.0 [gurder] (ABI changed) py27-twistedLore-14.0.0 [gurder] (ABI changed) py27-twistedCore-14.0.0 [gurder] (ABI changed) py27-twistedConch-14.0.0 [gurder] (ABI changed) py27-twisted-14.0.0 [gurder] (ABI changed) py27-tornado-4.0.2 [gurder] (ABI changed) py27-setuptools27-5.5.1 [gurder] (ABI changed) py27-pygments-1.6_2 [gurder] (ABI changed) py27-futures-2.1.6 [gurder] (ABI changed) py27-docutils-0.12 [gurder] (ABI changed) py27-certifi-14.05.14 [gurder] (ABI changed) py27-backports.ssl_match_hostname-3.4.0.2 [gurder] (ABI changed) py27-asn1-0.1.7,1 [FreeBSD] (ABI changed) py27-Babel-1.3_2 [gurder] (ABI changed) pkgconf-0.9.7 [FreeBSD] (ABI changed) m4-1.4.17_1,1 [gurder] (ABI changed) libpthread-stubs-0.3_6 [FreeBSD] (ABI changed) libpaper-1.1.24.3 [FreeBSD] (ABI changed) libgcrypt-1.6.1_5 [gurder] (ABI changed) libXt-1.1.4_2,1 [FreeBSD] (ABI changed) libXdmcp-1.1.1_2 [gurder] (ABI changed) libXau-1.0.8_2 [FreeBSD] (ABI changed) libX11-1.6.2_2,1 [gurder] (ABI changed) libSM-1.2.2_2,1 [gurder] (ABI changed) libICE-1.0.9,1 [FreeBSD] (ABI changed) lcms2-2.6_3 [gurder] (ABI changed) kbproto-1.0.6 [FreeBSD] (ABI changed) jbigkit-2.1_1 [FreeBSD] (ABI changed) jbig2dec-0.11_2 [gurder] (ABI changed) jasper-1.900.1_14 [gurder] (ABI changed) indexinfo-0.2 [FreeBSD] (ABI changed) help2man-1.43.3_1 [gurder] (ABI changed) gsfonts-8.11_6 [FreeBSD] (ABI changed) cups-image-1.7.3_1 [gurder] (ABI changed) cups-client-1.7.3_2 [FreeBSD] (ABI changed) cmake-modules-3.0.2 [FreeBSD] (ABI changed) cmake-3.0.2 [gurder] (ABI changed) autoconf-wrapper-20131203 [FreeBSD] (ABI changed) autoconf-2.69 [gurder] (ABI changed) This again loops, i. e. these packages get reinstalled on every "pkg upgrade" run. I try "pkg upgrade -f": Checking for upgrades (322 candidates): 93% db42 has no direct installation candidates, change it to db? [Y/n]: Y Checking for upgrades (322 candidates): 100% Processing candidates (322 candidates): 100% pkg: sqlite error while executing UPDATE packages SET name=?1 WHERE name=?2; in file pkg_jobs.c:1601: UNIQUE constraint failed: packages.name Checking integrity...pkg: cannot load files from tiff to check integrity pkg: cannot load files from python27 to check integrity pkg: cannot load files from py27-pytz to check integrity pkg: cannot load files from png to check integrity pkg: cannot load files from perl5 to check integrity pkg: cannot load files from pcre to check integrity pkg: cannot load files from p5-Locale-gettext to check integrity pkg: cannot load files from nginx to check integrity pkg: cannot load files from mysql56-server to check integrity pkg: cannot load files from mysql56-client to check integrity pkg: cannot load files from libxml2 to check integrity pkg: cannot load files from libxcb to check integrity pkg: cannot load files from libidn to check integrity pkg: cannot load files from libgpg-error to check integrity pkg: cannot load files from libXext to check integrity pkg: cannot load files from jpeg to check integrity pkg: cannot load files from gmake to check integrity pkg: cannot load files from gettext to check integrity pkg: cannot load files from freetype2 to check integrity pkg: cannot load files from expat to check integrity pkg: cannot load files from exim to check integrity Assertion failed: (strcmp(uid, p->uid) != 0), function pkg_conflicts_check_local_path, file pkg_jobs_conflicts.c, line 350. Child process pid=10913 terminated abnormally: Abort trap Answering "no" to the db42 change question yields: Checking for upgrades (325 candidates): 92% db42 has no direct installation candidates, change it to db? [Y/n]: n db42 has no direct installation candidates, change it to db? [Y/n]: n db42 has no direct installation candidates, change it to db48? [Y/n]: n db42 has no direct installation candidates, change it to db5? [Y/n]: n db42 has no direct installation candidates, change it to db6? [Y/n]: n Checking for upgrades (325 candidates): 100% Processing candidates (325 candidates): 100% Checking integrity...pkg: cannot load files from tiff to check integrity pkg: cannot load files from python27 to check integrity pkg: cannot load files from py27-pytz to check integrity pkg: cannot load files from png to check integrity pkg: cannot load files from perl5 to check integrity pkg: cannot load files from pcre to check integrity pkg: cannot load files from p5-Locale-gettext to check integrity Assertion failed: (pkgdb_ensure_loaded(j->db, p2, PKG_LOAD_FILES|PKG_LOAD_DIRS) == EPKG_OK), function pkg_conflicts_need_conflict, file pkg_jobs_conflicts.c, line 211. Child process pid=10467 terminated abnormally: Abort trap "pkg check -d -a": Checking all packages: 0% devel/autoconf has a missing dependency: lang/perl5.16 Checking all packages: 18% misc/help2man has a missing dependency: lang/perl5.16 Checking all packages: 78% ftp/py-pyftpdlib has a missing dependency: devel/py-distribute Checking all packages: 100% >>> Missing package dependencies were detected. >>> Found 2 issue(s) in the package database. pkg: No packages available to install matching 'devel/py-distribute' have been found in the repositories >>> Summary of actions performed: lang/perl5.16 dependency failed to be fixed devel/py-distribute dependency failed to be fixed >>> There are still missing dependencies. >>> You are advised to try fixing them manually. >>> Also make sure to check 'pkg updating' for known issues. "pkg check -B -a": pkg: fstat() failed for(/usr/local/bin/envsubst): No such file or directory pkg: fstat() failed for(/usr/local/bin/gettext): No such file or directory pkg: fstat() failed for(/usr/local/bin/gettext.sh): No such file or directory pkg: fstat() failed for(/usr/local/bin/ngettext): No such file or directory pkg: fstat() failed for(/usr/local/include/autosprintf.h): No such file or directory pkg: fstat() failed for(/usr/local/include/libintl.h): No such file or directory pkg: fstat() failed for(/usr/local/info/autosprintf.info): No such file or directory pkg: fstat() failed for(/usr/local/lib/libasprintf.a): No such file or directory pkg: fstat() failed for(/usr/local/lib/libasprintf.so): No such file or directory pkg: fstat() failed for(/usr/local/lib/libasprintf.so.0): No such file or directory pkg: fstat() failed for(/usr/local/lib/libintl.a): No such file or directory pkg: fstat() failed for(/usr/local/lib/libintl.so): No such file or directory pkg: fstat() failed for(/usr/local/lib/libintl.so.9): No such file or directory pkg: fstat() failed for(/usr/local/man/man1/envsubst.1.gz): No such file or directory pkg: fstat() failed for(/usr/local/man/man1/gettext.1.gz): No such file or directory pkg: fstat() failed for(/usr/local/man/man1/ngettext.1.gz): No such file or directory pkg: fstat() failed for(/usr/local/man/man3/bind_textdomain_codeset.3.gz): No such file or directory pkg: fstat() failed for(/usr/local/man/man3/bindtextdomain.3.gz): No such file or directory pkg: fstat() failed for(/usr/local/man/man3/dcgettext.3.gz): No such file or directory pkg: fstat() failed for(/usr/local/man/man3/dcngettext.3.gz): No such file or directory pkg: fstat() failed for(/usr/local/man/man3/dgettext.3.gz): No such file or directory pkg: fstat() failed for(/usr/local/man/man3/dngettext.3.gz): No such file or directory pkg: fstat() failed for(/usr/local/man/man3/gettext.3.gz): No such file or directory pkg: fstat() failed for(/usr/local/man/man3/ngettext.3.gz): No such file or directory pkg: fstat() failed for(/usr/local/man/man3/textdomain.3.gz): No such file or directory pkg: fstat() failed for(/usr/local/share/gettext/ABOUT-NLS): No such file or directory pkg: fstat() failed for(/usr/local/share/locale/ko/LC_MESSAGES/gettext-runtime.mo): No such file or directory pkg: fstat() failed for(/usr/local/share/locale/locale.alias): No such file or directory pkg: fstat() failed for(/usr/local/share/locale/nb/LC_MESSAGES/gettext-runtime.mo): No such file or directory pkg: fstat() failed for(/usr/local/share/locale/nl/LC_MESSAGES/gettext-runtime.mo): No such file or directory pkg: fstat() failed for(/usr/local/share/locale/nn/LC_MESSAGES/gettext-runtime.mo): No such file or directory pkg: fstat() failed for(/usr/local/share/locale/pl/LC_MESSAGES/gettext-runtime.mo): No such file or directory pkg: fstat() failed for(/usr/local/share/locale/pt/LC_MESSAGES/gettext-runtime.mo): No such file or directory pkg: fstat() failed for(/usr/local/share/locale/pt_BR/LC_MESSAGES/gettext-runtime.mo): No such file or directory pkg: fstat() failed for(/usr/local/share/locale/ro/LC_MESSAGES/gettext-runtime.mo): No such file or directory pkg: fstat() failed for(/usr/local/share/locale/ru/LC_MESSAGES/gettext-runtime.mo): No such file or directory pkg: fstat() failed for(/usr/local/share/locale/sk/LC_MESSAGES/gettext-runtime.mo): No such file or directory pkg: fstat() failed for(/usr/local/share/locale/sl/LC_MESSAGES/gettext-runtime.mo): No such file or directory pkg: fstat() failed for(/usr/local/share/locale/sr/LC_MESSAGES/gettext-runtime.mo): No such file or directory pkg: fstat() failed for(/usr/local/share/locale/sv/LC_MESSAGES/gettext-runtime.mo): No such file or directory pkg: fstat() failed for(/usr/local/share/locale/tr/LC_MESSAGES/gettext-runtime.mo): No such file or directory pkg: fstat() failed for(/usr/local/share/locale/uk/LC_MESSAGES/gettext-runtime.mo): No such file or directory pkg: fstat() failed for(/usr/local/share/locale/vi/LC_MESSAGES/gettext-runtime.mo): No such file or directory pkg: fstat() failed for(/usr/local/share/locale/zh_CN/LC_MESSAGES/gettext-runtime.mo): No such file or directory pkg: fstat() failed for(/usr/local/share/locale/zh_HK/LC_MESSAGES/gettext-runtime.mo): No such file or directory pkg: fstat() failed for(/usr/local/share/locale/zh_TW/LC_MESSAGES/gettext-runtime.mo): No such file or directory