[Virtuoso-users] Archiving log files

2015-04-07 Thread Eliza Chan
Hi, Is there a way to configure Virtuoso so that the log files can be archived automatically once a certain size is reached? e.g. virtuoso.log.1 virtuoso.log.2 virtuoso.log.3 virtuoso.log etc. Or is it up to the user to set up cron jobs to clean up the log files? Thanks, Eliza -

Re: [Virtuoso-users] create procedure in bash shell

2015-04-07 Thread Gang Fu
Thank you very much, Morty and Hugh! I just found out that the isql command line has two mode: file mode and command line mode: isql dba dba isql dba dba exec="" Best, Gang B On Tue, Apr 7, 2015 at 10:14 PM, Hugh Williams wrote: > Hi Gang, > > You could also place the procedure to b

[Virtuoso-users] update/uninstall virtuoso

2015-04-07 Thread Balazs Varhegyi
Hi, How can I uninstall and/or update virtuoso? We had a version 7.1 with a bug that was fixed in 7.2. I would like to update to the new version. Previous virtuoso installation was from source. I cloned the new version and compiled (I used the same for 7.1): "CFLAGS="-O2 -m64" export CFLAGS

Re: [Virtuoso-users] Unable to bulk load nquads in Virtuoso

2015-04-07 Thread Hugh Williams
Hi Maria, What do you mean by “virtuoso halts” ? What is the size of the “Dbpedia.nq” file ? Are you able to make another isql connection to the database and run the “status();” command ? What does the Linux “top” command report as to the resources being consumed by the process ? Best Regard

[Virtuoso-users] update/install virtuoso

2015-04-07 Thread Balazs Varhegyi
Hi all, How can I uninstall and/or update virtuoso? We had a version 7.1 with a bug that was fixed in 7.2. I would like to update to the new version. Previous virtuoso installation was from source. I cloned the new version and compiled (I used the same for 7.1): "CFLAGS="-O2 -m64" export CFLA

Re: [Virtuoso-users] create procedure in bash shell

2015-04-07 Thread Hugh Williams
Hi Gang, You could also place the procedure to be loaded in a file (dump.sql) and use the “load” command to load it into the database: $ isql dba dba verbose=on banner=off prompt=off echo=ON errors=stdout exec='load dump.sql' Connected to OpenLink Virtuoso Driver: 07.10.3211 OpenLink Virtu

[Virtuoso-users] Unable to bulk load nquads in Virtuoso

2015-04-07 Thread Maria Jackson
*I am trying to bulk load dbpedia.nq in Virtuoso using the following command:* *$ ./isql dba dba* Connected to OpenLink Virtuoso Driver: 07.20.3212 OpenLink Virtuoso ODBC Driver OpenLink Interactive SQL (Virtuoso), version 0.9849b. Type HELP; for help and EXIT; to exit. SQL> DB.DBA.TTLP_MT (f

Re: [Virtuoso-users] create procedure in bash shell

2015-04-07 Thread Morty
On Tue, Apr 07, 2015 at 04:36:39PM -0400, Gang Fu wrote: > In the bash shell, we need to take care of single quote by converting ' to > '"'"'. Gang -- You can avoid some issues and debug more easily by using isql's run file syntax. temp_file=`mktemp /somedir/tmpX` $command_to_generate_proce

Re: [Virtuoso-users] create procedure in bash shell

2015-04-07 Thread Gang Fu
I double-checked the error message and found the plus sign '+' is missing in the error message: file_len := file_len ses_len; Do we need to escape plus sign in shell script? Any comment? On Tue, Apr 7, 2015 at 4:36 PM, Gang Fu wrote: > Hi, > > In our application, we want to create many diffe

[Virtuoso-users] create procedure in bash shell

2015-04-07 Thread Gang Fu
Hi, In our application, we want to create many different dump functions to dump different subset of triple collections from database. According to the wiki page: http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtRDFDatasetDump we can define dump one graph function in isql command li

Re: [Virtuoso-users] SPARQL query size limits (GET, POST, POST DIRECT)

2015-04-07 Thread Jörn Hees
Hi, On 7 Apr 2015, at 01:48, Hugh Williams wrote: > 10K is the maximum limit, see the following post: > > http://boards.openlinksw.com/phpBB3/viewtopic.php?f=12&t=1377#p4422 in that thread you mention a 10 K limit (of bytes i assume) for GET. What are the limits for POST and POST DIRECT