Re: [sqlite] Getting SQLITE_IOERR_WRITE when running sqlite
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
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
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