Re: [sqlite] When does SQLite open/create files?

2016-11-23 Thread Jens Alfke
> On Nov 23, 2016, at 1:31 PM, Richard Hipp wrote: > > Have you enabled the error and warning log? > (https://www.sqlite.org/errlog.html ) > IIRC, the error log will give > you the name of the file that could not be opened. No! I wasn’t aware of that featur

Re: [sqlite] When does SQLite open/create files?

2016-11-23 Thread Richard Hipp
On 11/23/16, Jens Alfke wrote: > >> On Nov 23, 2016, at 12:45 PM, Simon Slavin wrote: >> >> Are you checking the value returned by each call to the SQLite API to make >> sure it's SQLITE_OK ? > > Yes. As I said, the error is returned from sqlite3_step(), but it doesn’t > specify _what_ file could

Re: [sqlite] When does SQLite open/create files?

2016-11-23 Thread Jens Alfke
> On Nov 23, 2016, at 12:45 PM, Simon Slavin wrote: > > Are you checking the value returned by each call to the SQLite API to make > sure it's SQLITE_OK ? Yes. As I said, the error is returned from sqlite3_step(), but it doesn’t specify _what_ file couldn’t be opened. That’s the information I

Re: [sqlite] When does SQLite open/create files?

2016-11-23 Thread Simon Slavin
On 23 Nov 2016, at 7:54pm, Jens Alfke wrote: >> On Nov 22, 2016, at 2:10 PM, Richard Hipp wrote: >> >> No. Did you run "PRAGMA temp_store=MEMORY;"? This might be a >> statement journal opening. > > No. (The string “temp_store” does not appear anywhere in the source code.) > > Any way I can

Re: [sqlite] When does SQLite open/create files?

2016-11-23 Thread Jens Alfke
> On Nov 22, 2016, at 2:10 PM, Richard Hipp wrote: > > No. Did you run "PRAGMA temp_store=MEMORY;"? This might be a > statement journal opening. No. (The string “temp_store” does not appear anywhere in the source code.) Any way I can get more info from SQLite about exactly what operation fai

Re: [sqlite] When does SQLite open/create files?

2016-11-22 Thread Richard Hipp
On 11/22/16, Jens Alfke wrote: > > I did not close the database handle, so if SQLite is trying to open the file > at this moment, it must have closed it earlier on its own. > Or could it be the WAL file? Does SQLite ever close and reopen, or delete > and re-create, the WAL? No. Did you run "PRAG

Re: [sqlite] When does SQLite open/create files?

2016-11-22 Thread Jens Alfke
> On Nov 21, 2016, at 12:39 PM, Richard Hipp wrote: > > On 11/21/16, Jens Alfke wrote: >> Does SQLite ever open or create files while a database connection is already >> open? > > (1) When you run ATTACH. > > (2) The open/create of the original database is deferred until you > actually need t

Re: [sqlite] When does SQLite open/create files?

2016-11-21 Thread Richard Hipp
On 11/21/16, Jens Alfke wrote: > Does SQLite ever open or create files while a database connection is already > open? (1) When you run ATTACH. (2) The open/create of the original database is deferred until you actually need to read or write the database, so the open/create might occur later than

[sqlite] When does SQLite open/create files?

2016-11-21 Thread Jens Alfke
Does SQLite ever open or create files while a database connection is already open? Or does that only happen while creating the connection? (I'm using WAL mode, if it makes a difference.) --Jens [via iPhone] ___ sqlite-users mailing list sqlite-user