I've run out of ideas to successfully restore dbpedia to a local test server, and would love any help on this. A restore to 5.0.10 encounters an error when it installs the dbpedia package:
15:01:31 OpenLink Virtuoso Universal Server 15:01:31 Version 05.10.3037-pthreads for Linux as of Mar 19 2009 15:01:31 uses parts of OpenSSL, PCRE, Html Tidy 15:01:31 Database version 3016 15:01:33 SQL Optimizer enabled (max 1000 layouts) 15:01:35 Compiler unit is timed at 0.000866 msec 15:02:01 PL LOG: Upgrading INFORMATION SCHEMA 15:02:02 Roll forward started 15:02:02 Roll forward complete 15:05:32 PL LOG: Installing Virtuoso Conductor version 1.00.7526 (DAV) 15:05:33 Checkpoint made, log reused 15:06:23 Checkpoint made, log reused 15:06:24 PL LOG: Installing iSPARQL version 1.19.32 (DAV) 15:06:25 Checkpoint made, log reused 15:06:34 Checkpoint made, log reused 15:06:35 PL LOG: Installing DBpedia version 1.1.75 (DAV) 15:06:36 Checkpoint made, log reused 15:06:37 PL LOG: SR185: Undefined procedure DB.DBA.REPL_GETDATE. 15:06:37 PL LOG: SR185: Undefined procedure DB.DBA.REPL_GETDATE. while executing the following statement: --no_c_escapes- upload_isparql () in file: /DAV/VAD/dbpedia/dbpedia_init.sql 15:06:51 PL LOG: Errors where detected during installation of "DBpedia". 15:06:51 PL LOG: The installation of this VAD package has failed. 15:06:51 PL LOG: Please delete the transaction file 15:06:51 PL LOG: /usr/local/virtuoso-opensource/var/lib/virtuoso/db/virtuoso.trx 15:06:51 PL LOG: and then restart your database server. 15:06:51 PL LOG: Note: Your database will be in its pre VAD installation 15:06:51 PL LOG: state after you restart. Deleting the transaction file and reloading gives the same error. In documentation, the dbpedia package is installed after loading the database, so I tried removing it from the VAD directory to prevent it from being installed automatically. In this case the server runs, but the packages stored in DAV are corrupted (including conductor). Loading the conductor web page displays: Error 42000 DA010: Can't store the file '/DAV/VAD/conductor/main_tabs. > > vspx-m': DAV error -29 Same thing happens if I install the ODS Framework and open it. I spent some time searching on this error with no luck (although a google search shows a few virtuoso instances with this bug out in the wild). While looking for solutions to this problem I came across an undocumented ini configuration setting "EnabledDAVVSP". Changing this didn't seem to help. Other things that I tried: - Installing the dbpedia VAD packages via iSQL after the server is running is also failing with the same error. - I tried loading dbpedia into VOS 5.0.9 but the database wouldn't load at all. - Attempting vad_uninstall on packages is giving an error (undefined procedure DB.DBA.REPL_GETDATE). Thanks in advance. -Steve On Thu, Mar 26, 2009 at 8:04 PM, Steve Judkins <steve.judk...@gmail.com>wrote: > Your suggestion helped catch a documentation bug. I had copied the SPARQL > endpoint settings from the Safeguarding your SPARQL endpoint > documentation<http://virtuoso.openlinksw.com/wiki/main/Main/VirtEC2AMIDBpediaInstall#Safeguarding%20Your%20SPARQL%20End-point>. > The DeferInferenceRulesInit = 0 in the cut and paste section, even though it > mentions setting it to 1 in the text below. > > Correcting this got me a little further along. Apparently the main problem > is when restoring the database there are incompatibilities between the > compiled VOS VAD files in {virtuoso}/share/virtuoso/vad/ and those of the > restored database DAV/VAD. Loading the database on a fresh build installs > the Conductor (see attached log). When opening the web page for the > conductor an error is displayed: > Error 42000 DA010: Can't store the file > '/DAV/VAD/conductor/main_tabs.vspx-m': DAV error -29 > > My next option is to update the VAD packages via isql to see if this > resolves things. > > -Steve > > On Wed, Mar 25, 2009 at 7:28 PM, Kingsley Idehen > <kide...@openlinksw.com>wrote: > >> >> Steve, >> >> Do you have the following re. INI. >> >> [SPARQL] >> . >> DeferInferenceRulesInit = 1 ; controls inference rules loading >> >> >> I suggest you start up (first time) using: >> >> virtuoso -c <INI> -f >> >> >> >> >> >> -- >> >> >> Regards, >> >> Kingsley Idehen Weblog: >> http://www.openlinksw.com/blog/~kidehen<http://www.openlinksw.com/blog/%7Ekidehen> >> President & CEO OpenLink Software Web: http://www.openlinksw.com >> >> >> >> >> >
