Important precision,
we have focused this problems on a specific type of literals :
Je dois préciser que le pb concerne des données de type Littéraux XML
(http://www.w3.org/TR/REC-rdf-syntax/#section-Syntax-XML-literals) :
<http://www.hub.abes.fr/springerB/ebook/1-85233-134-8/chapter/9/w>
<http://purl.org/dc/terms/title> "Variants of nonlinear normal form observer
design"^^<http://www.w3.org/1999/02/22-rdf-syntax-ns#XMLLiteral> .
Le 08/12/2015 10:39, Thomas Michaux a écrit :
Hello,
Thanks Hugh,
we performed as explained in
http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/UpgradingToVOS610#Upgrading%20from%20Release%206.x%20to%20Release%207.x
( convert the RDF_QUAD table to Column Store )
and it worked... except now we have pbs on datas (which was correct in
V6), for exemple :
select ?titre from
<http://www.hub.abes.fr/springer/ebooksLN2011/SPR_EBOOK_642_19NOV>
where {?s dcterms:title ?titre}
return in SPARQL query results of the conductor interface in V6 :
titre
Variants of nonlinear normal form observer design
Input/State linearization
On achieving Lp (ℓp) performance with global internal stability for
linear plants with saturating actuators
Design criteria for uncertain models with structured and unstructured
uncertainties
Sliding mode control of systems with delayed states and controls
On global stabilization of nonlinear dynamical systems
On sampled data variable structure control systems
Stochastic optimal control problems
Modeling, Estimation, and Their Applications for Distributed Parameter
Systems
Optimal input design
...
the same SPARQL query on V7 now returns in the conductor :
titre
"???� rootbVariants of nonlinear normal form observer design"
"???� root2Input/State linearization"
"???� root??On achieving Lp (ℓp) performance with global internal
stability for linear plants with saturating actuators"
"???� root??Design criteria for uncertain models with structured and
unstructured uncertainties"
"???� root??Sliding mode control of systems with delayed states and
controls"
"???� rootlOn global stabilization of nonlinear dynamical systems"
"???� rootdOn sampled data variable structure control systems"
"???� rootFStochastic optimal control problems"
"Modeling, Estimation, and Their Applications for Distributed
Parameter Systems"
"???� root(Optimal input design"
...
Also tried directly SPARQL query in isql client and same divergences,
(so it's excluding presentation problems in the conductor i suppose)
see attached screenshots.
Do you think the faulty part resides in the reindexing process or in
the driver accessing the datas in V7 ?
Thanks,
Thomas Michaux.
PS: I'm planning a test to see the datas from V6 into V7 (just copying
virtusoso.db) without converting to column store indexes.
Le 05/12/2015 03:22, Hugh Williams a écrit :
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
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
Then reload with the Virtuoso RDF Bulk loader into the empty v7 database:
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 <mich...@abes.fr> 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
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
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
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
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
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users