Date: Thu, 12 Oct 2017 22:00:57 +0200 From: Eduardo Morras <emorrasg@yahoo.es> To: freebsd-ports@freebsd.org Subject: Re: pkg: sqlite error while executing sqlite open in file pkgdb.c:1126: unable to open database file Message-ID: <20171012220057.f72df19f5872a40668ec6522@yahoo.es> In-Reply-To: <29A49D53-5563-4FAF-B122-268DC6056EE6@karlsen.tech> References: <fc394181-fede-ce16-16d4-535306d59bfe@cloudzeeland.nl> <CAN6yY1sm65vPbqK6sNmnxLv0C7ohvNkLy-gAWOhoPhyUzquAbw@mail.gmail.com> <8E4C5B17-EB78-437F-9FBE-C0CD74333CB0@karlsen.tech> <9ce33529-55d4-e9ab-a377-2bd142e27b4b@cloudzeeland.nl> <29A49D53-5563-4FAF-B122-268DC6056EE6@karlsen.tech>
next in thread | previous in thread | raw e-mail | index | archive | help
On Thu, 12 Oct 2017 20:19:02 +0200 Vidar Karlsen <vidar@karlsen.tech> wrote: >=20 > > On 12 Oct 2017, at 19:50, Jos Chrispijn <bsdports@cloudzeeland.nl> > > wrote: > >=20 > > Op 12-10-2017 om 7:39 schreef Vidar Karlsen: > >> Also check if your current work dir has been deleted, > > Do you mean my BSD workdir like /temp or do you refer to the > > workdir that is used during the portupdate? Where can I find which > > workdir that is? >=20 > I usually get that exact error when I run pkg from a directory that > no longer exists. In my case, this typically happens because I?m > sitting in a port dir like /usr/ports/dns/unbound after having run > 'portsnap fetch update? which has deleted that dir and created a new > one because of a version bump in the tree. What configuration has sqlite in pkg? It looks like it tries to create wal, temp and/or shm files in current directory. If compile sqlite with options temp_store =3D memory, 3, or sets it at open file or as pre open pragma, temp files won't exist. For shm files and wal, use pragma directory_data, deprecated sqlite pragma because Windows OS could cause db corruption, but we are not Windows. And now that I write it, perhaps it's easier to check if the current directory exists before opening the db file. --- --- Eduardo Morras <emorrasg@yahoo.es>
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20171012220057.f72df19f5872a40668ec6522>