Date: Tue, 16 Dec 2014 02:30:05 +0100 From: "Michael Ross" <gmx@ross.cx> To: "freebsd-questions@FreeBSD.org" <freebsd-questions@freebsd.org> Subject: pkg upgrade Problem: loop between packages, sqlite error Message-ID: <op.xqxs4fnwg7njmm@michael-think.fritz.box>
next in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?op.xqxs4fnwg7njmm>