Solved Updating error on 15.0p1 (pkgbase)

After updating to 15.0p1 pkg-update now throws errors:

Code:
$ doas pkg update
Updating FreeBSD-ports repository catalogue...
Fetching data.pkg: 100%   10 MiB   1.1MB/s    00:10   
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
Updating FreeBSD-ports-kmods repository catalogue...
FreeBSD-ports-kmods repository is up to date.
Updating FreeBSD-base repository catalogue...
FreeBSD-base repository is up to date.
Error updating repositories!
 
while updating repos, pkg: sqlite error while executing grmbl in file update.c:171: NOT NULL constraint failed: packages.path #2575
 
I'm experiencing the same issue on 14.3-RELEASE-p6 and 14.3-RELEASE-p7, but NOT on 13.5-RELEASE-p7.
This is noted in the GitHub issue linked above and "is being worked on".
 
Same here:

Code:
% freebsd-version
14.3-RELEASE-p7
% sudo pkg update
Updating FreeBSD repository catalogue...
Fetching data.pkg: 100%   11 MiB   1.1MB/s    00:10   
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
Updating FreeBSD-kmods repository catalogue...
FreeBSD-kmods repository is up to date.
Error updating repositories!

Any known cure/workaround so far?
 
Same here:

Code:
% freebsd-version
14.3-RELEASE-p7
% sudo pkg update
Updating FreeBSD repository catalogue...
Fetching data.pkg: 100%   11 MiB   1.1MB/s    00:10  
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
Updating FreeBSD-kmods repository catalogue...
FreeBSD-kmods repository is up to date.
Error updating repositories!

Any known cure/workaround so far?
I had the same problem yesterday with the latest FreeBSD-ports repo. quarterly worked fine so I thought it might be a temporary problem with the actual remote repo files.
 
Back
Top