The critical error is now that after some query evaluations I get a lot of "Virtuoso 40001 Error SR172: Transaction deadlocked" errors. For me this is really strange because I've set the DefaultIsolation = 2 and only SELECT queries are executed. Please notice that I've slightly changed some parameters in the ini files.
It would be really nice if you could help me on that and give me some suggestions how transaction errors can be avoided on evaluating SELECT queries. Please find the current log and ini files of each Virtuoso instance as well as the corresponding output 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 <hwilli...@openlinksw.com> 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 <http://141.87.4.8:8899/sparql> { ?x <http://purl.org/dc/terms/partOf> ?a . FILTER ( ?x >= <http://bibsonomy.org/uri/bibtexkey/conf/icmcs/NagatomoYOIT02/dblp> ) . FILTER ( ?x < <http://bibsonomy.org/uri/bibtexkey/conf/wpmc/EndoMA14/dblp> ) . } . BIND (<http://141.87.4.8:8899/sparql> AS ?P0src) } UNION { SERVICE <http://141.87.4.8:8891/sparql> { ?x <http://purl.org/dc/terms/partOf> ?a . FILTER ( ?x >= <http://bibsonomy.org/uri/bibtexkey/conf/icmcs/NagatomoYOIT02/dblp> ) . FILTER ( ?x < <http://bibsonomy.org/uri/bibtexkey/conf/wpmc/EndoMA14/dblp> ) . } . BIND (<http://141.87.4.8:8891/sparql> AS ?P0src) } UNION { ?x <http://purl.org/dc/terms/partOf> ?a . FILTER ( ?x >= <http://bibsonomy.org/uri/bibtexkey/conf/icmcs/NagatomoYOIT02/dblp> ) . FILTER ( ?x < <http://bibsonomy.org/uri/bibtexkey/conf/wpmc/EndoMA14/dblp> ) . BIND (<http://141.87.4.8:8893/sparql> AS ?P0src) } UNION { SERVICE <http://141.87.4.8:8895/sparql> { ?x <http://purl.org/dc/terms/partOf> ?a . FILTER ( ?x >= <http://bibsonomy.org/uri/bibtexkey/conf/icmcs/NagatomoYOIT02/dblp> ) . FILTER ( ?x < <http://bibsonomy.org/uri/bibtexkey/conf/wpmc/EndoMA14/dblp> ) . } . BIND (<http://141.87.4.8:8895/sparql> AS ?P0src) BIND (<http://141.87.4.8:8895/sparql> AS ?P0src) } . ?b <http://www.aktors.org/ontology/portal#article-of-journal> ?x . FILTER ( ?x >= <http://bibsonomy.org/uri/bibtexkey/conf/icmcs/NagatomoYOIT02/dblp> ) . FILTER ( ?x < <http://bibsonomy.org/uri/bibtexkey/conf/wpmc/EndoMA14/dblp> ) . BIND (<http://141.87.4.8:8893/sparql> AS ?P1src) } If this endpoint has no ?x matching pattern at line 22 of this query, an exception is thrown. It is possible to avoid that by replacing line 20 to 26 by UNION { { ?x <http://purl.org/dc/terms/partOf> ?a . FILTER ( ?x >= <http://bibsonomy.org/uri/bibtexkey/conf/icmcs/NagatomoYOIT02/dblp> ) . FILTER ( ?x < <http://bibsonomy.org/uri/bibtexkey/conf/wpmc/EndoMA14/dblp> ) . } BIND (<http://141.87.4.8:8893/sparql> AS ?P0src) } Best Andy ------------------------------------------------------------------------------ Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140 _______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users ------------------------------------------------------------------------------ Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140 _______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users