Information on how to open SQLite files:
http://www.sqlite.org/c3ref/open.html
How the locking mechanisms work: http://sqlite.org/lockingv3.html
Specifically, it'll depend on the language or wrapper you're using to
access the database. In my case (Delphi) there is an option in the open
function t
On Mon, Feb 10, 2014 at 4:40 PM, Stephen Chrzanowski wrote:
> Personally, I don't buy that DropBox is the culprit as I've done this kind
> of thing a few times in a few applications of my own, however, I'm the
> single user that works on that single account, and any app that uses DB is
> usually u
On Mon, 10 Feb 2014 16:20:40 -0500
C M wrote:
> But this must be a fairly commonly sought need. The solution you
> propose where I occasionally export a copy of the db to Dropbox is
> great *for backup purposes* but seems to exclude the possibility of
> syncing across multiple computers. So wh
On 10 Feb 2014, at 9:20pm, C M wrote:
> I purposefully put the SQlite database file in the Dropbox folder because
> it was my intention, with this app, to allow a user to use the app on more
> than one computer and "sync" the database via Dropbox. E.g., s/he could
> make changes to the db at ho
On 2014/02/10 23:40, Stephen Chrzanowski wrote:
Personally, I don't buy that DropBox is the culprit as I've done this kind
of thing a few times in a few applications of my own, however, I'm the
single user that works on that single account, and any app that uses DB is
usually under development a
On 2014/02/10 23:20, C M wrote:
On Mon, Feb 10, 2014 at 2:54 PM, RSmith wrote:
How to go from the error codes to the diagnosis? I think the logic is as
follows:
[lots of snipping]
Thanks for this insight.
I purposefully put the SQlite database file in the Dropbox folder because
it was m
Personally, I don't buy that DropBox is the culprit as I've done this kind
of thing a few times in a few applications of my own, however, I'm the
single user that works on that single account, and any app that uses DB is
usually under development and "closed" on any other geographical site.
However
On Mon, Feb 10, 2014 at 2:54 PM, RSmith wrote:
> How to go from the error codes to the diagnosis? I think the logic is as
> follows:
>
> We can see an error occurs when trying to access the file, or more
> specifically, trying to obtain a shared lock on it. This means it is locked
> by another ap
On 2014/02/10 21:18, C M wrote:
Documents\My Dropbox\myapp\gorp.db-journal) - Access is denied. (3338)
SQLITE_IOERR
SQLITE_LOG: statement aborts at 16: [SELECT resumes, start FROM
WHERE start='2014-02-07 14:24:14.064000' AND value='activity'] disk I/O
error (3338) SQLITE_IOERR
Looks like GetFi
On Mon, 10 Feb 2014 14:18:18 -0500, C M
wrote:
>On Sat, Feb 8, 2014 at 4:28 AM, Kees Nuyt wrote:
>>
>> On Sat, 08 Feb 2014 12:06:01 +0700, Dan Kennedy
>> wrote:
>
>
>
>> >> SQLITE_LOG: delayed 1375ms for lock/sharing conflict (10) SQLITE_IOERR
>> >>
>> >> SQLITE_LOG: os_win.c:35129: (5) winAcce
On 10 Feb 2014, at 7:18pm, C M wrote:
> I may want to deploy this app to users who would also backup their database
> by having it in the Dropbox folder. What would people suggest I do about
> this?
Don't run the app while Dropbox is messing with its datafile.
The problem is with Dropbox, whi
On Sat, Feb 8, 2014 at 4:28 AM, Kees Nuyt wrote:
>
> On Sat, 08 Feb 2014 12:06:01 +0700, Dan Kennedy
> wrote:
> >> SQLITE_LOG: delayed 1375ms for lock/sharing conflict (10) SQLITE_IOERR
> >>
> >> SQLITE_LOG: os_win.c:35129: (5) winAccess(C:\Documents and
Settings\user\My
> >> Documents\My Drop
On Sat, 08 Feb 2014 12:06:01 +0700, Dan Kennedy
wrote:
>On 02/08/2014 03:00 AM, C M wrote:
>> This is a follow-up to a question I asked on this list on Sep 1st, 2013,
>> about an error that I was randomly getting with disk-based SQLite database
>> in a Python desktop application. I now have more
On 02/08/2014 03:00 AM, C M wrote:
This is a follow-up to a question I asked on this list on Sep 1st, 2013,
about an error that I was randomly getting with disk-based SQLite database
in a Python desktop application. I now have more info to provide about the
error...such as what was asked for at
This is a follow-up to a question I asked on this list on Sep 1st, 2013,
about an error that I was randomly getting with disk-based SQLite database
in a Python desktop application. I now have more info to provide about the
error...such as what was asked for at that time:
On Sun, Sep 1, 2013 at 6:
On Mon, Sep 2, 2013 at 3:28 PM, E.Pasma wrote:
> Op 2 sep 2013, om 17:58 heeft C M het volgende geschreven:
>
>> ...
>>
>> Is setting up APSW and making the transition from pysqlite2's wrapper
>> fairly straightforward, or would I have to re-do all the database queries?
>> (Even so, I do them all
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/09/13 08:58, C M wrote:
> If you think APSW would provide more details about just what went
> wrong other than "SQLite logic error or missing database" (which, I
> feel, doesn't tell me much at all), then I could potentially try it.
I'm in the p
Op 2 sep 2013, om 17:58 heeft C M het volgende geschreven:
...
Is setting up APSW and making the transition from pysqlite2's wrapper
fairly straightforward, or would I have to re-do all the database
queries?
(Even so, I do them all in one utilities library, so perhaps it
would be
not too muc
On Sun, Sep 1, 2013 at 6:12 PM, Richard Hipp wrote:
> Does Python have an interface to the error and warning log mechanism of
> SQLite? (http://www.sqlite.org/errlog.html) Can you turn that on? It
> will probably give more details about what it happening.
>
Looks like, no, though maybe Roger
On Sun, Sep 1, 2013 at 7:51 PM, Roger Binns wrote:
>
> He needs to give the exception traceback which will show what is happening
> at the time.
>
> A common mistake with newish Python programmers is to catch all
> exceptions, and then keep going which also hides the exception tracebacks.
>
I ha
On Mon, Sep 2, 2013 at 2:33 AM, Markus Schaber wrote:
> Hi, C M,
>
>
> Just to be safe: Can you roule out any antivirus or other security
> software locking the files temporarily?
>
Good idea, but I don't think that is what is happening in my case. I
actually have a way to catch the "Database is
On Sun, Sep 1, 2013 at 6:53 PM, Simon Slavin wrote:
>
> On 1 Sep 2013, at 10:34pm, C M wrote:
>
> > Do you know how I can do that with Python? For example, I tried this:
> >
> > status = cursor.execute("some SQL statement here")
> > print "The status is: ", status
> >
> > But it prints the curs
Hi, C M,
Im Auftrag von C M
> On Sun, Sep 1, 2013 at 4:28 PM, jose isaias cabrera
> wrote:
> > "C M" wrote...
> > Keeping it simple:
> >>
> >> I have a Python application that uses SQLite, and I randomly get this
> >> error:
> >>
> >> "SQL logic error or missing database"
> >>
> >> Is the datab
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
He needs to give the exception traceback which will show what is happening
at the time.
A common mistake with newish Python programmers is to catch all
exceptions, and then keep going which also hides the exception tracebacks.
On 01/09/13 15:12, Rich
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 01/09/13 14:34, C M wrote:
> Do you know how I can do that with Python? For example, I tried this:
>
> status = cursor.execute("some SQL statement here") print "The status
> is: ", status
>
> But it prints the cursor object:
>
>> The status is
On 1 Sep 2013, at 10:34pm, C M wrote:
> Do you know how I can do that with Python? For example, I tried this:
>
> status = cursor.execute("some SQL statement here")
> print "The status is: ", status
>
> But it prints the cursor object:
>
>> The status is
Does the cursor object have propert
Does Python have an interface to the error and warning log mechanism of
SQLite? (http://www.sqlite.org/errlog.html) Can you turn that on? It
will probably give more details about what it happening.
On Sun, Sep 1, 2013 at 5:32 PM, C M wrote:
> On Sun, Sep 1, 2013 at 1:38 PM, Richard Hipp wro
On Sun, Sep 1, 2013 at 4:28 PM, jose isaias cabrera
wrote:
>
> "C M" wrote...
>
>
> Keeping it simple:
>>
>> I have a Python application that uses SQLite, and I randomly get this
>> error:
>>
>> "SQL logic error or missing database"
>>
>> Is the database in network drive or not in the same machi
On Sun, Sep 1, 2013 at 2:23 PM, Simon Slavin wrote:
>
> On 1 Sep 2013, at 6:38pm, Richard Hipp wrote:
>
> > A good starting place might be to tell us what the program is doing when
> > the error comes back.
>
> As well as telling us the call that trieggers the error, please put logic
> into your
On Sun, Sep 1, 2013 at 1:38 PM, Richard Hipp wrote:
> On Sun, Sep 1, 2013 at 1:12 PM, C M wrote:
>
> >
> > I have a Python application that uses SQLite, and I randomly get this
> > error:
> >
> > "SQL logic error or missing database"
> >
> > I have no idea how to figure out what's wrong,
> >
>
>
"C M" wrote...
Keeping it simple:
I have a Python application that uses SQLite, and I randomly get this
error:
"SQL logic error or missing database"
Is the database in network drive or not in the same machine that is running
the app?
___
sqli
On 1 Sep 2013, at 6:38pm, Richard Hipp wrote:
> A good starting place might be to tell us what the program is doing when
> the error comes back.
As well as telling us the call that trieggers the error, please put logic into
your program so that it not only checks the result code of the call th
On Sun, Sep 1, 2013 at 1:12 PM, C M wrote:
>
> I have a Python application that uses SQLite, and I randomly get this
> error:
>
> "SQL logic error or missing database"
>
> I have no idea how to figure out what's wrong,
>
A good starting place might be to tell us what the program is doing when
th
Keeping it simple:
I have a Python application that uses SQLite, and I randomly get this error:
"SQL logic error or missing database"
I have no idea how to figure out what's wrong, and if I can't figure it
out, it leaves a huge deal-breaking bug in my application, such that I'd
have to abandon S
34 matches
Mail list logo
