[Bug 297065] ports-mgmt/pkg: pkg-2.8.1: pkg update -r FreeBSD-ports creates the db file with a size of 1.6 Giga(!)bytes

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=297065

--- Comment #9 from Mark Millard <marklmi26-fbsd@yahoo.com> ---
(In reply to Herbert J. Skuhra from comment #8)

I've added a note to the upstream github issue, repeated below:


QUOTE
I expect that bapt's answer above is referencing what got moved to the likes of
a separate file (upstream):

https://pkg.freebsd.org/FreeBSD:16:amd64/latest/files.pkg
https://pkg.freebsd.org/FreeBSD:15:amd64/latest/files.pkg

that now have sizes like: 42323007 and  43439619 showing. (These files are part
of the implementation of "pkg rwhich".)

However, just doing a "pkg update -rFreeBSD-ports" via 2.8.1 against either of
the above repositories in a context where `FreeBSD-ports` is not otherwise in
use (local port-package repository used instead) leads to the likes of :
(/OffAMD64ufs-mnt/ is pkgbase stable/15 system media, used via a chroot here.
PDT time zone shown.)
(The other is for a main [so: 16] system in direct use.)

```
-rw-r--r--  1 root wheel - 1598496768 Jul 27 22:47:37 2026
/OffAMD64ufs-mnt/var/db/pkg/repos/FreeBSD-ports/db
-rw-r--r--  1 root wheel uarch 1589063680 Jul 27 23:54:47 2026
/var/db/pkg/repos/FreeBSD-ports/db
```

pkg 2.7.5 does not end up with such historically huge files.

`FreeBSD:*:aarch64` , for example, has no latest/files.pkg files and "pkg
rwhich" does not find anything for aarch64. So far only amd64 seems to be
getting such large files, even via pkg 2.8.1 .

Part of the problem with the descriptions of things here is that the upstream
`latest/files.pkg` and the local `var/db/pkg/repos/FreeBSD-ports/db` are
distinct databases and either or both could have size problems. As I remember,
there had been a report some where that I saw that was explicit about an
upstream size problem being reported.
END QUOTE


I'll note that there has been post-2.8.1 work for 2.8.2 in the
general subject area. But, as I understand, bapt is now away
for a while.

-- 
You are receiving this mail because:
You are the assignee for the bug.