On 7 Aug 2018, at 12:55pm, Gerlando Falauto <gerlando.fala...@gmail.com> wrote:

> I'm trying to implement a logging system based on SQLite, using python3
> package apsw.
> There's one process constantly writing and another one reading.
> From time to time I get an exception from the writer, complaining the
> database is locked.

Please set a time of at least 10,000 milliseconds for /all/ connections, both 
reading and writing:

    Connection.setbusytimeout(10000)

<https://rogerbinns.github.io/apsw/connection.html?highlight=timeout#apsw.Connection.setbusytimeout>

If you're already doing this, please post again, telling us whether you're 
using two separate connections or passing the connection handle from process to 
process.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to