---------- Forwarded message ----------
From: wei luo <luowe...@gmail.com>
Date: 2012/7/20
Subject: Some kind of disk I/O error occurred–SQLite3
To: danielk1...@gmail.com
hi:
i am a user who is seeing some kind of disk I/O error when
attempting to use an SQLite3 database.
i want to ask for you help. my programe was writen by this:
while ( (res->sp) < row )
{
rc = sqlite3_step(res->pstmt);
if ( SQLITE_ROW == rc )
{
(res->sp)++;
}
else
{
return rc;
}
}
And i had use gdb getting the rc value. it is 10. And the 10 is
SQLITE_IOERR. See below:
#define SQLITE_IOERR 10 /* Some kind of disk I/O error occurred */
And i find the SQLITE_IOERR in your open sources. i got the infomation.
it is below:
/**********************************************************************
** The file I/O implementation can use the object type flags to
** change the way it deals with files. For example, an application
** that does not care about crash recovery or rollback might make
** the open of a journal file a no-op. Writes to this journal would
** also be no-ops, and any attempt to read the journal would return
** SQLITE_IOERR. Or the implementation might recognize that a database
** file will be doing page-aligned sector reads and writes in a random
** order and set up its I/O subsystem accordingly.
****************************************************************************/
Did it have any relations with journal ? if it had. Please tell me, how to
del the journal or how to resolve this problem.
Thanks
luowei
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
