Hi Hugh, I can't find the exact version right now, but it's indeed a quite recent Virtuoso 7 single server (open source version). Is there a way to find the build from the command line? Also, is it possible that slightly different builds use the database files in a different way, thus causing incompatibilities when updating/downgrading?
The other queries seem to run without any troubles anyway. Thanks, Nicola Il 07/02/2014 03:57, Hugh Williams ha scritto: > Hi Nicola, > > Which Virtuoso server type single server or cluster are you using and > also the version, as the error message implies you are running on a > cluster which is not supported in open source ? > > 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 6 Feb 2014, at 22:29, Nicola Vitucci <nicola.vitu...@gmail.com > <mailto:nicola.vitu...@gmail.com>> wrote: > >> Hi all, >> >> I got this message while running a query: >> >> *** Error 42000: [Virtuoso Driver][Virtuoso Server]CL...: The array >> extend 1048576 is less than requested 1310721 >> >> What could be the cause? I pasted here the query and the output of >> EXPLAIN(). >> >> Thanks, >> >> Nicola >> >> _______________________________________________________________________________ >> >> SELECT ?val (COUNT(?id) as ?vc) WHERE {?id >> <http://.../ontologies/hasProp> ?val . ?id >> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> >> <http://.../ontologies/Class> .} GROUP BY ?val ORDER BY DESC(?vc) LIMIT 15 >> >> ______________________________________________________________________________ >> >> { >> s# 107 cluster outer seq start, set no <V $104 set_ctr in> >> save ctx:() >> s# 112 Subquery 27 >> multistate set no = <V $30 set_no i> >> { >> s# 148 Fork 68 >> { >> >> save ctx:() >> set no = <V $30 set_no i> array <none> save: () >> s# 134 Fork 39 >> { >> >> save ctx:() >> set no = <V $30 set_no i> array <none> save: () >> s# 118 from DB.DBA.RDF_QUAD by RDF_QUAD_POGS 1.3e+07 rows Parallel, >> tail cost 4.6e+07 >> Key RDF_QUAD_POGS ASC (<V $33 s_1_4_t0.S rn>, <V $32 s_1_4_t0.O an>) >> inlined P = #ontologies/hasProp >> >> s# 125 from DB.DBA.RDF_QUAD by RDF_QUAD_POGS 0.43 rows Parallel, >> tail cost 3.7 >> Key RDF_QUAD_POGS ASC () >> inlined P = #type , O = #ontologies/hasProp , S = <V $33 >> s_1_4_t0.S rn> >> row specs: O LIKE <c T�> >> >> >> After code: >> 0: <V $37 isnotnull in> := Call isnotnull (<r $33 s_1_4_t0.S via >> S125>) >> 5: BReturn 0 >> s# 130 Sort (HASH) set no <r $30 set_no via S125 S118>(<r $30 set_no >> via S125 S118>, <r $32 s_1_4_t0.O via S125>) -> (<V $37 isnotnull in>) >> up to 5.8e+06 distinct >> >> } >> s# 137 group by read node >> (<V $49 gb_set_no i>, <V $32 s_1_4_t0.O an>, <V $41 aggregate in>) >> set no returned in <V $49 gb_set_no i> >> >> Precode: >> 0: <V $66 __ro2sq a> := Call __ro2sq (<V $32 s_1_4_t0.O an>) >> 5: BReturn 0 >> s# 144 Sort (HASH) set no <r $30 set_no via S137>(TOP 15 ) (<V $41 >> aggregate in>) -> (<V $66 __ro2sq a>) >> >> } >> s# 151 top order by node (<V $66 __ro2sq a>, <V $41 aggregate in>) >> set no <V $30 set_no i> >> >> After code: >> 0: <V $28 val a> := := artm <V $66 __ro2sq a> >> 4: <V $29 vc i> := := artm <V $41 aggregate in> >> 8: BReturn 0 >> s# 112 Subquery Select(<V $28 val a>, <V $29 vc i>) >> set no: <r $30 set_no via S151> >> } >> >> >> After code: >> 0: <V $94 val a> := Call __ro2sq (<V $28 val a>) >> 5: <V $96 vc a> := Call __ro2sq (<V $29 vc i>) >> 10: BReturn 0 >> s# 162 Select (<V $94 val a>, <V $96 vc a>) >> set no: <r $104 set_ctr via S112> >> } >> >> ------------------------------------------------------------------------------ >> Managing the Performance of Cloud-Based Applications >> Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. >> Read the Whitepaper. >> http://pubads.g.doubleclick.net/gampad/clk?id=121051231&iu=/4140/ostg.clktrk >> _______________________________________________ >> Virtuoso-users mailing list >> Virtuoso-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/virtuoso-users > ------------------------------------------------------------------------------ Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121051231&iu=/4140/ostg.clktrk _______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
