On 29 Nov 2018, at 11:35am, Prajeesh Prakash <prajeeshprakash@elear.solutions> wrote:
> I am writing to a table 1 and reading from table 2 both operation are from > different DB connection i am getting SQLITE_LOCKED SQLite locks the entire database. It does not lock each table independently. > and when i try to read and write the same table from different connection i > am getting same error. (I know read and write are the incompatible at same > time). Why this happening bu default sqlite will act on FULLMUTEXT. Ignore MUTEX when using two different connections. You need to set a timeout of a minute or two for each connection: <https://sqlite.org/pragma.html#pragma_busy_timeout> Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users