Re: [Virtuoso-users] Monitoring uploads via WebDav

2015-03-03 Thread Alexey Zakhlestin
r. Virtuoso has a hard-limit on number of results it can return. You’ll have to use offset/limit blocks and hope that data doesn’t change in process. -- Alexey Zakhlestin https://github.com/indeyets PGP key: http://indeyets.ru/alexey.zakhlestin.pgp.asc signature.asc Description: Message sign

Re: [Virtuoso-users] 'Too many arguments' error

2014-07-16 Thread Alexey Zakhlestin
en clear the graph INSERT DATA { a <https://example.com/dummy> . a <https://example.com/dummy> .} etc. -- Alexey Zakhlestin CTO at Grids.by/you https://github.com/indeyets PGP key: http://indeyets.ru/alexey

Re: [Virtuoso-users] How to redirect virtuoso output to file?

2013-12-19 Thread Alexey Zakhlestin
On 19.12.13, 13:02, Rose Beck wrote: > I am trying to view the output of status() command, since the output is > long therefore I am unable to view it all on the command line. Is there > a way to redirect the output to a text file? echo 'status();' | isql > file.txt --

Re: [Virtuoso-users] built-in procedure "…" overruled by the RDBMS

2013-10-02 Thread Alexey Zakhlestin
procedure "PUMP.DBA.HTML_RETRIEVE_QUALIFIERS_VIA_PLSQL" overruled by the RDBMS 07:24:21 built-in procedure "PUMP.DBA.DUMP_TABLES_AND_PARS_RETRIEVE" overruled by the RDBMS 07:24:21 built-in procedure "PUMP.DBA.RESTORE_TABLES_AND_P

[Virtuoso-users] built-in procedure "…" overruled by the RDBMS

2013-09-30 Thread Alexey Zakhlestin
by us. Is it a good idea to drop these procedures so that server uses the built-in copies? -- Alexey Zakhlestin CTO at Grids.by/you https://github.com/indeyets PGP key: http://indeyets.ru/alexey.zakhlestin.pgp.asc signature.asc Description: Message signed with OpenPG

[Virtuoso-users] Strangely slow query

2013-08-16 Thread Alexey Zakhlestin
native approach? -- Alexey Zakhlestin CTO at Grids.by/you https://github.com/indeyets PGP key: http://indeyets.ru/alexey.zakhlestin.pgp.asc signature.asc Description: Message signed with OpenPGP using GPGMail -- Get 100%

Re: [Virtuoso-users] Announcing OpenLink Virtuoso Open-Source Edition v6.1.7

2013-07-23 Thread Alexey Zakhlestin
On 23.07.2013, at 14:29, Tim Haynes wrote: > Hi, > > OpenLink Software is pleased to announce the official release of Something's broken. I can't build it https://gist.github.com/indeyets/5d035b8a63511377bfc7 -- Alexey Zakhlestin CTO at Grids.by/you https://github.com/ind

Re: [Virtuoso-users] Announcing OpenLink Virtuoso Open-Source Edition v6.1.7

2013-07-23 Thread Alexey Zakhlestin
On 23.07.2013, at 14:29, Tim Haynes wrote: > OpenLink Software is pleased to announce the official release of > Virtuoso Open-Source Edition, Version 6.1.7: Thanks! Sent corresponding pull-request to Homebrew: https://github.com/mxcl/homebrew/pull/21400 -- Alexey Zakhlestin CTO at Gr

[Virtuoso-users] AIO makes sense?

2013-07-09 Thread Alexey Zakhlestin
ld be set to "1" -- Alexey Zakhlestin CTO at Grids.by/you https://github.com/indeyets PGP key: http://indeyets.ru/alexey.zakhlestin.pgp.asc -- See everything from the browser to the database with AppDynamics

Re: [Virtuoso-users] upgrade triplestore to column store

2013-07-09 Thread Alexey Zakhlestin
-- 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 Acces

Re: [Virtuoso-users] virtuoso/7, status(). What's "IER 1"?

2013-07-08 Thread Alexey Zakhlestin
On 08.07.2013, at 21:37, Alexey Zakhlestin wrote: > Sometimes, status() gives me lines like these: > > 1454231: IER 1 > 201: IER 1 > 996248: IER 1 > 1: IER 1 > 1025432: IER 1 > 5: IER 1 > 238232: IER 1 > 3: IER 1 > > what do

[Virtuoso-users] virtuoso/7, status(). What's "IER 1"?

2013-07-08 Thread Alexey Zakhlestin
r letter-combos in status(), but can't find what those were right now -- Alexey Zakhlestin CTO at Grids.by/you https://github.com/indeyets PGP key: http://indeyets.ru/alexey.zakhlestin.pgp.asc signature.asc Description: Message signed with O

[Virtuoso-users] upgrade triplestore to column store

2013-07-08 Thread Alexey Zakhlestin
this script? https://github.com/openlink/virtuoso-opensource/blob/develop/7/libsrc/Wi/rdfcol.sql what's the command to verify format of indices? -- Alexey Zakhlestin CTO at Grids.by/you https://github.com/indeyets PGP key: http://indeyets.ru/alexey.zakhlestin.pgp.asc signature.asc D

Re: [Virtuoso-users] RAM requirements

2013-06-28 Thread Alexey Zakhlestin
utely sure if it was the cause of just coincidence, but this time I got totally stuck virtuoso-t I even couldn't get result for status(); -- Alexey Zakhlestin CTO at Grids.by/you https://github.com/indeyets PGP key: http://indeyets.ru/alexey.zakhlestin.pgp.asc ---

Re: [Virtuoso-users] RAM requirements

2013-06-28 Thread Alexey Zakhlestin
On 28.06.2013, at 17:40, Hugh Williams wrote: > Hi Alexey, > > Can you try setting "DefaultIsolation = 2" in the "[Parameters]" section of > the INI file, restart the server and repeat the load test with an empty > database. DefaultIsolation = 2 sets the isolation level to read committed >

Re: [Virtuoso-users] RAM requirements

2013-06-28 Thread Alexey Zakhlestin
ted would be in > swap, which means you load is mainly going to be to disk, which will always > kill performance … I wrote previously, that I switched to larger VM with 30Gb of RAM All data refers to this new VM. Original 2G VM got stuck too early to be usable -- Alexey Zakhlestin CTO at

Re: [Virtuoso-users] RAM requirements

2013-06-28 Thread Alexey Zakhlestin
eLDMeterUtility Here's the snapshot: https://gist.github.com/indeyets/79cf5444ab8ff2546662 -- Alexey Zakhlestin CTO at Grids.by/you https://github.com/indeyets PGP key: http://indeyets.ru/alexey.zakhlestin.pgp.asc signature.asc Description: Message signed with O

Re: [Virtuoso-users] RAM requirements

2013-06-28 Thread Alexey Zakhlestin
On 28.06.2013, at 2:26, Hugh Williams wrote: > Hi Alexey, > > We need to see the status(''); output either for the v6 or v7 instance being > used. Here's the recent status(); https://gist.github.com/indeyets/799ba18f1da5ac77354f Import was running for 12 hours approximately. CPU load was gre

Re: [Virtuoso-users] RAM requirements

2013-06-27 Thread Alexey Zakhlestin
On 28.06.2013, at 0:39, Hugh Williams wrote: > Hi Alexey, > > For Virtuoso 6 the average size of a triple is about 31bytes, with the > default index schema as detailed in the followng FAQ document: > > > http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VOSVirtuoso6FAQ#What%20

[Virtuoso-users] RAM requirements

2013-06-27 Thread Alexey Zakhlestin
/dataspace/doc/dav/wiki/Main/VirtRDFPerformanceTuning) so, how much RAM do I need to handle 100M? 500M? 1000M triples? Numbers will be smaller for Virtuoso/7 I guess? We plan to upgrade in the near future. -- Alexey Zakhlestin, http://github.com/indeyets

Re: [Virtuoso-users] What is the structrue of data stored in virtuoso?

2013-06-19 Thread Alexey Zakhlestin
On 19.06.2013, at 18:18, 126 wrote: > Hi, all > I am new to virtuoso, after I followed instructions on the web to load > rdf data into my local virtuoso database, I became curious about the > high-level structure of the stored data in virtuoso. As we all know, > Relational Database stores

[Virtuoso-users] Size (in bytes) of Named Graph

2013-05-20 Thread Alexey Zakhlestin
Is it possible to get the disk space used by the named graph in bytes? I didn't manage to find anything relevant by googling. -- AlienVault Unified Security Management (USM) platform delivers complete security visibility w

Re: [Virtuoso-users] Data Integrity in RDF?

2013-04-24 Thread Alexey Zakhlestin
On 24.04.2013, at 19:24, Matías Parodi wrote: > There is this project called SPIN (spingrdf.org) which lets you add > constraints that are checked when you insert new data into the store. In this > way, as I see it, you're not "blocking the data-flow". Whatever gets into the > store is "valid

Re: [Virtuoso-users] Data Integrity in RDF?

2013-04-24 Thread Alexey Zakhlestin
On 24.04.2013, at 19:04, Matías Parodi wrote: > Any idea about forcing constraints in Virtuoso? well… my personal belief is, that constraints should be enforced on application level RDF is good because it allows you to store and exchange opaque-but-introspectable data Application, on the oth

Re: [Virtuoso-users] Data Integrity in RDF?

2013-04-22 Thread Alexey Zakhlestin
On 23.04.2013, at 2:16, Matías Parodi wrote: > By the way, what is the best way to use Virtuoso from Ruby on Rails? I think > there isn't any ActiveRecord support at the moment nor any still-maintained > adapter for Ruby (all I found were a couple of outdated project). Here's some recent proje

Re: [Virtuoso-users] Problem after compiling virtuoso

2013-04-17 Thread Alexey Zakhlestin
On 17.04.2013, at 20:20, Julien Plu wrote: > And I fall on this error : > > Starting OpenLink Virtuoso Open-Source Edition: The VDBMS server process > terminated prematurely > after starting up. > > I though that maybe an instance of Virtuoso is already running so I did : > > ps -ef | grep v

Re: [Virtuoso-users] Problems building and installing Virtuoso 7

2013-04-09 Thread Alexey Zakhlestin
On 09.04.2013, at 14:51, Bernard Buri wrote: > > Checked out virtuoso stable/7 branch and built virtuoso with CFLAGS > described in README > stable/7 is 2 years old. check develop/7 if you want current code. ---

Re: [Virtuoso-users] SPARQL 1.1 Graph Store HTTP Protocol

2013-03-29 Thread Alexey Zakhlestin
link-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 25 Jan 2013, at 14:34, Alexey Zakhl

Re: [Virtuoso-users] SPARQL LOAD <…> INTO. file size

2013-03-28 Thread Alexey Zakhlestin
On 28.03.2013, at 6:46, Hugh Williams wrote: > On 27 Mar 2013, at 18:02, Alexey Zakhlestin wrote: > >> Anyway, what is the actual limit? >> If it is impossible to support larger files, then it will be good to know >> maximum allowed size. >> Error message could

Re: [Virtuoso-users] SPARQL LOAD <…> INTO. file size

2013-03-28 Thread Alexey Zakhlestin
On 28.03.2013, at 0:18, Kingsley Idehen wrote: > On 3/27/13 2:01 PM, Alexey Zakhlestin wrote: >> On 27.03.2013, at 20:59, Kingsley Idehen wrote: >>> >>> >>> There's a bulk loader option for larger RDF documents [1]. >>> >>> Links: &

Re: [Virtuoso-users] SPARQL LOAD <…> INTO. file size

2013-03-27 Thread Alexey Zakhlestin
On 27.03.2013, at 20:59, Kingsley Idehen wrote: > On 3/27/13 12:15 PM, Alexey Zakhlestin wrote: >> I am trying to import dataset files with this SPARQL query: >> >> LOAD INTO <http://example.com/graph> >> >> It works fine for smaller files, but now I

[Virtuoso-users] SPARQL LOAD <…> INTO. file size

2013-03-27 Thread Alexey Zakhlestin
I am trying to import dataset files with this SPARQL query: LOAD INTO It works fine for smaller files, but now I need to import larger one and I get this error: Virtuoso 39000 Error FA008: File '/path/to/file.nt' too long, cannot return string content 62172163 chars

[Virtuoso-users] SPARQL, backslash in URIs

2013-03-26 Thread Alexey Zakhlestin
Hi. I have a dataset, which has backslash character in some of the Subject URIs. Whenever I try to use such URI in SPARQL Query, Virtuoso gives me this: Virtuoso 37000 Error SP030: SPARQL compiler, line 0: Invalid character in SPARQL expression at '\' Do I need to escape backslash somehow?

Re: [Virtuoso-users] SPARQL 1.1 Graph Store HTTP Protocol

2013-01-25 Thread Alexey Zakhlestin
ould appreciate explicit errors overall result for me is, that I can't use standard-compliant tools to work with virtuoso's http sparql graph store [1] http://www.w3.org/TR/sparql11-http-rdf-update/#indirect-graph-identification [2] https://github.com/njh/easyrdf -- Alex

Re: [Virtuoso-users] WebSchemas, Schema.org and W3C

2013-01-24 Thread Alexey Zakhlestin
Is it attempt to reimplement http://prefix.cc/ ? On 23 Jan 2013 06:35, "Kingsley Idehen" wrote: > On 1/22/13 11:45 AM, Bernard Vatant wrote: > > ACTION > > Make a list of "globally adopted schemas" (vocabularies) and put a * > responsible* agent name/email/URI whatever Web identifier in front o

Re: [Virtuoso-users] SPARQL 1.1 Graph Store HTTP Protocol

2013-01-22 Thread Alexey Zakhlestin
On 23.01.2013, at 1:14, Alexey Zakhlestin wrote: > > On 22.01.2013, at 23:09, Alexey Zakhlestin wrote: > >> >> On 22.01.2013, at 21:57, Hugh Williams wrote: >> >>> Hi Alexey, >>> >>> Can you provide the sample query and turtle file yo

Re: [Virtuoso-users] SPARQL 1.1 Graph Store HTTP Protocol

2013-01-22 Thread Alexey Zakhlestin
On 22.01.2013, at 23:09, Alexey Zakhlestin wrote: > > On 22.01.2013, at 21:57, Hugh Williams wrote: > >> Hi Alexey, >> >> Can you provide the sample query and turtle file you are using when trying >> to perform such an insert/load please ? > > Sure.

Re: [Virtuoso-users] SPARQL 1.1 Graph Store HTTP Protocol

2013-01-22 Thread Alexey Zakhlestin
; On 22 Jan 2013, at 08:05, Alexey Zakhlestin wrote: >> On 22.01.2013, at 6:14, Hugh Williams wrote: >> >>> Hi Erich, >>> >>> Yes, Virtuoso has supported the SPARQL 1.1 Graph Store HTTP Protocol since >>> Nov 2011 as indicated at: >>> &

Re: [Virtuoso-users] SPARQL 1.1 Graph Store HTTP Protocol

2013-01-22 Thread Alexey Zakhlestin
so 22023 Error The request does not contain text of SPARQL query > > On 22 Jan 2013, at 00:29, Erich Bremer wrote: > >> Is the SPARQL 1.1 Graph Store HTTP Protocol supported yet in Virtuoso? >> >> http://www.w3.org/TR/sparql11-http-rdf-update/ &

Re: [Virtuoso-users] Official binary builds

2013-01-18 Thread Alexey Zakhlestin
On 18.01.2013, at 19:43, Hugh Williams wrote: > Hi Alexey, > > We are currently discussing how best this can be done for this common Linux > distro's, but as it stands they would have to be build from source, for which > we do provide instructions on building for popular Linux distros in ther

[Virtuoso-users] Official binary builds

2013-01-18 Thread Alexey Zakhlestin
) * Ubuntu LTS(ships with 6.1.4) There are two problems with packages from distributions: 1. They are outdated 2. They are crippled (miss some of the tools) Community will greatly benefit from proper up to date packages for production systems. -- Alexey Zakhlestin https://github.com/indeyets

Re: [Virtuoso-users] Virtuoso Version-Build Number Problem While Executing Construct Query

2013-01-11 Thread Alexey Zakhlestin
ld on CentOS because of this. On OSX it is possible to use homebrew's "brew install virtuoso" to get latest stable or "brew install virtuoso --HEAD" to get recent snapshot from git -- Alexey Zakhlestin https://github.com/indeyets -

[Virtuoso-users] Blank nodes in INSERT DATA

2013-01-02 Thread Alexey Zakhlestin
27; is not allowed in a constant clause -- Alexey Zakhlestin https://github.com/indeyets -- Master Java SE, Java EE, Eclipse, Spring, Hibernate, JavaScript, jQuery and much more. Keep your Java skills cu

Re: [Virtuoso-users] Inserting large quantities of text via SPARQL

2012-12-24 Thread Alexey Zakhlestin
ity of text? +1 I will need something like this, too. p.s. Hi, Vishesh (we met in Tampere, couple of years ago) ;) -- Alexey Zakhlestin https://github.com/indeyets -- LogMeIn Rescue: Anywhere, Anytime Remote s

Re: [Virtuoso-users] Implicit type overrides explicit type on assignment

2012-11-13 Thread Alexey Zakhlestin
On 13.11.2012, at 9:18, Hugh Williams wrote: > Hi Quentin, > > The error is saying you are trying to concat and integer when a strings is > expected, thus the integer should be cast as varchar for it to work: > > create procedure > DB.q.testBug() returns varchar > { > declare str varchar;