[sqlite] Sqlite database corrupted

2011-04-09 Thread giorgi giorgi 
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 9: 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

[sqlite] Sqlite profiler

2009-09-20 Thread giorgi giorgi 
Hello,

Is there anyone interested in sqlite profiler? If yes what features would
you like to see?

Thank you.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users