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

Reply via email to