I am exploring the possibility of upgrading from Virtuoso 6.1.6 to Virtuoso
7.0.0 in our project. We use full text index. I am novice user of Virtuoso,
I just joined the project so I am not sure if I am doing something
incorrectly. When exploring this option I found that when we create the
full text index we encounter an error when trying to use Virtuoso 7.0.0
To isolate the issue I just used empty db which isnt populated and issued
these commands from isql connecting to the Virtuoso 7.0.0.
Command line to start virtuoso:
/opt/virtuoso-7.0.0/bin/virtuoso-iodbc-t +foreground +wait +debug
+configfile /home/bharath/test/virtuoso/virtuoso7.ini
Here is the output from Virtuoso console:
Wed Nov 06 2013
11:39:13 INFO: OpenLink Virtuoso Universal Server
11:39:13 INFO: Version 07.00.3203-pthreads for Linux as of Nov 5 2013
11:39:13 INFO: uses parts of OpenSSL, PCRE, Html Tidy
11:39:14 INFO: Entering Lite Mode
11:39:14 INFO: SQL Optimizer enabled (max 1024 layouts)
11:39:15 INFO: Compiler unit is timed at 0.000838 msec
11:39:16 INFO: Checkpoint started
11:39:16 INFO: Roll forward started
11:39:16 INFO: Roll forward complete
11:39:16 INFO: Checkpoint started
11:39:16 INFO: Checkpoint finished, log reused
11:39:16 INFO: Checkpoint started
11:39:16 INFO: Checkpoint finished, log reused
11:39:16 INFO: Checkpoint started
11:39:16 INFO: Checkpoint finished, log reused
11:39:16 INFO: Server online at 127.0.0.1:8598 (pid 22452)
11:39:26 INFO: ERRS_0 22023 SR008 Function sprintf needs an integer as
argument 2, not an arg of type VARCHAR (182)
The command we use to create the full text index is as follows which I load
as test.sql:
DB.DBA.RDF_OBJ_FT_RULE_ADD (null, null, 'All');
DB.DBA.VT_BATCH_UPDATE ('DB.DBA.RDF_OBJ', 'OFF', null);
DB.DBA.VT_INC_INDEX_DB_DBA_RDF_OBJ ();
DB.DBA.RDF_OBJ_FT_RECOVER ();
Once issue the call to "DB.DBA.RDF_OBJ_FT_RECOVER ()" to enable recover
after any crashes I get the following error:
Temporary drop of rule "All" for graph <> predicate <>...
... done
Restoring rule "All" for graph <> predicate <>...
... done
*** Error 22023: [Virtuoso Driver][Virtuoso Server]SR008: Function sprintf
needs an integer as argument 2, not an arg of type VARCHAR (182)
in
sprintf:(BIF),
DB.DBA.RDF_OBJ_FT_RECOVER,
<Top Level>
at line 4 of load test.sql
:
DB.DBA.RDF_OBJ_FT_RECOVER ()
I am wondering if we are doing anything incorrectly or is this a bug. On
some of other tests we have notice significant performance improvements
using Virtuoso 7 and would like to upgrade to it. Any help with resolving
this issue is greatly appreciated.
Thanks,
Bharath
------------------------------------------------------------------------------
November Webinars for C, C++, Fortran Developers
Accelerate application performance with scalable programming models. Explore
techniques for threading, error checking, porting, and tuning. Get the most
from the latest Intel processors and coprocessors. See abstracts and register
http://pubads.g.doubleclick.net/gampad/clk?id=60136231&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
