On Sat, 08 Feb 2014 12:06:01 +0700, Dan Kennedy <danielk1...@gmail.com> 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 info to provide about the >> error...such as what was asked for at that time: >> >> On Sun, Sep 1, 2013 at 6:12 PM, Richard Hipp <d...@sqlite.org> 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. >>> >> I wasn't able to do this at first, but thanks to switching from the >> standard sqlite3 module in Python (otherwise known as pysqslite) to Roger >> Binns's APSW module, and then also using an experimental module, >> apswdbapi2, from Edzard Pasma (thank you both), I was able to set things up >> to return the warning log...I think. Today, after not seeing the error in >> a very long time, I hit the error, and this was printed to sys.stdout: >> >> 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 Dropbox\myapp\gorp.db-journal) - Access is denied. (3338) >> SQLITE_IOERR >> >> SQLITE_LOG: statement aborts at 16: [SELECT resumes, start FROM Durations >> WHERE start='2014-02-07 14:24:14.064000' AND value='activity'] disk I/O >> error (3338) SQLITE_IOERR >> >> Does that give anyone a better idea of what could be happening and how I >> can fix this problem? > >Looks like GetFileAttributesEx() might be throwing an ERROR_ACCESS_DENIED >exception. Maybe a virus scanner or some other background process had >temporarily locked the database file. > >Dan. I agree, and I think Dropbox is the culprit here. -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
