Hello,
Resending with some more finding any help would be appreciated. One of the tables in the database is getting corrupted. 1. Sqlite>select count(*) from $table_name ...... 7981508|35001|284 7981509|35002|284 7981510|35003|284 7981511|35004|284 SQL error: database disk image is malformed sqlite> 2. When integrity check is performed following is the error: *** in database main *** Page 703104: sqlite3BtreeInitPage() returns error code 11 On tree page 680368 cell 75: Child page depth differs Page 703365: sqlite3BtreeInitPage() returns error code 11 Page 703624: sqlite3BtreeInitPage() returns error code 11 Page 703884: sqlite3BtreeInitPage() returns error code 11 Note: 1. $table_name has 2 unique indexes and 3 columns 2. Using Sqlite version 3.5.6 3. We are able to .dump to sql file and get the db back Thanks and Regards, Manpreet Singh CA Subject Matter Expert SQL Certified (Oracle 9i) MCP (SQL 2000 Administration) MS Certified Technology Specialist - SQL Server 2005 From: Singh, Manpreet Sent: Wednesday, May 18, 2011 12:04 PM To: 'sqlite-...@sqlite.org' Subject: Help sqlite database corruption Hello, Looking for help, sqlite database getting corrupted multiple times we need to use .dump to recover and then back to database. As per our observations index gets corrupted for one of the tables (table goes more than 7900k records) and when queried it give "malformed disk image" for that database. Thanks and Regards, Manpreet Singh _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
