If I had the same problem ... I would: 1. Refresh the surface of the hard drive using spinrite (grc.com), which is OS and file-structure independent;
2. Then, I'd run the Linux equivalent to the Windows chkdsk command to resolve any file-structure issues; In all but the worst hard drive issues, this would in all likelihood take care of any read errors. --- On Mon, 6/20/11, Raja Kondu <rkondu.t...@gmail.com> wrote: From: Raja Kondu <rkondu.t...@gmail.com> Subject: [sqlite] Sqlite database integrity check fails with disk I/O error (10) To: sqlite-users@sqlite.org Date: Monday, June 20, 2011, 11:25 AM Hi I am using the Sqlite database in the linux box . Here I am encountered the disk I/O error when I perform the integrity check on the database. The error occuted during the sqlite prepare statement only. The prepared select statement is : " pragma integrity_check " retValue = sqlite3_prepare(pDb,pragma integrity_check ) ; retvalue = 10 #define SQLITE_IOERR 10 /* Some kind of disk I/O error occurred */ Can some one help me why the disk I/O error occured during the sqlite3_prepare() statement ? Kindly provide me your feed back. -- Thanks, Raja Kondu. _______________________________________________ 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
