Re: [Virtuoso-users] infrequent errors on parallel querying

e mentioned errors? Best regards Andy -Ursprüngliche Nachricht- Von: Nolle, Andreas Gesendet: Freitag, 4. März 2016 09:10 An: 'Hugh Williams' Cc: Kingsley Idehen ; virtuoso-users@lists.sourceforge.net Betreff: AW: [Virtuoso-users] infrequent errors on parallel querying

Re: [Virtuoso-users] infrequent errors on parallel querying

Dear Kingsley, were you able to reproduce the mentioned behavior regarding the long evaluation time? Did you find any reason for that? Best regards Andy -- Site24x7 APM Insight: Get Deep Visibility into Application Pe

Re: [Virtuoso-users] infrequent errors on parallel querying

nd point, i.e. http Best Regards Andy -Ursprüngliche Nachricht- Von: Hugh Williams [mailto:hwilli...@openlinksw.com] Gesendet: Donnerstag, 3. März 2016 02:09 An: Nolle, Andreas Cc: Kingsley Idehen ; virtuoso-users@lists.sourceforge.net Betreff: Re: [Virtuoso-users] infrequent errors on p

Re: [Virtuoso-users] infrequent errors on parallel querying

blob” errors in the next run of my application. Best regards Andy Von: Hugh Williams [mailto:hwilli...@openlinksw.com] Gesendet: Mittwoch, 2. März 2016 15:55 An: Nolle, Andreas Cc: Kingsley Idehen ; virtuoso-users@lists.sourceforge.net Betreff: Re: [Virtuoso-users] infrequent errors on parallel

Re: [Virtuoso-users] infrequent errors on parallel querying

Dear Hugh, please find the requested information about top50 at https://www.dropbox.com/s/ylrb20ylze38cj6/top50.zip?dl=0 Please notice that both errors (transaction deadlock and No ext map for dp 3193852 in uncommitted blob cpt) only occur if I run several queries (of the type already mentione

Re: [Virtuoso-users] infrequent errors on parallel querying

Dear Kingsley, thanks for your reply. The overall triple counts of each instance is - Virtuoso instance running at port 8891: 17765873 triples - Virtuoso instance running at port 8893: 27897291 triples - Virtuoso instance running at port 8895: 16956 triples - Virtuoso instance running

Re: [Virtuoso-users] infrequent errors on parallel querying

Hi Hugh, this was also my first guess, but the network is not the problem. This is definitively the case because I’ve evaluated again q2 SELECT ?x ?b WHERE { SERVICE { ?x ?b . } . } at Vi

Re: [Virtuoso-users] infrequent errors on parallel querying

Sorry for sending the mail again, but my previous message to Virtuoso-users awaits moderator approval… So I cut out some parts: Hi Hugh, if I open the provided files with an editor, there is no error. For example, profile_q2_federated contain: Connected to OpenLink Virtuoso Driver: 07.20.3215

Re: [Virtuoso-users] infrequent errors on parallel querying

version 7.2.2.3215 since I updated as recently as two weeks ago… My Virtuoso instances hosting the following triple counts: -Virtuoso instance 8891: 17765873 -Virtuoso instance 8893: 27897291 -Virtuoso instance 8895: 16956 -Virtuoso instance 8899: 72372256 B

Re: [Virtuoso-users] infrequent errors on parallel querying

some additional indexing? Cheers Andy Von: Hugh Williams [mailto:hwilli...@openlinksw.com] Gesendet: Dienstag, 23. Februar 2016 01:05 An: Nolle, Andreas Cc: virtuoso-users@lists.sourceforge.net Betreff: Re: [Virtuoso-users] infrequent errors on parallel querying Hi Andreas, Missed that you

Re: [Virtuoso-users] infrequent errors on parallel querying

ruar 2016 17:05 An: Nolle, Andreas Cc: virtuoso-users@lists.sourceforge.net Betreff: Re: [Virtuoso-users] infrequent errors on parallel querying Hi Andreas, How are you running the script for the query profiles as all scripts provided contain errors of the form: Last login: Mon Feb 29 16:01:14

Re: [Virtuoso-users] infrequent errors on parallel querying

Dear Hugh, could you already open and inspect the files? Best Andy Von: Nolle, Andreas Gesendet: Montag, 29. Februar 2016 17:43 An: 'Hugh Williams' Cc: 'virtuoso-users@lists.sourceforge.net' Betreff: AW: [Virtuoso-users] infrequent errors on parallel querying Sorry

Re: [Virtuoso-users] infrequent errors on parallel querying

Sorry for sending the mail again, but my previous message to Virtuoso-users awaits moderator approval… So I cut out some parts: Hi Hugh, if I open the provided files with an editor, there is no error. For example, profile_q2_federated contain: Connected to OpenLink Virtuoso Driver: 07.20.3215

Re: [Virtuoso-users] infrequent errors on parallel querying

willi...@openlinksw.com] Gesendet: Sonntag, 28. Februar 2016 22:21 An: Nolle, Andreas Cc: virtuoso-users@lists.sourceforge.net Betreff: Re: [Virtuoso-users] infrequent errors on parallel querying Hi Andreas, Generally there should be no create additional indexes as the 2 Full & 3 partial indexe

Re: [Virtuoso-users] infrequent errors on parallel querying

silon.slu.se/id/eprint/11557> ) . } . } at another instance is running possibly indefinitely... (stopped the evaluation after 45 minutes). Best Andy -----Ursprüngliche Nachricht- Von: Hugh Williams [mailto:hwilli...@openlinksw.com] Gesendet: Sonntag, 28. Februar 2016 04:14 An: Nolle, And

Re: [Virtuoso-users] infrequent errors on parallel querying

utput of status() at https://www.dropbox.com/s/v6hvw7j7uz9r9uq/virtuoso_files.zip?dl=0 Best Andy -Ursprüngliche Nachricht- Von: Nolle, Andreas [mailto:no...@hs-albsig.de] Gesendet: Freitag, 26. Februar 2016 09:00 An: Hugh Williams Cc: virtuoso-users@lists.sourceforge.net Betreff:

Re: [Virtuoso-users] infrequent errors on parallel querying

Hi Hugh, in the meantime I solved some of the errors. Assuming the following query is evaluated at endpoint running at port 8893: SELECT ?x ?a ?b ?P0src ?P1src WHERE { { SERVICE { ?x ?a . FILTER ( ?x >=

Re: [Virtuoso-users] infrequent errors on parallel querying

Hi Hugh, in addition to my last mail I have the following question: Do the logs “missed delete of name id cache…” have any influence on the completeness of query results? Best Andy Von: Nolle, Andreas Gesendet: Dienstag, 23. Februar 2016 14:42 An: 'Hugh Williams' Cc: virt

[Virtuoso-users] infrequent errors on parallel querying

Hi folks, I've set up four Virtuoso instances (Version 7.2.2.3215) on an Ubuntu 14.04.4 LTS server with 12 cores and 128 GB memory. If I run several (federated) queries in parallel (maximal 16 at a time), where some of the queries may take several minutes, it may happened that a SPARQL endpoint

Re: [Virtuoso-users] execute SPARQL update queries by command line

he -b parameter to 10737418240 (10GB), but it is still the same... Is there a limit for this parameter? Do you see any option to execute a file in isql with around 8 GB? Best Andy Von: Nolle, Andreas [mailto:no...@hs-albsig.de] Gesendet: Montag, 8. Juni 2015 09:40 An: virtuoso-users@lists.sourceforg

Re: [Virtuoso-users] execute SPARQL update queries by command line

The problem is probably solved: I missed the ";" for each command in my txt file... Best Andy Von: Nolle, Andreas [mailto:no...@hs-albsig.de] Gesendet: Montag, 8. Juni 2015 08:50 An: virtuoso-users@lists.sourceforge.net Betreff: [Virtuoso-users] execute SPARQL update queries by comman

[Virtuoso-users] execute SPARQL update queries by command line

Hi all, I need to execute a lot of SPARQL update queries on my virtuoso (Version 7.2.0_p1.3212-pthreads). Using the SPARQL interface is too slow and after some update queries the server won't be available and needs a restart, despite the fact that I set "DEFINE sql:log-enable 3". So my current

Re: [Virtuoso-users] more than 1048576 query results

The approach mentioned by Paul worked for me perfectly, many thanks!!! Best Andy Von: Paul Houle [mailto:ontolo...@gmail.com] Gesendet: Donnerstag, 30. April 2015 18:37 An: Nolle, Andreas Cc: Hugh Williams; virtuoso-users@lists.sourceforge.net Betreff: Re: [Virtuoso-users] more than 1048576

Re: [Virtuoso-users] more than 1048576 query results

In the meantime I’ve upgraded to Version 7.2.0_p1.3212-pthreads and the issue is still the same! Best Andy Von: Nolle, Andreas [mailto:no...@hs-albsig.de] Gesendet: Donnerstag, 30. April 2015 08:21 An: Hugh Williams Cc: virtuoso-users@lists.sourceforge.net Betreff: Re: [Virtuoso-users] more

Re: [Virtuoso-users] more than 1048576 query results

just hanged up without any log entry. Best Andy Von: Hugh Williams [mailto:hwilli...@openlinksw.com] Gesendet: Donnerstag, 30. April 2015 03:08 An: Nolle, Andreas Cc: virtuoso-users@lists.sourceforge.net Betreff: Re: [Virtuoso-users] more than 1048576 query results Hi Andy, 1048576 is a known

[Virtuoso-users] more than 1048576 query results

Hi all, I've tried to retrieve more than 1048576 query results (I know this is much ;) through the SPARQL endpoint, but with no success. I've also tried to retrieve the results by using LIMIT and OFFSET, but the server crashes on querying the second 1048576 results. Is there a way to enable this