On 20 Mar 2015, at 6:12pm, Kumar Suraj <surajnitk at gmail.com> wrote:
> we get error SQLITE_IOERR_SHORT_READ once in a while. While > > error is Ok for us we were interested to know whether there are retries made > > internally when ever SQLite encounter this kind of error. <https://www.sqlite.org/rescode.html#ioerr_short_read> "The SQLITE_IOERR_SHORT_READ error code is an extended error code for SQLITE_IOERR indicating that a read attempt in the VFS layer was unable to obtain as many bytes as was requested. This might be due to a truncated file." This indicates a file format error or possibly a hardware fault. A retry would not help. You should see this fault. Seeing this fault should worry you. I think one of the following is true: (A) your database is corrupt (and will fail PRAGMA integrity_check) (B) you are using a non-standard VFS layer and it is buggy (C) you are accessing the file across a network (D) you have a hardware fault. Not 100% sure about the hardware fault but it is something to consider. Simon.