Bug 220114 - ports-mgmt/pkg unable to open database file when run from a non-existent dir
Summary: ports-mgmt/pkg unable to open database file when run from a non-existent dir
Status: Closed FIXED
Alias: None
Product: Ports & Packages
Classification: Unclassified
Component: Individual Port(s) (show other bugs)
Version: Latest
Hardware: Any Any
: --- Affects Many People
Assignee: freebsd-pkg (Nobody)
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-06-18 16:43 UTC by Zsolt Udvari
Modified: 2019-08-15 04:45 UTC (History)
8 users (show)

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Zsolt Udvari freebsd_committer freebsd_triage 2017-06-18 16:43:45 UTC 
$ mkdir ~/pkg_tmp
$ cd ~/pkg_tmp
$ rmdir ~/pkg_tmp
$ pwd
pwd: .: No such file or directory
$ pkg info
pkg: sqlite error while executing sqlite open in file pkgdb.c:1126: unable to open database file
$ pkg -v
1.10.1

I saw this message when I 'cd' into a directory which is owned by package "foo" (I don't remember which package but I think it's irrelevant) and some minutes later I wanted to remove "foo".
I think the error message is deceptive (I could handle the package database with sqlite and didn't understand why pkg can't access it).
Comment 1 Herbert J. Skuhra 2017-08-02 06:35:11 UTC 
I often see this error updating ports with portmaster:

# pwd
/root
# portmaster security/ca_root_nss
[...]
pkg: sqlite error while executing sqlite open in file pkgdb.c:1126: unable to open database file

If I remove pkg-message from SUB_FILES (security/ca_root_nss/Makefile) the error is gone. After more testing I think the error does not appear on 12.0-CURRENT (pkg) and 11-RELEASE/STABLE (pkg-devel).
Comment 2 Michael Büker 2017-08-17 08:01:21 UTC 
I see this error message when running "portmaster -a" on 11.1-RELEASE, right at the end of the process.
Comment 3 Steve Wills freebsd_committer freebsd_triage 2017-08-17 14:21:03 UTC 
I can confirm I've experienced this error too and agree the error message is misleading at best. The error seems unnecessary.
Comment 4 Jordan Morningstar 2017-08-17 22:28:19 UTC 
See this github issue: https://github.com/freebsd/pkg/issues/1552
Comment 5 Walter Schwarzenfeld 2019-08-15 04:45:35 UTC 
See link in comment4. Is fixed.