I have 10 databases. One database got disk io error, later it's used by application without proper handling, so it's corrupted.
After some days, one more database also corrupted without io error. Sqlite returned error code 11. It's fully corrupted. Are these corruptions depend on other database integrity? I am using this database for "schengen countries" customers. Can sqlite handle these characters(special)? On Fri, Dec 7, 2012 at 5:51 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 7 Dec 2012, at 1:36pm, dd <durga.d...@gmail.com> wrote: > > > Thank you Simon. > > > > So I have to stop using database when error between 1 to 26. > > You have to stop when you get any code you do not have specific logic to > handle. Here is the list of result codes: > > <http://www.sqlite.org/c3ref/c_abort.html> > > You can expect 0 from anything, and 100 and 101 from _step() calls. You > may have written your own software which will cause or handle various > errors (e.g. 4, 9, 19). Anything you haven't written your own code to > handle is a sign that your program needs to immediately stop until you have > figured out what caused the error. > > You might find it useful to look at the extended result codes if you don't > understand what's causing an error: > > <http://www.sqlite.org/c3ref/extended_result_codes.html> > <http://www.sqlite.org/c3ref/c_abort_rollback.html> > > > If I use new database connection (sqlite3*) for every query, will it > cause > > disk io error? > > It will not create them or prevent them, it will just make your software > slower. That result code is what happens when your operating system > reports an error, which it may do for anything from broken hardware, a full > hard disk, or trying to edit a file without high enough permissions. I > don't know what's causing the SQLITE_IOERR that you have seen. > > > I am encrypting database with secret key. I changed page size also. Can > > sqlite handle encrypted database and different page sizes? > > Each database has only one page size. You can have as many databases open > at the same time as you want. They do not all have to have the same page > size. > > 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
