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

Re: [Virtuoso-users] Multiple datasets returned even after restrictions

2012-01-23 Thread Ivan Mikhailov
Hello Peter, FROM is to form default graph only, it does not affect named graphs at all. In order to restrict both bindings in default graph and bindings in graph ?dataset {...}, use FROM FROM NAMED FROM FROM NAMED etc. Of course, you don't have to keep lists of default and named graphs iden

[Virtuoso-users] Multiple datasets returned even after restrictions

2012-01-23 Thread Peter Secomb
Hi everyone, We have a query as follows: SELECT ?new_id ?attribute ?value ?id ?dataset FROM FROM FROM FROM FROM WHERE { ?s prefixA:ID ?old_id . ?old_id ?attribute ? value graph ?dataset { ?old_id prefixB:new_attribute ?new_id} } Data is held in graph A duplicate graph exists that is not s