Hi Joe,

How is Drupal communicating with Virtuoso is this via some Jena module as error 
reported trying to log-enable 2 is coming from the ARQ parser it  seems because 
it does not understand the Virtuoso custom define. The ARQ parser can be by 
passed to avoid such error as detailed in the docs for our Jena provider, but 
I'm not sure if you have this control in Drupal:

        
http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtJenaProvider#Bypass%20Jena/ARQ%20parser

You can also try setting the "DefaultIsolation" param in the Virtuoso INI file 
to 2 (read committed), which would reduce the occurrence of locks in update 
intensive applications ...

Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc.      //              http://www.openlinksw.com/
Weblog   -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter  -- http://twitter.com/OpenLink
Google+  -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers

On 11 Mar 2013, at 12:23, Joe Corneli <[email protected]> wrote:

> Hello:
> 
> I'm connecting to Virtuoso using Drupal.  The system is under heavy
> use right now (loading in triples).  When I ran a query, I got:
> 
> User error: 500 SPARQL Request Failed "Virtuoso 40001 Error SR172:
> Transaction deadlocked SPARQL query: PREFIX msc: PREFIX s..." in
> ARC2_Reader in _sparql_request() (line 92 of
> /home/joe/staging/beta/sites/all/modules/sparql/sparql.module).
> 
> Do you think I can expect this sort of error to go away when the
> system activity calms down a bit, or is it something I should worry
> about fixing now?  I saw this previous mail on the subject:
> http://www.mail-archive.com/[email protected]/msg03914.html:
> 
> «Have you tried passing the log_enable(2) option in your query string
> which is recommended when performing multiple  concurrent SPARUL
> operations»
> 
> I added
> 
> DEFINE sql:log-enable 2
> 
> at the top of my queries, but this gave another error:
> 
> User error: Could not properly handle "DEFINE sql:log-enable 2 PREFI"
> in ARC2_SPARQLPlusParser in _sparql_request() (line 92 of
> /home/joe/staging/beta/sites/all/modules/sparql/sparql.module).
> 
> (Have I gone about this the wrong way?)
> 
> Joe
> 
> ------------------------------------------------------------------------------
> Symantec Endpoint Protection 12 positioned as A LEADER in The Forrester  
> Wave(TM): Endpoint Security, Q1 2013 and "remains a good choice" in the  
> endpoint security space. For insight on selecting the right partner to 
> tackle endpoint security challenges, access the full report. 
> http://p.sf.net/sfu/symantec-dev2dev
> _______________________________________________
> Virtuoso-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Attachment: smime.p7s
Description: S/MIME cryptographic signature

------------------------------------------------------------------------------
Symantec Endpoint Protection 12 positioned as A LEADER in The Forrester  
Wave(TM): Endpoint Security, Q1 2013 and "remains a good choice" in the  
endpoint security space. For insight on selecting the right partner to 
tackle endpoint security challenges, access the full report. 
http://p.sf.net/sfu/symantec-dev2dev
_______________________________________________
Virtuoso-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Reply via email to