Hi Sarah,
What data do you have in the database that it needed, as if you want to start
again with an empty database you can simply shutdown the database and remove
the “virtuoso.db” and “virtuoso.trx” files in the “db” directory and restart it.
What are you seeking to use Virtuoso for ? There are many HowTo guides of
common use cases and tasks user perform with Virtuoso detailed at:
http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/#How%20Do%20I...
With regards to the “sparql_demo” DAWG testsuite will have to check that as I
do not a number of errors loading the "rdf-exp.sql” script ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
Weblog -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter -- http://twitter.com/OpenLink
Google+ -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers
> On 6 Jan 2015, at 17:23, Sarah Weissman <sweiss...@stsci.edu> wrote:
>
> Hi,
>
> I am new to Virtuoso. I recently downloaded the open source version and
> installed it and was trying to find instructions on how to set it up as a
> sparql endpoint (including loading data). I tried to load the sparql_demo_dav
> package as found here:
>
> http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VOSDownload
>
> But the tutorial appears to be broken and refers to “folder trees” that don’t
> exist. (See the DAWG test cases link here:
> http://demo.openlinksw.com/sparql_demo/#.)
>
> So I tried to load some data manually following the instructions from this
> page:
> http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VOSSPARQLDemo and
> it seems that I have completely broken my databases. The conductor console
> wouldn’t let me uninstall the demo (or do anything really) because of some
> missing DB table, so I decided to restart and now I can’t even start the
> server (see log below).
>
> Now I am wondering:
> Is there a way to unhose my installation without completely starting over?
> Is there a working sparql demo or a very simple guide to how databases are
> managed in Virtuoso, either through the command line or the conductor console?
>
> Thanks,
> Sarah
>
>
> blanc:db sweissman$ virtuoso-t -f &
> [1] 41534
> blanc:db sweissman$
> Tue Jan 06 2015
> 12:01:37 { Loading plugin 1: Type `plain', file `wikiv' in
> `/usr/local/lib/virtuoso/hosting'
> 12:01:37 FAILED plugin 1: Unable to locate file }
> 12:01:37 { Loading plugin 2: Type `plain', file `mediawiki' in
> `/usr/local/lib/virtuoso/hosting'
> 12:01:37 FAILED plugin 2: Unable to locate file }
> 12:01:37 { Loading plugin 3: Type `plain', file `creolewiki' in
> `/usr/local/lib/virtuoso/hosting'
> 12:01:37 FAILED plugin 3: Unable to locate file }
> 12:01:37 { Loading plugin 4: Type `plain', file `im' in
> `/usr/local/lib/virtuoso/hosting'
> 12:01:37 IM version 0.6 from OpenLink Software
> 12:01:37 Support functions for Image Magick 6.8.8
> 12:01:37 SUCCESS plugin 4: loaded from
> /usr/local/lib/virtuoso/hosting/im.so }
> 12:01:37 OpenLink Virtuoso Universal Server
> 12:01:37 Version 07.10.3211-pthreads for Darwin as of Jan 5 2015
> 12:01:37 uses parts of OpenSSL, PCRE, Html Tidy
> 12:01:37 Database version 3126
> 12:01:37 SQL Optimizer enabled (max 1000 layouts)
>
> blanc:db sweissman$ 12:01:38 Compiler unit is timed at 0.000134 msec
> 12:01:39 built-in procedure "repl_undot_name" overruled by the RDBMS
> 12:01:39 Roll forward started
> 12:01:39 Key without parts RO_VAL.
> 12:01:39 Key without parts DB_DBA_RDF_DATATYPE_UNQC_RDT_TWOBYTE.
> 12:01:39 Key without parts DB_DBA_RDF_DATATYPE_UNQC_RDT_QNAME.
> 12:01:39 Key without parts DB_DBA_RDF_LANGUAGE_UNQC_RL_TWOBYTE.
> 12:01:39 Key without parts RO_VAL.
> 12:01:39 Key without parts DB_DBA_RDF_LANGUAGE_UNQC_RL_TWOBYTE.
> 12:01:39 SQL Error: 23000 : SR175: Uniqueness violation : Violating unique
> index SYS_KEYS on table DB.DBA.SYS_KEYS. Transaction killed.
> 12:01:39 In roll forward batch commit failed code 5
> 12:01:39 Rfwd error: 23000: SR175: Uniqueness violation : Violating unique
> index SYS_KEYS on table DB.DBA.SYS_KEYS. Transaction killed.
> 12:01:39 SQL Error: 23000 : SR175: Uniqueness violation : Violating unique
> index SYS_KEYS on table DB.DBA.SYS_KEYS. Transaction killed.
> 12:01:39 SQL Error: 37000 : SQ074: Line 1: syntax error at ')' before 'select'
> 12:01:39 SQL Error: 23000 : SR175: Uniqueness violation : Violating unique
> index SYS_KEYS on table DB.DBA.SYS_KEYS. Transaction killed.
> 12:01:39 In roll forward batch commit failed code 5
> 12:01:39 Rfwd error: 23000: SR175: Uniqueness violation : Violating unique
> index SYS_KEYS on table DB.DBA.SYS_KEYS. Transaction killed.
> 12:01:39 SQL Error: 23000 : SR175: Uniqueness violation : Violating unique
> index SYS_KEYS on table DB.DBA.SYS_KEYS. Transaction killed.
> 12:01:39 SQL Error: 37000 : SQ074: Line 1: syntax error at ')' before 'select'
> 12:01:39 Server received signal 11. Continuing with the default action for
> that signal.
>
> ------------------------------------------------------------------------------
> Dive into the World of Parallel Programming! The Go Parallel Website,
> sponsored by Intel and developed in partnership with Slashdot Media, is your
> hub for all things parallel software development, from weekly thought
> leadership blogs to news, videos, case studies, tutorials and more. Take a
> look and join the conversation now.
> http://goparallel.sourceforge.net_______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
Dive into the World of Parallel Programming! The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
