Re: [sqlite] Getting SQLITE_IOERR_WRITE when running sqlite

[Zsbán Ambrus]

On 1/2/15, Dan Kennedy  wrote:
> On 01/02/2015 04:44 PM, Waiba, Aswin wrote:
>> we were getting SQLITE_IOERR_WRITE (778).
>
> It means a call to write(), pwrite(), fallocate() or similar has failed.
> Because it ran out of disk space, or the media was removed or perhaps is
> faulty. Or a bug in SQLite might be causing invalid parameters to be
> passed to one of these system calls.

Note that if you run out of disk space, you're usually supposed to get
 SQLITE_FULL as the error code from sqlite, rather than
SQLITE_IOERR_WRITE.

-- ambrus
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Getting SQLITE_IOERR_WRITE when running sqlite

[Dan Kennedy]

On 01/02/2015 04:44 PM, Waiba, Aswin wrote:

Hi,

I am currently using sqlite version 3.7.14 in our application. We are using it 
via a single thread, however we are getting SQLITE_IOERR (10) when running the 
application. After enabling the extended result code, we found out that we were 
getting SQLITE_IOERR_WRITE (778). After going through the sqlite code for 
version 3.7.14 I could see that the error was being thrown from unixWrite() and 
unixFileControl() (as the application is deployed on Unix). However we are 
unsure why the error is being thrown from those places.
Has anyone got these kind of errors before and if yes, how was it solved. Any 
feedback will be of great help.


It means a call to write(), pwrite(), fallocate() or similar has failed. 
Because it ran out of disk space, or the media was removed or perhaps is 
faulty. Or a bug in SQLite might be causing invalid parameters to be 
passed to one of these system calls.


Running under [strace] or equivalent might help to figure out why the 
system call is failing.


Dan.






Thanks and Regards
Aswin Waiba




===
Please access the attached hyperlink for an important electronic communications 
disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
===
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Getting SQLITE_IOERR_WRITE when running sqlite

[Waiba, Aswin]

Hi,

I am currently using sqlite version 3.7.14 in our application. We are using it 
via a single thread, however we are getting SQLITE_IOERR (10) when running the 
application. After enabling the extended result code, we found out that we were 
getting SQLITE_IOERR_WRITE (778). After going through the sqlite code for 
version 3.7.14 I could see that the error was being thrown from unixWrite() and 
unixFileControl() (as the application is deployed on Unix). However we are 
unsure why the error is being thrown from those places.
Has anyone got these kind of errors before and if yes, how was it solved. Any 
feedback will be of great help.

Thanks and Regards
Aswin Waiba




=== 
Please access the attached hyperlink for an important electronic communications 
disclaimer: 
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html 
=== 
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users