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

2016-03-08 Thread Hugh Williams
Hi Andreas, On the 8891 & 8895 server instances can you connect with the isql PL Debugger ( isql dba -D ) and provide the output of running the command “info threads” , which will show the current running threads and procedures associated with them as detailed at: http://docs.openlin

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

2016-03-05 Thread Hugh Williams
rs regarding "No ext map for ... in uncommitted > blob cpt" are still be there... > > Please notice that 24 queries are evaluated in parallel via the /sparql end > point, i.e. http > > Best Regards > Andy > > -Ursprüngliche Nachricht- > Von: Hu

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

2016-03-05 Thread Nolle, Andreas
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

2016-03-04 Thread Kingsley Idehen
On 3/4/16 3:12 AM, Nolle, Andreas wrote: > > 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 > > > > It is being looked into by the development and support tea

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

2016-03-04 Thread Nolle, Andreas
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

2016-03-04 Thread Nolle, Andreas
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

2016-03-03 Thread Nolle, Andreas
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users Begin forwarded message: From: Kingsley Idehen mailto:kide...@openlinksw.com>> Subject: Re: [Virtuoso-users] infrequent errors on parallel querying Date: 2 March 2016 at 13:28:22 GMT To: virtuoso-users@lists.sourceforge.net<

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

2016-03-02 Thread Hugh Williams
Hi Andreas, The select top 10 * from sys_l_stat order by waits desc; queries from the 8891 & 8895 instances do not show an excessive number of waits, only about 1990+ waits on the SYS_DAV_QUEUE index. When you ran those queries was the system under typical work load ie was the long running qu

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

2016-03-02 Thread Nolle, Andreas
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

2016-03-02 Thread Kingsley Idehen
On 3/2/16 9:30 AM, Nolle, Andreas wrote: > > 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 ins

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

2016-03-02 Thread Hugh Williams
ubleclick.net/gampad/clk?id=272487151&iu=/4140___ > > <http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140___> > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net

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

2016-03-02 Thread Nolle, Andreas
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

2016-03-02 Thread Kingsley Idehen
On 3/2/16 4:24 AM, Nolle, Andreas wrote: > > 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

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

2016-03-02 Thread Nolle, Andreas
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

2016-03-01 Thread Nolle, Andreas
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

2016-03-01 Thread Nolle, Andreas
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

2016-03-01 Thread Nolle, Andreas
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

2016-03-01 Thread Nolle, Andreas
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

2016-03-01 Thread Nolle, Andreas
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 for sending the mail aga

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

2016-02-29 Thread Nolle, Andreas
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

2016-02-29 Thread Hugh Williams
evaluation of these queries (without SERVICE) at the Virtuoso instance > running at port 8891. > > Best regards > Andy > > > > -----Ursprüngliche Nachricht- > Von: Hugh Williams [mailto:hwilli...@openlinksw.com] > Gesendet: Sonntag, 28. Februar 2016 22:2

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

2016-02-29 Thread Nolle, Andreas
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

2016-02-28 Thread Hugh Williams
> FILTER ( ?x >= <http://eprints.wmin.ac.uk/id/eprint/1620> ) . > FILTER ( ?x < <http://pub.epsilon.slu.se/id/eprint/11557> ) . > } . > } > > at another instance is running possibly indefinitely... (stopped the > evaluation after 45 minutes). > &

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

2016-02-28 Thread Nolle, Andreas
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

2016-02-27 Thread Hugh Williams
t 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: virt

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

2016-02-26 Thread Nolle, Andreas
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 <http://141.87.4.8:8899/sparql> { ?x

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

2016-02-26 Thread Nolle, Andreas
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

2016-02-25 Thread Hugh Williams
HI Andreas, The “missed delete of name id cache…” messages can be ignored as they are more informative and should not be in the default log, so will be moved to a higher or more verbose log level … Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // h

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

2016-02-24 Thread Nolle, Andreas
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: virtuoso-users@lists.sou

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

2016-02-22 Thread Hugh Williams
ies (like the one above) at each Virtuoso > instance, but maximal 16 at one time over all instances. If you look at the > memory usage it starts normally but it increases over time as long as the > swap space is overcrowded… If this will be the case my code (running on > another server

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

2016-02-20 Thread Hugh Williams
Hi Andy, What is a typical query being executing that is result in a HTTP error and what is the actual error ? When the error occurs what is the status of the server at that point , please provide the output of running the command: status(); Are any errors reported in the “virtuoos.lo