I keep my own pkgdb server built using poudriere. With the upgrade from pkg 1.2.7 to 1.3.2, the local copy of the pkg repo has to be removed in order for many packages to successfully download and upgrade.



[root@projects]# pkg upgrade
Updating repository catalogue
digests.txz                         100%   28KB  28.5KB/s  28.5KB/s   00:00
packagesite.txz                     100%  149KB 149.2KB/s 149.2KB/s   00:00
Incremental update completed, 581 packages processed:
24 packages updated, 2 removed and 1 added.
New version of pkg detected; it needs to be installed first.
Upgrades have been requested for the following 1 packages:

	Upgrading pkg: 1.2.7_4 -> 1.3.2

The upgrade will require 857 kB more space

1 MB to be downloaded

Proceed with upgrading packages [y/N]: y
pkg-1.3.2.txz                       100% 1938KB 646.0KB/s 498.1KB/s   00:03
Checking integrity... done
[1/1] Upgrading pkg from 1.2.7_4 to 1.3.2... done
If you are upgrading from the old package format, first run:

  # pkg2ng
Updating repository catalogue
pkg: Repo "KCI" upgrade schema 2006 to 2007: Add conflicts and provides
pkg: Repo "KCI" upgrade schema 2007 to 2008: Add FTS index
pkg: Repo "KCI" upgrade schema 2008 to 2009: Optimize indicies
pkg: Repo "KCI" upgrade schema 2009 to 2010: Add legacy digest field
[projects.int.kcilink.com] Fetching meta.txz: 100% of 584 B
[projects.int.kcilink.com] Fetching digests.txz: 35%   10 kB  10.2k/s    00:01 E[projects.int.kcilink.com] Fetching digests.txz: 100% of 28 kB
[projects.int.kcilink.com] Fetching packagesite.txz: 6%   10 kB  10.2k/s    00:1[projects.int.kcilink.com] Fetching packagesite.txz: 100% of 149 kB

Adding new entries: 100%
Incremental update completed, 581 packages processed:
0 packages updated, 0 removed and 1 added.
Updating database digests format: 100%
Checking for upgrades: 100%
The following 25 packages will be affected (of 235 checked):

Installed packages to be UPGRADED:
	p5-libwww: 6.07 -> 6.08
	p5-Crypt-SSLeay: 0.64 -> 0.72
	p5-URI: 1.60 -> 1.64
	p5-Net-HTTP: 6.06 -> 6.07
	p5-URI-Find: 20140702 -> 20140709
	p5-Net-SSLeay: 1.64 -> 1.65
	p5-Net-DNS: 0.77 -> 0.78
	p5-IO-Socket-SSL: 1.994 -> 1.997_2
	p5-HTTP-Tiny: 0.043 -> 0.046
	openjdk: 7.60.19_1,1 -> 7.65.17,1
	libXi: 1.7.2_2,1 -> 1.7.4,1
	dejavu: 2.34_3 -> 2.34_4
	xproto: 7.0.25 -> 7.0.26
	inputproto: 2.3 -> 2.3.1
	libICE: 1.0.8_2,1 -> 1.0.9,1
	apr: 1.5.1.1.5.3_2 -> 1.5.1.1.5.3_3
	apache22: 2.2.27_4 -> 2.2.27_6
	curl: 7.37.0 -> 7.37.1_2
	p5-Net: 1.25,1 -> 1.27,1
	postfix: 2.11.1_1,1 -> 2.11.1_2,1
	python27: 2.7.6_4 -> 2.7.8

Installed packages to be REINSTALLED:
	pcre-8.34_1 (options changed)
	openssl-1.0.1_13 (options changed)
	fontconfig-2.11.0_3,1 (options changed)
	libxcb-1.10_2 (options changed)

The process will require 1 MB more space
71 MB to be downloaded

Proceed with this action [y/N]: y
[projects.int.kcilink.com] Fetching pcre-8.34_1.txz: 0%   10 kB  10.2k/s    01:4[projects.int.kcilink.com] Fetching pcre-8.34_1.txz: 12%  130 kB 122.9k/s    00:[projects.int.kcilink.com] Fetching pcre-8.34_1.txz: 52%  530 kB 409.6k/s    00:[projects.int.kcilink.com] Fetching pcre-8.34_1.txz: 94%  960 kB 440.3k/s    00:[projects.int.kcilink.com] Fetching pcre-8.34_1.txz: 100% of 1 MB
[projects.int.kcilink.com] Fetching p5-libwww-6.08.txz: 6%   10 kB  10.2k/s    0[projects.int.kcilink.com] Fetching p5-libwww-6.08.txz: 100% of 154 kB
[projects.int.kcilink.com] Fetching p5-Crypt-SSLeay-0.72.txz: 22%   10 kB  10.2k[projects.int.kcilink.com] Fetching p5-Crypt-SSLeay-0.72.txz: 100% of 43 kB
pkg: cached package p5-Crypt-SSLeay-0.72: size mismatch, fetching from remote
[projects.int.kcilink.com] Fetching p5-Crypt-SSLeay-0.72.txz: 22%   10 kB  10.2k[projects.int.kcilink.com] Fetching p5-Crypt-SSLeay-0.72.txz: 100% of 43 kB
pkg: cached package p5-Crypt-SSLeay-0.72: size mismatch, cannot continue
[root@projects]#

This same error will happen every time "pkg upgrade" is run until I delete the local copy of the repo db: "rm /var/db/pkg/repo-KCI.sqlite"

Once that file is removed, the upgrade succeeds. This has happened on three servers so far.