On 6/17/2019 7:49 PM, Simon Slavin wrote:
Is session B complaining that session A has a lock ?
Yes.
If session A had a lock why was there no complaint for the INSERT ?
A connection doesn't need to check locks on every statement - only when it tries to spill to disk, most commonly during commit. See https://sqlite.org/lockingv3.html . Specifically, Session A holds a SHARED lock. Session B holds a RESERVED lock up until the time you ask it to commit, at which point it tries and fails to promote it to EXCLUSIVE. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users