Bug 249317

Summary:	ports-mgmt/pkg: assertion failed on 1.15.4 (pkg_jobs_conflicts.c)
Product:	Ports & Packages	Reporter:	Jimmy Olgeni <olgeni>
Component:	Individual Port(s)	Assignee:	freebsd-pkg (Nobody) <pkg>
Status:	Closed Not A Bug
Severity:	Affects Only Me	Flags:	bugzilla: maintainer-feedback? (pkg)
Priority:	---
Version:	Latest
Hardware:	Any
OS:	Any

Description Jimmy Olgeni freebsd_committer

2020-09-14 15:19:32 UTC

It goes like this:

# pkg -v
1.15.4
# pkg upg -y
Updating bsdkit repository catalogue...
bsdkit repository is up to date.
All repositories are up to date.
Checking for upgrades (49 candidates): 100%
Processing candidates (49 candidates): 100%
Checking integrity...Assertion failed: (strcmp(uid, p->uid) != 0), function pkg_conflicts_check_local_path, file pkg_jobs_conflicts.c, line 386.
Child process pid=93227 terminated abnormally: Abort trap

Not sure what could have caused it, but I can peek around and check.

What does the uid check refer to? :)

Comment 1 Jimmy Olgeni freebsd_committer

2020-09-16 08:19:51 UTC

Apparently the sqlite db got corrupted somehow:

[pts/9:olgeni@olgeni ~]% sudo pkg delete devel/py-azure-mgmt-resource
Checking integrity... done (0 conflicting)
Deinstallation has been requested for the following 3 packages (of 0 packages in the universe):

Installed packages to be REMOVED:
	py37-azure-cli: 2.11.1
	py37-azure-cli-core: 2.11.1
	py37-azure-mgmt-resource: 10.1.0

Number of packages to be removed: 3

The operation will free 35 MiB.

Proceed with deinstalling packages? [y/N]: y
[1/3] Deinstalling py37-azure-cli-2.11.1...
[1/3] Deleting files for py37-azure-cli-2.11.1: 100%
[2/3] Deinstalling py37-azure-cli-core-2.11.1...
[2/3] Deleting files for py37-azure-cli-core-2.11.1: 100%
[3/3] Deinstalling py37-azure-mgmt-resource-10.1.0...
[3/3] Deleting files for py37-azure-mgmt-resource-10.1.0:  44%
py37-azure-mgmt-resource-10.1.0: missing file /usr/local/lib/python3.7/site-packages/azure/mgmt/resource/resources/v2 19_08_01/operations/__init__.py
[3/3] Deleting files for py37-azure-mgmt-resource-10.1.0: 100%
pkg: sqlite error while executing DELETE FROM packages WHERE id = ?1; in file pkgdb.c:2449: database disk image is malformed

Comment 2 Jimmy Olgeni freebsd_committer

2020-09-16 09:59:15 UTC

I dumped/restored the sqlite3 db and nothing was lost \o/