Re: [sqlite] Write-ahead logging issue on Android

2013-10-07 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/10/13 18:37, Sascha Sertel wrote: > I have since tried to find out what the correct way is to point SQLite > to the right place for creating temporary files in Android, with no > luck. https://developer.android.com/reference/android/content/Con

Re: [sqlite] Write-ahead logging issue on Android

2013-10-07 Thread Sascha Sertel
Ok I was able to make some progress on this issue. Per Richard's recommendation I hooked into the error callback and started seeing errors like this (original sql statement removed from log output since it is not important here): SqliteLibrary::Log( Error=14, Message="cannot open file at line 2820

Re: [sqlite] Write-ahead logging issue on Android

2013-10-04 Thread Richard Hipp
On Fri, Oct 4, 2013 at 2:55 PM, Sascha Sertel wrote: > > I'm working on a multi-platform app that uses a cross-platform library with > SQLite 3.7.16.1 built into it (i.e. not using the built-in SQLite version > in Android or other platforms). We make (re)use of prepared statements for > INSERT and

Re: [sqlite] Write-ahead logging issue on Android

2013-10-04 Thread Simon Slavin
On 4 Oct 2013, at 10:26pm, Sascha Sertel wrote: > The error does not come up immediately, creating tables works fine, making > inserts works fine, it's only when I start making updates (from multiple > threads) where this error starts showing up. Any chance that the VFS just doesn't allow other

Re: [sqlite] Write-ahead logging issue on Android

2013-10-04 Thread Sascha Sertel
I can see the .wal and .shm files getting created and don't see a reason why SQLite would suddenly have issues accessing those files. The error does not come up immediately, creating tables works fine, making inserts works fine, it's only when I start making updates (from multiple threads) where t

Re: [sqlite] Write-ahead logging issue on Android

2013-10-04 Thread Dan Kennedy
On 10/05/2013 01:55 AM, Sascha Sertel wrote: Hello everybody, I'm hoping someone might have some insights on a particular issue I've been running into. Here some details: I'm working on a multi-platform app that uses a cross-platform library with SQLite 3.7.16.1 built into it (i.e. not using th

[sqlite] Write-ahead logging issue on Android

2013-10-04 Thread Sascha Sertel
Hello everybody, I'm hoping someone might have some insights on a particular issue I've been running into. Here some details: I'm working on a multi-platform app that uses a cross-platform library with SQLite 3.7.16.1 built into it (i.e. not using the built-in SQLite version in Android or other p