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

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

Reply via email to