Re: [Virtuoso-users] Running Virtuoso in 200M of RAM?
Hi Lars, By default, triple deletion is performed as part of a transaction, which is stored in memory until the operation is completed and committed to the database. During typical server operation, deleting one or more graphs containing a large number of triples (generally millions or more) can consume available memory to the point where the operation cannot be completed, and thus the graph(s) cannot be deleted. Such large graphs can be cleared by changing the transaction log mode to autocommit on each operation, deleting the graph(s) or triples, and then setting the log mode back to its original setting. This can done using the Virtuoso log_enable function, with the settings log_enable(3,1) as detailed at: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtTipsAndTricksGuideDeleteLargeGraphs Which you will have to perform manually rather than via the Conductor, whose behaviour will be change to similarly turn of transactions when performing such operations in the next release ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ 10 Burlington Mall Road, Suite 265, Burlington MA 01803 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 Feb 2012, at 12:04, Lars Marius Garshol wrote: * Hugh Williams Is this 120K triples already loaded and what is the current triple count of your Virtuoso instance ? Yes, they were already loaded. I did some more deletions, and now the total triple count is 2 295 633. It contains some graphs left over from older work and some unwanted graphs pulled in by Virtuoso (presumably by spongers). It seems I've made a mistake, because now Virtuoso uses 161M on startup. Even if I start running queries and using it for real it stays at that memory usage. However, if I try to delete some more of the unwanted graphs (via the graphs display in Conductor) memory usage rapidly increases into the 450M range. The biggest graph has 1 751 330 statements, and trying to delete this graph causes an error: 40005SR325: Transaction aborted because it's log after image size went above the limit in v:vscx navbar1 (render) I think the memory usage issues I saw earlier were somehow related to this. I'm not sure why memory usage increased on startup, too, but it might have something to do with having 4-5 aborted transactions of this type in the log when starting up. Not being able to delete graphs looks worrying, though. Any ideas about what's causing this? So you should be able to get it to run within 200MB ... It does seem like I should, yes. Thanks for the tips in your email. They may come in handy at other times. Thanks a lot for the help! --Lars M. http://www.garshol.priv.no/tmphoto/ http://www.garshol.priv.no/blog/ -- Virtualization Cloud Management Using Capacity Planning Cloud computing makes use of virtualization - but cloud computing also focuses on allowing computing to be delivered as a service. http://www.accelacomm.com/jaw/sfnl/114/51521223/ ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users smime.p7s Description: S/MIME cryptographic signature
Re: [Virtuoso-users] Insertion w/ explicit datatypes
Hi Percy,
Using “isql” from command line I do get the expected results:
SQL sparql insert data into teste_datatype { subject predicate string,
string^^xsd:string, string^^xsd:String, 1^^xsd:int, 1^^xsd:integer, 2,
2^^xsd:int. };
callret-0
VARCHAR
___
Insert into teste_datatype, 7 (or less) triples -- done
1 Rows. -- 15 msec.
SQL sparql select * from teste_datatype where {?s ?p ?o};
s
p
o
VARCHAR
VARCHAR
VARCHAR
___
subject
predicate
1
subject
predicate
2
subject
predicate
string
subject
predicate
string
subject
predicate
string
5 Rows. -- 39 msec.
SQL
Although querying via the SPARQL endpoint does display the internally stored
datatype information as you report:
s p o
subject predicate 1^^http://www.w3.org/2001/XMLSchema#int
subject predicate 2^^http://www.w3.org/2001/XMLSchema#int
subject predicate string
subject predicate string^^http://www.w3.org/2001/XMLSchema#string
subject predicate string^^http://www.w3.org/2001/XMLSchema#String
I shall seek clarification from development on why this is the case ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
10 Burlington Mall Road, Suite 265, Burlington MA 01803
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 23 Feb 2012, at 20:49, Percy Enrique Rivera Salas wrote:
All,
I successfully inserted the data below, with explicit datatypes through the
Sparql Endpoint (WebBrowser), I also tried using the iSQL and Conductor
Importer
insert data into teste_datatype
{
subject predicate string,
string^^xsd:string,
string^^xsd:String,
1^^xsd:int,
1^^xsd:integer,
2,
2^^xsd:int.
}
But, after the following query execution
select *
from teste_datatype
where {?s ?p ?o}
I got these triples
s p o
subject predicate 1^^http://www.w3.org/2001/XMLSchema#int
subject predicate 2
subject predicate
string^^http://www.w3.org/2001/XMLSchema#string
subject predicate
string^^http://www.w3.org/2001/XMLSchema#String
subject predicate string
I would expected something like
s p o
subject predicate 1
subject predicate 2
subject predicate string
Is this a bug? or am I doing something wrong?
Best Regards,
Percy
--
Virtualization Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
smime.p7s
Description: S/MIME cryptographic signature
Re: [Virtuoso-users] Undefined procedure DB.DBA.isgeometry
Hi Natanael What are you wanting to “import” this data to ? Are you wanting to setup your own DBpedia instance ? The geo:geometry (POINT) triples are generated by after loading the base DBpedia datasets by the Virtuoso commercial instance hosting the DBpedia endpoint (http://dbpedia.org/sparql) this feature is enabled. If you want to load DBpedia into Virtuoso open source then you should load from the base dataset which will then just contain the geo:long and geo:lat (geo = http://www.w3.org/2003/01/geo/wgs84_pos#) triples. Details on loading the Dbpedia datasets into Virtuoso can be found at: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtBulkRDFLoaderExampleDbpedia Or if you really want the geo:geometry data then you need a commercial license to enable this to be support, which can acquire a license and setup locally or we have a AWS snapshot of the live DBpedia instance you can instantiate in the cloud in minutes as detailed at: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtAWSDBpedia351C Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ 10 Burlington Mall Road, Suite 265, Burlington MA 01803 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 22 Feb 2012, at 23:29, Natanael Arndt wrote: Hello, as I read in the forum [1] the geometry functions are not available in virtuoso open source. But is there any chance to import data from dbpedia because many of them contain triple like this: http://dbpedia.org/resource/Montreal http://www.w3.org/2003/01/geo/wgs84_pos#geometry POINT(-73.5542 45.5089)^^http://www.openlinksw.com/schemas/virtrdf#Geometry . see [2]. Kind regards, Natanael [1] http://boards.openlinksw.com/phpBB3/viewtopic.php?f=12t=1599 [2] http://dbpedia.org/data/Montreal.ntriples -- Virtualization Cloud Management Using Capacity Planning Cloud computing makes use of virtualization - but cloud computing also focuses on allowing computing to be delivered as a service. http://www.accelacomm.com/jaw/sfnl/114/51521223/ ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users smime.p7s Description: S/MIME cryptographic signature
Re: [Virtuoso-users] Running Virtuoso in 200M of RAM?
Hi Lars, Is this 120K triples already loaded and what is the current triple count of your Virtuoso instance ? Assuming an average triple size for v6 of 30bytes * 120K = 3.6 million bytes of memory roughly required for hosting that number of triples. Thus what else is being hosted/run on your Virtuoso installation, as 360 MB would appear excessive? Can you provide a copy of your virtuoso.ini virtuoso.log file and the output of running the “status(‘’)” command from isql. On my Mac OS X Lion Machine starting with an empty default database the server size in memory is about 230MB, commenting out the [Plugin] section for PHP, IM extension etc support in the INI file reduces its size to about 150MB, enabling the Virtuoso LiteMode in the INI file (http://docs.openlinksw.com/virtuoso/databaseadmsrv.html) which disables all HTTP services and runs the server with minimum memory foot print then reduces memory consumption to about 120MB. So you should be able to get it to run within 200MB ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ 10 Burlington Mall Road, Suite 265, Burlington MA 01803 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 23 Feb 2012, at 11:09, Lars Marius Garshol wrote: I want to try to use Virtuoso for a private web application (non-commercial), but since this is a virtual host (Linux), it doesn't have much memory available. Running Virtuoso on my laptop (MacOS X) I see it consistently use 400-600M of RAM, which is too much for this particular use case. The graph I'll be working with has ~120,000 triples. It may grow a bit, but that's the order of magnitude we're talking about. I found this page: http://docs.openlinksw.com/virtuoso/dbadm.html which documents some parameters that can be used to tweak the memory usage. I haven't changed any of these from the defaults, because as the defaults stand we should use 16M for buffers and 1M for threads. That leaves something like 380M used by things not controlled by these parameters. There seems little point in trying to tweak the parameters, because either they don't affect the memory usage much, or I don't understand what they mean. Should I expect to be able to run Virtuoso with this sort of memory usage at all, or should I just give up? Will Linux memory usage be different? Are there any parameters I should try modifying? --Lars M. http://www.garshol.priv.no/tmphoto/ http://www.garshol.priv.no/blog/ -- Virtualization Cloud Management Using Capacity Planning Cloud computing makes use of virtualization - but cloud computing also focuses on allowing computing to be delivered as a service. http://www.accelacomm.com/jaw/sfnl/114/51521223/ ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users smime.p7s Description: S/MIME cryptographic signature
Re: [Virtuoso-users] Strange error sparql 6.1.3 to 6.1.4
Hi Peter,
Note we are looking into this and will provide an update soon ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
10 Burlington Mall Road, Suite 265, Burlington MA 01803
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 22 Feb 2012, at 05:42, Peter Secomb wrote:
Hi everyone,
We just upgraded virtuoso from 6.1.3 to 6.1.4 in our test environment and
some sparql queries that were working appear to be breaking. We are getting
the following error:
Virtuoso 37000 Error SP031: SPARQL compiler: Internal error:
ssg_print_equiv_retval_expn(): select selid is out of scope
The query is of the form:
select ?s ? p ?o
where {
{select ?s ?p ?o where {conditions}}
union
{select ?s ?p ?o where {other conditions}}
}
All sub-queries run correctly as stand alone queries, however combining them
together with a UNION under 6.1.4 throws the above error. It works without
issue under 6.1.3
Does anyone have any thoughts on this?
Regards,
Peter Secomb
clearbluewater.com.au
--
Virtualization Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
smime.p7s
Description: S/MIME cryptographic signature
Re: [Virtuoso-users] (no subject)
Hi Aem, Looking at the date of your Virtuoso build you are using a 6.1.3 build from March 2011 at best, whereas the latest Virtuoso build is available are 6.1.4 and running your query below does not crash my server on Mac OS X Lion, thus I would recommend you upgrade to this version to see if the problem persists. You can download the source for compilation from: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VOSDownload Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ 10 Burlington Mall Road, Suite 265, Burlington MA 01803 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 17 Feb 2012, at 23:22, Aem Cradle wrote: Hello! I'm using Virtuoso Version 06.01.3127-pthreads for Darwin as of May 28 2011 running isql I'm running the following query: select * from DB.DBA.SYS_INDEX_SPACE_STATS; And virtuoso crashes with the following lines on standard output: 19:28:05 INFO: HTTP/WebDAV server online at 8891 19:28:05 INFO: Server online at 1112 (pid 40690) 19:28:14 INFO: Server received signal 11. Continuing with the default action for that signal. isql outputs the following message: *** Error 08S01: [Virtuoso Driver]CL065: Lost connection to server at line 1 of Top-Level: select * from DB.DBA.SYS_INDEX_SPACE_STATS This is the command line I'm using to run virtuoso: /opt/local/bin/virtuoso-t -df +foreground +debug +configfile /mcradle/temp/virtuoso.ini nothing gets written to the error log file, and I can't find any trace of a callstack, even though CallstackOnException is set to 2 in virtuoso.ini what I'm really after besides reporting this bug is to get an idea why the database takes 1GB where it shouldn't have much data in. Any guidance will be appreciated Thanks, mcradle. ==more technical information follows: This is the macport info on the package: bash-3.2$ port info virtuoso virtuoso @6.1.4 (devel) Variants: universal Description: Virtuoso is an enterprise-grade server that delivers a platform for Data Access, Integration and Management. Homepage: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/ Build Dependencies: gawk Library Dependencies: libiodbc, openssl Platforms:darwin License: GPL Maintainers: s...@macports.org, openmaintai...@macports.org and this is the content of /mcradle/temp/virtuoso.ini [Database] DatabaseFile=/Users/mcradle/Library/Preferences/KDE/share/apps/nepomuk/repository/main/data/virtuosobackend/soprano-virtuoso.db ErrorLogFile=/Users/mcradle/Library/Preferences/KDE/share/apps/nepomuk/repository/main/data/virtuosobackend/soprano-virtuoso.log TransactionFile=/Users/mcradle/Library/Preferences/KDE/share/apps/nepomuk/repository/main/data/virtuosobackend/soprano-virtuoso.trx xa_persistent_file=/Users/mcradle/Library/Preferences/KDE/share/apps/nepomuk/repository/main/data/virtuosobackend/soprano-virtuoso.pxa [TempDatabase] DatabaseFile=/Users/mcradle/Library/Preferences/KDE/share/apps/nepomuk/repository/main/data/virtuosobackend/soprano-virtuoso-temp.db TransactionFile=/Users/mcradle/Library/Preferences/KDE/share/apps/nepomuk/repository/main/data/virtuosobackend/soprano-virtuoso-temp.trx MaxCheckpointRemap=1000 [Parameters] LiteMode=0 ServerPort=1112 ;mcradle change to enable tcp DisableTcpSocket=1 PrefixResultNames=0 ServerThreads=100 NumberOfBuffers=2000 MaxDirtyBuffers=1333 SchedulerInterval=5 FreeTextBatchSize=1000 CheckpointInterval=10 MinAutoCheckpointSize=20 ;Mcradle enable callstack (does not help) CallstackOnException = 2 TraceOn = errors -- Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-dev2___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users smime.p7s Description: S/MIME cryptographic signature
Re: [Virtuoso-users] Default Configuration always loaded
Hi Sherif, Were is the virtuoso.ini file you are editing located and is it in the same location as the registered Windows Virtuoso Server. If they are in the same location then perhaps you do not have privileges to write to the virtuoso.ini file . Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ 10 Burlington Mall Road, Suite 265, Burlington MA 01803 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 17 Feb 2012, at 23:13, sherif kandel wrote: When I start the virtuoso service with the configuration file virtuoso.ini Which I edited. after starting the virtuoso server, I type status(); and I find the configuration parameters is the default ones, not the ones I edited, I tried to edit some from the localhost/conductor some gets edit, and some like NumberOfBuffers is not even there, When I try To add it to the parametrs it returns error ?? -- Virtualization Cloud Management Using Capacity Planning Cloud computing makes use of virtualization - but cloud computing also focuses on allowing computing to be delivered as a service. http://www.accelacomm.com/jaw/sfnl/114/51521223/___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users smime.p7s Description: S/MIME cryptographic signature
Re: [Virtuoso-users] overriding the server timeout
Hi Sherif, You say “The library makes the timeout 30seconds” by which I presume you mean the dotNetRDF library, in which case where is this setting actually made and what is the actual timeout error message being received as it sounds as if its value is overriding the one you are setting in the ConnectString ? Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ 10 Burlington Mall Road, Suite 265, Burlington MA 01803 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 17 Feb 2012, at 01:37, sherif kandel wrote: Hi, I started the virtuoso service on windows with the following configurations (configuration files attached) I'm using the dotNetRDF library to make local queries to the local server (The library makes the timeout 30seconds) , but I can override the default timeout by sending a connection string when starting the object: VirtuosoManager manager = new VirtuosoManager(Server=localhost;Uid=dba;pwd=dba;Connection Timeout=500); it still times out at 30seconds (if my query is complex enough to process in more than 30 seconds... My project uses some complex queries, so I need the timeout property as large as possible , how can I override that property ? virtuoso2.ini-- Virtualization Cloud Management Using Capacity Planning Cloud computing makes use of virtualization - but cloud computing also focuses on allowing computing to be delivered as a service. http://www.accelacomm.com/jaw/sfnl/114/51521223/___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users smime.p7s Description: S/MIME cryptographic signature
Re: [Virtuoso-users] Best way to import large RDF files into Virtuoso?
Hi Peter, The Virtuoso RDF Bulk Loader functions detailed in the following documentation link are what you should use: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtBulkRDFLoader Some of the DBpedia datasets we load with it are 2.5GB+ in size ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ 10 Burlington Mall Road, Suite 265, Burlington MA 01803 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 16 Feb 2012, at 17:15, Peter DeVries wrote: What is the best way to import large RDF files into Virtuoso and assign them to a specific named graph? I have one that is over 600MB and another that is about 340 MB. Normally I would have converted these to n3 and then split them, but the tools I have used don't seem to work on files this large. Thanks, - Pete Pete DeVries Department of Entomology University of Wisconsin - Madison 445 Russell Laboratories 1630 Linden Drive Madison, WI 53706 Email: pdevr...@wisc.edu TaxonConceptGeoSpecies Knowledge Bases A Semantic Web, Linked Open Data Project -- -- Virtualization Cloud Management Using Capacity Planning Cloud computing makes use of virtualization - but cloud computing also focuses on allowing computing to be delivered as a service. http://www.accelacomm.com/jaw/sfnl/114/51521223/___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users smime.p7s Description: S/MIME cryptographic signature
Re: [Virtuoso-users] Renaming a big graph
Hi Martin, Looking at your Virtuoso Server version it appears to be an early 6.1.3 pre-release version from Sept 2010, with the 6.1.3 official release having been made in March 2011, and a 6.1.4 release in Nov 2011. So I would recommend and upgrade to the latest 6.1.4 release. Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ 10 Burlington Mall Road, Suite 265, Burlington MA 01803 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 8 Feb 2012, at 12:21, Martin Gerlach wrote: Hi Hugh, virtuoso-t -? Virtuoso Open Source Edition (multi threaded) Version 6.1.3-pre1.3127-pthreads as of Sep 23 2010 Compiled for Linux (x86_64-unknown-linux-gnu) Cheers, Martin On 24.01.2012 02:16, Hugh Williams wrote: Hi Martin, Assuming an average triple size of 30 bytes, 150 million triples would require 4.5GB of memory ie 562500 (4.5GB / 8K) NumberOfBuffers. Although also how many triples are there in the Virtuoso Quad stores as that would determine the size required for hosting to the database working set in memory. What is the Virtuoso version being used, which can be determined by running the command: virtuoso-t -? Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ 10 Burlington Mall Road, Suite 265, Burlington MA 01803 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 23 Jan 2012, at 13:59, Martin Gerlach wrote: Hi Hugh, I tried as described on the Web page. For a while, memory usage remained constant, but after a while it suddenly rose and broke: 14:55:30 ERROR: Memory low! Using memory reserve to terminate current activities properly 14:55:30 ERROR: Current location of the program break 13070086144 14:55:30 ERROR: GPF: gate.c:1464 loop in registered cursors Any recommendation on the NumberOfBuffers settings for that operation? Cheers, Martin On 23.01.2012 12:43, Hugh Williams wrote: Hi Martin, Please see the following tip on rename graphs in Virtuoso, the key for large graphs being to perform the operation in auto-commit mode (log_enable(3)) to avoid excessively sized transaction log depleting memory: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtTipsAndTricksGuideRenameGraph Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ 10 Burlington Mall Road, Suite 265, Burlington MA 01803 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 23 Jan 2012, at 10:49, Martin Gerlach wrote: Hi, I'd like to rename a graph with about 150 million triples in Virtuoso Open Source 6.1 The Virtuoso db file has 16GB. Which is the best way to rename such a big graph? Going through Conductor/RDF/Graphs/rename or using isql? Which are the required buffer sizes for renaming the graph? I tried with 2,3 Mio max buffers and max dirty buffers (18 GB which is 75% of the machine's RAM), but Virtuoso crashed after this log output: 11:37:36 ERROR: Memory low! Using memory reserve to terminate current activities properly 11:37:36 ERROR: Current location of the program break 19991629824 11:37:36 ERROR: GPF: gate.c:1464 loop in registered cursors Cheers, Martin -- Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-dev2 ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users -- Martin Gerlach Senior Softwareentwickler Research Neofonie GmbH Robert-Koch-Platz 4 10115 Berlin T +49.30 24627 413 F +49.30 24627 120 martin.gerl...@neofonie.de http://www.neofonie.de Handelsregister Berlin
Re: [Virtuoso-users] Problem Virtuoso Bulk Loader
Hi Aliki, What exactly is the problem you are having executing the isql program, provide the error being reported from the attempt to execute it ? Did you compile the 6.1.4 sources yourself, as if you have a working Virtuoso server ie virtuoso-t then you should also have an isql in the same location. If you have installed on of these prebuilt Linux distro’s from the vendor then the binary will be called “isql-v” by default in /usr/sbin as there is already a component shipped called “isql” which precedes it ? Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ 10 Burlington Mall Road, Suite 265, Burlington MA 01803 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 2 Feb 2012, at 10:28, aliki aliki wrote: Hi everyone! I'm trying to load dbpedia datasets. I have installed virtuoso opensource 6.1.4. According to this page: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtBulkRDFLoaderExampleDbpedia I should execute the Bulk Loading Script. However I have trouble in executing the isql program. The command $ isql doesn't work. I presume that I am not in the correct file path but I don't know which one is the correct and the one indicated by the example doesn't exist in my virtuoso folders. Thanks! Aliki -- Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users smime.p7s Description: S/MIME cryptographic signature
Re: [Virtuoso-users] connecting with java application...
Hi Sid, You only need the Virtuoso JVM enabled binary if you intend to build and host a Java applications (JSP etc) in Virtuoso or want to call Java classes within Virtuoso as detailed at: http://docs.openlinksw.com/virtuoso/javaextvm.html http://docs.openlinksw.com/virtuoso/rthjsp.html In you case I suspect you just want some means JDBC, Hibernate, Jena, Sesame etc of connecting with the Virtuoso database from Netbeans or other Java application, all of which are data access methods Virtuoso supports: http://docs.openlinksw.com/virtuoso/VirtuosoDriverJDBC.html http://docs.openlinksw.com/virtuoso/VirtuosoDriverJDBC.html#JDBCDriverhibernate http://docs.openlinksw.com/virtuoso/rdfnativestorageproviders.html Assuming you intend to use one of the above methods there is nothing else to setup apart from configuring a connection via the chosen method ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ 10 Burlington Mall Road, Suite 265, Burlington MA 01803 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 31 Jan 2012, at 05:15, siddharth shirke wrote: Hi! there, Thank you very much for the guidance. I have virtuoso running on my computer now. Now, I want to integrate it with the application that I am building using java+javafx on Netbeans IDE. Is there anything else I need to set up before using it with java? I read in the documentation: . Note we also provide binaries with Java (virtuoso-javavm-t) and .Net CLR (virtuoso-clr-t) hosting support, which can be substituted for virtuoso-t in this and the sections below if such support is required. .. so, do I need to set up an instance of virtuoso using virtuoso-javavm-t in order for me to integrate it with java application I have already set up an instance of virtuoso using virtuoso-t. Also what if I want to use Flex or Adobe Flash professional or simple HTML/HTML5 to create an application, instead. Many thanks, sid From: Hugh Williams hwilli...@openlinksw.com To: siddharth shirke siddhu...@yahoo.co.in Cc: virtuoso-users@lists.sourceforge.net virtuoso-users@lists.sourceforge.net Sent: Monday, 30 January 2012 11:19 PM Subject: Re: [Virtuoso-users] problem installing virtuoso open-source 6.1.3 prebuilt binaries on windows 7 Hi Sid, Have you ensured the Virtuoso Windows Service has first been started before the attempting the ODBC connection ? Note the ODBC connection is not required for the Virtuoso server to work, only if you want to make and ODBC connection to the database. I assume you are following the documentation at: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VOSUsageWindows Which I noticed details the creation of an ODBC DSN before the database is started which seem to be was you may be doing, so I have removed that section to after the Virtuoso Database which should make things clearer. As a general not always check the “virtuoso.log” file in the “database” directory of your Virtuoso installation to ensure the database server has started and is online, if not an error/reason should be given for the failure to start ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ 10 Burlington Mall Road, Suite 265, Burlington MA 01803 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 30 Jan 2012, at 17:43, siddharth shirke wrote: Hi! there, I am trying to install virtuoso open-source 6.1.3 binaries on my windows 7 32-bit computer. I am sure I am following the instructions correctly. But when I try to setup DSN I get the error : ... SQL State: S2801 Reason: [OpenLink][Virtuoso ODBC Driver]CL033:Connect failed to my-IP-address:= my-IP-address:
Re: [Virtuoso-users] problem installing virtuoso open-source 6.1.3 prebuilt binaries on windows 7
Hi Sid, Have you ensured the Virtuoso Windows Service has first been started before the attempting the ODBC connection ? Note the ODBC connection is not required for the Virtuoso server to work, only if you want to make and ODBC connection to the database. I assume you are following the documentation at: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VOSUsageWindows Which I noticed details the creation of an ODBC DSN before the database is started which seem to be was you may be doing, so I have removed that section to after the Virtuoso Database which should make things clearer. As a general not always check the “virtuoso.log” file in the “database” directory of your Virtuoso installation to ensure the database server has started and is online, if not an error/reason should be given for the failure to start ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ 10 Burlington Mall Road, Suite 265, Burlington MA 01803 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 30 Jan 2012, at 17:43, siddharth shirke wrote: Hi! there, I am trying to install virtuoso open-source 6.1.3 binaries on my windows 7 32-bit computer. I am sure I am following the instructions correctly. But when I try to setup DSN I get the error : ... SQL State: S2801 Reason: [OpenLink][Virtuoso ODBC Driver]CL033:Connect failed to my-IP-address:= my-IP-address:. ... At the top of the window it also reads that Database connection failed. I don't understand why is this happening as I have followed the steps correctly. I am doing a university project to convert non-RDF into RDF and display it using my own application and I need to get this virtuoso running asap. many thanks, sid -- Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-dev2___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users smime.p7s Description: S/MIME cryptographic signature
Re: [Virtuoso-users] Renaming a big graph
Hi Martin, Assuming an average triple size of 30 bytes, 150 million triples would require 4.5GB of memory ie 562500 (4.5GB / 8K) NumberOfBuffers. Although also how many triples are there in the Virtuoso Quad stores as that would determine the size required for hosting to the database working set in memory. What is the Virtuoso version being used, which can be determined by running the command: virtuoso-t -? Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ 10 Burlington Mall Road, Suite 265, Burlington MA 01803 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 23 Jan 2012, at 13:59, Martin Gerlach wrote: Hi Hugh, I tried as described on the Web page. For a while, memory usage remained constant, but after a while it suddenly rose and broke: 14:55:30 ERROR: Memory low! Using memory reserve to terminate current activities properly 14:55:30 ERROR: Current location of the program break 13070086144 14:55:30 ERROR: GPF: gate.c:1464 loop in registered cursors Any recommendation on the NumberOfBuffers settings for that operation? Cheers, Martin On 23.01.2012 12:43, Hugh Williams wrote: Hi Martin, Please see the following tip on rename graphs in Virtuoso, the key for large graphs being to perform the operation in auto-commit mode (log_enable(3)) to avoid excessively sized transaction log depleting memory: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtTipsAndTricksGuideRenameGraph Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ 10 Burlington Mall Road, Suite 265, Burlington MA 01803 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 23 Jan 2012, at 10:49, Martin Gerlach wrote: Hi, I'd like to rename a graph with about 150 million triples in Virtuoso Open Source 6.1 The Virtuoso db file has 16GB. Which is the best way to rename such a big graph? Going through Conductor/RDF/Graphs/rename or using isql? Which are the required buffer sizes for renaming the graph? I tried with 2,3 Mio max buffers and max dirty buffers (18 GB which is 75% of the machine's RAM), but Virtuoso crashed after this log output: 11:37:36 ERROR: Memory low! Using memory reserve to terminate current activities properly 11:37:36 ERROR: Current location of the program break 19991629824 11:37:36 ERROR: GPF: gate.c:1464 loop in registered cursors Cheers, Martin -- Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-dev2 ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users -- Martin Gerlach Senior Softwareentwickler Research Neofonie GmbH Robert-Koch-Platz 4 10115 Berlin T +49.30 24627 413 F +49.30 24627 120 martin.gerl...@neofonie.de http://www.neofonie.de Handelsregister Berlin-Charlottenburg: HRB 67460 Geschäftsführung Thomas Kitlitschko Dr. Mario Lenz -- Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-dev2___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users smime.p7s Description: S/MIME cryptographic signature
Re: [Virtuoso-users] Rewrite Sparql endpoint
Hi Peter, What is the “DynamicLocal” setting in your “virtuoso.ini” config file as this setting if enabled would result in the domain name part of the URL being used rather than the URiQA DefaultHost setting as detailed in the documentation link: http://docs.openlinksw.com/virtuoso/uriqa.html#uriqaws If disabled ie DynamicLocal = 0” , which is the default setting, thus should prevent the Dynamic translation of the hostname part of an IRI via the SPARQL endpoint and other HTTP interfaces ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ 10 Burlington Mall Road, Suite 265, Burlington MA 01803 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 Jan 2012, at 03:28, Peter Secomb wrote: Hi Hugh, Regarding URL Rewrite via the SPARQL Endpoint... If a triple exists such as http://localhost:8890/a/b/c http://ontology/attribute 'value' When queried we get http://domain.com.au/a/b/c http://ontology/attribute 'value' For this query the value of URIQA DefaultHost = localhost:8890 I'd have thought that instead of getting the domain the URIQA would rewrite localhost to use the DefaultHost value which is 'localhost'. Eg no change should have taken place. The problem we have when querying through the sparql endpoint is that it is impossible to determine the true value of the triple, eg localhost or domain. We have to use isql to avoid the url rewrite to see the true value of the triples. The guides you sent explain how to turn url rewrite on and set the regexp for a specific scenario's but I haven't found anything to switch url rewrite off across the board such that when data is retrieved via the sparql endpoint the true values of each triple component is displayed rather than the rewritten value. Regards, Peter Secomb clearbluewater.com.au On 18 November 2011 12:25, Hugh Williams hwilli...@openlinksw.com wrote: Hi Sachit, You probably need to set the URIQA “DefaultHost” parameter in the Virtuoso configuration INI file to the hostname you want to be used in the rewrite rules as detailed at: http://docs.openlinksw.com/virtuoso/uriqa.html#uriqaws http://docs.openlinksw.com/virtuoso/dbadm.html#ini_URIQA As the default setting is “localhost:8890” and the rewrite rules typically use the “URIQADefaultHost” macro function to read the value of the URIQA DefaultHOst param in the INI file for use in generating the hostname for the URL as indicated in the example at: http://docs.openlinksw.com/virtuoso/fn_urlrewrite_create_regex_rule.html#ex_urlrewrite_create_regex_rule I hope this resolves the problem for you ... Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 17 Nov 2011, at 06:04, Sachit Malhotra wrote: Hi Guys, Can anyone tell me how i can stop url rewrite from the sparql endpoint? For example, i have a namespace: http://localhost:8890/schemas/demo and my domain is http://demo.cbw.com.au, So when i query the sparql endpoint, it rewrites localhost to demo.cbw.com.au. Any help is much appreciated. Thanks. -- Sachit Malhotra | Clear Blue Water Pty Ltd +61 403565478 | smalho...@clearbluewater.com.au -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-novd2d___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-novd2d ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users -- Keep Your Developer Skills Current with LearnDevNow! The most comprehensive
Re: [Virtuoso-users] Renaming a big graph
Hi Martin, Please see the following tip on rename graphs in Virtuoso, the key for large graphs being to perform the operation in auto-commit mode (log_enable(3)) to avoid excessively sized transaction log depleting memory: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtTipsAndTricksGuideRenameGraph Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ 10 Burlington Mall Road, Suite 265, Burlington MA 01803 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 23 Jan 2012, at 10:49, Martin Gerlach wrote: Hi, I'd like to rename a graph with about 150 million triples in Virtuoso Open Source 6.1 The Virtuoso db file has 16GB. Which is the best way to rename such a big graph? Going through Conductor/RDF/Graphs/rename or using isql? Which are the required buffer sizes for renaming the graph? I tried with 2,3 Mio max buffers and max dirty buffers (18 GB which is 75% of the machine's RAM), but Virtuoso crashed after this log output: 11:37:36 ERROR: Memory low! Using memory reserve to terminate current activities properly 11:37:36 ERROR: Current location of the program break 19991629824 11:37:36 ERROR: GPF: gate.c:1464 loop in registered cursors Cheers, Martin -- Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-dev2 ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users smime.p7s Description: S/MIME cryptographic signature
Re: [Virtuoso-users] Multiple instances - One SPARQL endpoint
Hi Houda, I can’t see how this can be readily done without the use of SPARQL-FED ie SERVICE keyword. Why do you have data in separate Virtuoso Quad Store instances on the same machine rather than in a single Virtuoso Quad Store instance, is the data in each instance the same or different ? Note Virtuoso is a Quad rather than Triple store and thus can host multiple Graphs in the same instance and can use graph groups/security and/or WebID to control access to specific graphs or groups of graphs in the Quad store if necessary. Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ 10 Burlington Mall Road, Suite 265, Burlington MA 01803 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 Jan 2012, at 14:36, Houda khrouf wrote: Hi, I am using the open-virtuoso-6.1.3. I created multiple Virtuoso instances on a single machine. Each instance has unique SQL and HTTP port numbers. So, each instance is accessible via a unique SPARQL endpoint. I wonder if there is a way in Virtuoso to manage them in just a single SPARQL endpoint (without using of the SERVICE keyword of the SPARQL 1.1). Do you have any suggestion ? Thanks, Houda -- Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex infrastructure or vast IT resources to deliver seamless, secure access to virtual desktops. With this all-in-one solution, easily deploy virtual desktops for less than the cost of PCs and save 60% on VDI infrastructure costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users smime.p7s Description: S/MIME cryptographic signature
Re: [Virtuoso-users] MODIFY statement doesn't work properly
Hi Percy,
Note, Ivan does most of the work on the Virtuoso SPARQL engine so you should
follow his advise ...
Although I would like to point out that even your last query runs successfully
for me against an open source 6.1.4 or commercial 6.3 build, thus are you
running against an open source 6.1.3 build still ?
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
10 Burlington Mall Road, Suite 265, Burlington MA 01803
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 12 Jan 2012, at 14:21, Ivan Mikhailov wrote:
Hello Percy,
I'd write either
MODIFY http://test.com/
delete
{?s ?p ?o}
insert
{?s_new ?p ?o}
where
{
{
SELECT iri(bif:replace(
str(?s),http://test.com/link,http://test.com/extra/link; ) )
AS ?s_new ?s ?p ?o
WHERE
{?s ?p ?o
filter (regex (str(?s), http://test.com/link;))
}
}
}
or
MODIFY http://test.com/
delete
{?s ?p ?o}
insert
{`iri(?s_new)` ?p ?o}
where
{
{
SELECT bif:replace(
str(?s),http://test.com/link,http://test.com/extra/link; )
AS ?s_new ?s ?p ?o
WHERE
{?s ?p ?o
filter (regex (str(?s), http://test.com/link;))
}
}
}
or even
MODIFY http://test.com/
delete
{?s ?p ?o}
insert
{ `iri(bif:replace(
str(?s),http://test.com/link,http://test.com/extra/link; ))`
?p ?o }
where
{
{?s ?p ?o
filter (regex (str(?s), http://test.com/link;))
}
}
}
but in any case I'd convert string to IRI somewhere before trying to
construct a subject node.
Best Regards,
Ivan Mikhailov
OpenLink Software
http://virtuoso.openlinksw.com
On Thu, 2012-01-12 at 10:55 -0200, Percy Enrique Rivera Salas wrote:
Hi Hugh,
I provided a wrong example =(
the right one is the following
Virtuoso 22023 Error SR007: Function sprintf needs a string or UNAME or NULL
as argument 2, not an arg of type INTEGER (189)
MODIFY http://test.com/
delete
{?s ?p ?o}
insert
{?s_new ?p ?o}
where
{
{
SELECT
bif:replace(str(?s),http://test.com/link,http://test.com/extra/link;) AS
?s_new ?s ?p ?o
WHERE
{?s ?p ?o
filter (regex (str(?s), http://test.com/link;))
}
}
}
Best Regards,
Percy
2012/1/11 Hugh Williams hwilli...@openlinksw.com
Hi Percy,
In what way does it now work as the query itself runs on my
machine but doesn’t modify anything as I don’t have such data,
so are you getting and error or unexpected results are
occurring ? Please provide some output of what you are seeing
as not working ?
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. //
http://www.openlinksw.com/
10 Burlington Mall Road, Suite 265, Burlington MA 01803
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 Jan 2012, at 19:03, Percy Enrique Rivera Salas wrote:
Dear All,
The following MODIFY Statement doesn't work properly, I
think is because
the variable ?url and ?new_url is an IRI (not a Literal)
MODIFY http://test.com/
delete
{?s ?p ?url}
insert
{?s ?p ?new_url}
where
{
{
SELECT
?s ?p
bif:replace(str(?url),http://test.com/link,http://test.com/extra/link;)
AS ?new_url ?url
WHERE
{?s ?p ?url
filter (regex (str(?url), http://test.com/link;))
}
}
}
Any idea to workaround?
Best Regards,
Percy
--
Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't
need a complex
infrastructure or vast IT resources to deliver seamless,
secure access to
virtual desktops. With this all-in-one solution, easily
deploy virtual
desktops for less than the cost of PCs and save 60% on VDI
infrastructure
costs. Try it free!
http://p.sf.net/sfu/Citrix-VDIinabox___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
--
RSA(R) Conference 2012
Mar 27 - Feb 2
Save $400 by Jan. 27
Register now!
http://p.sf.net/sfu/rsa-sfdev2dev2
___ Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] sparul enabled only for a concrete network
Hi Sergio, Virtuoso provides an additional /sparql-auth endpoint requiring authentication using SQL, OAuth or WebID access for use as detailed at: http://docs.openlinksw.com/virtuoso/rdfsparql.html#sparqloauthendpointauth http://ods.openlinksw.com/wiki/ODS/OdsSPARQLAuth and would be the recommended method for enabling SPARUL access, which you can choose to expose externally or not but either way provides controlled access ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ 10 Burlington Mall Road, Suite 265, Burlington MA 01803 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 Jan 2012, at 09:40, Sergio Fernández wrote: Hi, is it possible to enable sparul support only for a range of ip addresses? For instance, providing a public endpoint, allow sparul requests only inside the intranet. Thanks in advance. Cheers, -- Sergio Fernández CTIC - Technological Center Parque Científico y Tecnológico de Gijón C/ Ada Byron, 39 Edificio Centros Tecnológicos 33203 Gijón - Asturias - Spain Tel.: +34 984 29 12 12 Fax: +34 984 39 06 12 E-mail: sergio.fernan...@fundacionctic.org http://www.fundacionctic.org Privacy Policy: http://www.fundacionctic.org/privacidad -- Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex infrastructure or vast IT resources to deliver seamless, secure access to virtual desktops. With this all-in-one solution, easily deploy virtual desktops for less than the cost of PCs and save 60% on VDI infrastructure costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users smime.p7s Description: S/MIME cryptographic signature
Re: [Virtuoso-users] MODIFY statement doesn't work properly
Hi Percy,
In what way does it now work as the query itself runs on my machine but doesn’t
modify anything as I don’t have such data, so are you getting and error or
unexpected results are occurring ? Please provide some output of what you are
seeing as not working ?
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
10 Burlington Mall Road, Suite 265, Burlington MA 01803
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 Jan 2012, at 19:03, Percy Enrique Rivera Salas wrote:
Dear All,
The following MODIFY Statement doesn't work properly, I think is because
the variable ?url and ?new_url is an IRI (not a Literal)
MODIFY http://test.com/
delete
{?s ?p ?url}
insert
{?s ?p ?new_url}
where
{
{
SELECT
?s ?p
bif:replace(str(?url),http://test.com/link,http://test.com/extra/link;) AS
?new_url ?url
WHERE
{?s ?p ?url
filter (regex (str(?url), http://test.com/link;))
}
}
}
Any idea to workaround?
Best Regards,
Percy
--
Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex
infrastructure or vast IT resources to deliver seamless, secure access to
virtual desktops. With this all-in-one solution, easily deploy virtual
desktops for less than the cost of PCs and save 60% on VDI infrastructure
costs. Try it free!
http://p.sf.net/sfu/Citrix-VDIinabox___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
smime.p7s
Description: S/MIME cryptographic signature
Re: [Virtuoso-users] server startup failure after crash
Hi Sharath, Sounds as if the database file is corrupt due to the unexpected killing of the sever or other. As per my previous suggestion do you now have a backup, online or manual that is being made at regular intervals that the database could be restored to ? I also note you are running the open source Virtuoso 6.1.3 release and would recommend upgrading to the latest 6.1.4 release available on source forge ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ 10 Burlington Mall Road, Suite 265, Burlington MA 01803 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 10 Jan 2012, at 03:10, Sharath Jagannath wrote: 03:01:55 It is impossible to have a database file /mnt/gluster/staging-virtuoso.ec2.xen.io/software/6_1_3_install_dir/var/lib/virtuoso/db/virtuoso.db with a length not multiple of 2MB. Hey Hugh, This issue is surfacing again. Virtuoso server was killed accidentally. I tried to recover the database using the recovery procedure mentioned here: http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#backup #./virtuoso-t -b . . . Recovery still fails with the debug message: 3:01:40 uses parts of OpenSSL, PCRE, Html Tidy 03:01:55 Database version 3126 03:01:55 It is impossible to have a database file ../6_1_3_install_dir/var/lib/virtuoso/db/virtuoso.db with a length not multiple of 2MB. 03:01:55 The process must have last terminated while growing the file. 03:01:55 Please contact OpenLink Customer Support 03:01:55 Server exiting Is there anything else I should be doing to recover the data. I do not want to re-load all of the billion triples :( again. Thanks, Sharath On Fri, Dec 9, 2011 at 10:58 AM, Sharath Jagannath shotsonclo...@gmail.com wrote: Thanks Hugh. I did not have the back up yet. I should have one now. Good to bump into this crash issue early in the game. I just started to test the open virtuoso to make sure it meets my requirements. So the data corrupted was more of a test data than anything but I was kind of surprised that the crash corrupted the db. Cheers, Sharath On Thu, Dec 8, 2011 at 5:38 PM, Hugh Williams hwilli...@openlinksw.com wrote: Hi Sharath, The error indicates the database file is corrupt probably due to the database file size being expanded at the time of the crash. Do you maintain backup sets it can be recovered from ? The following documentation details how to create backups and also how you can attempt to recover a corrupt database: http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#backup Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ 10 Burlington Mall Road, Suite 265, Burlington MA 01803 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 8 Dec 2011, at 20:41, Sharath Jagannath wrote: Hey, I am using open-virtuoso-6.1.3. Have it configured, installed and was running on ubuntu box. open virtuoso server crashed due to some manual errors and I tried to restart it using virtuoso-t -f. I get the following error messages and the server crashes. 20:01:01 Database version 3126 20:01:01 It is impossible to have a database file /mnt/gluster/staging-virtuoso.ec2.xen.io/software/6_1_3_install_dir/var/lib/virtuoso/db/virtuoso.db with a length not multiple of 2MB. 20:01:01 The process must have last terminated while growing the file. 20:01:01 Please contact OpenLink Customer Support 20:01:01 Server exiting I did see couple of questions in the forum regarding this issue but I did not see a solution to this problem. How am I supposed to restart the server and recover the corrupted data from the crash. Thanks, Sharath -- Cloud Services Checklist: Pricing and Packaging Optimization This white paper is intended to serve as a reference, checklist and point of discussion for anyone considering optimizing the pricing and packaging model of a cloud services business. Read Now! http://www.accelacomm.com/jaw/sfnl/114/51491232/___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users smime.p7s Description: S/MIME
Re: [Virtuoso-users] GROUP_CONCAT in VOS 6.1.3
Hi Percy, You will need to updated to the latest Virtuoso 6.1.4 release for support for the GROUP_CONCAT() function as this is the release it was added to, which can be downloaded from: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VOSDownload What prevents you from upgrading to the latest release, as the only other option would be for you to attempt a back port which would probably be more work ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ 10 Burlington Mall Road, Suite 265, Burlington MA 01803 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 2 Jan 2012, at 17:33, Percy Enrique Rivera Salas wrote: All, I would like to use the GROUP_CONCAT function in the VOS (Version 06.01.312) but the procedure seems to be missed any idea how to resolve, without install the new VOS version? Thanks in advance Best Regards, Percy -- Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join http://p.sf.net/sfu/intel-appdev___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users smime.p7s Description: S/MIME cryptographic signature
Re: [Virtuoso-users] OWL in Virtuoso
Hi Louis, Assuming your OWL data is in standard N3, Turtle, RDF/XML or other form, then you can either load it from a file location on the file system or from a URI using one of the following Virtuoso graph data insertion methods: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtRDFInsert Once loaded you can then query the created graph or create rule set etc for inference and reasoning as detailed at: http://docs.openlinksw.com/virtuoso/rdfsparqlrule.html as I assume you would next want to do ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ 10 Burlington Mall Road, Suite 265, Burlington MA 01803 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 23 Dec 2011, at 11:00, Luis Criado Fernández wrote: Hi all How to upload OWL data in Virtuoso? It is supported? Could anyone help me? Thanks, Luis -- -- -- -- -- -- -- -- -- -- -- -- -- -- Dr. Luis Criado http://luis.criado.org/ twitter: http://twitter.com/lcriadof vissem (semantic search engines): http://vissem.criado.org/ Sw2sws tool: http://sw2sws.sourceforge.net/index.html -- Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join http://p.sf.net/sfu/intel-appdev___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users smime.p7s Description: S/MIME cryptographic signature
Re: [Virtuoso-users] server startup failure after crash
Hi Sharath, The error indicates the database file is corrupt probably due to the database file size being expanded at the time of the crash. Do you maintain backup sets it can be recovered from ? The following documentation details how to create backups and also how you can attempt to recover a corrupt database: http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#backup Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ 10 Burlington Mall Road, Suite 265, Burlington MA 01803 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 8 Dec 2011, at 20:41, Sharath Jagannath wrote: Hey, I am using open-virtuoso-6.1.3. Have it configured, installed and was running on ubuntu box. open virtuoso server crashed due to some manual errors and I tried to restart it using virtuoso-t -f. I get the following error messages and the server crashes. 20:01:01 Database version 3126 20:01:01 It is impossible to have a database file /mnt/gluster/staging-virtuoso.ec2.xen.io/software/6_1_3_install_dir/var/lib/virtuoso/db/virtuoso.db with a length not multiple of 2MB. 20:01:01 The process must have last terminated while growing the file. 20:01:01 Please contact OpenLink Customer Support 20:01:01 Server exiting I did see couple of questions in the forum regarding this issue but I did not see a solution to this problem. How am I supposed to restart the server and recover the corrupted data from the crash. Thanks, Sharath -- Cloud Services Checklist: Pricing and Packaging Optimization This white paper is intended to serve as a reference, checklist and point of discussion for anyone considering optimizing the pricing and packaging model of a cloud services business. Read Now! http://www.accelacomm.com/jaw/sfnl/114/51491232/___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users smime.p7s Description: S/MIME cryptographic signature
Re: [Virtuoso-users] Which version of Jena goes with VOS's Jena Provider?
Hi Tim, The Virtuoso Jena Provider (open source or commercial) is expected to work with any Jena version from 2.5.5 or above as indicated at: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtJenaProvider I certainly have tested with Jena 2.6.3 most recently. Are you able to get the example program provided in the documentation above to work at least to we have a common reference to compare with ? Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ 10 Burlington Mall Road, Suite 265, Burlington MA 01803 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 6 Dec 2011, at 17:57, Tim McCormack wrote: I'm trying to convert a program from Jena's TDB store to using the Virtuoso (Open Source) Provider for Jena, and I'm getting AbstractMethodError when I try to use the API. It looks like Provider is expecting a different version of Jena than the one I have, which is 2.6.4. This also happens if I downgrade to Jena 2.6.2 (and adjust my use of Jena accordingly). For reference: virtuoso.jena.driver.Version.main(null) = OpenLink Virtuoso(TM) Provider for Jena(TM) Version 2.6.2 [Build 1.5] jena.version.main(null) = VERSION: 2.6.2 From this, I infer that the Provider's version is not actually tied to Jena's version and I'm just seeing some coincidental numbers. I'm going to try to rebuild Provider from source, linked against latest Jena, but until then... what versions of Provider go with what versions of Jena? I can't find documentation on this anywhere. Thanks, - Tim McCormack -- Cloud Services Checklist: Pricing and Packaging Optimization This white paper is intended to serve as a reference, checklist and point of discussion for anyone considering optimizing the pricing and packaging model of a cloud services business. Read Now! http://www.accelacomm.com/jaw/sfnl/114/51491232/ ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users smime.p7s Description: S/MIME cryptographic signature
Re: [Virtuoso-users] RDFZZ Error DB.DBA.SPARQL_REXEC returned unsupported Content-Type 'application/sparql-results+xml'
Hi Jon,
What is the version of the Virtuoso Server you are attempting to run your query
against as the query you provide runs successfully for me, returning one row,
against one of our demo server:
http://demo.openlinksw.com/sparql?default-graph-uri=query=PREFIX+foaf%3A+%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0D%0APREFIX+skos%3A%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E%0D%0ASELECT+%3Fs%0D%0AWHERE+%7B%0D%0ASERVICE+%3Chttp%3A%2F%2Fpoolparty.reegle.info%2FPoolParty%2Fsparql%2Fglossary%3E%7B%0D%0A+%3Fs+foaf%3Apage+%3Chttp%3A%2F%2Fen.wikipedia.org%2Fwiki%2FFuel_cell%3E+.%0D%0A+%3Fs+skos%3Adefinition+%3Fv+.%0D%0A%7D%0D%0A%7Dshould-sponge=format=text%2FhtmlCXML_redir_for_subjs=121CXML_redir_for_hrefs=timeout=0debug=on
Short URL:
http://tinyurl.com/c26ovv6
So I assume you are running a Virtuoso version before full SPARQL-FED support
was available. I would recommend you upgrade to the latest 6.1.4 open source
release available from:
http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VOSDownload
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 1 Dec 2011, at 15:22, Weers, Jon wrote:
Hey Kingsley,
Thanks for responding. Yes, this an attempt to access Reegle's PoolParty
endpoint from the OpenEI Virtuoso endpoint.
Here is the query in question:
PREFIX foaf: http://xmlns.com/foaf/0.1/
PREFIX skos:http://www.w3.org/2004/02/skos/core#
SELECT ?s
WHERE {
SERVICE http://poolparty.reegle.info/PoolParty/sparql/glossary{
?s foaf:page http://en.wikipedia.org/wiki/Fuel_cell .
?s skos:definition ?v .
}
}
Here's an almost identical query to fetch the similar information from
DBPedia, this one works fine:
PREFIX dbpedia-owl: http://dbpedia.org/ontology/
PREFIX foaf: http://xmlns.com/foaf/0.1/
SELECT ?v
WHERE {
SERVICE http://dbpedia.org/sparql {
?s dbpedia-owl:abstract ?v .
?s foaf:page http://en.wikipedia.org/wiki/Fuel_cell .
}FILTER (lang(?v)=en)
}
Much thanks!
Jon
On 11/30/11 11:18 AM, Kingsley Idehen kide...@openlinksw.com wrote:
On 11/30/11 11:49 AM, Weers, Jon wrote:
Hi all,
Hoping you can help me out with something. I'm running a sparql query
against an external PoolParty server from a Virtuoso sparql endpoint and
am getting the following error:
RDFZZ Error
DB.DBA.SPARQL_REXEC('http://poolparty.reegle.info/PoolParty/sparql/glossa
ry', ...) returned unsupported Content-Type
'application/sparql-results+xml'
As far as I can tell, Virtuoso should support this content type.
Also, the query works when run from non-virtuoso sparql endpoints, so I
don't think anything's wrong there.
Any insight would be greatly appreciated.
Thanks!
Jon
-
-
All the data continuously generated in your IT infrastructure
contains a definitive record of customers, application performance,
security threats, fraudulent activity, and more. Splunk takes this
data and makes sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Jon,
Could have the actual query? I assume this is the OpenEI endpoint?
--
Regards,
Kingsley Idehen
Founder CEO
OpenLink Software
Company Web: http://www.openlinksw.com
Personal Weblog: http://www.openlinksw.com/blog/~kidehen
Twitter/Identi.ca handle: @kidehen
Google+ Profile: https://plus.google.com/112399767740508618350/about
LinkedIn Profile: http://www.linkedin.com/in/kidehen
--
All the data continuously generated in your IT infrastructure
contains a definitive record of customers, application performance,
security threats, fraudulent activity, and more. Splunk takes this
data and makes sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
smime.p7s
Description: S/MIME cryptographic signature
Re: [Virtuoso-users] file_to_string and dba privileges
Hi You can wrap the function(s) that require DBA privileges in Virtuoso into a store procedure which is then granted DBA privileges to allow it to run with such privileges but can be called by a none DBA user ... Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 28 Nov 2011, at 11:32, bmillemathias@orange.com wrote: Hello, While looking to a way to dump data from the database to disk, I used the function file_to_string but it requires DBA permissions; due to that I can't use that function in script to automate export in production environment, as it is unsafe to grant DBA permission to any user in the wild. Is there a way to circumvent this, by using another function ? Why does it require DBA permission and not a file permission as it exist in a SGDB like mysql ? Thanks _ Ce message et ses pieces jointes peuvent contenir des informations confidentielles ou privilegiees et ne doivent donc pas etre diffuses, exploites ou copies sans autorisation. Si vous avez recu ce message par erreur, veuillez le signaler a l'expediteur et le detruire ainsi que les pieces jointes. Les messages electroniques etant susceptibles d'alteration, France Telecom - Orange decline toute responsabilite si ce message a ete altere, deforme ou falsifie. Merci This message and its attachments may contain confidential or privileged information that may be protected by law; they should not be distributed, used or copied without authorization. If you have received this email in error, please notify the sender and delete this message and its attachments. As emails may be altered, France Telecom - Orange shall not be liable if this message was modified, changed or falsified. Thank you. -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-novd2d ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users smime.p7s Description: S/MIME cryptographic signature
Re: [Virtuoso-users] Rewrite Sparql endpoint
Hi Sachit, You probably need to set the URIQA “DefaultHost” parameter in the Virtuoso configuration INI file to the hostname you want to be used in the rewrite rules as detailed at: http://docs.openlinksw.com/virtuoso/uriqa.html#uriqaws http://docs.openlinksw.com/virtuoso/dbadm.html#ini_URIQA As the default setting is “localhost:8890” and the rewrite rules typically use the “URIQADefaultHost” macro function to read the value of the URIQA DefaultHOst param in the INI file for use in generating the hostname for the URL as indicated in the example at: http://docs.openlinksw.com/virtuoso/fn_urlrewrite_create_regex_rule.html#ex_urlrewrite_create_regex_rule I hope this resolves the problem for you ... Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 17 Nov 2011, at 06:04, Sachit Malhotra wrote: Hi Guys, Can anyone tell me how i can stop url rewrite from the sparql endpoint? For example, i have a namespace: http://localhost:8890/schemas/demo and my domain is http://demo.cbw.com.au, So when i query the sparql endpoint, it rewrites localhost to demo.cbw.com.au. Any help is much appreciated. Thanks. -- Sachit Malhotra | Clear Blue Water Pty Ltd +61 403565478 | smalho...@clearbluewater.com.au -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-novd2d___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users smime.p7s Description: S/MIME cryptographic signature
Re: [Virtuoso-users] Virtuoso Jena Provider and ARQ keywords
Hi Christian
Virtuoso does not support “NOT EXIST” but does have its own built in function:
FILTER (!bif:exists ((select (1) ...)))
See the following example on usage:
http://docs.openlinksw.com/virtuoso/rdfsparqlrule.html#rdfsparqlruleexamples6
LET is a Jena specific keyword not support in Virtuoso. The SPARQL 1.1 standard
provides an equivalent called “BIND” it appears which is not currently
supported in Virtuoso but is scheduled for the next release.
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 12 Nov 2011, at 09:42, Christian Fuerber wrote:
Dear all,
I am having trouble using certain keywords of Jena ARQ to query virtuoso
over the Virtuoso Jena Provider.
In particular, my queries require the use of the keywords LET, NOT EXISTS,
and IRI.
For example I tried to execute the following Code:
VirtGraph set = new VirtGraph
(jdbc:virtuoso://localhost:/charset=UTF-8/log_enable=2, dba, dba);
Model model = new VirtModel(set);
String queryString =
SELECT ?s ?o ?now +
FROM http://localhost/mediawiki +
WHERE{ +
?s ?p ?o . +
LET(?now := true) +
};
Query query =
QueryFactory.create(queryString,Syntax.syntaxARQ);
QueryExecution vqe =
VirtuosoQueryExecutionFactory.create(query, model);
ResultSet results = vqe.execSelect();
System.out.print(ResultSetFormatter.asText(results));
Which returns the following error message:
Exception in thread main com.hp.hpl.jena.shared.JenaException: Can not
create ResultSet.:virtuoso.jdbc3.VirtuosoException: SQ074: Line 12: SP030:
SPARQL compiler, line 10: syntax error at 'LET' before '('
at virtuoso.jena.driver.VirtuosoQueryExecution.execSelect(Unknown
Source)
at VirtuosoSPARQLExample1.main(VirtuosoSPARQLExample1.java:73)
When I use QueryExecutionFactory instead of VirtuosoQueryExecutionFactory I
get the following error message:
Exception in thread main com.hp.hpl.jena.shared.JenaException: Can not
create QueryIterator.:virtuoso.jdbc3.VirtuosoException: SQ074: Line 12:
SP030: SPARQL compiler, line 10: syntax error at 'LET' before '('
at virtuoso.jena.driver.VirtuosoQueryEngine.eval(Unknown Source)
at
com.hp.hpl.jena.sparql.engine.QueryEngineBase.evaluate(QueryEngineBase.java:
124)
at
com.hp.hpl.jena.sparql.engine.QueryEngineBase.createPlan(QueryEngineBase.jav
a:98)
at
com.hp.hpl.jena.sparql.engine.QueryEngineBase.getPlan(QueryEngineBase.java:8
6)
at
virtuoso.jena.driver.VirtuosoQueryEngine$VirtQueryEngineFactory.create(Unkno
wn Source)
at
com.hp.hpl.jena.sparql.engine.QueryExecutionBase.getPlan(QueryExecutionBase.
java:266)
at
com.hp.hpl.jena.sparql.engine.QueryExecutionBase.startQueryIterator(QueryExe
cutionBase.java:243)
at
com.hp.hpl.jena.sparql.engine.QueryExecutionBase.execResultSet(QueryExecutio
nBase.java:248)
at
com.hp.hpl.jena.sparql.engine.QueryExecutionBase.execSelect(QueryExecutionBa
se.java:94)
at VirtuosoSPARQLExample1.main(VirtuosoSPARQLExample1.java:73)
Simple queries without the use of Jena ARQ specific keywords work fine!
I am using Virtuoso Open Source 6.1.4 and Jena 2.6.2 with ARQ 2.8.3. The
virt_jena.jar is for Jena 2.6.2 [Build 1.5].
Thank you for any help!
Christian
--
Dipl.-Kfm. Christian Fürber
Professur für Allgemeine BWL, insbesondere E-Business
e-business web science research group
Universität der Bundeswehr München
e-mail: c.fuer...@unibw.de
www: http://www.unibw.de/ebusiness/
skype: c.fuerber
twitter: cfuerber
--
RSA(R) Conference 2012
Save $700 by Nov 18
Register now
http://p.sf.net/sfu/rsa-sfdev2dev1
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
smime.p7s
Description: S/MIME cryptographic signature
Re: [Virtuoso-users] Exception Violating unique index RDF_QUAD_POGS
Hi Roberto, Yes, you can remove these as there is nothing to commit ... Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 11 Nov 2011, at 15:27, Roberto García wrote: No, I don't have transactions turned off. Should I do so and remove the begin() and commit() calls from my code then? Roberto García http://rhizomik.net/~roberto 2011/11/11 Hugh Williams hwilli...@openlinksw.com: Hi Roberto, Do you have transactions turned of when performing this bulk load operation, using the Virtuoso “log_enable” function as SPARUL operations are no transactional as detailed at: http://docs.openlinksw.com/virtuoso/rdfperformancetuning.html#rdfperfsparul http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtTipsAndTricksGuideDeleteLargeGraphs http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtTipsAndTricksGuideTransactionLogControl Hence the transaction errors you are encountering ... Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 11 Nov 2011, at 11:25, Roberto García wrote: Dear all, I've started testing version 6.1.4 but I've having the same problems with transactions when doing a bulk update. Concretely I get the following exception: com.hp.hpl.jena.shared.JenaException: Couldn't create transaction:com.hp.hpl.jena.shared.JenaException: rethrew: java.sql.BatchUpdateException: SR175: Uniqueness violation : Violating unique index RDF_QUAD_POGS on table DB.DBA.RDF_QUAD. Transaction killed. This is the code I use for the upload: VirtGraph graph = new VirtGraph (DATA_URI, DB_URL, DB_USER, DB_PASSWD); ... graph.getTransactionHandler().begin(); graph.getBulkUpdateHandler().add(jenaModel.getModel().getGraph()); graph.getTransactionHandler().commit(); ... It seems to work well at the beginning but as I'm trying to load a quite big dataset (I'm regenerating the Semantic XBRL dataset) at some point it starts throwing this exception for most of the attempts to load an RDF model. Best, Roberto García http://rhizomik.net/~roberto -- RSA(R) Conference 2012 Save $700 by Nov 18 Register now http://p.sf.net/sfu/rsa-sfdev2dev1 ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users -- RSA(R) Conference 2012 Save $700 by Nov 18 Register now http://p.sf.net/sfu/rsa-sfdev2dev1 ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users smime.p7s Description: S/MIME cryptographic signature
Re: [Virtuoso-users] VOS 6.2 release ? VOS 6.1.3 backport for Debian Squeeze
Hi Cédric, 6.2 is the Virtuoso commercial release number which maps or is equivalent to the 6.1.3 open source release number, both made in March 2011 . The following page provide details on building the latest Virtuoso open source archive as debian, ubuntu and other packages should you want the current latest 6.1.3 in this format: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VOSBuild#Specific%20Linux%20Distributions Note open source 6.1.4 is due for release any day now also … Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 21 Oct 2011, at 09:37, Cédric Delfosse wrote: Hello, looks like Virtuoso OpenSource 6.2 has not been released. Is there an ETA for this ? VOS 6.1.2 Debian packages are available for Squeeze. Did someone already try to backport the 6.1.3 version available in Debian Sid for Squeeze ? Thanks a lot. Regards, Cédric -- The demand for IT networking professionals continues to grow, and the demand for specialized networking skills is growing even more rapidly. Take a complimentary Learning@Cisco Self-Assessment and learn about Cisco certifications, training, and career opportunities. http://p.sf.net/sfu/cisco-dev2dev ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] viewing components of a soap_client call
Hi Peter,
The error indicates the definition of
http://target_web_service/schema/XmlDefinition accepts only one element in an
array . Can you provide a more detailed code sample for analysis such that we
can determine the source of the problem as the information provided below is
not sufficient ?
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 18 Oct 2011, at 02:15, Peter Secomb wrote:
Hi everyone,
I have a soap_client call to a web service with the following structure:
soap_response := soap_client(
url='http://target_url_path',
operation=web_service_function,
target_namespace='http://target_namespace',
ticket='file_path/file.pem', auth_type='none',
parameters=vector(vector('param0,''http://target_web_service_function'',
soap_box_structure(...,soap_box_structure(..., soap_box_structure( some
value that errors) )),
debug=1,
style=1)
I have two variations on the call. The first call to the web service works
perfectly. The second call uses a different parameter and has a slight
variation on the soap_box_structure component (it has one additional
soap_box_structure nested) that returns the following error:
(3, '22023' 'SV039: An array of type
\'http://target_web_service/schema/XmlDefinition\' with min=1 and max=1
expected')
I've found the piece of code that calls the error but it is functionally
equivalent to the working version. The error states an array is expected and
implies it is not receiving that value. At the moment I cannot tell what it
is getting.
Is there anyway to extract the value that IS being received from the
soap_client call (eg a string, or something else, or even NULL)? The debug
option returns the partially built xml string then the error to stdout.
Many thanks,
Peter Secomb
http://clearbluewater.com.au/
--
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2d-oct___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] How to remove few or all triples from a graph?
Hi Jamshaid, The deletion of large graphs is something of a special case as detailed in the following tip: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtTipsAndTricksGuideDeleteLargeGraphs Or you can also use the “clear graph...” command as detailed at: http://docs.openlinksw.com/virtuoso/sparqlextensions.html#rdfsparulexamples10 The conductor should not be used for deleting large graphs at this point which is a known issue and scheduled to be fixed in the next release. Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 6 Oct 2011, at 07:38, Jamshaid Ashraf wrote: Hi, I am using open source virtuosos. How can I removed few or all triples of a Graph? I have tried to delete graph using drop graph command through isql but gives error has not been explicitly created before... I have also used the provided delete on Graphs List screen (conductor) but it works for the graph of small size (few hundred triples) but not for the graph with a million record. jamshaid -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Missing Procedure DB.DBA.RDF_LOAD_RDFXML and custom select output
Peter,
On 26 Sep 2011, at 07:53, Peter Secomb wrote:
Hi everyone,
When I run a sparql query eg: sparql select %s from http://mygraph where {
%s %p %o} the information returned for %s looks like:
http://my_host_server/about/id/mygraph/
Is it possible to return a specified tag instead? eg just: http://mygraph ?
[Hugh] I don’t understand what you are asking here, what is this “tag” mean’t
to represent ?
Secondly,
As part of investigating this I've bee looking through the RM_RDF_LOAD_RDFXML
procedure. This procedure appears to be a wrapper for RDF_LOAD_RDFXML
however I cannot find RDF_LOAD_RDFXML anywhere as it is not visible under the
DB procedures or anywhere else. Where might it be?
[Hugh] RDF_LOAD_RDFXML is a built in function (bif) in the Virtuoso binary thus
you cannot get a listing from the DB procedures in the schema, but you can see
the source code at ~/libsrc/Wi/rdf_core.c, as seen at:
http://www.assembla.com/code/virtuoso/git/nodes/libsrc/Wi/rdf_core.c?rev=4eb251af200c222371a7acfe1ee5436c9a834979
Regards,
Hugh
Many thanks,
Peter Secomb
http://clearbluewater.com.au/
--
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Problems materialising data using rdb2rdf trigger option within rdf views
Hi Mark, Is the table you are attempting to materialise as RDF triples a local or remote table ? The functions you reference below do seem to be undefined, I am trying to determine why they are not part of the current builds ... Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 21 Sep 2011, at 14:39, Mark James wrote: Hi, Using the Commercial 6.2 version of Virtuoso I've created and populated a table within the relational part of Virtuoso. I've then tried to materialise this data as triples using the rdb2rdf and sync options (checkboxes) found within the final screen of the rdf view creation wizard. Once the view is created I can query the triples if the from clause is included just like a normal rdf view however when querying the data without a from clause I get nothing back. I've further confirmed that it is not searchable via the fct tool. So I'm assuming the triples have not been materialised as intended. I've checked the source table and I can't see any triggers on it. I assumed triggers should have been created when the rdf view was created. Is this correct? I've read the document - http://docs.openlinksw.com/virtuoso/rdfperformancetuning.html#rdb2rdftriggers and have found I have neither DB.DBA.SPARQL_RDB2RDF_LIST_TABLES or DB.DBA.SPARQL_RDB2RDF_CODEGEN functions installed. Am I missing a package that needs to be installed prior to using this functionality within rdf views? cheers Mark -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] How to use sql log_enable() function
Hi Hoan,
You can set the option on a pre query level using the SPARQL DEFINE
sql:log-enable X pragma as detailed at:
http://docs.openlinksw.com/virtuoso/rdfsparql.html#rdfsparqlimplementatioptragmasmnotes
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 19 Sep 2011, at 22:38, Nguyen Mau Quoc Hoan wrote:
To advoid deadlock transaction, I was suggested to use function log-enable,
but I dont know how to integrate it into my sql string or hibernate query
string. For example:
Connection conn = getVirtuosoConneciton();
String query = select id +
from deri.dba.sensor;
Statement st = conn.createStatement();
boolean ok = st.execute(query);
java.sql.ResultSet rs = st.getResultSet();
while (rs.next()){
System.out.println(rs.getString(1));
}
conn.close();
Is there anybody know how to use this function?
Thanks so much.
--
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Loading uniprot
Hi Pierre,
The NumberOfBuffers parameter in the virtuoso.ini file is too low for a machine
with 16GB memory and loading large datasets like uniprot, please refer to the
following performance tuning guide document for recommended settings for best
performance with various typical memory sizes:
http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtRDFPerformanceTuning
Which for 16GB machine are:
NumberOfBuffers = 136
MaxDirtyBuffers = 100
You can also run multiple rdf_loader_run() client one per core for parallel
loading of data, with checkpointing turned off for the duration of the load and
then re-enabled with a script of the following form for a 4 core machine:
$more rdf_load.sh
isql dba dba exec=checkpoint_interval(-1);
isql dba dba exec=rdf_loader_run();
isql dba dba exec=rdf_loader_run();
isql dba dba exec=rdf_loader_run();
isql dba dba exec=rdf_loader_run();
wait
isql dba dba exec=checkpoint;”
isql dba dba exec=checkpoint_interval(120);
Let me know if this works for you ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 10 Sep 2011, at 15:13, Pierre-Yves Chibon wrote:
Dear all,
I am trying to load uniprot on a quadcore machine with 16Gb of ram and 2
hard-drives in raid 1.
I installed virtuoso opensource from the Fedora repository, I therefore
have the version virtuoso-opensource-6.1.3-1.fc14.x86_64.
I generated the ~/.odbc.ini file, then I load uniprot by:
$ isql-vt virtuoso dba dba
Connected to OpenLink Virtuoso
Driver: 06.01.3127 OpenLink Virtuoso ODBC Driver
OpenLink Interactive SQL (ODBC), version 0.9849b.
Type HELP; for help and EXIT; to exit.
SQL ld_dir ('/data/virtuoso/','uniprot.rdf','http://uniprot/');
Done. -- 3 msec.
SQL rdf_loader_run ();
So for 9h virtuoso seem stuck. The database file hasn't changed since
7h55. I cannot connect anymore to virtuoso using isql. I could not kill
virtuoso by ctrl+c on the terminal where I started it (the log says
Server received signal 2 but the server was never shutdown).
I killed -9 the pid of virtuoso, restarted it using +foreground again.
I loged in throught isql and ran:
SQL select * from DB.DBA.load_list;
Output is at: http://fpaste.org/wswj/
Logs are attached.
It is I think the third time I try to load uniprod and face this
problem. The max it ran was ~30h during which the memory was never full
but the cache was very high, the load went sometime a little bit high
but never enough to get the machine unresponsive.
Since my first trial I tried to change the configuration, but no
difference in the loading:
[database]
;MaxCheckpointRemap = 2000
MaxCheckpointRemap = 2
[TempDatabase]
;MaxCheckpointRemap = 2000
MaxCheckpointRemap = 2
[Parameters]
;NumberOfBuffers= 5000
NumberOfBuffers = 15000
;MaxDirtyBuffers= 3200
MaxDirtyBuffers = 7000
If you have suggestions or if I can help to debug this :)
Thanks for your help,
Pierre
virtuoso.log--
Malware Security Report: Protecting Your Business, Customers, and the
Bottom Line. Protect your business and customers by understanding the
threat from malware and how it can impact your online business.
http://www.accelacomm.com/jaw/sfnl/114/51427462/___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Virtuoso 6.1.3 on FreeBSD-9: conductor does not work
Hi Mathais,
What happens if you install the prebuilt conductor vad package at:
http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VOSDownload#Other%20Virtuoso-related%20Packages
Preferably into and empty database to start off with as this will provide if it
is a bad VAD package build from your local compilation on FreeBSD ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 1 Sep 2011, at 17:15, Mathias Picker wrote:
With a fresh install of virtuoso, most things seem to work (sparql
endpoint, isql), but opening http://localhost:8890/conductor/ gives:
Error HTCLI
HC001: Connection Error in HTTP Client
Nothing in the error log when I do this. Is there a way to increase the error
log verbosity? Then doc
states that ErrorLogLevel should stay at 7, is there a different way to
increase verbosity?
Starting with virtuoso-t +foreground +debug +configfile gives the same
log
Trying vad_install ('/usr/local/virtuoso/vad/conductor_dav.vad', 0); in isql
works (ends with SUCCESS)
The errorlog shows something on startup, which I do not understand (I'm new
with virtuoso)
Any ideas or tips on how to debug this welcome!
Cheers, Mathias
mp# uname -a
FreeBSD mp.virtual-earth.de 9.0-BETA2 FreeBSD 9.0-BETA2 #34: Tue Aug 30
19:56:28 CEST 2011
mathi...@mp.virtual-earth.de:/usr/obj/usr/src/sys/acer5553g amd64
mp# virtuoso-t +foreground +debug +configfile
/usr/local/virtuoso/db/virtuoso.ini
Thu Sep 01 2011
18:11:58 INFO: { Loading plugin 1: Type `plain', file `wikiv' in
`/usr/local/lib/virtuoso/hosting'
18:11:58 INFO: WikiV version 0.6 from OpenLink Software
18:11:58 INFO: Support functions for WikiV collaboration tool
18:11:58 INFO: SUCCESS plugin 1: loaded from
/usr/local/lib/virtuoso/hosting/wikiv.so }
18:11:58 INFO: { Loading plugin 2: Type `plain', file `mediawiki' in
`/usr/local/lib/virtuoso/hosting'
18:11:58 INFO: MediaWiki version 0.1 from OpenLink Software
18:11:58 INFO: Support functions for MediaWiki collaboration tool
18:11:58 INFO: SUCCESS plugin 2: loaded from
/usr/local/lib/virtuoso/hosting/mediawiki.so }
18:11:58 INFO: { Loading plugin 3: Type `plain', file `creolewiki' in
`/usr/local/lib/virtuoso/hosting'
18:11:58 INFO: CreoleWiki version 0.1 from OpenLink Software
18:11:58 INFO: Support functions for CreoleWiki collaboration tool
18:11:58 INFO: SUCCESS plugin 3: loaded from
/usr/local/lib/virtuoso/hosting/creolewiki.so }
18:11:58 INFO: OpenLink Virtuoso Universal Server
18:11:58 INFO: Version 06.01.3127-pthreads for FreeBSD as of Sep 1 2011
18:11:58 INFO: uses parts of OpenSSL, PCRE, Html Tidy
18:11:58 INFO: Database version 3126
18:11:58 INFO: SQL Optimizer enabled (max 1000 layouts)
18:12:00 INFO: Compiler unit is timed at 0.001084 msec
18:12:00 ERROR: Error compiling a server init statement : 37000: SQ074: Line
18: syntax error at '' -- create method
xmla_discover_keywords () returns any for xmla_discover
{
declare kwds, res any;
d...
18:12:01 ERROR: Error compiling a server init statement : 37000: SQ074: Line
78: syntax error at '%' before 's' -- create method vc_render () for
vspx_browse_button
{
if ( not self.vc_enabled)
return;
if (self
18:12:01 ERROR: Error compiling a server init statement : 37000: SQ074: Line
46: syntax error at '\' before ''\''' -- create method vc_render () for
vspx_return_button
{
if ( not self.vc_enabled)
return;
if (self.b...
18:12:01 ERROR: Error executing a server init statement : 22007: XM003: XML
parser detected an error:
ERROR : 37000 XM029: XPath interpreter, line 0: Invalid character at %
in . like ''%'' in attribute test of tag
http://www.w3.org/1999/XSL/Transform:when in line 453 of file
http://local.virt/vspx_expand
at line 453 column 38 of 'http://local.virt/vspx_expand'
xsl:when test=. like ''%''xsl:value-of select=. //xsl:when
^
-- ?xml version='1.0'?
!--
-
- $Id: vspx_expa
18:12:01 ERROR: Error executing a server init statement : 22007: XM003: XML
parser detected an error:
ERROR : 37000 XM029: XPath interpreter, line 0: Invalid character at %
in . like ''%'' in attribute test of tag
http://www.w3.org/1999/XSL/Transform:when in line 4647 of file
http://local.virt/vspx
at line 4647 column 34 of 'http://local.virt/vspx'
xsl:when test=. like ''%''xsl:value-of select=. //xsl:when
^
-- ?xml version='1.0'?
!DOCTYPE xsl:stylesheet [
18:12:01 INFO: Roll forward started
18:12:01 INFO: Roll forward complete
18:12:02 INFO: Checkpoint started
18:12:02 INFO: Checkpoint finished, log reused
18:12:02 INFO: HTTP/WebDAV server online at 8890
18:12:02 INFO: Server online at (pid 39262)
(here I'm calling http
Re: [Virtuoso-users] DB.DBA.TTLP_MT_LOCAL_FILE error
Hi Percy,
Try add specifying the partial location as “./dbpedia/foaf/file1.ttl” ie
prepend with “./“ to force it to check the current directory if “.” is not
already in your PATH environment variable
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 30 Aug 2011, at 15:54, Percy Enrique Rivera Salas wrote:
Hi everyone,
I tried to upload a file through DB.DBA.TTLP_MT_LOCAL_FILE but I got the
following error when I wrote the partial path
SQL DB.DBA.TTLP_MT_LOCAL_FILE
('dbpedia/foaf/file1.ttl','','http://graph1.com');
*** Error 42000: [Virtuoso Driver][Virtuoso Server]SR598: TURTLE parser has
failed to open file 'dbpedia/foaf/file1.ttl' for reading
at line 2 of Top-Level:
DB.DBA.TTLP_MT_LOCAL_FILE ('dbpedia/foaf/file1.ttl','','http://graph1.com')
but when I wrote the all path works perfectly
SQL DB.DBA.TTLP_MT_LOCAL_FILE
('/var/lib/virtuoso/db/dbpedia/foaf/file1.ttl','','http://graph1.com');
Done. -- 11773 msec.
I already added the DirsAllowed in the virtuoso.ini file.
Any Suggestions?
Best Regards,
Percy
Re: [Virtuoso-users] Detected stale lock
Hi Lars, Thanks for the note, which has been appended to the following error message document on the “virtuoso.lck” file: http://wikis.openlinksw.com/dataspace/owiki/wiki/VirtuosoWikiWeb/VirtuosoLCKFileExistsError Note also that this error would not occur with open source ( the mailing list you have posted to :)), as these start scripts are not part of the open source archives, only being available in with the commercial installers. Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 25 Aug 2011, at 09:33, Lars Marius Garshol wrote: I'm running Virtuoso locally on my Macbook and trying to start it gives me a dialog saying Detected stale lock. Virtuoso then refuses to start and that's it. I discovered that the following command: sudo rm /Applications/OpenLink Virtuoso/Virtuoso 6.2/database/virtuoso.lck solves the problem by deleting the lock file. Posting this since googling the problem gave absolutely no information whatever, and I figure others will run into this as well. --Lars M. http://www.garshol.priv.no/blog/ -- EMC VNX: the world's simplest storage, starting under $10K The only unified storage solution that offers unified management Up to 160% more powerful than alternatives and 25% more efficient. Guaranteed. http://p.sf.net/sfu/emc-vnx-dev2dev ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] dump_graphs() error
Hi Greg,
Was the data reloaded using this updated 6.1.3 binary or was the existing
database file used ie that was loaded with the 6.1.2 binary ? As I would
suggest reloading the data into a new empty database using the 6.1.3 binary,
then try to dump the graphs.
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 22 Aug 2011, at 22:10, Gregory Williams wrote:
On Aug 21, 2011, at 8:46 AM, Hugh Williams wrote:
Looking at the version 6.1.2 you report as being used and based on Ivan's
(who wrote these procedures) comment I would suggest you database be
upgraded to the latest 6.1.3 release to use these procedures. The latest
6.1.3 snapshot can be downloaded from:
ftp://download.openlinksw.com/support/vos/virtuoso-opensource-6-20110614.tar.gz
I tried moving over to a newer version (Version 6.1.3.3127-pthreads as of Aug
7 2011), and still get the error:
*** Error 22023: [Virtuoso Driver][Virtuoso Server]SR601: Argument 1 of
http_ttl_triple() should be an array of special format
at line 1 of Top-Level:
dump_graphs('/var/tmp/dump', 1000)
Any other thoughts?
thanks,
.greg
--
uberSVN's rich system and user administration capabilities and model
configuration take the hassle out of deploying and managing Subversion and
the tools developers use with it. Learn more about uberSVN and get a free
download at: http://p.sf.net/sfu/wandisco-dev2dev
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] dump_graphs() error
Hi Greg, True, bit of a catch 22 situation then ... What is the triple count in the Virtuoso Quad Store you are seeking to dump and how was this data loaded originally ? If the data cannot readily be reloaded from its original sources, then maybe a full database dump to log and restore (http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#vdbrecovery) into a 6.1.3 database may be performed, after which the rdf dump_graphs() can be attempted to see if this now works Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 23 Aug 2011, at 02:34, Gregory Williams wrote: On Aug 22, 2011, at 8:58 PM, Hugh Williams wrote: Hi Greg, Was the data reloaded using this updated 6.1.3 binary or was the existing database file used ie that was loaded with the 6.1.2 binary ? As I would suggest reloading the data into a new empty database using the 6.1.3 binary, then try to dump the graphs. Hugh, The existing database file was used. Reloading the data would be easier if I could dump it out of the existing database! :) thanks, .greg -- Get a FREE DOWNLOAD! and learn more about uberSVN rich system, user administration capabilities and model configuration. Take the hassle out of deploying and managing Subversion and the tools developers use with it. http://p.sf.net/sfu/wandisco-d2d-2 ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] dump_graphs() error
Hi Greg,
The error implies that there is a bad triple in one of the graphs being
dumped, can you please check the “virtuoso.log” file to see if any errors are
reported there. The Virtuoso trace_on() function can also being enabled to
write more detailed information to the log file that might highlight the error
as detailed at:
http://docs.openlinksw.com/virtuoso/fn_trace_on.html
are an graph files dumped to the /tmp/dump directory specified ?
Please also confirm the version of the Virtuoso server being used by running
the command:
virtuoso-t -?
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 20 Aug 2011, at 21:38, Gregory Williams wrote:
I've been trying to use the dump_graphs() function from
http://ods.openlinksw.com/wiki/main/Main/VirtDumpLoadRdfGraphs to dump the
RDF contents of my virtuoso database, and I've been getting the following
error:
[willig4@sam db]$ cat /tmp/dump.txt
dump_graphs('/tmp/dump', 1);
[willig4@sam db]$ /opt/virtuoso6/bin/isql greg /tmp/dump.txt
Connected to OpenLink Virtuoso
Driver: 06.01.3127 OpenLink Virtuoso ODBC Driver
*** Error 22023: [Virtuoso Driver][Virtuoso Server]SR601: Argument 1 of
http_ttl_triple() should be an array of special format
at line 1 of Command-Line-Load /tmp/dump.txt:
dump_graphs('/tmp/dump', 1)
Does anyone have any idea why I'm getting this error and how I can fix/avoid
it?
thanks,
.greg
--
Get a FREE DOWNLOAD! and learn more about uberSVN rich system,
user administration capabilities and model configuration. Take
the hassle out of deploying and managing Subversion and the
tools developers use with it. http://p.sf.net/sfu/wandisco-d2d-2
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] dump_graphs() error
Hi Greg,
Checking the log I see the following query appearing to result in the error:
20:37:25 COMP_2 SPARQL 128.113.106.176 Internal Compile text: sparqlprefix
vann: http://purl.org/vocab/vann/
SELECT distinct ?namespace ?prefix
WHERE {
GRAPH
http://logd.tw.rpi.edu/source/data-gov/dataset/3506/version/2010-Dec-17/conversion/enhancement/1/subset/sample
{
[] vann:preferredNamespacePrefix ?prefix;
vann:preferredNamespaceUri?namespace .
}
} order by ?namespace
20:37:25 ERRS_0 22023 SR601 Argument 1 of http_ttl_triple() should be an array
of special format
20:37:25 LTRS_1 greg 127.0.0.1 :59 Commit transact 0x214d7ce0 0
Looking at the version 6.1.2 you report as being used and based on Ivan's (who
wrote these procedures) comment I would suggest you database be upgraded to the
latest 6.1.3 release to use these procedures. The latest 6.1.3 snapshot can be
downloaded from:
ftp://download.openlinksw.com/support/vos/virtuoso-opensource-6-20110614.tar.gz
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 21 Aug 2011, at 01:51, Gregory Williams wrote:
Hugh,
Thanks for the response.
On Aug 20, 2011, at 8:02 PM, Hugh Williams wrote:
The error implies that there is a bad triple in one of the graphs being
dumped, can you please check the “virtuoso.log” file to see if any errors
are reported there. The Virtuoso trace_on() function can also being enabled
to write more detailed information to the log file that might highlight the
error as detailed at:
http://docs.openlinksw.com/virtuoso/fn_trace_on.html
I've attached a section of the virtuoso log during a run of the dump_graphs
function, but it looks to me like it gives no more information than isql gave.
are an graph files dumped to the /tmp/dump directory specified ?
Yes. It takes about 25 minutes for ~2M triples to be dumped before the error
occurs.
Please also confirm the version of the Virtuoso server being used by running
the command:
virtuoso-t -?
Version 6.1.2.3127-pthreads as of Jul 26 2010
thanks,
.greg
virtuoso.log.gz--
Get a FREE DOWNLOAD! and learn more about uberSVN rich system,
user administration capabilities and model configuration. Take
the hassle out of deploying and managing Subversion and the
tools developers use with it.
http://p.sf.net/sfu/wandisco-d2d-2___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Internal error: quad storage metadata are lost
Hi
This query runs fine for be using the 64bit Windows Virtuoso open source 6.1.3
build:
$ /opt/virtuoso/bin/isql opluswinbuild:1313
Connected to OpenLink Virtuoso
Driver: 06.01.3127 OpenLink Virtuoso ODBC Driver
OpenLink Interactive SQL (Virtuoso), version 0.9849b.
Type HELP; for help and EXIT; to exit.
SQL sparql PREFIX rdfs: http://www.w3.org/2000/01/rdf-schema# Select ?o
where {SERVICE http://www4.wiwiss.fu-berlin.de/factbook/sparql {?s
rdfs:label ?o }};
o
VARCHAR
___
Aruba
Antigua and Barbuda
United Arab Emirates
Afghanistan
Algeria
Azerbaijan
Albania
Armenia
Andorra
Angola
American Samoa
Argentina
Australia
Ashmore and Cartier Islands
Austria
Anguilla
Akrotiri
Antarctica
Bahrain
Barbados
Botswana
Bermuda
Belgium
Bahamas, The
Bangladesh
Belize
Bosnia and Herzegovina
Bolivia
Burma
Benin
Belarus
Solomon Islands
Navassa Island
Brazil
Bhutan
Bulgaria
Bouvet Island
Brunei
Burundi
Canada
Cambodia
Chad
Sri Lanka
Congo, Republic of the
Congo, Democratic Republic of the
China
Chile
Cayman Islands
Cocos (Keeling) Islands
Cameroon
Comoros
Colombia
Central African Republic
Cuba
Cape Verde
Cook Islands
Cyprus
Denmark
Djibouti
Dominica
Dominican Republic
Dhekelia
Ecuador
European Union
Egypt
Ireland
Equatorial Guinea
Estonia
Eritrea
El Salvador
Ethiopia
Czech Republic
Finland
Fiji
Falkland Islands (Islas Malvinas)
Micronesia, Federated States of
Faroe Islands
French Polynesia
France
French Southern and Antarctic Lands
Gambia, The
Gabon
Georgia
Ghana
Gibraltar
Grenada
Guernsey
Greenland
Germany
Guam
Greece
Guatemala
Guinea
Guyana
Gaza Strip
Haiti
Hong Kong
Heard Island and McDonald Islands
Honduras
Croatia
Hungary
Iceland
Indonesia
Isle of Man
India
British Indian Ocean Territory
Clipperton Island
Iran
Israel
Italy
Cote dIvoire
Iraq
Japan
Jersey
Jamaica
Jan Mayen
Jordan
Kenya
Kyrgyzstan
Korea, North
Kiribati
Korea, South
Christmas Island
Kuwait
Kazakhstan
Laos
Lebanon
Latvia
Lithuania
Liberia
Slovakia
Liechtenstein
Lesotho
Luxembourg
Libya
Madagascar
Macau
Moldova
Mayotte
Mongolia
Montserrat
Malawi
Montenegro
Macedonia
Mali
Monaco
Morocco
Mauritius
Mauritania
Malta
Oman
Maldives
Mexico
Malaysia
Mozambique
New Caledonia
Niue
Norfolk Island
Niger
Vanuatu
Nigeria
Netherlands
Norway
Nepal
Nauru
Suriname
Netherlands Antilles
Nicaragua
New Zealand
Southern Ocean
Paraguay
Pitcairn Islands
Peru
Paracel Islands
Spratly Islands
Pakistan
Poland
Panama
Portugal
Papua New Guinea
Palau
Guinea-Bissau
Qatar
Serbia
Marshall Islands
Romania
Philippines
Puerto Rico
Russia
Rwanda
Saudi Arabia
Saint Pierre and Miquelon
Saint Kitts and Nevis
Seychelles
South Africa
Senegal
Saint Helena
Slovenia
Sierra Leone
San Marino
Singapore
Spain
Saint Lucia
Sudan
Svalbard
Sweden
South Georgia and the South Sandwich Islands
Syria
Switzerland
Trinidad and Tobago
Thailand
Tajikistan
Turks and Caicos Islands
Tokelau
Tonga
Togo
Sao Tome and Principe
Tunisia
East Timor
Turkey
Tuvalu
Taiwan
Turkmenistan
Tanzania
Uganda
United Kingdom
United States Pacific Island Wildlife Refuges
Ukraine
United States
Burkina Faso
Uruguay
Uzbekistan
Saint Vincent and the Grenadines
Venezuela
British Virgin Islands
Vietnam
Virgin Islands
Holy See (Vatican City)
Namibia
West Bank
Wallis and Futuna
Western Sahara
Wake Island
Samoa
Swaziland
Indian Ocean
Arctic Ocean
World
Yemen
Zambia
Atlantic Ocean
Zimbabwe
Pacific Ocean
Iles Eparses
254 Rows. -- 7117 msec.
SQL
I would suggest running the RDF_AUDIT_METADATA() function which attempts to
check and fix any metadata corruption in the QUAD Store. If that fails I would
suggest you try starting with a new empty database and run the federated query
to see if the error still occurs.
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 20 Aug 2011, at 15:43, Priyam Maheshwari wrote:
Hi,
When i try to execute:
sparql PREFIX rdfs: http://www.w3.org/2000/01/rdf-schema# Select ?o where
{SERVICE http://www4.wiwiss.fu-berlin.de/factbook/sparql {?s rdfs:label ?o
}}
The above query gives me following error
SQLState: 37000
Message: SQ074: Line 1: SP031: SPARQL compiler: Internal error: quad storage
metadata are lost
sparql PREFIX rdfs: http://www.w3.org/2000/01/rdf-schema# Select ?o where
{SERVICE http://www4.wiwiss.fu-berlin.de/factbook/sparql {?s rdfs:label ?o
}}
Please find attached my configuration and log file.
I am trying to run this query from iSQL
virtuoso.logvirtuoso.ini--
Get a FREE DOWNLOAD! and learn more about uberSVN rich system,
user administration capabilities and model configuration. Take
the hassle out of deploying and managing Subversion and the
tools developers use with it.
http://p.sf.net/sfu/wandisco-d2d-2___
Re: [Virtuoso-users] Virtuoso-Jena provider problem
Hi Babis, We have an Inference Graph example (VirtuosoSPARQLExample13) in the Jena documentation at http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtJenaProvider?#Testing , does this run for you ? Also please confirm the versions of the components being used with the following commands: virtuoso-t -? java -jar virt_jena.jar java -jar virtjdbc3.jar Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 18 Aug 2011, at 11:22, Babis Doulaverakis wrote: Hello, I am trying to use the Virtuoso-Jena provider to make an Inference Graph in Jena using Virtuoso as a RDF backend but an exception is thrown. The code I use is: VirtGraph schemaGraph = new VirtGraph (http://MyGraph/schema#,jdbc:virtuoso://localhost:/charset=UTF-8/log_enable=2;, dba, dba); VirtGraph dataGraph = new VirtGraph (http://MyGraph/data#,jdbc:virtuoso://localhost:/charset=UTF-8/log_enable=2;, dba, dba); Model dataModel = new VirtModel(dataGraph); Model schemaModel = new VirtModel(schemaGraph); Reasoner reasoner = ReasonerRegistry.getOWLReasoner(); reasoner = reasoner.bindSchema(schemaModel); InfModel infmodel = ModelFactory.createInfModel(reasoner, dataModel); IteratorStatement list = infmodel.listStatements(); The exception I get is Exception in thread main virtuoso.jdbc3.VirtuosoException: Tag 1 not defined. when the listStatements() method is called. Is there a way to fix this problem? Thanks, Babis -- Get a FREE DOWNLOAD! and learn more about uberSVN rich system, user administration capabilities and model configuration. Take the hassle out of deploying and managing Subversion and the tools developers use with it. http://p.sf.net/sfu/wandisco-d2d-2___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Virtuoso-Jena provider problem
Hi Babis, Looking at the version of your Virtuoso Server 06.02,3128 from Sept 2010, it would appear you are a commercial license holder/user for which the latest available builds are 06.02.3129, 1.4 3.57 from March 2011, so I would recommend you upgrade your components to this latest version, which is available from http://download.openlinksw.com/virtwiz and is a free upgrade ... Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 18 Aug 2011, at 17:00, Babis Doulaverakis wrote: Hi Hugh, I have the following versions: Virtuoso: 06.02.3128 virt_jena: 2.6.2 [Build 1.2] virtjdbc3: 3.x [Build 3.56] Are there any newer version of virt_jena and virtjdbc3?. With the versions I have I am not able to use virtjdbc4. The Inference Graph example works. Actually I was able to run the code I posted earlier by using other graphs in Virtuoso to get data from. I don't know why the previous graphs caused errors. Could it be because of possible inconsistencies in the ontology definition? What I found out later was that the inclusion of dataGraph in the Inference Model caused the exception to be thrown. Thanks for your answer. Best regards, Babis From: Hugh Williams hwilli...@openlinksw.com To: Babis Doulaverakis doula...@yahoo.gr Cc: virtuoso-users@lists.sourceforge.net virtuoso-users@lists.sourceforge.net Sent: Thursday, August 18, 2011 3:15 PM Subject: Re: [Virtuoso-users] Virtuoso-Jena provider problem Hi Babis, We have an Inference Graph example (VirtuosoSPARQLExample13) in the Jena documentation at http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtJenaProvider?#Testing , does this run for you ? Also please confirm the versions of the components being used with the following commands: virtuoso-t -? java -jar virt_jena.jar java -jar virtjdbc3.jar Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 18 Aug 2011, at 11:22, Babis Doulaverakis wrote: Hello, I am trying to use the Virtuoso-Jena provider to make an Inference Graph in Jena using Virtuoso as a RDF backend but an exception is thrown. The code I use is: VirtGraph schemaGraph = new VirtGraph (http://MyGraph/schema#,jdbc:virtuoso://localhost:/charset=UTF-8/log_enable=2;, dba, dba); VirtGraph dataGraph = new VirtGraph (http://MyGraph/data#,jdbc:virtuoso://localhost:/charset=UTF-8/log_enable=2;, dba, dba); Model dataModel = new VirtModel(dataGraph); Model schemaModel = new VirtModel(schemaGraph); Reasoner reasoner = ReasonerRegistry.getOWLReasoner(); reasoner = reasoner.bindSchema(schemaModel); InfModel infmodel = ModelFactory.createInfModel(reasoner, dataModel); IteratorStatement list = infmodel.listStatements(); The exception I get is Exception in thread main virtuoso.jdbc3.VirtuosoException: Tag 1 not defined. when the listStatements() method is called. Is there a way to fix this problem? Thanks, Babis -- Get a FREE DOWNLOAD! and learn more about uberSVN rich system, user administration capabilities and model configuration. Take the hassle out of deploying and managing Subversion and the tools developers use with it. http://p.sf.net/sfu/wandisco-d2d-2___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Virtuoso ADO.Net provider stopped working with strange TypeLoadException error?
Hi Rob, This is strange, to be clear do you build the OpenLink.Data.Virtuoso.dll ADO.Net provider yourself or use the one provided in the open source pre-built Windows binaries we provide which are currently at version 06.02.3128.1 and can be obtained from : http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VOSDownload#Pre-built%20binaries%20for%20Windows You specifically mentioned “preferably built on Windows”, why ? Does the dotNetRDF use Mono or Windows .Net runtime, from the error you report it would appear to be Mono in which case does the OS it was compiled on matter ? Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 16 Aug 2011, at 15:54, Rob Vesse wrote: Hi all I've encountered a bizarre error with the Virtuoso ADO.Net provider that I am at a loss to explain. The provider version is 6.2.3128.1 and it is the latest version of OpenLink.Data.Virtuoso.dll AFAIK When I try and create a VirtuosoConnection object I get the following error: System.TypeLoadException occurred Message=Could not load type 'Mono.Runtime' from assembly 'mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'. Source=mscorlib TypeName=Mono.Runtime StackTrace: at System.Reflection.Assembly._GetType(String name, Boolean throwOnError, Boolean ignoreCase) at System.Reflection.Assembly.GetType(String name, Boolean throwOnError) InnerException: Until today I had never encountered this error before and I have not recompiled or otherwise modified the version of the provider I have been using for the last few months without issue. The only changes I have made in my code recently was to split the Virtuoso support into a separate DLL which has all the same core .Net references and this had previously been working fine until today. Anyone have any ideas on why this error may suddenly have cropped up? Any chance you could send me an up to date snapshot of the provider (preferably built on Windows) so that I can check that it isn't my version that is at fault? Regards, Rob Vesse -- uberSVN's rich system and user administration capabilities and model configuration take the hassle out of deploying and managing Subversion and the tools developers use with it. Learn more about uberSVN and get a free download at: http://p.sf.net/sfu/wandisco-dev2dev ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] max length of temp row error
Hi Nan,
I can see the error against your endpoint, but cannot access any other services
ie conductor, isql etc to analyse the query. If you cannot provide datasets for
a test case, we would then also need to have the query execution plan using
the virtuoso explain() function and the sparql_to_sql_text() function output to
enable some for of analysis to be performed:
http://docs.openlinksw.com/virtuoso/fn_explain.html
http://docs.openlinksw.com/virtuoso/fn_sparql_to_sql_text.html
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 4 Aug 2011, at 17:48, DENG Nan wrote:
The query is as following using the endpoint
http://semantics.eurecom.fr/sparql
select ?event (sql:SAMPLE(?thumb) as ?thumb) ?title ?description ?lat ?lon
?beginTime ?endTime
where {
?event a lode:Event.
?event dc:title ?title.
?event dc:description ?description.
?event lode:inSpace ?space.
?space geo:lat ?lat.
?space geo:long ?lon.
?event lode:atTime ?time.
?time time:hasBeginning ?beginning.
?time time:hasEnd ?end.
?beginning time:inXSDDateTime ?beginTime.
?end time:inXSDDateTime ?endTime.
?photo lode:illustrate ?event.
?photo foaf:thumbnail ?thumbnail.
?thumbnail ma:locator ?thumb.
FILTER regex(?thumb, m.jpg)
}
thanks
Nan
2011/8/4 Hugh Williams hwilli...@openlinksw.com
Hi Nan,
The are no specific configuration params to work around this from occurrence
of this error seen before, although we are looking into it. Please provide
the query and ideally some test data to recreate and we may be able to advise
on re-structuring of the query to work around this.
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 4 Aug 2011, at 15:54, DENG Nan wrote:
Hi,
I run a select query and I get an error called:
Virtuoso 22023 Error SR319: Max length of a temp row (12432) exceeded
Can I reconfigure this, like the timeout, to make it work?
Thank you.
--
DENG Nan
Elève ingénieur à Télécom-Paristech
Mail: nicolasdeng1...@gmail.com
de...@eurecom.fr
Tel:(+33)0682548208
--
BlackBerryreg; DevCon Americas, Oct. 18-20, San Francisco, CA
The must-attend event for mobile developers. Connect with experts.
Get tools for creating Super Apps. See the latest technologies.
Sessions, hands-on labs, demos much more. Register early save!
http://p.sf.net/sfu/rim-blackberry-1___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
--
DENG Nan
Elève ingénieur à Télécom-Paristech
Mail: nicolasdeng1...@gmail.com
de...@eurecom.fr
Tel:(+33)0682548208
Re: [Virtuoso-users] How to delete all triples from a named graph / for a given subject?
Hi Andreas, Please provide details of the Virtuoso version being used (virtuoso-t -?), and also a simple test case showing the steps to reproduce the problem you are seeing, so we can attempt recreation locally ... Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 5 Aug 2011, at 10:33, Andreas Kahl wrote: Hello again, now, after deleting the graph, I loaded new data into the graph and the old triples are there again (in addition to the old ones). It seems, they were not really deleted. Is there some restriction that I must not reuse a graph- or subject-URI after having deleted it previously? Andreas Original-Nachricht Datum: Fri, 05 Aug 2011 11:05:15 +0200 Von: Andreas Kahl andreas_k...@gmx.net An: Andreas Radinger andreas.radin...@ebusiness-unibw.org CC: virtuoso-users@lists.sourceforge.net Betreff: Re: [Virtuoso-users] How to delete all triples from a named graph / for a given subject? Hello Andreas, thanks a lot for your hint - now the data seems to be deleted from the graph. (the Interactive SQL said: Drop silent graph URI -- nothing to do , but the data is not returned by SPARQL SELECTs any more). I am still interested how to update data about a single RDF-Subject (preferably via SPARQL Update). Andreas Original-Nachricht Datum: Fri, 05 Aug 2011 10:55:24 +0200 Von: Andreas Radinger andreas.radin...@ebusiness-unibw.org An: Andreas Kahl andreas_k...@gmx.net CC: virtuoso-users@lists.sourceforge.net Betreff: Re: [Virtuoso-users] How to delete all triples from a named graph / for a given subject? On 8/5/11 10:43 AM, Andreas Kahl wrote: Hello, I loaded some data into Virtuoso OSE 6.1.3 using the BulkLoader. For every dataset I defined a named graph. How can I now delete all Triples from one of those graphs? I tried 'sparql clear graph URI' in conductor's interactive SQL (as user dba), the system said it executed the query successfully. But after that, I still can retrieve the data from this graph via SPARQL Select. Alternatively I tried 'sparql drop graph URI'. But this lead to an error saying: Message: SPARUL_DROP() failed: graph URI has not been explicitly created before. So is there another command I should use? Hi Andreas, try 'sparql drop silent graph URI;' as described at [1] for graphs that are not created explicitly. Best, Andreas [1] http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtTipsAndTricksGuideCreateGraph Another question to is how to update data describing a single RDF-Subject. How could I issue commands to delete all Triples having a certain URI as RDF-Subject? (and then bulk load the new data). Thanks for your help. Andreas -- BlackBerryreg; DevCon Americas, Oct. 18-20, San Francisco, CA The must-attend event for mobile developers. Connect with experts. Get tools for creating Super Apps. See the latest technologies. Sessions, hands-on labs, demos much more. Register early save! http://p.sf.net/sfu/rim-blackberry-1 ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users -- BlackBerryreg; DevCon Americas, Oct. 18-20, San Francisco, CA The must-attend event for mobile developers. Connect with experts. Get tools for creating Super Apps. See the latest technologies. Sessions, hands-on labs, demos much more. Register early save! http://p.sf.net/sfu/rim-blackberry-1 ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users -- BlackBerryreg; DevCon Americas, Oct. 18-20, San Francisco, CA The must-attend event for mobile developers. Connect with experts. Get tools for creating Super Apps. See the latest technologies. Sessions, hands-on labs, demos much more. Register early save! http://p.sf.net/sfu/rim-blackberry-1 ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Configuring new user
Hi
I don’t understand the problem you are describing, so can you please provide a
test case that can be created locally ?
If I insert the following data via isql and query it I get the following:
SQL SPARQL
Type the rest of statement, end with a semicolon (;) insert into graph
http://BookStore.com
Type the rest of statement, end with a semicolon (;) {
Type the rest of statement, end with a semicolon (;)
http://www.dajobe.org/foaf.rdf#i http://purl.org/dc/elements/1.1/date
1999-04-01T00:00:00 .
Type the rest of statement, end with a semicolon (;)
http://www.w3.org/People/Berners-Lee/card#i
http://purl.org/dc/elements/1.1/date 1998-05-03T00:00:00 .
Type the rest of statement, end with a semicolon (;)
http://www.w3.org/People/Connolly/#me http://purl.org/dc/elements/1.1/date
2001-02-08T00:00:00
Type the rest of statement, end with a semicolon (;) };
callret-0
VARCHAR
___
Insert into http://BookStore.com, 3 (or less) triples -- done
1 Rows. -- 600 msec.
SQL sparql select * from http://BookStore.com where {?s ?p ?o};
s
p
oVARCHAR
VARCHAR
VARCHAR
___
http://www.dajobe.org/foaf.rdf#i
http://purl.org/dc/elements/1.1/date
1999-04-01T00:00:00
http://www.w3.org/People/Berners-Lee/card#i
http://purl.org/dc/elements/1.1/date
1998-05-03T00:00:00
http://www.w3.org/People/Connolly/#me
http://purl.org/dc/elements/1.1/date
2001-02-08T00:00:00
3 Rows. -- 3 msec.
SQL
and get the same output querying via the SPARQL endpoint:
s p o
http://www.dajobe.org/foaf.rdf#i http://purl.org/dc/elements/1.1/date
1999-04-01T00:00:00
http://www.w3.org/People/Berners-Lee/card#i
http://purl.org/dc/elements/1.1/date 1998-05-03T00:00:00
http://www.w3.org/People/Connolly/#me http://purl.org/dc/elements/1.1/date
2001-02-08T00:00:00
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 3 Aug 2011, at 18:15, Houda kr wrote:
OK thanks Hugh.
I have also another question : how can I remove the timezone added by
Virtuoso from the SPARQL results (queries executed on SPARQL endpoint) when
the datatype is dateTime. I want to simply have 00:00:00T-mm-dd instead
of 00:00:00T-mm-dd+01:00 (the +01:00 is added by Virtuoso). I don't have
the problem when I run the query using SQL interactive.
Best,
Houda
2011/8/3 Hugh Williams hwilli...@openlinksw.com
Hi Houda,
You are missing the following from the example in the documentation, which is
required before you can set user permissions on graphs:
-- At least some data are supposed to be confidential,
-- thus the whole storage becomes confidential.
DB.DBA.RDF_DEFAULT_USER_PERMS_SET ('nobody', 0);
-- Moreover, no one of created users have access to all
-- graphs (even for reading).
DB.DBA.RDF_DEFAULT_USER_PERMS_SET ('Anna', 0);
The error message is rather misleading though, so will see about getting it
changed
$ /opt/virtuoso/bin/isql opluswinbuild:
Connected to OpenLink Virtuoso
Driver: 06.01.3127 OpenLink Virtuoso ODBC Driver
OpenLink Interactive SQL (Virtuoso), version 0.9849b.
Type HELP; for help and EXIT; to exit.
SQL DB.DBA.USER_CREATE ('Anna', 'Anna');
Done. -- 4285 msec.
SQL DB.DBA.RDF_DEFAULT_USER_PERMS_SET ('Anna', 1);
Done. -- 1201 msec.
SQL DB.DBA.RDF_GRAPH_USER_PERMS_SET ('http://example.com', 'Anna', 3);
*** Error RDF99: [Virtuoso Driver][Virtuoso Server]Permissions of
unauthenticated user are broader than new permissions of user Anna on
specific graph http://example.com
at line 3 of Top-Level:
DB.DBA.RDF_GRAPH_USER_PERMS_SET ('http://example.com', 'Anna', 3)
SQL DB.DBA.RDF_DEFAULT_USER_PERMS_SET ('nobody', 0);
Done. -- 386 msec.
SQL DB.DBA.RDF_GRAPH_USER_PERMS_SET ('http://example.com', 'Anna', 3);
Done. -- 251 msec.
SQL
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 3 Aug 2011, at 10:36, Houda kr wrote:
Hi,
I am trying to create a new user (Anna) in Virtuoso and specify
Re: [Virtuoso-users] max length of temp row error
Hi Nan, The are no specific configuration params to work around this from occurrence of this error seen before, although we are looking into it. Please provide the query and ideally some test data to recreate and we may be able to advise on re-structuring of the query to work around this. Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 4 Aug 2011, at 15:54, DENG Nan wrote: Hi, I run a select query and I get an error called: Virtuoso 22023 Error SR319: Max length of a temp row (12432) exceeded Can I reconfigure this, like the timeout, to make it work? Thank you. -- DENG Nan Elève ingénieur à Télécom-Paristech Mail: nicolasdeng1...@gmail.com de...@eurecom.fr Tel:(+33)0682548208 -- BlackBerryreg; DevCon Americas, Oct. 18-20, San Francisco, CA The must-attend event for mobile developers. Connect with experts. Get tools for creating Super Apps. See the latest technologies. Sessions, hands-on labs, demos much more. Register early save! http://p.sf.net/sfu/rim-blackberry-1___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] How can I delete or reconfigure the timeout?
Hi Deng, Configuration of Virtuoso SPARQL query time outs MaxQueryExecutionTime , MaxQueryCostEstimationTime can be performed in the virtuoso.ini file as detailed at: http://docs.openlinksw.com/virtuoso/dbadm.html#ini_SPARQL There is also and anytime query timeout for returning partial results as detailed at: http://docs.openlinksw.com/virtuoso/anytimequeries.html Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 3 Aug 2011, at 09:22, DENG Nan wrote: Hello, How can I delete or reconfigure the timeout as we have a query command which takes a long time? -- DENG Nan Elève ingénieur à Télécom-Paristech Mail: nicolasdeng1...@gmail.com de...@eurecom.fr Tel:(+33)0682548208 -- BlackBerryreg; DevCon Americas, Oct. 18-20, San Francisco, CA The must-attend event for mobile developers. Connect with experts. Get tools for creating Super Apps. See the latest technologies. Sessions, hands-on labs, demos much more. Register early save! http://p.sf.net/sfu/rim-blackberry-1___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Configuring new user
Hi Houda,
You are missing the following from the example in the documentation, which is
required before you can set user permissions on graphs:
-- At least some data are supposed to be confidential,
-- thus the whole storage becomes confidential.
DB.DBA.RDF_DEFAULT_USER_PERMS_SET ('nobody', 0);
-- Moreover, no one of created users have access to all
-- graphs (even for reading).
DB.DBA.RDF_DEFAULT_USER_PERMS_SET ('Anna', 0);
The error message is rather misleading though, so will see about getting it
changed
$ /opt/virtuoso/bin/isql opluswinbuild:
Connected to OpenLink Virtuoso
Driver: 06.01.3127 OpenLink Virtuoso ODBC Driver
OpenLink Interactive SQL (Virtuoso), version 0.9849b.
Type HELP; for help and EXIT; to exit.
SQL DB.DBA.USER_CREATE ('Anna', 'Anna');
Done. -- 4285 msec.
SQL DB.DBA.RDF_DEFAULT_USER_PERMS_SET ('Anna', 1);
Done. -- 1201 msec.
SQL DB.DBA.RDF_GRAPH_USER_PERMS_SET ('http://example.com', 'Anna', 3);
*** Error RDF99: [Virtuoso Driver][Virtuoso Server]Permissions of
unauthenticated user are broader than new permissions of user Anna on
specific graph http://example.com
at line 3 of Top-Level:
DB.DBA.RDF_GRAPH_USER_PERMS_SET ('http://example.com', 'Anna', 3)
SQL DB.DBA.RDF_DEFAULT_USER_PERMS_SET ('nobody', 0);
Done. -- 386 msec.
SQL DB.DBA.RDF_GRAPH_USER_PERMS_SET ('http://example.com', 'Anna', 3);
Done. -- 251 msec.
SQL
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 3 Aug 2011, at 10:36, Houda kr wrote:
Hi,
I am trying to create a new user (Anna) in Virtuoso and specify his
permission (read/write) on a specific graph http://example.com and only
read for the rest of graphs. I follow the example provided in this link
http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtRDFGraphsSecurity,
and I execute the following commands :
DB.DBA.USER_CREATE ('Anna', 'Anna');
DB.DBA.RDF_DEFAULT_USER_PERMS_SET ('Anna', 1);
DB.DBA.RDF_GRAPH_USER_PERMS_SET ('http://example.com', 'Anna', 3);
But, the last command generates the following error :
*** Error RDF99: [Virtuoso Driver][Virtuoso Server]Permissions of
unauthenticated user are broader than new permissions of user Anna on
specific graph http://example.com
Is there something wrong ?
Thanks
Houda
--
BlackBerryreg; DevCon Americas, Oct. 18-20, San Francisco, CA
The must-attend event for mobile developers. Connect with experts.
Get tools for creating Super Apps. See the latest technologies.
Sessions, hands-on labs, demos much more. Register early save!
http://p.sf.net/sfu/rim-blackberry-1___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Subquery and SAMPLE keyword (SPARQL 1.1)
Hi Houda,
Virtuoso does now implement the SPARQL 1.1 GROUP_CONCAT and SAMPLE aggregate
functions.
Note however their is a slight deviation from SPARQL 1.1 in that as the
specification is not fully ratified stable, SAMPLE and GROUP_CONCAT are not
added as keywords directly and need to be prefixed with “sql:” until the
specification is complete. So for the DBpedia query given on
answers.semanticweb, the following now works:
PREFIX w3geo: http://www.w3.org/2003/01/geo/wgs84_pos#
SELECT ?name (sql:SAMPLE(?lat) as ?latlat) ?long ?city ?imageBlankEmblem WHERE {
?city dbpprop:imageBlankEmblem ?imageBlankEmblem .
?city rdfs:label ?name .
?city w3geo:lat ?lat .
?city w3geo:long ?long .
FILTER ( ( LANG(?name) = 'en' ) ( datatype(?lat) = datatype(?long) ) (
datatype(?long) = xsd:float ) )
}
As you are using the Virtuoso open source version you would need a later
snapshot to the current 6.1.3 available on source forge, as this support was
added recently. A snapshot build containing this support can be obtained from:
ftp://download.openlinksw.com/support/vos/virtuoso-opensource-6-20110614.tar.gz
which you can rebuild and test with ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 2 Aug 2011, at 14:01, Houda kr wrote:
Hi,
I need to know how to return one random label (for each item) when the item
has several labels (using SPARQL). I tried the following query, but it
returns the same label for all persons
SELECT ?person ?name WHERE {
?person a foaf:Agent .
{ SELECT ?name WHERE {
?person rdfs:label ?name
} LIMIT 1 } .
}
Same behavior on DBpedia SPARQL endpoint (see
http://answers.semanticweb.com/questions/2726/using-sample-keyword-and-subqueries-at-dbpediaorg).
I need to understand why this query doesn't work since the second query
should retrieve the first name for each resource from the first query.
I am trying to use the SAMPLE keyword (SPARQL 1.1), but it is not supported
by the current version of Virtuoso. I want to know when the SPARQL 1.1 will
be fully integrated in the open source distribution. Any other suggestion is
welcome.
thanks in advance
Houda
--
BlackBerryreg; DevCon Americas, Oct. 18-20, San Francisco, CA
The must-attend event for mobile developers. Connect with experts.
Get tools for creating Super Apps. See the latest technologies.
Sessions, hands-on labs, demos much more. Register early save!
http://p.sf.net/sfu/rim-blackberry-1___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Virtuoso full text search for plural
Hi Priyam, Virtuoso does not have specific support for plurals, will check with development if there is an alternative way this can be done. Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 31 Jul 2011, at 17:25, Priyam Maheshwari wrote: Hi, I am using Virtuoso to store some text in Virtuoso relational database. I am also using its full text feature to retrieve some search result, but when i search for plural words it doesn't return me any relevant answer for example i have 2 entries in my database earthquake and massive earthquake, when i just search for earthquake it returns me both entries but if i search for earthquakes it doesn't give me any answer. How can I implement it to search for plurals as well. -- Got Input? Slashdot Needs You. Take our quick survey online. Come on, we don't ask for help often. Plus, you'll get a chance to win $100 to spend on ThinkGeek. http://p.sf.net/sfu/slashdot-survey ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Build in sparql end point service
Hi Hoan, I am not sure how you are attempting to create this built in SPARQL endpoint, as the lsm.deri.org site appears to be a Russian Web Site built in PHP, and not hosted in Virtuoso ? Do you thus have a Virtuoso server on an internal network hosting some RDF data you want to expose via the SPARQL endpoint at the http://lsm.deir.org/sparql URL ? The following tip details how the Virtuoso SPARQL endpoint can be configured to run on a different domain and port to the Virtuoso Server instance itself: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtTipsAndTricksSPARQLCondPort Details on customising the Virtuoso SPARQL endpoint can also be found in the following documentation: http://docs.openlinksw.com/virtuoso/rdfsparql.html#rdfsparqlprotocolendpoint I hope this is what you are looking for ... Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 24 Jul 2011, at 23:44, Nguyen Mau Quoc Hoan wrote: Hi. I'm trying to create virtuoso sparql service for my project. How could I do that? My sparql endpoint service will have URI: http://lsm.deir.org/sparql Thanks in advance. -- Magic Quadrant for Content-Aware Data Loss Prevention Research study explores the data loss prevention market. Includes in-depth analysis on the changes within the DLP market, and the criteria used to evaluate the strengths and weaknesses of these DLP solutions. http://www.accelacomm.com/jaw/sfnl/114/51385063/___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] SPARQL Construct with optionals behavior in Virtuoso
Hi Manuel,
I have tested the query you provided against empty default Virtuoso 6.1.3 and
6.1.2 databases, and do get results returned:
@prefix rdfs: http://www.w3.org/2000/01/rdf-schema# .
@prefix owl:http://www.w3.org/2002/07/owl# .
owl:Thing rdfs:label Thing .
owl:Class rdfs:label Class .
owl:Nothing rdfs:label Nothing .
owl:complementOfrdfs:label complementOf .
owl:unionOf rdfs:label unionOf .
owl:Ontologyrdfs:label Ontology .
owl:imports rdfs:label imports .
owl:versionInfo rdfs:label versionInfo .
owl:priorVersionrdfs:label priorVersion .
owl:OntologyPropertyrdfs:label OntologyProperty .
owl:AnnotationProperty rdfs:label AnnotationProperty .
owl:equivalentClass rdfs:label equivalentClass .
owl:disjointWithrdfs:label disjointWith .
owl:equivalentProperty rdfs:label equivalentProperty .
owl:differentFrom rdfs:label differentFrom .
owl:distinctMembers rdfs:label distinctMembers .
owl:AllDifferentrdfs:label AllDifferent .
owl:intersectionOf rdfs:label intersectionOf .
owl:oneOf rdfs:label oneOf .
owl:Restriction rdfs:label Restriction .
owl:onProperty rdfs:label onProperty .
owl:allValuesFrom rdfs:label allValuesFrom .
owl:hasValuerdfs:label hasValue .
owl:someValuesFrom rdfs:label someValuesFrom .
owl:minCardinality rdfs:label minCardinality .
owl:maxCardinality rdfs:label maxCardinality .
owl:cardinality rdfs:label cardinality .
owl:ObjectProperty rdfs:label ObjectProperty .
owl:DatatypePropertyrdfs:label DatatypeProperty .
owl:inverseOf rdfs:label inverseOf .
owl:TransitiveProperty rdfs:label TransitiveProperty .
owl:SymmetricProperty rdfs:label SymmetricProperty .
owl:FunctionalProperty rdfs:label FunctionalProperty .
owl:InverseFunctionalProperty rdfs:label InverseFunctionalProperty .
owl:backwardCompatibleWith rdfs:label backwardCompatibleWith .
owl:incompatibleWithrdfs:label incompatibleWith .
owl:DeprecatedClass rdfs:label DeprecatedClass .
owl:DeprecatedProperty rdfs:label DeprecatedProperty .
owl:DataRange rdfs:label DataRange .
owl:sameAs rdfs:label sameAs”
Can you please confirm the Virtuoso version and build data of the binary being
used by running the command:
$ virtuoso-t -?
Virtuoso Open Source Edition (multi threaded)
Version 6.1.3.3127-pthreads as of May 29 2011
Compiled for Darwin (i386-apple-darwin10.6.0)
Copyright (C) 1998-2011 OpenLink Software
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 14 Jul 2011, at 19:00, manuelso wrote:
Hi,
I am running OpenLink Virtuoso version 06.01.3127, on Linux (x86_64).
My question is the following. I have a SPARQL construct query with complex
optionals that returns no results. It looks like ...
CONSTRUCT { ?s http://www.w3.org/2000/01/rdf-schema#label ?o }
WHERE {
?s http://www.w3.org/2000/01/rdf-schema#label ?o .
OPTIONAL { ?s http://www.w3.org/2000/01/rdf-schema#NOT_EXISTING
http://www.w3.org/2000/01/rdf-schema#NOT_EXISTING . }
}
I know that the pattern in the OPTIONAL clause is not satisfied but, despite
that fact, I should get results. I have tested this query also with Jena-TDB
and 4store and in both cases I get results. Also in the SPARQL spec I could
read ...
If any such instantiation produces a triple containing an unbound variable
or an illegal RDF construct, such as a literal in subject or predicate
position, then that triple is not included in the output RDF graph. (see
also
http://answers.semanticweb.com/questions/2529/sparql-construct-queries-against-optional-data)
So my question is ... whether this is a bug and, if so, if it has been fixed
in latest releases ?
Thanks,
Manuel Salvadores
--
AppSumo Presents a FREE Video for the SourceForge Community by Eric
Ries, the creator of the Lean Startup Methodology on Lean Startup
Secrets Revealed. This video shows you how to validate your ideas,
optimize your ideas and identify your business strategy.
http://p.sf.net/sfu/appsumosfdev2dev___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Inserting litterals
Hi Alexandre,
This works for me:
$ /opt/virtuoso/bin/isql opllinux3:1234
Connected to OpenLink Virtuoso
Driver: 06.02.3129 OpenLink Virtuoso ODBC Driver
OpenLink Interactive SQL (Virtuoso), version 0.9849b.
Type HELP; for help and EXIT; to exit.
SQL SPARQL INSERT DATA INTO http://foobar { http://foo
http://example.org/foo Bar^^xsd:string .};
callret-0
VARCHAR
___
Insert into http://foobar, 1 (or less) triples -- done
1 Rows. -- 1611 msec.
SQL SPARQL select * from http://foobar where {?s ?p ?o};
s
p
o
VARCHAR
VARCHAR
VARCHAR
___
http://foo
http://example.org/foo
Bar
1 Rows. -- 188 msec.
SQL
Where is the version of the Virtuoso server being run ?
virtuoso-iodbc-t -?
or
virtuoso-t -?
Are you running this on your Virtuoso EC2 AMI instance ?
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 15 Jul 2011, at 10:12, Alexandre Passant wrote:
On 15 Jul 2011, at 10:11, Bob Ferris wrote:
Hi Alex,
On 7/15/2011 11:07 AM, Alexandre Passant wrote:
Hi,
I'm trying to insert typed literals in a Virtuoso store as follows:
INSERT DATA INTO http://foobar {
http://foo http://example.org/foo Bar^^xsd:string .
}
But have the following error
37000 Error SP031: SPARQL compiler: The query can be compiled and executed
but not translated to an accurate SQL text
SPARQL query:
define sql:signal-void-variables 1 INSERT DATA INTOhttp://foobar {
http://foo http://example.org/foo Bar^^xsd:String .
}
dunno, but you wrote 'xsd:String' instead of 'xsd:string'.
Well spotted !
I tried with both to see if that was related - but that's not
Alex.
Cheers,
Bob
--
AppSumo Presents a FREE Video for the SourceForge Community by Eric
Ries, the creator of the Lean Startup Methodology on Lean Startup
Secrets Revealed. This video shows you how to validate your ideas,
optimize your ideas and identify your business strategy.
http://p.sf.net/sfu/appsumosfdev2dev
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
--
Dr. Alexandre Passant,
Social Software Unit Leader
Digital Enterprise Research Institute,
National University of Ireland, Galway
--
AppSumo Presents a FREE Video for the SourceForge Community by Eric
Ries, the creator of the Lean Startup Methodology on Lean Startup
Secrets Revealed. This video shows you how to validate your ideas,
optimize your ideas and identify your business strategy.
http://p.sf.net/sfu/appsumosfdev2dev
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Inserting litterals
Hi Alexandre,
Looks like it. Note we provide documentation on upgrading the Ubuntu (and
other) Linux distro’s Virtuoso binaries to the latest 6.1.3 open source builds
at:
http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VOSUbuntuNotes
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 15 Jul 2011, at 11:25, Alexandre Passant wrote:
Hi,
I've made the tests on a ubuntu with the Virtuoso packages
Virtuoso Open Source Edition (multi threaded)
Version 6.1.2.3127-pthreads as of Aug 2 2010
Compiled for Linux (x86_64-pc-linux-gnu)
Copyright (C) 1998-2010 OpenLink Software
Yet - I've just tried on EC2 and it works.
So that's apparently a solved bug
Alex.
On 15 Jul 2011, at 10:42, Hugh Williams wrote:
Hi Alexandre,
This works for me:
$ /opt/virtuoso/bin/isql opllinux3:1234
Connected to OpenLink Virtuoso
Driver: 06.02.3129 OpenLink Virtuoso ODBC Driver
OpenLink Interactive SQL (Virtuoso), version 0.9849b.
Type HELP; for help and EXIT; to exit.
SQL SPARQL INSERT DATA INTO http://foobar { http://foo
http://example.org/foo Bar^^xsd:string .};
callret-0
VARCHAR
___
Insert into http://foobar, 1 (or less) triples -- done
1 Rows. -- 1611 msec.
SQL SPARQL select * from http://foobar where {?s ?p ?o};
s
p
o
VARCHAR
VARCHAR
VARCHAR
___
http://foo
http://example.org/foo
Bar
1 Rows. -- 188 msec.
SQL
Where is the version of the Virtuoso server being run ?
virtuoso-iodbc-t -?
or
virtuoso-t -?
Are you running this on your Virtuoso EC2 AMI instance ?
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 15 Jul 2011, at 10:12, Alexandre Passant wrote:
On 15 Jul 2011, at 10:11, Bob Ferris wrote:
Hi Alex,
On 7/15/2011 11:07 AM, Alexandre Passant wrote:
Hi,
I'm trying to insert typed literals in a Virtuoso store as follows:
INSERT DATA INTO http://foobar {
http://foo http://example.org/foo Bar^^xsd:string .
}
But have the following error
37000 Error SP031: SPARQL compiler: The query can be compiled and
executed but not translated to an accurate SQL text
SPARQL query:
define sql:signal-void-variables 1 INSERT DATA INTOhttp://foobar {
http://foo http://example.org/foo Bar^^xsd:String .
}
dunno, but you wrote 'xsd:String' instead of 'xsd:string'.
Well spotted !
I tried with both to see if that was related - but that's not
Alex.
Cheers,
Bob
--
AppSumo Presents a FREE Video for the SourceForge Community by Eric
Ries, the creator of the Lean Startup Methodology on Lean Startup
Secrets Revealed. This video shows you how to validate your ideas,
optimize your ideas and identify your business strategy.
http://p.sf.net/sfu/appsumosfdev2dev
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
--
Dr. Alexandre Passant,
Social Software Unit Leader
Digital Enterprise Research Institute,
National University of Ireland, Galway
--
AppSumo Presents a FREE Video for the SourceForge Community by Eric
Ries, the creator of the Lean Startup Methodology on Lean Startup
Secrets Revealed. This video shows you how to validate your ideas,
optimize your ideas and identify your business strategy.
http://p.sf.net/sfu/appsumosfdev2dev
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
--
Dr. Alexandre Passant,
Social Software Unit Leader
Digital Enterprise Research Institute,
National University of Ireland, Galway
--
AppSumo Presents a FREE Video for the SourceForge Community by Eric
Ries, the creator of the Lean Startup Methodology on Lean Startup
Re: [Virtuoso-users] Increase number connection to virtuoso?
Hi Hoan, Are you using the Virtuoso open source or commercial release at this point as I recall sending you commercial test license back in March which would have expired by now ? Thus specifically what is the error you are sometimes getting, please provide a copy of your virtuoso.log file which should record such errors. Also provide the virtuoso.ini file, where the “ServerThreads” parameter in the “[Parameters]” and “[HTTP]” sections of the file control the number of threads available for SQL and HTTP (allocated on startup) respectively. Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 13 Jul 2011, at 00:08, Nguyen Mau Quoc Hoan wrote: Hi. How could I increase the number of client connection and number of server thread of Virtuoso. Sometimes I got problem about limited number connection so I want to modify it. Any one can help me? -- AppSumo Presents a FREE Video for the SourceForge Community by Eric Ries, the creator of the Lean Startup Methodology on Lean Startup Secrets Revealed. This video shows you how to validate your ideas, optimize your ideas and identify your business strategy. http://p.sf.net/sfu/appsumosfdev2dev___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] use of grab- pragmas
Hi Tatiana, What datasets to you have loaded locally when encountering these issues , is it possible to provide sample datasets and queries we can load locally to recreate these issues ? Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 2 Jul 2011, at 01:01, Таня Тарасова wrote: Hi, I have just noticed I answered only to Hugh first time. Anyway, thanks for your advise, Hugh, I installed the 6.3.1 version. Unfortunately , it didn't solve my issue. So, I will just ask again the whole list. Specially, I found that somebody already experienced similar issue and also with lat/long here [1]. I don't know if it was resolved though... When I am using grab-var pragma it looks like some of the resources are downloaded partially, e.g. this resource http://dbpedia.org/resource/Porto;. I check it out from the local storage afterwards and the geo:lat and geo:long properties were not returned (not only them). But this resource http://dbpedia.org/resource/Beja_Municipality; is downloaded with geo:lat and geo:long perfectly... So, I don't think the problem is with my query. By the way, the FED-query returns lat/long for all the resources (just the execution time is unacceptably long). Is there a way to increase the timeout? Also, I already faced with partial downloading while I was uploading a data set to my local graph and Virtuoso rejected it as not valid (but I validated it before). Then, just the part of the graph was downloaded, even though I expected not valid RDF files should not be downloaded either partially or completely. Anyway, such graphs contain - symbol in local part of QName, which I believe was reason why they were considered not valid before. So, I was thinking could it be any connection between Virtuoso considering graphs with - not valid and partial downloading of some of the resources from dbpedia with lat/long literals (which also contain signs +/-). If anybody faced similar issue before and knows how to solve it I will be grateful if you share it with me :) Thank you, Tatiana [1] http://sourceforge.net/mailarchive/message.php?msg_id=27365847 -- All of the data generated in your IT infrastructure is seriously valuable. Why? It contains a definitive record of application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-d2d-c2 ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Virtuoso RDFXX Error Unknown language
Hi Tatiana, The error indicates the DBA.DBA.RDF_LANGUAGE table is possibly corrupt. Its a bit complicated, but this can be determined by checking the value of ro_dt_and_lang column in DB.DBA.RDF_OBJ table where ro_val is equal to the the literal mentioned in the error: select ro_dt_and_lang from DB.DBA.RDF_OBJ where ro_val = '丰沙尔'; Then take a bit-and of the ro_dt_and_lang column with 0x: select bit_and (ro_dt_and_lang, 0hex) from rdf_obj where ro_val = '丰沙尔'; and finally check for this id in the DB.DBA.RDF_LANGUAGE table, which is possibly missing. In which case the best course of action would be to start from scratch and reload the datasets into a fresh empty database. Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 3 Jul 2011, at 19:12, Таня Тарасова wrote: Hello, Does anybody happens to know how to fix this error: Virtuoso RDFXX Error Unknown language in DB.DBA.RDF_LANGUAGE_OF_OBJ, bad string 丰沙尔 It occurred when I tried to do filtering by language: ?dbpedia_city rdfs:label ?label . filter (lang(?label) =en ) . will be grateful! Tatiana -- All of the data generated in your IT infrastructure is seriously valuable. Why? It contains a definitive record of application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-d2d-c2___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] use of grab- pragmas
Hi Таня,
As you indicate using the Virtuoso Open Source 6.1 packages shipped with
debian, which are 6.1.2 builds from about a year ago, I would suggest you
upgrade this to the latest 6.1.3 builds from March of this year, as detailed at:
http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VOSBuild#Specific%20Linux%20Distributions
There are a number of fixes in 6.1.3 for sponger pragmas and crawlers as well
as SPARQL-FED support you would benefit from and may resolve these issues you
are having ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 29 Jun 2011, at 02:52, Таня Тарасова wrote:
Hello dear Virtuoso-users!
I am a newbie in Virtuoso, and I am seeking for your advises since I didn't
manage to solve my problem with the Virtuoso documentation I considered
relevant. So probably you may point out what I am doing wrong or where I
could look for more detail. I would appreciate any help!
I am using Virtuoso Open Source Edition v.6.1( from debian packages). I am
using its native quad store to store my RDF files and to post queries against
its SPARQL-endpoint to mash-up data from my files with the data from external
data sets. My Virtuoso instance is running locally.
I was following tutorials [1], [2] and 16.2 Section [3] from the Virutoso
documentation to construct queries which would retrieve data from my local
graphs and DBpedia. I was also looking at the example queries from [4]. But
still I think I am missing something regarding what different grab- pragmas
do.
For example, in my data sets I have statistical data about cities and I set
up owl:sameAs links to the DBpedia cities. I want to be able to retrieve
geo:lat and geo:long values for my cities from DBpedia.
I tried the following pragmas:
1) grab-var:
define input:grab-var dbpediaConcept
2) same-as + grab-follow-predicate
define input:same-as yes
define input:grab-follow-predicate geo:lat
define input:grab-follow-predicate geo:long
3) grab:all
define input:grab-all yes
And the query itself is:
select distinct ?myConcept ?lat ?long
where
{?myConcept owl:sameAs ?dbpediaConcept .
?dbpediaConcept http://www.w3.org/2003/01/geo/wgs84_pos#lat ?lat ;
http://www.w3.org/2003/01/geo/wgs84_pos#long ?long .
}
But with these queries I returned only subset of myConcept. The simplest
explanation is that owl:sameAs links were set up wrong. But I checked
them...and I run the same federated query which did return all the data from
my data sets bounded with the DBpedia data:
select * where
{
SERVICE http://dbpedia.org/sparql
{?x http://www.w3.org/2003/01/geo/wgs84_pos#lat ?lat ;
http://www.w3.org/2003/01/geo/wgs84_pos#long ?long .}
?myConcept owl:sameAs ?x .
}
I believe I am missing some other pragmas in my extended SPARQL queries or I
am using them wrong? I would greatly appreciate if you could advise me what I
am doing wrong...
Thank you,
Tatiana
[1]
http://www.openlinksw.co.uk/virtuoso/Whitepapers/html/VirtSpongerWhitePaper.html#AncSPARQL1
[2]
http://www.openlinksw.co.uk/virtuoso/Whitepapers/html/VirtSpongerWhitePaper.html#AncSPARQL2
[3] http://docs.openlinksw.com/virtuoso/rdfiridereferencing.html
[4]
http://virtuoso.openlinksw.com/presentations/SPARQL_Tutorials/SPARQL_Tutorials_Part_7/SPARQL_Tutorials_Part_7.html#(24)
--
All of the data generated in your IT infrastructure is seriously valuable.
Why? It contains a definitive record of application performance, security
threats, fraudulent activity, and more. Splunk takes this data and makes
sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-d2d-c2___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Bulk dataset uploading performance
Hi Alexander, I presume 50kk in 50 million ? You indicated having allocate all you memory for use by the Virtuoso Server whereas it is recommended about 60% of memory is allocated as detailed at: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtRDFPerformanceTuning Also, are you running the Virtuoso RDF Bulk loader scripts detailed at: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtBulkRDFLoaderScript as these are what we used for loading the billion plus datasets loading into some of the endpoints we use. These script auto set log_enable mode prior to upload. Note you can also run multiple rdf_runloader() scripts to perform parallel loading of the datasets for better performance. I’ve had upwards for 300 million triple uploads per hour on an 8 core machine with 72GB of memory running 8 instances of the rdf_runloader() scripts in parallel ( one for each core). Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 26 Jun 2011, at 17:00, Alexander Sidorov wrote: Hello! What does influence on the bulk dataset uploading performance? I need to upload about 50kk triples (quads) to the server with outdated hardware and 1gb of memory. I have set MaxCheckpointRemap, NumberOfBuffers and MaxDirtyBuffers to take all available memory but uploading goes very slow, about 100k triples per hour (I am not even sure whether memory size plays significant role in dataset uploading process). Are there any other points to improve uploading performance? Does log_enable play role here (like in graph deletion)? Regards, Alexander -- All of the data generated in your IT infrastructure is seriously valuable. Why? It contains a definitive record of application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-d2d-c2___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Virtuoso Server Hardware Suggestions
Hi Peter, For server hardware we generally recommend generic x86_64 servers, e.g. Supermicro with 2x CXeon 56xx , running Linux as the operating system. The dual socket Xeon 56xx series is a better deal in terms for price performance than the 4 socket Xeon 75xx series. As x86_64 is today' s principal server platform, our code is specially optimized for this, for example better than for SPARC, on which it also runs. Database files are preferrably to be kept on SSD’s, which can be run in software RAID 5 which is usually faster then hardware. The Dell server spec below should also suffice, the key requirement for performance being having sufficient memory available to load the entire database working set in memory. As a rule we recommend 32GB per billion triples and given that DBpedia consists of about 1 billions triples 32GB memory should suffice, especially in conjunction with SSD’s. Although for future growth, assuming the datasets are likely to grow over time a server with more memory capacity might be worth considering ? Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 23 Jun 2011, at 23:36, Peter DeVries wrote: Thanks Ivan, I guess the think that they are being clever by not allowing linking to a product page. Thanks for the specs, This will help, - Pete === Dell PowerEdge R2100 II Rack Server with One Quad-Core Intel® Xeon® processor E3-1200 Up to 32GB (4 DIMM slots): 1GB/2GB/4GB/8GB DDR3 up to 1333MHz Intel® Xeon® E3-1220 3.10 GHz, 8M Cache, Turbo, Quad Core/4T (80W) [add $170.00] Intel® Xeon® E3-1220L 2.20 GHz, 3M Cache, Turbo, Dual Core/4T (20W) [add $180.00] Intel® Xeon® E3-1230 3.20 GHz, 8M Cache, Turbo, Quad Core/8T (80W) [add $230.00] Intel® Xeon® E3-1240 3.30 GHz, 8M Cache, Turbo, Quad Core/8T (80W) [add $270.00] Intel® Xeon® E3-1260L 2.40 GHz, 8M Cache, Turbo, Quad Core/8T (45W) [add $310.00] Intel® Xeon® E3-1270 3.40 GHz, 8M Cache, Turbo, Quad Core/8T (80W) [add $400.00] Intel® Xeon® E3-1280 3.50 GHz, 8M Cache, Turbo, Quad Core/8T (95W) [add $800.00] Cabled Hard Drive Options: 3.5 SAS (15K, 10K), nearline SAS (7.2K), SATA (5.4K, 7.2K) Maximum Internal Storage: Up to 4TB11 External Storage: For information about Dell external storage options, visit Dell.com/Storage. Drive Bays Cabled options available: Up to two 3.5 SAS or SATA drives Slots 1 PCIe x16 G2 slot RAID Controllers (optional) Internal Controllers: PERC H200 (6Gb/s) PERC S100 (software based) PERC S300 (software based) External Controllers: 6GB/s SAS HBA Optional Communications Broadcom® NetXtremeTM 5709 Dual Port Gigabit Ethernet NIC, Copper, w/TOE PCIe x4 Broadcom® NetXtremeTM 5709 Dual Port Gigabit Ethernet NIC, Copper, TOE/iSCI PCIe x4 Broadcom® NetXtremeTM 5709 Quad Port Gigabit Ethernet NIC, Copper, w/TOE/ iSCI PCIe x4 Intel Gigabit ET Dual Port Adapter, Gigabit Ethernet NIC, PCIe x4 Intel Gigabit ET Quad Port Adapter, Gigabit Ethernet NIC, PCIe x4 Power Supply Single cabled power supply (250W) Availability Quad-pack LED diagnostic, ECC Memory, add-in RAID, TPM/C-TPM Embedded Network Controller One Dual port Broadcom BCM 5716 Graphics Matrox G200eW w/ 16MB memory Chassis Rack Chassis 42.6 H x 434 W x 394.3 D (mm) 1.66 H x 17.09 W x 15.52 D (in) Rack Support ReadyRailsTM static rails for tool-less mounting in 4-post racks with square or unthreaded round holes or tooled mounting in 4-post threaded and 2-post (Telco) racks. Management BMC, IPMI 2.0 compliant DellTM OpenManageTM Unified Server Configurator LifeCycle Controller enabled via optional: iDRAC6 Express, iDRAC6 Enterprise and Vflash Acoustics Typically configured3 3.5 cable chassis in 23 ± 2 °C ambient Idle: LwA-UL4 = 5.2 bels; LpA5 = 40 dBA Regulatory and Environmental Compliance Regulatory Model: E10S Regulatory Type: E10S002 I guess the think that they are being clever by not allowing linking to each product page. Thanks for the specs, This will help, - Pete On Thu, Jun 23, 2011 at 5:15 PM, Ivan Mikhailov imikhai...@openlinksw.com wrote: Hello Peter, The link does not show anything except title page, it depends on your login and/or other credentials. Could you please cut+paste the selected configuration (and its price) into the mail? The last box I've assembled for Virtuoso development was 6 * RAM DDR-3 8Gb 1 * Intel 5520HCR Motherboard 2 * Intel Xeon E5620 CPUs 3 * WD5003ABYX SATA-II HDDs 1 * Chieftek BX-02B-B-SL miditower 1 * Cooler Master RS-A00-AMBA-J3 ATX power (plus DVD, video, CPU coolers, case fans) Some about $4100 last December, now it should become cheaper
Re: [Virtuoso-users] Building Virtuoso on a Mac
Hi Herman, Details on building Virtuoso open source on Mac OS 10.6.x and other OS’es is available at: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VOSMake The “README” file in the root of the open source archive also contains this information. Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 24 Jun 2011, at 13:39, Herman A. Junge wrote: Hi, Did someone build Virtuoso Open Source on a MacBook? (with Leopard 10.6.7)? Any information will be appreciated :D hermanjunge -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense.. http://p.sf.net/sfu/splunk-d2d-c1 ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Mapping two table into one quad storage?
Hi Hoan, You can create your own Quad Map Storage for loading your RDFView into or use the virtrdf:DefaultQuadStorage location used by the conductor when creating RDFViews as detailed at: http://docs.openlinksw.com/virtuoso/rdfsparqlintegrationmiddleware.html#rdfviewconfiguringrdfstorages http://www.openlinksw.co.uk/virtuoso/Whitepapers/html/rdf_views/virtuoso_rdf_views_example.html Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 21 Jun 2011, at 17:21, Nguyen Mau Quoc Hoan wrote: Hi. How could I map two table with the same quad storage RDF view? Is this possible? I want to create a quad storage that will be used to store all triple which are created from different table using mapping RDF View. Any help? Thanks in advance. -- EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image Editing and ensure content is compliant with Accessibility Checking. http://p.sf.net/sfu/ephox-dev2dev___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Query to return all graphs defined in a virtuoso instance
Hi Carlos, See the following tip on how to obtain a list of graphs in a Virtuoso server instance: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtTipsAndTricksGuideAllGraphs I hope this is what you are looking for ... Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 15 Jun 2011, at 15:48, Bruno Carvalho wrote: Hi, I need to know what graphs have something in a virtuoso instance. Do you know how to retrieve all graphs defined in a virtuoso instance ? Thanks in advance, Bruno Globo.com -- EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image Editing and ensure content is compliant with Accessibility Checking. http://p.sf.net/sfu/ephox-dev2dev___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] bif:contains - using a string variable as search term
Hi Robert,
Development suggest the query:
sparql
PREFIX dc: http://purl.org/dc/elements/1.1/
select distinct ?title ?u
from http://dbpedia.org
WHERE
{
?prog dc:title ?title .
?u rdfs:label ?label .
FILTER (bif:isnotnull (bif:strstr (?label, ?title)))
}
ORDER BY DESC ((select ?created where { ?prog dc:created ?created. } ))
LIMIT 1
should be the fastest. Note FROM graph and an implicit hint to the
optimizer that ?created can be calculated later and does not affect
filtering (i.e. the presence of ?created is not essential).
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 12 Jun 2011, at 15:28, Robert Globisch wrote:
Hi Hugh,
that's me, yes. Hello :)
When i remove the dc:created property (bounded to my ?prog variable) it gets
a lot faster on my Thinkpad (TP) and QuadCore system.
I need the dc:created property to order the results based on their date of
creation (time you tuned in to a channel) of my files loaded into the store.
As you can see it improves execution time massively.
I run the explain function for the following query using the virtuoso.db
loaded with the whole en.dbpedia dataset.
Hope that's what you wanted to have.
PREFIX po: http://purl.org/ontology/po/
PREFIX skos: http://www.w3.org/2004/02/skos/core#
PREFIX rdf: http://www.w3.org/1999/02/22-rdf-syntax-ns#
PREFIX dc: http://purl.org/dc/elements/1.1/
PREFIX dbpprop: http://dbpedia.org/property/
PREFIX fn: http://www.w3.org/2005/xpath-functions#
PREFIX dbpedia-owl: http://dbpedia.org/ontology/
PREFIX foaf: http://xmlns.com/foaf/0.1/
PREFIX dcterms: http://purl.org/dc/terms/
select distinct ?title ?u
WHERE
{
?prog dc:title ?title;
dc:created ?created.
?u rdfs:label ?label.
FILTER (bif:isnotnull (bif:strstr (?label, ?title)))
}
ORDER BY DESC (?created)
LIMIT 1
Result:
REPORT
VARCHAR
___
{
Subquery 21
{
Fork 50
{
END Node
After test:
0: if ( 0 1(=) 1 ) then 10 else 3 unkn 10
3: if ( 0 1(=) 1 ) then 10 else 6 unkn 10
6: if ( 0 1(=) 1 ) then 10 else 9 unkn 10
9: BReturn 1
10: BReturn 0
from DB.DBA.RDF_QUAD by RDF_QUAD_POGS 1.1e+002 rows
Key RDF_QUAD_POGS ASC ($27 s-13-1-t0.O, $26 s-13-1-t0.S)
inlined col=554 P = #dc/elements/1.1/title
Local Test
0: if ( 0 1(=) 1 ) then 4 else 3 unkn 4
3: BReturn 1
4: BReturn 0
Precode:
0: $30 __ro2sq := Call __ro2sq ($27 s-13-1-t0.O)
5: BReturn 0
from DB.DBA.RDF_QUAD by RDF_QUAD 0.23 rows
Key RDF_QUAD ASC ($32 s-13-1-t1.O)
inlined col=554 P = #dc/elements/1.1/created , col=553 S = $26
s-13-1-t0.S
from DB.DBA.RDF_QUAD by RDF_QUAD 9.6e+006 rows
Key RDF_QUAD ASC ($37 s-13-1-t2.O, $36 s-13-1-t2.S)
inlined col=554 P = #label
After test:
0: $40 __ro2sq := Call __ro2sq ($37 s-13-1-t2.O)
5: $41 strstr := Call strstr ($40 __ro2sq, $30 __ro2sq)
10: $42 isnotnull := Call isnotnull ($41 strstr)
15: if ( 0 1(=) $42 isnotnull) then 19 else 18 unkn 19
18: BReturn 1
19: BReturn 0
After code:
0: $43 __id2i := Call __id2i ($36 s-13-1-t2.S)
5: BReturn 0
Distinct (HASH) ($27 s-13-1-t0.O, $36 s-13-1-t2.S)
Precode:
0: $49 __ro2sq := Call __ro2sq ($32 s-13-1-t1.O)
5: BReturn 0
Sort (HASH) (TOP 1 ) ($49 __ro2sq) - ($30 __ro2sq, $43 __id2i)
}
top order by node
After code:
0: $22 title := := artm $30 __ro2sq
4: $23 u := := artm $43 __id2i
8: BReturn 0
Subquery Select($22 title, $23 u, $39 DB.DBA.RDF_QUAD s-13-1-t2 spec
5, $34 DB.DBA.RDF_QUAD s-13-1-t1 spec 5, $29 DB.DBA.RDF_QUAD
s-13-1-t0 spec 5)
}
After code:
0: $70 title := Call __ro2sq ($22 title)
5: $71 u := Call __ro2sq ($23 u)
10: BReturn 0
Select ($70 title, $71 u)
}
69 Rows. -- 328 msec.
Best regards,
Robert
On 12.06.2011 15:39, Hugh Williams wrote:
Hi Robert,
I presume you are also Robbet rob...@gmx.de” who posted similar questions
on the vos mailing list ?
Can you use the Virtuoso explain function to generate a compiler query
execution plan so we can so how this is being constructed as detailed at:
http://docs.openlinksw.com
Re: [Virtuoso-users] Clear graph
Hi Alexander, Glad to hear log_enable worked for you and I have created the following tip for all’s benefit on how to delete large graphs: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtTipsAndTricksGuideDeleteLargeGraphs? With regards to the vacuum function did you run a checkpoint afterwards and restart the database. The vacuum function make a best effort at compacting the database tables and indexes but is not always guaranteed to, although I certainly would not expect it to result in a 50% increase in database size ? Probably the best way to compact the database assuming you only have data in the Quad store would be to dump all graphs and reload into and empty database as detailed at: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtDumpLoadRdfGraphs Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 11 Jun 2011, at 08:57, Alexander Sidorov wrote: log_enable 3 worked like a charm. Graph contains zero triples now. After that I tried to run vacuum() to make the size of my database less, but after it had finished its work, the size became even more (was 4.8gb, now 6.8gb). 2011/6/11 Ivan Mikhailov imikhai...@openlinksw.com Hi Alexander log_enable(3,1); delete from rdf_quad where g = iri_to_id (‘graph-name’); Note that this will not even try to remove free-text index data for this graph. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com -- EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image Editing and ensure content is compliant with Accessibility Checking. http://p.sf.net/sfu/ephox-dev2dev___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] bif:contains - using a string variable as search term
Hi Robbet,
What are your actual NumberOfBuffers and MaXDirtyBuffer settings for your 4GB
memory system, I presume those recommended in the Virtuoso Performance Tuning
guide at:
http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtRDFPerformanceTuning
Which are:
NumberOfBuffers = 34
MaxDirtyBuffers = 25
Please confirm ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 10 Jun 2011, at 01:39, Kingsley Idehen wrote:
On 6/10/11 1:28 AM, Robbet wrote:
Hi Kingsley,
changed NumberofBuffers and MaxDirtyBuffer to 4GB recommendation. Did i
miss something?
Dunno if it's only rely in the given hardware or if my query causes the
slowdowns.
If after doing that you don't have improvements. We are down to DBMS
size and host operating system resources i.e., RAM.
Kingsley
Best regards,
Robert
On 10.06.2011 02:20, Kingsley Idehen wrote:
On 6/10/11 1:10 AM, Robbet wrote:
Hi Ivan,
thank you! Looks gut ...
First one seems to work as a Sparql query.
syntax error at bif:strstr before (
FILTER ( BOUND(bif:strstr (?label, ?title) )
But it works without the BOUND keyword.
I'm new to Virtuoso and SQL / SPARQL environment and try to compare
small buch of triples with a dc:title property with the rdfs:label property
from the whole dbpedia dataset stored locally. How do i can increase
search performance?
It takes lot of time (about 5-10 minutes each) at the moment altough it
runs on a quad core, 4gb, ssd system.
The dbpedia dataset is loaded into one graph.
In the meantime I already run the RDF_OBJ ADD rule with (null, null,
'ALL') to enable free text seach index.
I consider there is a way to index the rdfs label property only (no need
to search each dbpedia property or concept) in any way but dunno how.
Did you tweak our INI or stuck with default?
4GB for DBpedia instance is small.
Kingsley
Best regards,
Robert
On 09.06.2011 15:48, Ivan Mikhailov wrote:
Robert,
bif:strstr (?haystack, ?needle) will return an zero-based position of
of ?needle in ?haystack, or NULL if not found [1]. Thus
FILTER (BOUND (bif:strstr (?haystack, ?needle)))
is what you need.
For similar future needs, note
FILTER (BOUND (bif:strcasestr (?haystack, ?needle)))
Recent versions also support (not yet documented)
FILTER (bif:strcontains (?haystack, ?needle))
(strcontains returns boolean, not a position or NULL)
FILTER (bif:starts_with (?dachshund, ?nose))
FILTER (bif:ends_with (?dachshund, ?tail))
Best Regards,
Ivan Mikhailov
OpenLink Software
http://virtuoso.openlinksw.com
[1] http://docs.openlinksw.com/virtuoso/fn_strstr.html
On Thu, 2011-06-09 at 13:30 +0200, Robbet wrote:
Hello,
actually i'm trying to find a solution to compare two string variables
(exact match of the string and if one variable contains the other).
Is it possible (in any way) to use the bif:contains function in this
case? Like variable1 bif:contains variable2 (or the other way round) ?
Already tried it but i receive an expression error.
f.e.
Select *
Where {
?s dc:title ?variable1.
?x rdfs:label ?variable2.
variable1 bif:contains variable2.
}
Best regards,
Robert
--
EditLive Enterprise is the world's most technically advanced content
authoring tool. Experience the power of Track Changes, Inline Image
Editing and ensure content is compliant with Accessibility Checking.
http://p.sf.net/sfu/ephox-dev2dev
___ Virtuoso-users mailing
list Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
--
EditLive Enterprise is the world's most technically advanced content
authoring tool. Experience the power of Track Changes, Inline Image
Editing and ensure content is compliant with Accessibility Checking.
http://p.sf.net/sfu/ephox-dev2dev
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
--
EditLive Enterprise is the world's most technically advanced content
authoring tool. Experience the power of Track Changes, Inline Image
Editing and ensure content is compliant with Accessibility Checking.
http://p.sf.net/sfu/ephox-dev2dev
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
--
Regards,
Kingsley Idehen
Re: [Virtuoso-users] RDF geo queries in open source edition
Hi Babis, This feature is not available in the Virtuoso open source product as it is a commercial product only feature. See the following Feature comparison matrix between the open source and closed source (commercial) products to see the differences between them: http://virtuoso.openlinksw.com/features-comparison-matrix/ The commercial product can is available for a free evaluation period from : http://download.openlinksw.com/virtwiz Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 10 Jun 2011, at 15:01, Babis Doulaverakis wrote: Hello, I am using the open source edition for Virtuoso but I am unable to run the procedure RDF_GEO_FILL(); The server responds with the message Undefined procedure DB.DBA.rdf_geo_fill The same happens when I try to use st_point. When I issue the query SELECT st_point(0,52) as in the manual, the server responds with Undefined procedure DB.DBA.st_point For all the above I logged in to Conductor as user dba Does the Open Source edition support geospatial inference? If it does, what am I doing wrong? Any help is appreciated. Kind regards, Babis -- EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image Editing and ensure content is compliant with Accessibility Checking. http://p.sf.net/sfu/ephox-dev2dev___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Clear graph
Hi Alexander
You can turn transactions off and then back on using the log_enable() function
directly as:
log_enable(3,1);
SPARQL CLEAR GRAPH graph-name;
or as a pragma in the specified query as:
SPARQL DEFINE sql:log-enable 3 CLEAR GRAPH graph-name;
or you can even deleted the triples directly from the RDF_QUAD table with :
log_enable(3,1);
delete from rdf_quad where g = iri_to_id (‘graph-name’);
Let me know if this works for you ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 10 Jun 2011, at 21:16, Alexander Sidorov wrote:
Hi Hugh,
I forgot about that discussion and it really looks like the same problem.
Unfortunately I have no idea how to execute define sql:log-enable NNN
before the query - it doesn't run.
Virtuoso 06.01.3127
About 30kk of triples.
I am pretty sure my query calculates triples count inside a graph.
Regards,
Alexander
2011/6/9 Hugh Williams hwilli...@openlinksw.com
Hi Alexander,
Its been a while, but one of the last conversation we had about a year was
with regards to clear graph issues you were having in which Ivan had
suggested:
Try define sql:log-enable NNN at the beginning of CLEAR GRAPH
statement. That will invoke log_enable (NNN, 1) before the operation
(and restore the log mode back to original value after the operation).
The log_enable() BIF is described in
http://docs.openlinksw.com/virtuoso/fn_log_enable.html
Is this still the same or similar issue ?
What version of Virtuoso are you running currently (virtuoso-t -?) ?
What is the size in triple count of the graph(s) being clear’ed ?
In your query below you are counting the number of graphs, but clear graph
does not remove a graph it just clears its content so the graph count will
remain the same, but the key is has the over all triple count reduced ( ie
select count(*) where {?s ?p ?o}) ? If the graphs where explicitly created
then you can use “drop graph graph-name” instead to remove it, although
even that needs some explaining in terms of the differences between create,
drop, clear and delete Graph as detailed at:
http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtTipsAndTricksGuideCreateGraph
The database size will not reduce when you remove content as once pages are
allocated they are not returned. If running v6 you can try running the
vacuum() function which will perform some compact of the database as detailed
at:
http://docs.openlinksw.com/virtuoso/fn_vacuum.html
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 9 Jun 2011, at 16:39, Alexander Sidorov wrote:
Hello!
I need to clear some graph from Virtuoso database. I execute sparql clear
graph graphName from isql, virtuoso-t takes all my free memory but the
size of database file doesn't become better and even select count(*) from
graph graphName { ?s ?p ?o} doesn't become less. What am I doind wrong?
Regard,
Alexander
--
EditLive Enterprise is the world's most technically advanced content
authoring tool. Experience the power of Track Changes, Inline Image
Editing and ensure content is compliant with Accessibility Checking.
http://p.sf.net/sfu/ephox-dev2dev___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
--
EditLive Enterprise is the world's most technically advanced content
authoring tool. Experience the power of Track Changes, Inline Image
Editing and ensure content is compliant with Accessibility Checking.
http://p.sf.net/sfu/ephox-dev2dev___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Clear graph
Hi Alexander,
Its been a while, but one of the last conversation we had about a year was with
regards to clear graph issues you were having in which Ivan had suggested:
Try define sql:log-enable NNN at the beginning of CLEAR GRAPH
statement. That will invoke log_enable (NNN, 1) before the operation
(and restore the log mode back to original value after the operation).
The log_enable() BIF is described in
http://docs.openlinksw.com/virtuoso/fn_log_enable.html
Is this still the same or similar issue ?
What version of Virtuoso are you running currently (virtuoso-t -?) ?
What is the size in triple count of the graph(s) being clear’ed ?
In your query below you are counting the number of graphs, but clear graph does
not remove a graph it just clears its content so the graph count will remain
the same, but the key is has the over all triple count reduced ( ie select
count(*) where {?s ?p ?o}) ? If the graphs where explicitly created then you
can use “drop graph graph-name” instead to remove it, although even that
needs some explaining in terms of the differences between create, drop, clear
and delete Graph as detailed at:
http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtTipsAndTricksGuideCreateGraph
The database size will not reduce when you remove content as once pages are
allocated they are not returned. If running v6 you can try running the vacuum()
function which will perform some compact of the database as detailed at:
http://docs.openlinksw.com/virtuoso/fn_vacuum.html
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 9 Jun 2011, at 16:39, Alexander Sidorov wrote:
Hello!
I need to clear some graph from Virtuoso database. I execute sparql clear
graph graphName from isql, virtuoso-t takes all my free memory but the size
of database file doesn't become better and even select count(*) from graph
graphName { ?s ?p ?o} doesn't become less. What am I doind wrong?
Regard,
Alexander
--
EditLive Enterprise is the world's most technically advanced content
authoring tool. Experience the power of Track Changes, Inline Image
Editing and ensure content is compliant with Accessibility Checking.
http://p.sf.net/sfu/ephox-dev2dev___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] SPARQL service keyword
Hi Robbet, This is a known issue with the open source builds which is scheduled to be fixed. In the meantime you can grant the necessary privileges as follows: grant select on DB.DBA.SPARQL_SINV_2 to “SPARQL”; grant execute on DB.DBA.SPARQL_SINV_IMP to SPARQL; Then the SPARQL-FED queries should start to work ... Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 4 Jun 2011, at 14:45, Robbet wrote: Hi, when using the SERVICE keyword on my local store (f.e. on dbpedia or linked.mdb endpoint) i got no results (and no errors). Tried the sample query from http://www.snee.com/bobdc.blog/2010/01/federated-sparql-queries.html which works on the Query Demo Page (http://www.sparql.org/query.html). Then i tried the opposite and used my localstore as SERVICE within the dbpedia endpoint. I reveived the following error: Virtuoso 42000 Error SQ200: Must have select privileges on view DB.DBA.SPARQL_SINV_2 What wrong in both cases or what do i have to fix on my local config? Best regards, Robert -- Simplify data backup and recovery for your virtual environment with vRanger. Installation's a snap, and flexible recovery options mean your data is safe, secure and there when you need it. Discover what all the cheering's about. Get your free trial download today. http://p.sf.net/sfu/quest-dev2dev2 ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] RDF - how to interact with other triple stores?
Hi Robbet, The ADO.Net Provider included with the Virtuoso open source release does not include Visual Studio Integration or Entity Frameworks support which are features of the provider included with the commercial product only. You can however simply add a reference to the open source provider in Visual Studio and reference within your C# application with “using OpenLink.Data.Virtuoso; to make use of it as shown in the following tip on using the ADO.Net Provider: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtTipsAndTricksGuideInsertRDFUsingVStudio Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 30 May 2011, at 15:34, Robbet wrote: Hi Hugh, i installed the ADO.net client but unfortunately there is no Virtuoso Data Source in my Visual Studio. moz-screenshot-3.png Any ideas? Best regards, Robert Am 30.05.2011 03:13, schrieb Hugh Williams: Hi Robert, If you have a C# application creating the .n3 files then the Virtuoso ODBC Driver or ADO.Net Provider can be used to make a connection to Virtuoso Server and call the load function directly to load the created .n3 data. Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 30 May 2011, at 00:05, rob...@gmx.de wrote: Hi Hugh, thank you. How can this batch file look like? Dunno how to run these sql commands with isql.exe within a batch file. My C# application creates .n3 files storing them into a definied folder. Then my store is queried using the endpoint. Best regards, Robert Original-Nachricht Datum: Sun, 29 May 2011 18:50:43 +0100 Von: Hugh Williams hwilli...@openlinksw.com An: Robbet rob...@gmx.de CC: virtuoso-users@lists.sourceforge.net Betreff: Re: [Virtuoso-users] RDF - how to interact with other triple stores? Hi Robbet, The initial issue with the load of files for the WebDAV rdf_sink folder is still to be looked into by development. You can call the ld_dir and rdf_loader_run() functions at runtime either in your application or as part of some scheduled batch script to load new data. You can also directly upload N3 files using the Virtuoso TTLP_MT [1] function or its sister function RDF_LOAD_RDFXML_MT [2] for RDF/XML datasets, once again either at runtime or as part of some scheduled batch script to load new data. Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink [1] http://docs.openlinksw.com/virtuoso/fn_ttlp_mt.html [2] http://docs.openlinksw.com/virtuoso/fn_rdf_load_rdfxml_mt.html On 29 May 2011, at 15:11, Robbet wrote: Hello Hugh, is there something new about this issue? In the meantime i need to insert RDF files on runtime (e.g it should be inserted as soon as the .n3 file is created). Is there a possibility to run the isql commands using a batchfile which execute the ld_dir and rdf_loader_run () script command? Other suggestions? WebDAV would be the optimal solution in this case. Best regards, Robert On 11.05.2011 04:38, Hugh Williams wrote: Hi Robbet, I have recreated this issue with the Windows 64bit 6.1.3 open source release and we shall be looking into and fixing this issue ... In the meantime if you have multiple RDF data files to upload into Virtuoso you can also use the bulk loader scripts detailed at: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtBulkRDFLoader Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 11 May 2011, at 00:00, Robbet wrote: Hi Hugh, i'm running Virtuoso 6.1.3.3127 and Windows 7 as WebDav Client. As soon as i set the virt:rdf_graph property to the rdf_sink folder i can't access it anymore with the webdav client or with the webdav repository. error msg: SQL State 42001 - SQL Message SR185: Undefinied procedure DBA.DBA.rdfSink_DAV_SEARCH_ID. What wrong in this case? Thanks and best regards, Robert On 06.05.2011 19:28, Hugh Williams wrote: Hi Robert, You can upload multiple n3, rdf, ttl and other RDF data files via the WebDAV rdf_sink folders as detailed at: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtuosoRDFSinkFolder
Re: [Virtuoso-users] RDF - how to interact with other triple stores?
Hi Robbet, The initial issue with the load of files for the WebDAV rdf_sink folder is still to be looked into by development. You can call the ld_dir and rdf_loader_run() functions at runtime either in your application or as part of some scheduled batch script to load new data. You can also directly upload N3 files using the Virtuoso TTLP_MT [1] function or its sister function RDF_LOAD_RDFXML_MT [2] for RDF/XML datasets, once again either at runtime or as part of some scheduled batch script to load new data. Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink [1] http://docs.openlinksw.com/virtuoso/fn_ttlp_mt.html [2] http://docs.openlinksw.com/virtuoso/fn_rdf_load_rdfxml_mt.html On 29 May 2011, at 15:11, Robbet wrote: Hello Hugh, is there something new about this issue? In the meantime i need to insert RDF files on runtime (e.g it should be inserted as soon as the .n3 file is created). Is there a possibility to run the isql commands using a batchfile which execute the ld_dir and rdf_loader_run () script command? Other suggestions? WebDAV would be the optimal solution in this case. Best regards, Robert On 11.05.2011 04:38, Hugh Williams wrote: Hi Robbet, I have recreated this issue with the Windows 64bit 6.1.3 open source release and we shall be looking into and fixing this issue ... In the meantime if you have multiple RDF data files to upload into Virtuoso you can also use the bulk loader scripts detailed at: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtBulkRDFLoader Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 11 May 2011, at 00:00, Robbet wrote: Hi Hugh, i'm running Virtuoso 6.1.3.3127 and Windows 7 as WebDav Client. As soon as i set the virt:rdf_graph property to the rdf_sink folder i can't access it anymore with the webdav client or with the webdav repository. error msg: SQL State 42001 - SQL Message SR185: Undefinied procedure DBA.DBA.rdfSink_DAV_SEARCH_ID. What wrong in this case? Thanks and best regards, Robert On 06.05.2011 19:28, Hugh Williams wrote: Hi Robert, You can upload multiple n3, rdf, ttl and other RDF data files via the WebDAV rdf_sink folders as detailed at: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtuosoRDFSinkFolder Are these the instructions you have been following as I have just tested myself on Mac OS X mounting my Virtuoso WebDAV folder in the Finder and copying RDF data files into it ? Also, what version virtuoso (virtuoso-t - ?) are you running and what is the WebDAV client you are using to copy files in with ? Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 6 May 2011, at 15:29, Robbet wrote: Hi, i simply trying to access it from my local instance. I will have a look at your SPARQL-FED links. Thanks! Last question :) I'm using WebDAV and trying to sync my .n3 files in the rdf_sink folder (dba home) with my graph. As far as i read the file will be added automatically to my graph(s) when i put them into rdf_sink. But ... they not. I created a link to this source (http://localhost:8890/DAV/home/dba/rdf_sink/) in my file manager and add the n3 files. They will be added only if i upload them using the RDF Store upload function (which allows only one file at a time). Thanks and best regards, Robert On 05.05.2011 20:42, Kingsley Idehen wrote: On 5/5/11 2:23 PM, Robbet wrote: Hi Kingsley, i put http://dbpedia.org as Default Graph IRI in the sparql execution query only. Do i have to load these dbpedia data set into my local named graph? If yes, how to proceed? Did you load DBpedia dataset into your local Virtuoso instance? Or are you simply trying to access DBpedia via SPARQL from your local Virtuoso instance? If the latter then look at SPARQL-FED examples [1]. You can also do SPARQL-Routing whereby you add 3rd part SPARQL protocol endpoint to Virtuoso SPARQL protocol URLs. Links: 1. http://www.delicious.com/kidehen/sparql_fed_demo -- shows SPARQL-FED syntax
Re: [Virtuoso-users] Virtuoso sparql endpoint - setup for external access
Hi Robbet, I have been hosting Virtuoso v5 v6 servers externally using my home dyndns account for years and it has always worked: http://nevisian.dyndns.org/ Nothing special had to be configured on whatever port is runs on as I use to run on port 8890 also. I just setup my dyndns account on ADSL modem, told it to map anything that comes in on port 80 to my local Linux box hosting Virtuoso on port 80 or whatever port it was running on ... Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 24 May 2011, at 23:28, Robbet wrote: Hello, i'm trying to access my Virtuoso sparql endpoint on my local server using a dyndns client. Unfortunately i get no access to xxx.dyndns.org:8890/sparql although the nececessary port is forwarded and open (tried it using an external post scanner). It does not work on the ip too so there is no problem with my dyndns host. Any suggestions? Do i have to change something tin the virtuoso.ini? Miss another port? Thank you! Robert -- vRanger cuts backup time in half-while increasing security. With the market-leading solution for virtual backup and recovery, you get blazing-fast, flexible, and affordable data protection. Download your free trial now. http://p.sf.net/sfu/quest-d2dcopy1 ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] process terminated prematurely after opening the database
Hi Sebastian, Looks as if there is a problem replaying the transaction log file (virtuoso.trx), thus you could try renaming it and attempt a restart again and run and integrity check on the database (backup '/dev/null’;) as detailed in section 6.1.5.5.2 of the documentation [1]. If the data in the trx file is of value, try running moving it back into place and restarting the database again to see if it can be replayed. Looking at the build date of your binary this would appear to be a 6.1.2 build (virtuoso-t -?) and we would recommend upgrading to the latest 6.1.3 in general and/or to see if this problem persists with the latest builds ... Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink [1] http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#backup On 17 May 2011, at 13:05, Sebastian Tramp wrote: Hi, The VDBMS server process of our virtuoso terminated prematurely after opening the database. here are the last words from the log 14:03:26 OpenLink Virtuoso Universal Server 14:03:26 Version 06.01.3127-pthreads for Linux as of Aug 12 2010 14:03:26 uses parts of OpenSSL, PCRE, Html Tidy 14:03:27 Database version 3126 14:03:27 SQL Optimizer enabled (max 1000 layouts) 14:03:29 Compiler unit is timed at 0.001030 msec 14:03:30 Roll forward started 14:03:30 1000 transactions, 239534 bytes replayed (49 %) 14:03:30 GPF: gate.c:129 Zero DP in page_fault_map_sem any idea to fix this? best regards Sebastian Tramp -- Sebastian Tramp - Department of Computer Science; University of Leipzig WebID: http://sebastian.tramp.name Tel. (Fax): +49 341 97 323-66 (-29) -- Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] DateTime literal timezone handling
Hi Timo,
No ETA yet, I shall seek one from development ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 13 May 2011, at 07:39, Timo Westkämper wrote:
Hi Hugh.
Is there any ETA for the bug fix?
Br
Timo Westkämper
On 05/08/2011 01:41 AM, Hugh Williams wrote:
Hi Timo,
This is logged on our internal bugzilla system which external users do not
have access to ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 6 May 2011, at 12:50, Timo Westkämper wrote:
Hi Hugh.
Could you send me a link to the ticket? Thanks.
Br,
Timo Westkämper
On 05/06/2011 02:48 PM, Hugh Williams wrote:
Hi Timo,
This problem and been recreated and reported to development for resolution
...
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 4 May 2011, at 14:52, Timo Westkämper wrote:
Hi.
Sorry for my amount of mails on this list, but I had really lots of
troubles with Virtuoso lately.
I found a reproducable sequence which presents one of my problems with
dateTime literal handling in Virtuoso :
* Insert the following triples via the ttlp function :
ttlp ('http://test http://test1
2000-01-01T00:00:00.000Z^^http://www.w3.org/2001/XMLSchema#dateTime .
http://test http://test2
2000-01-01T00:00:00.000+02:00^^http://www.w3.org/2001/XMLSchema#dateTime
.', '', 'http://test', 0);
* Execute the following query via the Interactive SQL window :
sparql select * where { http://test ?p ?o }
The results are :
http://test1 2000-01-01 00:00:00
http://test2 2000-01-01 00:00:00
* Execute the same query via the SPARQL query form :
select * where { http://test ?p ?o }
The results are :
http://test1 2000-01-01T00:00:00Z
http://test2 2000-01-01T00:00:00+02:00
I am having the same issue when using SPARQL via JDBC. The timezone
offset is ignored when using SPARQL via JDBC or the Interactive SQL form.
Br,
Timo Westkämper
--
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network
management toolset available today. Delivers lowest initial
acquisition cost and overall TCO of any competing solution.
http://p.sf.net/sfu/whatsupgold-sd___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
--
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network
management toolset available today. Delivers lowest initial
acquisition cost and overall TCO of any competing solution.
http://p.sf.net/sfu/whatsupgold-sd___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
--
Achieve unprecedented app performance and reliability
What every C/C++ and Fortran developer should know.
Learn how Intel has extended the reach of its next-generation tools
to help boost performance applications - inlcuding clusters.
http://p.sf.net/sfu/intel-dev2devmay___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Sorting key too long
Hi Jonas,
Hmmm, I think I hadn’t specified the graph name correctly previously, but now
can get the result and do get the sorting key too long” error running in the
Conductor or from SQL when the LIMIT it removed. I have reported to
development to look into and will let you know when we have a fix ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 16 May 2011, at 19:55, Jonas Brekle wrote:
There should be 1873 results without the limit, stange...
Am Sonntag, den 15.05.2011, 14:47 +0100 schrieb Hugh Williams:
Hi Jonas,
When I run the query below against the Conductor or command line isql
program with or without the “LIMIT 1000” option have loaded the “lod2.ttl”
dataset you provided in all cases the same one row is returned:
rdf:RDF
xmlns:rdf=http://www.w3.org/1999/02/22-rdf-syntax-ns#;
xmlns:rs=http://www.w3.org/2005/sparql-results#;
xmlns:xsd=http://www.w3.org/2001/XMLSchema#;
rs:results rdf:nodeID=rset
/rs:results
/rdf:RDF
Is this the expect data to be returned ?
Note I am using a Virtuoso open source 6.1.3 build, what Virtuoso release
(virtuoso-t -?) are you using ?
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 11 May 2011, at 21:07, Jonas Brekle wrote:
Hi,
your right, the query gives a error, i mistakenly shortened it too much
and I thought it would make no difference (sorry). the actual query used
in the application is a bit longer:
CALL DB.DBA.SPARQL_EVAL('define output:format RDF/XML
SELECT DISTINCT ?s ?p ?o
FROM http://lod2.eu/
WHERE
{ ?s ?p ?o .
OPTIONAL { ?s http://www.w3.org/1999/02/22-rdf-syntax-ns#type ?o2 } .
FILTER (!bound(?o2) || (!sameTerm(?o2,
http://www.w3.org/2002/07/owl#Ontology) !sameTerm(?o2,
http://www.w3.org/2002/07/owl#Class) !sameTerm(?o2,
http://www.w3.org/2000/01/rdf-schema#Datatype) !sameTerm(?o2,
http://www.w3.org/2002/07/owl#AnnotationProperty) !sameTerm(?o2,
http://www.w3.org/2002/07/owl#DatatypeProperty) !sameTerm(?o2,
http://www.w3.org/2002/07/owl#ObjectProperty)))} ORDER BY ?s ?p ?o
LIMIT 1000
', NULL, 0)
and this query doesnt trigger the error (also not in the conductor) but
is unsorted via odbc (via the conductor its fine).
btw: if i remove the limit, the error appears. how does that make sense?
thanks for your effort,
jonas
Am Mittwoch, den 11.05.2011, 13:44 +0100 schrieb Hugh Williams:
Hi Jonas,
Also, you indicate this error does not occur via ODBC ie the SQL Virtuoso
interface, but it does for me:
SQL sparql select * from http://localhost:8862/lod2.ttl where {?s ?p ?o
} ORDER BY ?s ?p ?o;
*** Error 22026: [Virtuoso Driver][Virtuoso Server]SR...: Sorting key too
long in order by key, exceeds 1900 bytes.
at line 2 of Top-Level:
sparql select * from http://localhost:8862/lod2.ttl where {?s ?p ?o }
ORDER BY ?s ?p ?o
SQL
so curious as to how this is being run in OntoWiki via ODBC ?
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 11 May 2011, at 13:30, Hugh Williams wrote:
Hi Jonas,
I have been able to recreate this locally, we are looking into this and
will get back to you ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
PS: You need to register on the virtuoso-users mailing list to prevent
you posts from being moderated before allowed on:
http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VOSMailingLists
On 10 May 2011, at 14:24, Jonas Brekle wrote:
Hi,
i have a rdf model which contains very long literals (the lod2.eu
website model - see attacchments). When i send the sparql query:
SELECT * FROM http://lod2.eu/ WHERE {?s ?p ?o} ORDER BY ?s ?p ?o
via the conductor, it tells me
22026 Error SR...: Sorting key too long in order by key, exceeds 1900
bytes.
when i do the same query via odbc (in ontowiki) i get no error but a
unsorted result...
this is crucial to our rdf/xml serialization algorithm.
can you recomend anything to us? or fix this somehow (i know its
probably intended so, but we could also live with a config option + a
slower query)
regards,
Jonas
AKSW
lod2.ttl--
Achieve unprecedented app performance and reliability
What every C/C++ and Fortran developer should know.
Learn how Intel has extended the reach
Re: [Virtuoso-users] Sorting key too long
Hi Jonas,
Also, you indicate this error does not occur via ODBC ie the SQL Virtuoso
interface, but it does for me:
SQL sparql select * from http://localhost:8862/lod2.ttl where {?s ?p ?o }
ORDER BY ?s ?p ?o;
*** Error 22026: [Virtuoso Driver][Virtuoso Server]SR...: Sorting key too long
in order by key, exceeds 1900 bytes.
at line 2 of Top-Level:
sparql select * from http://localhost:8862/lod2.ttl where {?s ?p ?o } ORDER
BY ?s ?p ?o
SQL
so curious as to how this is being run in OntoWiki via ODBC ?
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 11 May 2011, at 13:30, Hugh Williams wrote:
Hi Jonas,
I have been able to recreate this locally, we are looking into this and will
get back to you ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
PS: You need to register on the virtuoso-users mailing list to prevent you
posts from being moderated before allowed on:
http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VOSMailingLists
On 10 May 2011, at 14:24, Jonas Brekle wrote:
Hi,
i have a rdf model which contains very long literals (the lod2.eu
website model - see attacchments). When i send the sparql query:
SELECT * FROM http://lod2.eu/ WHERE {?s ?p ?o} ORDER BY ?s ?p ?o
via the conductor, it tells me
22026 Error SR...: Sorting key too long in order by key, exceeds 1900 bytes.
when i do the same query via odbc (in ontowiki) i get no error but a
unsorted result...
this is crucial to our rdf/xml serialization algorithm.
can you recomend anything to us? or fix this somehow (i know its
probably intended so, but we could also live with a config option + a
slower query)
regards,
Jonas
AKSW
lod2.ttl--
Achieve unprecedented app performance and reliability
What every C/C++ and Fortran developer should know.
Learn how Intel has extended the reach of its next-generation tools
to help boost performance applications - inlcuding clusters.
http://p.sf.net/sfu/intel-dev2devmay___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Problems loading large .ttl file
Hi Peter,
What is the actual error reported in the log ?
Also, have you tried using the complementary “load_graph()” functions to load
the dump graphs as detailed in the documentation on dumping and load graphs at:
http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtDumpLoadRdfGraphs
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 9 May 2011, at 20:23, Peter DeVries wrote:
Sorry I should have been more clear.
I create a dump file using this command.
dump_one_graph('urn:org:linkedopenspeciesdata:dataspace:taxonconcept',
'txn_ses');
I the outputed .ttl file and change the name to txn_ses.ttl and then gzip it
before copying it to my web server and public endpoint.
Once it is on the public endpoint I ungzip it.
I looked though the logs and it seems to indicate that the file exceeded some
length limit.
I suspect the length limit is one of the settings that you configure in the
virtuoso.ini file.
On the same public endpoint system the procedure that loads a directory of
.rdf files with the same data works.
Thanks,
- Pete
On Sun, May 8, 2011 at 8:18 PM, Hugh Williams hwilli...@openlinksw.com
wrote:
Peter,
On 8 May 2011, at 18:26, Peter DeVries wrote:
Hi,
I am trying to upload a new version of my TaxonConcept dataset. (VOS 6.1.3)
There is one large .ttl file that is giving me problems.
On my staging machine I run this procedure which loads each of the ~100,000
rdf files. It seems to work
create procedure ld_txn_se ()
{
ld_dir ('/home/lod_data/ses', '*.rdf',
'urn:org:linkedopenspeciesdata:dataspace:taxonconcept');
rdf_loader_run ();
commit work;
log_message ('ses loaded,');
VT_INC_INDEX_DB_DBA_RDF_OBJ ();
commit work;
s_rank();
commit work;
}
;
I then copy the outputed .ttl file to my public server and try to load it
with this.
[Hugh] I am not sure what you mean by outputed .ttl file” , what created
this ttl file ?
create procedure ld_txn_sp_oc ()
{
ld_file ('/home/lod_data/txn_ttl/txn_ses.ttl',
'urn:org:linkedopenspeciesdata:dataspace:taxonconcept');
rdf_loader_run ();
commit work;
log_message ('txn_ses.ttl loaded,');
VT_INC_INDEX_DB_DBA_RDF_OBJ ();
commit work;
ld_file ('/home/lod_data/txn_ttl/txn_ocs.ttl',
'urn:org:linkedopenspeciesdata:dataspace:taxonconcept');
rdf_loader_run ();
commit work;
log_message ('txn_ocs.ttl loaded,');
VT_INC_INDEX_DB_DBA_RDF_OBJ ();
commit work;
s_rank();
commit work;
}
;
The smaller txn_ocs.ttl file seems to load but when I check how many
species concepts I get it returns only ~775.
The txn_ses.ttl file is about 1.4 GB so it is much large than the 12MB
txn_ocs.ttl file.
I suspect that there is some setting in the virtuoso.ini file that will
allow me to import the 1.4GB file?
* I can make a tar of the ses directory, gzip it and moving to the public
server to load the data but I suspect that anyone who tries to load my data
set might experience the same problem.
Any suggestions?
[Hugh] I can’t think of any configuration file settings that would affect
the loading of large ttl files. Are any errors in the virtuoso.log file post
the attempt to load and also what is reported in the “DB.DBA.load_list table
which records files loaded and an errors that might have occurred during the
load ?
Regards
Hugh
Thanks,
- Pete
Pete DeVries
Department of Entomology
University of Wisconsin - Madison
445 Russell Laboratories
1630 Linden Drive
Madison, WI 53706
Email: pdevr...@wisc.edu
TaxonConceptGeoSpecies Knowledge Bases
A Semantic Web, Linked Open Data Project
--
--
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network
management toolset available today. Delivers lowest initial
acquisition cost and overall TCO of any competing solution.
http://p.sf.net/sfu/whatsupgold-sd___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
--
Pete DeVries
Department of Entomology
University of Wisconsin - Madison
445 Russell Laboratories
1630 Linden Drive
Madison, WI 53706
Email: pdevr...@wisc.edu
TaxonConceptGeoSpecies Knowledge Bases
A Semantic Web, Linked Open Data
Re: [Virtuoso-users] Inference performance
Hi Roberto,
Can you please provide the content of the [SPARQL] section of the
“virtuoso.ini” file so we can see what setting are in place.
Is your ontology and data available for public download ? If so please provide
the location they can be downloaded from, which datasets to load and we can
attempt a recreation in-house.
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 9 May 2011, at 23:56, Roberto García wrote:
Please provide the command used for creating the rule sets and confirm they
exist in the “sys_rdf_schema” table ?
Yes, I used
rdfs_rule_set('http://semantic.eurobau.com/data/schema/rules/','http://semantic.eurobau.com/data/schema/');
And they exist in that table.
Based on the details below is would appear you have about 10 triples
loaded in total and the status output indicates that only abt 16 of the
50 buffers are allocated with no locks etc so the system seems pretty
much idle and thus should be performant. To see how performant the system
is can you try counting all the triples in the store with the command
“select * from where {?s ?p ?o}” and see how long it takes. How long do
these queries below take to run if the inference rule is removed ? It would
also be interesting to see the compiler execution plan for these queries
using the Virtuoso explain() function as detailed at:
I counted all triples in virtuoso with select count(*) where {?s ?p
?o}. The result is 117550498 and it took more or less 15 seconds.
For the Eurobau data graph (http://semantic.eurobau.com/data/) the
count is 89911 and 1 or 2 secs.
For the Eurobau schema graph
(http://semantic.eurobau.com/data/schema/) 79544 triples and also 1 or
2 seconds.
If there is no inference, the query is almost instantaneous and
correctly responds 0:
SELECT count(*)
FROM http://semantic.eurobau.com/data/
WHERE
{ ?x a http://purl.org/goodrelations/v1#ProductOrService }
And here is what I get with fn_explain (inference enabled):
explain('sparql define input:inference
http://semantic.eurobau.com/data/schema/rules/; SELECT count(?x)
FROM http://semantic.eurobau.com/data/ FROM
http://semantic.eurobau.com/data/schema/ WHERE { ?x a
http://purl.org/goodrelations/v1#ProductOrService }');
{
Fork 34
{
RDF Inference subproperty iterates $28 inferred
o= none p= #type
RDF Inference subclass iterates $31 inferred
o= #ProductOrService p= none
from DB.DBA.RDF_QUAD by RDF_QUAD 1.2 rows
Key RDF_QUAD ASC ($22 s-1-1-t0.S, $21 s-1-1-t0.G)
inlined col=551 P = $28 inferred
0
Local Test
0: $25 one_of_these := Call one_of_these ($21 s-1-1-t0.G, #data/
, #data/schema/ )
5: if ( 0 2() $25 one_of_these) then 8 else 9 unkn 9
8: BReturn 1
9: BReturn 0
Local Code
0: if ($22 s-1-1-t0.S 16( IS NULL ) 0 ) then 3 else 8 unkn 8
3: $32 callretSearchedCASE := := artm 0
7: Jump 12 (level=0)
8: $32 callretSearchedCASE := := artm 1
12: $33 one_of_these := Call one_of_these ($21 s-1-1-t0.G,
#data/ , #data/schema/ )
17: if ($32 callretSearchedCASE 16( IS NULL ) none ) then 32
else 20 unkn 32
20: if ($36 callret-0 16( IS NULL ) none ) then 23 else 28 unkn 32
23: $36 callret-0 := := artm $32 callretSearchedCASE
27: Jump 32 (level=0)
28: $36 callret-0 := artm $36 callret-0 + $32 callretSearchedCASE
32: BReturn 0
}
Select ($36 callret-0, $24 DB.DBA.RDF_QUAD s-1-1-t0 spec 5)
}
Best,
Roberto
--
Achieve unprecedented app performance and reliability
What every C/C++ and Fortran developer should know.
Learn how Intel has extended the reach of its next-generation tools
to help boost performance applications - inlcuding clusters.
http://p.sf.net/sfu/intel-dev2devmay
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] DateTime literal timezone handling
Hi Timo,
This is logged on our internal bugzilla system which external users do not have
access to ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 6 May 2011, at 12:50, Timo Westkämper wrote:
Hi Hugh.
Could you send me a link to the ticket? Thanks.
Br,
Timo Westkämper
On 05/06/2011 02:48 PM, Hugh Williams wrote:
Hi Timo,
This problem and been recreated and reported to development for resolution
...
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 4 May 2011, at 14:52, Timo Westkämper wrote:
Hi.
Sorry for my amount of mails on this list, but I had really lots of
troubles with Virtuoso lately.
I found a reproducable sequence which presents one of my problems with
dateTime literal handling in Virtuoso :
* Insert the following triples via the ttlp function :
ttlp ('http://test http://test1
2000-01-01T00:00:00.000Z^^http://www.w3.org/2001/XMLSchema#dateTime .
http://test http://test2
2000-01-01T00:00:00.000+02:00^^http://www.w3.org/2001/XMLSchema#dateTime
.', '', 'http://test', 0);
* Execute the following query via the Interactive SQL window :
sparql select * where { http://test ?p ?o }
The results are :
http://test1 2000-01-01 00:00:00
http://test2 2000-01-01 00:00:00
* Execute the same query via the SPARQL query form :
select * where { http://test ?p ?o }
The results are :
http://test12000-01-01T00:00:00Z
http://test22000-01-01T00:00:00+02:00
I am having the same issue when using SPARQL via JDBC. The timezone offset
is ignored when using SPARQL via JDBC or the Interactive SQL form.
Br,
Timo Westkämper
--
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network
management toolset available today. Delivers lowest initial
acquisition cost and overall TCO of any competing solution.
http://p.sf.net/sfu/whatsupgold-sd___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
--
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network
management toolset available today. Delivers lowest initial
acquisition cost and overall TCO of any competing solution.
http://p.sf.net/sfu/whatsupgold-sd___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Accessing SPARQL result sets via JDBC
Hi Timo, Yes you can access SPARQL results sets via the JDBC driver using the ExtendedString etc method as detailed in section 7.4.3.5. Extension datatype for RDF” of the online documentation at: http://docs.openlinksw.com/virtuoso/VirtuosoDriverJDBC.html Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 4 May 2011, at 12:08, Timo Westkämper wrote: Hi. Is it possible to access SPARQL results via JDBC using proper Node representation (ExtendedString, RdfBox etc) and not the SQL types? I did not yet manage to do this via the output:valmode. My use case is to get the persisted timezone offset of an xsd:dateTime literal. When accessing the literal via the java.sql.Timestamp instance, it is not possible. Br, Timo Westkämper -- WhatsUp Gold - Download Free Network Management Software The most intuitive, comprehensive, and cost-effective network management toolset available today. Delivers lowest initial acquisition cost and overall TCO of any competing solution. http://p.sf.net/sfu/whatsupgold-sd ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] DateTime literal timezone handling
Hi Timo,
This problem and been recreated and reported to development for resolution ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 4 May 2011, at 14:52, Timo Westkämper wrote:
Hi.
Sorry for my amount of mails on this list, but I had really lots of troubles
with Virtuoso lately.
I found a reproducable sequence which presents one of my problems with
dateTime literal handling in Virtuoso :
* Insert the following triples via the ttlp function :
ttlp ('http://test http://test1
2000-01-01T00:00:00.000Z^^http://www.w3.org/2001/XMLSchema#dateTime .
http://test http://test2
2000-01-01T00:00:00.000+02:00^^http://www.w3.org/2001/XMLSchema#dateTime
.', '', 'http://test', 0);
* Execute the following query via the Interactive SQL window :
sparql select * where { http://test ?p ?o }
The results are :
http://test1 2000-01-01 00:00:00
http://test2 2000-01-01 00:00:00
* Execute the same query via the SPARQL query form :
select * where { http://test ?p ?o }
The results are :
http://test1 2000-01-01T00:00:00Z
http://test2 2000-01-01T00:00:00+02:00
I am having the same issue when using SPARQL via JDBC. The timezone offset is
ignored when using SPARQL via JDBC or the Interactive SQL form.
Br,
Timo Westkämper
--
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network
management toolset available today. Delivers lowest initial
acquisition cost and overall TCO of any competing solution.
http://p.sf.net/sfu/whatsupgold-sd___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] RDF - how to interact with other triple stores?
Hi Robert,
You can upload multiple n3, rdf, ttl and other RDF data files via the WebDAV
rdf_sink folders as detailed at:
http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtuosoRDFSinkFolder
Are these the instructions you have been following as I have just tested
myself on Mac OS X mounting my Virtuoso WebDAV folder in the Finder and copying
RDF data files into it ?
Also, what version virtuoso (virtuoso-t - ?) are you running and what is the
WebDAV client you are using to copy files in with ?
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 6 May 2011, at 15:29, Robbet wrote:
Hi,
i simply trying to access it from my local instance.
I will have a look at your SPARQL-FED links. Thanks!
Last question :)
I'm using WebDAV and trying to sync my .n3 files in the rdf_sink folder (dba
home) with my graph.
As far as i read the file will be added automatically to my graph(s) when i
put them into rdf_sink. But ... they not.
I created a link to this source
(http://localhost:8890/DAV/home/dba/rdf_sink/) in my file manager and add the
n3 files.
They will be added only if i upload them using the RDF Store upload function
(which allows only one file at a time).
Thanks and best regards,
Robert
On 05.05.2011 20:42, Kingsley Idehen wrote:
On 5/5/11 2:23 PM, Robbet wrote:
Hi Kingsley,
i put http://dbpedia.org as Default Graph IRI in the sparql execution query
only.
Do i have to load these dbpedia data set into my local named graph?
If yes, how to proceed?
Did you load DBpedia dataset into your local Virtuoso instance? Or are you
simply trying to access DBpedia via SPARQL from your local Virtuoso
instance? If the latter then look at SPARQL-FED examples [1]. You can also
do SPARQL-Routing whereby you add 3rd part SPARQL protocol endpoint to
Virtuoso SPARQL protocol URLs.
Links:
1. http://www.delicious.com/kidehen/sparql_fed_demo -- shows SPARQL-FED
syntax based examples for querying external sparql endpoints from your local
virtuoso instance
2.
http://answers.semanticweb.com/questions/9173/different-results-at-differnt-endpoints-while-using-sparql-query?page=1#9181
-- post I made on answers.semanticweb.com about SPARQL-Routing and
SPARQL-FED via Virtuoso .
Kingsley
Best regards,
Robert
On 05.05.2011 20:19, Kingsley Idehen wrote:
On 5/5/11 1:25 PM, Robbet wrote:
Hi,
i do a simple query on dbpedia sparql endpoint and receive the correct
results.
When i do same on my local Virtuoso i get no results besides the top row
(concept).
There is no error msgs or something like this.
Same on http://dbpedia.org/sparql:
SELECT DISTINCT ?concept
WHERE {
?s a ?concept .
} LIMIT 5
Result:
concept
http://www.w3.org/2002/07/owl#Thing
http://www.w3.org/2002/07/owl#Class
http://www.w3.org/2002/07/owl#ObjectProperty
http://www.w3.org/1999/02/22-rdf-syntax-ns#Property
http://www.w3.org/2002/07/owl#Ontology
Whats from with me? :)
Into what local Named Graph did you load the DBpedia dataset?
Kingsley
Best regards,
Robert
On 05.05.2011 13:38, Hugh Williams wrote:
Hi Robbet,
What exactly is the method or query being run that is not allowing the
the querying of the remote graph, and what if any errors are reported ?
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 5 May 2011, at 01:15, Robbet wrote:
Hi,
thank you. Will check this out.
One further question:
The SPARQL execution within Virtuoso does not allow me query foreign
graphs (f.e http://dbpedia.org).
I get no results at all. For testing i already did the same query using
the DBpedia sparql endpoint - http://dbpedia.org/sparql - so there
nothing wrong with the query itself.
What should i consider? Is there something wrong with my network
configuration or my Virtuoso config?
Thank you!
Best regards,
Robert
On 03.05.2011 02:23, Hugh Williams wrote:
Hi Robert,
Virtuoso extends SPARQL so it is possible to download RDF resource
from a given IRI, parse them and store the resulting triples in a
graph, all three operations will be performed during the SPARQL query
execution as detailed in [1]. The Virtuoso uriburner.com service at
[2] is a demonstration site that can should this in action. SPARQL-FED
can also be used to query remote SPARQL end points at detailed at [3].
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
[1] http
Re: [Virtuoso-users] RDF - how to interact with other triple stores?
Hi Robbet, What exactly is the method or query being run that is not allowing the the querying of the remote graph, and what if any errors are reported ? Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 5 May 2011, at 01:15, Robbet wrote: Hi, thank you. Will check this out. One further question: The SPARQL execution within Virtuoso does not allow me query foreign graphs (f.e http://dbpedia.org). I get no results at all. For testing i already did the same query using the DBpedia sparql endpoint - http://dbpedia.org/sparql - so there nothing wrong with the query itself. What should i consider? Is there something wrong with my network configuration or my Virtuoso config? Thank you! Best regards, Robert On 03.05.2011 02:23, Hugh Williams wrote: Hi Robert, Virtuoso extends SPARQL so it is possible to download RDF resource from a given IRI, parse them and store the resulting triples in a graph, all three operations will be performed during the SPARQL query execution as detailed in [1]. The Virtuoso uriburner.com service at [2] is a demonstration site that can should this in action. SPARQL-FED can also be used to query remote SPARQL end points at detailed at [3]. Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink [1] http://docs.openlinksw.com/virtuoso/rdfiridereferencing.html [2] http://uriburner.com/ [3] http://www.w3.org/TR/sparql11-federated-query/ On 2 May 2011, at 11:49, rob...@gmx.de wrote: Hi everybody, i'm Robert and i'm new into Virtuoso software. As a part of my project i'm working with RDF data (n3 notated information) and need to link these data with other stores. I'm already uploaded my data (lots of rdf files) into my own virtuoso triple store and did a few sparql queries to test it. Now i need some help how to go on. How do i know interact with other (virtuoso running) triple stores to get linked data? Would be great if someone could give me a hint :) Thanks in advance and best regards, Robert -- Empfehlen Sie GMX DSL Ihren Freunden und Bekannten und wir belohnen Sie mit bis zu 50,- Euro! https://freundschaftswerbung.gmx.de -- WhatsUp Gold - Download Free Network Management Software The most intuitive, comprehensive, and cost-effective network management toolset available today. Delivers lowest initial acquisition cost and overall TCO of any competing solution. http://p.sf.net/sfu/whatsupgold-sd ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users -- WhatsUp Gold - Download Free Network Management Software The most intuitive, comprehensive, and cost-effective network management toolset available today. Delivers lowest initial acquisition cost and overall TCO of any competing solution. http://p.sf.net/sfu/whatsupgold-sd ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Primary key not found in delete error cause
Hi Bharath,
I doubt the data is being loaded incorrectly but sounds as an index on the
RDF_QUAD table might be corrupt, which case you could try dropping and
recreating them as detailed at:
http://docs.openlinksw.com/virtuoso/rdfperformancetuning.html#rdfperfrdfscheme
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 2 May 2011, at 08:14, Bharath V wrote:
Hi,
I am using the below code snippet to load a rdf/xml file into virtuoso. It
loads the data correctly, but while deleting(clear graph
http://www.load.org) the graph gives
Error : SQLState: 42S12 Message: SR201: Primary key not found in delete
.Is this a problem with the way the data is being loaded into virtuoso or a
different problem.
Code:
Model model = ModelFactory.createDefaultModel();
model.read(file:\\load.xml);
StmtIterator stmtIterator = model.listStatements();
ListTriple triples = new LinkedListTriple();
while (stmtIterator.hasNext()) {
triples.add(stmtIterator.nextStatement().asTriple());}
VirtGraph virtGraph = new VirtGraph(http://www.load.org;, DB_URL, dba,
dba);
BulkUpdateHandler bulkUpdateHandler = virtGraph.getBulkUpdateHandler();
TransactionHandler transactionHandler = virtGraph.getTransactionHandler();
transactionHandler.begin();
bulkUpdateHandler.add(triples);
transactionHandler.commit();
Thank You,
Bharath
--
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network
management toolset available today. Delivers lowest initial
acquisition cost and overall TCO of any competing solution.
http://p.sf.net/sfu/whatsupgold-sd___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] RDF - how to interact with other triple stores?
Hi Robert, Virtuoso extends SPARQL so it is possible to download RDF resource from a given IRI, parse them and store the resulting triples in a graph, all three operations will be performed during the SPARQL query execution as detailed in [1]. The Virtuoso uriburner.com service at [2] is a demonstration site that can should this in action. SPARQL-FED can also be used to query remote SPARQL end points at detailed at [3]. Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink [1] http://docs.openlinksw.com/virtuoso/rdfiridereferencing.html [2] http://uriburner.com/ [3] http://www.w3.org/TR/sparql11-federated-query/ On 2 May 2011, at 11:49, rob...@gmx.de wrote: Hi everybody, i'm Robert and i'm new into Virtuoso software. As a part of my project i'm working with RDF data (n3 notated information) and need to link these data with other stores. I'm already uploaded my data (lots of rdf files) into my own virtuoso triple store and did a few sparql queries to test it. Now i need some help how to go on. How do i know interact with other (virtuoso running) triple stores to get linked data? Would be great if someone could give me a hint :) Thanks in advance and best regards, Robert -- Empfehlen Sie GMX DSL Ihren Freunden und Bekannten und wir belohnen Sie mit bis zu 50,- Euro! https://freundschaftswerbung.gmx.de -- WhatsUp Gold - Download Free Network Management Software The most intuitive, comprehensive, and cost-effective network management toolset available today. Delivers lowest initial acquisition cost and overall TCO of any competing solution. http://p.sf.net/sfu/whatsupgold-sd ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Primary key not found in delete error cause
Hi Bharath,
I would suggest rebuilding the index and then see if the delete from graph is
still causing a crash. Also do confirm you are running the latest 6.1.3 open
source release, use the “virtuoso-t -?” command to determine the version.
If a core file being produced when a crash occurs you can use gdb to create a
stacktrace to determine the cause if nothing is being written to the log.
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 3 May 2011, at 06:19, Bharath V wrote:
Thanks Hugh for the reply i will check the virtuoso's index .
I have one more doubt when ever we use the delete query :
-- SPARQL DELETE FROM GRAPH http://examp.org { ?s ?p ?o } FROM
http://examp.org WHERE { ?s ?p ?o.})
the whole virtuoso crashes and there is no log also to know about the issues
or why its crashing.
Regards,
Bharath
From: Hugh Williams hwilli...@openlinksw.com
To: Bharath V bhar...@metaome.com
Cc: Virtuoso-users@lists.sourceforge.net; Ramkumar Nandakumar
r...@metaome.com; a...@metaome.com
Sent: Tue, 3 May, 2011 4:54:53 AM
Subject: Re: [Virtuoso-users] Primary key not found in delete error cause
Hi Bharath,
I doubt the data is being loaded incorrectly but sounds as an index on the
RDF_QUAD table might be corrupt, which case you could try dropping and
recreating them as detailed at:
http://docs.openlinksw.com/virtuoso/rdfperformancetuning.html#rdfperfrdfscheme
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 2 May 2011, at 08:14, Bharath V wrote:
Hi,
I am using the below code snippet to load a rdf/xml file into virtuoso. It
loads the data correctly, but while deleting(clear graph
http://www.load.org) the graph gives
Error : SQLState: 42S12 Message: SR201: Primary key not found in delete
.Is this a problem with the way the data is being loaded into virtuoso or a
different problem.
Code:
Model model = ModelFactory.createDefaultModel();
model.read(file:\\load.xml);
StmtIterator stmtIterator = model.listStatements();
ListTriple triples = new LinkedListTriple();
while (stmtIterator.hasNext()) {
triples.add(stmtIterator.nextStatement().asTriple());}
VirtGraph virtGraph = new VirtGraph(http://www.load.org;, DB_URL, dba,
dba);
BulkUpdateHandler bulkUpdateHandler = virtGraph.getBulkUpdateHandler();
TransactionHandler transactionHandler = virtGraph.getTransactionHandler();
transactionHandler.begin();
bulkUpdateHandler.add(triples);
transactionHandler.commit();
Thank You,
Bharath
--
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network
management toolset available today. Delivers lowest initial
acquisition cost and overall TCO of any competing solution.
http://p.sf.net/sfu/whatsupgold-sd___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Backing-up Virtuoso
Hi Alexandre,
The backup files would get written the the master node database working
directory ie cluster_01 in your case or you can specify a directory for the
files to be written to with the optional 4th parameter of this function as
detailed in the function reference guide at:
http://docs.openlinksw.com/virtuoso/fn_backup_online.html
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 3 May 2011, at 00:30, Alexandre Passant wrote:
Hi,
I'm trying to do some backups of my setup.
I used the instructions from http://docs.openlinksw.com/virtuoso/backup.html
to do online backup with
backup_online ('virt-inc_dump_#', 150);
Where is the backup file stored ?
Also, is there an easy way to create a full NQUAD archive from the content of
my RDF store ?
Thanks,
Alex.
--
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network
management toolset available today. Delivers lowest initial
acquisition cost and overall TCO of any competing solution.
http://p.sf.net/sfu/whatsupgold-sd___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Hibernate virtuoso?
HI Hoan, The error doesn’t really mean anything to me. Please provide the complete output of running one of the example programs you refer to which I presume are the one in the documentation at: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtJdbcHibernate#Building%20and%20running%20the%20example which work for me with the leatest Virtuoso 6.2 components against hibernate 3.3: $ which ant /usr/bin/ant hugh-williams-computer-3932:ex1 hughwilliams$ ant run Buildfile: /Users/hughwilliams/hibernate/ex1/build.xml clean: [delete] Deleting directory /Users/hughwilliams/hibernate/ex1/bin [mkdir] Created dir: /Users/hughwilliams/hibernate/ex1/bin copy-resources: [copy] Copying 3 files to /Users/hughwilliams/hibernate/ex1/bin [copy] Copied 2 empty directories to 1 empty directory under /Users/hughwilliams/hibernate/ex1/bin compile: [javac] /Users/hughwilliams/hibernate/ex1/build.xml:21: warning: 'includeantruntime' was not set, defaulting to build.sysclasspath=last; set to false for repeatable builds [javac] Compiling 3 source files to /Users/hughwilliams/hibernate/ex1/bin run: [java] Hibernate: insert into Event (EVENT_DATE, title) values (?, ?) [java] Hibernate: select identity_value() [java] Hibernate: insert into Event (EVENT_DATE, title) values (?, ?) [java] Hibernate: select identity_value() [java] Hibernate: select event0_.EVENT_ID as EVENT1_0_, event0_.EVENT_DATE as EVENT2_0_, event0_.title as title0_ from Event event0_ [java] Event: My Event1 Time: 2011-04-25 12:51:08.0 [java] Event: My Event2 Time: 2011-04-25 12:51:13.0 BUILD SUCCESSFUL Total time: 12 seconds $ Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 25 Apr 2011, at 11:23, Nguyen Mau Quoc Hoan wrote: Hi. I'm doing some Hibernate examples from Virtuoso document but I failed to run it. I always got the same error whatever virtuoso hibernate project. This is the error report: Exception in thread main java.lang.ExceptionInInitializerError at MyUtil.HibernateUtil.clinit(HibernateUtil.java:16) at events.EventManager.createAndStoreEvent(Unknown Source) at events.EventManager.main(Unknown Source) Caused by: java.lang.NoSuchFieldError: INTEGER at virtuoso.hibernate.VirtuosoDialect.init(Unknown Source) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at java.lang.Class.newInstance0(Class.java:355) at java.lang.Class.newInstance(Class.java:308) at org.hibernate.dialect.resolver.DialectFactory.constructDialect(DialectFactory.java:156) at org.hibernate.dialect.resolver.DialectFactory.buildDialect(DialectFactory.java:99) at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:117) at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2836) at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2832) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1843) at MyUtil.HibernateUtil.clinit(HibernateUtil.java:12) What's problem I got here? I already downloaded all the necessary library. Thanks in advance. -- Fulfilling the Lean Software Promise Lean software platforms are now widely adopted and the benefits have been demonstrated beyond question. Learn why your peers are replacing JEE containers with lightweight application servers - and what you can gain from the move. http://p.sf.net/sfu/vmware-sfemails___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] DB.DBA.RDF_LOAD_RDFXML error
Hi Bin, Your dataset size is probably too large for use with the RDF_LLOAD_RDFXML() function, thus you should use the multi-threaded DB.DBA.RDF_LOAD_RDFXML_MT() function that is specially built for non-transactional loading as it has no transaction size limit, as detailed at: http://docs.openlinksw.com/virtuoso/fn_rdf_load_rdfxml_mt.html If you have multiple large datasets to load you should use the Virtuoso Bulk loader scripts as detailed at: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtBulkRDFLoader Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 22 Apr 2011, at 06:44, bin chen wrote: Hi, I was uploading owl file with size 340M using DB.DBA.RDF_LOAD_RDFXML (file_to_string_output...), it gave the following error: ** Error 40005: [Virtuoso Driver][Virtuoso Server]SR325: Transaction aborted because it's log after image size went above the limit at line 1 of Top-Level: Do you know how to fix it? Thanks. Best, Bin -- Fulfilling the Lean Software Promise Lean software platforms are now widely adopted and the benefits have been demonstrated beyond question. Learn why your peers are replacing JEE containers with lightweight application servers - and what you can gain from the move. http://p.sf.net/sfu/vmware-sfemails ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] query via sesame API throws Exception
Hi Florian, Can you provide some sample code we can review or compile/run to test locally ? Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 19 Apr 2011, at 16:54, Florian Kleedorfer wrote: Hi Hugh, thanks for the quick reaction! The first option (the Virtuoso RDF Data Storage Provider) works, but I'd have to change my client code which I really don't want. The second option is the one that fails. best, Florian On 19.4.2011 14:24, Hugh Williams wrote: Hi Florian, What method are you using to query the Virtuoso repository from Sesame as we support two methods: 1. Using the Virtuoso RDF Data Storage provider as detailed at: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtSesame2Provider 2. Using the Sesame HTTP repository as detailed at: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtSesame2HttpRepository Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 19 Apr 2011, at 11:25, Florian Kleedorfer wrote: Hi all, I'm using the virtuoso sesame provider with the latest openrdf-workbench and openrdf-sesame webapps. sesame version: 2.3.3 virtuoso version: virtuoso-opensource-win32-20110330 I've configured a repository to use virtuoso and I can access it normally in the openrdf workbench. However, I can't run queries via the sesame java api. I tried tuple queries and graph queries and I always get the same exception: Caused by: org.openrdf.repository.RepositoryException: Unsupported query type: virtuoso.sesame2.driver.VirtuosoQuery at org.openrdf.http.client.HTTPClient.getRDF(HTTPClient.java:1066) at org.openrdf.http.client.HTTPClient.sendGraphQuery(HTTPClient.java:440) at org.openrdf.http.client.HTTPClient.sendGraphQuery(HTTPClient.java:423) at org.openrdf.repository.http.HTTPGraphQuery.evaluate(HTTPGraphQuery.java:40) ... 12 more Other sesame repositories I've configured, using native and postgres flavours, work fine. Strangely enough, I can't seem to find this exception anywhere on the web. Any ideas? best Florian -- Benefiting from Server Virtualization: Beyond Initial Workload Consolidation -- Increasing the use of server virtualization is a top priority.Virtualization can reduce costs, simplify management, and improve application availability and disaster protection. Learn more about boosting the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users -- Benefiting from Server Virtualization: Beyond Initial Workload Consolidation -- Increasing the use of server virtualization is a top priority.Virtualization can reduce costs, simplify management, and improve application availability and disaster protection. Learn more about boosting the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] query via sesame API throws Exception
Hi Florian, What method are you using to query the Virtuoso repository from Sesame as we support two methods: 1. Using the Virtuoso RDF Data Storage provider as detailed at: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtSesame2Provider 2. Using the Sesame HTTP repository as detailed at: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtSesame2HttpRepository Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 19 Apr 2011, at 11:25, Florian Kleedorfer wrote: Hi all, I'm using the virtuoso sesame provider with the latest openrdf-workbench and openrdf-sesame webapps. sesame version: 2.3.3 virtuoso version: virtuoso-opensource-win32-20110330 I've configured a repository to use virtuoso and I can access it normally in the openrdf workbench. However, I can't run queries via the sesame java api. I tried tuple queries and graph queries and I always get the same exception: Caused by: org.openrdf.repository.RepositoryException: Unsupported query type: virtuoso.sesame2.driver.VirtuosoQuery at org.openrdf.http.client.HTTPClient.getRDF(HTTPClient.java:1066) at org.openrdf.http.client.HTTPClient.sendGraphQuery(HTTPClient.java:440) at org.openrdf.http.client.HTTPClient.sendGraphQuery(HTTPClient.java:423) at org.openrdf.repository.http.HTTPGraphQuery.evaluate(HTTPGraphQuery.java:40) ... 12 more Other sesame repositories I've configured, using native and postgres flavours, work fine. Strangely enough, I can't seem to find this exception anywhere on the web. Any ideas? best Florian -- Benefiting from Server Virtualization: Beyond Initial Workload Consolidation -- Increasing the use of server virtualization is a top priority.Virtualization can reduce costs, simplify management, and improve application availability and disaster protection. Learn more about boosting the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Built-in Protection against SQL / SPARQL Injections.
Hi Herman, The Virtuoso SPARQL endpoint can be configured for secure access on an a secure port using WebID and ACLs to control access to the server as detailed in section 16.2.3.4. Service Endpoint Security of the online documentation at: http://docs.openlinksw.com/virtuoso/rdfsparql.html#rdfsparqlprotocolendpoint See also: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtAuthFOAFSSLACL The “[SPARQL]” section of the virtuoso configuration file can also has a number of parameters to restrict access to the endpoint as detailed at: http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#ini_SPARQL Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 18 Apr 2011, at 03:09, Herman A. Junge wrote: Hi, Does Virtuoso have built-in protection against SQL / SPARQL Injections? Herman A. Junge neoSource, SCL -- Benefiting from Server Virtualization: Beyond Initial Workload Consolidation -- Increasing the use of server virtualization is a top priority.Virtualization can reduce costs, simplify management, and improve application availability and disaster protection. Learn more about boosting the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Implementing a simple ACL atop a SPARQL endpoint
Hi Aldo, You can use WebID/Oauth/SQL authentication and configure separate SPARQL endpoints with various ACLs and user access rights as detailed in section 16.2.3.4.1. Managing a SPARQL Web Service Endpoint of the documentation at : http://docs.openlinksw.com/virtuoso/rdfsparql.html#rdfsparqlprotocolendpoint Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 14 Apr 2011, at 04:57, Aldo Bucchi wrote: Hi, I have done this many times already, so I can tell it is a pattern. I have a Virtuoso in an intranet, and one or more applications talk to it via SPARQL HTTP. I would like to also allow selected external users (humans) and applications to access the endpoint. Some with SPARQL Update privilege. What's the recommended way to do this? Regards, A -- Aldo Bucchi @aldonline skype:aldo.bucchi http://facebook.com/aldo.bucchi http://aldobucchi.com/ -- Benefiting from Server Virtualization: Beyond Initial Workload Consolidation -- Increasing the use of server virtualization is a top priority.Virtualization can reduce costs, simplify management, and improve application availability and disaster protection. Learn more about boosting the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
