Hi Uldis, Update intensive SPARQL update (SPARUL) operations should be performed with Virtuoso transaction isolation level set to “Read Committed” (2), in the Virtuoso INI file and restart, as detailed at;
http://wikis.openlinksw.com/dataspace/owiki/wiki/VirtuosoWikiWeb/ChangeVirtuosoSDefaultTransactionIsolationLevel
Or is can be set at the application level as detailed at:
http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#ptunedotnetiso
This is for the Virtuoso provider, but the ODBC provider should have a similar
call.
The log-enable parameter should also be set to 2 to disable transaction logging
to memory which can deplete system memory and enables row by row autocommit,
as indicated at:
http://docs.openlinksw.com/virtuoso/sparqlextensions.html#rdfsparul
http://docs.openlinksw.com/virtuoso/fn_log_enable.html
http://www.openlinksw.com/dataspace/dav/wiki/Main/VirtTipsAndTricksGuideTransactionLogControl
It would be interested to the the output of the “status(“”):” command run from
isql on the server to see the status of the server in terms of memory “buffers"
in use and whether there are any "locks/deadlocks” occurring, which also should
be handled in the application.
With regards to the Virtuoso ADO.Net Provider, it seems you are writing your
own .Net application by hand and not using Visual Studio Integration services
in which case the following is a good example of how this can be done with the
Virtuoso ADO.Net Provider which should be similar to with the ODBC Provider but
using the Virtuoso providers equivalent classes/methods:
http://docs.openlinksw.com/virtuoso/installwfas.html
http://docs.openlinksw.com/virtuoso/virtclientref.html#virtclientrefprogrammersguide
BTW, have you considered using the DotNetRDF Library at:
http://www.dotnetrdf.org
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 24 Nov 2012, at 21:39, Uldis Bojars wrote:
> Tried the following workaround and it worked (+ works reasonably fast):
> - reconnect ODBC connection after each SPARQL update
>
> Yet it would be good to solve the problem itself.
>
> Best,
> Uldis
>
> On Sat, Nov 24, 2012 at 11:15 PM, Uldis Bojars <[email protected]> wrote:
>> Hi Hugh,
>>
>>> 1. The version of Virtuoso being used as last we spoke you were using 6.1.4
>>> shipped with Ubuntu 12.04 and were going to attempt to rebuild for source
>>> to update to the latest 6.1.6 version ?
>>
>> Still 6.1.4 shipped with Ubuntu. Will update, but did not get around
>> to it yet. However, this problem appears to be client-side.
>>
>>> 2. The version of the Virtuoso ODBC Driver on windows being used ie how
>>> does it compare with the server version being used on Ubuntu ?
>>
>> Version 6.04.3132.01 from Virtuoso Connectivity Kit (guess that is the name).
>>
>>> 3. The query being run that is causing this error, which I assume runs
>>> successfully if run from isql or the /sparql endpoint ?
>>
>> It's a series of INSERT IN GRAPH <uri> { triples } statements. The
>> failure does not happen on the first query, but takes some time (3 -
>> 10 statements in a row) to build up. For some time it happened on
>> every 3rd statement. It does not seem to be associated with any
>> particular statement. It's a number of statements in a row that causes
>> the problem.
>>
>>> You indicate a C# .Net 4.0 application is being used, in which case how
>>> does this application invoke the Virtuoso ODBC Driver does it use the
>>> ADO.Net ODBC Bridge Provider (System.Data.Odbc) built-in or other method.
>>> Also have you
>>
>> Using the ODBC bridge (System.Data.Odbc):
>> _Conn = new OdbcConnection(ConnectionStrings.Sparql());
>> _Conn.Open();
>>
>>> considered using the Virtuoso ADO.Net Provider to make a direct connection
>>> to Virtuoso and invoke SPASQL queries via this means, see:
>>
>> How does this approach differ from the ODBC bridge?
>>
>> Could you show (or point to) an example of doing a SPASQL query via
>> ADO.Net Provider? I got lost in the contents of
>> http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtAdoNet35Provider
>> -- could not find a simple example how to run a SPARQL query.
>>
>> Thanks,
>> Uldis
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------ Monitor your physical, virtual and cloud infrastructure from a single web console. Get in-depth insight into apps, servers, databases, vmware, SAP, cloud infrastructure, etc. Download 30-day Free Trial. Pricing starts from $795 for 25 servers or applications! http://p.sf.net/sfu/zoho_dev2dev_nov
_______________________________________________ Virtuoso-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/virtuoso-users
