V5 First impressions

Ivan Smahin ivan_smahin at paradigmasoft.com
Wed Apr 11 09:49:54 CDT 2012 

On Apr 9, 2012, at 3:53 PM, Beatrix Willius wrote:

> - Why is the journal visible? This will confuse the users.

Do you think that hidden file is better? In this case user will ask - what do you hide from me and why.


> - Can't load a database dump: Date value "01/20/2012" is invalid. Illegal symbol at "3" position.
> I'm dumping with 
> 
> theDatabase.Dump(DumpFolderitem, EVDumpType.kXML, EVDataKind.kStructureAndRecords, true, "UTF-16")
> 
> and loading with 
> 
> newDatabase.LoadDump(DumpFolderitem, theFolderitem, EVDumpType.kXML, "UTF-16")
> 
> This looks like the usual confusion with date formats.
> 

You should set appropriate date/time format before load dump.

> - When cancelling a data export

How do you cancel exporting? Do you mean Valentina or own export here? 

> I get a hard crash during data reload.

"Data reload", "exporting" - what do you mean by that?

> This doesn't occur when the export is finished normally. When cancelling I don't do anything special (I hope), the interface just gets a signal to reload the data. Still searching what might cause this. Do you have any idea what the crash log is about? The SQL works, it's the same that I use for navigation/searching.
> 

But crash log below is about some join-query - I think it is not related to data export.
It seems some problems with indexes - I would suggest to diagnose the database and reindex it if needed.

> - I have a help table for searching, where I add some data. When doing a search this works on the second try and not on the first.  Here I'm also investigating.
> 
> Setup: Realbasic 2011r4, Mac OS 10.7.2, V5b20, Cocoa!
> 
> Crash log:
> 
> Thread 0 Crashed:: Dispatch queue: com.apple.main-thread
> 0   libvkernel_fat_release.dylib  	0x0b1cf67d fbl::VObjectPtr::get_IndexIterator(fbl::smart_ptr<fbl::I_Table>, unsigned short) const + 521
> 1   libvkernel_fat_release.dylib  	0x0b1cf74f non-virtual thunk to fbl::VObjectPtr::get_IndexIterator(fbl::smart_ptr<fbl::I_Table>, unsigned short) const + 44
> 2   libvkernel_fat_release.dylib  	0x0b51c9e4 fbl::Join_Builder_2::ChooseInnerJoinAlg() + 262
> 3   libvkernel_fat_release.dylib  	0x0b51c844 fbl::Join_Builder_2::DoInnerJoin(fbl::smart_ptr<fbl::Node_Explain>) + 66
> 4   libvkernel_fat_release.dylib  	0x0b198247 fbl::Join_Builder_2::Build(fbl::smart_ptr<fbl::Node_Explain>) + 77
> 5   libvkernel_fat_release.dylib  	0x0b3a30c0 fbl::Join_Builder::Build_2(fbl::smart_ptr<fbl::JoinPair>, fbl::smart_ptr<fbl::Node_Explain>) + 132
> 6   libvkernel_fat_release.dylib  	0x0b3a2db3 fbl::Join_Builder::Build(fbl::smart_ptr<fbl::Node_Explain>) + 141
> 7   libvkernel_fat_release.dylib  	0x0b268b77 fbl::Join(fbl::smart_ptr<fbl::ArrayOfSmartPtrs<fbl::smart_ptr<fbl::JoinPair> > >, bool, fbl::smart_ptr<fbl::ArrayOfSmartPtrs<fbl::smart_ptr<fbl::I_Field> > >, fbl::smart_ptr<fbl::ArrayOfSmartPtrs<fbl::smart_ptr<fbl::TableOrAlias> > >, fbl::smart_ptr<fbl::Node_Explain>) + 282
> 8   libvkernel_fat_release.dylib  	0x0b38f0b4 fbl::vsql::Node_Table_Join::ExecuteSql(fbl::vsql::SqlEnvironment&, fbl::smart_ptr<fbl::Node_Explain>) + 3268
> 9   libvkernel_fat_release.dylib  	0x0b31ce40 fbl::vsql::Node_TableExpr::Execute_Select_FromN_Where(fbl::vsql::SqlEnvironment&, fbl::smart_ptr<fbl::Node_Explain>) + 440
> 10  libvkernel_fat_release.dylib  	0x0b31efe7 fbl::vsql::Node_TableExpr::Execute_Select_From_Where_Indirect(fbl::vsql::SqlEnvironment&, fbl::smart_ptr<fbl::Node_Explain>) + 67
> 11  libvkernel_fat_release.dylib  	0x0b316f58 fbl::vsql::Node_TableExpr::Execute_Select_From_Where(fbl::vsql::SqlEnvironment&, fbl::smart_ptr<fbl::Node_Explain>) + 712
> 12  libvkernel_fat_release.dylib  	0x0b3162d8 fbl::vsql::Node_TableExpr::ExecuteSql(fbl::vsql::SqlEnvironment&, fbl::smart_ptr<fbl::Node_Explain>) + 108
> 13  libvkernel_fat_release.dylib  	0x0b305b21 fbl::vsql::Node_QuerySelect::ExecuteSql(fbl::vsql::SqlEnvironment&, fbl::smart_ptr<fbl::Node_Explain>) + 277
> 14  libvkernel_fat_release.dylib  	0x0b392841 fbl::vsql::Node_Table_NonJoin::ExecuteSql_Query(fbl::vsql::SqlEnvironment&, fbl::smart_ptr<fbl::Node_Explain>) + 87
> 15  libvkernel_fat_release.dylib  	0x0b392747 fbl::vsql::Node_Table_NonJoin::ExecuteSql(fbl::vsql::SqlEnvironment&, fbl::smart_ptr<fbl::Node_Explain>) + 81
> 16  libvkernel_fat_release.dylib  	0x0b306763 fbl::vsql::Node_QueryTRef::ExecuteSql(fbl::vsql::SqlEnvironment&, fbl::smart_ptr<fbl::Node_Explain>) + 59
> 17  libvkernel_fat_release.dylib  	0x0b2ff137 fbl::vsql::Node_RelationalAlgebra::ExecuteSql(fbl::vsql::SqlEnvironment&, fbl::smart_ptr<fbl::Node_Explain>) + 175
> 18  libvkernel_fat_release.dylib  	0x0b30d6bd fbl::vsql::Node_Select::ExecuteSql(fbl::vsql::SqlEnvironment&, fbl::smart_ptr<fbl::Node_Explain>) + 179
> 19  libvkernel_fat_release.dylib  	0x0b30e4e5 non-virtual thunk to fbl::vsql::Node_Select::ExecuteSql(fbl::vsql::SqlEnvironment&, fbl::smart_ptr<fbl::Node_Explain>) + 34
> 20  libvkernel_fat_release.dylib  	0x0b4de4c9 fbl::vsql::ProceedCommand(fbl::vsql::SqlEnvironment&) + 230
> 21  libvkernel_fat_release.dylib  	0x0b4fe460 fbl::vsql::SqlParser::SqlQuery_(fbl::smart_ptr<fbl::vsql::QueryResult>, fbl::vsql::I_SqlDatabaseEx*, fbl::String const&, fbl::vsql::ECursorLocation, fbl::vsql::ELockType, fbl::vsql::ECursorDirection, fbl::smart_ptr<fbl::ArrayOfSmartPtrs<fbl::smart_ptr<fbl::I_Value> > >) + 428
> 22  libvkernel_fat_release.dylib  	0x0b4fe8a6 fbl::vsql::SqlParser::SqlQuery(fbl::vsql::I_SqlDatabaseEx*, fbl::String const&, fbl::vsql::ECursorLocation, fbl::vsql::ELockType, fbl::vsql::ECursorDirection, fbl::smart_ptr<fbl::ArrayOfSmartPtrs<fbl::smart_ptr<fbl::I_Value> > >) + 148
> 23  libvkernel_fat_release.dylib  	0x0b24f11f fbl::vsql::SqlDatabase::SqlQuery(fbl::String const&, fbl::vsql::ECursorLocation, fbl::vsql::ELockType, fbl::vsql::ECursorDirection, fbl::smart_ptr<fbl::ArrayOfSmartPtrs<fbl::smart_ptr<fbl::I_Value> > >) + 119
> 24  libvkernel_fat_release.dylib  	0x0b24f19b non-virtual thunk to fbl::vsql::SqlDatabase::SqlQuery(fbl::String const&, fbl::vsql::ECursorLocation, fbl::vsql::ELockType, fbl::vsql::ECursorDirection, fbl::smart_ptr<fbl::ArrayOfSmartPtrs<fbl::smart_ptr<fbl::I_Value> > >) + 64
> 25  V4RB.rbx_0.dylib              	0x067007a1 Database_SqlSelect(fbl::smart_ptr<fbl::vsql::I_SqlDatabase>, REALstringStruct*, int, int, int, fbl::smart_ptr<fbl::ArrayOfSmartPtrs<fbl::smart_ptr<fbl::I_Value> > >) + 183
> 26  V4RB.rbx_0.dylib              	0x066fda63 Database_SqlSelect_2(REALobjectStruct*, REALstringStruct*, int, int, int, REALstringArrayStruct*) + 372
> 27  com.mothsoftware.mailarchiverx	0x0073835a VDatabase.SqlSelect%o<VCursor>%o<VDatabase>si4i4i4A1s + 169
> 28  com.mothsoftware.mailarchiverx	0x00c9db7c VCursorController.Query%%o<VCursorController>ss + 631

-- 
Best regards,
Ivan Smahin
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com

More information about the Valentina mailing list