Hi, I have developed an application which is using sqlite database for querying data from the database which ships with it. Several days ago the database somehow got corrupted.
The application is only issuing select statements (no insert/update/delete or vacuum) so I cannot understand what could have caused database corruption. The database is accessed via .Net provider and is password protected. Database size is about 500MB. Sqlite version is 3.6.23.1 There is only one table, one index and one system table produced by Analyze command. No triggers, no joins, no foreign keys. The result from integrity check is: *** in database main *** Page 44449: btreeInitPage() returns error code 11 On tree page 5 cell 13: Child page depth differs On tree page 5 cell 14: Child page depth differs Page 44355 is never used Page 44356 is never used Page 44357 is never used Page 44358 is never used Page 44359 is never used Page 44360 is never used ..... ..... ..... Page 44577 is never used Page 44578 is never used Page 44579 is never used Page 44580 is never used Could the corruption have been caused by sqlite engine? Thanks. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
