Re: [sqlite] Database Disk Full

2006-02-10 Thread John Stanton
Since the file access has already worked by this stage the "plethora" is far smaller than you may have appreciated. It is a reasonable assumption to make that the only thing which can have changed since the last write is the disk becoming full. A disk cable falling off, head crash or

RE: [sqlite] Database Disk Full

2006-02-10 Thread Drew, Stephen
:[EMAIL PROTECTED] Sent: 10 February 2006 17:28 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Database Disk Full "Drew, Stephen" <[EMAIL PROTECTED]> wrote: >> > It's just a little bit misleading if you're not familiar with the > circumstances it's raised in... I've

Re: [sqlite] Database Disk Full

2006-02-10 Thread drh
"Drew, Stephen" <[EMAIL PROTECTED]> wrote: >> > It's just a little bit misleading if you're not familiar with the > circumstances it's raised in... I've had some confused colleagues > wondering why their 100kb DB on a disk with 15gb free would be out of > space :) > I'm curious. What was

RE: [sqlite] Database Disk Full

2006-02-10 Thread Drew, Stephen
the file write failed. Many thanks, and keep up the great work! Steve -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 10 February 2006 17:01 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Database Disk Full "Drew, Stephen" <[EMAIL PROTECTED]>

Re: [sqlite] Database Disk Full

2006-02-10 Thread drh
"Drew, Stephen" <[EMAIL PROTECTED]> wrote: > Hello, > > In sqlite3OsWrite function (in os_win.c) the following code exists: > > while( amt>0 && (rc = WriteFile(id->h, pBuf, amt, , 0))!=0 && > wrote>0 ){ > > amt -= wrote; > > pBuf = &((char*)pBuf)[wrote]; > > } > > if( !rc ||