I have set busy time out for 5 seconds and given different names for every attach and detaching database. still, this error is not getting fixed. prepare, step and finalize are not throwing any errors.
What is the alternative solution for attach and detaching database? Thanks in advance. On Sun, Apr 20, 2014 at 9:16 PM, Simon Slavin <[email protected]> wrote: > > On 20 Apr 2014, at 12:58pm, dd <[email protected]> wrote: > > > Given different database name for in-memory database for every > > iteration(looped for 1000 times). Still, it's throwing Database Locked at > > least once on Windows, not on Mac/Linux. Is there any way to track this > > issue? I am using 3.7.11. Any ideas? > > Technically this should not solve the problem, but I'm curious to know. > > Have you set a timeout value ? If not, please set one to at least five > seconds using either of these: > > <http://www.sqlite.org/c3ref/busy_timeout.html> > <http://www.sqlite.org/draft/pragma.html#pragma_busy_timeout> > > I'm curious to know whether (a) this solves the problem or (b) it makes > your loop of 1000 take longer. > > However, we do seem to still think that the error is in your code > somewhere rather than in the SQLite library. Are you checking the result > returned by all calls for errors, rather than checking just the result > returned by your DETACH ? Check the result returned by every single > _prepare(), _step() and _finalize() and other sqlite_ call in your code. > > Simon. > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
