On 4 Feb 2019, at 3:15pm, Urs Wagner wrote:
> SQLite error (5): database is locked occurs?
Can't answer your question, but …
If you're getting unexpected locks, have you set a timeout on every connection
to that database ? That gets rid of most locks.
Si
Hello
Is it possible to get a C# exception when the error
SQLite error (5): database is locked occurs?
I am using the entity framework with multiple thread and a global mutex.
I would like to know which call generates the locking error.
Thanks
On Tue, 15 Jan 2019 at 02:54, Simon Slavin wrote:
> The "just-in-time" idea mentioned in your question doesn't work in real
> life, since constantly checking mutex status keeps one core completely
> busy, using lots of power and generating lots of heat.
>
Technically "just-in-time" could be
On 14 Jan 2019, at 7:04pm, Tim Streater wrote:
> Hmm, from my attempt at interpreting the source code I gained the impression
> that the handler used exponential backoff for the first few attempts, but
> then used a constant period for the rest (up to the set limit). Is this not
> the case?
On 14 Jan 2019, at 18:54, Simon Slavin wrote:
> SQLite's own busy_timeout routine (the one you get if you don't supply your
> own) uses exponential backoff. It first sleeps for a very small amount of
> time, then checks the lock. If access is still prevented it sleeps longer,
> then checks
On 14 Jan 2019, at 6:34pm, Thomas Kurz wrote:
>> pragma_busy_timeout
>
> Does setting the busy_timeout retry periodically (e.g. every x milliseconds),
> or is there some automatism that ensures that the requested operation is done
> just-in-time as soon as the previous/blocking operation is
> pragma_busy_timeout
Does setting the busy_timeout retry periodically (e.g. every x milliseconds),
or is there some automatism that ensures that the requested operation is done
just-in-time as soon as the previous/blocking operation is finished?
___
.
>-Original Message-
>From: sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of Urs Wagner
>Sent: Monday, 14 January, 2019 02:24
>To: SQLite mailing list
>Subject: [sqlite] SQLite error (5): database is locked
>
>Hallo
>
>I use seve
On 14 Jan 2019, at 9:23am, Urs Wagner wrote:
> 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?
Please set a timeout for all connections to your database
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
sqlite-users@mailinglists.sqlite.org
gt; users-bounces at mailinglists.sqlite.org] On Behalf Of Hick Gunter
> Sent: Wednesday, March 04, 2015 8:45 AM
> To: 'General Discussion of SQLite Database'
> Subject: Re: [sqlite] SQLite error(5): database is locked in
> System.Data.SQLite
>
> Only one writer may be active a
On 4 Mar 2015, at 1:45pm, Hick Gunter wrote:
> Only one writer may be active at any one time. The other(s) will recieve an
> error return status. You can either wait a while and retry this in your
> application or set a busy timeout to handle the "usual" cases for you.
Agreed. The default
t.savaliya at matrixcomsec.com]
Gesendet: Mittwoch, 04. M?rz 2015 07:46
An: sqlite-users at mailinglists.sqlite.org
Betreff: [sqlite] SQLite error(5): database is locked in System.Data.SQLite
Hi all,
I am using System.Data.SQLite in my project.
I have two threads which are updating database simu
Hi all,
I am using System.Data.SQLite in my project.
I have two threads which are updating database simultaneously.
I get SQLite error(5): database is locked, System.Data.SQLite error.
Why is it so!. What could be the reason? Does System.Data.SQLite is not
thread safe?
Please help me out
14 matches
Mail list logo