Re: [Virtuoso-users] Tips to prevent hanging TTLP_MT?

[Hugh W. <hwi...@op...>]

Hi Frans,

How are you calling the TTLP_MT() function to load multiple files and when you says these file are small what is there typical size or number of lines/triples ? For loading of large number of files I would expect you to be using the rdf_loader_run() bulk loader function which calls ttlp() under the covers for loading as detailed at:

	http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtBulkRDFLoader

Using this method you can then use the LDMeter functions to monitor the load rates as detailed at:

	http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtTipsAndTricksGuideLDMeterUtility

Also, at the time the TTLP load appear to hang I presume you can still access the server in which case what does the "status();" command reports as to the status of the server at that point ? How much memory is  on the system and how much does the "top" command report as being used by Virtuoso ?

Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc.      //              http://www.openlinksw.com/
Weblog   -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter  -- http://twitter.com/OpenLink
Google+  -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers

On 18 Apr 2014, at 10:12, Frans Knibbe | Geodan <fra...@ge...> wrote:

> Hello,
> 
> I am using the function TTLP_MT to load ntriple files in Virtuoso 7.1. Even though I take care to have reasonably small files (splitting the files by line numbers if necessary) TTLP_MT still frequently hangs. I have to restart Virtuoso, remove the partial load results and start over. This is quite bothersome, because I have a lot of data to load. I would like to be able to load the files from a script without constantly having to check if Virtuoso hangs and making repairs.
> 
> Are there any tips on getting TTLP_MT to work without hanging? I think the memory configuration is OK, available system memory is used without disk swapping.
> 
> Regards,
> Frans
> 
> 
> Frans Knibbe
> Geodan
> President Kennedylaan 1
> 1079 MB Amsterdam (NL)
> 
> T +31 (0)20 - 5711 347
> E fra...@ge...
> www.geodan.nl | disclaimer
> ------------------------------------------------------------------------------
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and their
> applications. Written by three acclaimed leaders in the field,
> this first edition is now available. Download your free book today!
> http://p.sf.net/sfu/NeoTech_______________________________________________
> Virtuoso-users mailing list
> Vir...@li...
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users