ports/181946: [pkgng] pkg repo corrupts repository after rebuilding a package

[Spil]

>Number:         181946
>Category:       ports
>Synopsis:       [pkgng] pkg repo corrupts repository after rebuilding a package
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          sw-bug
>Submitter-Id:   current-users
>Arrival-Date:   Sun Sep 08 18:30:00 UTC 2013
>Closed-Date:
>Last-Modified:
>Originator:     Spil
>Release:        FreeBSD 9.2-RC3 amd64
>Organization:
n.a.
>Environment:
FreeBSD new93.example.org 9.2-RC3 FreeBSD 9.2-RC3 #0 r254795: Sat Aug 24 20:25:04 UTC 2013     root at bake.isc.freebsd.org:/usr/obj/usr/src/sys/GENERIC  amd64
>Description:
When I reinstall a package, pkg repo and pkg repo -f corrupt the database resulting in a repo with only one package
>How-To-Repeat:
With portmaster as example
# pwd
/usr/ports/ports-mgmt/portmaster
# rm -rf /usr/ports/packages/*.txz
# make deinstall
===>  Deinstalling for ports-mgmt/portmaster
<snip>
[1/1] Deleting portmaster-3.17.1... done
# make package
===>  Installing for portmaster-3.17.1
<snip>
Installing portmaster-3.17.1... done
===>  Building package for portmaster-3.17.1
Creating package for portmaster-3.17.1
# pkg repo /usr/ports/packages
Generating repository catalog in /usr/ports/packages: done!
# make deinstall
===>  Deinstalling for ports-mgmt/portmaster
<snip>
[1/1] Deleting portmaster-3.17.1... done
# make package
===>  Installing for portmaster-3.17.1
<snip>
Creating package for portmaster-3.17.1
# pkg repo /usr/ports/packages
Generating repository catalog in /usr/ports/packages: \pkg: duplicate package origin: package All/portmaster-3.17.1.txz is not newer than version 3.17.1 already in repo for origin ports-mgmt/portmaster
done!
# rm -rf /usr/ports/packages/*.txz
# pkg repo /usr/ports/packages
Generating repository catalog in /usr/ports/packages: done!

Using the repo after the duplicate origin error
# pkg update
Updating repository catalogue
digests.txz                                                             100%  260     0.3KB/s   0.3KB/s   00:00
packagesite.txz                                                         100% 1284     1.3KB/s   1.3KB/s   00:00
Incremental update completed, 0 packages processed:
1 packages updated, 120 removed and 0 added.
# pkg search '.*'
portmaster-3.17.1
# pkg update
Updating repository catalogue
digests.txz                                                             100% 5908     5.8KB/s   5.8KB/s   00:00
packagesite.txz                                                         100%   39KB  39.3KB/s  39.3KB/s   00:00
Incremental update completed, 0 packages processed:
0 packages updated, 0 removed and 120 added.
# pkg search '.*'
apache24-2.4.6
<snip>
zip-3.0

>Fix:
Workaround is to delete the repo's .txz files and run pkg repo

>Release-Note:
>Audit-Trail:
>Unformatted: