Re: [sqlite] sqlite3_get_table() failed with error "database is locked"

[Simon Slavin]

On 4 Oct 2018, at 10:57am, ldl  wrote:

> Just the same application started in multiple processes doing the same 
> things. The accesses to the db were all readonly.
> 
> 
> I print the error from sqlite3_get_table(). The error is "database is locked".

Set a timeout of 60,000ms and see whether this makes the errors go away:



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

Re: [sqlite] sqlite3_get_table() failed with error "database is locked"

[ldl]

Hi Clemens,


Just the same application started in multiple processes doing the same things. 
The accesses to the db were all readonly.


I print the error from sqlite3_get_table(). The error is "database is locked".


Thanks,
Liu






At 2018-09-24 18:27:24, "Clemens Ladisch"  wrote:
>ldl wrote:
>> Multiple applications called sqlite3_get_table() to read data in a same db 
>> file at the same time, got error "database is locked"
>
>Somebody has a write lock.
>
>> Why read-only access is locked?
>
>Because one access is not read only.
>
>> How to resolve the issue?
>
>Find out who locked it.
>Do you know which processess could access the DB file?
>
>
>Regards,
>Clemens
>___
>sqlite-users mailing list
>sqlite-users@mailinglists.sqlite.org
>http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3_get_table() failed with error "database is locked"

[Clemens Ladisch]

ldl wrote:
> Multiple applications called sqlite3_get_table() to read data in a same db 
> file at the same time, got error "database is locked"

Somebody has a write lock.

> Why read-only access is locked?

Because one access is not read only.

> How to resolve the issue?

Find out who locked it.
Do you know which processess could access the DB file?


Regards,
Clemens
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] sqlite3_get_table() failed with error "database is locked"

[ldl]

Hi,


Multiple applications called sqlite3_get_table() to read data in a same db file 
at the same time, got error "database is locked"? Why read-only access is 
locked? How to resolve the issue?


Thanks,
Liu
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users