Hi Thomas, That won’t work as the +backup-dump is not compatible even between 6.x engine numbers which are thus included in the trx file to indicate this should you attempt to restore / replay with a different database engine number hence the error you indicating the server version don’t match.
So you have to perform the upgrade by copying the database as is and starting
with a v7 binary and then convert the RDF_QUAD table to Column Store mode as
indicated at:
http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/UpgradingToVOS610#Upgrading%20from%20Release%206.x%20to%20Release%207.x
<http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/UpgradingToVOS610#Upgrading
from Release 6.x to Release 7.x>
If you just have RDF Datasets then you could also dump them to file datasets in
nquad form and then reloading into an empty/virtuoso v7 database as detailed at:
http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtRDFDumpNQuad
<http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtRDFDumpNQuad>
Then reload with the Virtuoso RDF Bulk loader into the empty v7 database:
http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtBulkRDFLoader
<http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtBulkRDFLoader>
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 4 Dec 2015, at 08:46, Thomas Michaux <[email protected]> wrote:
>
> Hello,
>
> I have a problem trying to build a new .db in Virtuoso 7 from a dump of
> Virtuoso 6 (i.e. we do not want to just copy virtuoso.db to have
> benefits of Column Store mode) :
>
> The dump is built from Virtuoso Open Source Edition (multi threaded)
> Version 6.1.6.3127-pthreads as of Oct 19 2012
> Compiled for Linux (x86_64-unknown-linux-gnu)
> Copyright (C) 1998-2012 OpenLink Software
>
> after a checkpoint; shutdown; and /usr/local/bin/virtuoso-t +configfile
> /usr/local/var/lib/virtuoso/db/virtuoso.ini +backup-dump
>
> Then we are trying to read this dump transaction file on another host
> with Virtuoso Open Source Edition (Column Store) (multi threaded)
> Version 7.2.2-rc1.3215-pthreads as of Nov 23 2015
> Compiled for Linux (x86_64-unknown-linux-gnu)
> Copyright (C) 1998-2015 OpenLink Software
>
> with ./virtuoso-t +configfile
> /usr/local/virtuoso-opensource/var/lib/virtuoso/db/virtuoso.ini
> +restore-crash-dump +foreground
>
> but...
> 19:11:18 Roll forward started
> 19:11:18 The transaction log file has been produced by server version
> '06.01.3127'. The version of this server is '07.20.3215'. If the
> transaction log is empty or you do not want to replay it then delete it
> and start the server again. Otherwise replay the log using the server of
> version '06.01.3127' and make checkpoint and shutdown to ensure that the
> log is empty, then delete it and start using new version.
> 19:11:18 Server exiting
>
>
> Any advices ?
>
> Thanks,
>
> Thomas Michaux
>
>
>
>
>
>
> ------------------------------------------------------------------------------
> Go from Idea to Many App Stores Faster with Intel(R) XDK
> Give your users amazing mobile app experiences with Intel(R) XDK.
> Use one codebase in this all-in-one HTML5 development environment.
> Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
> http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140
> _______________________________________________
> Virtuoso-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------ Go from Idea to Many App Stores Faster with Intel(R) XDK Give your users amazing mobile app experiences with Intel(R) XDK. Use one codebase in this all-in-one HTML5 development environment. Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs. http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140
_______________________________________________ Virtuoso-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/virtuoso-users
