[Bug 292214] ports-mgmt/pkg sqlite error

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

            Bug ID: 292214
           Summary: ports-mgmt/pkg sqlite error
           Product: Ports & Packages
           Version: Latest
          Hardware: amd64
                OS: Any
            Status: New
          Severity: Affects Many People
          Priority: ---
         Component: Individual Port(s)
          Assignee: pkg@FreeBSD.org
          Reporter: devosalain@ymail.com
             Flags: maintainer-feedback?(pkg@FreeBSD.org)
          Assignee: pkg@FreeBSD.org

Script :
cd /var/db/pkg
rm -vfR *
pkg-static install -f pkg
pkg update -f
pkg upgrade

returns :

local.sqlite
repos/FreeBSD-kmods/lock
repos/FreeBSD-kmods/db-journal
repos/FreeBSD-kmods/meta
repos/FreeBSD-kmods/db
repos/FreeBSD-kmods
repos/FreeBSD/meta
repos/FreeBSD/lock
repos/FreeBSD/db-journal
repos/FreeBSD
repos
Updating FreeBSD repository catalogue...
Fetching meta.conf: 100%    179 B   0.2kB/s    00:01    
Fetching data.pkg: 100%   10 MiB   5.3MB/s    00:02    
Processing entries:  99%
pkg-static: sqlite error while executing grmbl in file update.c:154: NOT NULL
constraint failed: packages.path
pkg-static: sqlite error while executing grmbl in file update.c:154: NOT NULL
constraint failed: packages.path
pkg-static: 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...
Fetching meta.conf: 100%    179 B   0.2kB/s    00:01    
Fetching data.pkg: 100%   30 KiB  31.1kB/s    00:01    
Processing entries: 100%
FreeBSD-kmods repository update completed. 204 packages processed.
Error updating repositories!
pkg-static: Repository FreeBSD cannot be opened. 'pkg update' required
pkg-static: No packages available to install matching 'pkg' have been found in
the repositories
Updating FreeBSD repository catalogue...
Fetching meta.conf: 100%    179 B   0.2kB/s    00:01    
Fetching data.pkg: 100%   10 MiB   5.3MB/s    00:02    
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...
Fetching meta.conf: 100%    179 B   0.2kB/s    00:01    
Fetching data.pkg: 100%   30 KiB  31.1kB/s    00:01    
Processing entries: 100%
FreeBSD-kmods repository update completed. 204 packages processed.
Error updating repositories!
Updating FreeBSD repository catalogue...
Fetching meta.conf: 100%    179 B   0.2kB/s    00:01    
Fetching data.pkg: 100%   10 MiB   5.3MB/s    00:02    
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!
pkg: Repository FreeBSD cannot be opened. 'pkg update' required
Checking for upgrades (0 candidates): 100%
Processing candidates (0 candidates): 100%
Checking integrity... done (0 conflicting)
Your packages are up to date.

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