[sqlite] Statistical SQLITE_BUSY_SNAPSHOT in WAL mode

2015-05-30 Thread Samuel Tebeka
ay 30, 2015 11:57 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Statistical SQLITE_BUSY_SNAPSHOT in WAL mode On 30 May 2015, at 9:41pm, Samuel Tebeka wrote: > This is the official doc: > > 1.Process A starts a read transaction on the database and does one or

[sqlite] Statistical SQLITE_BUSY_SNAPSHOT in WAL mode

2015-05-30 Thread Samuel Tebeka
Hello, I recently decided to make my application use WAL mode since it works with multiple connections from multiple threads and It should improve performance. Since then, I have been having random SQLITE_BUSY_SNAPSHOTS errors (517). I read the documentation and tried to debug the code but it s