Re: [sqlite] Help sqlite database corruption

[Black, Michael (IS)]

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

[Singh, Manpreet]

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

[Richard Hipp]

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

[Singh, Manpreet]

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