Dear Kingsley,
Thanks for your answer. The problem is that the URLs you have sent me
have a quite different syntax than the ones I try.
And in fact I do not have the control over the syntax queries are
constructed,
since the URLs I have sent you are just the tip of the iceberg.
I am actually using the SPARQL client library of SWI-Prolog to query the
DBpedia endpoint.
This library converts my SPARQL query to an http request (in the exact
format I have reported)
which is send over to the endpoint. Of course, the http request can be
directly used by any client
just to confirm or not the problem that appears. This problem appears to
be a problem of how Virtuoso
handles (parses?) the http request. Actually, my initial hypothesis that
the length of the query string might
be relevant is wrong, since I can reduce the length of the string a lot
by removing unnecessary spaces.
The result is still the 500 error message.
So, I was wondering if there are any ideas on where to report this bug
of Virtuoso.
Best,
Nick
On 24/8/2016 7:11 μμ, Kingsley Idehen wrote:
On 8/24/16 11:27 AM, Nick Bassiliades wrote:
Dear all,
To start off, I'm really not sure if this is the correct forum to pose
my question, so I initially apologize
and I kindly ask to re-direct me to the proper forum, if anyone of you
knows.
I have a problem with a SPARQL query I send over a remote client to the
public SPARQL endpoint of DBpedia.
The query is the following:
select ?s1, ?s2 where { {
select ?s1, ?s2 where {
?s1 ?x ?o1 .
?o1 bif:contains ' ( "Pierre" AND "Marie" AND "Curie" AND "University"
AND "UPMC" ) ' option ( score ?sc ) .
?s1 rdfs:label ?s2 .
?s1 rdf:type dbo:EducationalInstitution . }
order by desc ( ?sc * 3e-1 + sql:rnk_scale ( <LONG::IRI_RANK> ( ?s1 ) ) )
limit 100 } .
FILTER (lang(?s2) = "en") }
limit 2
If I type it in the query box ofhttp:dbpedia.org/sparql, everything is
fine.
However, when I construct the query and send it over a remote client
like this:
http://dbpedia.org/sparql?query=select%20?s1,%20?s2%20where%20{%20{%20select%20?s1,%20?s2%20where%20{%20?s1%20?x%20?o1%20.%20?o1%20bif:contains%20%27%20(%20%22Pierre%22%20AND%20%22Marie%22%20AND%20%22Curie%22%20AND%20%22University%22%20AND%20%22UPMC%22%20)%27%20option%20(%20score%20?sc%20)%20.%20?s1%20rdfs:label%20?s2%20.%20?s1%20rdf:type%20dbo:EducationalInstitution%20.%20}%20order%20by%20desc%20(%20?sc%20*%203e-1%20%2B%20sql:rnk_scale%20(%20%3CLONG::IRI_RANK%3E%20(%20?s1%20)%20)%20)%20limit%20100%20}%20.%20FILTER%20(%20lang(?s2)%20%3D%20%22en%22)%20}%20limit%202&entailment=rdfs&timeout=2000
there is a problem; the following error page appears:
>Virtuoso 37000 Error SQ156: Internal Optimized compiler error : col is not
supposed to be virtual in sqldf.c:1496.
>Please report the statement compiled.
>
>SPARQL query:
>define sql:big-data-const 0 select ?s1, ?s2 where { { select ?s1, ?s2 where { ?s1 ?x ?o1 . ?o1 bif:contains ' ( "Pierre" AND
"Marie" AND "Curie" AND "University" AND "UPMC" )' option ( score ?sc ) . ?s1 rdfs:label ?s2 . ?s1 rdf:type
dbo:EducationalInstitution . } order by desc ( ?sc * 3e-1 + sql:rnk_scale ( <LONG::IRI_RANK> ( ?s1 ) ) ) limit 100 } . FILTER ( lang(?s2) =
"en") } limit 2
The funny thing is that if let's say reduce the query by removing e.g.
one of the keywords, then the query runs fine:
http://dbpedia.org/sparql?query=select%20?s1,%20?s2%20where%20{%20{%20select%20?s1,%20?s2%20where%20{%20?s1%20?x%20?o1%20.%20?o1%20bif:contains%20%27%20(%20%22Pierre%22%20AND%20%22Marie%22%20AND%20%22Curie%22%20AND%20%22University%22%20)%27%20option%20(%20score%20?sc%20)%20.%20?s1%20rdfs:label%20?s2%20.%20?s1%20rdf:type%20dbo:EducationalInstitution%20.%20}%20order%20by%20desc%20(%20?sc%20*%203e-1%20%2B%20sql:rnk_scale%20(%20%3CLONG::IRI_RANK%3E%20(%20?s1%20)%20)%20)%20limit%20100%20}%20.%20FILTER%20(%20lang(?s2)%20%3D%20%22en%22)%20}%20limit%202&entailment=rdfs&timeout=2000
Do you think there might be a problem with the length of the URL in
Virtuoso?
Has anyone of you come up with such a problem before?
Thank you in advance.
Your help will be greatly appreciated.
Sorry again if this is not the correct forum to report this.
Best Regards,
Nick
-- *************************************************************** *
Dr. Nick Bassiliades, Associate Professor * * Dept. of Informatics,
Aristotle University of Thessaloniki * * 54124 Thessaloniki, Greece *
* * * Tel: +302310997913 E-mail: nbass...@csd.auth.gr * * Fax:
+302310997913 URL: http://tinyurl.com/bassiliades * *
=========================================================== * *
Intelligent Systems Group - http://intelligence.csd.auth.gr *
***************************************************************
I just tried this for XML:
curl -i
"http://dbpedia.org/sparql?default-graph-uri=http%3A%2F%2Fdbpedia.org&query=select+%3Fs1%2C+%3Fs2+where+%7B+%7B%0D%0Aselect+%3Fs1%2C+%3Fs2+where+%7B%0D%0A%3Fs1+%3Fx+%3Fo1+.%0D%0A%3Fo1+bif%3Acontains+%27+%28+%22Pierre%22+AND+%22Marie%22+AND+%22Curie%22+AND+%22University%22+AND+%22UPMC%22+%29+%27+option+%28+score+%3Fsc+%29+.%0D%0A%3Fs1+rdfs%3Alabel+%3Fs2+.%0D%0A%3Fs1+rdf%3Atype+dbo%3AEducationalInstitution+.+%7D%0D%0Aorder+by+desc+%28+%3Fsc+*+3e-1+%2B+sql%3Arnk_scale+%28+%3CLONG%3A%3AIRI_RANK%3E+%28+%3Fs1+%29+%29+%29%0D%0Alimit+100+%7D+.%0D%0AFILTER+%28lang%28%3Fs2%29+%3D+%22en%22%29+%7D%0D%0Alimit+2&format=text%2Fhtml&CXML_redir_for_subjs=121&CXML_redir_for_hrefs=&timeout=30000&debug=on";
HTTP/1.1 200 OK
Date: Wed, 24 Aug 2016 16:09:26 GMT
Content-Type: text/html; charset=UTF-8
Content-Length: 513
Connection: keep-alive
Server: Virtuoso/07.20.3217 (Linux) i686-generic-linux-glibc212-64 VDB
X-SPARQL-default-graph: http://dbpedia.org
Expires: Wed, 31 Aug 2016 16:09:26 GMT
Cache-Control: max-age=604800
Access-Control-Allow-Origin: *
Access-Control-Allow-Credentials: true
Access-Control-Allow-Methods: GET, POST, OPTIONS
Access-Control-Allow-Headers:
DNT,X-CustomHeader,Keep-Alive,User-Agent,X-Requested-With,If-Modified-Since,Cache-Control,Content-Type,Accept-Encoding
Accept-Ranges: bytes
<table class="sparql" border="1">
<tr>
<th>s1</th>
<th>s2</th>
</tr>
<tr>
<td><a
href="http://dbpedia.org/resource/Pierre_and_Marie_Curie_University";>http://dbpedia.org/resource/Pierre_and_Marie_Curie_University</a></td>
<td><pre>"Pierre and Marie Curie University"@en</pre></td>
</tr>
<tr>
<td><a
href="http://dbpedia.org/resource/Polytech'Paris-UPMC">http://dbpedia.org/resource/Polytech'Paris-UPMC</a></td>
<td><pre>"Polytech'Paris-UPMC"@en</pre></td>
</tr>
</table>
And this for JSON:
curl -i
"http://dbpedia.org/sparql?default-graph-uri=http%3A%2F%2Fdbpedia.org&query=select+%3Fs1%2where+%7B+%7B%0D%0Aselect+%3Fs1%2C+%3Fs2+where+%7B%0D%0A%3Fs1+%3Fx+%3Fo1+.%0D%0A%3Fo1+bif%3Acontains+%27+%28+%22Pierre%22+AND+%22Marie%22+AND+%22Curie%22+AND+%22University%22+AND+%22UPMC%22+%29+%27+option+%28+score+%3Fsc+%29+.%0D%0A%3Fs1+rdfs%3Alabel+%3Fs2+.%0D%0A%3Fs1+rdf%3Atype+dbo%3AEducationalInstitution+.+%7D%0D%0Aorder+by+desc+%28+%3Fsc+*+3e-1+%2B+sql%3Arnk_scale+%28+%3CLONG%3A%3AIRI_RANK%3E+%28+%3Fs1+%29+%29+%29%0D%0Alimit+100+%7D+.%0D%0AFILTER+%28lang%28%3Fs2%29+%3D+%22en%22%29+%7D%0D%0Alimit+2&format=application%2Fsparql-results%2Bjson&CXML_redir_for_subjs=121&CXML_redir_for_hrefs=&timeout=30000&debug=on";
HTTP/1.1 200 OK
Date: Wed, 24 Aug 2016 16:11:04 GMT
Content-Type: application/sparql-results+json
Content-Length: 490
Connection: keep-alive
Server: Virtuoso/07.20.3217 (Linux) i686-generic-linux-glibc212-64 VDB
X-SPARQL-default-graph: http://dbpedia.org
Expires: Wed, 31 Aug 2016 16:11:04 GMT
Cache-Control: max-age=604800
Access-Control-Allow-Origin: *
Access-Control-Allow-Credentials: true
Access-Control-Allow-Methods: GET, POST, OPTIONS
Access-Control-Allow-Headers:
DNT,X-CustomHeader,Keep-Alive,User-Agent,X-Requested-With,If-Modified-Since,Cache-Control,Content-Type,Accept-Encoding
Accept-Ranges: bytes
{ "head": { "link": [], "vars": ["s1", "s2"] },
"results": { "distinct": false, "ordered": true, "bindings": [
{ "s1": { "type": "uri", "value":
"http://dbpedia.org/resource/Pierre_and_Marie_Curie_University"; } ,
"s2": { "type": "literal", "xml:lang": "en", "value": "Pierre and
Marie Curie University" }},
{ "s1": { "type": "uri", "value":
"http://dbpedia.org/resource/Polytech'Paris-UPMC" } , "s2": {
"type": "literal", "xml:lang": "en", "value": "Polytech'Paris-UPMC" }}
] } }
--
Regards,
Kingsley Idehen
Founder & CEO
OpenLink Software (Home Page:http://www.openlinksw.com)
Medium Blog:https://medium.com/@kidehen
Blogspot Blog:http://kidehen.blogspot.com
Twitter Profile:https://twitter.com/kidehen
Google+ Profile:https://plus.google.com/+KingsleyIdehen/about
LinkedIn Profile:http://www.linkedin.com/in/kidehen
Personal WebID:http://kingsley.idehen.net/dataspace/person/kidehen#this
------------------------------------------------------------------------------
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
--
***************************************************************
* Dr. Nick Bassiliades, Associate Professor *
* Dept. of Informatics, Aristotle University of Thessaloniki *
* 54124 Thessaloniki, Greece *
* *
* Tel: +302310997913 E-mail: nbass...@csd.auth.gr *
* Fax: +302310997913 URL: http://tinyurl.com/bassiliades *
* =========================================================== *
* Intelligent Systems Group - http://intelligence.csd.auth.gr *
***************************************************************
------------------------------------------------------------------------------
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
