On 5/24/2012 11:35 AM, Simon Slavin wrote: > On 5/24/2012 9:06 PM, Igor Tandetnik wrote: > >> What exactly do you mean by "database lockout problems"? What error in what >> API call are you getting? > > I am getting SQLITE_BUSY error very often, and it does not go away, as if the > database is dead-locked
> Please set a SQLite timeout to three seconds and try again. If you're still > getting locks, set it to ten seconds and try again. > <http://sqlite.org/c3ref/busy_timeout.html> > I'm not saying this will get rid of locks entirely, but it will help us to > know whether this has any effect on the number of errors you're seeing. I have already done this. Tried different timeouts. The timeouts will basically make the program hang, but eventually the transaction will end with SQLITE_BUSY error. Andrew _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users