Welcome!

Welcome to the official BlackBerry Support Community Forums.

This is your resource to discuss support topics with your peers, and learn from each other.

inside custom component

Java Development

Reply
Highlighted
Regular Contributor
Posts: 83
Registered: ‎12-09-2010
My Device: Not Specified

SQLite corruption : database disk image is malformed

[ Edited ]

Hello,

I've a big problem with two clients' devices.

They have an SQLite corruption error and I can't determine how it's happened.

SQlite documentation says that corruption is a very rare problem and could come from hardware :

http://www.sqlite.org/faq.html#q21

 

I was able to get the two files on my computer and I've tried to open them with sqlite3.exe shel to execute an integrity_check and here is the result :

 

sqlite> PRAGMA integrity_check;
*** in database main ***
On tree page 34 cell 1: Rowid 1 out of order (previous was 1)
On tree page 34 cell 2: Rowid 1 out of order (previous was 1)
On tree page 34 cell 3: Rowid 1 out of order (previous was 1)
On tree page 34 cell 4: Rowid 0 out of order (previous was 1)
On tree page 34 cell 5: Rowid 0 out of order (previous was 0)
On tree page 34 cell 6: Rowid 0 out of order (previous was 0)
On tree page 34 cell 7: Rowid 0 out of order (previous was 0)
On tree page 34 cell 8: Rowid 0 out of order (previous was 0)
On tree page 34 cell 9: Rowid 0 out of order (previous was 0)
On tree page 34 cell 10: Rowid 0 out of order (previous was 0)
On tree page 34 cell 11: Rowid 0 out of order (previous was 0)
Corruption detected in cell 0 on page 34
Corruption detected in cell 1 on page 34
Multiple uses for byte 681 of page 34
Fragmentation of 30 bytes reported as 0 on page 34
Page 37: btreeInitPage() returns error code 11
On tree page 1 cell 7: Child page depth differs
Page 42: btreeInitPage() returns error code 11
Page 48: btreeInitPage() returns error code 11
Page 52: btreeInitPage() returns error code 11
Page 58: btreeInitPage() returns error code 11
Page 63: btreeInitPage() returns error code 11
On tree page 1 cell 13: Child page depth differs
Page 35 is never used
Page 36 is never used

 

I'm unable to extract my databse into a text file cause I've current error  :

 

/****** CORRUPTION ERROR *******/
/****** database disk image is malformed ******/
CREATE TABLE 'dalyo_desc_Table_61' ( 'Name' VARCHAR, 'Label' VARCHAR, 'Type' VARCHAR, 'SystemField' BOOLEAN);
/****** ERROR: callback requested query abort ******/
/****** CORRUPTION ERROR *******/
/****** database disk image is malformed ******/
/****** ERROR: database disk image is malformed ******/
CREATE INDEX Index_Table_37 ON Table_37 (Field_347,Field_442);
/**** ERROR: (11) database disk image is malformed *****/
ROLLBACK; -- due to errors

 

 Someone can help me to repair this error and says me how can I detect what's happened on the Blackberry cause the file is corrupt..

 

I've got this message on two 9360 devices with OS 7.0.0.594

 

Thank for your help

 

Developer
Posts: 265
Registered: ‎01-02-2011
My Device: Z30, PlayBook
My Carrier: AT&T

Re: SQLite corruption : database disk image is malformed

I got the error after I used the DROP command in SQLManager to remove the database tables.

I went to the file directory where I stored the database and deleted the database itself.

This allowed my app to rebuild the database.

_________________
Meetup for BlackBerry 10
Meetup Search Tool - not available at the moment