paulhoule / telepath

System for mining Wikipedia Usage data to read our collective mind
MIT License
21 stars 1 forks source link

Virtuoso 7 crashed by query #6

Open paulhoule opened 10 years ago

paulhoule commented 10 years ago

The query is

sparql
prefix public: <http://rdf.basekb.com/public/>
prefix vrank: <http://purl.org/voc/vrank#>

select ?type (COUNT(?s) AS ?cnt) (SUM(?eye) AS ?sum) where {
   ?s a ?type .
   ?s vrank:hasRank ?eye .
   FILTER(STRSTARTS(STR(?type), "http://dbpedia.org/ontology")) .
} GROUP BY ?type ORDER BY DESC(?sum)

and the relevant data are the "a" data from the dbpedia ontology and the 3.9 dbpedia file from

http://people.aifb.kit.edu/ath/

In the log I see an error

15:26:46 GPF: ..\libsrc\Wi\chash.c:2332 op not supportted in chash merge

and that source code is here:

https://github.com/openlink/virtuoso-opensource/blob/develop/7/libsrc/Wi/chash.c#L2344

this shuts virtuoso down completely.

paulhoule commented 10 years ago

Hey, they just had to add a blank node...

sparql
prefix public: <http://rdf.basekb.com/public/>
prefix vrank: <http://purl.org/voc/vrank#>

select ?s ?eye where {
   ?s vrank:hasRank ?eye .
![image](https://f.cloud.github.com/assets/2703649/2175074/8112c446-95b9-11e3-9e7b-1a84f50b22ed.png)

} LIMIT 100

gives this:

paulhoule commented 10 years ago

bnodez

paulhoule commented 10 years ago

This problem is fixed for us by changing the query to

prefix public: <http://rdf.basekb.com/public/>
prefix vrank: <http://purl.org/voc/vrank#>

select ?type (COUNT(?s) AS ?cnt) (SUM(?eye) AS ?sum) where {
   ?s a ?type .
   ?s vrank:hasRank ?node .
   ?node vrank:rankValue ?eye
   FILTER(STRSTARTS(STR(?type), "http://dbpedia.org/ontology")) .
} GROUP BY ?type ORDER BY DESC(?sum)

rightanswer

You shouldn't be able to crash V7 by running any query so there is still a bug.

HughWilliams commented 10 years ago

What git branch did you build against as looking at the error it would seem you build against stable/7 from Jul2013:

https://github.com/openlink/virtuoso-opensource/blob/stable/7/libsrc/Wi/chash.c#L2332

Thus I would suggest trying against latest develop/7 branch from a few days ago ...

paulhoule commented 10 years ago

I ran against the latest binary for Windows.

HughWilliams commented 10 years ago

Ah, that is stable/7 from July 2013 for sure as we provide prebuilt binaries as open source is not an out of the box build as on Unix'es ie Linux, Mac etc. not sure if you can build on one of these ?

If not we are planning a new VOS 7 release next week, which will become stable/7 and thus a new Windows binary will be made available for this.

Or, if you can confirm what datasets where loaded to recreate this issue I can try it locally on a develop/7 build on Linux ?