Hi.
I am trying to execute a SPARQL INSERT-WHERE taking a lot time to complete.
INSERT {
GRAPH <a
<http://bio2rdf.org/clinicaltrials_resource:bio2rdf.dataset.clinicaltrials.R4>>
{
?s <hasLabelAfterManualConversion> ?newLabel
}
}
WHERE {
GRAPH <a
<http://bio2rdf.org/clinicaltrials_resource:bio2rdf.dataset.clinicaltrials.R4>>
{
?s ?p ?o .
FILTER (REGEX(STR(?o),"abc","i")) .
BIND(REPLACE(?o, "abc", "", "i") AS ?newLabel)
}
};
Trying to execute it through the web environment, I get a timeout. I
thought that the most appropriate way to do it would be through the isql-v
command line environment. When I try to do it, after some hours I get
**** Error 08S01: [Virtuoso Driver]CL065: Lost connection to server*
This is rather peculiar as the isql-v runs on the same VM as the virtuoso.
It should also be noted that the virtuoso instance responds and has not
collapsed.
I have three questions:
1. Is this "lost connection" behavior in the isql-v environment normal?
2. Does this "lost connection" message mean that the transaction has
rolled-back or is the command still running?
3. Is there a better way to run long-time queries against virtuoso?
Kind regards,
Pantelis Natsiavas
------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are
consuming the most bandwidth. Provides multi-vendor support for NetFlow,
J-Flow, sFlow and other flows. Make informed decisions using capacity
planning reports. http://sdm.link/zohodev2dev
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
