Re: [sqlite] Cause of "disk I/O errors"

2011-02-01 Thread Nasron Cheong 
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"

2011-01-31 Thread Teg 
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

Re: [sqlite] Cause of "disk I/O errors"

2011-01-30 Thread Max Vlasov 
On Mon, Jan 31, 2011 at 4:25 AM, GHCS Software wrote:

>
> 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

Re: [sqlite] Cause of "disk I/O errors"

2011-01-30 Thread Jay A. Kreibich 
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"

2011-01-30 Thread Simon Slavin 

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