Hi Hugh, I have about 250 million triples over ten graphs. I found a work around already, but I will keep this information handy. Thank you much! - Erich
========================================================== Erich Bremer http://www.ebremer.com > On Sep 25, 2013, at 10:57 PM, "Hugh Williams" <hwilli...@openlinksw.com> > wrote: > > Hi Erich, > > The query runs for me against local v7 open source build, but then I don't > have your data in my installation: > > SQL> SPARQL prefix sno: <http://www.ebremer.com/sno/> with > <http://www.maxmind.com> delete {?range sno:hasStartip4Address ?ip} insert > {?range sno:hasStartip4AddressDotted ?ip} where {?range > sno:hasStartip4Address ?ip filter(!isnumeric(?ip))}; > > Done. -- 1 msec. > SQL> > > In Virtuoso 7 there is a MaxVectorSize param in the virtuoso.ini file which > defaults to 1000000, you can try setting it to something higher than 2000000 > , restart Virtuoso and see if it resolves the problem ... > > 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 25 Sep 2013, at 16:46, Erich Bremer <er...@ebremer.com> wrote: >> >> Using Virtuoso 7.0.0, I tried to do a with-delete-insert query and the >> following error was generated: >> >> Virtuoso 42000 Error FRVEC: array in for vectored over max vector length >> 2000000 > 1000000 >> >> SPARQL query: >> define sql:big-data-const 0 >> #output-format:text/html >> define sql:signal-void-variables 1 prefix sno: >> <http://www.ebremer.com/sno/> >> with <http://www.maxmind.com> >> delete {?range sno:hasStartip4Address ?ip} >> insert {?range sno:hasStartip4AddressDotted ?ip} >> where {?range sno:hasStartip4Address ?ip filter(!isnumeric(?ip))} >> >> - Erich >> >> Erich Bremer >> http://www.ebremer.com >> >> >> ------------------------------------------------------------------------------ >> October Webinars: Code for Performance >> Free Intel webinars can help you accelerate application performance. >> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most >> from >> the latest Intel processors and coprocessors. See abstracts and register > >> http://pubads.g.doubleclick.net/gampad/clk?id=60133471&iu=/4140/ostg.clktrk >> _______________________________________________ >> Virtuoso-users mailing list >> Virtuoso-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/virtuoso-users > ------------------------------------------------------------------------------ October Webinars: Code for Performance Free Intel webinars can help you accelerate application performance. Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from the latest Intel processors and coprocessors. See abstracts and register > http://pubads.g.doubleclick.net/gampad/clk?id=60133471&iu=/4140/ostg.clktrk _______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
