Hi Pantelis, Looks like you are exceeding the Virtuoso MaxVectorSize INI file param with a default value of 1000000, thus due to the graph size probably should split the query as in previous delete case to limit the vector size.
Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software/ Twitter -- http://twitter.com/OpenLink Google+ -- http://plus.google.com/100570109519069333827/ Facebook -- http://www.facebook.com/OpenLinkSoftware Universal Data Access, Integration, and Management Technology Providers > On 23 Aug 2016, at 10:18, Pantelis Natsiavas <natsia...@gmail.com> wrote: > > Hi everybody. > > I am executing a SPARUL query in a large graph (over 150M triples): > > SPARQL DEFINE sql:log-enable 3 > WITH <graph> > DELETE { ?s ?p ?o} > INSERT {?s ?p ?newLabel} > WHERE {?s ?p ?o . > FILTER (isLiteral(?o) && REGEX(STR(?o),"some_string:","i")) . > BIND(REPLACE(STR(?o), "some_string:", "", "i") as ?newLabel) } > > After an hour or two, I get the following error: > > *** Error 42000: [Virtuoso Driver][Virtuoso Server]CL...: The array extend > 1048576 is less than requested 1310721 > > Googling the above error, I found a suggestion of splitting the above query > using a limit. However, it seemed that the limit was so small that this is > not an option. Please note that I run on a 32GB, 8x VM. > > My questions: > 1. Is there some kind of setting in virtuoso.ini that could change this > behaviour? > 2. As you can see from the above query, all I am trying to do is a replace > operation on literals. Is there an alternative more efficient way to do it? > e.g. using direct SQL or refactoring the SPARUL query somehow? Perhaps I > missed something... > > Kind regards, > Pantelis Natsiavas > > > > > ------------------------------------------------------------------------------ > _______________________________________________ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
