database is locked

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

database is locked

prog@geniais.com
Hello,

I'm using exec() to simply get true/false result (just reading) and I'm
receiving this error, even in WAL mode:
SQLite3::exec(): database is locked in ... on line 47

Any help will be apreciated

Thank you

Ismael


_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: database is locked

Simon Slavin-3
On 20 Oct 2018, at 1:19pm, [hidden email] wrote:

> I'm using exec() to simply get true/false result (just reading) and I'm receiving this error, even in WAL mode:
> SQLite3::exec(): database is locked in ... on line 47
>
> Any help will be apreciated

I'm assuming that you are aware that something else is acessing the same database at the same time.

Set a timeout using either of these:

<https://sqlite.org/c3ref/busy_timeout.html

<https://sqlite.org/pragma.html#pragma_busy_timeout>

Simon.
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users