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. When exploring this option I
found that when we even 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 procedure to recover 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.
I am novice user of Virtuoso, I just joined the project so I am not sure if
I am doing something incorrectly.
Thanks,
Bharath
------------------------------------------------------------------------------
Shape the Mobile Experience: Free Subscription
Software experts and developers: Be at the forefront of tech innovation.
Intel(R) Software Adrenaline delivers strategic insight and game-changing
conversations that shape the rapidly evolving mobile landscape. Sign up now.
http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
