Re: [sqlite] [EXTERNAL] SQLite error (5): database is locked

2019-01-14 Thread Simon Slavin
On 14 Jan 2019, at 11:14am, Urs Wagner wrote: >ProviderConnectionString = @"data source=" + _dataBase + > ";PRAGMA foreign_keys = ON;PRAGMA locking_mode = EXCLUSIVE;PRAGMA > schema.synchronous = NORMAL; PRAGMA schema.journal_mode = DELETE; PRAGMA > busy_timeout = 10" I am

Re: [sqlite] [EXTERNAL] SQLite error (5): database is locked

2019-01-14 Thread Urs Wagner
rs On Behalf > Of Hick Gunter > Sent: Monday, January 14, 2019 11:28 AM > To: 'SQLite mailing list' > 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

Re: [sqlite] [EXTERNAL] SQLite error (5): database is locked

2019-01-14 Thread Barry Smith
ck Gunter > Sent: Monday, January 14, 2019 11:28 AM > To: 'SQLite mailing list' > 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. > &g

Re: [sqlite] [EXTERNAL] SQLite error (5): database is locked

2019-01-14 Thread Hick Gunter
in" is desired. -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Urs Wagner Gesendet: Montag, 14. Jänner 2019 12:14 An: SQLite mailing list Betreff: Re: [sqlite] [EXTERNAL] SQLite error (5): database is locked We are us

Re: [sqlite] [EXTERNAL] SQLite error (5): database is locked

2019-01-14 Thread Urs Wagner
LETE; PRAGMA busy_timeout = 10" }; -Original Message- From: sqlite-users On Behalf Of Hick Gunter Sent: Monday, January 14, 2019 11:28 AM To: 'SQLite mailing list' Subject: Re: [sqlite] [EXTERNAL] SQLite error (5): database is locked With journal mode, SQLite supports 1 writer OR n readers;

Re: [sqlite] [EXTERNAL] SQLite error (5): database is locked

2019-01-14 Thread Hick Gunter
: Montag, 14. Jänner 2019 10:24 An: SQLite mailing list 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