From owner-freebsd-ports@freebsd.org Thu Oct 12 19:56:01 2017 Return-Path: Delivered-To: freebsd-ports@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 6F95AE33347 for ; Thu, 12 Oct 2017 19:56:01 +0000 (UTC) (envelope-from emorrasg@yahoo.es) Received: from sonic309-25.consmr.mail.ir2.yahoo.com (sonic309-25.consmr.mail.ir2.yahoo.com [77.238.179.83]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 0AD2164F22 for ; Thu, 12 Oct 2017 19:55:59 +0000 (UTC) (envelope-from emorrasg@yahoo.es) X-YMail-OSG: Yisruw4VM1m9_eCX6ZLqSaSW5hH8vvvW1F8JZaLUEmBMJzCXwrKkXlRp19rLisv QHKFEL1VHE7YurblCTiWMmJ.iGjCoxguhI6cDkqjrxwTwBZ9OKtgUhZ0Ez5_vQULwLi9Q7rvHiWt POtfmJa3.2qGItf2WxdNXmepUk.bFrBPzMWQfyGiXWmj9IrooYj0.dQIZoTbivMWEY0bPB1spJNa Rvm5KQNVum0A8Rc8HDepmaY7YA.Pin4galfWF7OT8lIQ.Rb2Ljw.kuCRYlYl0WZB9PLMVwFgK4Cu slVGMTS4qgpZP9709iNV0FG27NI12MGbzEdLg8MWmR6xbsB6blIYSp3UctW5EXMJrdHNh60t9DGH b0pLDrSfrovZvv9ouW0ZJ9moX4wLYI3MnrTeEwZouhM3lEzgY.z9X7vva4TOyzNs7NapiQZlZEwG xvE8GjI7_aEOheit40gPdnjcgfuW5N605R6yBEV0S2xpXSh2KFZQzLBdXQEWEFDtEYl0EUTNsxtI GFwPkJMNMlDkrX_VhxFtgA4NCMp0SMbY95ERGQQ-- Received: from sonic.gate.mail.ne1.yahoo.com by sonic309.consmr.mail.ir2.yahoo.com with HTTP; Thu, 12 Oct 2017 19:55:52 +0000 Received: from [127.0.0.1] by smtp144.mail.ir2.yahoo.com with NNFMP; 12 Oct 2017 19:55:52 -0000 X-Yahoo-Newman-Id: 240210.44608.bm@smtp144.mail.ir2.yahoo.com X-Yahoo-Newman-Property: ymail-3 X-YMail-OSG: Yisruw4VM1m9_eCX6ZLqSaSW5hH8vvvW1F8JZaLUEmBMJzC XwrKkXlRp19rLisvQHKFEL1VHE7YurblCTiWMmJ.iGjCoxguhI6cDkqjrxwT wBZ9OKtgUhZ0Ez5_vQULwLi9Q7rvHiWtPOtfmJa3.2qGItf2WxdNXmepUk.b FrBPzMWQfyGiXWmj9IrooYj0.dQIZoTbivMWEY0bPB1spJNaRvm5KQNVum0A 8Rc8HDepmaY7YA.Pin4galfWF7OT8lIQ.Rb2Ljw.kuCRYlYl0WZB9PLMVwFg K4CuslVGMTS4qgpZP9709iNV0FG27NI12MGbzEdLg8MWmR6xbsB6blIYSp3U ctW5EXMJrdHNh60t9DGHb0pLDrSfrovZvv9ouW0ZJ9moX4wLYI3MnrTeEwZo uhM3lEzgY.z9X7vva4TOyzNs7NapiQZlZEwGxvE8GjI7_aEOheit40gPdnjc gfuW5N605R6yBEV0S2xpXSh2KFZQzLBdXQEWEFDtEYl0EUTNsxtIGFwPkJMN MlDkrX_VhxFtgA4NCMp0SMbY95ERGQQ-- X-Yahoo-SMTP: mX392iiswBAeJNdO_s.EW62LZDJR Date: Thu, 12 Oct 2017 22:00:57 +0200 From: Eduardo Morras 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: <8E4C5B17-EB78-437F-9FBE-C0CD74333CB0@karlsen.tech> <9ce33529-55d4-e9ab-a377-2bd142e27b4b@cloudzeeland.nl> <29A49D53-5563-4FAF-B122-268DC6056EE6@karlsen.tech> X-Mailer: Sylpheed 3.6.0 (GTK+ 2.24.31; amd64-portbld-freebsd11.0) Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 12 Oct 2017 19:56:01 -0000 On Thu, 12 Oct 2017 20:19:02 +0200 Vidar Karlsen wrote: >=20 > > On 12 Oct 2017, at 19:50, Jos Chrispijn > > 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