Crash when adding records

[Beatrix Willius]

Hi Ruslan,

when you are back from your holiday, here is some fun for you.

Got another similar crash below following my mail from mid June. The crash occurs for extremely simple SQL.

MailCleaners:
theCursor = theDatabase.SqlSelect("select *, RecID from message")

The crashes happen randomly. I haven't been able to reproduce this. Haven't even had a crash myself. As you may remember I changed - on your advice - my strategy when adding data. Before I added data for one record and indexed this record, in the new version I add all records and index at the end. Is it possible that this is responsible for the crashes?

Adding records is a multistep process in my app. After the raw data has been added this data is manipulated and the data in the database is changed, other fields are added. To do this I need some helper SQL queries.


Thread 5 Crashed: 
0   libvshared_fat_release.dylib  	0x188168b2 fbl::String::String(unsigned short const*, int) + 30 
1   V4RB.rbx_0.dylib              	0x1875576a Database_SqlSelect(fbl::smart_ptr<fbl::vsql::I_SqlDatabase>, REALstringStruct*, int, int, int, fbl::smart_ptr<fbl::ArrayOfSmartPtrs<fbl::smart_ptr<fbl::I_Value> > >) + 100 
2   V4RB.rbx_0.dylib              	0x18752852 Database_SqlSelect_1(REALobjectStruct*, REALstringStruct*, int, int, int) + 281 
3   com.mothsoftware.mailarchiverx	0x006a051a VDatabase.SqlSelect%o<VCursor>%o<VDatabase>si4i4i4 + 145 
4   com.mothsoftware.mailarchiverx	0x00da4af3 MailCleaners.Constructor%%o<MailCleaners>o<VDatabase>bbbo<Dictionary> + 857 
5   com.mothsoftware.mailarchiverx	0x00b26b75 ArchiveThread.Clean%%o<ArchiveThread> + 558 
6   com.mothsoftware.mailarchiverx	0x00b241bd ArchiveThread.DoWork%%o<ArchiveThread> + 4682 
7   com.mothsoftware.mailarchiverx	0x00b22f13 ArchiveThread.Event_Run%%o<ArchiveThread> + 56 
8   rbframework.dylib             	0x01338ecb ThreadYieldAsNeeded() + 289 
9   libSystem.B.dylib             	0x964fb259 _pthread_start + 345 
10  libSystem.B.dylib             	0x964fb0de thread_start + 34 

Am 21.06.2012 um 13:16 schrieb Beatrix Willius:

> no binding. Just come simple SQL.
> 
> Haven't been able to reproduce the error here. The customer had the crash 2 times.
> 
> Lovely §$%§ RealStudio is crashing for me so I can't get the emails in so fast. From what I have seen from my customer he had about 100.000 records in the database, wanted to add some more and in the middle of going through the data again the crash happened.

Mit freundlichen Grüßen/Regards

Trixi Willius

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