Thanks for your quick response!
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.
I removed those files and now I can start the server. Hooray!
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...
Somehow I didn’t notice those How Tos, and my searching didn’t lead me to those
pages. That looks like the information I wanted. To my credit, the links on the
Virtuoso welcome page when you load up the server do not lead to this
documentation, but to a much less useful set of documentation here:
http://docs.openlinksw.com/virtuoso/. Maybe this should be changed?
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<mailto: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<mailto: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
