I understand your points Simon. Let me explain scenario where I got this disk io error then my database got corrupted.
My multithreaded application do all read/write operations. For each query, it opens database connection and execute query then close connection. This application executes plenty of records within a second. In this scenario, Application got disk io error within couple of hours with new database. (even space available on that machine). Application didn't handle this error. So application continued execution. After that, disk image malformed errors are thrown by sqlite for some records only. There was no other errors before disk io error. I suspect, after disk io error only these errors are introduced. Any ideas? On Fri, Dec 7, 2012 at 12:39 AM, dd <durga.d...@gmail.com> wrote: > No Robert. It's on same machine -- multiple threads within process, > TRUNCATE mode. > > > On Fri, Dec 7, 2012 at 12:38 AM, Robert Myers <rob.my...@ziften.com>wrote: > >> One thing I haven't seen anyone ask yet - are you putting this on a >> network drive? >> On 12/6/2012 10:52 AM, Durga D wrote: >> > Hi, >> > >> > Is it possible to corrupt a single table among 10 tables in a >> database? >> > >> > Is it possible to corrupt some records among millions of records in a >> > table? >> > >> > Best Regards, >> > _______________________________________________ >> > 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
