Hi Martin,

Looking at your Virtuoso Server version it appears to be an early  6.1.3 
pre-release version from Sept  2010, with the 6.1.3 official release having 
been made in March 2011, and a 6.1.4 release in Nov 2011. So I would recommend 
and upgrade to the latest 6.1.4 release.

Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc.      //              http://www.openlinksw.com/
10 Burlington Mall Road, Suite 265, Burlington MA 01803
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 8 Feb 2012, at 12:21, Martin Gerlach wrote:

> Hi Hugh,
> 
> > virtuoso-t -?
> Virtuoso Open Source Edition (multi threaded)
> Version 6.1.3-pre1.3127-pthreads as of Sep 23 2010
> Compiled for Linux (x86_64-unknown-linux-gnu)
> 
> Cheers,
> Martin
> 
> On 24.01.2012 02:16, Hugh Williams wrote:
>> 
>> Hi Martin,
>> 
>> Assuming an average triple size of 30 bytes, 150 million triples would 
>> require 4.5GB of memory ie 562500  (4.5GB / 8K) NumberOfBuffers. Although 
>> also how many triples are there in the Virtuoso Quad stores as that would 
>> determine the size required for hosting to the database working set in 
>> memory.
>> 
>> What is the Virtuoso version being used, which can be determined by running 
>> the command:
>> 
>> virtuoso-t -?
>> 
>> Best Regards
>> Hugh Williams
>> Professional Services
>> OpenLink Software, Inc.      //              http://www.openlinksw.com/
>> 10 Burlington Mall Road, Suite 265, Burlington MA 01803
>> 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 23 Jan 2012, at 13:59, Martin Gerlach wrote:
>> 
>>> Hi Hugh,
>>> 
>>> I tried as described on the Web page. For a while, memory usage remained 
>>> constant, but after a while it suddenly rose and broke:
>>> 
>>> 14:55:30 ERROR: Memory low! Using memory reserve to terminate current 
>>> activities properly
>>> 14:55:30 ERROR: Current location of the program break 13070086144
>>> 14:55:30 ERROR: GPF: gate.c:1464 loop in registered cursors
>>> 
>>> Any recommendation on the NumberOfBuffers settings for that operation?
>>> 
>>> Cheers,
>>> Martin
>>> 
>>> On 23.01.2012 12:43, Hugh Williams wrote:
>>>> 
>>>> Hi Martin,
>>>> 
>>>> Please see the following tip on rename graphs in Virtuoso, the key for 
>>>> large graphs being to perform the operation in auto-commit mode 
>>>> (log_enable(3)) to avoid excessively sized transaction log depleting 
>>>> memory:
>>>> 
>>>> http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtTipsAndTricksGuideRenameGraph
>>>> 
>>>> Best Regards
>>>> Hugh Williams
>>>> Professional Services
>>>> OpenLink Software, Inc.      //              http://www.openlinksw.com/
>>>> 10 Burlington Mall Road, Suite 265, Burlington MA 01803
>>>> 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 23 Jan 2012, at 10:49, Martin Gerlach wrote:
>>>> 
>>>>> Hi,
>>>>> 
>>>>> I'd like to rename a graph with about 150 million triples in Virtuoso 
>>>>> Open Source 6.1
>>>>> 
>>>>> The Virtuoso db file has 16GB.
>>>>> 
>>>>> Which is the best way to rename such a big graph? Going through 
>>>>> Conductor/RDF/Graphs/rename or using isql?
>>>>> 
>>>>> Which are the required buffer sizes for renaming the graph?
>>>>> 
>>>>> I tried with 2,3 Mio max buffers and max dirty buffers (18 GB which is 
>>>>> 75% of the machine's RAM), but Virtuoso crashed after this log output:
>>>>> 
>>>>> 11:37:36 ERROR: Memory low! Using memory reserve to terminate current 
>>>>> activities properly
>>>>> 11:37:36 ERROR: Current location of the program break 19991629824
>>>>> 11:37:36 ERROR: GPF: gate.c:1464 loop in registered cursors
>>>>> 
>>>>> Cheers,
>>>>> Martin
>>>>> 
>>>>> 
>>>>> 
>>>>> ------------------------------------------------------------------------------
>>>>> Try before you buy = See our experts in action!
>>>>> The most comprehensive online learning library for Microsoft developers
>>>>> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
>>>>> Metro Style Apps, more. Free future releases when you subscribe now!
>>>>> http://p.sf.net/sfu/learndevnow-dev2
>>>>> _______________________________________________
>>>>> Virtuoso-users mailing list
>>>>> [email protected]
>>>>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>>>> 
>>> 
>>> -- 
>>> Martin Gerlach
>>> Senior Softwareentwickler
>>> Research
>>> 
>>> Neofonie GmbH
>>> Robert-Koch-Platz 4
>>> 10115 Berlin
>>> 
>>> T +49.30 24627 413
>>> F +49.30 24627 120
>>> [email protected]
>>> http://www.neofonie.de
>>> 
>>> Handelsregister
>>> Berlin-Charlottenburg: HRB 67460
>>> 
>>> Geschäftsführung
>>> Thomas Kitlitschko
>>> Dr. Mario Lenz
>>> 
>>> ------------------------------------------------------------------------------
>>> Try before you buy = See our experts in action!
>>> The most comprehensive online learning library for Microsoft developers
>>> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
>>> Metro Style Apps, more. Free future releases when you subscribe now!
>>> http://p.sf.net/sfu/learndevnow-dev2_______________________________________________
>>> Virtuoso-users mailing list
>>> [email protected]
>>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>> 
> 
> -- 
> Martin Gerlach
> Senior Softwareentwickler
> Research
> 
> Neofonie GmbH
> Robert-Koch-Platz 4
> 10115 Berlin
> 
> T +49.30 24627 413
> F +49.30 24627 120
> [email protected]
> http://www.neofonie.de
> 
> Handelsregister
> Berlin-Charlottenburg: HRB 67460
> 
> Geschäftsführung
> Thomas Kitlitschko
> Dr. Mario Lenz
> 
> ------------------------------------------------------------------------------
> Keep Your Developer Skills Current with LearnDevNow!
> The most comprehensive online learning library for Microsoft developers
> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
> Metro Style Apps, more. Free future releases when you subscribe now!
> http://p.sf.net/sfu/learndevnow-d2d_______________________________________________
> Virtuoso-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Attachment: smime.p7s
Description: S/MIME cryptographic signature

Reply via email to