Re: [Virtuoso-users] Log out of disk

, Erick -- * Erick Antezana [2008/08/08 12:29 AM +0200] wrote: I got this error while loading some graphs using a perl script: DBD::ODBC::st execute failed: [unixODBC][OpenLink][Virtuoso iODBC Driver][Virtuoso Server]SR174: Log out of disk (SQL-40004) any idea what this means? The

[Virtuoso-users] Log out of disk

Hi, I got this error while loading some graphs using a perl script: DBD::ODBC::st execute failed: [unixODBC][OpenLink][Virtuoso iODBC Driver][Virtuoso Server]SR174: Log out of disk (SQL-40004) any idea what this means? thanks, Erick

[Virtuoso-users] Segmentation fault in 5.0.7

Hi Hugh, I' m using perl (DBI), unix odbc to load my graphs into our virtuoso instance. The process was executed successfully many times using v5.0.3. However, I got now (with 5.0.7) a segmentation fault and my perl script crashes, the virtuoso instance is still alive, and the graph seems to

Re: [Virtuoso-users] Announcing OpenLink Virtuoso, Open-Source Edition, v5.0.7

el ?name.} UNION {?unique_id ssb:name ?name.} } } erick Hugh Williams wrote: HI Erick, Can you please provide the SPARQL query this explain output was generated from also ... Regards Hugh On 31 Jul 2008, at 16:37, Erick Antezana wrote: Hi Hugh, I've run the 'explain' on

Re: [Virtuoso-users] Announcing OpenLink Virtuoso, Open-Source Edition, v5.0.7

ot;s-11-6-t1.S" 4: $33 "name" := := artm $50 "s-11-6-t1.O" 8: BReturn 0 Subquery Select($32 "unique_id", $33 "name", <$39 "s-9-3-t0-u8>" spec 5>) } } After code: 0: $62 "name" := Call __rdf_sqlval_of_obj ($33 "name"

Re: [Virtuoso-users] Announcing OpenLink Virtuoso, Open-Source Edition, v5.0.7

n for RDF browsing): http://ode.openlinksw.com/ Regards, ~Tim -- == Erick Antezanahttp://www.cellcycleontology.org PhD student Tel:+32 (0)9 331 38 24fax:+32 (0)9 3313809 VIB Department of Plant Systems Biology, Ghent University Technologiepark 9

Re: [Virtuoso-users] base for prefixes

Hi Hugh, the version we're running for this particular instance is 5.0.5 (Linux 64bits). You can check it out from: http://www.cellcycleontology.org/query/sparql I have run 'explain' with the following query: BASE PREFIX rdfs:

Re: [Virtuoso-users] performance tuning

Hugh, it is 64bits: virtuoso-t: ELF 64-bit LSB executable, AMD x86-64, version 1 (SYSV), for GNU/Linux 2.4.0, dynamically linked (uses shared libs), stripped so, we will wait until 5.0.7 is out there... Erick Hugh Williams wrote: On 19 Jun 2008, at 16:00, Erick Antezana wrote: Hi Hugh

Re: [Virtuoso-users] performance tuning

Hi Hugh, please see below: Hugh Williams wrote: Hi Erick, On 17 Jun 2008, at 09:11, Erick Antezana wrote: Hi Hugh, There was only one defined index on that table (RDF_QUAD_OGPS). I have added the following: create indexRDF_QUAD_GSPO on DB.DBA.RDF_QUAD (G,S,P,O); create bitmap

Re: [Virtuoso-users] performance tuning

egards Hugh /opt/Ingres/IngresII/ingres On 10 Jun 2008, at 11:06, Erick Antezana wrote:

Re: [Virtuoso-users] performance tuning

_SAFE ((http://www.semantic-systems-biology.org/ontology/rdf/OBO)>) 7: $26 "-ns#type" := Call DB.DBA.RDF_MAKE_IID_OF_QNAME_SAFE ((http://www.w3.org/1999/02/22-rdf-syntax-ns#type)>) 14: BReturn 0 from DB.DBA.RDF_QUAD by RDF_QUAD Key RDF_QUAD ASC ($28 "s-4-1-t0.O") inline

Re: [Virtuoso-users] performance tuning

query to the server. Multiple lines would best in the Conductor Interactive SQL UI, which you could try also. Best Regards Hugh Williams Professional Services OpenLink Software On 9 Jun 2008, at 17:40, Erick Antezana wrote: Hi Hugh, I tried to run both queries (first surrounded by the '

Re: [Virtuoso-users] performance tuning

:GO_0005737. obo:GO_0005737 rdfs:label ?GO_term. ?Statement goa:supported_by ?GOA_association. ?GOA_association obo:has_evidence_code ?eco_id. }') example 2: explain('prefix rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#> select distinct ?ontology from <http://www.semantic-sys

Re: [Virtuoso-users] performance tuning

OpenLink Software On 6 Jun 2008, at 14:09, Erick Antezana wrote: Hi Hugh, here you are the 'top' output: top - 14:57:25 up 13 days, 22:52, 7 users, load average: 2.57, 1.74, 1.31 Tasks: 133 total, 1 running, 132 sleeping, 0 stopped, 0 zombie Cpu(s): 68.0% us, 1.7% sy, 0.0

[Virtuoso-users] performance tuning

Hello, could anybody point out some doc/examples for doing some performance tuning? I have been playing (in a linux box with 16GB RAM, 1 CPU, ...) with some params (numberofbuffers, maxcheckpointremap, O_DIRECT, etc) as indicated in: http://virtuoso.openlinksw.com/wiki/main/Main/VOSScale htt

Re: [Virtuoso-users] huge file loading

ng; I don't know the exact reason). This problem with memory allocation seems to be my personal problem because other Linux boxes work fine. This problem happens only during intensive data loading, I use 1500000 buffers for all other activities (i.e. 12Gb out of 16Gb are usually for buffers). B

[Virtuoso-users] huge file loading

g should they be?). Once loaded, will virtuoso be able to cope with such DB? Were some tuning in the INI parameters be still needed/suggested? thanks in advance for any hints, Erick -- == Erick Antezanahttp://ww

[Virtuoso-users] 'dav' user

Hello, how can I enable/disable the 'dav' user using isql (and not the conductor)? thanks, Erick -- ====== Erick Antezanahttp://www.cellcycleontology.org PhD student Tel:+32 (0)9

[Virtuoso-users] Striping and NFS

Hi, is it possible/advisable to do striping over a partition that is mounted via NFS? (The disk where virtuoso (5.0.3) is running is almost full...) thanks, Erick -- == Erick Antezanahttp

[Virtuoso-users] AJAX functionality on SPARQL forms

Hello, I have been looking for an easy and lazy ;-) way to have some AJAX functionality to be added to our SPARQL form (http://www.cellcycleontology.org/query/sparql) so that query results could be seen on the same web page and therefore, users don't have to click on the BACK button of thei

Re: [Virtuoso-users] how many triples do I have?

thank you all for your help. Actually, I wanted the total count from all the graphs. I was only counting as Rumi suggested for each graph, then adding... Erick Kunal Patel wrote: Hi, If you want the total count of triples from all the graphs in your db you can also use select count(*) f

[Virtuoso-users] how many triples do I have?

Hi, is there an "intelligent" way to get the number of triples I've got in my virtuoso db? thanks, erick

[Virtuoso-users] Error while building 5.0.4 from CVS

Hello, we've got the following messages while building the latest CVS code: Virtuoso.ini creation... The VDBMS server process terminated prematurely after initializing network connections. Waiting Virtuoso Server start on port ... PASSED: Virtuoso Server successfully started on port ***

Re: [Virtuoso-users] Fwd: Segmentation fault

eTerm(). Regarding 5.0.4, it may be safer to wait the 'official' confirmation that your problem is solved. Pierre 2008/2/6, Erick Antezana <mailto:er...@psb.ugent.be>>: Hi Pierre, I tried out the line: FILTER(sameTerm(?prot,cco:CCO_B0001243) = false)

Re: [Virtuoso-users] Fwd: Segmentation fault

n 5.0.3, FILTER(!...) may not work properly. Instead, try this: FILTER(sameTerm(?prot,cco:CCO_B0001243) = false) In 5.0.4, FILTER(!...) seems to work properly. Pierre 2008/2/6, Erick Antezana <mailto:er...@psb.ugent.be>>: Hi, we're running 5.0.3 on a linux box. So far ev

[Virtuoso-users] Segmentation fault

Hi, we're running 5.0.3 on a linux box. So far everything was going perfectly until we tested the following query which is very simple against a huge graph (that could be found here: http://www.cellcycleontology.org/ontology/rdf/cco.rdf): PREFIX rdfs:

[Virtuoso-users] A clean virtuoso shutdown

Hi, I have virtuoso running on a linux box (2.6.9-67.0.1.ELsmp #1 SMP Fri Nov 30 11:57:43 EST 2007 x86_64 x86_64 x86_64 GNU/Linux). I would like to try out the different parameters that could be in the INI file (e.g. Striping = 1, SPARQL related, etc) so I need to shutdown virtuoso so that