Index troubles

[Beatrix Willius]

Hi,

I've got a diverse set of problem with the index files in Valentina. But every customer has different problems:

1. Index corrupt for customer. Really really tiny files. Created with an older version of my app. May be result of converting to newer Valentina format. I’ve had at least 10 customers where this “hung” the app.

2. Issue from http://www.valentina-db.com/bt/view.php?id=6576. Crash log relevant section:

Thread 0 Crashed:: Dispatch queue: com.apple.main-thread
0 libvkernel_fat_release.dylib 0x0ae8051b fbl::Index_String_Page::get_ValueArraySize() const + 53
1 libvkernel_fat_release.dylib 0x0ae80a0f fbl::Index_String_Page::SetPointersTo(char*, bool) + 87

This issue went away after I removed "if theMessageTable <> nil then theMessageTable.IndexChanges” for false and true from the code.

3. I occasionally get the following crash:

Thread 3 Crashed:
0   libvkernel_fat_release.dylib  	0x0d9eaaee fbl::Index_NotUnique_Page::DeleteFromCurrentPage(fbl::TIndexContext&) + 20
1   libvkernel_fat_release.dylib  	0x0d9f3dd9 fbl::Index_Page_imp::DeletePair(fbl::TIndexContext&) + 25
2   libvkernel_fat_release.dylib  	0x0d9df08a fbl::Index_Imp::DeletePair_on_locked(fbl::smart_ptr<fbl::I_Value const>, unsigned int) + 180
3   libvkernel_fat_release.dylib  	0x0d9f77b6 fbl::Index_String::DeletePair_on_locked_words(fbl::smart_ptr<fbl::I_Value const>, unsigned int) + 468
4   libvkernel_fat_release.dylib  	0x0d9ed21e fbl::Index_String::DeletePair(fbl::smart_ptr<fbl::I_Value const>, unsigned int) + 108
5   libvkernel_fat_release.dylib  	0x0d65d4f0 fbl::VText::DeleteFromIndex(unsigned int, bool) + 430
6   libvkernel_fat_release.dylib  	0x0d68f2dd fbl::DeleteRecordFromIndex_OneField(fbl::smart_ptr<fbl::I_FieldEx>, unsigned int, bool, bool) + 91
7   libvkernel_fat_release.dylib  	0x0d68f17a fbl::Table::DeleteRecordFromFieldIndexes(unsigned int, fbl::smart_ptr<fbl::BitSet>, bool) + 136
8   libvkernel_fat_release.dylib  	0x0d68ec88 fbl::Table::DeleteRecordFromIndex(unsigned int, fbl::smart_ptr<fbl::BitSet>, bool) + 158
9   libvkernel_fat_release.dylib  	0x0d6995d6 fbl::Table::UpdateRecord_WithOut_OnEachStatement_Triggers_ex(unsigned int) + 324
10  libvkernel_fat_release.dylib  	0x0d69593f fbl::Table::UpdateRecord(unsigned int) + 117
11  libvkernel_fat_release.dylib  	0x0d69df54 fbl::Table_Indirect::UpdateRecord(unsigned int) + 202
12  libvkernel_fat_release.dylib  	0x0d6a82ec fbl::vsql::Cursor::UpdateRecord(unsigned int) + 74
13  V4RB.rbx_0.dylib              	0x0d286b74 Cursor_UpdateRecord(REALobjectStruct*) + 123
14  com.mothsoftware.mailarchiverx	0x007414b8 VCursor.UpdateRecord%%o<VCursor> + 48
15  com.mothsoftware.mailarchiverx	0x00e30e26 AttachmentsAndMimeCleaner.execute%%o<AttachmentsAndMimeCleaner> + 22844

4. Now I’ve got a customer who also has corrupt index. When trying to rebuild his index in Valentina Studio it crashed! This was from a > 25 GB database. I’m just trying to reproduce this but it will take a while to create such a large file. In a second diagnose his database had the nice problem from the email I sent earlier.

All this is rather frustrating. My app can make rather large files and fixing issues on these large files is extremely annoying and difficult.

Any ideas how to tackle these problems?



Mit freundlichen Grüßen/Regards

Trixi Willius

http://www.mothsoftware.com
Mail Archiver X: The email archiving solution for professionals

Mit freundlichen Grüßen/Regards

Trixi Willius

http://www.mothsoftware.com
Mail Archiver X: The email archiving solution for professionals