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
