Hi Pantelis,
If you want fine control over processing of results then Daniel's answer
is the way to go, PLSQL allows you to do basically anything with your
results.
However it's not necessary in this instance I think. We can probably do
what you want with a subquery. Since you only want to p
Hi Piret,
I would suggest run a database integrity check to ensure there is no detected
corruption in the database with the command:
backup '/dev/null';
and possibly consider performing backup-dump and restore or even crash-dump and
restore to correct possible corruption/inconsistency
HI Ghislain,
I get the same error, we are looking into it …
Note the query does run against http://linkedgeodata.org/sparql
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
Weblog -- http://www.openlinksw.com/blogs/
Linke
Thank you for your advice Daniel.
Actually I want to delete only the statements containing the specific
predicate. I don't want to delete all the triples containing the subject of
the predicate. As I have already said, I don't feel comfortable with the
DELETE queries.
Is my query wrong? Could you
So, this has nothing to do with the large vector size, but just to be sure the
SPARQL is correct - do you wish to delete the subjects (and all their triples)
where the subject has the predicate, or just the predicate itself?
As far as avoiding the maximum vector size, I think your best approach
Hi all.
We setup a separate location for virtuoso backup files on a different
volume. First I did a full backup by stopping all processes writing to
virtuoso and executed commands in ISQL terminal:
SQL> checkpoint_interval(-1);
SQL> backup_context_clear();
SQL> checkpoint;
SQL>
backup_online('v
Hi everybody.
I am trying to delete a large number of triples of a very big graph. The
graph contains *217.609.545* triples and I want to delete all the triples
having a specific predicate (*64.884.016* triples).
I am trying to do it through the isql-v command line interface, using the
command:
Hi,
I've just tried this query [1] in the LOD cache
http://lod.openlinksw.com/sparql .
Unfortunately I get this error: "Virtuoso 4000X Error SR176: Transaction
rolled back due to previous SQL error"
What I am missing?
TIA
Ghislain
[1] https://gist.github.com/gatemezing/28ed5e8d01f65f32a818c4338
