On Mon, 10 Feb 2014 14:18:18 -0500, C M <cmpyt...@gmail.com> wrote: >On Sat, Feb 8, 2014 at 4:28 AM, Kees Nuyt <k.n...@zonnet.nl> wrote: >> >> On Sat, 08 Feb 2014 12:06:01 +0700, Dan Kennedy >> <danielk1...@gmail.com> 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 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 > > >> >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. > >May I ask either Dan or Kees, or anyone here, how to go from the error >codes to that diagnosis? > >Kees, why do you think Dropbox is the culprit?
Because the log indicates that the database and its journal are located in a dropbox directory: "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" Given that name, I just assumed you are using dropbox. Dropbox will try to synchronise files in that directory with its copy in the cloud whenever its contents have changed. In an effort to make a consistent copy, dropbox will probably lock the file during the copy operation. Both the database and its journal will change frequently when you are using it, and dropbox will try yo keep up. You may want to temporarily disable dropbox to avoid this unwanted cpncurrent access, or perhaps restrict dropbox to time slots when you don't use the database. >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? Perhaps you could put the database somewhere else and periodically use the sqlite3_backup() interface to save a copy to the dropbox folder. >Thanks again to all. (btw, I now view my original subject line as a bit >much; I was just frustrated by it happening so randomly and without the >ability to fix it) -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
