Skip to content
This repository has been archived by the owner on Jun 11, 2024. It is now read-only.

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

Open
shinobu opened this issue Aug 12, 2016 · 4 comments
Open
Milestone

Comments

@shinobu
Copy link
Collaborator

shinobu commented Aug 12, 2016

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
Copy link
Collaborator Author

shinobu commented Aug 27, 2016

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
Copy link
Collaborator Author

shinobu commented Aug 27, 2016

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 shinobu changed the title History doesn't work in the All Resources Section History doesn't work in the All Resources Section for (medium) big datasets Sep 30, 2016
@shinobu
Copy link
Collaborator Author

shinobu commented Sep 30, 2016

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

@shinobu shinobu added this to the 1.1 milestone Sep 30, 2016
@shinobu
Copy link
Collaborator Author

shinobu commented Oct 4, 2016

the issue #47 might give an explanation for this bug

@pfrischmuth pfrischmuth self-assigned this Oct 7, 2016
@pfrischmuth pfrischmuth removed their assignment Aug 24, 2021
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants