Re: [Virtuoso-users] Renaming a big graph

2012-02-09 Thread Patrick van Kleef
Hi Martin, will the database binary format be backwards compatible, i.e. can we just copy our 6.1.3-pre database over into 6.1.4's working directory? Please read the README.UPGRADE file from the 6.1.4 source tree. There was a potential problem with some types of XML fragments that could br

Re: [Virtuoso-users] Renaming a big graph

2012-02-09 Thread Martin Gerlach
Hi Hugh, will the database binary format be backwards compatible, i.e. can we just copy our 6.1.3-pre database over into 6.1.4's working directory? Regards, Martin On 08.02.2012 16:28, Hugh Williams wrote: Hi Martin, Looking at your Virtuoso Server version it appears to be an early 6.1.3

Re: [Virtuoso-users] Renaming a big graph

2012-02-08 Thread Hugh Williams
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 H

Re: [Virtuoso-users] Renaming a big graph

2012-02-08 Thread Martin Gerlach
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

Re: [Virtuoso-users] Renaming a big graph

2012-01-24 Thread Hugh Williams
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 s

Re: [Virtuoso-users] Renaming a big graph

2012-01-23 Thread Martin Gerlach
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 1307008614

Re: [Virtuoso-users] Renaming a big graph

2012-01-23 Thread Martin Gerlach
Hi Ivan, I went through the Conductor UI, RDF -> Graphs -> Rename. NumberOfBuffers and MaxDirtyBuffers were set to 2359296 (=18GB, on a machine with 24GB of RAM) VOS Version is 06.01.3127 Cheers, Martin On 23.01.2012 13:01, Ivan Mikhailov wrote: Hello Martin, 11:37:36 ERROR: Memory low!

Re: [Virtuoso-users] Renaming a big graph

2012-01-23 Thread Ivan Mikhailov
Hello Martin, > 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 What was the exact text of the executed query? I'd like to

Re: [Virtuoso-users] Renaming a big graph

2012-01-23 Thread Hugh Williams
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/VirtTips

[Virtuoso-users] Renaming a big graph

2012-01-23 Thread Martin Gerlach
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