Srikanth Bemineni wrote: > Lately we are seeing a dead lock kind of state while deleting records > from a table. > > All threads open their own shared connection to the database.
Why are you using shared cache mode? To prevent deadlocks, transactions that will modify the database should be started with BEGIN IMMEDIATE. (This kind of lock is not available in shared cache mode.) Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
