Re: pkg problems [now there is a report for "FreeBSD 14.3-RELEASE-p5 GENERIC" as well]

From: Karl Denninger <karl_at_denninger.net>
Date: Thu, 18 Dec 2025 14:24:48 UTC
On 12/18/2025 09:21, Mark Millard wrote:
> On Dec 17, 2025, at 08:36, Mark Millard <marklmi@yahoo.com> wrote:
>
>> On Dec 17, 2025, at 07:31, Baptiste Daroussin <bapt@FreeBSD.org> wrote:
>>
>>> On Wed 17 Dec 15:24, void wrote:
>>>> Hi,
>>>>
>>>> Getting this error:
>>>>
>>>> # pkg update -f
>>>> Updating FreeBSD-ports repository catalogue...
>>>> Fetching meta.conf: 100%    179 B   0.2kB/s    00:01    Fetching data.pkg:
>>>> 100%   10 MiB  11.0MB/s    00:01    Processing entries:  99%
>>>> pkg: sqlite error while executing grmbl in file update.c:154: NOT NULL constraint failed: packages.path
>>>> pkg: sqlite error while executing grmbl in file update.c:154: NOT NULL constraint failed: packages.path
>>>> pkg: sqlite error while executing INSERT OR REPLACE INTO packages (origin, name, version, comment, desc, arch, maintainer, www, prefix, pkgsize, flatsize, licenselogic, cksum, path, manifestdigest, olddigest, vital)VALUES (?1, ?2, ?3, ?4, ?5, ?6, ?7, ?8, ?9, ?10, ?11, ?12, ?13, ?14, ?15, ?16, ?17) in file update.c:158: not an error
>>>> Processing entries:  99%
>>>> Unable to update repository FreeBSD-ports
>>>> Error updating repositories!
>>>>
>>> The dataset is corrupted for yet unknonw reason, a new dataset is being uploaded
>>> as we speak, so in the next couple of hours it should hit the mirrors next to
>>> you.
>>>
>> I do not know if it matters, but for . . .
>>
>> Sun, 07 Dec 2025:
>>
>>     • git: b3058e362102 - main - devel/base64: Add base64 0.5.2 Po-Chuan Hsieh
>> . . .
>>     • git: 077d9ba380e5 - main - www/py-requests-kerberos: Add py-requests-kerberos 0.15.0 Po-Chuan Hsieh
>>
>> devel/base64 created a second port with the same PKGNAME as long
>> used by converters/base64 . (The content was not a duplicate.)
>>
>> www/py-requests-kerberos created a duplicate of
>> security/py-requests-kerberos (including the PKGNAME).
>>
>> The fixes are recent:
>>
>> Wed, 17 Dec 2025
>>
>>     • git: d773ece5bc68 - main - www/py-requests-kerberos: Remove duplicate port Po-Chuan Hsieh
>>     • git: f554dcbcf289 - main - devel/base64: Change PKGNAME to avoid conflict with converters/base64 Po-Chuan Hsieh
>>
>>
>> So, for around 10 days a couple of PKGNAME's were not unique in
>> the ports tree.
>>
> The problem is now reported for
>
> # uname -v
> FreeBSD 14.3-RELEASE-p5 GENERIC
>
> as well. See:
>
> https://lists.freebsd.org/archives/freebsd-stable/2025-December/003731.html

Yes, and on multiple systems here all on 14.3, both -STABLE (built from 
source) and -RELEASEp5

It is definitely not a local corruption problem with one machine since 
the error is identical across multiple boxes in different locations (I 
stopped after three in a mix of 14.3-STABLE and -RELEASEp5 this morning 
-- all return the same result.)

-- 
Karl Denninger
karl@denninger.net
/The Market Ticker/
/[S/MIME encrypted email preferred]/