search

AKSW / OntoWiki

Semantic data wiki as well as Linked Data publishing engine
https://ontowiki.net
205 stars 51 forks source link

History doesn't work in the All Resources Section for (medium) big datasets #379

Open shinobu opened 8 years ago

shinobu commented 8 years ago

After clicking on all resources for a knowledge base, clicking the history Button leads to a fatal error

Erfurt_Versioning _sqlQuery failed: SQL Error

Setup:

OntoWiki Develop 456a819

PHP 5.5.9-1ubuntu4.17

Virtuoso Version 07.20.3217-pthreads for Linux as of Jul 4 2016

Erfurt 8340230

shinobu commented 8 years ago

The reason for the error is simple: the History Extension tries to make a query with ~15k or's, which won't work for "bigger" knowledge bases. A way to solve this should be to just use ~1k? per query and concat the results of all queries together

shinobu commented 8 years ago

Update: It seems the Virtuoso Adapter function in Erfurt applies the Limit and Offset Clauses the wrong way (the regex doesn't seem to be correct (the TOP irritates me as well)).

shinobu commented 8 years ago

example file for the knowledge base to reproduce the error dataset.ttl.zip

shinobu commented 8 years ago

the issue #47 might give an explanation for this bug