I've narrowed this locking issue down to a very simply test case. It seems as
though having the same file attached multiple times with different names
prevents exclusive or immediate transactions from acquiring a lock. Deferred
transactions still seem to work fine. Try the following code:
#d
100
>> From: Simon Slavin
>> To: General Discussion of SQLite Database
>> Subject: Re: [sqlite] Sqlite locking issue with ATTACH'ed databases
>> Message-ID:
>> Content-Type: text/plain; charset=us-ascii
>
>
>> On 16 Jul 2013, at 11:24pm, Loren Kea
On 18 Jul 2013, at 8:26pm, Loren Keagle wrote:
> It definitely seems to be related to having the same database attached
> multiple times with different names.
Okay. I have absolutely no idea how well SQLite copes with that. I'm not
saying it's bad, I just have no idea at all. I hope one of
>Date: Wed, 17 Jul 2013 17:21:15 +0100
>From: Simon Slavin
>To: General Discussion of SQLite Database
>Subject: Re: [sqlite] Sqlite locking issue with ATTACH'ed databases
>Message-ID:
>Content-Type: text/plain; charset=us-ascii
>On 16 Jul 2013, at 11:24pm, Lore
>> Prepare query statement;
>> Iterate through one or more rows;
>> Reset statement;
>>
>> Attempt to begin transaction; <--- SQLITE_BUSY
"The sqlite3_reset() function is called to reset a prepared statement
object back to its initial state, ready to be re-executed. Any SQL
statement variables
If you remove a busy check, does it output any statements?
Do you have any custom functions/operations running so they could block
sqlite in creating new statement?
2013/7/17 Loren Keagle
> Hi everyone,
>
> I have an interesting locking problem that I'm wondering if someone can
> help with some
On 16 Jul 2013, at 11:24pm, Loren Keagle wrote:
> Begin EXCLUSIVE TRANSACTION;
> insert several rows of data;
> Commit transaction;
>
> Prepare query statement;
> Iterate through one or more rows;
> Reset statement;
>
> Attempt to begin transaction; <--- SQLITE_BUSY
> Would like to write m
Hi everyone,
I have an interesting locking problem that I'm wondering if someone can help
with some insight.
I have a master database with some metadata, and several sub-databases to store
logging events. I have one reader object and one writer object that attach to
the sub-databases and encap
8 matches
Mail list logo