OntoWiki icon indicating copy to clipboard operation
OntoWiki copied to clipboard

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

Open shinobu opened this issue 9 years ago • 4 comments

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 avatar Aug 12 '16 19:08 shinobu

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 avatar Aug 27 '16 18:08 shinobu

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 avatar Aug 27 '16 19:08 shinobu

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

shinobu avatar Sep 30 '16 11:09 shinobu

the issue #47 might give an explanation for this bug

shinobu avatar Oct 04 '16 19:10 shinobu