With journal mode, SQLite supports 1 writer OR n readers; with WAL mode, SQLite supports 1 writer AND N readers.
In any case, connections need to indicate if or how long they are willing to wait for the db file to be unlocked. Default is NO. The easiest way is to specify a timeout on the connection. The value needs to be longer than your longest write transaction is expected to run and shorter than the latency required by your application. -----Ursprüngliche Nachricht----- Von: sqlite-users [mailto:[email protected]] Im Auftrag von Urs Wagner Gesendet: Montag, 14. Jänner 2019 10:24 An: SQLite mailing list <[email protected]> Betreff: [EXTERNAL] [sqlite] SQLite error (5): database is locked Hallo I use several tasks in C# to call Sqlite queries. No I get the error SQLite error (5): database is locked. Is it not possible to use more than one tasks with Sqlite? Regards Urs _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___________________________________________ Gunter Hick | Software Engineer | Scientific Games International GmbH | Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43 1 80100 - 0 May be privileged. May be confidential. Please delete if not the addressee. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
