Corrupted table...

[GoogleCodeExporter]

1. select count(*) from [LocalUpdates] - returning count, ok
2. select * from [LocalUpdates] returning exception

What in general can be caused by damage to the table ?

Original issue reported on code.google.com by mmx...@gmail.com on 27 Apr 2011 at 9:07

Attachments:

• personal_personal

[GoogleCodeExporter]

C#-sqlite> pragma integrity_check;
*** in database main ***
On tree page 29 cell 0: 2 of 3 pages missing from overflow list starting at 80
Page 78 is never used
Page 79 is never used
C#-sqlite>

Was this database created from C#-SQLite?

Original comment by noah.hart@gmail.com on 16 May 2011 at 7:21

• Changed state: Reviewed

[GoogleCodeExporter]

Yes, of corse. This exception is floating. 
I think what happens when the process nailed during the update data and thus 
corrupted database. if so, why not use the journal ?

Original comment by mmx...@gmail.com on 16 May 2011 at 8:29

[GoogleCodeExporter]

It is supposed to use the journal to recover.  Can you reproduce the error with 
a small program or routine?

Original comment by noah.hart@gmail.com on 16 May 2011 at 8:34

[GoogleCodeExporter]

exception is floating in our programm, I'll try to write the test.

Original comment by mmx...@gmail.com on 16 May 2011 at 8:36

[GoogleCodeExporter]

bug visible only SL version of sqlite

Original comment by mmx...@gmail.com on 16 May 2011 at 8:38

[GoogleCodeExporter]

ahhh; new version for SL getting posted soon; please try again after that

Original comment by noah.hart@gmail.com on 16 May 2011 at 8:43

• Added labels: Silverlight

[GoogleCodeExporter]

ok, i do

Original comment by mmx...@gmail.com on 16 May 2011 at 8:46

[GoogleCodeExporter]

New version has been posted. A simple test case project would be great if the 
issue still occurs.

Original comment by alxw...@gmail.com on 18 May 2011 at 7:49

[GoogleCodeExporter]

Original comment by market.n...@gmail.com on 29 Aug 2011 at 3:15

• Changed state: CannotReproduce