Re: [Virtuoso-users] infrequent errors on parallel querying

[Nolle, A. <no...@hs...>]

Sorry for sending the mail again, but my previous message to Virtuoso-users awaits moderator approval…
So I cut out some parts:


Hi Hugh,

if I open the provided files with an editor, there is no error.

For example, profile_q2_federated contain:

Connected to OpenLink Virtuoso
Driver: 07.20.3215 OpenLink Virtuoso ODBC Driver
result
LONG VARCHAR
_______________________________________________________________________________

http://www.bibsonomy.org/bibtex/20001ccbac4a192c385dd1a813c33e4a4         130--147
http://www.bibsonomy.org/bibtex/2001726ad493878da37ce74c327b64142        451--464
http://www.bibsonomy.org/bibtex/2002a5c36b038d703388ea3133d1c1d64        125--144
http://www.bibsonomy.org/bibtex/2002b342f8686b42ca9386b7101e57d03         1966--1972
http://www.bibsonomy.org/bibtex/2002f844c77738f07d6aed27377358948          36--50
http://www.bibsonomy.org/bibtex/200583305f841e25137f18dc67f63e83a          571-573
http://www.bibsonomy.org/bibtex/200825babcdaa38b3fa7afef00705b74e          1553-1558
http://www.bibsonomy.org/bibtex/2008eea7c2709538ca3824513b797dd5f         319--355
http://www.bibsonomy.org/bibtex/20091a9f693bb98983ac76724ecfaa344          195--205
http://www.bibsonomy.org/bibtex/200b84d4fae9f972bd06d1648119d1ac8          203--223
http://www.bibsonomy.org/bibtex/200d0f3fa9f6a4ab1fc84973c9f6d03f7             10--12
http://www.bibsonomy.org/bibtex/200d246b67269ee8de5bdb900b766f229         92-97
http://www.bibsonomy.org/bibtex/200ecc41577170f3a59cd67882c309d0a          77-86
http://www.bibsonomy.org/bibtex/200ecc846b53f52079c34af53e8badcfa           4--10
http://www.bibsonomy.org/bibtex/200ef9f672b4e826261dcd9219d5d0507          82-83
http://www.bibsonomy.org/bibtex/200f4976a86726f22802bd39e93386926         238--246
http://www.bibsonomy.org/bibtex/2010ebc7f46486e290469eb950a20d04d         319--325
http://www.bibsonomy.org/bibtex/2011380714119b1a98da3addca3fe0e50         18
http://www.bibsonomy.org/bibtex/2012c49708658e54a9e61214be4bdc4b0        27--36
http://www.bibsonomy.org/bibtex/2012c49708658e54a9e61214be4bdc4b0        27–36

{
time   1.8e-07% fanout         1 input         1 rows

Precode:
      0: vector := Call vector ()
      5: vector := Call vector (<c b>, <c x>)
      10: BReturn 0
Subquery 31
{
time   1.5e-07% fanout         1 input         1 rows

Precode:
      0: __stub :=  := artm  1
      4: BReturn 0
END Node
time   6.5e-08% fanout         0 input         1 rows
Subquery Select(__stub)
}
time     1e+02% fanout      1000 input         1 rows

Precode:
      0: ws_endpoint :=  := artm <tag 182 flag 1 c http://141.87.4.8:8891/sparql>
      4: ws_params :=  := artm vector
      8: qtext_template :=  := artm <c  SELECT ?b ?x
WHERE {  ?x <http://swrc.ontoware.org/ontology#pages> ?b . }>
      12: qtext_posmap :=  := artm <tag 225 c >
      16: param_row :=  := artm vector
      20: expected_vars :=  := artm vector
      24: proc_ctr :=  := artm  0
      28:  <none>  := Call __reset_temp ( 140051501624464 )
      33:  <proc table>  := Call DB.DBA.SPARQL_SINV_IMP (<tag 182 flag 1 c http://141.87.4.8:8891/sparql>, vector, <c  SELECT ?b ?x
WHERE {  ?x <http://swrc.ontoware.org/ontology#pages> ?b . }>, <tag 225 c >, vector, vector)
      40: BReturn 0
Key from temp (proc_ctr, RSET)


After code:
      0: aref := Call aref (RSET,  1 )
      5: x := Call __id2in (aref)
      10: aref := Call aref (RSET,  0 )
      15: b := Call __ro2sq (aref)
      20: BReturn 0
time   2.7e-08% fanout         0 input      1000 rows
Select (x, b)
}


4987453 msec 99% cpu, 1.40551e+06 rnd    200089 seq         0% same seg 0.0686584% same pg
144592 disk reads, 143623 read ahead,  0.445211% wait
Compilation: 2 msec 0 reads         0% read 0 messages         0% clw

5 Rows. -- 4987467 msec.


Best
Andy