Question About Segment Errors

[Karl Grob]

Hi Barry

I have a DB that should (among other things) present transcriptions of manuscripts of a Swiss 19th century author. For reasons not to discuss here, I have to split all the texts into their words (ca. 3'500'000 Records). Some of these texts are exact transcriptions of manuscripts and will be shown together with a picture of the original.

There is a older DB (Clipper) I have to import. With this import (about 2 hrs.) I put into my DB placeholders for the pictures. Until yesterday, these placeholders were rather small (60KB) and I replaced them with 500 KB pictures (JPEGs). Up to then I never had problems with the import.
Yesterday I had unspecific crashes during the Import of the first or the second (very large) DBF-Table. No idea what it was. Only once i got this VException in my own log-File: 

Valentina Fehler in 'App; UnhandledExceptios' - Fehler Nummer: 628010 / "FILE: /PARADIGMA/Developer_2/kernel/xcode/../../sources/VKernel/FBL/prot/LowLevel/Volume/VolumeOnFile/prot_SegmentMap/Tree/FBL_SegmentMap_RBTree.cpp FUNCTION: Search LINE: 298" SegmentMap is corrupted - "UNKNOWN"

If I cannot use BLOB-Fields (VTEXT, VPICTURE) this would destroy years of my work, and I did use this Import x-times with no problem. Integrating the pictures is in my DB no important structural or programming problem, it is just a basic need. Or can you give me a way to show pictures from the server (not locally!) without integrating them into the Database?

BTW: going back to the smaller JPEGs allowed me the import (Result: no errors in VStudio)

I am using VRB4 on a IntelMac.

Thanks
Karl Grob



Am 07.05.2010 um 23:29 schrieb Barry G. Sumpter:

> Thanks Steve for your input.
> 
> 
> 
> Hi jda,
> 
> I think having a stable database far outweighs using vText or blob fields.
> 
> If it were my project and I had any thought that the issues may be with
> vText or Blob fields,
> I'd develop a test app and DB without them.
> Test thoroughly myself.
> Then Ask a user in good standing for testing purposes to have a go with it.
> 
> 
> If it still occurred then I'd move to a previously known to be stable DB
> version.
> 
> Also, absolutely, without hesitation, be sure to send Ruslan and his team 
> a copy of your fresh database and a copy of the failed database 
> so they can run their own before and after analysis.
> 
> They sorted out a problem I had on a huge huge DB I had been working on for
> months.
> 
> ----
> 
> I also had another issue with database failing and corrupting beyond
> recovery.
> I started to back up the db at every screen change until I found the issue.
> I now leave the backup in as standard and have a admin property to turn it
> off.
> 
> ----
> 
> Another practive I've developed over years is to 
> 1. Open the database
> 2. Execute whatever on the database
> 3. close the database
> 
> i.e. I never leave the database open
> 
> 
> hth
> 
> Thanks,
>       Barry G. Sumpter
> 
> 
> 
> 
> -----Original Message-----
> From: valentina-bounces at lists.macserve.net
> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of jda
> Sent: Saturday, 8 May 2010 4:45 AM
> To: Valentina Developers
> Subject: Re: Question About Segment Errors
> 
>> Another question.
>> 
>> What CACHE size usually you use Jon? Matt?
>> 
> 
> Minimum is 10 MB. Most people leave it there.
> 
> Jon
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>