pkg upgrade Problem: loop between packages, sqlite error

Michael Ross gmx at ross.cx
Tue Dec 16 01:48:22 UTC 2014


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


More information about the freebsd-questions mailing list