On 7 Aug 2018, at 12:55pm, Gerlando Falauto <[email protected]> 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
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
