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
[email protected]
https://lists.sourceforge.net/lists/listinfo/virtuoso-users