Re: [sqlite] database table is locked issue

2014-02-14 Thread Sandu Buraga
> > I have a process with several threads working in the same time on a > > database file. I have 0 or 1 writers and 0 or N readers at a moment. All > > write accesses are isolated in transactions, I am using WAL and shared > > cache, but sometimes during the DELETE statemens I get "database

Re: [sqlite] database table is locked issue

2014-02-12 Thread Simon Slavin
On 12 Feb 2014, at 4:44pm, Sandu Buraga wrote: > I have a process with several threads working in the same time on a > database file. I have 0 or 1 writers and 0 or N readers at a moment. All > write accesses are isolated in transactions, I am using WAL and shared >

[sqlite] database table is locked issue

2014-02-12 Thread Sandu Buraga
Hi, I have a process with several threads working in the same time on a database file. I have 0 or 1 writers and 0 or N readers at a moment. All write accesses are isolated in transactions, I am using WAL and shared cache, but sometimes during the DELETE statemens I get "database table is locked"