Hi Ivan,
thanks a lot for the explanation. The workaround looks crazy. :)
Sadly it does not work here. But then again the following query does not
work either which is very confusing:
select ?mg where {
?mg nrl:coreGraphMetadataFor ?g .
FILTER(?g in ()) .
FILTER(!bif:exists((select (1) w
Hello Sebastian,
Unfortunately there's no way to calculate the graph to delete by
something more complicated than constant expression. If that creates
severe problems then I will extend the processor to support something
like
clear graph (
select ?mg where {
?mg nrl:coreGraphMetadataF
Hi list,
With this query:
clear graph ?mg where {
?mg nrl:coreGraphMetadataFor ?g .
FILTER(?g in ()) .
FILTER(
!bif:exists((select (1) where { graph ?g { ?s ?p ?o . } . }))
) .
}
I get the following error:
"SP031: SPARQL compiler: non-global variable 'mg' can not be
Hi Alexander,
Glad to hear log_enable worked for you and I have created the following tip for
all’s benefit on how to delete large graphs:
http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtTipsAndTricksGuideDeleteLargeGraphs?
With regards to the vacuum function did you run a c
log_enable 3 worked like a charm. Graph contains zero triples now. After
that I tried to run vacuum() to make the size of my database less, but after
it had finished its work, the size became even more (was 4.8gb, now 6.8gb).
2011/6/11 Ivan Mikhailov
> Hi Alexander
>
> > log_enable(3,1);
>
Hi Alexander
> log_enable(3,1);
> delete from rdf_quad where g = iri_to_id (‘graph-name’);
Note that this will not even try to remove free-text index data for this
graph.
Best Regards,
Ivan Mikhailov
OpenLink Software
http://virtuoso.openlinksw.com
Hi Alexander
You can turn transactions off and then back on using the log_enable() function
directly as:
log_enable(3,1);
SPARQL CLEAR GRAPH ;
or as a pragma in the specified query as:
SPARQL DEFINE sql:log-enable 3 CLEAR GRAPH ;
or you can even deleted the triples
Hello Alexander,
All DEFINE pragmas are placed right into the SPARQL statement.
They're not in a separate statement, they're part of SPARQL statement.
If it's via web-interface then they're at the very beginning of the
statement,
if it's via ISQL or SPARQL is a part of an bigger SQL query or
Virt
Hi Hugh,
I forgot about that discussion and it really looks like the same problem.
Unfortunately I have no idea how to execute "define sql:log-enable NNN"
before the query - it doesn't run.
Virtuoso 06.01.3127
About 30kk of triples.
I am pretty sure my query calculates triples count inside a gr
Hi Alexander,
Its been a while, but one of the last conversation we had about a year was with
regards to clear graph issues you were having in which Ivan had suggested:
>>>
Try "define sql:log-enable NNN" at the beginning of CLEAR GRAPH
statement. That will invoke log_enable (NNN, 1) before the
Hello!
I need to clear some graph from Virtuoso database. I execute "sparql clear
graph { ?s ?p ?o}" doesn't become less. What am I doind wrong?
Regard,
Alexander
Hi Kingsley,
This table raised the question. There is no price for High-memory instances
(but I can choose them during instance launching). Also it is very
disappointing there is no "over 96 hours" discount for Large instances (I
believe it is the most popular choice).
Regards,
Alexander
2010/5/
Alexander Sidorov wrote:
Hugh and Ivan, thank you for advices. I tried some of the ways you
have suggested but they didn't work. It was easier to me to launch new
Virtuoso EC2 instance and make dataset loading from scratch. The
problem didn't appear again so looks like I have done something wro
Hugh and Ivan, thank you for advices. I tried some of the ways you have
suggested but they didn't work. It was easier to me to launch new Virtuoso
EC2 instance and make dataset loading from scratch. The problem didn't
appear again so looks like I have done something wrong previous time.
2010/5/16
Hello Alexander,
Try "define sql:log-enable NNN" at the beginning of CLEAR GRAPH
statement. That will invoke log_enable (NNN, 1) before the operation
(and restore the log mode back to original value after the operation).
The log_enable() BIF is described in
http://docs.openlinksw.com/virtuoso/fn_l
Hi Alexander,
When the Virtuoso hang occurred, how did you stop server was this a graceful
shutdown or did you have to forcibly shut it down ? For the query(s) failing
can provide the output of running the "explain" function which compiles a query
and returns a description of that compilation
Hello!
Virtuoso hanged during large graph clearing. I stopped Virtuoso, removed
virtuoso.lck and started again. I am not sure whether graph was cleared or
not but now all queries from this graph result in "S1T00 Error SR171:
Transaction timed out". I need to reload dataset to this graph. Is there
17 matches
Mail list logo
