Thank you Simon. So I have to stop using database when error between 1 to 26.
If I use new database connection (sqlite3*) for every query, will it cause disk io error? I am encrypting database with secret key. I changed page size also. Can sqlite handle encrypted database and different page sizes? On Fri, Dec 7, 2012 at 2:06 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 6 Dec 2012, at 7:57pm, dd <durga.d...@gmail.com> wrote: > > > It's checking with OK, BUSY, 101 and some other errors. But not disk io, > > image malformed errors. How to handle these errors in run time? these > > databases have critical information about customers. We cannot stop > > application. Any inputs? > > Proceeding after anything but SQLITE_OK, and the special result codes > expected when you do sqlite3_step() will only make more problems. The > first time you get an error like DISK IO you have to stop. Anything > written to the database after that will probably fail, but if it doesn't > fail it'll probably just corrupt the database file. > > But it's extremely unusual for users of SQLite to see errors 10 or 11. > They almost always indicates faulty hardware or that some part of your > operating system has become corrupt (which might itself be the result of > faulty hardware). > > 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
