Maybe this post might be of interest here:
http://sqlite.1065341.n5.nabble.com/malformed-database-schema-td65610.html

I had several corrupted databases the last few days. Unfortunately, I
haven't found out the cause yet.


2012/12/6 Durga D <durga.d...@gmail.com>

> I will run integrity check.
>
> >>I would like to know, why sqlite throws disk io error while inserting
>  records...
>
> I suspect, linking among pages will  be broken in sqlite database when disk
> io error thrown by sqlite. Is it?
>
>
> On Thu, Dec 6, 2012 at 11:30 PM, Simon Slavin <slav...@bigfraud.org>
> wrote:
>
> >
> > On 6 Dec 2012, at 5:23pm, Durga D <durga.d...@gmail.com> wrote:
> >
> > > Is it (corruption) related error code 10? (disk io)
> > >
> > > I would like to know, why sqlite throws disk io error while inserting
> > > records...
> >
> > It doesn't matter.  Run an in integrity check:
> >
> > <http://www.sqlite.org/pragma.html#pragma_integrity_check>
> >
> > If the integrity check reports a problem, rescue the data you can.  Throw
> > away the corrupt database and make a new one.
> >
> > If the integrity check doesn't report a problem, your error is very
> > unlikely to be related to a corrupt database.  Check your hardware and
> your
> > software.
> >
> > Simon.
> > _______________________________________________
> > 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-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to