Re: [sqlite] Help sqlite database corruption
As I said before...welcome to DLL hell... You guessed itthe original DLL will give an error if any of the DLLs it depends on are not loadable. Since sqlite.interop.dll is non-standard you should include ALL DLLs that it depends on in your installation. Subject to Microsoft's restrictions: http://msdn.microsoft.com/en-us/library/8kche8ah.aspx How are you making your installation distribution? Michael D. Black Senior Scientist NG Information Systems Advanced Analytics Directorate From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Singh, Manpreet [manpreet.sing...@ca.com] Sent: Tuesday, June 21, 2011 2:55 AM To: sqlite-...@sqlite.org; sqlite-users@sqlite.org Subject: EXT :Re: [sqlite] Help sqlite database corruption Anyone with clues to the problem "malformed disk image"? From: Singh, Manpreet Sent: Tuesday, May 24, 2011 3:10 PM To: sqlite-...@sqlite.org; d...@hwaci.com; sqlite-users@sqlite.org Cc: Singh, Abhijeet; Singh, Satbeer; Prasanth, Neelapalem Subject: RE: Help sqlite database corruption 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 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Help sqlite database corruption
Anyone with clues to the problem "malformed disk image"? From: Singh, Manpreet Sent: Tuesday, May 24, 2011 3:10 PM To: sqlite-...@sqlite.org; d...@hwaci.com; sqlite-users@sqlite.org Cc: Singh, Abhijeet; Singh, Satbeer; Prasanth, Neelapalem Subject: RE: Help sqlite database corruption 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
Re: [sqlite] Help sqlite database corruption
On Tue, May 24, 2011 at 5:39 AM, Singh, Manpreet wrote: > Hello, > > > > Resending with some more finding any help would be appreciated. One of > the tables in the database is getting corrupted. > http://www.sqlite.org/howtocorrupt.html http://www.sqlite.org/lockingv3.html#how_to_corrupt http://www.sqlite.org/atomiccommit.html#sect_9_0 2. Using Sqlite version 3.5.6 > SQLite version 3.7.6.3 is faster and has fewer bugs. Recommend that you upgrade. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Help sqlite database corruption
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