> Can some one help me why the disk I/O error occured during the
> sqlite3_prepare()  statement ?

Because while preparing the statement SQLite must read schema from the
database. And although in case of integrity check it's not really
necessary I think it's still the general rule and is done before it's
even known what statement is being prepared just so that resolving of
all identifiers could be done during the parsing.


Pavel


On Mon, Jun 20, 2011 at 11:25 AM, Raja Kondu <rkondu.t...@gmail.com> wrote:
> 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

Reply via email to