<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Can you send this db for testing?<div><br><div><div>On Apr 21, 2012, at 12:52 PM, Francois Van Lerberghe wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">
<title>Re: Crash on AddRecord</title>
<div>
<font face="Verdana"><span style="font-size:12.0px">Mmmh, I've talk too fast.<br>
<br>
With V4RB v4.8.1, no more crash <br>
replacing the LOCATE() function with some IF().<br>
<br>
With V4RB v4.9.1 or v4.9, the crash is always there, <br>
on the very same record. This is the crash log :<br>
<br>
0 libvkernel_fat_release.dylib 0x1917d7ee fbl::vu_strcoll_uu_icu(unsigned short const*, int, unsigned short const*, int, fbl::I_Collator*) + 130<br>
1 libvkernel_fat_release.dylib 0x190b6d54 fbl::ENode_Pred_Equal_Str::long_val(unsigned int) + 228<br>
2 libvkernel_fat_release.dylib 0x190b6104 fbl::ENode_Pred_CmpOp::llong_val(unsigned int) + 24<br>
3 libvkernel_fat_release.dylib 0x190a4d07 fbl::ENode_Func_If::llong_val(unsigned int) + 31<br>
4 libvkernel_fat_release.dylib 0x1916f105 fbl::AssignToValue(fbl::smart_ptr<fbl::I_Value>, fbl::smart_ptr<fbl::I_ENode>, unsigned int) + 191<br>
5 libvkernel_fat_release.dylib 0x19056703 fbl::Method_SQL::Evaluate(unsigned int, fbl::smart_ptr<fbl::I_Value>) + 221<br>
6 libvkernel_fat_release.dylib 0x19117a71 fbl::policyMethodYes::DoMethod(fbl::FldStorage*, unsigned int, fbl::I_Value*) + 95<br>
7 libvkernel_fat_release.dylib 0x194007fc fbl::FldStorageMaster_T<fbl::policyFileNo, fbl::policyNullNo, fbl::policyMethodYes>::ReadValue(unsigned int, fbl::smart_ptr<fbl::I_Value>) + 62<br>
8 libvkernel_fat_release.dylib 0x190f4372 fbl::Field_Imp::ReadValue(unsigned int) + 60<br>
9 libvkernel_fat_release.dylib 0x1913fdb7 fbl::Table::ReEvaluateAllMethods(unsigned int) + 101<br>
10 libvkernel_fat_release.dylib 0x1913fe8c fbl::Table::AddRecord_WithOut_Triggers_ex() + 156<br>
11 libvkernel_fat_release.dylib 0x1913f101 fbl::Table::AddRecord_WithOut_OnEachStatement_Triggers_ex() + 187<br>
12 libvkernel_fat_release.dylib 0x1913f304 fbl::Table::AddRecord() + 478<br>
13 libvkernel_fat_release.dylib 0x19148b0b fbl::Table_Indirect::AddRecord() + 229<br>
14 libvkernel_fat_release.dylib 0x19153542 fbl::vsql::Cursor::AddRecord() + 258<br>
15 ..._macho_ub_4_9_1.rbx_0.dylib 0x18dc068a Cursor_AddRecord(REALobjectStruct*) + 114<br>
<br>
With V4RB v5beta, the crash is always there, on the very same record, <br>
but with another crash log :<br>
<br>
0 ??? 0000000000 0 + 0<br>
1 libvkernel_fat_release.dylib 0x191e01db fbl::ENode_Pred_Equal_Str::long_val(unsigned int) + 243<br>
2 libvkernel_fat_release.dylib 0x191de4a2 fbl::ENode_Pred_CmpOp::llong_val(unsigned int) + 24<br>
3 libvkernel_fat_release.dylib 0x191cb096 fbl::ENode_Func_If::llong_val(unsigned int) + 32<br>
4 libvkernel_fat_release.dylib 0x192a9359 fbl::AssignToValue(fbl::smart_ptr<fbl::I_Value>, fbl::smart_ptr<fbl::I_ENode>, unsigned int) + 278<br>
5 libvkernel_fat_release.dylib 0x19174593 fbl::Method_SQL::Evaluate(unsigned int, fbl::smart_ptr<fbl::I_Value>) + 229<br>
6 libvkernel_fat_release.dylib 0x19248e67 fbl::policyMethodYes::DoMethod(fbl::FldStorage*, unsigned int, fbl::I_Value*) + 93<br>
7 libvkernel_fat_release.dylib 0x195553bc fbl::FldStorageMaster_T<fbl::policyFileNo, fbl::policyNullNo, fbl::policyMethodYes>::ReadValue(unsigned int, fbl::smart_ptr<fbl::I_Value>) + 48<br>
8 libvkernel_fat_release.dylib 0x1921c05b fbl::Field_Imp::ReadValue(unsigned int) + 57<br>
9 libvkernel_fat_release.dylib 0x1927b960 fbl::Table::ReEvaluateAllMethods(unsigned int) + 94<br>
10 libvkernel_fat_release.dylib 0x1927bf28 fbl::Table::AddRecord_WithOut_Triggers_ex() + 102<br>
11 libvkernel_fat_release.dylib 0x1927ba45 fbl::Table::AddRecord_WithOut_OnEachStatement_Triggers_ex() + 171<br>
12 libvkernel_fat_release.dylib 0x19277e80 fbl::Table::AddRecord() + 428<br>
13 libvkernel_fat_release.dylib 0x1927f5e1 fbl::Table_Indirect::AddRecord() + 217<br>
14 libvkernel_fat_release.dylib 0x19289c29 fbl::vsql::Cursor::AddRecord() + 223<br>
15 V4RB_macho_ub_5b.rbx_0.dylib 0x18ed69d2 Cursor_AddRecord(REALobjectStruct*) + 117<br>
<br>
I don’t understand what’s happening since I use IF() function in many other <br>
tables without exhibit any problem ... for the moment :-(.<br>
<br>
François Van Lerberghe<br>
Rue Thier Monty, 15 A<br>
4570 Marchin<br>
Belgique<br>
<br>
le 21/04/12 10:15, Francois Van Lerberghe <<a href="mailto:fvanlerberghe@freegates.be">fvanlerberghe@freegates.be</a>> a écrit :<br>
<br>
<font color="#000098">> The function LOCATE() seems to be the culprit here. Replacing it with a<br>
> bunch of IF() solve my problem : no more crash.<br>
> I hope that workaround will not decrease too much the speed...<br>
> <br>
> Ruslan, is there another workaround more efficient ?<br>
</font></span></font>
</div>
_______________________________________________<br>Valentina mailing list<br><a href="mailto:Valentina@lists.macserve.net">Valentina@lists.macserve.net</a><br>http://lists.macserve.net/mailman/listinfo/valentina<br></blockquote></div><br><div>
<span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div>-- <br>Best regards,<br>Ivan Smahin<br>Senior Software Engineer<br>Paradigma Software, Inc<br>Valentina - The Ultra-Fast Database<br><a href="http://www.valentina-db.com/">http://www.valentina-db.com</a></div></span>
</div>
<br></div></body></html>