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

2018-10-04 Thread 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

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

2018-10-04 Thread 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

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

2018-09-24 Thread 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

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

2018-09-23 Thread 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