Thanks Andy - I’ll try upgrading! This server is kind of long in the tooth :)
> On 13 Jul 2015, at 21:31, Andy Seaborne <[email protected]> wrote: > > Hi Ric, > > Could you please try Fuseki 1.1.2 or Fuseki 2.0.0? > > How many datasets does the server host? > > 1.0.1 was Jan 2014 and IIRC this area has changed, especially DELETE of a > graph with the Graph Store Protocol. However, if this is just due to > transaction overheads (it's not immediately clear it is or is not), then > DELETE {} WHERE { SELECT {...} LIMIT } is the way to go for an immediate > solution. > > TDB1 (i.e. the Jena code) is a bit memory hungry for transactions. > > TDB2 is not memory bound but it isn't in the Jena codebase. It has been > tested with 100 million triple loads in a single Fuseki2 upload. > > See > http://www.sparql.org/validate/update > for checking syntax. > > Andy > > On 13/07/15 18:59, Ric Roberts wrote: >> Hi. I’m having problems deleting a moderately large graph from a >> jena-fuseki-1.0.1 database. >> >> The graph contains approximately 60 million triples, and the database >> contains about 70 million triples in total. >> >> I’ve started Fuseki with 16G Heap. (JVM_ARGS=${JVM_ARGS:—Xmx16000M}). The >> server has 32G RAM. >> >> When I issue the DELETE command over http, I see this in the fuseki log: >> >> 16:12:03 INFO [24] DELETE >> http://127.0.0.1:3030/stagingdb/data?graph=http://example.com/graph >> <http://127.0.0.1:3030/stagingdb/data?graph=http://example.com/graph> >> 17:10:40 WARN [24] RC = 500 : Java heap space >> 17:10:40 INFO [24] 500 Java heap space (3,517.614 s) >> >> i.e. it takes about an hour, and then 500s with an error about heap space. >> >> I’ve also tried DROP and CLEAR SPARQL update statements but they timeout >> with our default endpoint timeout of 30s. >> >> I’ve also tried deleting 1000 triples at a time, from the graph by issuing a >> sparql update statement like this: >> >> DELETE { >> GRAPH <http://example.com/graph <http://example.com/graph>> >> { ?s ?p ?o } >> } >> WHERE { >> GRAPH <http://example.com/graph <http://example.com/graph>> >> { ?s ?p ?o } >> } >> LIMIT 1000 >> >> … but this times out too (which surprised me, as I only asked it to find and >> DELETE 1000 triples). >> >> What is the recommended way to delete this graph - I need to replace its >> contents fairly urgently on a production system. We loaded it by loading >> 10,000 triples at a time, which worked fine, but I’m having trouble deleting >> its current contents first. >> >> Any pointers appreciated. >> Thanks, Ric. >
