Re: [sqlite] Cause of disk I/O errors
I did report an issue much earlier on with regards to retrying io operations when some other process (like virus scanners) are touching the db file. Hopefully it will be of use to you: http://www.mail-archive.com/sqlite-users@sqlite.org/msg51895.html - Nasron Cheong ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Cause of disk I/O errors
Hello GHCS, Most common problem my users have is Virus scanners stepping on my writes. Might suggest they tell their Virus scanners to ignore your data folder. People do run out of disk space fairly frequently. I wouldn't discount it out of hand. C Sunday, January 30, 2011, 8:25:48 PM, you wrote: GS Are there any common reasons for encountering a disk I/O error (code GS 10) when creating records in an SQLite database on a Windows PC? My GS product uses V3.6.23.1 and I did not have extended error codes turned on GS in my releases up to now. GS The problem in reproducing this is that the users can be running XP, GS Vista, or Win7, and the amount and nature of the data being written is GS entirely dependent on data provided by the user and run through my GS processing program to create the database. When I've had someone upload GS their raw data to me so I can try it here, it works every time (naturally). GS So it seems it must be something about their particular machine GS environment, but what? I'm sure that nobody is running out of disk space GS these days. Any ideas on where to look or what to suggest to them that GS they can do? -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Cause of disk I/O errors
Are there any common reasons for encountering a disk I/O error (code 10) when creating records in an SQLite database on a Windows PC? My product uses V3.6.23.1 and I did not have extended error codes turned on in my releases up to now. The problem in reproducing this is that the users can be running XP, Vista, or Win7, and the amount and nature of the data being written is entirely dependent on data provided by the user and run through my processing program to create the database. When I've had someone upload their raw data to me so I can try it here, it works every time (naturally). So it seems it must be something about their particular machine environment, but what? I'm sure that nobody is running out of disk space these days. Any ideas on where to look or what to suggest to them that they can do? -- Doug Gordon *GHCS Software* http://www.ghcssoftware.com g...@ghcssoftware.com mailto:g...@ghcssoftware.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Cause of disk I/O errors
On 31 Jan 2011, at 1:25am, GHCS Software wrote: Are there any common reasons for encountering a disk I/O error (code 10) when creating records in an SQLite database on a Windows PC? [snip] So it seems it must be something about their particular machine environment, but what? File is protected against access ? Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Cause of disk I/O errors
On Sun, Jan 30, 2011 at 08:25:48PM -0500, GHCS Software scratched on the wall: Are there any common reasons for encountering a disk I/O error (code 10) when creating records in an SQLite database on a Windows PC? Check to be sure the application has permission to create new files in the same directory as the database file. Off the top of my head, I believe this error is returned if SQLite cannot create the WAL file or journal file required to complete a transaction. -j -- Jay A. Kreibich J A Y @ K R E I B I.C H Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable. -- Angela Johnson ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Cause of disk I/O errors
On Mon, Jan 31, 2011 at 4:25 AM, GHCS Software g...@ghcssoftware.comwrote: So it seems it must be something about their particular machine environment, but what? I'm sure that nobody is running out of disk space these days. Any ideas on where to look or what to suggest to them that they can do? Maybe antivirus software blocking the file exclusively? Max ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users