Martin Alfredsson jma.se> wrote:
I understand, I to did not understand what happened.
But the code below shows my point (sorry for the horrible indentation).
Rather than apologize, why not just fix it? Is your time so
much more valuable than ours that you cannot be troubled with
such mund
>From: Igor Tandetnik <[EMAIL PROTECTED]>
>Subject: Re: Where to look in the code for this ?
>Newsgroups: gmane.comp.db.sqlite.general
>Date: 2006-10-02 21:53:13 GMT (1 hour and 1 minute ago)
>Martin Alfredsson <[EMAIL PROTECTED]> wrote:
>>> Surely you mean &q
>>Martin Alfredsson <[EMAIL PROTECTED]> wrote:
>> My problem is that the SHARED lock does not stay after
>>_step() returns
>> SQLITE_DONE and that this allows another process to update the
>> database and I end up with a locked database.
>Why exactly
Anyone familiar with SQLite source ?
Opened a tecked a few days ago (#1995). However I did not check enough
and found out I only got the error in a subset of the tests;
My problem is that the SHARED lock does not stay after _step() returns
SQLITE_DONE and that this allows another process to
http://www.sqlite.org/cvstrac/tktnew
gives;
Query failed
Database query failed:
SELECT name, value FROM enums WHERE type='type'
Reason: database disk image is malformed
/Martin
-
To unsubscribe, send email to
m have a lock.
>What I do to make writing efficient and the logic simple is to use a
>mutex to synchronize the writes.
>Martin Alfredsson wrote:
>> Hi !
>>
>> Only one process IS writing at once. The problem is that if
>> the writing is able to happen aft
to an Sqlite database at any time. The logic >of
>your application has to enforce that "serialization" or "single
>streaming" in some way.
>From: John Stanton <[EMAIL PROTECTED]>
>Subject: Re: Please help me locking/transaction? logic !
>Newsgro
Is this correct ?
My program calls:
sqlite3_prepare(...)
sqlite3_step(...)
Here another process writes to the database sqlite3_exec(...)
sqlite3_finalize(...)
Now my program will fail with SQLITE_BUSY (5) when
accessing the database.
If I dont terminate the other process restaring my program
;Date: 2006-09-23 15:12:09 GMT (38 minutes ago)
>On 9/23/06, Martin Alfredsson <[EMAIL PROTECTED]> wrote:
>> Tried to solve a problem and what I did was to open the
>> database over the net and then physically disconnect
>> the machine.
>>
>> I can still SELECT
Hi !
Tried to solve a problem and what I did was to open the
database over the net and then physically disconnect
the machine.
I can still SELECT !
sqlite3_prepare() works and gives SQLITE_OK
sqlite3_step() gives SQLITE_ROW but is very, very slow
sqlite3_finalize() works.
First when I do
>Usually, the SQLITE_LOCKED means that you tried to prepare or execute
a >new SQL statement without resetting or finalizing a previous one on a
>single connection. The statements should be prepared and executed this
I'm NOT getting SQLITE_LOCKED.
The error I get is SQLITE_BUSY (5).
For some
Hi !
I'm getting a lots of "database is locked" (code:5).
My app keeps giving up on one machine, it might be that
there is a network problem but I not 100% sure.
Anyway, when the app hangs all the other machines
including the machine where the database file is get
the "database is locked"
using it as multiuser on a lan.
Does it crash due to network problem, does it work better with WinXP
than Win9x/2k/linux etc.
John Martin Alfredsson
ma1999ATjmaDOTse
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
Is this true, will it be included in 3.3.8 ?
Any time estimate when release with this is released ?
John Martin Alfredsson
ma1999ATjmaDOTse
sequence" be a consiquence of
the above ?
Sorry for bugging this list with all these questions but I need to help
my customer
and I need to know what I do wrong so that I can avoid trouble in the
future.
John Martin Alfredsson
ma1999ATjmaDOTse
stion how to debug this ?
Any help would be great !!
John Martin Alfredsson
(mailATjmaDOTse)
16 matches
Mail list logo