Package database problems

[Paul Schmehl]

--On November 16, 2017 at 11:23:34 AM -0800 Freddie Cash 
<fjwcash at gmail.com> wrote:

>
> ​There's nothing to iterate over.  There's nothing in /var/db/pkg
> anymore except the SQLite databases.

Then what is all this? (I'm only showing part of it.

 ls /var/db/pkg/
FreeBSD.meta				libXfixes-5.0.3				p5-Net-Domain-TLD-1.74 
	py27-qt4-dbussupport-4.12_1
ImageMagick-6.9.2.10,1			libXfont-1.5.2,2			p5-Package-Stash-0.37_1 
	py27-qt4-gui-4.11.4,1
ORBit2-2.14.19_2			libXft-2.3.2_1				p5-Package-Stash-XS-0.28_2 
	py27-setuptools-36.5.0
a2ps-4.13b_8				libXi-1.7.9,1				p5-Params-Util-1.07_2 
	py27-setuptools27-19.2
apache24-2.4.18				libXpm-3.5.12				p5-Params-Validate-1.29 
	py27-sip-4.19.2,1
apache24-2.4.29				libXrandr-1.5.1				p5-Params-ValidationCompiler-0.24 
	py27-six-1.11.0
apr-1.6.3.1.6.1				libXrender-0.9.10			p5-Role-Tiny-2.000006 
	py27-six-1.9.0
argp-standalone-1.3_3			libXt-1.1.5,1				p5-Specio-0.42 
	py27-snowballstemmer-1.2.0_1
atk-2.24.0				libXv-1.0.11,1				p5-Sub-Exporter-0.987_1 
	py27-sphinx-1.3.1_2
autoconf-2.69_1				libXvMC-1.0.10				p5-Sub-Exporter-Progressive-0.001013 
	py27-sphinx-1.4.8_2,1
autoconf-wrapper-20131203		libXxf86vm-1.1.4_1			p5-Sub-Identify-0.14 
	py27-sphinx_rtd_theme-0.1.8
automake-1.15.1				libarchive-3.3.2,1			p5-Sub-Install-0.928_1 
	py27-sphinx_rtd_theme-0.2.4
automake-wrapper-20131203		libatomic_ops-7.6.0_1			p5-Sub-Quote-2.004000 
	py27-sqlite3-2.7.11_7
avahi-app-0.6.31_5			libcheck-0.10.0				p5-TimeDate-2.30_2,1 
	py27-tkinter-2.7.11_6
bacula-client-7.2.0_3			libclc-0.3.0.20170927			p5-Try-Tiny-0.28 
	py27-tkinter-2.7.14_6
bareos-client-static-16.2.6		libcroco-0.6.11				p5-Variable-Magic-0.62 
	pydbus-common-1.2.0_1
bash-4.4.12_3				libdaemon-0.14_1			p5-XML-Parser-2.44			python27-2.7.14_1
bdftopcf-1.0.5				libdevq-0.0.4				p5-namespace-autoclean-0.28 
	python35-3.5.4
bigreqsproto-1.1.2			libdrm-2.4.88,1				p5-namespace-clean-0.27 
	qpdf-6.0.0_1
binutils-2.28,1				libedit-3.1.20170329_2,1		pango-1.36.8_2 
	qscintilla2-2.9.1,1
bison-3.0.4,1				libev-4.22,1				pango-1.40.6				qt4-assistant-4.8.7
boehm-gc-7.6.0				libevent-2.1.8				pciids-20171021				qt4-clucene-4.8.7
boost-docs-1.65.1			libevent2-2.0.22_1			pcre-8.40_1				qt4-clucene-4.8.7_1
boost-jam-1.65.1			libffi-3.2.1_1				pecl-APCu-5.1.8_1			qt4-corelib-4.8.7_9
>
>
> The only way to "rebuild" local.sqlite is to reinstall everything.

Well that sucks, because I CAN'T reinstall everything, since the supposed 
conflicts are preventing it. Are you saying to delete the database and then 
reinstall every port to build a new db? Good lord. I'm already into my 
second day of trying to fix this problem, and I've got tons of problems.

Paul Schmehl, Retired
As if it wasn't already obvious, my opinions
are my own and not those of my employer.
*******************************************
"It is as useless to argue with those who have
renounced the use of reason as to administer
medication to the dead." Thomas Jefferson
"There are some ideas so wrong that only a very
intelligent person could believe in them." George Orwell