Pkg Upgrade failing after upgrading from 13.5 to 14.4

[smnbldwn]

I have upgraded from 13.5 to 14.4 and the process went ok except that when I try to upgrade the packages, I get an error when it tries to delete Apache Openoffice.

Deleting files for apache-commons-logging-1.3.5_2: 100%
pkg: sqlite error while executing DELETE FROM shlibs WHERE id NOT IN (SELECT DISTINCT shlib_id FROM pkg_shlibs_required)AND id NOT IN (SELECT DISTINCT shlib_id FROM pkg_shlibs_provided); in file pkgdb.c:2427: FOREIGN KEY constraint failed

This stops the whole process, is there a way to just clear out the offending package and start again?

 

[Hiroo Ono]

I had run into similar problem, but I do not remember well how I solved it.

first, pkg-static upgrade pkg
then, pkg upgrade

works?
If not, try pkg remove -f apache-commons-logging.

You may need to check if you are missing some packages and install them as needed.

 

[Beastie]

You need to upgrade all of your packages anyway so why not just save yourself the trouble: backup anything you may want to keep from /usr/local and then nuke the entire thing (pkg databases and /usr/local) and reinstall your packages.
It will even be a bit faster than letting pkg do all its checks and uninstalling-reinstalling.