Hi Hugh,
thanks for looking into it, for the moment I think I'll rather start
over loading DBpedia stuff into a fresh DB than going through a
recovery, as I don't have any meaningful data to recover (by the moment
just a test DB). I would be pleased however to know the causes of that
problem though when (if) you find it, as we are considering the
possibility of using Virtuoso in production as our triple-store.
Regards,
Alex
Hugh Williams, 06-10-2010 01:54:
Hi Alex,
We are looking into possible causes of this. In the meantime you could consider
either restoring an backup if you have setup regular online backups or perform
a crash dump and restore of the database as detailed at:
http://docs.openlinksw.com/virtuoso/backup.html#vdbrecovery
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 4 Oct 2010, at 10:35, Alex Rodriguez Lopez wrote:
Hi all!
Today I tried to start VOS instance I have around for testing a local
DBpedia that so far gave little problems and found I can't get virtuoso
to run. I already erased transaction files and so on but the problem
persists. The relevant part of virtuoso.log follows:
...friday...
15:57:43 Server shutdown complete
Mon Oct 04 2010
09:44:19 { Loading plugin 1: Type `plain', file `wikiv' in
`/usr/lib/virtuoso/hosting'
09:44:19 WikiV version 0.6 from OpenLink Software
09:44:19 Support functions for WikiV collaboration tool
09:44:19 SUCCESS plugin 1: loaded from
/usr/lib/virtuoso/hosting/wikiv.so }
09:44:19 { Loading plugin 2: Type `plain', file `mediawiki' in
`/usr/lib/virtuoso/hosting'
09:44:19 MediaWiki version 0.1 from OpenLink Software
09:44:19 Support functions for MediaWiki collaboration tool
09:44:19 SUCCESS plugin 2: loaded from
/usr/lib/virtuoso/hosting/mediawiki.so }
09:44:19 { Loading plugin 3: Type `plain', file `creolewiki' in
`/usr/lib/virtuoso/hosting'
09:44:19 CreoleWiki version 0.1 from OpenLink Software
09:44:19 Support functions for CreoleWiki collaboration tool
09:44:19 SUCCESS plugin 3: loaded from
/usr/lib/virtuoso/hosting/creolewiki.so }
09:44:19 OpenLink Virtuoso Universal Server
09:44:19 Version 06.01.3127-pthreads for Linux as of Sep 22 2010
09:44:19 uses parts of OpenSSL, PCRE, Html Tidy
09:44:20 Database version 3126
09:44:20 SQL Optimizer enabled (max 1000 layouts)
09:44:22 Compiler unit is timed at 0.001163 msec
09:44:29 GPF: page.c:119 row length out of range
Mon Oct 04 2010
09:57:02 { Loading plugin 1: Type `plain', file `wikiv' in
`/usr/lib/virtuoso/hosting'
09:57:02 WikiV version 0.6 from OpenLink Software
09:57:02 Support functions for WikiV collaboration tool
09:57:02 SUCCESS plugin 1: loaded from
/usr/lib/virtuoso/hosting/wikiv.so }
09:57:02 { Loading plugin 2: Type `plain', file `mediawiki' in
`/usr/lib/virtuoso/hosting'
09:57:02 MediaWiki version 0.1 from OpenLink Software
09:57:02 Support functions for MediaWiki collaboration tool
09:57:02 SUCCESS plugin 2: loaded from
/usr/lib/virtuoso/hosting/mediawiki.so }
09:57:02 { Loading plugin 3: Type `plain', file `creolewiki' in
`/usr/lib/virtuoso/hosting'
09:57:02 CreoleWiki version 0.1 from OpenLink Software
09:57:02 Support functions for CreoleWiki collaboration tool
09:57:02 SUCCESS plugin 3: loaded from
/usr/lib/virtuoso/hosting/creolewiki.so }
09:57:02 OpenLink Virtuoso Universal Server
09:57:02 Version 06.01.3127-pthreads for Linux as of Sep 22 2010
09:57:02 uses parts of OpenSSL, PCRE, Html Tidy
09:57:03 Database version 3126
09:57:03 SQL Optimizer enabled (max 1000 layouts)
09:57:05 Compiler unit is timed at 0.001165 msec
09:57:05 row with bad kv in RDF_QUAD
09:57:05 GPF: page.c:110 key with bad key version
After that, succesive attemps to start virtuoso all end with
GPF: page.c:119 row length out of range
I figure out that since this is for the moment a test db I am doing
things with little care, like messing with indexes, installing VADs and
performing queries all at the same time, and the db still trying to make
checkpoints every now and then, which I think I don't need at all by the
moment because it's loaded once with DBpedia dumps and nothing more to
be added later (or little controled dumps, not several concurrent
writes). How do I dissable completely backup/checkpoints? I think it's
more important for me at this moment to be prepared for eventual crashes
and unexpected closings and shutdowns (that are to be expected while
still testing and learning how to manage this) and being able to go on
with testing on an usable db, that to worry about saving the latest
changes to db because after all it doesn't change that much now...
Any help about recovering this greatly appreciated, not that it would be
too much to start over with a fresh db and put dbpedia again but I would
like to save the day-and-a-half or so that it takes to load all the
thing again!
Alex
------------------------------------------------------------------------------
Virtualization is moving to the mainstream and overtaking non-virtualized
environment for deploying applications. Does it make network security
easier or more difficult to achieve? Read this whitepaper to separate the
two and get a better understanding.
http://p.sf.net/sfu/hp-phase2-d2d
_______________________________________________
Virtuoso-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
