[Virtuoso-users] help in setting few config parameters in ini file

2014-07-03 Thread Purohit, Sumit
Hi All, I am trying to performance tune VOS 7.1.1 which i got from git and i have few questions about some of the parameters in virtuoso.ini file First some instruction about my server setup. I have VOS 7.1.1 with 100GB memory and around 1.4B triples. I have kept following values for buffer: N

Re: [Virtuoso-users] Using column store structure for exiting data

2014-05-22 Thread Purohit, Sumit
Thanks Kingsley and entire community for this meaning full discussion, After this discussion, I have 2 follow-up question. 1. How do I create a new empty database in my existing virtuoso and start loading RDF data into that by default. I think this way I will be using column-wise structure. 2.

Re: [Virtuoso-users] Using column store structure for exiting data

2014-05-20 Thread Purohit, Sumit
e virtuoso : I recompile it from source and then used my older ini file as i have made some performance tuning it that. --sumit From: Hugh Williams [hwilli...@openlinksw.com] Sent: Tuesday, May 20, 2014 3:03 PM To: Purohit, Sumit Cc: Bart Vandewoestyne; virt

Re: [Virtuoso-users] Using column store structure for exiting data

2014-05-20 Thread Purohit, Sumit
I +1 Bart's question as I also want to know which tables are using latest column store. Is there a way ? Thanks Sumit Purohit -Original Message- From: Bart Vandewoestyne [mailto:bart.vandewoest...@telenet.be] Sent: Tuesday, May 20, 2014 4:50 AM To: virtuoso-users@lists.sourceforge.ne

Re: [Virtuoso-users] Using column store structure for exiting data

2014-05-17 Thread Purohit, Sumit
From: Hugh Williams [hwilli...@openlinksw.com] Sent: Saturday, May 17, 2014 5:46 PM To: Purohit, Sumit Cc: virtuoso-users@lists.sourceforge.net Subject: Re: [Virtuoso-users] Using column store structure for exiting data Hi Sumit, By default all SQL tables would be created as

Re: [Virtuoso-users] Graph List does not get updated after RDF load

2014-05-17 Thread Purohit, Sumit
.0.1 Transaction status: PENDING, 1 threads. Locks: Running Statements: Time (msec) Text 387 status() Hash indexes 37 Rows. -- 388 msec. thanks sumit From: Hugh Williams [hwilli...@openlinksw.com] Sent: Saturday, May 17, 2014 5:36 PM To: Purohit, S

[Virtuoso-users] Using column store structure for exiting data

2014-05-17 Thread Purohit, Sumit
Hi All, I am using Virtuoso (Open Source) 7.1.0 and read about support of column-store structure in virtuoso. http://docs.openlinksw.com/virtuoso/databaseadmsrv.html Does setting ColumnStore=1 affect only tables created after the change OR DOES IT RE-INDEX / RE-STRUCTURE exiting tables and ind

[Virtuoso-users] Graph List does not get updated after RDF load

2014-05-17 Thread Purohit, Sumit
Hi, I have observed many times after loading rdf data into a named graph using ld_dir() or ld_dir_all(), updated list of graph does show up either on conductor->linked data-> Graphs or using query like SELECT DISTINCT ?g WHERE { GRAPH ?g { ?s ?p ?o } } Behavior is quite random and som

Re: [Virtuoso-users] Instructions to upgrade to V 7.1.0

2014-05-08 Thread Purohit, Sumit
anks sumit From: Hugh Williams [hwilli...@openlinksw.com] Sent: Thursday, May 08, 2014 3:58 PM To: Purohit, Sumit Cc: virtuoso-users@lists.sourceforge.net Subject: Re: [Virtuoso-users] Instructions to upgrade to V 7.1.0 Hi Sumit, You simply run the "checkpoint"

Re: [Virtuoso-users] Instructions to upgrade to V 7.1.0

2014-05-08 Thread Purohit, Sumit
From: Purohit, Sumit Sent: Thursday, May 08, 2014 2:00 PM To: Hugh Williams Cc: virtuoso-users@lists.sourceforge.net Subject: Re: [Virtuoso-users] Instructions to upgrade to V 7.1.0 thanks for prompt response. Can you explain what you mean by "nsuring a checkpoint has been performed such that the

Re: [Virtuoso-users] Instructions to upgrade to V 7.1.0

2014-05-08 Thread Purohit, Sumit
ay, May 08, 2014 2:18 PM To: Purohit, Sumit Cc: virtuoso-users@lists.sourceforge.net Subject: Re: [Virtuoso-users] Instructions to upgrade to V 7.1.0 Hi Summit, There are no instructions necessary, as the databases between the two versions are compatible. So you simply shutdown the 7.0 databas

[Virtuoso-users] Instructions to upgrade to V 7.1.0

2014-05-08 Thread Purohit, Sumit
Hi, I want to update virtuoso (open source) from 7.00.3203 to latest version 7.1.0. I could not find any update instructions for this version. Included README.UPDATE talks about "Upgrading from VOS 6.1.X to VOS 6.1.4" as latest. Is there any documentation to upgrade to v7.1.0 ? 2nd question i h

Re: [Virtuoso-users] Virtuoso crash when try to delete a huge graph

2014-04-14 Thread Purohit, Sumit
"log_enable(3,1);" mentioned in 2nd link did the trick. I am able to delete large graph without any issue. Thank you . --sumit purohit From: Hugh Williams [mailto:hwilli...@openlinksw.com] Sent: Saturday, April 05, 2014 2:44 PM To: Purohit, Sumit Cc: virtuoso-users@lists.sourc

[Virtuoso-users] Virtuoso crash when try to delete a huge graph

2014-04-02 Thread Purohit, Sumit
Hi All, I have a virtuoso (open source Version: 07.00.3203 Build: Aug 5 2013) server with around 1.4 B triples. Recently i tried to delete a named graph which has 285566 triples but on all 3 attempts virtuoso crashed after few minuets. I used following command on isql prompt to delete the graph

Re: [Virtuoso-users] Dump graph to file

2014-02-03 Thread Purohit, Sumit
Hi Dimitris, I recently used following procedure(s) to dump rdf graph into ttl files. http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtRDFDatasetDump and these worked perfectly . I am not sure about validity of the link you provided but you can try above link. Hope this helps. Tha

[Virtuoso-users] Undefined procedure DB.DBA.dump_one_graph

2013-12-18 Thread Purohit, Sumit
Hi All, I am trying to dump my existing virutoso graphs into .ttl file. I refer http://www.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtRDFDatasetDump#Dump%20One%20Graph but when i run in on my SQL console, i get SQL> dump_one_graph('','/data1/virtuosodumpDec18/_',10) ; *** Error 4

[Virtuoso-users] Impact of number of files on bulk RDF load

2013-04-16 Thread Purohit, Sumit
Hi All, I bulk loaded 11M rdf file (.ttl) into virtuoso graph "A" using "ld_dir" and "rdf_loader_run" and it took 8.5 hours which seems a lot slower considering virtuoso can load data at 36K per second on a single 4 core machine as per virtuoso documentation. ( http://goo.gl/D5zw1) Considering

Re: [Virtuoso-users] Unable to connect to virtuoso : Connect failed to localhost:1111

2013-03-25 Thread Purohit, Sumit
send dump of "ps -ef" in previous reply , please see that to confirm if there is any nsflock daemon. i see "nfsoid" and "locked" process. thanks for your help sumit From: Patrick van Kleef [pkl...@openlinksw.com] Sent: Monday,

Re: [Virtuoso-users] Unable to connect to virtuoso : Connect failed to localhost:1111

2013-03-25 Thread Purohit, Sumit
/conf/logging.properties - root 3877 2039 5 09:17 pts/100:00:00 ps -ef [root@rdesc db]# Thanks sumit From: Hugh Williams [hwilli...@openlinksw.com] Sent: Monday, March 25, 2013 1:36 AM To: Purohit, Sumit Cc: virtuoso-users@lists.sourceforge.net

Re: [Virtuoso-users] Unable to connect to virtuoso : Connect failed to localhost:1111

2013-03-24 Thread Purohit, Sumit
__ From: Hugh Williams [hwilli...@openlinksw.com] Sent: Sunday, March 24, 2013 6:39 PM To: Purohit, Sumit Cc: Kingsley Idehen; virtuoso-users@lists.sourceforge.net Subject: Re: [Virtuoso-users] Unable to connect to virtuoso : Connect failed to localhost: Hi Sumit, Please provide the com

Re: [Virtuoso-users] Unable to connect to virtuoso : Connect failed to localhost:1111

2013-03-24 Thread Purohit, Sumit
_ From: Kingsley Idehen [kide...@openlinksw.com] Sent: Sunday, March 24, 2013 9:25 AM To: virtuoso-users@lists.sourceforge.net Subject: Re: [Virtuoso-users] Unable to connect to virtuoso : Connect failed to localhost: On 3/23/13 10:28 PM, Purohit, Sumit wrote: > root 2936 2039 0 19:2

Re: [Virtuoso-users] Unable to connect to virtuoso : Connect failed to localhost:1111

2013-03-23 Thread Purohit, Sumit
root 2936 2039 0 19:28 pts/100:00:00 grep virtuoso can i kill it ??? i wanna kill it :-) From: Hugh Williams [hwilli...@openlinksw.com] Sent: Saturday, March 23, 2013 6:17 PM To: Purohit, Sumit Cc: virtuoso-users@lists.sourceforge.net Subject

Re: [Virtuoso-users] Unable to connect to virtuoso : Connect failed to localhost:1111

2013-03-23 Thread Purohit, Sumit
opensource/var/lib/virtuoso/db [root@rdesc db]# How does virtuoso-t determine that an instance is already running thanks sumit From: Hugh Williams [hwilli...@openlinksw.com] Sent: Saturday, March 23, 2013 3:29 PM To: Purohit, Sumit Cc: virtuoso-users

Re: [Virtuoso-users] Unable to connect to virtuoso : Connect failed to localhost:1111

2013-03-23 Thread Purohit, Sumit
umit From: Hugh Williams [mailto:hwilli...@openlinksw.com] Sent: Saturday, March 23, 2013 2:58 PM To: Purohit, Sumit Cc: virtuoso-users@lists.sourceforge.net Subject: Re: [Virtuoso-users] Unable to connect to virtuoso : Connect failed to localhost: Hi Sumit, Why is there a file called "virtuoso.ini

Re: [Virtuoso-users] Unable to connect to virtuoso : Connect failed to localhost:1111

2013-03-23 Thread Purohit, Sumit
...@openlinksw.com] Sent: Friday, March 22, 2013 8:25 PM To: Purohit, Sumit Cc: virtuoso-users@lists.sourceforge.net Subject: Re: [Virtuoso-users] Unable to connect to virtuoso : Connect failed to localhost: Hi Sumit, You removed the "virtuoso.lck" and restarted Virtuoso how, by manually

[Virtuoso-users] Unable to connect to virtuoso : Connect failed to localhost:1111

2013-03-22 Thread Purohit, Sumit
Hi All, I have a virtuoso installed on my VM and i had to reboot it for some reason. But once i reboot it, i am not bole to connect to Virtuoso. when i restart it my log says : Fri Mar 22 2013 18:14:33 { Loading plugin 1: Type `plain', file `wikiv' in `/usr/local/virtuoso-opensour

Re: [Virtuoso-users] changing Virtuoso DB location on Ubuntu

2013-03-22 Thread Purohit, Sumit
Hi Uldis, I did same configuration changes in RedHat and it was only changing virtuoso.ini file and restarting the server. I changed following entries [Database] DatabaseFile= /virtuoso.db ErrorLogFile= /virtuoso.log LockFile= /virt

Re: [Virtuoso-users] Configuration for scalable virtuoso

2013-03-22 Thread Purohit, Sumit
Thanks Hugh for pointing me to correct location. Will give it a try. --sumit From: Hugh Williams [hwilli...@openlinksw.com] Sent: Thursday, March 21, 2013 7:33 PM To: Purohit, Sumit Cc: virtuoso-users@lists.sourceforge.net Subject: Re: [Virtuoso-users

[Virtuoso-users] Configuration for scalable virtuoso

2013-03-21 Thread Purohit, Sumit
Hi All, I have setup a Virtuoso server and i need it to tune its triple store for large amount of rdf data. with default configuration one of my dataset took 4 days to load :-) ..i have a 8 core 16GB machine. IS this the right and complete page to follow in order to tune it for higher performa

[Virtuoso-users] Change virtuoso database location

2013-03-12 Thread Purohit, Sumit
Hi All, I am a new virtuoso user and have installed open source version 6.4. I plan to import huge amount of rdf data into it (order of million triples ). I want virtuoso to point to an external mounted disk to use as content store/db store. What do i need to configure in order to do that ? If

[Virtuoso-users] polygon support for geo sparql query

2013-02-15 Thread Purohit, Sumit
Hi All, I have started exploring virtuoso to use it for geo spatial query. One of my requirement is to support different geometries from POINT to Rectangle and polygon, circle After searching mailing list I found some discussions about this. https://sourceforge.net/mailarchive/message.php?msg_i