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
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
