search

dbpedia / virtuoso-sparql-endpoint-quickstart

creates a docker image with Virtuoso preloaded with the latest DBpedia dataset
Other
118 stars 36 forks source link

Installed and sucessfully running the latest_core collection but no results returned for SPARQL queries or pages don't show correctly #24

Open ghost opened 2 years ago

ghost commented 2 years ago

Here is a sparql for returning entries related to Steve Jobs' page :

SELECT ?uri ?sameAs WHERE { ?uri dbo:wikiPageID 7412236 . ?uri owl:sameAs ?sameAs }

It returns values on live dbpedia but when I run through virtuoso on my machine nothing is returned. Also any dbpedia page(Even non-existing ones) have only on statement which is sameAs, pointing to live dbpedia. as below:

Screenshot (50)

What should I do to make it work on my local machine correctly?

keithcallenberg commented 2 years ago

I recently installed this with the docker-compose quickstart and it seems to be loading very similarly to the "live" dbpedia page for me: image

Can you clarify when you say "installed and successfully running" about how long the download/load process took and what message you saw? And you are definitely using the latest_core URI and not the https://databus.dbpedia.org/dbpedia/collections/virtuoso-sparql-endpoint-quickstart-preview ?

ghost commented 2 years ago

It took considerable time to download the data when I used latest_core. Similarly, when I use the started package to test and view the page for Berlin as suggested in the main github page, it shows a similar page to the above :

Screenshot (82)

I'm running these on a VirtualBox Ubuntu machine. And here is the output of the command :

Screenshot (84)

Screenshot (85)

Screenshot (83)

maniol commented 2 years ago

Hi, I also see differences between the public dbpedia endpoint and my local instance (I'm running the docker with the latest core collection: https://databus.dbpedia.org/dbpedia/collections/latest-core). Otherwise, I'm running dockers as they are in the repo (except for adjusting buffer sizes). The query I'm using for testing is:

SELECT DISTINCT ?child  WHERE {
            <http://dbpedia.org/resource/Calcium> dbo:wikiPageWikiLink ?child .}

which returns results on the public endpoint but not on my local endpoint. The endpoint is running locally without any problem. It just seems like some data is missing. That said, I do see: *** Error S2801: [Virtuoso Driver]CL033: Connect failed to store:1111 = store:1111. when running docker-compose up store load Could that be the reason for the missing data? If, what could be the issue? Thanks!

sazirarrwth99 commented 7 months ago

I have exactly the same problem (I only get the sameAs properties, nothing else), have you found a solution yet?