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
Hi Andreas, Analysing your logs further I see: 1. On the remote (8891) instance the SERVICE keyword references I see many occurrences of the following in there log: 07:11:34 WARNING: * Monitor: Many lock waits 07:13:34 WARNING: * Monitor: Many lock waits 07:15:43 WARNING: * Monitor: Many lock

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] Error installing ODS Weblog

2016-03-02 Thread Hugh Williams
Hi Nashwa, A set of Open Source VADs have been uploaded to the download server which resolve this problem … Note if you compile your own binary then you can also use the configure --enable-ods-vad to build the ODS VADs or —-enable-all-vads to build ALL the available VADs … Best Regards Hugh

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