Can someone please explain this error message to me:
Simple database, journal mode set to 'delete', accessed by two simultaneous
sessions running the SQLite command-line shell,
SQLite version 3.28.0 2019-04-15 14:49:49
Session A:
PRAGMA journal_mode; <-- says 'delete'
CREATE TABLE Test (a TEXT);
INSERT INTO Test (a) VALUES "first";
BEGIN;
SELECT * FROM Test; <-- first
Session B:
BEGIN;
INSERT INTO Test (a) VALUES ('second');
SELECT * FROM Test; <-- first / second
Session A:
SELECT * FROM Test; <-- first
Session B:
END; <-- Error: database is locked
Is session B complaining that session A has a lock ? If session A had a lock
why was there no complaint for the INSERT ? If session B had a lock why didn't
session A get a complaint when it did the SELECT * ?
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
