Please note the the semicolon at the end of an SQL Statement is required. "PRAGMA busy_timeout = 1000000" is not complete SQL. Also, the schema prefix needs to be replaced with the attach name of the database whose properties you wish to query/change. It may be omitted if "main" is desired.
-----Ursprüngliche Nachricht----- Von: sqlite-users [mailto:[email protected]] Im Auftrag von Urs Wagner Gesendet: Montag, 14. Jänner 2019 12:14 An: SQLite mailing list <[email protected]> Betreff: Re: [sqlite] [EXTERNAL] SQLite error (5): database is locked We are using entity framework The timeout pragma does not work. Is think the timeout is not set, see below var esb = new EntityConnectionStringBuilder { Metadata = "res://*/RadaxModel.csdl|res://*/RadaxModel.ssdl|res://*/RadaxModel.msl", Provider = "System.Data.SQLite.EF6", ProviderConnectionString = @"data source=" + _dataBase + ";PRAGMA foreign_keys = ON;PRAGMA locking_mode = EXCLUSIVE;PRAGMA schema.synchronous = NORMAL; PRAGMA schema.journal_mode = DELETE; PRAGMA busy_timeout = 100000" }; -----Original Message----- From: sqlite-users <[email protected]> On Behalf Of Hick Gunter Sent: Monday, January 14, 2019 11:28 AM To: 'SQLite mailing list' <[email protected]> Subject: Re: [sqlite] [EXTERNAL] SQLite error (5): database is locked 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 _______________________________________________ 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
