[Bug 292332] ports-mgmt/pkg sqlite error on ARM64

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

            Bug ID: 292332
           Summary: ports-mgmt/pkg sqlite error on ARM64
           Product: Ports & Packages
           Version: Latest
          Hardware: arm64
                OS: Any
            Status: New
          Severity: Affects Many People
          Priority: ---
         Component: Individual Port(s)
          Assignee: pkg@FreeBSD.org
          Reporter: staf@wagemakers.be
             Flags: maintainer-feedback?(pkg@FreeBSD.org)
          Assignee: pkg@FreeBSD.org

Related to:
Bug 292214 - ports-mgmt/pkg sqlite error 
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=292214
The issue seems to be fixed on AMD64, but there is still an issue on ARM64 in
the quarterly FreeBSD-ports
It's fixed on the FreeBSD-ports/latest, but still broken on
FreeBSD-ports/quarterly (see below)
See also the comment in Bug 292214

https://lists.freebsd.org/archives/freebsd-pkg/2026-January/001807.html

With latest

```
root@pigate:~ # pkg repos
FreeBSD-ports: {
url : "pkg+https://pkg.freebsd.org/FreeBSD:15:aarch64/latest",
enabled : yes,
priority : 0,
mirror_type : "SRV",
signature_type : "FINGERPRINTS",
fingerprints : "/usr/share/keys/pkg"
}
FreeBSD-ports-kmods: {
url : "pkg+https://pkg.freebsd.org/FreeBSD:15:aarch64/kmods_quarterly_0",
enabled : yes,
priority : 0,
mirror_type : "SRV",
signature_type : "FINGERPRINTS",
fingerprints : "/usr/share/keys/pkg"
}
FreeBSD-base: {
url : "pkg+https://pkg.freebsd.org/FreeBSD:15:aarch64/base_release_0",
enabled : no,
priority : 0,
mirror_type : "SRV",
signature_type : "FINGERPRINTS",
fingerprints : "/usr/share/keys/pkgbase-15"
}
root@pigate:~ #
```
```
root@pigate:~ # pkg update
Updating FreeBSD-ports repository catalogue...
FreeBSD-ports repository is up to date.
Updating FreeBSD-ports-kmods repository catalogue...
FreeBSD-ports-kmods repository is up to date.
All repositories are up to date.
root@pigate:~ #
```

With quarterly

```
root@wifigate:/var/db/pkg # pkg repos
FreeBSD-ports: {
url : "pkg+https://pkg.freebsd.org/FreeBSD:15:aarch64/quarterly",
enabled : yes,
priority : 0,
mirror_type : "SRV",
signature_type : "FINGERPRINTS",
fingerprints : "/usr/share/keys/pkg"
}
FreeBSD-ports-kmods: {
url : "pkg+https://pkg.freebsd.org/FreeBSD:15:aarch64/kmods_quarterly_0",
enabled : yes,
priority : 0,
mirror_type : "SRV",
signature_type : "FINGERPRINTS",
fingerprints : "/usr/share/keys/pkg"
}
FreeBSD-base: {
url : "pkg+https://pkg.freebsd.org/FreeBSD:15:aarch64/base_release_0",
enabled : no,
priority : 0,
mirror_type : "SRV",
signature_type : "FINGERPRINTS",
fingerprints : "/usr/share/keys/pkgbase-15"
}
root@wifigate:/var/db/pkg #
```

```
root@wifigate:/var/db/pkg # pkg update
Updating FreeBSD-ports repository catalogue...
Fetching meta.conf: 100% 179 B 0.2kB/s 00:01
Fetching data.pkg: 100% 10 MiB 10.4MB/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
Updating FreeBSD-ports-kmods repository catalogue...
FreeBSD-ports-kmods repository is up to date.
Error updating repositories!
root@wifigate:/var/db/pkg #
```

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