Re: [Virtuoso-users] Long query - "Lost connection to server"

2016-08-09 Thread Hugh Williams
Hi Pantelis, What is the memory consumption of Virtuoso whilst running the insert query and what is the size of the graph the insert is being performed against ? As note for SPARUL operation against graph with large amounts of data it is recommended queries are performed in row-wise auto commit

Re: [Virtuoso-users] Long query - "Lost connection to server"

2016-08-09 Thread Pantelis Natsiavas
I have just retried the above long-time query and checked the virtuoso.log. I see that after 45 minutes I get the following log entries (I executed the query around 10.00): 10:24:23 * Monitor: High disk read (2) 10:41:23 * Monitor: High disk read (2) 10:43:24 * Monitor: High disk read (2) 10:43:41

[Virtuoso-users] Long query - "Lost connection to server"

2016-08-09 Thread Pantelis Natsiavas
Hi. I am trying to execute a SPARQL INSERT-WHERE taking a lot time to complete. INSERT { GRAPH http://bio2rdf.org/clinicaltrials_resource:bio2rdf.dataset.clinicaltrials.R4>> { ?s ?newLabel } } WHERE { GRAPH http://bio2rdf.org/clinicaltrials_resource:bio2rdf.dataset.clinicaltrials.R4>> { ?s ?p ?o