On Tue, Apr 12, 2011 at 6:06 PM, jeff archer <jarch...@yahoo.com> wrote:
> I have a process which analyzes an image then writes results to database. > (sqlite 3.7.4) > When I run multiple of these in parallel, each on its own image but all on > the > same database, and all on same machine (Windows 7) I get an error from > sqlite3_step() when attempting to execute "BEGIN IMMEDIATE". I get > proportionaly more errors when I run more processes in parallel. A high > percentage of the error occurs just after successful open when trying to > check > for some existing values to confirm this is correct file. > > The error looks like it is always from sqlite3_step() on the "BEGIN > IMMEDIATE" > I am getting a return from sqlite3_step() of 3338. > sqlite3_errmsg16() is returning "disk I/O error" > sqlite3_prepare16_v2 returned success. > > 3338 is the extended error code. In your case it means that a call to GetFileAttributesExW() failed for some reason other than ERROR_FILE_NOT_FOUND. I have no idea why that might be. Set your breakpoint on the function winAccess if you want to try to debug this. > And now that I am digging into this I am not sure I have this correct. > Am I supposed to get my error code from sqlite3_step() because I have now > also > noticed sqlite3_extended_errcode()? > Is 3338 an extended error code?Do I need to use sqlite3_open_v2 to get the > extended error code? > > Jeff Archer > Nanotronics Imaging > jsarc...@nanotronicsimaging.com > <330>819.4615 > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users